-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `DistrictOfficers`
--

CREATE TABLE `DistrictOfficers` (
  `id` int(11) NOT NULL,
  `district` varchar(50) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `mobile` varchar(15) DEFAULT NULL,
  `Designation` varchar(255) DEFAULT NULL,
  `Email_ID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `DistrictOfficers`
--

INSERT INTO `DistrictOfficers` (`id`, `district`, `name`, `mobile`, `Designation`, `Email_ID`) VALUES
(1, 'AMRITSAR', 'DR. DINESH KUMAR', '9417268421', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'DAUOAMRITSAR@GMAIL.COM'),
(2, 'BATHINDA', 'DR. BALDEV RAJ', '9814322839', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'DAUOBTI@GMAIL.COM'),
(3, 'BARNALA', 'DR. AMAN KAUSHAL', '9780055010', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'DAUOBARNALA12@GMAIL.COM'),
(4, 'ROPAR', 'DR. MURSHID IMAM', '9781218692', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'DAUO.RUPNAGAR@GMAIL.COM'),
(5, 'FEROZEPUR', 'DR. MANJU', '9815195952', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'DAUOFZR1@GMAIL.COM'),
(6, 'FATEHGARH SAHIB', 'DR. PARMJIT SAINI (SR. AYU. PHY.)', '9815023744', 'DISTRICT AYURVEDIC AND UNANI OFFICER (ADDL. CHARGE)', 'AYURVEDICFGS@GMAIL.COM'),
(7, 'GURDASPUR', 'DR. PARDEEP SINGH', '9417405036', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'AYU.GSP@GMAIL.COM'),
(8, 'HOSHIARPUR', 'DR. PARDEEP SINGH', '9463435920', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'DAUOHOSHIARPUR@YAHOO.IN'),
(9, 'SHRI MUKTSAR SAHIB', 'DR. GURPREET SINGH, SR. AYURVEDIC PHYSICIAN', '9814189449', 'DISTRICT AYURVEDIC AND UNANI OFFICER (ADDL. CHARGE)', 'DAUOMKS@GMAIL.COM'),
(10, 'KAPURTHALA', 'DR. KUSAM GUPTA', '9815599902', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'DAUOKPT@GMAIL.COM'),
(11, 'LUDHIANA', 'DR. NAVPREET KAUR (SR. AYU. PHY.)', '9463070212', 'DISTRICT AYURVEDIC AND UNANI OFFICER (ADDL. CHARGE)', 'DAULDH429@GMAIL.COM'),
(12, 'MANSA', 'DR. NAMITA GARG', '9501033879', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'DAUOMANSA05@GMAIL.COM'),
(13, 'SAHIBZADA AJIT SINGH NAGAR', 'DR. PALWINDER SINGH', '9914534111', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'DAUOMOHALI009@GMAIL.COM'),
(14, 'MOGA', 'DR. RAPINDERDEEP GILL (SR. AYU. PHY.)', '9914202533', 'DISTRICT AYURVEDIC AND UNANI OFFICER (ADDL. CHARGE)', 'DISTTAYURMOGA@GMAIL.COM'),
(15, 'JALANDHAR', 'DR. VEENU KHANNA', '8146744800', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'DAUOJAL@GMAIL.COM'),
(16, 'PATIALA', 'DR. MOHAN LAL', '8427946567', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'DAUOPATIALA2013@GMAIL.COM'),
(17, 'SANGRUR', 'DR. RAMAN KHANNA', '7340715450', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'DAUOSANGRUR@GMAIL.COM'),
(18, 'SBS NAGAR', 'DR. SARBJIT KAUR', '9872873075', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'DAUONWS@GMAIL.COM'),
(19, 'TARN TARAN', 'DR. SARABJIT KAUR', '9781104477', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'DAUOTARNTARAN@GMAIL.COM'),
(20, 'PATHANKOT', 'DR. MALKIT SINGH', '9815018212', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'AYURPKT@GMAIL.COM'),
(21, 'FAZILKA', 'DR. SANJEEV PATHAK (SR. AYU. PHY.)', '9417011036', 'DISTRICT AYURVEDIC AND UNANI OFFICER (ADDL. CHARGE)', 'DAUOFZK@GMAIL.COM'),
(22, 'FARIDKOT', 'DR. BAHADUR SINGH', '9855071702', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'DAUOFDK@GMAIL.COM'),
(23, 'PATIALA', 'DR. RAJIV KUMAR JINDIA', '7889170596', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.PATIALA@PUNJAB.GOV.IN'),
(24, 'BATHINDA', 'DR. RAJIV KUMAR JINDIA', '7889170596', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.BTD@PUNJAB.GOV.IN'),
(25, 'MANSA', 'DR. RAJIV KUMAR JINDIA', '7889170596', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.MANSA@PUNJAB.GOV.IN'),
(26, 'BARNALA', 'DR. RAJIV KUMAR JINDIA', '7889170596', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.HOMEO.BARNALA@PUNJAB.GOV.IN'),
(27, 'ROOPNAGAR', 'DR. RAJIV KUMAR JINDIA', '7889170596', 'DISTRICT HOMEOPATHY OFFICER', 'DHORUPNAGAR@GMAIL.COM'),
(28, 'SAHEED BHAGAT SINGH NAGAR', 'DR. RAJIV KUMAR JINDIA', '7889170596', 'DISTRICT HOMEOPATHY OFFICER', 'DHOSBSN2016@GMAIL.COM'),
(29, 'SANGRUR', 'DR. REHMAN ASAD', '9417760186', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.SGR@PUNJAB.GOV.IN'),
(30, 'FEROZEPUR', 'DR. REHMAN ASAD', '9417760186', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.HOMEO.FZR@PUNJAB.GOV.IN'),
(31, 'FAZILKA', 'DR. REHMAN ASAD', '9417760186', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.FAZILKA@PUNJAB.GOV.IN'),
(32, 'FARIDKOT', 'DR. REHMAN ASAD', '9417760186', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.HOMOE.FDK@PUNJAB.GOV.IN'),
(33, 'SH. MUKTSAR SAHIB', 'DR. REHMAN ASAD', '9417760186', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.HOMOE.MKS@PUNJAB.GOV.IN'),
(34, 'AMRITSAR', 'DR. REHMAN ASAD', '9417760186', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.HOMOE.ASR@PUNJAB.GOV.IN'),
(35, 'LUDHIANA', 'DR. GURDARSHAN KAUR', '9872820398', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.HOMEO.LDH@PUNJAB.GOV.IN'),
(36, 'HEAD QUARTER CHANDIGARH', 'DR. GURDARSHAN KAUR', '9872820398', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.HOMEO.CHDHQ@PUNJAB.GOV.IN'),
(37, 'SAHIBZADA AJIT SINGH NAGAR', 'DR. GURDARSHAN KAUR', '9872820398', 'DISTRICT HOMEOPATHY OFFICER', 'DHOMOHALI015@GMAIL.COM'),
(38, 'FATEHGARH SAHIB', 'DR. RUPINDER KAUR', '9814244664', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.HOMEO.FGS@PUNJAB.GOV.IN'),
(39, 'JALANDHAR', 'DR. RUPINDER KAUR', '9814244664', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.HOMEO.JAL@PUNJAB.GOV.IN'),
(40, 'KAPURTHALA', 'DR. RUPINDER KAUR', '9814244664', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.HOMEO.KPT@PUNJAB.GOV.IN'),
(41, 'MOGA', 'DR. RUPINDER KAUR', '9814244664', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.HOMEO.MOGA@PUNJAB.GOV.IN'),
(42, 'HOSHIARPUR', 'DR. RUPINDER KAUR', '9814244664', 'DISTRICT HOMEOPATHY OFFICER', 'DHOHSP@GMAIL.COM'),
(43, 'GURDASPUR', 'DR. RUPINDER KAUR', '9814244664', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.GURDASPUR@PUNJAB.GOV.IN'),
(44, 'TARN TARAN', 'DR. RUPINDER KAUR', '9814244664', 'DISTRICT HOMEOPATHY OFFICER', 'DHO.TARNTARAN@PUNJAB.GOV.IN'),
(45, 'CHANDIGARH', 'DR. TESTING DISTRICT', '9058788862123', 'DISTRICT AYURVEDIC AND UNANI OFFICER', 'XYZ@PUNJAB.GOV.IN');

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

--
-- Table structure for table `facility_officer`
--

CREATE TABLE `facility_officer` (
  `id` int(11) NOT NULL,
  `district` varchar(255) NOT NULL,
  `ayush_hwc` varchar(255) DEFAULT NULL,
  `Facility_Type` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `mobile` varchar(100) NOT NULL,
  `email` varchar(255) NOT NULL,
  `Designation` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `facility_officer`
--

INSERT INTO `facility_officer` (`id`, `district`, `ayush_hwc`, `Facility_Type`, `name`, `mobile`, `email`, `Designation`) VALUES
(1, 'AMRITSAR', 'CHAPPA RAM SINGH', 'AYURVEDIC DISPENSARY', 'DR. SONIA SHARMA', '9501035146', 'SONIA26775@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(2, 'AMRITSAR', 'CHEHARRATTA', 'AYURVEDIC DISPENSARY', 'DR. NIRUPAMA ARORA', '7986694303', 'VJNIRUPAMA@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(3, 'AMRITSAR', 'GAH VERKA', 'GOVT AYURVEDIC HOSPITAL', 'DR. AMIT MAHAJAN', '9501111214', 'DRAMITMAHAJAN3179@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(4, 'AMRITSAR', 'SWASTH KENDRA (CIVIL HOSPITAL)', 'AYURVEDIC DISPENSARY', 'DR. RAMANJIT KAUR RANDHAWA', '9478205796', 'RKHBHULLAR007@GMAIL.COM', 'SENIOR AYURVEDIC PHYSICIAN'),
(5, 'AMRITSAR', 'UGGAR AULAKH', 'AYURVEDIC DISPENSARY', 'DR. SANDEEP KAUR', '9877782339', 'KSANDEEPSANDY1512@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(6, 'AMRITSAR', 'PHERUMAAN', 'AYURVEDIC DISPENSARY', 'DR. VIVEK SHORI (ADJUSTED)', '8146800919', 'VIVEKSHORI1976@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(7, 'AMRITSAR', 'G.N.D.UNIVERSITY', 'AYURVEDIC DISPENSARY', 'DR. SANDEEP SHRIDHAR', '8146424400', 'SANDEEP.SHRIDHAR71@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(8, 'AMRITSAR', 'MACHINANGAL', 'AYURVEDIC DISPENSARY', 'DR. AMANPREET SINGH', '9814288991', 'AMAN88991@YAHOO.COM', 'AYURVEDIC MEDICAL OFFICER'),
(9, 'AMRITSAR', 'SANGNA', 'AYURVEDIC DISPENSARY', 'DR. ALISHA DHAWAN', '8288055939', 'ALISHADHAWAN26@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(10, 'AMRITSAR', 'TAHLI SAHIB', 'AYURVEDIC DISPENSARY', 'DR. RANDHIR SINGH', '9779265932', 'SINGHRANDHIRDR@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(11, 'BARNALA', 'GAD KHUDI KHURD', 'AYURVEDIC DISPENSARY', 'DR. RAKESH KUMAR', '9417329462', 'RAKESHKUMARTAPA@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(12, 'BATHINDA', 'AMARPURA', 'AYURVEDIC DISPENSARY', 'DR. MAMTA GUPTA', '8195011511', 'GMONA86@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(13, 'BATHINDA', 'MEHMA SARJA', 'AYURVEDIC DISPENSARY', 'DR. SUKHPREET KAUR', '9464341632', 'DR.SUKHPREET2687@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(14, 'BATHINDA', 'DAN SINGH', 'AYURVEDIC DISPENSARY', 'DR. RUPINDER KAUR NATT', '7837500192', 'RUPINDERKAURRAJPAL@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(15, 'BATHINDA', 'CHAKK KHADAK SINGH', 'AYURVEDIC DISPENSARY', 'DR. RAVINDER BHARADWAJ', '9878091333', 'RBHARDWAJ1201@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(16, 'BATHINDA', 'GAH BATHINDA', 'GOVT AYURVEDIC HOSPITAL', 'DR. RASHMI KHANNA', '9463159997', 'DODRONLINE@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(17, 'BATHINDA', 'BHAGIWANDER', 'AYURVEDIC DISPENSARY', 'DR. PARAMJEET KAUR PIPTON', '9592346940', 'PARAMJEET12340@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(18, 'BATHINDA', 'KOT FATTA', 'AYURVEDIC DISPENSARY', 'DR. YOGESH GOYAL', '8146700214', 'GOYAL2627@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(19, 'BATHINDA', 'CHUMBA', 'AYURVEDIC DISPENSARY', 'DR. BANDANA DHARIWAL', '9915677793', 'BANDANADHARIWAL@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(20, 'BATHINDA', 'RAMPURA', 'AYURVEDIC DISPENSARY', 'DR. SANDEEP SINGH', '9463628775', 'DRSANDEEP9999@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(21, 'FARIDKOT', 'GOV. AYURVEDIC SWASTH KENDRA FARIDKOT', 'AYURVEDIC DISPENSARY', 'DR. SANJEEV KUMAR', '7986357780', 'SANJEEVJINDAL884@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(22, 'FARIDKOT', 'GAD AMBEDKAR NAGAR FDK', 'AYURVEDIC DISPENSARY', 'DR. GURLEEN KAUR', '9056698020', 'DOCGURLEEN241@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(23, 'FARIDKOT', 'GAD BARGARI', 'AYURVEDIC DISPENSARY', 'DR. ROHIT MONGA', '9888233280', 'MONGAROHIT2@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(24, 'FARIDKOT', 'GAD PAKHI KALAN', 'AYURVEDIC DISPENSARY', 'SH. SUKHJINDER SINGH', '9517561727', 'SUKJINDERBUTTER884@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(25, 'FATEHGARH SAHIB', 'KHAMANO KALAN', 'AYURVEDIC DISPENSARY', 'DR. DEEPIKA PARMAR', '8146587999', 'PARMARDEEPIKA393@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(26, 'FATEHGARH SAHIB', 'KHERI NODH SINGH', 'AYURVEDIC DISPENSARY', 'VACANT (DR. KULWINDER SHARMA (AD:)', '9814722806', 'SHARMAKULVINDER43@YAHOO.COM', 'AYURVEDIC MEDICAL OFFICER'),
(27, 'FATEHGARH SAHIB', 'FAIZULLAPUR', 'AYURVEDIC DISPENSARY', 'DR. RAJAN KAUSHAL', '9501700279', 'DRRAJAN.KAUSHAL@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(28, 'FATEHGARH SAHIB', 'DAULAT PUR', 'AYURVEDIC DISPENSARY', 'DR. UMA BEDI', '9464836510', 'DRUMABEDI@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(29, 'FATEHGARH SAHIB', 'BRASS', 'AYURVEDIC DISPENSARY', 'DR. PUNJABI SATINDER KAUR', '8427002939', 'SATTU111_CHANDEL@YAHOO.COM', 'AYURVEDIC MEDICAL OFFICER'),
(30, 'FATEHGARH SAHIB', 'RAILLON', 'AYURVEDIC DISPENSARY', 'DR. DIWAN CHAND DHIR', '9872851195', 'DRDIWANDHIR@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(31, 'FATEHGARH SAHIB', 'SALANA JIWAN SINGH WALA', 'AYURVEDIC DISPENSARY', 'DR. TEENA DEVGAN', '7815011111', 'DRTEENASHARMA88@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(32, 'FATEHGARH SAHIB', 'CHUNNI KALAN', 'AYURVEDIC DISPENSARY', 'DR. SAKINDER', '9878349449', 'SAKINDER0903@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(33, 'FATEHGARH SAHIB', 'REOUNA', 'AYURVEDIC DISPENSARY', 'DR. KAMNA BAWA', '9592140773', 'KAMANABAWA@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(34, 'FATEHGARH SAHIB', 'GAD SIRHIND MANDI', 'AYURVEDIC DISPENSARY', 'DR. SANDEEP', '9646679855', 'S07121972@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(35, 'FAZILKA', 'GAD ABOHAR', 'AYURVEDIC DISPENSARY', 'DR. AMIT KUMAR', '7597385005', 'MIGLANI85@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(36, 'FAZILKA', 'GAD KALLER KHERA', 'AYURVEDIC DISPENSARY', 'DR. VINEET KUMAR', '9646486363', 'VINEETARORA028@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(37, 'FAZILKA', 'GAD DHINGA WALI', 'AYURVEDIC DISPENSARY', 'DR. RAJESH KUMAR JOHAR', '8560859592', 'RAJESH.PUNJABAMO@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(38, 'FAZILKA', 'GAD RAMGARH', 'AYURVEDIC DISPENSARY', 'DR. VINEET KUMAR (ADJUSTED)', '9646486363', 'VINEETARORA028@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(39, 'FAZILKA', 'GAD CHURIWALA DHANA', 'AYURVEDIC DISPENSARY', 'DR. VINOD KUMAR VERMA', '8601165477', 'DRVINODVRMA@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(40, 'FAZILKA', 'GAD DANEWALA SATKOSHI', 'AYURVEDIC DISPENSARY', 'DR. SUNITA', '9454865460', 'SUNITAVRMA1991@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(41, 'FAZILKA', 'GAD SAPPAN WALI', 'AYURVEDIC DISPENSARY', 'DR. PARVINDER KAUR', '6350541980', 'PARVINDERLGM@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(42, 'FAZILKA', 'GAD RANA', 'AYURVEDIC DISPENSARY', 'DR. AMANDEEP KAUR', '9646764491', 'GILLAMANDEEP508@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(43, 'FAZILKA', 'GAD CHAK ROOM WALA', 'AYURVEDIC DISPENSARY', 'SH. VIKAS KUMAR', '9914740481', 'VKUMARSANDHA@GMAIL.COM', 'UPVAID'),
(44, 'FEROZPUR', 'YARESHAH WALA', 'AYURVEDIC DISPENSARY', 'DR. SUMIT MONGA', '9876344421', 'SUMITMONGA83@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(45, 'FEROZPUR', 'CHUGATEWALA', 'AYURVEDIC DISPENSARY', 'DR. PRAVEEN KUMAR RANA (ADJUSTED)', '9882203940', 'DR.PRAVEENRANA87@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(46, 'FEROZPUR', 'SWASTH KENDRA BHADANA', 'AYURVEDIC DISPENSARY', 'DR. GURPREET SINGH', '9463296955', 'RANAGURPREETDHALIWAL83@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(47, 'GURDASPUR', 'THANDOI', 'AYURVEDIC DISPENSARY', 'SH. SANDEEP KUMAR', '9876764289', 'KSANDEEP72620@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(48, 'GURDASPUR', 'SEKHA', 'AYURVEDIC DISPENSARY', 'DR. MONIKA', '9465758218', 'MONIKAA28022@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(49, 'GURDASPUR', 'BABRI JIWAN WAL', 'AYURVEDIC DISPENSARY', 'DR. RAMANJEET KAUR', '6239498938', 'RAMANJEETKAUR697@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(50, 'GURDASPUR', 'NARPUR', 'AYURVEDIC DISPENSARY', 'DR. NAVNEET SINGH', '9855437036', 'NAVNEET1986@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(51, 'GURDASPUR', 'MASSANIA', 'AYURVEDIC DISPENSARY', 'DR. AMIT VERMA', '9814737262', 'DR.AMIT.VERMA24@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(52, 'GURDASPUR', 'DARGABAD', 'AYURVEDIC DISPENSARY', 'SH. SANDEEP SINGH', '9914289091', 'YASHSANDEEP751@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(53, 'GURDASPUR', 'PASNEWAL', 'AYURVEDIC DISPENSARY', 'SMT. CHARNJIT KAUR', '8837542733', 'CKAUR9549@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(54, 'GURDASPUR', 'CHAK SHRIF', 'AYURVEDIC DISPENSARY', 'DR. NEETU AGGARWAL', '9815348362', 'AGGARWAL2525@YAHOO.IN', 'AYURVEDIC MEDICAL OFFICER'),
(55, 'GURDASPUR', 'MARRIANWAL', 'AYURVEDIC DISPENSARY', 'DR. HARINDER SINGH', '8195983000', 'HARINDERSINGH7722@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(56, 'GURDASPUR', 'BALPURIAN', 'AYURVEDIC DISPENSARY', 'DR. NEELAM VERMA', '7681988995', 'VISHALVERMA@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(57, 'GURDASPUR', 'GOVT. SWAST KENDRA TALIBPUR PANDORI', 'AYURVEDIC DISPENSARY', 'DR. MEENAKSHI', '9888087157', 'DR.MEENAXI84@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(58, 'GURDASPUR', 'GHD RANJIT BAGH GURDASPUR', 'HOMEOPATHIC DISPENSARY', 'DR. BIKRAMJIT SINGH', '9465565696', 'DRJOHALBIKRAM92@YAHOO.COM', 'HOMEOPATHIC MEDICAL OFFICER'),
(59, 'HOSHIARPUR', 'MONA KALAN', 'AYURVEDIC DISPENSARY', 'AMRITPAL SINGH', '9464616524', 'AMRITNANDRA1@GMAIL.COM', 'UPVAID'),
(60, 'HOSHIARPUR', 'DATARPUR', 'GOVT AYURVEDIC HOSPITAL', 'DR. HEMANT', '8427272114', 'PRATUSH123@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(61, 'HOSHIARPUR', 'BOHAN', 'AYURVEDIC DISPENSARY', 'DR. MUKESH DHIMAN', '9781029912', 'MUKESH1984DHIMAN@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(62, 'HOSHIARPUR', 'NANGAL BIHALAN', 'AYURVEDIC DISPENSARY', 'DR. RUCHIKA', '9876703081', 'OMDR.RUCHIKASAPAIYA@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(63, 'HOSHIARPUR', 'HARDOKHANPUR', 'AYURVEDIC DISPENSARY', 'DR. RABJYOT KAUR', '9464932227', 'RABJYOTKAUR15@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(64, 'JALANDHAR', 'RASULPUR KALAN', 'AYURVEDIC DISPENSARY', 'DR. ANITA', '9855029394', 'RASULPURKALANAYUSH@GMAIL.COM@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(65, 'JALANDHAR', 'KHANPUR DHADDA', 'UNANI DISPENSARY', 'DR. RITIKA BALI (ADJUSTED)', '9878169151', 'RITIKABALI007@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(66, 'JALANDHAR', 'TAJPUR', 'AYURVEDIC DISPENSARY', 'DR. DALVEER KAUR', '7508021393', 'TAJPURAYUSH@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(67, 'JALANDHAR', 'TALWANDI MADHO', 'AYURVEDIC DISPENSARY', 'DR. PANKAJ DOGRA (ADJUSTED)', '9876771685', 'TALWANDIMADHOAYUSH@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(68, 'JALANDHAR', 'NIJJRAN', 'AYURVEDIC DISPENSARY', 'DR. CHETAN MEHTA', '9815966198', 'CHETAN5KARMA@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(69, 'JALANDHAR', 'PATARA', 'AYURVEDIC DISPENSARY', 'DR. SUKHPREET KAUR', '9878645084', 'DR.SUKHPREETKR@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(70, 'JALANDHAR', 'PARTABPURA', 'AYURVEDIC DISPENSARY', 'DR. AMITA BALM (ADJUSTED)', '9915994306', 'AMITABALM99@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(71, 'JALANDHAR', 'DUHRE', 'AYURVEDIC DISPENSARY', 'DR. MANOJ KUMAR', '9478858552', 'BALPREETKAUR808@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(72, 'KAPURTHALA', 'GAD SIDHWA DONA', 'AYURVEDIC DISPENSARY', 'DR. BALRAM', '9041916337', 'BALRAMNIJJAR82@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(73, 'KAPURTHALA', 'GAD MUSTAFABAD', 'AYURVEDIC DISPENSARY', 'DR. RUPINDER KAUR', '8054034008', 'RUPINDEREKU1@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(74, 'KAPURTHALA', 'GAD MANAK', 'AYURVEDIC DISPENSARY', 'DR. GURDIP SINGH (ADJUSTED)', '9463105602', 'DRGURDIP.MEHMI@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(75, 'KAPURTHALA', 'GAD BAGHANA', 'AYURVEDIC DISPENSARY', 'DR. PREM PAL', '9779799006', 'DRPREMPAL459@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(76, 'KAPURTHALA', 'GAD PALAHI', 'AYURVEDIC DISPENSARY', 'DR. SUNITA KUMARI', '9464236095', '1968DARA@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(77, 'KAPURTHALA', 'GAD PANDORI', 'AYURVEDIC DISPENSARY', 'DR. JASPAL SINGH (ADJUSTED)', '9876338083', 'DR.AMIJAS26@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(78, 'KAPURTHALA', 'GAD DHALIWAL BET', 'AYURVEDIC DISPENSARY', 'DR. MANJOT KAUR', '9417157548', 'MANJOTHEMANT@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(79, 'LUDHIANA', 'KHANNA', 'AYURVEDIC DISPENSARY', 'DR. PANKAJ SHARMA', '8699417096', 'GOPALPANKAJ203@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(80, 'LUDHIANA', 'SUJAPUR', 'AYURVEDIC DISPENSARY', 'DR. MOHD. SHAMSHUDDIN KHAN', '9650749827', 'DRSHAMSHKHAN1984@GMAIL.COM', 'UNANI MEDICAL OFFICER'),
(81, 'LUDHIANA', 'BOPARAI KALAN', 'AYURVEDIC DISPENSARY', 'DR. QAMRUL HASAN', '9149013376', 'DRQAMRULHASAN28@GMAIL.COM', 'UNANI MEDICAL OFFICER'),
(82, 'LUDHIANA', 'BUDHEWAL', 'AYURVEDIC DISPENSARY', 'DR. DEEPIKA VERMA', '9878524661', 'VERMADEEPIKA197@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(83, 'LUDHIANA', 'HEDONBET', 'AYURVEDIC DISPENSARY', 'DR. AMANDEEP SINGH', '9815472402', 'DEEPAMAN.4YOU@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(84, 'LUDHIANA', 'BHUTTA', 'AYURVEDIC DISPENSARY', 'DR. BALJEET KAUR', '9988011065', 'DRBALJITKAUR3@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(85, 'LUDHIANA', 'GAD SARABHA NAGAR', 'AYURVEDIC DISPENSARY', 'DR. JASWINDER KAUR', '9888984079', 'JASSI.GAMC30@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(86, 'LUDHIANA', 'SWASTH KENDRA JAGRAON', 'AYURVEDIC DISPENSARY', 'DR. HARJEET KAUR', '9041517920', 'HARJEETKAUR0855@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(87, 'LUDHIANA', 'GAD MUNDIAN KALAN', 'AYURVEDIC DISPENSARY', 'DR. JASWANT KAUR', '9988777279', 'SATWINDERBASSI86@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(88, 'LUDHIANA', 'GAD KHANPUR', 'AYURVEDIC DISPENSARY', 'DR. HARJINDER KAUR', '9646100319', 'DRHARJINDER28@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(89, 'LUDHIANA', 'GAD QILA HANS', 'AYURVEDIC DISPENSARY', 'DR. IMRAN KHAN SAIFI', '9634452843', 'DRSAIFI1@GMAIL.COM', 'UNANI MEDICAL OFFICER'),
(90, 'LUDHIANA', 'GUD BULARA', 'AYURVEDIC DISPENSARY', 'DR. SANDEEP KAUR', '8847683780', 'DRSEEMAKAUR1@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(91, 'LUDHIANA', 'GAD SAHBANA', 'AYURVEDIC DISPENSARY', 'DR. RAMANPREET KAUR', '9876827087', 'RMNPRT.RAMAN@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(92, 'LUDHIANA', 'GHD SAHNEWAL', 'HOMEOPATHIC DISPENSARY', 'DR. MANINDER KAUR', '9501891961', 'DRMANINDERK80@GMAIL.COM', 'HOMEOPATHIC MEDICAL OFFICER'),
(93, 'LUDHIANA', 'GHD JAGRAON/SWADI', 'HOMEOPATHIC DISPENSARY', 'DR. SURUCHI', '9780552543', 'DR.SURUCHI@YAHOO.COM', 'HOMEOPATHIC MEDICAL OFFICER'),
(94, 'LUDHIANA', 'GHD KOHARA', 'HOMEOPATHIC DISPENSARY', 'DR. BALWINDER KUMAR', '9888894309', 'BALWINDER56483@GMAIL.COM', 'HOMEOPATHIC MEDICAL OFFICER'),
(95, 'LUDHIANA', 'GHD MACHIWARA', 'HOMEOPATHIC DISPENSARY', 'DR. HARMAN KAUR', '9814890930', 'KAURDRHARMAN8@GMAIL.COM', 'HOMEOPATHIC MEDICAL OFFICER'),
(96, 'MANSA', 'GAD MANSA', 'AYURVEDIC DISPENSARY', 'SMT. KRITI RANI UPVAID', '9501352511', 'RANIKRITI1990@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(97, 'MANSA', 'GAD JHUNIR', 'AYURVEDIC DISPENSARY', 'DR. VERENDER KUMAR', '9467289399', 'VIRUKUUK@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(98, 'MANSA', 'GAD CHAKERIAN', 'AYURVEDIC DISPENSARY', 'DR. SEEMA GOEL', '8968746477', 'SEEMAAMO@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(99, 'MANSA', 'GAD KARANDI', 'AYURVEDIC DISPENSARY', 'DR. POOJA RANI', '9915217771', 'B.K.POOJAARORA771@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(100, 'MANSA', 'GAD RAIPUR', 'AYURVEDIC DISPENSARY', 'DR. POOJA', '9041005176', 'POOJAAYURVEDA48@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(101, 'MOGA', 'BHINDERKALAN', 'AYURVEDIC DISPENSARY', 'DR. PAVITTAR KAUR', '9914692437', 'DRPAVITTAR.AMOMOGA@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(102, 'SAHIBZADA AJIT SINGH NAGAR', 'PH.9 MOHALI', 'AYURVEDIC DISPENSARY', 'DR. PARMINDERJIT KAUR', '9417410001', 'PARMINDERJP266@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(103, 'SAHIBZADA AJIT SINGH NAGAR', 'TEERA', 'AYURVEDIC DISPENSARY', 'DR. HEENA', '9876040866', 'HENAK0866@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(104, 'SAHIBZADA AJIT SINGH NAGAR', 'TASIMBLI', 'AYURVEDIC DISPENSARY', 'DR. HARPREET SINGH', '9464389678', 'DOC.HARPREETSINGH@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(105, 'SAHIBZADA AJIT SINGH NAGAR', 'GAD MULLANPUR', 'AYURVEDIC DISPENSARY', 'DR. RAJNI BALA', '9888209587', 'DR.RAJNI2@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(106, 'SAHIBZADA AJIT SINGH NAGAR', 'GHD, SECTOR39 CHD', 'HOMEOPATHIC DISPENSARY', 'DR. GURPREET KAUR', '9646553989', 'DRGURPREETARORA@YAHOO.COM', 'HOMEOPATHIC MEDICAL OFFICER'),
(107, 'MUKTSAR', 'GAD MUKTSAR SAHIB', 'AYURVEDIC DISPENSARY', 'DR. AMITA GUPTA', '8146035786', 'AMITA35786GUPTA@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(108, 'MUKTSAR', 'GAD WARRING', 'AYURVEDIC DISPENSARY', 'DR. AMANDEEP KOUR', '9780629969', 'NARDOIA969@YAHOO.COM', 'AYURVEDIC MEDICAL OFFICER'),
(109, 'PATHANKOT', 'GAD LEHROON', 'AYURVEDIC DISPENSARY', 'DR. PRINCY LORIA', '9418052549', 'PRINCYLORIA@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(110, 'PATHANKOT', 'GAD LAHRIGUJJRA', 'AYURVEDIC DISPENSARY', 'DR. JATINDER SINGH', '9915267306', 'JATINDERTHAKUR726@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(111, 'PATHANKOT', 'GAD CHHATWAL', 'AYURVEDIC DISPENSARY', 'DR. SAHIL KUMAR SHARMA', '9878739668', 'SAHIL2615SHARMA@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(112, 'PATHANKOT', 'GAD BANI LODHI', 'AYURVEDIC DISPENSARY', 'DR. RUBANPREET', '9988079906', 'RUBANPREET3@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(113, 'PATHANKOT', 'GAD NAROT MEHRA', 'AYURVEDIC DISPENSARY', 'DR. MALTI RANA', '9625390098', 'RANAMALTI16@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(114, 'PATHANKOT', 'GAD DURANGKHAD', 'AYURVEDIC DISPENSARY', 'DR. SACHIN GUPTA', '9463605077', 'DRSACHINGUPTA@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(115, 'PATIALA', 'CHAMARU', 'AYURVEDIC DISPENSARY', 'DR. MANISHA', '8408902160', 'DR.MANISHA.SINGLA@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(116, 'PATIALA', 'CHAPPAR', 'AYURVEDIC DISPENSARY', 'DR. MANDEEP KAUR VIRDI', '9878632470', 'AHWCCHAPPAR12345@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(117, 'PATIALA', 'RAJPURA', 'AYURVEDIC DISPENSARY', 'DR. POOJA ARORA', '9855031921', 'POOJAARORAA832@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(118, 'PATIALA', 'NABHA', 'AYURVEDIC DISPENSARY', 'DR. HIMANSHU SHARMA', '9569266659', 'DRHIMANSHU.HERBALCURE@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(119, 'PATIALA', 'SEONA', 'AYURVEDIC DISPENSARY', 'DR. SIMRANJEET KAUR', '9781333799', 'DRSIMRANJITKAURSANDHU@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(120, 'PATIALA', 'KARHALI', 'AYURVEDIC DISPENSARY', 'DR. YOGESH BHATIA', '7696467191', 'Y_BHATIA1@YAHOO.CO.IN', 'AYURVEDIC MEDICAL OFFICER'),
(121, 'PATIALA', 'MADAUR', 'AYURVEDIC DISPENSARY', 'DR. RANJANA', '8968124823', 'DRRANJANAC@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(122, 'PATIALA', 'SHERMAJRA', 'AYURVEDIC DISPENSARY', 'DR. AMANDEEP KAUR', '7022671333', 'DRAMAN033@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(123, 'PATIALA', 'KHERAGAJJU', 'AYURVEDIC DISPENSARY', 'DR. JASVIR SINGH', '9988288174', 'JASVIR341@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(124, 'PATIALA', 'GAD MALLEHWAL', 'AYURVEDIC DISPENSARY', 'DR. JYOTI BALA', '9888627624', 'JYOTIBALA27624@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(125, 'PATIALA', 'GAD BEHAR JACH', 'AYURVEDIC DISPENSARY', 'DR. NEERU GUPTA', '8528538706', 'DRNEERUGUPTA27@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(126, 'ROPAR', 'BAJRUR', 'AYURVEDIC DISPENSARY', 'DR. KARUNA PURI', '6280095973', 'AYURAVI018@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(127, 'ROPAR', 'BUNGA SAHIB', 'AYURVEDIC DISPENSARY', 'DR. CHANDAN SHARMA', '9569379953', 'CHANDANATTRI@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(128, 'ROPAR', 'HARIPUR', 'AYURVEDIC DISPENSARY', 'DR. SIMAT TULI', '9988802752', 'SIMATTULI@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(129, 'ROPAR', 'BHATHA SAHIB', 'AYURVEDIC DISPENSARY', 'DR. INDERJIT KAUR', '9815472831', 'DOCTORVIEW4@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(130, 'ROPAR', 'BAMNARA', 'AYURVEDIC DISPENSARY', 'DR. KIRANJOT KAUR', '9417849563', 'RAJSANGHA2002@YAHOO.COM', 'AYURVEDIC MEDICAL OFFICER'),
(131, 'ROPAR', 'MATOUR', 'AYURVEDIC DISPENSARY', 'DR. SAMITA RAI', '9464697348', 'MATOUR140118@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(132, 'ROPAR', 'TALWARA', 'AYURVEDIC DISPENSARY', 'DR. SAMVEDNA BHARDWAJ (ADJUSTED)', '9736651625', 'DR.SAMVEDNA@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(133, 'ROPAR', 'GAD MASSEWAL', 'AYURVEDIC DISPENSARY', 'DR. RITU RANI (ADJUSTED)', '9464645164', 'RITURANI1333@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(134, 'ROPAR', 'BAN MAJRA', 'AYURVEDIC DISPENSARY', 'DR. TRIBHUVANJOT KAUR', '9872991998', 'DRTRIBHUVANJOTKBEDI@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(135, 'ROPAR', 'GAD BHANGAL', 'AYURVEDIC DISPENSARY', 'DR. ANITA SHARMA (ADJUSTED)', '9041342563', 'DRANITA6488@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(136, 'ROPAR', 'GAD BHABOR SAHIB', 'AYURVEDIC DISPENSARY', 'DR. VARUN KASHYAP', '9463865255', 'TARUS111@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(137, 'ROPAR', 'GAD BHANUPALI', 'AYURVEDIC DISPENSARY', 'DR. REKHA SONI', '7876870785', 'DRREKHASONI2505@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(138, 'SANGRUR', 'BARDWAL', 'AYURVEDIC DISPENSARY', 'DR. RAJNI BALA AMO', '9815720832', 'DRRAJNIBALA9@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(139, 'SANGRUR', 'BHARO', 'AYURVEDIC DISPENSARY', 'VACANT (DR. VISHAL ADJUSTED FOR 3 DAYS)', '7696475436', 'VISHALAYUR89@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(140, 'SANGRUR', 'KANAKWAL BHANGUA', 'AYURVEDIC DISPENSARY', 'VACANT (DR. AMANDEEP BHARTI ADJUSTED FOR 3 DAYS)', '9855276008', 'ZIYAFAIRY@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(141, 'SANGRUR', 'G.A.D. SANGRUR', 'AYURVEDIC DISPENSARY', 'DR. RAMANDEEP KUMAR AMO', '8837715583', 'PAROCHA18@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(142, 'SANGRUR', 'G.A.D. ROHIRA', 'AYURVEDIC DISPENSARY', 'DR. MOHD. AKMAL UMO', '9781069344', 'MAKMAL1378@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(143, 'SANGRUR', 'MEHLAN', 'AYURVEDIC DISPENSARY', 'DR. ROZY AMO', '9888128809', 'DR.ROZY01@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(144, 'SANGRUR', 'BHAWANIGARH', 'AYURVEDIC DISPENSARY', 'VACANT (DR. SHAILENDER VERMA ADJUSTED FOR 3 DAYS)', '8725928801', 'VERMASAIL88@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(145, 'SANGRUR', 'GOVT. AYU. SWASTH KENDRA KAHANGARH', 'AYURVEDIC DISPENSARY', 'DR. LALIT KANSAL', '9463588844', 'VAIDRAVIKANT13@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(146, 'SANGRUR', 'GHD NADAMPUR', 'HOMEOPATHIC DISPENSARY', 'DR. KAMALJEET KAUR HMO', '8872806788', 'DR.KJEETKAUR@GMAIL.COM', 'HOMEOPATHIC MEDICAL OFFICER'),
(147, 'SBS NAGAR', 'SIKOHPUR', 'AYURVEDIC DISPENSARY', 'DR. SHUBHKAMNA (ADJUSTED)', '9915631333', 'KAMNA.SHUBH33@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(148, 'SBS NAGAR', 'BEHRAM', 'AYURVEDIC DISPENSARY', 'DR. JATINDER KAUR (ADJUSTED)', '7696477203', 'JATTY0321@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(149, 'SBS NAGAR', 'MAJARI', 'AYURVEDIC DISPENSARY', 'DR. RAMGEET KUMARI (ADJUSTED)', '9501647616', 'DR.RAMGEET@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(150, 'SBS NAGAR', 'BRAMAD', 'AYURVEDIC DISPENSARY', 'DR. RAMINDER KAUR', '9988353237', 'RAMINDERKAUR524@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(151, 'SBS NAGAR', 'GAD KAMAM', 'AYURVEDIC DISPENSARY', 'DR. AMARPREET KAUR DHILLON', '8284807092', 'AMARPREETKAURDHILLON2@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(152, 'SBS NAGAR', 'GAD GUNACHAUR', 'AYURVEDIC DISPENSARY', 'DR. RAMANDEEP KUMAR', '8872712007', 'CHOAT26@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(153, 'TARN TARAN', 'GAD CHUSEWAL', 'AYURVEDIC DISPENSARY', 'DR. MANVINDER KAUR (ADJUSTED)', '8283055005', 'MANAVSHER06@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(154, 'TARN TARAN', 'GAD SARLI KALAN', 'AYURVEDIC DISPENSARY', 'DR. JYOTI BHATIA (ADJUSTED)', '9878273854', 'JOYADRJOYA@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(155, 'TARN TARAN', 'GAD KANG', 'AYURVEDIC DISPENSARY', 'DR. MANVINDER KAUR', '8283055005', 'MANAVSHER06@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(156, 'TARN TARAN', 'GAD SHEKH', 'AYURVEDIC DISPENSARY', 'DR. SANDEEP KUMAR (ADJUSTED)', '9888282069', 'AAKSHRITA123@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER'),
(157, 'TARN TARAN', 'GAD MANOCHAHAL', 'AYURVEDIC DISPENSARY', 'DR. MANINDER SINGH (ADJUSTED)', '9417951815', 'DR_RAJPUR20@YAHOO.COM', 'AYURVEDIC MEDICAL OFFICER'),
(158, 'TARN TARAN', 'GHD KHADOOR SAHIB', 'HOMEOPATHIC DISPENSARY', 'DR. HARINDER PAL SINGH VEGAL', '9463480866', 'HARINDERPALVEGAL@GMAIL.COM', 'HOMEOPATHIC MEDICAL OFFICER'),
(159, 'CHANDIGARH', 'NHM PUNJAB', 'AYURVEDIC DISPENSARY', 'DR. TESTING', '9258116678', 'PBITABDM@GMAIL.COM', 'AYURVEDIC MEDICAL OFFICER');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` text NOT NULL,
  `last_activity` int(11) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`, `email`, `mobile_no`, `created_at`, `updated_at`) VALUES
('dAfh8fFATa8u0hWJaTcrKHwOnVfgteQjAfqOCQR8', 1, '::1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoialhydFdBZ0lIY3dGN2tEeXpMMTk4aFRERUZlM0RNbzcxTDdwZFpHVSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDg6Imh0dHA6Ly9sb2NhbGhvc3Qvd2ViYXl1c2gvcHVibGljL3N0YXRlL2Rhc2hib2FyZCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTI6ImxvZ2luX3N0YXRlXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1722412725, NULL, NULL, NULL, NULL),
('iVZcLeMOMrjHTR7t68Xhd8qxzmzcHbljYUrncUGl', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:128.0) Gecko/20100101 Firefox/128.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiM0Z2b1FsNFBGZzlTcXRZWWR3QndxWVlNY1FSR0N1ZXRxYUtNTkRvTiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly9sb2NhbGhvc3Qvd2ViYXl1c2gvcHVibGljL2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1722410922, NULL, NULL, NULL, NULL),
('jPzVIj8K6EXL0d36gImbuDrdUCS9MH9b3U7Ug6jP', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:128.0) Gecko/20100101 Firefox/128.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibmNmSXYzQUZuZ1l2UUFRQmh1YVkzc3VvaUVvZlBCeUM3eHZXcmhRSyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDM6Imh0dHA6Ly9sb2NhbGhvc3Qvd2ViYXl1c2gvcHVibGljL3ZlcmlmeS1vdHAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1722485319, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `state_login_officers`
--

CREATE TABLE `state_login_officers` (
  `id` int(11) NOT NULL,
  `email` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `mobile` varchar(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `state_login_officers`
--

INSERT INTO `state_login_officers` (`id`, `email`, `name`, `mobile`) VALUES
(1, 'STATEXYZM@GMAIL.COM', 'DR. TESTING', '9058788862123');

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

--
-- Table structure for table `yoga_instructors`
--

CREATE TABLE `yoga_instructors` (
  `id` int(11) NOT NULL,
  `district` varchar(255) NOT NULL,
  `ayush_hwc` varchar(255) NOT NULL,
  `instructor_name` varchar(255) NOT NULL,
  `mobile_number` varchar(15) DEFAULT NULL,
  `gender` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `yoga_instructors`
--

INSERT INTO `yoga_instructors` (`id`, `district`, `ayush_hwc`, `instructor_name`, `mobile_number`, `gender`) VALUES
(1, 'AMRITSAR', 'CHAPPA RAM SINGH', 'LOVELEEN SINGH', '6280745779', 'MALE'),
(2, 'AMRITSAR', 'CHEHARRATTA', 'PARDEEP KUMAR', '7986824654', 'MALE'),
(3, 'AMRITSAR', 'GAH VERKA', 'JOBANBIR SINGH', '9501114510', 'MALE'),
(4, 'AMRITSAR', 'SWASTH KENDRA', 'RAMAN KUMAR', '9815456304', 'MALE'),
(5, 'AMRITSAR', 'UGGAR AULAKH', 'GURPREET SINGH', '7508263422', 'MALE'),
(6, 'AMRITSAR', 'PHERUMAAN', 'RACHHPAL SINGH', '8146820222', 'MALE'),
(7, 'AMRITSAR', 'G.N.D.UNIVERSITY', 'NANAK SINGH', '9855025333', 'MALE'),
(8, 'AMRITSAR', 'GAD MACHINANGAL', 'SHER SINGH', '9803209434', 'MALE'),
(9, 'AMRITSAR', 'SANGNA', 'AMAN KUMAR', '7986482137', 'MALE'),
(10, 'AMRITSAR', 'TAHLI SAHIB', 'ALLNEK BHAGAT', '9779789068', 'MALE'),
(11, 'BARNALA', 'GAD KHUDI KHURD', 'KULDEEP SINGH', '7814575277', 'MALE'),
(12, 'BATHINDA', 'AMARPURA', 'HARJINDER SINGH', '9915396213', 'MALE'),
(13, 'BATHINDA', 'MEHMA SARJA', 'RAM SINGH', '9781084112', 'MALE'),
(14, 'BATHINDA', 'DAN SINGH', 'HARISH JHANGRA', '9991674124', 'MALE'),
(15, 'BATHINDA', 'CHAK KHADAK SINGH WALA', 'INDER KUMAR', '9024941300', 'MALE'),
(16, 'BATHINDA', 'GAH BATHINDA', 'AMRINDER SINGH', '7986078838', 'MALE'),
(17, 'BATHINDA', 'BHAGIWANDER', 'AMANDEEP SINGH', '7888521245', 'MALE'),
(18, 'BATHINDA', 'KOT FATTA', 'MANDEEP SINGH', '9915273053', 'MALE'),
(19, 'BATHINDA', 'CHUMBA', 'GURTEJ SINGH', '9541728419', 'MALE'),
(20, 'BATHINDA', 'RAMPURA', 'ARJAN SINGH', '7719634451', 'MALE'),
(21, 'FARIDKOT', 'GOVT. AYURVEDIC SWASTH KENDRA FDK', 'VACANT', 'VACANT', ''),
(22, 'FARIDKOT', 'GAD AMBEDKAR NAGAR FDK', 'VACANT', 'VACANT', 'MALE'),
(23, 'FARIDKOT', 'GAD BARGARI', 'DAVINDER SINGH', '9988237757', 'MALE'),
(24, 'FARIDKOT', 'GAD PAKHI KALAN', 'AMARPRIT SINGH', '9577338000', 'MALE'),
(25, 'FATEHGARH SAHIB', 'KHAMANO KALAN', 'RANBIR SINGH', '9781312231', 'MALE'),
(26, 'FATEHGARH SAHIB', 'KHERI NODH SINGH', '', '', 'MALE'),
(27, 'FATEHGARH SAHIB', 'FAIZULLAPUR', '', '', 'MALE'),
(28, 'FATEHGARH SAHIB', 'DAULAT PUR', 'DEEPAK KUMAR', '9501131512', 'MALE'),
(29, 'FATEHGARH SAHIB', 'BRASS', 'JATINDER SINGH', '7814579867', 'MALE'),
(30, 'FATEHGARH SAHIB', 'RAILLON', 'HARJEET SINGH', '8360909126', 'MALE'),
(31, 'FATEHGARH SAHIB', 'SALANA JIWAN SINGH WALA', 'HARJIT SINGH', '9463407277', 'MALE'),
(32, 'FATEHGARH SAHIB', 'CHUNNI KALAN', 'JAGJEET SINGH', '9878551622', 'MALE'),
(33, 'FATEHGARH SAHIB', 'REOUNA', 'GAGANPREET SINGH', '9876195945', 'MALE'),
(34, 'FATEHGARH SAHIB', 'GAD SIRHIND MANDI', 'GAGANDEEP SHUKLA', '9872265003', 'MALE'),
(35, 'FAZILKA', 'GAD ABOHAR', 'ANKUR RINWA', '9530809695', 'MALE'),
(36, 'FAZILKA', 'GAD KALLER KHERA', 'MOHIT GODARA', '8058838573', 'MALE'),
(37, 'FAZILKA', 'GAD DHINGA WALI', 'VINOD KUMAR', '9872333634', 'MALE'),
(38, 'FAZILKA', 'GAD RAMGARH', 'PAWAN KUMAR', '9463851506', 'MALE'),
(39, 'FAZILKA', 'GAD CHURIWALA DHANA', 'PAWAN KUMAR', '9855929880', 'MALE'),
(40, 'FAZILKA', 'GAD DANEWALA SATKOSHI', 'RAMAN KUMAR', '8699650040', 'MALE'),
(41, 'FAZILKA', 'GAD SAPPAN WALI', 'RAJIV KUMAR', '9878394383', 'MALE'),
(42, 'FAZILKA', 'GAD RANA', 'KULWANT KUMAR', '9781977584', 'MALE'),
(43, 'FAZILKA', 'GAD CHAK ROOM WALA', '', '', 'MALE'),
(44, 'FEROZPUR', 'YARESHAH WALA', 'TARSEM SINGH', '7053980008', 'MALE'),
(45, 'FEROZPUR', 'CHUGATEWALA', 'BALWINDER SINGH', '9855984274', 'MALE'),
(46, 'FEROZPUR', 'SWASTH KENDRA BHADANA', 'VISHAL', '8437942313', 'MALE'),
(47, 'GURDASPUR', 'THANDOI', 'BIKRAMJIT SINGH', '9501611457', 'MALE'),
(48, 'GURDASPUR', 'SEKHA', 'DILPREET SINGH', '9780050147', 'MALE'),
(49, 'GURDASPUR', 'BABRI JIWAN WAL', 'NIKHIL', '6239137370', 'MALE'),
(50, 'GURDASPUR', 'NARPUR', 'RAJAN SHARMA', '6284613647', 'MALE'),
(51, 'GURDASPUR', 'MASSANIA', 'KARAN RAI', '8054195196', 'MALE'),
(52, 'GURDASPUR', 'DARGABAD', 'JOBANPREET SINGH', '9056877599', 'MALE'),
(53, 'GURDASPUR', 'PASNEWAL', 'HARPAL SINGH', '9814437679', 'MALE'),
(54, 'GURDASPUR', 'CHAK SHRIF', 'SUNIL KUMAR', '9780829388', 'MALE'),
(55, 'GURDASPUR', 'MARRIANWAL', 'ARSHDEEP SINGH', '9914358655', 'MALE'),
(56, 'GURDASPUR', 'BALPURIAN', 'MAHESHVER SINGH', '6284255981', 'MALE'),
(57, 'GURDASPUR', 'SWASTH KENDRA TALIBPUR PANDORI', 'BIKRAMJIT SINGH', '9914028321', 'MALE'),
(58, 'HOSHIARPUR', 'MONA KALAN', '', '', 'MALE'),
(59, 'HOSHIARPUR', 'GAH DATARPUR', 'JASHVIR SINGH', '8146398774', 'MALE'),
(60, 'HOSHIARPUR', 'BOHAN', 'HARPREET SINGH', '9814623964', 'MALE'),
(61, 'HOSHIARPUR', 'NANGAL VIHALA', 'AMANDEEP', '7710607101', 'MALE'),
(62, 'HOSHIARPUR', 'HARDOKHANPUR', '', '', 'MALE'),
(63, 'JALANDHAR', 'RASULPUR KALAN', 'SACHIN CHADHA', '9417593057', 'MALE'),
(64, 'JALANDHAR', 'KHANPUR DHADDA', 'HONEY CHADHA', '9417225625', 'MALE'),
(65, 'JALANDHAR', 'TAJPUR', 'JAGTAR SINGH', '9814804715', 'MALE'),
(66, 'JALANDHAR', 'TALWANDI MADHO', 'KULDEEP KUMAR', '7973612078', 'MALE'),
(67, 'JALANDHAR', 'NIJJRAN', 'ROHIT SHARMA', '8284922137', 'MALE'),
(68, 'JALANDHAR', 'PATARA', 'GOUTAM', '8146137459', 'MALE'),
(69, 'JALANDHAR', 'PARTABPURA', 'SHIV SHANKAR', '7696256513', 'MALE'),
(70, 'JALANDHAR', 'DUHRE', 'SURJEET KUMAR', '9592339350', 'MALE'),
(71, 'KAPURTHALA', 'GAD SIDHWA DONA', '', '', 'MALE'),
(72, 'KAPURTHALA', 'GAD MUSTAFABAD', '', '', 'MALE'),
(73, 'KAPURTHALA', 'GAD MANAK', '', '', 'MALE'),
(74, 'KAPURTHALA', 'GAD BAGHANA', '', '', 'MALE'),
(75, 'KAPURTHALA', 'GAD PALAHI', '', '', 'MALE'),
(76, 'KAPURTHALA', 'GAD PANDORI', '', '', 'MALE'),
(77, 'KAPURTHALA', 'GAD DHALIWAL BET', '', '', 'MALE'),
(78, 'LUDHIANA', 'KHANNA', 'VACANT', 'VACANT', 'MALE'),
(79, 'LUDHIANA', 'SUJAPUR', 'VACANT', 'VACANT', 'MALE'),
(80, 'LUDHIANA', 'BOPARAI KALAN', 'VACANT', 'VACANT', 'MALE'),
(81, 'LUDHIANA', 'BUDHEWAL', 'JAGROOP SINGH', '9878045513', 'MALE'),
(82, 'LUDHIANA', 'HEDONBET', 'RAGWINDER SINGH', '9914007813', 'MALE'),
(83, 'LUDHIANA', 'BHUTTA', 'VACANT', 'VACANT', 'MALE'),
(84, 'LUDHIANA', 'GAD SARABHA NAGAR', 'ARVIND CHAND', '7986523915', 'MALE'),
(85, 'LUDHIANA', 'SWASTH KENDRA JAGRAON', 'VACANT', 'VACANT', 'MALE'),
(86, 'LUDHIANA', 'GAD MUNDIAN KALAN', 'SUMIT ARORA', '9878965166', 'MALE'),
(87, 'LUDHIANA', 'GAD KHANPUR', 'YADWINDER SINGH', '7973789820', 'MALE'),
(88, 'LUDHIANA', 'GAD QILA HANS', 'GURMUKH SINGH', '9877194031', 'MALE'),
(89, 'LUDHIANA', 'GUD BULARA', 'VACANT', 'VACANT', 'MALE'),
(90, 'LUDHIANA', 'GAD SAHBANA', 'HARKIRAT SINGH', '8968048921', 'MALE'),
(91, 'MANSA', 'GAD MANSA', 'JASPREET SINGH', '9780311145', 'MALE'),
(92, 'MANSA', 'GAD JHUNIR', 'BHUPINDER SINGH', '9814974046', 'MALE'),
(93, 'MANSA', 'GAD CHAKERIAN', 'HARMANDEEP SINGH', '9888182116', 'MALE'),
(94, 'MANSA', 'GAD KARANDI', 'GURDIP SINGH', '7400470007', 'MALE'),
(95, 'MANSA', 'GAD RAIPUR', 'ASHOK KUMAR', '9478539322', 'MALE'),
(96, 'MOGA', 'BHINDERKALAN', '', '', 'MALE'),
(97, 'SAHIBZADA AJIT SINGH NAGAR', 'PH.9 MOHALI', 'BALJEET SINGH', '9814799963', 'MALE'),
(98, 'SAHIBZADA AJIT SINGH NAGAR', 'TEERA', 'AMIT KUMAR', '8837529608', 'MALE'),
(99, 'SAHIBZADA AJIT SINGH NAGAR', 'TASIMBLI', 'DAVINDER GOYAL', '8847359112', 'MALE'),
(100, 'SAHIBZADA AJIT SINGH NAGAR', 'GAD MULLANPUR', 'AVTAR SINGH', '9646952515', 'MALE'),
(101, 'MUKATSAR', 'GAD MUKATSAR SAHIB', 'GURBINDER SINGH', '7889090240', 'MALE'),
(102, 'MUKATSAR', 'GAD WARRING', 'KULWINDER SINGH', '7986312739', 'MALE'),
(103, 'PATHANKOT', 'GAD LEHROON', 'KARTIK MEHTA', '9878056326', 'MALE'),
(104, 'PATHANKOT', 'GAD LAHRIGUJJRA', 'SURESH KUMAR', '9417438862', 'MALE'),
(105, 'PATHANKOT', 'GAD CHHATWAL', 'SUNNY', '9877513978', 'MALE'),
(106, 'PATHANKOT', 'GAD BANI LODHI', 'LOVELY SHARMA', '7973853650', 'MALE'),
(107, 'PATHANKOT', 'GAD NAROT MEHRA', 'SHABAD KUMAR', '6280054773', 'MALE'),
(108, 'PATHANKOT', 'GAD DURANGKHAD', 'VACANT', '', 'MALE'),
(109, 'PATIALA', 'CHAMARU', 'VACANT', '', 'MALE'),
(110, 'PATIALA', 'CHAPPAR', 'BALKAR SINGH', '9878698166', 'MALE'),
(111, 'PATIALA', 'RAJPURA', 'SAHIL', '9814032589', 'MALE'),
(112, 'PATIALA', 'NABHA', 'HEMANT KUMAR', '9517923752', 'MALE'),
(113, 'PATIALA', 'SEONA', 'AMAN SINGH', '6284487398', 'MALE'),
(114, 'PATIALA', 'KARHALI', 'MUNNA SINGH', '6284095850', 'MALE'),
(115, 'PATIALA', 'MADAUR', 'HARPREET SINGH', '9256526450', 'MALE'),
(116, 'PATIALA', 'SHERMAJRA', 'MANNA RAM', '9781186194', 'MALE'),
(117, 'PATIALA', 'KHERAGAJJU', 'GURPREET SINGH', '9781791842', 'MALE'),
(118, 'PATIALA', 'GAD MALLEHWAL', 'VACANT', '', 'MALE'),
(119, 'PATIALA', 'GAD BEHAR JACH', 'AMANDEEP RAM', '6284970676', 'MALE'),
(120, 'ROPAR', 'BAJRUR', 'JIWAN KUMAR', '7526994851', 'MALE'),
(121, 'ROPAR', 'BUNGA SAAB', '', '', 'MALE'),
(122, 'ROPAR', 'HARIPUR', 'RUPINDER SINGH', '7307627640', 'MALE'),
(123, 'ROPAR', 'BHATHA SAAB', '', '', 'MALE'),
(124, 'ROPAR', 'BAMNARA', '', '', 'MALE'),
(125, 'ROPAR', 'MATOUR', 'ARSHVIR SINGH', '8968782099', 'MALE'),
(126, 'ROPAR', 'TALWARA', '', '', 'MALE'),
(127, 'ROPAR', 'GAD MASSEWAL', '', '', 'MALE'),
(128, 'ROPAR', 'BAN MAJRA', '', '', 'MALE'),
(129, 'ROPAR', 'GAD BHANGAL', '', '', 'MALE'),
(130, 'ROPAR', 'GAD BHABOR SAHIB', '', '', 'MALE'),
(131, 'ROPAR', 'GAD BHNUPALI', '', '', 'MALE'),
(132, 'SANGRUR', 'BARDWAL', '', '', 'MALE'),
(133, 'SANGRUR', 'BHARO', 'SUNIL KUMAR', '9517087885', 'MALE'),
(134, 'SANGRUR', 'KANAKWAL BHANGUA', '', '', 'MALE'),
(135, 'SANGRUR', 'G.A.D. SANGRUR', 'SAMUNDER SINGH', '8544795404', 'MALE'),
(136, 'SANGRUR', 'G.A.D. ROHIRA', '', '', 'MALE'),
(137, 'SANGRUR', 'MEHLAN', 'HARWINDER SINGH', '9781237511', 'MALE'),
(138, 'SANGRUR', 'BHAWANI GARH', 'SOURAV AGNIHOTRI', '7009771309', 'MALE'),
(139, 'SANGRUR', 'GOVT. AYU. SWASTH KENDRA KAHANGARH', 'GURUSAV SINGH', '8968104981', 'MALE'),
(140, 'SBS NAGAR', 'SIKOHPUR', '', '', 'MALE'),
(141, 'SBS NAGAR', 'BEHRAM', '', '', 'MALE'),
(142, 'SBS NAGAR', 'MAJARI', '', '', 'MALE'),
(143, 'SBS NAGAR', 'BRAMAD', '', '', 'MALE'),
(144, 'SBS NAGAR', 'GAD KAMAM', 'VINAY KUMAR', '9464727125', 'MALE'),
(145, 'SBS NAGAR', 'GAD GUNACHAUR', '', '', 'MALE'),
(146, 'TARN TARAN', 'GAD CHUSEWAL', 'VACANT', '', 'MALE'),
(147, 'TARN TARAN', 'GAD SARLI KALAN', 'VACANT', '', 'MALE'),
(148, 'TARN TARAN', 'GAD KANG', 'AMRITPAL SINGH', '8968667336', 'MALE'),
(149, 'TARN TARAN', 'GAD SHEKH', 'VACANT', '', 'MALE'),
(150, 'TARN TARAN', 'GAD MANOCHAHAL', 'SAJANPREET SINGH', '7719703766', 'MALE'),
(151, 'LUDHIANA', 'GHD SAHNEWAL', 'HARPREET SINGH', '9041237006', 'MALE'),
(152, 'LUDHIANA', 'GHD JAGRAON', 'VACANT', 'VACANT', 'MALE'),
(153, 'LUDHIANA', 'GHD KOHARA', 'JAINVEER', '8568917498', 'MALE'),
(154, 'LUDHIANA', 'GHD MACHIWARA', 'VACANT', 'VACANT', 'MALE'),
(155, 'SANGRUR', 'GHD NADAMPUR', 'MANJIT SINGH', '9872434634', 'MALE'),
(156, 'SAHIBZADA AJIT SINGH NAGAR', 'GHD, SECTOR39 CHD', 'SAPINDER PAL SINGH', '8528889346', 'MALE'),
(157, 'GURDASPUR', 'GHD RANJIT BAGH GURDASPUR', 'GURPAL SINGH', '7814163558', 'MALE'),
(158, 'TARAN TARAN', 'GHD KHADOOR SAHIB', 'DILBAG SINGH', '9915298467', 'MALE'),
(159, 'AMRITSAR', 'CHAPPA RAM SINGH', 'VACANT POST', '', 'FEMALE'),
(160, 'AMRITSAR', 'CHEHARRATTA', 'VACANT POST', '', 'FEMALE'),
(161, 'AMRITSAR', 'GAH VERKA', 'PRIYANKA', '8360863224', 'FEMALE'),
(162, 'AMRITSAR', 'SWASTH KENDRA', 'VACANT POST', '', 'FEMALE'),
(163, 'AMRITSAR', 'UGGAR AULAKH', 'KOMALPREET KAUR', '9781958179', 'FEMALE'),
(164, 'AMRITSAR', 'PHERUMAAN', 'VACANT POST', '', 'FEMALE'),
(165, 'AMRITSAR', 'G.N.D.UNIVERSITY', 'VACANT POST', '', 'FEMALE'),
(166, 'AMRITSAR', 'GAD MACHINANGAL', 'VACANT POST', '', 'FEMALE'),
(167, 'AMRITSAR', 'SANGNA', 'VACANT POST', '', 'FEMALE'),
(168, 'AMRITSAR', 'TAHLI SAHIB', 'VACANT POST', '', 'FEMALE'),
(169, 'BARNALA', 'GAD KHUDI KHURD', 'AARTI SHARMA', '8556981678', 'FEMALE'),
(170, 'BATHINDA', 'AMARPURA', 'NEETU BANSAL', '7307600074', 'FEMALE'),
(171, 'BATHINDA', 'MEHMA SARJA', 'BHUPINDER KAUR', '9056776559', 'FEMALE'),
(172, 'BATHINDA', 'DAN SINGH', 'VEERPAL KAUR', '7717615146', 'FEMALE'),
(173, 'BATHINDA', 'CHAK KHADAK SINGH WALA', 'AMANDEEP KAUR', '8699840331', 'FEMALE'),
(174, 'BATHINDA', 'GAH BATHINDA', 'AMRITPAL KAUR', '8264411679', 'FEMALE'),
(175, 'BATHINDA', 'BHAGIWANDER', 'SONIA RANI', '7986671945', 'FEMALE'),
(176, 'BATHINDA', 'KOT FATTA', 'AKO RANI', '7973668390', 'FEMALE'),
(177, 'BATHINDA', 'CHUMBA', 'NEELAM SHARMA', '9815190968', 'FEMALE'),
(178, 'BATHINDA', 'RAMPURA', 'JASMEEN SHARMA', '7307670006', 'FEMALE'),
(179, 'FARIDKOT', 'GOVT. AYURVEDIC SWASTH KENDRA FDK', 'VACANT', '', 'FEMALE'),
(180, 'FARIDKOT', 'GAD AMBEDKAR NAGAR FDK', 'VACANT', '', 'FEMALE'),
(181, 'FARIDKOT', 'GAD BARGARI', 'VACANT', '', 'FEMALE'),
(182, 'FARIDKOT', 'GAD PAKHI KALAN', 'AMANDEEP KAUR', '6280771445', 'FEMALE'),
(183, 'FATEHGARH SAHIB', 'KHAMANO KALAN', '', '', 'FEMALE'),
(184, 'FATEHGARH SAHIB', 'KHERI NODH SINGH', 'NARINDER KAUR', '9041244459', 'FEMALE'),
(185, 'FATEHGARH SAHIB', 'FAIZULLAPUR', 'JASWINDER KAUR', '8283971401', 'FEMALE'),
(186, 'FATEHGARH SAHIB', 'DAULAT PUR', 'KULWANT KAUR', '9417443370', 'FEMALE'),
(187, 'FATEHGARH SAHIB', 'BRASS', '', '', 'FEMALE'),
(188, 'FATEHGARH SAHIB', 'RAILLON', 'MARJEENA', '7347413086', 'FEMALE'),
(189, 'FATEHGARH SAHIB', 'SALANA JIWAN SINGH WALA', 'GAGANDEEP KAUR', '6280252040', 'FEMALE'),
(190, 'FATEHGARH SAHIB', 'CHUNNI KALAN', 'MUKTA RANI', '9878123348', 'FEMALE'),
(191, 'FATEHGARH SAHIB', 'REOUNA', 'KULVINDER KAUR', '6284724486', 'FEMALE'),
(192, 'FATEHGARH SAHIB', 'GAD SIRHIND MANDI', 'MANPREET KAUR', '9501917537', 'FEMALE'),
(193, 'FAZILKA', 'GAD ABOHAR', 'RUCHIKA', '8699631583', 'FEMALE'),
(194, 'FAZILKA', 'GAD KALLER KHERA', 'SHALLU BISHNOI', '7878529290', 'FEMALE'),
(195, 'FAZILKA', 'GAD DHINGA WALI', 'NISHU', '9116716400', 'FEMALE'),
(196, 'FAZILKA', 'GAD RAMGARH', 'AINA', '7717445389', 'FEMALE'),
(197, 'FAZILKA', 'GAD CHURIWALA DHANA', 'SHAKUNTLA', '9478121983', 'FEMALE'),
(198, 'FAZILKA', 'GAD DANEWALA SATKOSHI', '', '', 'FEMALE'),
(199, 'FAZILKA', 'GAD SAPPAN WALI', 'MANJEET KAUR', '9115756008', 'FEMALE'),
(200, 'FAZILKA', 'GAD RANA', 'NEETU RANI', '7837273436', 'FEMALE'),
(201, 'FAZILKA', 'GAD CHAK ROOM WALA', 'SIMRAN', '9914346281', 'FEMALE'),
(202, 'FEROZPUR', 'YARESHAH WALA', 'NEERU RANI', '6280284050', 'FEMALE'),
(203, 'FEROZPUR', 'CHUGATEWALA', 'KIRAN RANI', '9914686187', 'FEMALE'),
(204, 'FEROZPUR', 'SWASTH KENDRA BHADANA', 'NEETU BHATIA', '6239652120', 'FEMALE'),
(205, 'GURDASPUR', 'THANDOI', 'MANDEEP KAUR', '9878029803', 'FEMALE'),
(206, 'GURDASPUR', 'SEKHA', 'PAVITERJIT KAUR', '6283828170', 'FEMALE'),
(207, 'GURDASPUR', 'BABRI JIWAN WAL', 'SANDEEP KAUR', '9780021106', 'FEMALE'),
(208, 'GURDASPUR', 'NARPUR', 'MANDIP KAUR', '6280043431', 'FEMALE'),
(209, 'GURDASPUR', 'MASSANIA', 'PAWANPREET KAUR', '9872758566', 'FEMALE'),
(210, 'GURDASPUR', 'DARGABAD', 'JASPINDER KAUR', '6006016073', 'FEMALE'),
(211, 'GURDASPUR', 'PASNEWAL', 'NAVDEEP KAUR', '8968275641', 'FEMALE'),
(212, 'GURDASPUR', 'CHAK SHRIF', 'SIMRANJIT KAUR', '9915072383', 'FEMALE'),
(213, 'GURDASPUR', 'MARRIANWAL', 'MONIKA', '6239546872', 'FEMALE'),
(214, 'GURDASPUR', 'BALPURIAN', 'GUNEET KAUR', '7009941655', 'FEMALE'),
(215, 'GURDASPUR', 'SWASTH KENDRA TALIBPUR PANDORI', 'MEENAKSHI', '6280537566', 'FEMALE'),
(216, 'HOSHIARPUR', 'MONA KALAN', '', '', 'FEMALE'),
(217, 'HOSHIARPUR', 'GAH DATARPUR', '', '', 'FEMALE'),
(218, 'HOSHIARPUR', 'BOHAN', 'KASHMIR KAUR', '7589082319', 'FEMALE'),
(219, 'HOSHIARPUR', 'NANGAL VIHALA', 'RAMA SAGAR', '8437149925', 'FEMALE'),
(220, 'HOSHIARPUR', 'HARDOKHANPUR', 'KANCHAN', '7973849562', 'FEMALE'),
(221, 'JALANDHAR', 'RASULPUR KALAN', '', '', 'FEMALE'),
(222, 'JALANDHAR', 'KHANPUR DHADDA', '', '', 'FEMALE'),
(223, 'JALANDHAR', 'TAJPUR', 'NITIKA PURBA', '9780040027', 'FEMALE'),
(224, 'JALANDHAR', 'TALWANDI MADHO', '', '', 'FEMALE'),
(225, 'JALANDHAR', 'NIJJRAN', 'SARITA MALHOTRA', '8360018331', 'FEMALE'),
(226, 'JALANDHAR', 'PATARA', 'ANURADHA', '9988484343', 'FEMALE'),
(227, 'JALANDHAR', 'PARTABPURA', 'GEETANJALI', '9478373575', 'FEMALE'),
(228, 'JALANDHAR', 'DUHRE', 'PARMINDER DUTTA', '9582122851', 'FEMALE'),
(229, 'KAPURTHALA', 'GAD SIDHWA DONA', '', '', 'FEMALE'),
(230, 'KAPURTHALA', 'GAD MUSTAFABAD', 'MEENA KUMARI', '7973249548', 'FEMALE'),
(231, 'KAPURTHALA', 'GAD MANAK', '', '', 'FEMALE'),
(232, 'KAPURTHALA', 'GAD BAGHANA', '', '', 'FEMALE'),
(233, 'KAPURTHALA', 'GAD PALAHI', 'ANJU BALA', '8793330426', 'FEMALE'),
(234, 'KAPURTHALA', 'GAD PANDORI', '', '', 'FEMALE'),
(235, 'KAPURTHALA', 'GAD DHALIWAL BET', '', '', 'FEMALE'),
(236, 'LUDHIANA', 'KHANNA', 'VACANT', 'VACANT', 'FEMALE'),
(237, 'LUDHIANA', 'SUJAPUR', 'VACANT', 'VACANT', 'FEMALE'),
(238, 'LUDHIANA', 'BOPARAI KALAN', 'JASWINDER KAUR', '6239027831', 'FEMALE'),
(239, 'LUDHIANA', 'BUDHEWAL', 'VACANT', 'VACANT', 'FEMALE'),
(240, 'LUDHIANA', 'HEDONBET', 'VACANT', 'VACANT', 'FEMALE'),
(241, 'LUDHIANA', 'BHUTTA', 'RAJPAL KAUR', '', 'FEMALE'),
(242, 'LUDHIANA', 'GAD SARABHA NAGAR', 'PRIYA', '8544810317', 'FEMALE'),
(243, 'LUDHIANA', 'SWASTH KENDRA JAGRAON', 'VACANT', 'VACANT', 'FEMALE'),
(244, 'LUDHIANA', 'GAD MUNDIAN KALAN', 'VACANT', 'VACANT', 'FEMALE'),
(245, 'LUDHIANA', 'GAD KHANPUR', 'VACANT', 'VACANT', 'FEMALE'),
(246, 'LUDHIANA', 'GAD QILA HANS', 'KULVINDER KAUR', '9878426891', 'FEMALE'),
(247, 'LUDHIANA', 'GUD BULARA', 'NISHA SHARMA', '9779250894', 'FEMALE'),
(248, 'LUDHIANA', 'GAD SAHBANA', 'VACANT', 'VACANT', 'FEMALE'),
(249, 'MANSA', 'GAD MANSA', 'GURPREET KAUR', '9815289522', 'FEMALE'),
(250, 'MANSA', 'GAD JHUNIR', 'GEETA', '9646326487', 'FEMALE'),
(251, 'MANSA', 'GAD CHAKERIAN', 'KUMARI INDERWATI', '9888434384', 'FEMALE'),
(252, 'MANSA', 'GAD KARANDI', 'AMISHA', '6239731474', 'FEMALE'),
(253, 'MANSA', 'GAD RAIPUR', 'SUKHPAL KAUR', '7986117393', 'FEMALE'),
(254, 'MOGA', 'BHINDERKALAN', 'GAGANDEEP KAUR', '6280323230', 'FEMALE'),
(255, 'SAHIBZADA AJIT SINGH NAGAR', 'PH.9 MOHALI', 'KAVITA', '9855911369', 'FEMALE'),
(256, 'SAHIBZADA AJIT SINGH NAGAR', 'TEERA', 'POOJA SENGER', '8699010815', 'FEMALE'),
(257, 'SAHIBZADA AJIT SINGH NAGAR', 'TASIMBLI', 'RAMANDEEP KAUR', '9056861921', 'FEMALE'),
(258, 'SAHIBZADA AJIT SINGH NAGAR', 'GAD MULLANPUR', 'INDU RANA', '9992000172', 'FEMALE'),
(259, 'MUKATSAR', 'GAD MUKATSAR SAHIB', 'JASPREET KAUR', '9465151897', 'FEMALE'),
(260, 'MUKATSAR', 'GAD WARRING', 'MANDEEP KAUR', '7814413282', 'FEMALE'),
(261, 'PATHANKOT', 'GAD LEHROON', 'ANUDEEP', '6283186617', 'FEMALE'),
(262, 'PATHANKOT', 'GAD LAHRIGUJJRA', 'VACANT', '', 'FEMALE'),
(263, 'PATHANKOT', 'GAD CHHATWAL', 'RAJNI BHARDWAJ', '9876246001', 'FEMALE'),
(264, 'PATHANKOT', 'GAD BANI LODHI', 'VANDANA MAHAJAN', '8427346434', 'FEMALE'),
(265, 'PATHANKOT', 'GAD NAROT MEHRA', 'DEEPALI', '7087095312', 'FEMALE'),
(266, 'PATHANKOT', 'GAD DURANGKHAD', 'MONIKA MAHAJAN', '9988595532', 'FEMALE'),
(267, 'PATIALA', 'CHAMARU', 'VACANT', '', 'FEMALE'),
(268, 'PATIALA', 'CHAPPAR', 'MANPREET KAUR', '8837863083', 'FEMALE'),
(269, 'PATIALA', 'RAJPURA', 'PRABHSIMRAN', '7986913153', 'FEMALE'),
(270, 'PATIALA', 'NABHA', 'CHERRY SHARMA', '9465679490', 'FEMALE'),
(271, 'PATIALA', 'SEONA', 'JASHANJOT KAUR', '6280414906', 'FEMALE'),
(272, 'PATIALA', 'KARHALI', 'SARITA RANI', '6280070757', 'FEMALE'),
(273, 'PATIALA', 'MADAUR', 'KIRANDEEP MASTANA', '6283772296', 'FEMALE'),
(274, 'PATIALA', 'SHERMAJRA', 'ANU SHARMA', '9915977905', 'FEMALE'),
(275, 'PATIALA', 'KHERAGAJJU', 'POOJA DHIMAN', '8727000743', 'FEMALE'),
(276, 'PATIALA', 'GAD MALLEHWAL', 'GURDEEP KAUR', '7837033057', 'FEMALE'),
(277, 'PATIALA', 'GAD BEHAR JACH', 'SEEMA DEVI', '7710406402', 'FEMALE'),
(278, 'ROPAR', 'BAJRUR', 'MANPREET KAUR', '9501429313', 'FEMALE'),
(279, 'ROPAR', 'BUNGA SAAB', 'SONI DEVI', '8360505003', 'FEMALE'),
(280, 'ROPAR', 'HARIPUR', '', '', 'FEMALE'),
(281, 'ROPAR', 'BHATHA SAAB', 'HARMANPREET KAUR', '9876512902', 'FEMALE'),
(282, 'ROPAR', 'BAMNARA', '', '', 'FEMALE'),
(283, 'ROPAR', 'MATOUR', 'NAVITA RANI', '7814087901', 'FEMALE'),
(284, 'ROPAR', 'TALWARA', '', '', 'FEMALE'),
(285, 'ROPAR', 'GAD MASSEWAL', '', '', 'FEMALE'),
(286, 'ROPAR', 'BAN MAJRA', '', '', 'FEMALE'),
(287, 'ROPAR', 'GAD BHANGAL', 'SAKSHI VERMA', '6284758079', 'FEMALE'),
(288, 'ROPAR', 'GAD BHABOR SAHIB', '', '', 'FEMALE'),
(289, 'ROPAR', 'GAD BHNUPALI', 'MANDEEP KAUR', '9417821088', 'FEMALE'),
(290, 'SANGRUR', 'BARDWAL', 'GURPREET KAUR', '9465943953', 'FEMALE'),
(291, 'SANGRUR', 'BHARO', 'SUKHWINDER KAUR', '7717353021', 'FEMALE'),
(292, 'SANGRUR', 'KANAKWAL BHANGUA', '', '', 'FEMALE'),
(293, 'SANGRUR', 'G.A.D. SANGRUR', 'HARMANDERP SINGH', '9878658501', 'FEMALE'),
(294, 'SANGRUR', 'G.A.D. ROHIRA', 'CHAMANPREET KAUR', '9814843805', 'FEMALE'),
(295, 'SANGRUR', 'MEHLAN', '', '', 'FEMALE'),
(296, 'SANGRUR', 'BHAWANI GARH', 'SHEHNAZ', '8437782418', 'FEMALE'),
(297, 'SANGRUR', 'GOVT. AYU. SWASTH KENDRA KAHANGARH', 'SANTOSH DEVI', '9815674164', 'FEMALE'),
(298, 'SBS NAGAR', 'SIKOHPUR', '', '', 'FEMALE'),
(299, 'SBS NAGAR', 'BEHRAM', '', '', 'FEMALE'),
(300, 'SBS NAGAR', 'MAJARI', 'RAMANA PAUL', '7009635895', 'FEMALE'),
(301, 'SBS NAGAR', 'BRAMAD', 'SIMRAN', '6283697889', 'FEMALE'),
(302, 'SBS NAGAR', 'GAD KAMAM', 'Testing Instructor 2', '9258116678', 'FEMALE'),
(303, 'SBS NAGAR', 'GAD GUNACHAUR', '', '', 'FEMALE'),
(304, 'TARN TARAN', 'GAD CHUSEWAL', 'VACANT', '', 'FEMALE'),
(305, 'TARN TARAN', 'GAD SARLI KALAN', 'VACANT', '', 'FEMALE'),
(306, 'TARN TARAN', 'GAD KANG', 'KIRAN', '9041811156', 'FEMALE'),
(307, 'TARN TARAN', 'GAD SHEKH', 'NISHA KUMARI', '8264356785', 'FEMALE'),
(308, 'TARN TARAN', 'GAD MANOCHAHAL', 'BALJIT KAUR', '7087677375', 'FEMALE'),
(309, 'LUDHIANA', 'GHD SAHNEWAL', 'RANJNA PANDAY', '7717313012', 'FEMALE'),
(310, 'LUDHIANA', 'GHD JAGRAON', 'VACANT', 'VACANT', 'FEMALE'),
(311, 'LUDHIANA', 'GHD KOHARA', 'VACANT', 'VACANT', 'FEMALE'),
(312, 'LUDHIANA', 'GHD MACHIWARA', 'VACANT', 'VACANT', 'FEMALE'),
(313, 'SANGRUR', 'GHD NADAMPUR', 'ROOBALPREET KAUR', '6239014048', 'FEMALE'),
(314, 'SAHIBZADA AJIT SINGH NAGAR', 'GHD, SECTOR39 CHD', 'MINAKSHI', '8699269108', 'FEMALE'),
(315, 'GURDASPUR', 'GHD RANJIT BAGH GURDASPUR', 'DIKSHA', '6283401650', 'FEMALE'),
(316, 'TARAN TARAN', 'GHD KHADOOR SAHIB', 'RUPINDER KAUR', '9478691755', 'FEMALE'),
(317, 'CHANDIGARH', 'NHM PUNJAB', 'YOGA TESTING', '9058788862', 'MALE'),
(318, 'District1', 'HWC1', 'Instructor Name', '1234567890', 'Male');

--
-- Triggers `yoga_instructors`
--
DELIMITER $$
CREATE TRIGGER `before_yoga_instructor_insert` BEFORE INSERT ON `yoga_instructors` FOR EACH ROW BEGIN
  SET NEW.yoga_instructor_id = NEW.id;
END
$$
DELIMITER ;

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

--
-- Table structure for table `yog_sessions`
--

CREATE TABLE `yog_sessions` (
  `id` int(11) NOT NULL,
  `session_name` varchar(255) NOT NULL,
  `yoga_instructor_id` int(11) DEFAULT NULL,
  `session_type` varchar(255) NOT NULL,
  `include_iec_activity` tinyint(1) NOT NULL,
  `batch_type` varchar(255) NOT NULL,
  `batch_frequency` varchar(255) NOT NULL,
  `time_slot` varchar(255) NOT NULL,
  `asanas` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `session_status` varchar(255) NOT NULL,
  `participant_number` int(11) DEFAULT NULL,
  `session_date` date DEFAULT NULL,
  `Below_16_years` int(11) DEFAULT 0,
  `Between_16_to_60_years` int(11) DEFAULT 0,
  `Above_60_years` int(11) DEFAULT 0,
  `Male` int(11) DEFAULT 0,
  `Female` int(11) DEFAULT 0,
  `other` int(11) DEFAULT NULL,
  `Session_Image` varchar(255) DEFAULT NULL,
  `Capture_Live_Location` varchar(255) DEFAULT NULL,
  `session_venue` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `yog_sessions`
--

INSERT INTO `yog_sessions` (`id`, `session_name`, `yoga_instructor_id`, `session_type`, `include_iec_activity`, `batch_type`, `batch_frequency`, `time_slot`, `asanas`, `created_at`, `session_status`, `participant_number`, `session_date`, `Below_16_years`, `Between_16_to_60_years`, `Above_60_years`, `Male`, `Female`, `other`, `Session_Image`, `Capture_Live_Location`, `session_venue`) VALUES
(1, 'test yog ', 317, 'Community', 1, 'Morning', 'Daily', '1:00 PM to 2:00 PM', '[\"Sitting Asana - Sukhasana\",\"Sitting Asana - Samasana\",\"Sitting Asana - Swastikasana\"]', '2024-08-01 08:27:44', 'complete', 10, '2024-08-01', 3, 6, 1, 4, 2, 4, '[]', NULL, 'NHM Punjab'),
(2, 'morning yoga', 317, 'School', 1, 'Morning', 'Daily', '4:00 PM to 5:00 PM', '[\"Sitting Asana - Samasana\",\"Sitting Asana - Sukhasana\",\"Sitting Asana - Gokilasana\",\"Sitting Asana - Ardha Padmasana\",\"Sitting Asana - Karmasukhasana\",\"Sitting Asana - Utthita Padmasana\"]', '2024-08-01 08:46:28', 'complete', 10, '2024-08-01', 3, 5, 2, 5, 3, 2, '[]', '30.7463083,76.7519117', 'NHM Punjab'),
(3, 'test by two', 302, 'Community', 1, 'Morning', 'Daily', '4:00 PM to 5:00 PM', NULL, '2024-08-05 10:13:01', 'pending', NULL, '2024-08-06', 0, 0, 0, 0, 0, NULL, NULL, NULL, 'NHm 2'),
(4, 'test yog 2', 302, 'Community', 1, 'Morning', 'Daily', '12:00 PM to 1:00 PM', '[\"Sitting Asana - Swastikasana\",\"Sitting Asana - Gokilasana\",\"Sitting Asana - Padmasana\"]', '2024-08-05 18:56:40', 'complete', 10, '2024-08-06', 2, 8, 0, 2, 7, 1, '[]', '30.7463083,76.7519117', 'NHM 2'),
(5, 'Hi testing 2', 302, 'Community', 1, 'Morning', 'Daily', '2:00 PM to 3:00 PM', '[\"Sitting Asana - Swastikasana\",\"Sitting Asana - Samasana\",\"Sitting Asana - Sukhasana\",\"Sitting Asana - Kshemasana\"]', '2024-08-08 11:11:12', 'complete', 10, '2024-08-08', 1, 8, 1, 4, 4, 2, '[]', '30.7463083,76.7519117', 'Testing 2'),
(6, 'test yog one', 317, 'HWC', 1, 'Morning', 'Daily', '10:00 AM to 11:00 AM', NULL, '2024-08-09 05:17:52', 'pending', NULL, '2024-08-09', 0, 0, 0, 0, 0, NULL, NULL, NULL, 'NHM facility');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `DistrictOfficers`
--
ALTER TABLE `DistrictOfficers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `facility_officer`
--
ALTER TABLE `facility_officer`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `state_login_officers`
--
ALTER TABLE `state_login_officers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `yoga_instructors`
--
ALTER TABLE `yoga_instructors`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `yog_sessions`
--
ALTER TABLE `yog_sessions`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `DistrictOfficers`
--
ALTER TABLE `DistrictOfficers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `facility_officer`
--
ALTER TABLE `facility_officer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=160;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `state_login_officers`
--
ALTER TABLE `state_login_officers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `yoga_instructors`
--
ALTER TABLE `yoga_instructors`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=319;

--
-- AUTO_INCREMENT for table `yog_sessions`
--
ALTER TABLE `yog_sessions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

