INSERT INTO `death` (`state`, `hospital`, `govten`, `govtlocal`, `dept`, `deptlocal`, `hospitalname`, `hospitalnamelocal`, `birthlanglocal`, `line1local`, `line1`, `line2local`, `line2`, `namelocal`, `genderlocal`, `doblocal`, `poblocal`, `mnamelocal`, `fnamelocal`, `birthaddresslocal`, `permanentaddresslocal`, `regnolocal`, `regdatelocal`, `remarkslocal`, `doilocal`, `ialocal`, `registrarlocal`, `registrar`, `reghospitallocal`, `reghospital`, `lastlinelocal`, `aadharlocal`, `topleftlocal`, `toprightlocal`, `signimage`, `stampimage`, `topleftimage`, `toprightimage`, `signimagetype`, `stampimagetype`, `topleftimagetype`, `toprightimagetype`, `username`, `hwname`, `hwaadhar`, `age`) VALUES
('Uttar Pradesh', 'SUB CENTRE MISRIKH', 'GOVERNMENT OF UTTAR PRADESH', 'उत्तर प्रदेश सरकार', 'DEPARTMENT OF MEDICAL AND HEALTH', 'चिकित्सा एवं स्वास्थ्य विभाग', 'SUB CENTRE MISRIKH', 'उप स्वास्थ्य केंद्र मिश्रिख', 'मृत्यु प्रमाण-पत्र', '(जन्म मृत्यु रजिस्ट्रीकरण अधिनियम, 1969 की धारा 12/17 तथा उत्तर प्रदेश जन्म मृत्यु रजिस्ट्रीकरण नियम, 2002 के नियम 8/13 के अंतर्गत जारी किया गया )', '(ISSUED UNDER SECTION 12/17 OF THE REGISTRATION OF BIRTHS & DEATHS ACT, 1969 AND RULE 8 / 13 OF THE UTTAR PRADESH REGISTRATION  OF BIRTHS & DEATHS RULES 2002)', 'यह प्रमाणित किया जाता है निम्नलिखित सुचना मृत्यु के मूल अभिलेख से ली गई है जो कि उप स्वास्थ्य केंद्र मिश्रिख तहसील मिसरिख जिला सीतापुर राज्य/संघ प्रदेश उत्तर प्रदेश, भारत के रजिस्टर में उल्लिखित है ।', 'THIS IS TO CERTIFY THAT THE FOLLOWING INFORMATION HAS BEEN TAKEN FROM THE ORIGINAL RECORD OF DEATHS WHICH IS THE REGISTER FOR SUB CENTRE MISRIKH OF TAHSIL/BLOCK MISRIKH OF DISTRICT SITAPUR OF STATE/UNION TERRITORY UTTAR PRADESH, INDIA.', 'नाम', 'लिंग', 'मृत्यु की तिथि', 'मृत्यु का स्थान', 'माता का नाम', 'पिता का नाम', 'मृत्यु के समय मृतक का पता', 'मृतक का स्थायी पत्ता', 'पंजीकरण संख्या', 'पंजीकरण तारीख', 'टिप्पणी', 'जारी करने की तिथि', 'जारी करने वाला प्राधिकारी', 'रजिस्ट्रार (जन्म एवं मृत्यु)', 'REGISTRAR (BIRTH & DEATH)', 'उप स्वास्थ्य केंद्र मिश्रिख', 'SUB CENTRE MISRIKH', 'प्रत्येक जन्म एवं मृत्यु का पंजीकरण सुनिश्चत करें', 'आधार नंबर', 'सं. 1', 'प्रपत्र-6', 0x[BLOB], 0x[BLOB], 0x[BLOB], 0x[BLOB], 'image/jpeg', 'image/jpeg', 'image/jpeg', 'image/png', 'ADMIN', 'पति/पत्नी का नाम', 'आधार नंबर', 'मृतक की उम्र');
INSERT INTO `death` (`state`, `hospital`, `govten`, `govtlocal`, `dept`, `deptlocal`, `hospitalname`, `hospitalnamelocal`, `birthlanglocal`, `line1local`, `line1`, `line2local`, `line2`, `namelocal`, `genderlocal`, `doblocal`, `poblocal`, `mnamelocal`, `fnamelocal`, `birthaddresslocal`, `permanentaddresslocal`, `regnolocal`, `regdatelocal`, `remarkslocal`, `doilocal`, `ialocal`, `registrarlocal`, `registrar`, `reghospitallocal`, `reghospital`, `lastlinelocal`, `aadharlocal`, `topleftlocal`, `toprightlocal`, `signimage`, `stampimage`, `topleftimage`, `toprightimage`, `signimagetype`, `stampimagetype`, `topleftimagetype`, `toprightimagetype`, `username`, `hwname`, `hwaadhar`, `age`) VALUES
('Uttar Pradesh', 'SVBP HOSPITAL AND MEDICAL COLLEGE MEERUT', 'GOVERNMENT OF UTTAR PRADESH', 'उत्तर प्रदेश सरकार', 'DEPARTMENT OF MEDICAL AND HEALTIT', 'चिकित्सा एवं स्वास्थ्य विभाग', 'SVBP HOSPITAL AND MEDICAL COLLEGE MEERUT', 'एस वी बी पी हास्पिटल & मेडिकल कॉलेज मेरठ', 'मृत्यु प्रमाण-पत्र', '(जन्म मृत्यु रजिस्ट्रीकरण अधिनियम, 1969 की धारा 12 / 17 तथा उत्तर प्रदेश जन्म मृत्यु रजिस्ट्रीकरण नियम 2012 के नियम 8/13 के अंतर्गत जारी किया गया।', '(ISSUED UNDER SECTION 12/17 OF THE REGISTRATION OF BIRTHS & DEATHS ACT, 1969 AND RULE 8/13 OF THE UTTAR PRADESH REGISTRATION OF BIRTHS & DEATHS RULES 2002.)', 'यह प्रमाणित किया जाता है निम्नलिखित सूचना मृत्यु के मूल अभिलेख से ली गई है जो कि एस वी बी पी हास्पिटल & मेडिकल कॉलेज मेरठ तहसील मेरठ जिला मेरठ राज्य संघ प्रदेश उत्तर प्रदेश भारत के रजिस्टर में उल्लिखित है।', 'THIS IS TO CERTIFY THAT THE FOLLOWING INFORMATION HAS BEEN TAKEN FROM THE ORIGINAL RECORD OF DEATH WHICH IS THE REGISTER FOR SYBP HOSPITAL AND MEDICAL COLLEGE MEERUT OF TAHSIL/BLOCK MEERUT OF DISTRICT MEERUT OF STATE/UNION TERRITORY UTTAR PRADESH, INDIA', 'मृतक का नाम', 'लिंग', 'मृत्यु की तिथि', 'मृत्यु का स्थान', 'माता का नाम', 'पिता का नाम', 'मृत्यु के समय मृतक का पता', 'मृतक का स्थायी पता', 'पंजीकरण संख्या', 'पंजीकरण तारीख', 'टिप्पणी', 'जारी करने की तिथि', 'जारी करने वाला प्राधिकारी', 'रजिस्ट्रार (जन्म एवं मृत्यु)', 'REGISTRAR (BIRTH & DEATH)', 'एस वी बी पी हास्पिटल & मेडिकल कॉलेज मेरठ', 'SVBP HOSPITAL AND MEDICAL COLLEGE MEERUT', 'प्रत्येक जन्म एवं मृत्यु का पंजीकरण  सुनिश्चित करे', 'आधार नंबर', 'सं. 1', 'प्रपत्र-6', 0x[BLOB], 0x[BLOB], 0x[BLOB], 0x[BLOB], 'image/jpeg', 'image/jpeg', 'image/jpeg', 'image/png', 'ADMIN', 'पति/पत्नी का नाम', 'आधार नंबर', 'मृतक की उम्र');

-- --------------------------------------------------------

--
-- Table structure for table `deathmanual`
--

CREATE TABLE `deathmanual` (
  `id` int(11) NOT NULL,
  `name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `aadharno` varchar(14) NOT NULL,
  `dob` varchar(30) NOT NULL,
  `dobwords` varchar(256) NOT NULL,
  `placeofbirth` text NOT NULL,
  `mname` text NOT NULL,
  `maadhar` varchar(14) NOT NULL,
  `fname` text NOT NULL,
  `faadhar` varchar(15) NOT NULL,
  `birthaddress` varchar(250) NOT NULL,
  `permanentaddress` varchar(250) NOT NULL,
  `regno` varchar(50) NOT NULL,
  `dateofregister` varchar(20) NOT NULL,
  `dateofissue` varchar(20) NOT NULL,
  `updatedate` varchar(30) NOT NULL,
  `username` varchar(20) NOT NULL,
  `gender` varchar(30) NOT NULL,
  `state` text DEFAULT NULL,
  `hospital` varchar(400) DEFAULT NULL,
  `age` varchar(20) NOT NULL,
  `hwname` varchar(255) NOT NULL,
  `hwaadhar` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `deathmanual`
--

INSERT INTO `deathmanual` (`id`, `name`, `aadharno`, `dob`, `dobwords`, `placeofbirth`, `mname`, `maadhar`, `fname`, `faadhar`, `birthaddress`, `permanentaddress`, `regno`, `dateofregister`, `dateofissue`, `updatedate`, `username`, `gender`, `state`, `hospital`, `age`, `hwname`, `hwaadhar`) VALUES
(15, 'GANESH CHAUDHARI', '495598116349', '08-02-2022', '08/02/2022', 'MALAHI TOLA ', 'GAUDI DEVI', '0', 'VISHUN CHAUDHARI', '0', 'MALAHI TOLA POST KOIRPTTI THAKRAHA WEST CHAMPARAN BIHAR 845404', 'MALAHI TOLA POST KOIRPTTI THAKRAHA WEST CHAMPARAN BIHAR 845404', 'D-2023: 10-90347-003284', '27-02-2023', '27-02-23 03:44:58', '27-02-23 03:44:58', '8601887325', 'MALE', 'Bihar', 'SADAR HOSPITAL MUZAFFARPUR', '68', '0', '0'),
(16, '', '', '', '', '', '', '', '', '', '', '', 'D-2023: 10-90347-003954', '', '18-03-23 03:04:41', '18-03-23 03:04:41', '8252158526', 'Select Gender', 'Madhya Pradesh', 'COMMUNITY HEALTH CENTRE BURHAR', '', '', ''),
(17, 'VISHNU MANJHI', '381501912950', '20-08-2021', 'TWENTY AUGUST TWO THOUSAND TWENTY ONE', 'SADAR HOSPITAL GAYA  BIHAR', 'SUGANIYA DEVI', '', 'JAYMANGAL MANJHI ', '', 'VILL- POKHARPUR , PO- PAWAPURI , NALANDA , BIHAR , 803115', 'VILL- POKHARPUR , PO- PAWAPURI , NALANDA , BIHAR , 803115', 'D-2023: 10-90347-003282', '27-03-2023', '28-03-23 02:48:35', '28-03-23 02:48:35', '9113722857', 'MALE', 'Bihar', 'SADAR HOSPITAL GAYA', '', 'KARI DEVI', ''),
(18, 'Majahar Alam ', '992912992742', '22-12-2022', '', '', 'Johara Khatoon', '', 'Abdul Rashid', '', 'VILL+PO-PATILAR MAUJE TOLA ,PS-CHAUTARWA DISS-WEST CHAMPARAN BIHAR PIN CODE-845101', 'Vill+po-patilar mauje Tola ,ps-Chautarwa Diss-west Champaran bihar pin Code-845101', 'D-2023: 10-90347-008654', '10-01-2023', '30-03-23 12:09:33', '30-03-23 12:09:33', '1234', 'MALE', 'Bihar', 'SADAR HOSPITAL MUZAFFARPUR', '', 'Samina Khatoon', '433972804666'),
(19, 'liyakat ali sardar', '', '01-09-1990', '', 'VILL-KHODAR BAZAR P.O-BARUIPUR P.S-BARUIPUR SOUTH 24 PARGANAS W.B 700144', 'sahazadi bibi', '', 'mansur ali sardar', '', 'VILL-KHODAR BAZAR P.O-BARUIPUR P.S-BARUIPUR SOUTH 24 PARGANAS W.B 700144', 'VILL-KHODAR BAZAR  P.O-BARUIPUR P.S-BARUIPUR SOUTH 24 PARGANAS W.B 700144', 'D-2023: 10-90347-007695', '', '03-04-23 12:48:01', '03-04-23 12:48:01', '6296630225', 'MALE', 'West Bengal ', 'NRS MEDICAL COLLEGE AND HOSPITAL', '', '', ''),
(20, 'liyakat ali sardar', '', '', '', 'VILL-KHODAR BAZAR P.O-BARUIPUR P.S-BARUIPUR SOUTH 24 PARGANAS W.B 700144', 'sahazadi bibi', '', 'mansur ali sardar', '', 'VILL-KHODAR BAZAR P.O-BARUIPUR P.S-BARUIPUR SOUTH 24 PARGANAS W.B 700144', 'VILL-KHODAR BAZAR P.O-BARUIPUR P.S-BARUIPUR SOUTH 24 PARGANAS W.B 700144', 'D-2023: 10-90347-00691', '', '03-04-23 12:56:59', '03-04-23 12:56:59', '6296630225', 'MALE', 'West Bengal ', 'CALCUTTA NATIONAL MEDICAL COLLEGE AND HOSPITAL', '', '', ''),
(21, 'SHOMABHAI CHHAGANBHAI RATHOD', '', '05-04-2011', 'FIVE-APRIL-TWO THOUSAND ELEVEN', 'SURAT', 'KAMUBEN', '', 'CHHAGANBHAI', '', 'PADAR FALIYU, MOTO HALPATIVAS, KACHHOLI, CHORYASI, SURAT, 394235', 'PADAR FALIYU, MOTO HALPATIVAS, KACHHOLI, CHORYASI, SURAT, 394235', 'D-2023: 10-90347-004623', '30-04-2011', '06-04-23 10:14:55', '06-04-23 10:14:55', '9099740420', 'MALE', 'Gujarat', 'MUNICIPAL CORPORATION SURAT', '39', 'REVABEN', ''),
(22, 'samim aktar', '', '30-03-2023', '', 'gourhand', 'majeda bibi', '', 'entaj ali', '', 'GOURHAND,MALIKAN,CHANCHAL II,MALDA,WEST BENGAL 732123', 'gourhand,malikan,chanchal ii,malda,west bengal 732123', 'D-2023: 10-90347-005672', '14-04-2023', '16-04-23 12:05:35', '16-04-23 12:05:35', '9933604997', 'MALE', 'West Bengal ', 'NRS MEDICAL COLLEGE AND HOSPITAL', '35', 'mst mansura khatun', ''),
(23, 'SHOMABHAI CHHAGANBHAI RATHOD', '', '05-04-2011', 'FIVE-APRIL-TWO THOUSAND ELEVEN', 'surat', 'KAMUBEN', '', 'CHHAGANBHAI', '', 'PADAR FALIYU, MOTO HALPATIVAS, KACHHOLI, CHORYASI, SURAT, 394235', 'PADAR FALIYU, MOTO HALPATIVAS, KACHHOLI, CHORYASI, SURAT, 394235', 'D-2023: 10-90347-004262', '30-04-2011', '16-04-23 10:28:29', '16-04-23 10:28:29', '9099740420', 'MALE', 'Gujarat', 'MUNICIPAL CORPORATION SURAT	', '', 'REVABEN', ''),
(24, 'SHOMABHAI CHHAGANBHAI RATHOD', '', '05-04-2011', 'FIVE-APRIL-TWO THOUSAND ELEVEN', '', 'KAMUBEN', '', 'CHHAGANBHAI', '', 'PADAR FALIYU, MOTO HALPATIVAS, KACHHOLI, CHORYASI, SURAT, 394235', 'PADAR FALIYU, MOTO HALPATIVAS, KACHHOLI, CHORYASI, SURAT, 394235', 'D-2023: 10-90347-008944', '30-04-2011', '18-04-23 12:58:34', '18-04-23 12:58:34', '9099740420', 'MALE', 'Gujarat', 'MUNICIPAL CORPORATION SURAT	', '', 'REVABEN', ''),
(25, 'RAMPRAKASH', 'NOT', '01-01-1998', '', 'KODRI ', 'RAJDULARI', 'NOT', 'RADHE', 'NOT', 'VILLAGE KODRI POST MADAR SANDILA HARDOI UTTAR PRADESH', 'VILLAGE KODRI POST MADAR SANDILA HARDOI UTTAR PRADESH', 'D-2023: 10-90347-003262', '21-04-2023', '21-04-23 03:54:08', '21-04-23 03:54:08', '9877141256', 'MALE', 'Uttar Pradesh', 'COMMUNITY HEALTH CENTRE MALIHABAD OK', '', 'MITHLESH KUMARI', '319257071591'),
(26, '', '', '', '', '', '', '', '', '', '', '', 'D-2023: 10-90347-008058', '', '24-04-23 11:59:54', '24-04-23 11:59:54', '1234', 'Select Gender', 'Madhya Pradesh', 'COMMUNITY HEALTH CENTRE BURHAR', '', '', ''),
(27, 'subhawati devi ', '514340986489', '18-04-2023', '', 'belwaripatti  ', 'malti devi ', '', 'banka yadav ', '', 'belwaripatti ', 'vill- belwaripatti post thakraha west champaran bihar ', 'D-2023: 10-90347-006709', '20-05-2023', '23-05-23 02:03:04', '23-05-23 02:03:04', '7079113101', 'FEMALE', 'Bihar', 'SADAR HOSPITAL MUZAFFARPUR', '29', 'dhananjay yadav ', '789571616883'),
(28, 'ramkumar', 'not', '10-05-2007', '10/05/2007', 'behsar', 'radhi', 'not', 'khageswar', 'not', 'VILLAGE AND POST BEHSAR BEHANDER HARDOI UTTAR PRADESH', 'village and post behsar behander hardoi uttar pradesh', 'D-2023: 10-90347-007020', '', '29-05-23 05:29:16', '29-05-23 05:29:16', '9877141256', 'MALE', 'Uttar Pradesh', 'COMMUNITY HEALTH CENTRE MALIHABAD OK', '1960', 'rajmati', '724320176666'),
(29, 'ramdeen', 'not', '13-10-2018', '', 'chhatta kheda', 'RAJRANI', 'NOT', 'GHASI', 'NOT', 'VILLAGE CHHATTA KHEDA POST BHATAULI BEHANDER HARDOI UTTAR PRADESH', 'VILLAGE CHHATTA KHEDA POST BHATAULI BEHANDER HARDOI UTTAR PRADESH', 'D-2023: 10-90347-00243', '', '03-06-23 02:55:45', '03-06-23 02:55:45', '9877141256', 'MALE', 'Uttar Pradesh', 'COMMUNITY HEALTH CENTRE MALIHABAD OK', '52', 'RAMKALI', '432587055162'),
(30, 'CHAMPA DEVI ', 'xxxxxx6855', '23-03-2022', '', 'malahi tola ', 'phuljhariya devi', '', 'harihar sahni', 'xxxxxxxx', 'MALAHI TOLA POST KOIRPATTI THAKRAHA WEST CHAMPARAN BIHAR 845404', 'malahi tola post koirpatti thakraha west champaran bihar 845404', 'D-2023: 10-90347-009045', '05-06-2023', '05-06-23 10:11:17', '05-06-23 10:11:17', '8957210848', 'FEMALE', 'Bihar', 'SADAR HOSPITAL MUZAFFARPUR', '45', 'changur chaudhari', 'xxxxxxx0756'),
(31, 'abhilakh miya ', '', '15-05-2006', '', 'ward no 07 ambedkar nagar ', 'habibana ', '', 'rasul miya ', '', 'WARD NO 07 AMBEDKAR NAGAR time  12:26 pm', 'ward no 07 ambedkar nagar tamkuhi raj seorahi kushinagar  274406', 'D-2023: 10-90347-009958', '07-06-2023', '08-06-23 11:40:03', '08-06-23 11:40:03', '7079113101', 'MALE', 'Uttar Pradesh', 'DISTRICT FEMALE HOSPITAL KUSHINAGAR', '75', 'saliman nesha ', '620412940408'),
(32, 'abhilakh miya ', '', '15-05-2006', '', 'ward no 07 azad nagar ', 'habibana ', '', 'rasul miya ', '', 'WARD NO 07 AZAD NAGAR time  12:26 pm', 'ward no 07 aZAD nagar tamkuhi raj seorahi kushinagar  274406', 'D-2023: 10-90347-003967', '07-06-2023', '08-06-23 02:24:54', '08-06-23 02:24:54', '7079113101', 'MALE', 'Uttar Pradesh', 'DISTRICT FEMALE HOSPITAL KUSHINAGAR', '75', 'saliman nesha ', '620412940408'),
(33, 'mukhalal mukhiya ', '760929908913', '29-06-2023', '', 'basantpur ', 'marchhiya devi ', '', 'rajman mukhiya ', '', 'VILL- BASANTPUR POST PIRARI WEST CHAMPARAN BIHAR  845306', 'vill- basantpur post pirari west champaran bihar  845306', 'D-2023: 10-90347-001549', '04-07-2023', '05-07-23 02:09:20', '05-07-23 02:09:20', '7079113101', 'MALE', 'Bihar', 'SADAR HOSPITAL MUZAFFARPUR', '46', 'birja devi ', '714531702933');

-- --------------------------------------------------------

--
