(70571,'Z3403','Encounter for supervision of normal first pregnancy, third trimester',NULL,NULL),
(70572,'Z3480','Encounter for supervision of other normal pregnancy, unspecified trimester',NULL,NULL),
(70573,'Z3481','Encounter for supervision of other normal pregnancy, first trimester',NULL,NULL),
(70574,'Z3482','Encounter for supervision of other normal pregnancy, second trimester',NULL,NULL),
(70575,'Z3483','Encounter for supervision of other normal pregnancy, third trimester',NULL,NULL),
(70576,'Z3490','Encounter for supervision of normal pregnancy, unspecified, unspecified trimester',NULL,NULL),
(70577,'Z3491','Encounter for supervision of normal pregnancy, unspecified, first trimester',NULL,NULL),
(70578,'Z3492','Encounter for supervision of normal pregnancy, unspecified, second trimester',NULL,NULL),
(70579,'Z3493','Encounter for supervision of normal pregnancy, unspecified, third trimester',NULL,NULL),
(70580,'Z36','Encounter for antenatal screening of mother',NULL,NULL),
(70581,'Z3A00','Weeks of gestation of pregnancy not specified',NULL,NULL),
(70582,'Z3A01','Less than 8 weeks gestation of pregnancy',NULL,NULL),
(70583,'Z3A08','8 weeks gestation of pregnancy',NULL,NULL),
(70584,'Z3A09','9 weeks gestation of pregnancy',NULL,NULL),
(70585,'Z3A10','10 weeks gestation of pregnancy',NULL,NULL),
(70586,'Z3A11','11 weeks gestation of pregnancy',NULL,NULL),
(70587,'Z3A12','12 weeks gestation of pregnancy',NULL,NULL),
(70588,'Z3A13','13 weeks gestation of pregnancy',NULL,NULL),
(70589,'Z3A14','14 weeks gestation of pregnancy',NULL,NULL),
(70590,'Z3A15','15 weeks gestation of pregnancy',NULL,NULL),
(70591,'Z3A16','16 weeks gestation of pregnancy',NULL,NULL),
(70592,'Z3A17','17 weeks gestation of pregnancy',NULL,NULL),
(70593,'Z3A18','18 weeks gestation of pregnancy',NULL,NULL),
(70594,'Z3A19','19 weeks gestation of pregnancy',NULL,NULL),
(70595,'Z3A20','20 weeks gestation of pregnancy',NULL,NULL),
(70596,'Z3A21','21 weeks gestation of pregnancy',NULL,NULL),
(70597,'Z3A22','22 weeks gestation of pregnancy',NULL,NULL),
(70598,'Z3A23','23 weeks gestation of pregnancy',NULL,NULL),
(70599,'Z3A24','24 weeks gestation of pregnancy',NULL,NULL),
(70600,'Z3A25','25 weeks gestation of pregnancy',NULL,NULL),
(70601,'Z3A26','26 weeks gestation of pregnancy',NULL,NULL),
(70602,'Z3A27','27 weeks gestation of pregnancy',NULL,NULL),
(70603,'Z3A28','28 weeks gestation of pregnancy',NULL,NULL),
(70604,'Z3A29','29 weeks gestation of pregnancy',NULL,NULL),
(70605,'Z3A30','30 weeks gestation of pregnancy',NULL,NULL),
(70606,'Z3A31','31 weeks gestation of pregnancy',NULL,NULL),
(70607,'Z3A32','32 weeks gestation of pregnancy',NULL,NULL),
(70608,'Z3A33','33 weeks gestation of pregnancy',NULL,NULL),
(70609,'Z3A34','34 weeks gestation of pregnancy',NULL,NULL),
(70610,'Z3A35','35 weeks gestation of pregnancy',NULL,NULL),
(70611,'Z3A36','36 weeks gestation of pregnancy',NULL,NULL),
(70612,'Z3A37','37 weeks gestation of pregnancy',NULL,NULL),
(70613,'Z3A38','38 weeks gestation of pregnancy',NULL,NULL),
(70614,'Z3A39','39 weeks gestation of pregnancy',NULL,NULL),
(70615,'Z3A40','40 weeks gestation of pregnancy',NULL,NULL),
(70616,'Z3A41','41 weeks gestation of pregnancy',NULL,NULL),
(70617,'Z3A42','42 weeks gestation of pregnancy',NULL,NULL),
(70618,'Z3A49','Greater than 42 weeks gestation of pregnancy',NULL,NULL),
(70619,'Z370','Single live birth',NULL,NULL),
(70620,'Z371','Single stillbirth',NULL,NULL),
(70621,'Z372','Twins, both liveborn',NULL,NULL),
(70622,'Z373','Twins, one liveborn and one stillborn',NULL,NULL),
(70623,'Z374','Twins, both stillborn',NULL,NULL),
(70624,'Z3750','Multiple births, unspecified, all liveborn',NULL,NULL),
(70625,'Z3751','Triplets, all liveborn',NULL,NULL),
(70626,'Z3752','Quadruplets, all liveborn',NULL,NULL),
(70627,'Z3753','Quintuplets, all liveborn',NULL,NULL),
(70628,'Z3754','Sextuplets, all liveborn',NULL,NULL),
(70629,'Z3759','Other multiple births, all liveborn',NULL,NULL),
(70630,'Z3760','Multiple births, unspecified, some liveborn',NULL,NULL),
(70631,'Z3761','Triplets, some liveborn',NULL,NULL),
(70632,'Z3762','Quadruplets, some liveborn',NULL,NULL),
(70633,'Z3763','Quintuplets, some liveborn',NULL,NULL),
(70634,'Z3764','Sextuplets, some liveborn',NULL,NULL),
(70635,'Z3769','Other multiple births, some liveborn',NULL,NULL),
(70636,'Z377','Other multiple births, all stillborn',NULL,NULL),
(70637,'Z379','Outcome of delivery, unspecified',NULL,NULL),
(70638,'Z3800','Single liveborn infant, delivered vaginally',NULL,NULL),
(70639,'Z3801','Single liveborn infant, delivered by cesarean',NULL,NULL),
(70640,'Z381','Single liveborn infant, born outside hospital',NULL,NULL),
(70641,'Z382','Single liveborn infant, unspecified as to place of birth',NULL,NULL),
(70642,'Z3830','Twin liveborn infant, delivered vaginally',NULL,NULL),
(70643,'Z3831','Twin liveborn infant, delivered by cesarean',NULL,NULL),
(70644,'Z384','Twin liveborn infant, born outside hospital',NULL,NULL),
(70645,'Z385','Twin liveborn infant, unspecified as to place of birth',NULL,NULL),
(70646,'Z3861','Triplet liveborn infant, delivered vaginally',NULL,NULL),
(70647,'Z3862','Triplet liveborn infant, delivered by cesarean',NULL,NULL),
(70648,'Z3863','Quadruplet liveborn infant, delivered vaginally',NULL,NULL),
(70649,'Z3864','Quadruplet liveborn infant, delivered by cesarean',NULL,NULL),
(70650,'Z3865','Quintuplet liveborn infant, delivered vaginally',NULL,NULL),
(70651,'Z3866','Quintuplet liveborn infant, delivered by cesarean',NULL,NULL),
(70652,'Z3868','Other multiple liveborn infant, delivered vaginally',NULL,NULL),
(70653,'Z3869','Other multiple liveborn infant, delivered by cesarean',NULL,NULL),
(70654,'Z387','Other multiple liveborn infant, born outside hospital',NULL,NULL),
(70655,'Z388','Other multiple liveborn infant, unspecified as to place of birth',NULL,NULL),
(70656,'Z390','Encounter for care and examination of mother immediately after delivery',NULL,NULL),
(70657,'Z391','Encounter for care and examination of lactating mother',NULL,NULL),
(70658,'Z392','Encounter for routine postpartum follow-up',NULL,NULL),
(70659,'Z4000','Encounter for prophylactic removal of unspecified organ',NULL,NULL),
(70660,'Z4001','Encounter for prophylactic removal of breast',NULL,NULL),
(70661,'Z4002','Encounter for prophylactic removal of ovary',NULL,NULL),
(70662,'Z4009','Encounter for prophylactic removal of other organ',NULL,NULL),
(70663,'Z408','Encounter for other prophylactic surgery',NULL,NULL),
(70664,'Z409','Encounter for prophylactic surgery, unspecified',NULL,NULL),
(70665,'Z411','Encounter for cosmetic surgery',NULL,NULL),
(70666,'Z412','Encounter for routine and ritual male circumcision',NULL,NULL),
(70667,'Z413','Encounter for ear piercing',NULL,NULL),
(70668,'Z418','Encounter for other procedures for purposes other than remedying health state',NULL,NULL),
(70669,'Z419','Encounter for procedure for purposes other than remedying health state, unspecified',NULL,NULL),
(70670,'Z421','Encounter for breast reconstruction following mastectomy',NULL,NULL),
(70671,'Z428','Encounter for other plastic and reconstructive surgery following medical procedure or healed injury ',NULL,NULL),
(70672,'Z430','Encounter for attention to tracheostomy',NULL,NULL),
(70673,'Z431','Encounter for attention to gastrostomy',NULL,NULL),
(70674,'Z432','Encounter for attention to ileostomy',NULL,NULL),
(70675,'Z433','Encounter for attention to colostomy',NULL,NULL),
(70676,'Z434','Encounter for attention to other artificial openings of digestive tract',NULL,NULL),
(70677,'Z435','Encounter for attention to cystostomy',NULL,NULL),
(70678,'Z436','Encounter for attention to other artificial openings of urinary tract',NULL,NULL),
(70679,'Z437','Encounter for attention to artificial vagina',NULL,NULL),
(70680,'Z438','Encounter for attention to other artificial openings',NULL,NULL),
(70681,'Z439','Encounter for attention to unspecified artificial opening',NULL,NULL),
(70682,'Z44001','Encounter for fitting and adjustment of unspecified right artificial arm',NULL,NULL),
(70683,'Z44002','Encounter for fitting and adjustment of unspecified left artificial arm',NULL,NULL),
(70684,'Z44009','Encounter for fitting and adjustment of unspecified artificial arm, unspecified arm',NULL,NULL),
(70685,'Z44011','Encounter for fitting and adjustment of complete right artificial arm',NULL,NULL),
(70686,'Z44012','Encounter for fitting and adjustment of complete left artificial arm',NULL,NULL),
(70687,'Z44019','Encounter for fitting and adjustment of complete artificial arm, unspecified arm',NULL,NULL),
(70688,'Z44021','Encounter for fitting and adjustment of partial artificial right arm',NULL,NULL),
(70689,'Z44022','Encounter for fitting and adjustment of partial artificial left arm',NULL,NULL),
(70690,'Z44029','Encounter for fitting and adjustment of partial artificial arm, unspecified arm',NULL,NULL),
(70691,'Z44101','Encounter for fitting and adjustment of unspecified right artificial leg',NULL,NULL),
(70692,'Z44102','Encounter for fitting and adjustment of unspecified left artificial leg',NULL,NULL),
(70693,'Z44109','Encounter for fitting and adjustment of unspecified artificial leg, unspecified leg',NULL,NULL),
(70694,'Z44111','Encounter for fitting and adjustment of complete right artificial leg',NULL,NULL),
(70695,'Z44112','Encounter for fitting and adjustment of complete left artificial leg',NULL,NULL),
(70696,'Z44119','Encounter for fitting and adjustment of complete artificial leg, unspecified leg',NULL,NULL),
(70697,'Z44121','Encounter for fitting and adjustment of partial artificial right leg',NULL,NULL),
(70698,'Z44122','Encounter for fitting and adjustment of partial artificial left leg',NULL,NULL),
(70699,'Z44129','Encounter for fitting and adjustment of partial artificial leg, unspecified leg',NULL,NULL),
(70700,'Z4420','Encounter for fitting and adjustment of artificial eye, unspecified',NULL,NULL),
(70701,'Z4421','Encounter for fitting and adjustment of artificial right eye',NULL,NULL),
(70702,'Z4422','Encounter for fitting and adjustment of artificial left eye',NULL,NULL),
(70703,'Z4430','Encounter for fitting and adjustment of external breast prosthesis, unspecified breast',NULL,NULL),
(70704,'Z4431','Encounter for fitting and adjustment of external right breast prosthesis',NULL,NULL),
(70705,'Z4432','Encounter for fitting and adjustment of external left breast prosthesis',NULL,NULL),
(70706,'Z448','Encounter for fitting and adjustment of other external prosthetic devices',NULL,NULL),
(70707,'Z449','Encounter for fitting and adjustment of unspecified external prosthetic device',NULL,NULL),
(70708,'Z45010','Encounter for checking and testing of cardiac pacemaker pulse generator [battery]',NULL,NULL),
(70709,'Z45018','Encounter for adjustment and management of other part of cardiac pacemaker',NULL,NULL),
(70710,'Z4502','Encounter for adjustment and management of automatic implantable cardiac defibrillator',NULL,NULL),
(70711,'Z4509','Encounter for adjustment and management of other cardiac device',NULL,NULL),
(70712,'Z451','Encounter for adjustment and management of infusion pump',NULL,NULL),
(70713,'Z452','Encounter for adjustment and management of vascular access device',NULL,NULL),
(70714,'Z4531','Encounter for adjustment and management of implanted visual substitution device',NULL,NULL),
(70715,'Z45320','Encounter for adjustment and management of bone conduction device',NULL,NULL),
(70716,'Z45321','Encounter for adjustment and management of cochlear device',NULL,NULL),
(70717,'Z45328','Encounter for adjustment and management of other implanted hearing device',NULL,NULL),
(70718,'Z4541','Encounter for adjustment and management of cerebrospinal fluid drainage device',NULL,NULL),
(70719,'Z4542','Encounter for adjustment and management of neuropacemaker (brain) (peripheral nerve) (spinal cord) ',NULL,NULL),
(70720,'Z4549','Encounter for adjustment and management of other implanted nervous system device',NULL,NULL),
(70721,'Z45811','Encounter for adjustment or removal of right breast implant',NULL,NULL),
(70722,'Z45812','Encounter for adjustment or removal of left breast implant',NULL,NULL),
(70723,'Z45819','Encounter for adjustment or removal of unspecified breast implant',NULL,NULL),
(70724,'Z4582','Encounter for adjustment or removal of myringotomy device (stent) (tube)',NULL,NULL),
(70725,'Z4589','Encounter for adjustment and management of other implanted devices',NULL,NULL),
(70726,'Z459','Encounter for adjustment and management of unspecified implanted device',NULL,NULL),
(70727,'Z460','Encounter for fitting and adjustment of spectacles and contact lenses',NULL,NULL),
(70728,'Z461','Encounter for fitting and adjustment of hearing aid',NULL,NULL),
(70729,'Z462','Encounter for fitting and adjustment of other devices related to nervous system and special senses ',NULL,NULL),
(70730,'Z463','Encounter for fitting and adjustment of dental prosthetic device',NULL,NULL),
(70731,'Z464','Encounter for fitting and adjustment of orthodontic device',NULL,NULL),
(70732,'Z4651','Encounter for fitting and adjustment of gastric lap band',NULL,NULL),
(70733,'Z4659','Encounter for fitting and adjustment of other gastrointestinal appliance and device',NULL,NULL),
(70734,'Z466','Encounter for fitting and adjustment of urinary device',NULL,NULL),
(70735,'Z4681','Encounter for fitting and adjustment of insulin pump',NULL,NULL),
(70736,'Z4682','Encounter for fitting and adjustment of non-vascular catheter',NULL,NULL),
(70737,'Z4689','Encounter for fitting and adjustment of other specified devices',NULL,NULL),
(70738,'Z469','Encounter for fitting and adjustment of unspecified device',NULL,NULL),
(70739,'Z471','Aftercare following joint replacement surgery',NULL,NULL),
(70740,'Z472','Encounter for removal of internal fixation device',NULL,NULL),
(70741,'Z4731','Aftercare following explantation of shoulder joint prosthesis',NULL,NULL),
(70742,'Z4732','Aftercare following explantation of hip joint prosthesis',NULL,NULL),
(70743,'Z4733','Aftercare following explantation of knee joint prosthesis',NULL,NULL),
(70744,'Z4781','Encounter for orthopedic aftercare following surgical amputation',NULL,NULL),
(70745,'Z4782','Encounter for orthopedic aftercare following scoliosis surgery',NULL,NULL),
(70746,'Z4789','Encounter for other orthopedic aftercare',NULL,NULL),
(70747,'Z4800','Encounter for change or removal of nonsurgical wound dressing',NULL,NULL),
(70748,'Z4801','Encounter for change or removal of surgical wound dressing',NULL,NULL),
(70749,'Z4802','Encounter for removal of sutures',NULL,NULL),
(70750,'Z4803','Encounter for change or removal of drains',NULL,NULL),
(70751,'Z481','Encounter for planned postprocedural wound closure',NULL,NULL),
(70752,'Z4821','Encounter for aftercare following heart transplant',NULL,NULL),
(70753,'Z4822','Encounter for aftercare following kidney transplant',NULL,NULL),
(70754,'Z4823','Encounter for aftercare following liver transplant',NULL,NULL),
(70755,'Z4824','Encounter for aftercare following lung transplant',NULL,NULL),
(70756,'Z48280','Encounter for aftercare following heart-lung transplant',NULL,NULL),
(70757,'Z48288','Encounter for aftercare following multiple organ transplant',NULL,NULL),
(70758,'Z48290','Encounter for aftercare following bone marrow transplant',NULL,NULL),
(70759,'Z48298','Encounter for aftercare following other organ transplant',NULL,NULL),
(70760,'Z483','Aftercare following surgery for neoplasm',NULL,NULL),
(70761,'Z48810','Encounter for surgical aftercare following surgery on the sense organs',NULL,NULL),
(70762,'Z48811','Encounter for surgical aftercare following surgery on the nervous system',NULL,NULL),
(70763,'Z48812','Encounter for surgical aftercare following surgery on the circulatory system',NULL,NULL),
(70764,'Z48813','Encounter for surgical aftercare following surgery on the respiratory system',NULL,NULL),
(70765,'Z48814','Encounter for surgical aftercare following surgery on the teeth or oral cavity',NULL,NULL),
(70766,'Z48815','Encounter for surgical aftercare following surgery on the digestive system',NULL,NULL),
(70767,'Z48816','Encounter for surgical aftercare following surgery on the genitourinary system',NULL,NULL),
(70768,'Z48817','Encounter for surgical aftercare following surgery on the skin and subcutaneous tissue',NULL,NULL),
(70769,'Z4889','Encounter for other specified surgical aftercare',NULL,NULL),
(70770,'Z4901','Encounter for fitting and adjustment of extracorporeal dialysis catheter',NULL,NULL),
(70771,'Z4902','Encounter for fitting and adjustment of peritoneal dialysis catheter',NULL,NULL),
(70772,'Z4931','Encounter for adequacy testing for hemodialysis',NULL,NULL),
(70773,'Z4932','Encounter for adequacy testing for peritoneal dialysis',NULL,NULL),
(70774,'Z510','Encounter for antineoplastic radiation therapy',NULL,NULL),
(70775,'Z5111','Encounter for antineoplastic chemotherapy',NULL,NULL),
(70776,'Z5112','Encounter for antineoplastic immunotherapy',NULL,NULL),
(70777,'Z515','Encounter for palliative care',NULL,NULL),
(70778,'Z516','Encounter for desensitization to allergens',NULL,NULL),
(70779,'Z5181','Encounter for therapeutic drug level monitoring',NULL,NULL),
(70780,'Z5189','Encounter for other specified aftercare',NULL,NULL),
(70781,'Z52000','Unspecified donor, whole blood',NULL,NULL),
(70782,'Z52001','Unspecified donor, stem cells',NULL,NULL),
(70783,'Z52008','Unspecified donor, other blood',NULL,NULL),
(70784,'Z52010','Autologous donor, whole blood',NULL,NULL),
(70785,'Z52011','Autologous donor, stem cells',NULL,NULL),
(70786,'Z52018','Autologous donor, other blood',NULL,NULL),
(70787,'Z52090','Other blood donor, whole blood',NULL,NULL),
(70788,'Z52091','Other blood donor, stem cells',NULL,NULL),
(70789,'Z52098','Other blood donor, other blood',NULL,NULL),
(70790,'Z5210','Skin donor, unspecified',NULL,NULL),
(70791,'Z5211','Skin donor, autologous',NULL,NULL),
(70792,'Z5219','Skin donor, other',NULL,NULL),
(70793,'Z5220','Bone donor, unspecified',NULL,NULL),
(70794,'Z5221','Bone donor, autologous',NULL,NULL),
(70795,'Z5229','Bone donor, other',NULL,NULL),
(70796,'Z523','Bone marrow donor',NULL,NULL),
(70797,'Z524','Kidney donor',NULL,NULL),
(70798,'Z525','Cornea donor',NULL,NULL),
(70799,'Z526','Liver donor',NULL,NULL),
(70800,'Z52810','Egg (Oocyte) donor under age 35, anonymous recipient',NULL,NULL),
(70801,'Z52811','Egg (Oocyte) donor under age 35, designated recipient',NULL,NULL),
(70802,'Z52812','Egg (Oocyte) donor age 35 and over, anonymous recipient',NULL,NULL),
(70803,'Z52813','Egg (Oocyte) donor age 35 and over, designated recipient',NULL,NULL),
(70804,'Z52819','Egg (Oocyte) donor, unspecified',NULL,NULL),
(70805,'Z5289','Donor of other specified organs or tissues',NULL,NULL),
(70806,'Z529','Donor of unspecified organ or tissue',NULL,NULL),
(70807,'Z5301','Procedure and treatment not carried out due to patient smoking',NULL,NULL),
(70808,'Z5309','Procedure and treatment not carried out because of other contraindication',NULL,NULL),
(70809,'Z531','Procedure and treatment not carried out because of patient\'s decision for reasons of belief and group pressure ',NULL,NULL),
(70810,'Z5320','Procedure and treatment not carried out because of patient\'s decision for unspecified reasons',NULL,NULL),
(70811,'Z5321','Procedure and treatment not carried out due to patient leaving prior to being seen by health care provider ',NULL,NULL),
(70812,'Z5329','Procedure and treatment not carried out because of patient\'s decision for other reasons',NULL,NULL),
(70813,'Z5331','Laparoscopic surgical procedure converted to open procedure',NULL,NULL),
(70814,'Z5332','Thoracoscopic surgical procedure converted to open procedure',NULL,NULL),
(70815,'Z5333','Arthroscopic surgical procedure converted to open procedure',NULL,NULL),
(70816,'Z5339','Other specified procedure converted to open procedure',NULL,NULL),
(70817,'Z538','Procedure and treatment not carried out for other reasons',NULL,NULL),
(70818,'Z539','Procedure and treatment not carried out, unspecified reason',NULL,NULL),
(70819,'Z550','Illiteracy and low-level literacy',NULL,NULL),
(70820,'Z551','Schooling unavailable and unattainable',NULL,NULL),
(70821,'Z552','Failed school examinations',NULL,NULL),
(70822,'Z553','Underachievement in school',NULL,NULL),
(70823,'Z554','Educational maladjustment and discord with teachers and classmates',NULL,NULL),
(70824,'Z558','Other problems related to education and literacy',NULL,NULL),
(70825,'Z559','Problems related to education and literacy, unspecified',NULL,NULL),
(70826,'Z560','Unemployment, unspecified',NULL,NULL),
(70827,'Z561','Change of job',NULL,NULL),
(70828,'Z562','Threat of job loss',NULL,NULL),
(70829,'Z563','Stressful work schedule',NULL,NULL),
(70830,'Z564','Discord with boss and workmates',NULL,NULL),
(70831,'Z565','Uncongenial work environment',NULL,NULL),
(70832,'Z566','Other physical and mental strain related to work',NULL,NULL),
(70833,'Z5681','Sexual harassment on the job',NULL,NULL),
(70834,'Z5682','Military deployment status',NULL,NULL),
(70835,'Z5689','Other problems related to employment',NULL,NULL),
(70836,'Z569','Unspecified problems related to employment',NULL,NULL),
(70837,'Z570','Occupational exposure to noise',NULL,NULL),
(70838,'Z571','Occupational exposure to radiation',NULL,NULL),
(70839,'Z572','Occupational exposure to dust',NULL,NULL),
(70840,'Z5731','Occupational exposure to environmental tobacco smoke',NULL,NULL),
(70841,'Z5739','Occupational exposure to other air contaminants',NULL,NULL),
(70842,'Z574','Occupational exposure to toxic agents in agriculture',NULL,NULL),
(70843,'Z575','Occupational exposure to toxic agents in other industries',NULL,NULL),
(70844,'Z576','Occupational exposure to extreme temperature',NULL,NULL),
(70845,'Z577','Occupational exposure to vibration',NULL,NULL),
(70846,'Z578','Occupational exposure to other risk factors',NULL,NULL),
(70847,'Z579','Occupational exposure to unspecified risk factor',NULL,NULL),
(70848,'Z590','Homelessness',NULL,NULL),
(70849,'Z591','Inadequate housing',NULL,NULL),
(70850,'Z592','Discord with neighbors, lodgers and landlord',NULL,NULL),
(70851,'Z593','Problems related to living in residential institution',NULL,NULL),
(70852,'Z594','Lack of adequate food and safe drinking water',NULL,NULL),
(70853,'Z595','Extreme poverty',NULL,NULL),
(70854,'Z596','Low income',NULL,NULL),
(70855,'Z597','Insufficient social insurance and welfare support',NULL,NULL),
(70856,'Z598','Other problems related to housing and economic circumstances',NULL,NULL),
(70857,'Z599','Problem related to housing and economic circumstances, unspecified',NULL,NULL),
(70858,'Z600','Problems of adjustment to life-cycle transitions',NULL,NULL),
(70859,'Z602','Problems related to living alone',NULL,NULL),
(70860,'Z603','Acculturation difficulty',NULL,NULL),
(70861,'Z604','Social exclusion and rejection',NULL,NULL),
(70862,'Z605','Target of (perceived) adverse discrimination and persecution',NULL,NULL),
(70863,'Z608','Other problems related to social environment',NULL,NULL),
(70864,'Z609','Problem related to social environment, unspecified',NULL,NULL),
(70865,'Z620','Inadequate parental supervision and control',NULL,NULL),
(70866,'Z621','Parental overprotection',NULL,NULL),
(70867,'Z6221','Child in welfare custody',NULL,NULL),
(70868,'Z6222','Institutional upbringing',NULL,NULL),
(70869,'Z6229','Other upbringing away from parents',NULL,NULL),
(70870,'Z623','Hostility towards and scapegoating of child',NULL,NULL),
(70871,'Z626','Inappropriate (excessive) parental pressure',NULL,NULL),
(70872,'Z62810','Personal history of physical and sexual abuse in childhood',NULL,NULL),
(70873,'Z62811','Personal history of psychological abuse in childhood',NULL,NULL),
(70874,'Z62812','Personal history of neglect in childhood',NULL,NULL),
(70875,'Z62819','Personal history of unspecified abuse in childhood',NULL,NULL),
(70876,'Z62820','Parent-biological child conflict',NULL,NULL),
(70877,'Z62821','Parent-adopted child conflict',NULL,NULL),
(70878,'Z62822','Parent-foster child conflict',NULL,NULL),
(70879,'Z62890','Parent-child estrangement NEC',NULL,NULL),
(70880,'Z62891','Sibling rivalry',NULL,NULL),
(70881,'Z62898','Other specified problems related to upbringing',NULL,NULL),
(70882,'Z629','Problem related to upbringing, unspecified',NULL,NULL),
(70883,'Z630','Problems in relationship with spouse or partner',NULL,NULL),
(70884,'Z631','Problems in relationship with in-laws',NULL,NULL),
(70885,'Z6331','Absence of family member due to military deployment',NULL,NULL),
(70886,'Z6332','Other absence of family member',NULL,NULL),
(70887,'Z634','Disappearance and death of family member',NULL,NULL),
(70888,'Z635','Disruption of family by separation and divorce',NULL,NULL),
(70889,'Z636','Dependent relative needing care at home',NULL,NULL),
(70890,'Z6371','Stress on family due to return of family member from military deployment',NULL,NULL),
(70891,'Z6372','Alcoholism and drug addiction in family',NULL,NULL),
(70892,'Z6379','Other stressful life events affecting family and household',NULL,NULL),
(70893,'Z638','Other specified problems related to primary support group',NULL,NULL),
(70894,'Z639','Problem related to primary support group, unspecified',NULL,NULL),
(70895,'Z640','Problems related to unwanted pregnancy',NULL,NULL),
(70896,'Z641','Problems related to multiparity',NULL,NULL),
(70897,'Z644','Discord with counselors',NULL,NULL),
(70898,'Z650','Conviction in civil and criminal proceedings without imprisonment',NULL,NULL),
(70899,'Z651','Imprisonment and other incarceration',NULL,NULL),
(70900,'Z652','Problems related to release from prison',NULL,NULL),
(70901,'Z653','Problems related to other legal circumstances',NULL,NULL),
(70902,'Z654','Victim of crime and terrorism',NULL,NULL),
(70903,'Z655','Exposure to disaster, war and other hostilities',NULL,NULL),
(70904,'Z658','Other specified problems related to psychosocial circumstances',NULL,NULL),
(70905,'Z659','Problem related to unspecified psychosocial circumstances',NULL,NULL),
(70906,'Z66','Do not resuscitate',NULL,NULL),
(70907,'Z6710','Type A blood, Rh positive',NULL,NULL),
(70908,'Z6711','Type A blood, Rh negative',NULL,NULL),
(70909,'Z6720','Type B blood, Rh positive',NULL,NULL),
(70910,'Z6721','Type B blood, Rh negative',NULL,NULL),
(70911,'Z6730','Type AB blood, Rh positive',NULL,NULL),
(70912,'Z6731','Type AB blood, Rh negative',NULL,NULL),
(70913,'Z6740','Type O blood, Rh positive',NULL,NULL),
(70914,'Z6741','Type O blood, Rh negative',NULL,NULL),
(70915,'Z6790','Unspecified blood type, Rh positive',NULL,NULL),
(70916,'Z6791','Unspecified blood type, Rh negative',NULL,NULL),
(70917,'Z681','Body mass index (BMI) 19 or less, adult',NULL,NULL),
(70918,'Z6820','Body mass index (BMI) 20.0-20.9, adult',NULL,NULL),
(70919,'Z6821','Body mass index (BMI) 21.0-21.9, adult',NULL,NULL),
(70920,'Z6822','Body mass index (BMI) 22.0-22.9, adult',NULL,NULL),
(70921,'Z6823','Body mass index (BMI) 23.0-23.9, adult',NULL,NULL),
(70922,'Z6824','Body mass index (BMI) 24.0-24.9, adult',NULL,NULL),
(70923,'Z6825','Body mass index (BMI) 25.0-25.9, adult',NULL,NULL),
(70924,'Z6826','Body mass index (BMI) 26.0-26.9, adult',NULL,NULL),
(70925,'Z6827','Body mass index (BMI) 27.0-27.9, adult',NULL,NULL),
(70926,'Z6828','Body mass index (BMI) 28.0-28.9, adult',NULL,NULL),
(70927,'Z6829','Body mass index (BMI) 29.0-29.9, adult',NULL,NULL),
(70928,'Z6830','Body mass index (BMI) 30.0-30.9, adult',NULL,NULL),
(70929,'Z6831','Body mass index (BMI) 31.0-31.9, adult',NULL,NULL),
(70930,'Z6832','Body mass index (BMI) 32.0-32.9, adult',NULL,NULL),
(70931,'Z6833','Body mass index (BMI) 33.0-33.9, adult',NULL,NULL),
(70932,'Z6834','Body mass index (BMI) 34.0-34.9, adult',NULL,NULL),
(70933,'Z6835','Body mass index (BMI) 35.0-35.9, adult',NULL,NULL),
(70934,'Z6836','Body mass index (BMI) 36.0-36.9, adult',NULL,NULL),
(70935,'Z6837','Body mass index (BMI) 37.0-37.9, adult',NULL,NULL),
(70936,'Z6838','Body mass index (BMI) 38.0-38.9, adult',NULL,NULL),
(70937,'Z6839','Body mass index (BMI) 39.0-39.9, adult',NULL,NULL),
(70938,'Z6841','Body mass index (BMI) 40.0-44.9, adult',NULL,NULL),
(70939,'Z6842','Body mass index (BMI) 45.0-49.9, adult',NULL,NULL),
(70940,'Z6843','Body mass index (BMI) 50-59.9 , adult',NULL,NULL),
(70941,'Z6844','Body mass index (BMI) 60.0-69.9, adult',NULL,NULL),
(70942,'Z6845','Body mass index (BMI) 70 or greater, adult',NULL,NULL),
(70943,'Z6851','Body mass index (BMI) pediatric, less than 5th percentile for age',NULL,NULL),
(70944,'Z6852','Body mass index (BMI) pediatric, 5th percentile to less than 85th percentile for age',NULL,NULL),
(70945,'Z6853','Body mass index (BMI) pediatric, 85th percentile to less than 95th percentile for age',NULL,NULL),
(70946,'Z6854','Body mass index (BMI) pediatric, greater than or equal to 95th percentile for age',NULL,NULL),
(70947,'Z69010','Encounter for mental health services for victim of parental child abuse',NULL,NULL),
(70948,'Z69011','Encounter for mental health services for perpetrator of parental child abuse',NULL,NULL),
(70949,'Z69020','Encounter for mental health services for victim of non-parental child abuse',NULL,NULL),
(70950,'Z69021','Encounter for mental health services for perpetrator of non-parental child abuse',NULL,NULL),
(70951,'Z6911','Encounter for mental health services for victim of spousal or partner abuse',NULL,NULL),
(70952,'Z6912','Encounter for mental health services for perpetrator of spousal or partner abuse',NULL,NULL),
(70953,'Z6981','Encounter for mental health services for victim of other abuse',NULL,NULL),
(70954,'Z6982','Encounter for mental health services for perpetrator of other abuse',NULL,NULL),
(70955,'Z700','Counseling related to sexual attitude',NULL,NULL),
(70956,'Z701','Counseling related to patient\'s sexual behavior and orientation',NULL,NULL),
(70957,'Z702','Counseling related to sexual behavior and orientation of third party',NULL,NULL),
(70958,'Z703','Counseling related to combined concerns regarding sexual attitude, behavior and orientation',NULL,NULL),
(70959,'Z708','Other sex counseling',NULL,NULL),
(70960,'Z709','Sex counseling, unspecified',NULL,NULL),
(70961,'Z710','Person encountering health services to consult on behalf of another person',NULL,NULL),
(70962,'Z711','Person with feared health complaint in whom no diagnosis is made',NULL,NULL),
(70963,'Z712','Person consulting for explanation of examination or test findings',NULL,NULL),
(70964,'Z713','Dietary counseling and surveillance',NULL,NULL),
(70965,'Z7141','Alcohol abuse counseling and surveillance of alcoholic',NULL,NULL),
(70966,'Z7142','Counseling for family member of alcoholic',NULL,NULL),
(70967,'Z7151','Drug abuse counseling and surveillance of drug abuser',NULL,NULL),
(70968,'Z7152','Counseling for family member of drug abuser',NULL,NULL),
(70969,'Z716','Tobacco abuse counseling',NULL,NULL),
(70970,'Z717','Human immunodeficiency virus [HIV] counseling',NULL,NULL),
(70971,'Z7181','Spiritual or religious counseling',NULL,NULL),
(70972,'Z7189','Other specified counseling',NULL,NULL),
(70973,'Z719','Counseling, unspecified',NULL,NULL),
(70974,'Z720','Tobacco use',NULL,NULL),
(70975,'Z723','Lack of physical exercise',NULL,NULL),
(70976,'Z724','Inappropriate diet and eating habits',NULL,NULL),
(70977,'Z7251','High risk heterosexual behavior',NULL,NULL),
(70978,'Z7252','High risk homosexual behavior',NULL,NULL),
(70979,'Z7253','High risk bisexual behavior',NULL,NULL),
(70980,'Z726','Gambling and betting',NULL,NULL),
(70981,'Z72810','Child and adolescent antisocial behavior',NULL,NULL),
(70982,'Z72811','Adult antisocial behavior',NULL,NULL),
(70983,'Z72820','Sleep deprivation',NULL,NULL),
(70984,'Z72821','Inadequate sleep hygiene',NULL,NULL),
(70985,'Z7289','Other problems related to lifestyle',NULL,NULL),
(70986,'Z729','Problem related to lifestyle, unspecified',NULL,NULL),
(70987,'Z730','Burn-out',NULL,NULL),
(70988,'Z731','Type A behavior pattern',NULL,NULL),
(70989,'Z732','Lack of relaxation and leisure',NULL,NULL),
(70990,'Z733','Stress, not elsewhere classified',NULL,NULL),
(70991,'Z734','Inadequate social skills, not elsewhere classified',NULL,NULL),
(70992,'Z735','Social role conflict, not elsewhere classified',NULL,NULL),
(70993,'Z736','Limitation of activities due to disability',NULL,NULL),
(70994,'Z73810','Behavioral insomnia of childhood, sleep-onset association type',NULL,NULL),
(70995,'Z73811','Behavioral insomnia of childhood, limit setting type',NULL,NULL),
(70996,'Z73812','Behavioral insomnia of childhood, combined type',NULL,NULL),
(70997,'Z73819','Behavioral insomnia of childhood, unspecified type',NULL,NULL),
(70998,'Z7382','Dual sensory impairment',NULL,NULL),
(70999,'Z7389','Other problems related to life management difficulty',NULL,NULL),
(71000,'Z739','Problem related to life management difficulty, unspecified',NULL,NULL),
(71001,'Z7401','Bed confinement status',NULL,NULL),
(71002,'Z7409','Other reduced mobility',NULL,NULL),
(71003,'Z741','Need for assistance with personal care',NULL,NULL),
(71004,'Z742','Need for assistance at home and no other household member able to render care',NULL,NULL),
(71005,'Z743','Need for continuous supervision',NULL,NULL),
(71006,'Z748','Other problems related to care provider dependency',NULL,NULL),
(71007,'Z749','Problem related to care provider dependency, unspecified',NULL,NULL),
(71008,'Z750','Medical services not available in home',NULL,NULL),
(71009,'Z751','Person awaiting admission to adequate facility elsewhere',NULL,NULL),
(71010,'Z752','Other waiting period for investigation and treatment',NULL,NULL),
(71011,'Z753','Unavailability and inaccessibility of health-care facilities',NULL,NULL),
(71012,'Z754','Unavailability and inaccessibility of other helping agencies',NULL,NULL),
(71013,'Z755','Holiday relief care',NULL,NULL),
(71014,'Z758','Other problems related to medical facilities and other health care',NULL,NULL),
(71015,'Z759','Unspecified problem related to medical facilities and other health care',NULL,NULL),
(71016,'Z760','Encounter for issue of repeat prescription',NULL,NULL),
(71017,'Z761','Encounter for health supervision and care of foundling',NULL,NULL),
(71018,'Z762','Encounter for health supervision and care of other healthy infant and child',NULL,NULL),
(71019,'Z763','Healthy person accompanying sick person',NULL,NULL),
(71020,'Z764','Other boarder to healthcare facility',NULL,NULL),
(71021,'Z765','Malingerer [conscious simulation]',NULL,NULL),
(71022,'Z7681','Expectant parent(s) prebirth pediatrician visit',NULL,NULL),
(71023,'Z7682','Awaiting organ transplant status',NULL,NULL),
(71024,'Z7689','Persons encountering health services in other specified circumstances',NULL,NULL),
(71025,'Z77010','Contact with and (suspected) exposure to arsenic',NULL,NULL),
(71026,'Z77011','Contact with and (suspected) exposure to lead',NULL,NULL),
(71027,'Z77012','Contact with and (suspected) exposure to uranium',NULL,NULL),
(71028,'Z77018','Contact with and (suspected) exposure to other hazardous metals',NULL,NULL),
(71029,'Z77020','Contact with and (suspected) exposure to aromatic amines',NULL,NULL),
(71030,'Z77021','Contact with and (suspected) exposure to benzene',NULL,NULL),
(71031,'Z77028','Contact with and (suspected) exposure to other hazardous aromatic compounds',NULL,NULL),
(71032,'Z77090','Contact with and (suspected) exposure to asbestos',NULL,NULL),
(71033,'Z77098','Contact with and (suspected) exposure to other hazardous, chiefly nonmedicinal, chemicals',NULL,NULL),
(71034,'Z77110','Contact with and (suspected) exposure to air pollution',NULL,NULL),
(71035,'Z77111','Contact with and (suspected) exposure to water pollution',NULL,NULL),
(71036,'Z77112','Contact with and (suspected) exposure to soil pollution',NULL,NULL),
(71037,'Z77118','Contact with and (suspected) exposure to other environmental pollution',NULL,NULL),
(71038,'Z77120','Contact with and (suspected) exposure to mold (toxic)',NULL,NULL),
(71039,'Z77121','Contact with and (suspected) exposure to harmful algae and algae toxins',NULL,NULL),
(71040,'Z77122','Contact with and (suspected) exposure to noise',NULL,NULL),
(71041,'Z77123','Contact with and (suspected) exposure to radon and other naturally occuring radiation',NULL,NULL),
(71042,'Z77128','Contact with and (suspected) exposure to other hazards in the physical environment',NULL,NULL),
(71043,'Z7721','Contact with and (suspected) exposure to potentially hazardous body fluids',NULL,NULL),
(71044,'Z7722','Contact with and (suspected) exposure to environmental tobacco smoke (acute) (chronic)',NULL,NULL),
(71045,'Z7729','Contact with and (suspected ) exposure to other hazardous substances',NULL,NULL),
(71046,'Z779','Other contact with and (suspected) exposures hazardous to health',NULL,NULL),
(71047,'Z780','Asymptomatic menopausal state',NULL,NULL),
(71048,'Z781','Physical restraint status',NULL,NULL),
(71049,'Z789','Other specified health status',NULL,NULL),
(71050,'Z7901','Long term (current) use of anticoagulants',NULL,NULL),
(71051,'Z7902','Long term (current) use of antithrombotics/antiplatelets',NULL,NULL),
(71052,'Z791','Long term (current) use of non-steroidal anti-inflammatories (NSAID)',NULL,NULL),
(71053,'Z792','Long term (current) use of antibiotics',NULL,NULL),
(71054,'Z793','Long term (current) use of hormonal contraceptives',NULL,NULL),
(71055,'Z794','Long term (current) use of insulin',NULL,NULL),
(71056,'Z7951','Long term (current) use of inhaled steroids',NULL,NULL),
(71057,'Z7952','Long term (current) use of systemic steroids',NULL,NULL),
(71058,'Z79810','Long term (current) use of selective estrogen receptor modulators (SERMs)',NULL,NULL),
(71059,'Z79811','Long term (current) use of aromatase inhibitors',NULL,NULL),
(71060,'Z79818','Long term (current) use of other agents affecting estrogen receptors and estrogen levels',NULL,NULL),
(71061,'Z7982','Long term (current) use of aspirin',NULL,NULL),
(71062,'Z7983','Long term (current) use of bisphosphonates',NULL,NULL),
(71063,'Z7984','Long term (current) use of oral hypoglycemic drugs',NULL,NULL),
(71064,'Z79890','Hormone replacement therapy (postmenopausal)',NULL,NULL),
(71065,'Z79891','Long term (current) use of opiate analgesic',NULL,NULL),
(71066,'Z79899','Other long term (current) drug therapy',NULL,NULL),
(71067,'Z800','Family history of malignant neoplasm of digestive organs',NULL,NULL),
(71068,'Z801','Family history of malignant neoplasm of trachea, bronchus and lung',NULL,NULL),
(71069,'Z802','Family history of malignant neoplasm of other respiratory and intrathoracic organs',NULL,NULL),
(71070,'Z803','Family history of malignant neoplasm of breast',NULL,NULL),
(71071,'Z8041','Family history of malignant neoplasm of ovary',NULL,NULL),
(71072,'Z8042','Family history of malignant neoplasm of prostate',NULL,NULL),
(71073,'Z8043','Family history of malignant neoplasm of testis',NULL,NULL),
(71074,'Z8049','Family history of malignant neoplasm of other genital organs',NULL,NULL),
(71075,'Z8051','Family history of malignant neoplasm of kidney',NULL,NULL),
(71076,'Z8052','Family history of malignant neoplasm of bladder',NULL,NULL),
(71077,'Z8059','Family history of malignant neoplasm of other urinary tract organ',NULL,NULL),
(71078,'Z806','Family history of leukemia',NULL,NULL),
(71079,'Z807','Family history of other malignant neoplasms of lymphoid, hematopoietic and related tissues',NULL,NULL),
(71080,'Z808','Family history of malignant neoplasm of other organs or systems',NULL,NULL),
(71081,'Z809','Family history of malignant neoplasm, unspecified',NULL,NULL),
(71082,'Z810','Family history of intellectual disabilities',NULL,NULL),
(71083,'Z811','Family history of alcohol abuse and dependence',NULL,NULL),
(71084,'Z812','Family history of tobacco abuse and dependence',NULL,NULL),
(71085,'Z813','Family history of other psychoactive substance abuse and dependence',NULL,NULL),
(71086,'Z814','Family history of other substance abuse and dependence',NULL,NULL),
(71087,'Z818','Family history of other mental and behavioral disorders',NULL,NULL),
(71088,'Z820','Family history of epilepsy and other diseases of the nervous system',NULL,NULL),
(71089,'Z821','Family history of blindness and visual loss',NULL,NULL),
(71090,'Z822','Family history of deafness and hearing loss',NULL,NULL),
(71091,'Z823','Family history of stroke',NULL,NULL),
(71092,'Z8241','Family history of sudden cardiac death',NULL,NULL),
(71093,'Z8249','Family history of ischemic heart disease and other diseases of the circulatory system',NULL,NULL),
(71094,'Z825','Family history of asthma and other chronic lower respiratory diseases',NULL,NULL),
(71095,'Z8261','Family history of arthritis',NULL,NULL),
(71096,'Z8262','Family history of osteoporosis',NULL,NULL),
(71097,'Z8269','Family history of other diseases of the musculoskeletal system and connective tissue',NULL,NULL),
(71098,'Z8271','Family history of polycystic kidney',NULL,NULL),
(71099,'Z8279','Family history of other congenital malformations, deformations and chromosomal abnormalities',NULL,NULL),
(71100,'Z828','Family history of other disabilities and chronic diseases leading to disablement, not elsewhere classified ',NULL,NULL),
(71101,'Z830','Family history of human immunodeficiency virus [HIV] disease',NULL,NULL),
(71102,'Z831','Family history of other infectious and parasitic diseases',NULL,NULL),
(71103,'Z832','Family history of diseases of the blood and blood-forming organs and certain disorders involving the immune mechanism ',NULL,NULL),
(71104,'Z833','Family history of diabetes mellitus',NULL,NULL),
(71105,'Z8341','Family history of multiple endocrine neoplasia [MEN] syndrome',NULL,NULL),
(71106,'Z8342','Family history of familial hypercholesterolemia',NULL,NULL),
(71107,'Z8349','Family history of other endocrine, nutritional and metabolic diseases',NULL,NULL),
(71108,'Z83511','Family history of glaucoma',NULL,NULL),
(71109,'Z83518','Family history of other specified eye disorder',NULL,NULL),
(71110,'Z8352','Family history of ear disorders',NULL,NULL),
(71111,'Z836','Family history of other diseases of the respiratory system',NULL,NULL),
(71112,'Z8371','Family history of colonic polyps',NULL,NULL),
(71113,'Z8379','Family history of other diseases of the digestive system',NULL,NULL),
(71114,'Z840','Family history of diseases of the skin and subcutaneous tissue',NULL,NULL),
(71115,'Z841','Family history of disorders of kidney and ureter',NULL,NULL),
(71116,'Z842','Family history of other diseases of the genitourinary system',NULL,NULL),
(71117,'Z843','Family history of consanguinity',NULL,NULL),
(71118,'Z8481','Family history of carrier of genetic disease',NULL,NULL),
(71119,'Z8482','Family history of sudden infant death syndrome',NULL,NULL),
(71120,'Z8489','Family history of other specified conditions',NULL,NULL),
(71121,'Z8500','Personal history of malignant neoplasm of unspecified digestive organ',NULL,NULL),
(71122,'Z8501','Personal history of malignant neoplasm of esophagus',NULL,NULL),
(71123,'Z85020','Personal history of malignant carcinoid tumor of stomach',NULL,NULL),
(71124,'Z85028','Personal history of other malignant neoplasm of stomach',NULL,NULL),
(71125,'Z85030','Personal history of malignant carcinoid tumor of large intestine',NULL,NULL),
(71126,'Z85038','Personal history of other malignant neoplasm of large intestine',NULL,NULL),
(71127,'Z85040','Personal history of malignant carcinoid tumor of rectum',NULL,NULL),
(71128,'Z85048','Personal history of other malignant neoplasm of rectum, rectosigmoid junction, and anus',NULL,NULL),
(71129,'Z8505','Personal history of malignant neoplasm of liver',NULL,NULL),
(71130,'Z85060','Personal history of malignant carcinoid tumor of small intestine',NULL,NULL),
(71131,'Z85068','Personal history of other malignant neoplasm of small intestine',NULL,NULL),
(71132,'Z8507','Personal history of malignant neoplasm of pancreas',NULL,NULL),
(71133,'Z8509','Personal history of malignant neoplasm of other digestive organs',NULL,NULL),
(71134,'Z85110','Personal history of malignant carcinoid tumor of bronchus and lung',NULL,NULL),
(71135,'Z85118','Personal history of other malignant neoplasm of bronchus and lung',NULL,NULL),
(71136,'Z8512','Personal history of malignant neoplasm of trachea',NULL,NULL),
(71137,'Z8520','Personal history of malignant neoplasm of unspecified respiratory organ',NULL,NULL),
(71138,'Z8521','Personal history of malignant neoplasm of larynx',NULL,NULL),
(71139,'Z8522','Personal history of malignant neoplasm of nasal cavities, middle ear, and accessory sinuses',NULL,NULL),
(71140,'Z85230','Personal history of malignant carcinoid tumor of thymus',NULL,NULL),
(71141,'Z85238','Personal history of other malignant neoplasm of thymus',NULL,NULL),
(71142,'Z8529','Personal history of malignant neoplasm of other respiratory and intrathoracic organs',NULL,NULL),
(71143,'Z853','Personal history of malignant neoplasm of breast',NULL,NULL),
(71144,'Z8540','Personal history of malignant neoplasm of unspecified female genital organ',NULL,NULL),
(71145,'Z8541','Personal history of malignant neoplasm of cervix uteri',NULL,NULL),
(71146,'Z8542','Personal history of malignant neoplasm of other parts of uterus',NULL,NULL),
(71147,'Z8543','Personal history of malignant neoplasm of ovary',NULL,NULL),
(71148,'Z8544','Personal history of malignant neoplasm of other female genital organs',NULL,NULL),
(71149,'Z8545','Personal history of malignant neoplasm of unspecified male genital organ',NULL,NULL),
(71150,'Z8546','Personal history of malignant neoplasm of prostate',NULL,NULL),
(71151,'Z8547','Personal history of malignant neoplasm of testis',NULL,NULL),
(71152,'Z8548','Personal history of malignant neoplasm of epididymis',NULL,NULL),
(71153,'Z8549','Personal history of malignant neoplasm of other male genital organs',NULL,NULL),
(71154,'Z8550','Personal history of malignant neoplasm of unspecified urinary tract organ',NULL,NULL),
(71155,'Z8551','Personal history of malignant neoplasm of bladder',NULL,NULL),
(71156,'Z85520','Personal history of malignant carcinoid tumor of kidney',NULL,NULL),
(71157,'Z85528','Personal history of other malignant neoplasm of kidney',NULL,NULL),
(71158,'Z8553','Personal history of malignant neoplasm of renal pelvis',NULL,NULL),
(71159,'Z8554','Personal history of malignant neoplasm of ureter',NULL,NULL),
(71160,'Z8559','Personal history of malignant neoplasm of other urinary tract organ',NULL,NULL),
(71161,'Z856','Personal history of leukemia',NULL,NULL),
(71162,'Z8571','Personal history of Hodgkin lymphoma',NULL,NULL),
(71163,'Z8572','Personal history of non-Hodgkin lymphomas',NULL,NULL),
(71164,'Z8579','Personal history of other malignant neoplasms of lymphoid, hematopoietic and related tissues',NULL,NULL),
(71165,'Z85810','Personal history of malignant neoplasm of tongue',NULL,NULL),
(71166,'Z85818','Personal history of malignant neoplasm of other sites of lip, oral cavity, and pharynx',NULL,NULL),
(71167,'Z85819','Personal history of malignant neoplasm of unspecified site of lip, oral cavity, and pharynx',NULL,NULL),
(71168,'Z85820','Personal history of malignant melanoma of skin',NULL,NULL),
(71169,'Z85821','Personal history of Merkel cell carcinoma',NULL,NULL),
(71170,'Z85828','Personal history of other malignant neoplasm of skin',NULL,NULL),
(71171,'Z85830','Personal history of malignant neoplasm of bone',NULL,NULL),
(71172,'Z85831','Personal history of malignant neoplasm of soft tissue',NULL,NULL),
(71173,'Z85840','Personal history of malignant neoplasm of eye',NULL,NULL),
(71174,'Z85841','Personal history of malignant neoplasm of brain',NULL,NULL),
(71175,'Z85848','Personal history of malignant neoplasm of other parts of nervous tissue',NULL,NULL),
(71176,'Z85850','Personal history of malignant neoplasm of thyroid',NULL,NULL),
(71177,'Z85858','Personal history of malignant neoplasm of other endocrine glands',NULL,NULL),
(71178,'Z8589','Personal history of malignant neoplasm of other organs and systems',NULL,NULL),
(71179,'Z859','Personal history of malignant neoplasm, unspecified',NULL,NULL),
(71180,'Z86000','Personal history of in-situ neoplasm of breast',NULL,NULL),
(71181,'Z86001','Personal history of in-situ neoplasm of cervix uteri',NULL,NULL),
(71182,'Z86008','Personal history of in-situ neoplasm of other site',NULL,NULL),
(71183,'Z86010','Personal history of colonic polyps',NULL,NULL),
(71184,'Z86011','Personal history of benign neoplasm of the brain',NULL,NULL),
(71185,'Z86012','Personal history of benign carcinoid tumor',NULL,NULL),
(71186,'Z86018','Personal history of other benign neoplasm',NULL,NULL),
(71187,'Z8603','Personal history of neoplasm of uncertain behavior',NULL,NULL),
(71188,'Z8611','Personal history of tuberculosis',NULL,NULL),
(71189,'Z8612','Personal history of poliomyelitis',NULL,NULL),
(71190,'Z8613','Personal history of malaria',NULL,NULL),
(71191,'Z8614','Personal history of Methicillin resistant Staphylococcus aureus infection',NULL,NULL),
(71192,'Z8619','Personal history of other infectious and parasitic diseases',NULL,NULL),
(71193,'Z862','Personal history of diseases of the blood and blood-forming organs and certain disorders involving the immune mechanism ',NULL,NULL),
(71194,'Z8631','Personal history of diabetic foot ulcer',NULL,NULL),
(71195,'Z8632','Personal history of gestational diabetes',NULL,NULL),
(71196,'Z8639','Personal history of other endocrine, nutritional and metabolic disease',NULL,NULL),
(71197,'Z8651','Personal history of combat and operational stress reaction',NULL,NULL),
(71198,'Z8659','Personal history of other mental and behavioral disorders',NULL,NULL),
(71199,'Z8661','Personal history of infections of the central nervous system',NULL,NULL),
(71200,'Z8669','Personal history of other diseases of the nervous system and sense organs',NULL,NULL),
(71201,'Z86711','Personal history of pulmonary embolism',NULL,NULL),
(71202,'Z86718','Personal history of other venous thrombosis and embolism',NULL,NULL),
(71203,'Z8672','Personal history of thrombophlebitis',NULL,NULL),
(71204,'Z8673','Personal history of transient ischemic attack (TIA), and cerebral infarction without residual deficits ',NULL,NULL),
(71205,'Z8674','Personal history of sudden cardiac arrest',NULL,NULL),
(71206,'Z8679','Personal history of other diseases of the circulatory system',NULL,NULL),
(71207,'Z8701','Personal history of pneumonia (recurrent)',NULL,NULL),
(71208,'Z8709','Personal history of other diseases of the respiratory system',NULL,NULL),
(71209,'Z8711','Personal history of peptic ulcer disease',NULL,NULL),
(71210,'Z8719','Personal history of other diseases of the digestive system',NULL,NULL),
(71211,'Z872','Personal history of diseases of the skin and subcutaneous tissue',NULL,NULL),
(71212,'Z87310','Personal history of (healed) osteoporosis fracture',NULL,NULL),
(71213,'Z87311','Personal history of (healed) other pathological fracture',NULL,NULL),
(71214,'Z87312','Personal history of (healed) stress fracture',NULL,NULL),
(71215,'Z8739','Personal history of other diseases of the musculoskeletal system and connective tissue',NULL,NULL),
(71216,'Z87410','Personal history of cervical dysplasia',NULL,NULL),
(71217,'Z87411','Personal history of vaginal dysplasia',NULL,NULL),
(71218,'Z87412','Personal history of vulvar dysplasia',NULL,NULL),
(71219,'Z8742','Personal history of other diseases of the female genital tract',NULL,NULL),
(71220,'Z87430','Personal history of prostatic dysplasia',NULL,NULL),
(71221,'Z87438','Personal history of other diseases of male genital organs',NULL,NULL),
(71222,'Z87440','Personal history of urinary (tract) infections',NULL,NULL),
(71223,'Z87441','Personal history of nephrotic syndrome',NULL,NULL),
(71224,'Z87442','Personal history of urinary calculi',NULL,NULL),
(71225,'Z87448','Personal history of other diseases of urinary system',NULL,NULL),
(71226,'Z8751','Personal history of pre-term labor',NULL,NULL),
(71227,'Z8759','Personal history of other complications of pregnancy, childbirth and the puerperium',NULL,NULL),
(71228,'Z87710','Personal history of (corrected) hypospadias',NULL,NULL),
(71229,'Z87718','Personal history of other specified (corrected) congenital malformations of genitourinary system ',NULL,NULL),
(71230,'Z87720','Personal history of (corrected) congenital malformations of eye',NULL,NULL),
(71231,'Z87721','Personal history of (corrected) congenital malformations of ear',NULL,NULL),
(71232,'Z87728','Personal history of other specified (corrected) congenital malformations of nervous system and sense organs ',NULL,NULL),
(71233,'Z87730','Personal history of (corrected) cleft lip and palate',NULL,NULL),
(71234,'Z87738','Personal history of other specified (corrected) congenital malformations of digestive system',NULL,NULL),
(71235,'Z8774','Personal history of (corrected) congenital malformations of heart and circulatory system',NULL,NULL),
(71236,'Z8775','Personal history of (corrected) congenital malformations of respiratory system',NULL,NULL),
(71237,'Z8776','Personal history of (corrected) congenital malformations of integument, limbs and musculoskeletal system ',NULL,NULL),
(71238,'Z87790','Personal history of (corrected) congenital malformations of face and neck',NULL,NULL),
(71239,'Z87798','Personal history of other (corrected) congenital malformations',NULL,NULL),
(71240,'Z8781','Personal history of (healed) traumatic fracture',NULL,NULL),
(71241,'Z87820','Personal history of traumatic brain injury',NULL,NULL),
(71242,'Z87821','Personal history of retained foreign body fully removed',NULL,NULL),
(71243,'Z87828','Personal history of other (healed) physical injury and trauma',NULL,NULL),
(71244,'Z87890','Personal history of sex reassignment',NULL,NULL),
(71245,'Z87891','Personal history of nicotine dependence',NULL,NULL),
(71246,'Z87892','Personal history of anaphylaxis',NULL,NULL),
(71247,'Z87898','Personal history of other specified conditions',NULL,NULL),
(71248,'Z880','Allergy status to penicillin',NULL,NULL),
(71249,'Z881','Allergy status to other antibiotic agents status',NULL,NULL),
(71250,'Z882','Allergy status to sulfonamides status',NULL,NULL),
(71251,'Z883','Allergy status to other anti-infective agents status',NULL,NULL),
(71252,'Z884','Allergy status to anesthetic agent status',NULL,NULL),
(71253,'Z885','Allergy status to narcotic agent status',NULL,NULL),
(71254,'Z886','Allergy status to analgesic agent status',NULL,NULL),
(71255,'Z887','Allergy status to serum and vaccine status',NULL,NULL),
(71256,'Z888','Allergy status to other drugs, medicaments and biological substances status',NULL,NULL),
(71257,'Z889','Allergy status to unspecified drugs, medicaments and biological substances status',NULL,NULL),
(71258,'Z89011','Acquired absence of right thumb',NULL,NULL),
(71259,'Z89012','Acquired absence of left thumb',NULL,NULL),
(71260,'Z89019','Acquired absence of unspecified thumb',NULL,NULL),
(71261,'Z89021','Acquired absence of right finger(s)',NULL,NULL),
(71262,'Z89022','Acquired absence of left finger(s)',NULL,NULL),
(71263,'Z89029','Acquired absence of unspecified finger(s)',NULL,NULL),
(71264,'Z89111','Acquired absence of right hand',NULL,NULL),
(71265,'Z89112','Acquired absence of left hand',NULL,NULL),
(71266,'Z89119','Acquired absence of unspecified hand',NULL,NULL),
(71267,'Z89121','Acquired absence of right wrist',NULL,NULL),
(71268,'Z89122','Acquired absence of left wrist',NULL,NULL),
(71269,'Z89129','Acquired absence of unspecified wrist',NULL,NULL),
(71270,'Z89201','Acquired absence of right upper limb, unspecified level',NULL,NULL),
(71271,'Z89202','Acquired absence of left upper limb, unspecified level',NULL,NULL),
(71272,'Z89209','Acquired absence of unspecified upper limb, unspecified level',NULL,NULL),
(71273,'Z89211','Acquired absence of right upper limb below elbow',NULL,NULL),
(71274,'Z89212','Acquired absence of left upper limb below elbow',NULL,NULL),
(71275,'Z89219','Acquired absence of unspecified upper limb below elbow',NULL,NULL),
(71276,'Z89221','Acquired absence of right upper limb above elbow',NULL,NULL),
(71277,'Z89222','Acquired absence of left upper limb above elbow',NULL,NULL),
(71278,'Z89229','Acquired absence of unspecified upper limb above elbow',NULL,NULL),
(71279,'Z89231','Acquired absence of right shoulder',NULL,NULL),
(71280,'Z89232','Acquired absence of left shoulder',NULL,NULL),
(71281,'Z89239','Acquired absence of unspecified shoulder',NULL,NULL),
(71282,'Z89411','Acquired absence of right great toe',NULL,NULL),
(71283,'Z89412','Acquired absence of left great toe',NULL,NULL),
(71284,'Z89419','Acquired absence of unspecified great toe',NULL,NULL),
(71285,'Z89421','Acquired absence of other right toe(s)',NULL,NULL),
(71286,'Z89422','Acquired absence of other left toe(s)',NULL,NULL),
(71287,'Z89429','Acquired absence of other toe(s), unspecified side',NULL,NULL),
(71288,'Z89431','Acquired absence of right foot',NULL,NULL),
(71289,'Z89432','Acquired absence of left foot',NULL,NULL),
(71290,'Z89439','Acquired absence of unspecified foot',NULL,NULL),
(71291,'Z89441','Acquired absence of right ankle',NULL,NULL),
(71292,'Z89442','Acquired absence of left ankle',NULL,NULL),
(71293,'Z89449','Acquired absence of unspecified ankle',NULL,NULL),
(71294,'Z89511','Acquired absence of right leg below knee',NULL,NULL),
(71295,'Z89512','Acquired absence of left leg below knee',NULL,NULL),
(71296,'Z89519','Acquired absence of unspecified leg below knee',NULL,NULL),
(71297,'Z89521','Acquired absence of right knee',NULL,NULL),
(71298,'Z89522','Acquired absence of left knee',NULL,NULL),
(71299,'Z89529','Acquired absence of unspecified knee',NULL,NULL),
(71300,'Z89611','Acquired absence of right leg above knee',NULL,NULL),
(71301,'Z89612','Acquired absence of left leg above knee',NULL,NULL),
(71302,'Z89619','Acquired absence of unspecified leg above knee',NULL,NULL),
(71303,'Z89621','Acquired absence of right hip joint',NULL,NULL),
(71304,'Z89622','Acquired absence of left hip joint',NULL,NULL),
(71305,'Z89629','Acquired absence of unspecified hip joint',NULL,NULL),
(71306,'Z899','Acquired absence of limb, unspecified',NULL,NULL),
(71307,'Z9001','Acquired absence of eye',NULL,NULL),
(71308,'Z9002','Acquired absence of larynx',NULL,NULL),
(71309,'Z9009','Acquired absence of other part of head and neck',NULL,NULL),
(71310,'Z9010','Acquired absence of unspecified breast and nipple',NULL,NULL),
(71311,'Z9011','Acquired absence of right breast and nipple',NULL,NULL),
(71312,'Z9012','Acquired absence of left breast and nipple',NULL,NULL),
(71313,'Z9013','Acquired absence of bilateral breasts and nipples',NULL,NULL),
(71314,'Z902','Acquired absence of lung [part of]',NULL,NULL),
(71315,'Z903','Acquired absence of stomach [part of]',NULL,NULL),
(71316,'Z90410','Acquired total absence of pancreas',NULL,NULL),
(71317,'Z90411','Acquired partial absence of pancreas',NULL,NULL),
(71318,'Z9049','Acquired absence of other specified parts of digestive tract',NULL,NULL),
(71319,'Z905','Acquired absence of kidney',NULL,NULL),
(71320,'Z906','Acquired absence of other parts of urinary tract',NULL,NULL),
(71321,'Z90710','Acquired absence of both cervix and uterus',NULL,NULL),
(71322,'Z90711','Acquired absence of uterus with remaining cervical stump',NULL,NULL),
(71323,'Z90712','Acquired absence of cervix with remaining uterus',NULL,NULL),
(71324,'Z90721','Acquired absence of ovaries, unilateral',NULL,NULL),
(71325,'Z90722','Acquired absence of ovaries, bilateral',NULL,NULL),
(71326,'Z9079','Acquired absence of other genital organ(s)',NULL,NULL),
(71327,'Z9081','Acquired absence of spleen',NULL,NULL),
(71328,'Z9089','Acquired absence of other organs',NULL,NULL),
(71329,'Z91010','Allergy to peanuts',NULL,NULL),
(71330,'Z91011','Allergy to milk products',NULL,NULL),
(71331,'Z91012','Allergy to eggs',NULL,NULL),
(71332,'Z91013','Allergy to seafood',NULL,NULL),
(71333,'Z91018','Allergy to other foods',NULL,NULL),
(71334,'Z9102','Food additives allergy status',NULL,NULL),
(71335,'Z91030','Bee allergy status',NULL,NULL),
(71336,'Z91038','Other insect allergy status',NULL,NULL),
(71337,'Z91040','Latex allergy status',NULL,NULL),
(71338,'Z91041','Radiographic dye allergy status',NULL,NULL),
(71339,'Z91048','Other nonmedicinal substance allergy status',NULL,NULL),
(71340,'Z9109','Other allergy status, other than to drugs and biological substances',NULL,NULL),
(71341,'Z9111','Patient\'s noncompliance with dietary regimen',NULL,NULL),
(71342,'Z91120','Patient\'s intentional underdosing of medication regimen due to financial hardship',NULL,NULL),
(71343,'Z91128','Patient\'s intentional underdosing of medication regimen for other reason',NULL,NULL),
(71344,'Z91130','Patient\'s unintentional underdosing of medication regimen due to age-related debility',NULL,NULL),
(71345,'Z91138','Patient\'s unintentional underdosing of medication regimen for other reason',NULL,NULL),
(71346,'Z9114','Patient\'s other noncompliance with medication regimen',NULL,NULL),
(71347,'Z9115','Patient\'s noncompliance with renal dialysis',NULL,NULL),
(71348,'Z9119','Patient\'s noncompliance with other medical treatment and regimen',NULL,NULL),
(71349,'Z91410','Personal history of adult physical and sexual abuse',NULL,NULL),
(71350,'Z91411','Personal history of adult psychological abuse',NULL,NULL),
(71351,'Z91412','Personal history of adult neglect',NULL,NULL),
(71352,'Z91419','Personal history of unspecified adult abuse',NULL,NULL),
(71353,'Z9149','Other personal history of psychological trauma, not elsewhere classified',NULL,NULL),
(71354,'Z915','Personal history of self-harm',NULL,NULL),
(71355,'Z9181','History of falling',NULL,NULL),
(71356,'Z9182','Personal history of military deployment',NULL,NULL),
(71357,'Z9183','Wandering in diseases classified elsewhere',NULL,NULL),
(71358,'Z9189','Other specified personal risk factors, not elsewhere classified',NULL,NULL),
(71359,'Z920','Personal history of contraception',NULL,NULL),
(71360,'Z9221','Personal history of antineoplastic chemotherapy',NULL,NULL),
(71361,'Z9222','Personal history of monoclonal drug therapy',NULL,NULL),
(71362,'Z9223','Personal history of estrogen therapy',NULL,NULL),
(71363,'Z92240','Personal history of inhaled steroid therapy',NULL,NULL),
(71364,'Z92241','Personal history of systemic steroid therapy',NULL,NULL),
(71365,'Z9225','Personal history of immunosupression therapy',NULL,NULL),
(71366,'Z9229','Personal history of other drug therapy',NULL,NULL),
(71367,'Z923','Personal history of irradiation',NULL,NULL),
(71368,'Z9281','Personal history of extracorporeal membrane oxygenation (ECMO)',NULL,NULL),
(71369,'Z9282','Status post administration of tPA (rtPA) in a different facility within the last 24 hours prior to admission to current facility ',NULL,NULL),
(71370,'Z9283','Personal history of failed moderate sedation',NULL,NULL),
(71371,'Z9284','Personal history of unintended awareness under general anesthesia',NULL,NULL),
(71372,'Z9289','Personal history of other medical treatment',NULL,NULL),
(71373,'Z930','Tracheostomy status',NULL,NULL),
(71374,'Z931','Gastrostomy status',NULL,NULL),
(71375,'Z932','Ileostomy status',NULL,NULL),
(71376,'Z933','Colostomy status',NULL,NULL),
(71377,'Z934','Other artificial openings of gastrointestinal tract status',NULL,NULL),
(71378,'Z9350','Unspecified cystostomy status',NULL,NULL),
(71379,'Z9351','Cutaneous-vesicostomy status',NULL,NULL),
(71380,'Z9352','Appendico-vesicostomy status',NULL,NULL),
(71381,'Z9359','Other cystostomy status',NULL,NULL),
(71382,'Z936','Other artificial openings of urinary tract status',NULL,NULL),
(71383,'Z938','Other artificial opening status',NULL,NULL),
(71384,'Z939','Artificial opening status, unspecified',NULL,NULL),
(71385,'Z940','Kidney transplant status',NULL,NULL),
(71386,'Z941','Heart transplant status',NULL,NULL),
(71387,'Z942','Lung transplant status',NULL,NULL),
(71388,'Z943','Heart and lungs transplant status',NULL,NULL),
(71389,'Z944','Liver transplant status',NULL,NULL),
(71390,'Z945','Skin transplant status',NULL,NULL),
(71391,'Z946','Bone transplant status',NULL,NULL),
(71392,'Z947','Corneal transplant status',NULL,NULL),
(71393,'Z9481','Bone marrow transplant status',NULL,NULL),
(71394,'Z9482','Intestine transplant status',NULL,NULL),
(71395,'Z9483','Pancreas transplant status',NULL,NULL),
(71396,'Z9484','Stem cells transplant status',NULL,NULL),
(71397,'Z9489','Other transplanted organ and tissue status',NULL,NULL),
(71398,'Z949','Transplanted organ and tissue status, unspecified',NULL,NULL),
(71399,'Z950','Presence of cardiac pacemaker',NULL,NULL),
(71400,'Z951','Presence of aortocoronary bypass graft',NULL,NULL),
(71401,'Z952','Presence of prosthetic heart valve',NULL,NULL),
(71402,'Z953','Presence of xenogenic heart valve',NULL,NULL),
(71403,'Z954','Presence of other heart-valve replacement',NULL,NULL),
(71404,'Z955','Presence of coronary angioplasty implant and graft',NULL,NULL),
(71405,'Z95810','Presence of automatic (implantable) cardiac defibrillator',NULL,NULL),
(71406,'Z95811','Presence of heart assist device',NULL,NULL),
(71407,'Z95812','Presence of fully implantable artificial heart',NULL,NULL),
(71408,'Z95818','Presence of other cardiac implants and grafts',NULL,NULL),
(71409,'Z95820','Peripheral vascular angioplasty status with implants and grafts',NULL,NULL),
(71410,'Z95828','Presence of other vascular implants and grafts',NULL,NULL),
(71411,'Z959','Presence of cardiac and vascular implant and graft, unspecified',NULL,NULL),
(71412,'Z960','Presence of urogenital implants',NULL,NULL),
(71413,'Z961','Presence of intraocular lens',NULL,NULL),
(71414,'Z9620','Presence of otological and audiological implant, unspecified',NULL,NULL),
(71415,'Z9621','Cochlear implant status',NULL,NULL),
(71416,'Z9622','Myringotomy tube(s) status',NULL,NULL),
(71417,'Z9629','Presence of other otological and audiological implants',NULL,NULL),
(71418,'Z963','Presence of artificial larynx',NULL,NULL),
(71419,'Z9641','Presence of insulin pump (external) (internal)',NULL,NULL),
(71420,'Z9649','Presence of other endocrine implants',NULL,NULL),
(71421,'Z965','Presence of tooth-root and mandibular implants',NULL,NULL),
(71422,'Z9660','Presence of unspecified orthopedic joint implant',NULL,NULL),
(71423,'Z96611','Presence of right artificial shoulder joint',NULL,NULL),
(71424,'Z96612','Presence of left artificial shoulder joint',NULL,NULL),
(71425,'Z96619','Presence of unspecified artificial shoulder joint',NULL,NULL),
(71426,'Z96621','Presence of right artificial elbow joint',NULL,NULL),
(71427,'Z96622','Presence of left artificial elbow joint',NULL,NULL),
(71428,'Z96629','Presence of unspecified artificial elbow joint',NULL,NULL),
(71429,'Z96631','Presence of right artificial wrist joint',NULL,NULL),
(71430,'Z96632','Presence of left artificial wrist joint',NULL,NULL),
(71431,'Z96639','Presence of unspecified artificial wrist joint',NULL,NULL),
(71432,'Z96641','Presence of right artificial hip joint',NULL,NULL),
(71433,'Z96642','Presence of left artificial hip joint',NULL,NULL),
(71434,'Z96643','Presence of artificial hip joint, bilateral',NULL,NULL),
(71435,'Z96649','Presence of unspecified artificial hip joint',NULL,NULL),
(71436,'Z96651','Presence of right artificial knee joint',NULL,NULL),
(71437,'Z96652','Presence of left artificial knee joint',NULL,NULL),
(71438,'Z96653','Presence of artificial knee joint, bilateral',NULL,NULL),
(71439,'Z96659','Presence of unspecified artificial knee joint',NULL,NULL),
(71440,'Z96661','Presence of right artificial ankle joint',NULL,NULL),
(71441,'Z96662','Presence of left artificial ankle joint',NULL,NULL),
(71442,'Z96669','Presence of unspecified artificial ankle joint',NULL,NULL),
(71443,'Z96691','Finger-joint replacement of right hand',NULL,NULL),
(71444,'Z96692','Finger-joint replacement of left hand',NULL,NULL),
(71445,'Z96693','Finger-joint replacement, bilateral',NULL,NULL),
(71446,'Z96698','Presence of other orthopedic joint implants',NULL,NULL),
(71447,'Z967','Presence of other bone and tendon implants',NULL,NULL),
(71448,'Z9681','Presence of artificial skin',NULL,NULL),
(71449,'Z9689','Presence of other specified functional implants',NULL,NULL),
(71450,'Z969','Presence of functional implant, unspecified',NULL,NULL),
(71451,'Z970','Presence of artificial eye',NULL,NULL),
(71452,'Z9710','Presence of artificial limb (complete) (partial), unspecified',NULL,NULL),
(71453,'Z9711','Presence of artificial right arm (complete) (partial)',NULL,NULL),
(71454,'Z9712','Presence of artificial left arm (complete) (partial)',NULL,NULL),
(71455,'Z9713','Presence of artificial right leg (complete) (partial)',NULL,NULL),
(71456,'Z9714','Presence of artificial left leg (complete) (partial)',NULL,NULL),
(71457,'Z9715','Presence of artificial arms, bilateral (complete) (partial)',NULL,NULL),
(71458,'Z9716','Presence of artificial legs, bilateral (complete) (partial)',NULL,NULL),
(71459,'Z972','Presence of dental prosthetic device (complete) (partial)',NULL,NULL),
(71460,'Z973','Presence of spectacles and contact lenses',NULL,NULL),
(71461,'Z974','Presence of external hearing-aid',NULL,NULL),
(71462,'Z975','Presence of (intrauterine) contraceptive device',NULL,NULL),
(71463,'Z978','Presence of other specified devices',NULL,NULL),
(71464,'Z980','Intestinal bypass and anastomosis status',NULL,NULL),
(71465,'Z981','Arthrodesis status',NULL,NULL),
(71466,'Z982','Presence of cerebrospinal fluid drainage device',NULL,NULL),
(71467,'Z983','Post therapeutic collapse of lung status',NULL,NULL),
(71468,'Z9841','Cataract extraction status, right eye',NULL,NULL),
(71469,'Z9842','Cataract extraction status, left eye',NULL,NULL),
(71470,'Z9849','Cataract extraction status, unspecified eye',NULL,NULL),
(71471,'Z9851','Tubal ligation status',NULL,NULL),
(71472,'Z9852','Vasectomy status',NULL,NULL),
(71473,'Z9861','Coronary angioplasty status',NULL,NULL),
(71474,'Z9862','Peripheral vascular angioplasty status',NULL,NULL),
(71475,'Z98810','Dental sealant status',NULL,NULL),
(71476,'Z98811','Dental restoration status',NULL,NULL),
(71477,'Z98818','Other dental procedure status',NULL,NULL),
(71478,'Z9882','Breast implant status',NULL,NULL),
(71479,'Z9883','Filtering (vitreous) bleb after glaucoma surgery status',NULL,NULL),
(71480,'Z9884','Bariatric surgery status',NULL,NULL),
(71481,'Z9885','Transplanted organ removal status',NULL,NULL),
(71482,'Z9886','Personal history of breast implant removal',NULL,NULL),
(71483,'Z98870','Personal history of in utero procedure during pregnancy',NULL,NULL),
(71484,'Z98871','Personal history of in utero procedure while a fetus',NULL,NULL),
(71485,'Z98890','Other specified postprocedural states',NULL,NULL),
(71486,'Z98891','History of uterine scar from previous surgery',NULL,NULL),
(71487,'Z990','Dependence on aspirator',NULL,NULL),
(71488,'Z9911','Dependence on respirator [ventilator] status',NULL,NULL),
(71489,'Z9912','Encounter for respirator [ventilator] dependence during power failure',NULL,NULL),
(71490,'Z992','Dependence on renal dialysis',NULL,NULL),
(71491,'Z993','Dependence on wheelchair',NULL,NULL),
(71492,'Z9981','Dependence on supplemental oxygen',NULL,NULL),
(71493,'Z9989','Dependence on other enabling machines and devices',NULL,NULL);

/*Table structure for table `log_activity` */


CREATE TABLE `log_activity` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `check_in_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `check_out_time` timestamp NULL DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0' COMMENT '0=not deleted,1=deleted',
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location_details` longtext COLLATE utf8mb4_unicode_ci,
  `created_by` int(11) NOT NULL DEFAULT '0',
  `updated_by` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `log_activity` */

insert  into `log_activity`(`id`,`check_in_time`,`check_out_time`,`user_id`,`deleted`,`subject`,`url`,`method`,`ip`,`agent`,`location_details`,`created_by`,`updated_by`,`created_at`,`updated_at`) values 
(5,'2024-03-08 05:57:15',NULL,14,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','125.209.99.30','Mozilla/5.0 (X11; CrOS x86_64 14541.0.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36','{\"ip\":\"125.209.99.30\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75300\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9246\",\"longitude\":\"67.087\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-08 00:57:15','2024-03-08 00:57:15'),
(6,'2024-03-08 08:44:39',NULL,15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','116.90.103.53','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"116.90.103.53\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75500\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-08 03:44:39','2024-03-08 03:44:39'),
(7,'2024-03-08 15:15:50',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-08 10:15:50','2024-03-08 10:15:50'),
(12,'2024-03-09 08:16:40',NULL,15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','116.90.103.252','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"116.90.103.252\",\"countryName\":null,\"countryCode\":\"PK\",\"regionCode\":null,\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8608\",\"longitude\":\"67.0104\",\"metroCode\":null,\"areaCode\":null,\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpInfo\"}',0,0,'2024-03-09 03:16:40','2024-03-09 03:16:40'),
(13,'2024-03-11 08:31:14','2024-03-11 12:01:34',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','116.90.103.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"116.90.103.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75500\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-11 03:31:14','2024-03-11 12:01:34'),
(14,'2024-03-11 08:38:37',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.180.72.131','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"182.180.72.131\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7233\",\"longitude\":\"73.0435\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-11 03:38:37','2024-03-11 03:38:37'),
(15,'2024-03-11 10:24:09',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.71','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.71\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-11 05:24:09','2024-03-11 05:24:09'),
(16,'2024-03-11 11:42:22',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.71','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.71\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-11 06:42:22','2024-03-11 06:42:22'),
(17,'2024-03-11 15:17:59','2024-03-11 13:24:59',22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-11 10:17:59','2024-03-11 13:24:59'),
(21,'2024-03-12 08:13:33','2024-03-12 10:34:20',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','125.62.88.84','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"125.62.88.84\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 03:13:33','2024-03-12 10:34:20'),
(22,'2024-03-12 08:54:19',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.180.72.131','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"182.180.72.131\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7233\",\"longitude\":\"73.0435\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 03:54:19','2024-03-12 03:54:19'),
(23,'2024-03-12 09:15:42',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.180.72.131','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"182.180.72.131\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7233\",\"longitude\":\"73.0435\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 04:15:42','2024-03-12 04:15:42'),
(24,'2024-03-12 10:13:10',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.219.61','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.219.61\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 05:13:10','2024-03-12 05:13:10'),
(25,'2024-03-12 10:20:37',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.219.61','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.219.61\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 05:20:37','2024-03-12 05:20:37'),
(26,'2024-03-12 11:31:10',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.180.72.131','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"182.180.72.131\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7233\",\"longitude\":\"73.0435\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 06:31:10','2024-03-12 06:31:10'),
(27,'2024-03-12 11:32:53',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 06:32:53','2024-03-12 06:32:53'),
(28,'2024-03-12 12:45:41',NULL,20,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','72.255.58.55','Mozilla/5.0 (iPhone; CPU iPhone OS 17_1_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.1.2 Mobile/15E148 Safari/604.1','{\"ip\":\"72.255.58.55\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 07:45:41','2024-03-12 07:45:41'),
(29,'2024-03-12 13:04:14',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.137.239','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.137.239\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"BA\",\"regionName\":\"Balochistan\",\"cityName\":\"Barkhan\",\"zipCode\":\"\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"29.8977\",\"longitude\":\"69.5256\",\"metroCode\":null,\"areaCode\":\"BA\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 08:04:14','2024-03-12 08:04:14'),
(30,'2024-03-12 13:41:29',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.219.61','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.219.61\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 08:41:29','2024-03-12 08:41:29'),
(31,'2024-03-12 15:22:00','2024-03-12 11:53:24',20,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','72.255.58.55','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"72.255.58.55\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-12 10:22:00','2024-03-12 11:53:24'),
(32,'2024-03-13 08:07:07',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.86','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.86\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 03:07:07','2024-03-13 03:07:07'),
(33,'2024-03-13 08:19:45',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','223.123.112.235','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.112.235\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74700\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 03:19:45','2024-03-13 03:19:45'),
(34,'2024-03-13 08:22:53',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','137.59.227.105','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"137.59.227.105\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74400\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 03:22:53','2024-03-13 03:22:53'),
(35,'2024-03-13 08:33:34','2024-03-13 10:30:23',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.155.176.42','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.155.176.42\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74700\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 03:33:34','2024-03-13 10:30:23'),
(36,'2024-03-13 09:30:00',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 04:30:00','2024-03-13 04:30:00'),
(37,'2024-03-13 10:57:15',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.215.89','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.215.89\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 05:57:15','2024-03-13 05:57:15'),
(38,'2024-03-13 11:36:06',NULL,20,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','154.91.162.8','Mozilla/5.0 (iPhone; CPU iPhone OS 17_1_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.1.2 Mobile/15E148 Safari/604.1','{\"ip\":\"154.91.162.8\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44010\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7233\",\"longitude\":\"73.0435\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 06:36:06','2024-03-13 06:36:06'),
(39,'2024-03-13 11:37:13',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.180.72.131','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"182.180.72.131\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7233\",\"longitude\":\"73.0435\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 06:37:13','2024-03-13 06:37:13'),
(40,'2024-03-13 12:02:04',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 07:02:04','2024-03-13 07:02:04'),
(41,'2024-03-13 14:01:44','2024-03-13 09:50:09',20,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.215.89','Mozilla/5.0 (iPhone; CPU iPhone OS 17_1_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.1.2 Mobile/15E148 Safari/604.1','{\"ip\":\"111.88.215.89\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 09:01:44','2024-03-13 09:50:09'),
(42,'2024-03-13 14:07:33',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.157.78.23','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.157.78.23\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 09:07:33','2024-03-13 09:07:33'),
(43,'2024-03-13 17:44:52',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.212.205','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.212.205\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 12:44:52','2024-03-13 12:44:52'),
(44,'2024-03-13 21:31:52',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.163.51','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.163.51\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 16:31:52','2024-03-13 16:31:52'),
(45,'2024-03-14 02:40:25',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.86','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.86\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-13 21:40:25','2024-03-13 21:40:25'),
(46,'2024-03-14 05:03:58',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.86','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.86\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 00:03:58','2024-03-14 00:03:58'),
(47,'2024-03-14 08:16:32',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','223.123.111.228','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.111.228\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75800\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9551\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 03:16:32','2024-03-14 03:16:32'),
(48,'2024-03-14 08:30:08',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','137.59.227.105','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"137.59.227.105\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74400\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 03:30:08','2024-03-14 03:30:08'),
(49,'2024-03-14 09:15:30',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 04:15:30','2024-03-14 04:15:30'),
(50,'2024-03-14 09:36:10',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.217.54','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.217.54\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 04:36:10','2024-03-14 04:36:10'),
(51,'2024-03-14 11:01:18',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','125.62.88.128','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"125.62.88.128\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 06:01:18','2024-03-14 06:01:18'),
(52,'2024-03-14 11:03:18',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','223.123.104.54','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.104.54\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74700\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 06:03:18','2024-03-14 06:03:18'),
(53,'2024-03-14 11:28:41',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.217.54','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.217.54\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 06:28:41','2024-03-14 06:28:41'),
(54,'2024-03-14 12:53:39','2024-03-14 07:59:23',22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.134.107','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.134.107\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7215\",\"longitude\":\"73.0433\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 07:53:39','2024-03-14 07:59:23'),
(55,'2024-03-14 14:50:38',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','125.62.88.247','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"125.62.88.247\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-14 09:50:38','2024-03-14 09:50:38'),
(56,'2024-03-15 08:23:05','2024-03-15 07:12:41',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','116.90.103.213','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"116.90.103.213\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75500\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-15 03:23:05','2024-03-15 07:12:41'),
(57,'2024-03-15 08:37:23',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.180.72.131','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"182.180.72.131\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7233\",\"longitude\":\"73.0435\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-15 03:37:23','2024-03-15 03:37:23'),
(58,'2024-03-15 09:02:11',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.86','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.86\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-15 04:02:11','2024-03-15 04:02:11'),
(59,'2024-03-15 10:05:56','2024-03-15 09:29:55',23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-15 05:05:56','2024-03-15 09:29:55'),
(60,'2024-03-15 11:10:42',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','202.47.35.189','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"202.47.35.189\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74700\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-15 06:10:42','2024-03-15 06:10:42'),
(61,'2024-03-15 12:30:06',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.208.115','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.208.115\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-15 07:30:06','2024-03-15 07:30:06'),
(64,'2024-03-16 01:09:15',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.86','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.86\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-15 20:09:15','2024-03-15 20:09:15'),
(65,'2024-03-16 08:19:19','2024-03-16 10:33:29',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','116.90.103.139','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"116.90.103.139\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75500\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-16 03:19:19','2024-03-16 10:33:29'),
(66,'2024-03-17 16:53:23',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.129','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.129\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-17 11:53:23','2024-03-17 11:53:23'),
(67,'2024-03-18 08:27:32',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.165.70','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.165.70\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-18 03:27:32','2024-03-18 03:27:32'),
(68,'2024-03-18 08:39:00','2024-03-18 10:36:01',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','125.62.88.15','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"125.62.88.15\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-18 03:39:00','2024-03-18 10:36:01'),
(69,'2024-03-18 09:10:17','2024-03-18 07:23:11',22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-18 04:10:17','2024-03-18 07:23:11'),
(70,'2024-03-18 10:06:53',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.223.13','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.223.13\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-18 05:06:53','2024-03-18 05:06:53'),
(71,'2024-03-18 11:27:46',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','223.123.112.168','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.112.168\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75300\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9246\",\"longitude\":\"67.087\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-18 06:27:46','2024-03-18 06:27:46'),
(72,'2024-03-18 14:47:55',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.34.154.254','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.34.154.254\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-18 09:47:55','2024-03-18 09:47:55'),
(73,'2024-03-18 21:11:14',NULL,20,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.182.41.4','Mozilla/5.0 (iPhone; CPU iPhone OS 17_1_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.1.2 Mobile/15E148 Safari/604.1','{\"ip\":\"182.182.41.4\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Tando Allahyar\",\"zipCode\":\"70010\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"25.4605\",\"longitude\":\"68.7175\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-18 16:11:14','2024-03-18 16:11:14'),
(74,'2024-03-19 08:23:12',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','223.123.113.246','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.113.246\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75300\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9246\",\"longitude\":\"67.087\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 03:23:12','2024-03-19 03:23:12'),
(75,'2024-03-19 08:38:16','2024-03-19 10:22:15',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','116.90.103.182','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"116.90.103.182\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75500\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 03:38:16','2024-03-19 10:22:15'),
(76,'2024-03-19 08:38:24',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.165.70','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.165.70\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 03:38:24','2024-03-19 03:38:24'),
(77,'2024-03-19 09:17:46',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.128.11','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.128.11\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"KP\",\"regionName\":\"Khyber Pakhtunkhwa\",\"cityName\":\"Zaida\",\"zipCode\":\"23540\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"34.0595\",\"longitude\":\"72.4669\",\"metroCode\":null,\"areaCode\":\"KP\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 04:17:46','2024-03-19 04:17:46'),
(78,'2024-03-19 09:18:44',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.128.11','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.128.11\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"KP\",\"regionName\":\"Khyber Pakhtunkhwa\",\"cityName\":\"Zaida\",\"zipCode\":\"23540\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"34.0595\",\"longitude\":\"72.4669\",\"metroCode\":null,\"areaCode\":\"KP\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 04:18:44','2024-03-19 04:18:44'),
(79,'2024-03-19 09:40:08',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.212.114','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.212.114\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 04:40:08','2024-03-19 04:40:08'),
(80,'2024-03-19 09:56:22','2024-03-19 07:20:18',22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 04:56:22','2024-03-19 07:20:18'),
(81,'2024-03-19 10:29:32','2024-03-19 05:55:41',12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.212.114','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.212.114\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 05:29:32','2024-03-19 05:55:41'),
(82,'2024-03-19 10:41:13',NULL,20,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.212.114','Mozilla/5.0 (iPhone; CPU iPhone OS 17_1_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.1.2 Mobile/15E148 Safari/604.1','{\"ip\":\"111.88.212.114\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 05:41:13','2024-03-19 05:41:13'),
(83,'2024-03-19 10:57:52','2024-03-19 08:42:56',20,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.212.114','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.212.114\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 05:57:52','2024-03-19 08:42:56'),
(84,'2024-03-19 11:31:50',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','137.59.227.105','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"137.59.227.105\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74400\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 06:31:50','2024-03-19 06:31:50'),
(85,'2024-03-19 13:59:54','2024-03-19 09:31:22',20,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.212.114','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.212.114\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 08:59:54','2024-03-19 09:31:22'),
(86,'2024-03-19 17:46:11',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.129','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.129\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 12:46:11','2024-03-19 12:46:11'),
(87,'2024-03-19 21:17:36',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.221.88','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.221.88\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 16:17:36','2024-03-19 16:17:36'),
(88,'2024-03-19 21:43:10',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.163.251','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.163.251\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-19 16:43:10','2024-03-19 16:43:10'),
(89,'2024-03-20 08:20:27',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','223.123.115.145','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.115.145\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75300\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9246\",\"longitude\":\"67.087\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 03:20:27','2024-03-20 03:20:27'),
(90,'2024-03-20 08:20:44',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','223.123.115.145','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.115.145\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75300\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9246\",\"longitude\":\"67.087\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 03:20:44','2024-03-20 03:20:44'),
(91,'2024-03-20 08:32:26',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.180.72.131','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"182.180.72.131\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"PB\",\"regionName\":\"Punjab\",\"cityName\":\"Rawalpindi\",\"zipCode\":\"46000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.6054\",\"longitude\":\"73.0354\",\"metroCode\":null,\"areaCode\":\"PB\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 03:32:26','2024-03-20 03:32:26'),
(92,'2024-03-20 08:41:19','2024-03-20 10:38:30',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','125.62.88.48','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"125.62.88.48\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 03:41:19','2024-03-20 10:38:30'),
(93,'2024-03-20 09:09:59',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.140.153','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.140.153\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"JK\",\"regionName\":\"Azad Jammu and Kashmir\",\"cityName\":\"Muzaffarabad\",\"zipCode\":\"24601\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"34.37\",\"longitude\":\"73.4708\",\"metroCode\":null,\"areaCode\":\"JK\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 04:09:59','2024-03-20 04:09:59'),
(94,'2024-03-20 09:24:55','2024-03-20 07:31:15',22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 04:24:55','2024-03-20 07:31:15'),
(95,'2024-03-20 10:02:58',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.209.166','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.209.166\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 05:02:58','2024-03-20 05:02:58'),
(96,'2024-03-20 10:30:06',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.209.166','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.209.166\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 05:30:06','2024-03-20 05:30:06'),
(97,'2024-03-20 11:29:27',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.165.70','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.165.70\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 06:29:27','2024-03-20 06:29:27'),
(98,'2024-03-20 11:31:15',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','39.50.165.70','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"39.50.165.70\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 06:31:15','2024-03-20 06:31:15'),
(99,'2024-03-20 16:18:57',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.218.135','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.218.135\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 11:18:57','2024-03-20 11:18:57'),
(100,'2024-03-20 19:41:52',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.129','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.129\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 14:41:52','2024-03-20 14:41:52'),
(101,'2024-03-20 22:29:43',NULL,14,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','99.185.60.55','Mozilla/5.0 (X11; CrOS x86_64 14541.0.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"99.185.60.55\",\"countryName\":\"United States\",\"countryCode\":\"US\",\"regionCode\":\"MI\",\"regionName\":\"Michigan\",\"cityName\":\"West Bloomfield\",\"zipCode\":\"48323\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"42.5655\",\"longitude\":\"-83.3783\",\"metroCode\":null,\"areaCode\":\"MI\",\"timezone\":\"America\\/Detroit\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 17:29:43','2024-03-20 17:29:43'),
(102,'2024-03-20 22:43:35','2024-03-20 17:45:31',17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 17:43:35','2024-03-20 17:45:31'),
(103,'2024-03-20 22:45:43','2024-03-20 23:06:07',17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 17:45:43','2024-03-20 18:06:07'),
(104,'2024-03-20 23:06:10',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 18:06:10','2024-03-20 18:06:10'),
(105,'2024-03-20 23:06:47','2024-03-20 23:08:09',17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.236','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.236\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 18:06:47','2024-03-20 18:08:09'),
(106,'2024-03-20 23:08:12','2024-03-20 23:09:29',17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.236','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.236\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 18:08:12','2024-03-20 18:09:29'),
(107,'2024-03-21 00:07:46',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.236','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.236\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 19:07:46','2024-03-20 19:07:46'),
(108,'2024-03-21 01:01:02',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-20 20:01:02','2024-03-20 20:01:02'),
(109,'2024-03-21 08:26:05',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','223.123.105.132','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.105.132\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75300\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9246\",\"longitude\":\"67.087\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 03:26:05','2024-03-21 03:26:05'),
(110,'2024-03-21 08:38:23',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.165.70','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.165.70\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 03:38:23','2024-03-21 03:38:23'),
(111,'2024-03-21 08:44:53','2024-03-21 15:30:24',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.155.223.34','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.155.223.34\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8607\",\"longitude\":\"67.0011\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 03:44:53','2024-03-21 10:30:24'),
(112,'2024-03-21 09:08:08',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.137.92','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.137.92\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"JK\",\"regionName\":\"Azad Jammu and Kashmir\",\"cityName\":\"Muzaffarabad\",\"zipCode\":\"24601\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"34.37\",\"longitude\":\"73.4708\",\"metroCode\":null,\"areaCode\":\"JK\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 04:08:08','2024-03-21 04:08:08'),
(113,'2024-03-21 09:11:32',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.97.129','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.73.97.129\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 04:11:32','2024-03-21 04:11:32'),
(114,'2024-03-21 09:24:29',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 04:24:29','2024-03-21 04:24:29'),
(115,'2024-03-21 10:35:09','2024-03-21 14:32:05',20,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.218.135','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.218.135\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 05:35:09','2024-03-21 09:32:05'),
(116,'2024-03-21 11:00:13',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.218.135','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.218.135\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 06:00:13','2024-03-21 06:00:13'),
(117,'2024-03-21 11:43:36',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.211.180','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"111.88.211.180\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 06:43:36','2024-03-21 06:43:36'),
(118,'2024-03-21 12:01:26','2024-03-21 12:25:12',22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 07:01:26','2024-03-21 07:25:12'),
(119,'2024-03-21 21:53:21',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-21 16:53:21','2024-03-21 16:53:21'),
(120,'2024-03-22 08:20:44',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','223.123.104.35','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.104.35\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75300\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9246\",\"longitude\":\"67.087\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-22 03:20:44','2024-03-22 03:20:44'),
(121,'2024-03-22 08:46:56','2024-03-22 11:50:10',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','125.62.88.6','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"125.62.88.6\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-22 03:46:56','2024-03-22 06:50:10'),
(122,'2024-03-22 09:05:51',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.134.240','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.134.240\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.7215\",\"longitude\":\"73.0433\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-22 04:05:51','2024-03-22 04:05:51'),
(123,'2024-03-22 09:19:36',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-22 04:19:36','2024-03-22 04:19:36'),
(124,'2024-03-23 01:46:00','2024-03-23 01:46:16',17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-22 20:46:00','2024-03-22 20:46:16'),
(125,'2024-03-23 01:46:20','2024-03-23 01:46:58',17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-22 20:46:20','2024-03-22 20:46:58'),
(126,'2024-03-25 09:04:04','2024-03-25 15:00:20',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.155.214.103','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.155.214.103\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75850\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9811\",\"longitude\":\"67.0725\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-25 04:04:04','2024-03-25 10:00:20'),
(127,'2024-03-25 09:04:19',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.167.228','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.167.228\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Islamkot\",\"zipCode\":\"\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.699\",\"longitude\":\"70.1798\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-25 04:04:19','2024-03-25 04:04:19'),
(128,'2024-03-25 09:46:32',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-25 04:46:32','2024-03-25 04:46:32'),
(129,'2024-03-25 10:03:28',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.213.194','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.213.194\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-25 05:03:28','2024-03-25 05:03:28'),
(130,'2024-03-26 00:40:51',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-25 19:40:51','2024-03-25 19:40:51'),
(131,'2024-03-26 01:36:38',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-25 20:36:38','2024-03-25 20:36:38'),
(132,'2024-03-26 09:05:17',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.164.163','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.164.163\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8608\",\"longitude\":\"67.0104\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 04:05:17','2024-03-26 04:05:17'),
(133,'2024-03-26 09:07:19',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.164.163','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.164.163\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8608\",\"longitude\":\"67.0104\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 04:07:19','2024-03-26 04:07:19'),
(134,'2024-03-26 09:12:56','2024-03-26 15:00:19',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.155.195.103','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"119.155.195.103\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75780\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8794\",\"longitude\":\"66.992\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 04:12:56','2024-03-26 10:00:19'),
(135,'2024-03-26 09:39:09',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 04:39:09','2024-03-26 04:39:09'),
(136,'2024-03-26 10:12:26',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','182.180.72.131','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"182.180.72.131\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"PB\",\"regionName\":\"Punjab\",\"cityName\":\"Rawalpindi\",\"zipCode\":\"46000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.6054\",\"longitude\":\"73.0354\",\"metroCode\":null,\"areaCode\":\"PB\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 05:12:26','2024-03-26 05:12:26'),
(137,'2024-03-26 11:56:07',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.156.45','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.156.45\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 06:56:07','2024-03-26 06:56:07'),
(138,'2024-03-26 11:58:39',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.255','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.255\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 06:58:39','2024-03-26 06:58:39'),
(139,'2024-03-26 14:24:32',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.255','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.255\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 09:24:32','2024-03-26 09:24:32'),
(140,'2024-03-26 20:57:08',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 15:57:08','2024-03-26 15:57:08'),
(141,'2024-03-26 23:43:46',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','223.123.115.165','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.115.165\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75300\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9246\",\"longitude\":\"67.087\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 18:43:46','2024-03-26 18:43:46'),
(142,'2024-03-27 01:02:08',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-26 20:02:08','2024-03-26 20:02:08'),
(143,'2024-03-27 08:59:32','2024-03-27 14:56:18',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.34.173','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.34.173\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-27 03:59:32','2024-03-27 09:56:18'),
(144,'2024-03-27 09:04:44',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.159','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.159\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-27 04:04:44','2024-03-27 04:04:44'),
(145,'2024-03-27 09:10:27',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','202.47.35.189','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"202.47.35.189\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-27 04:10:27','2024-03-27 04:10:27'),
(146,'2024-03-27 09:29:58',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-27 04:29:58','2024-03-27 04:29:58'),
(147,'2024-03-27 12:27:24','2024-03-27 12:27:30',22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.139.82','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.139.82\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"IS\",\"regionName\":\"Islamabad\",\"cityName\":\"Islamabad\",\"zipCode\":\"44000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"33.6843\",\"longitude\":\"72.9885\",\"metroCode\":null,\"areaCode\":\"IS\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-27 07:27:24','2024-03-27 07:27:30'),
(148,'2024-03-27 22:16:34',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-27 17:16:34','2024-03-27 17:16:34'),
(149,'2024-03-28 02:07:05',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-27 21:07:05','2024-03-27 21:07:05'),
(150,'2024-03-28 09:00:53','2024-03-28 15:00:07',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.45.86','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.45.86\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74900\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-28 04:00:53','2024-03-28 10:00:07'),
(151,'2024-03-28 09:41:34',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.159','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.159\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-28 04:41:34','2024-03-28 04:41:34'),
(152,'2024-03-28 09:42:37',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','202.47.35.189','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"202.47.35.189\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-28 04:42:37','2024-03-28 04:42:37'),
(153,'2024-03-28 10:05:51',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-28 05:05:51','2024-03-28 05:05:51'),
(154,'2024-03-28 12:46:27',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.159','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.159\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-28 07:46:27','2024-03-28 07:46:27'),
(155,'2024-03-29 02:56:46',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-28 21:56:46','2024-03-28 21:56:46'),
(156,'2024-03-29 09:05:51','2024-03-29 12:16:06',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.35.136','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.35.136\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-29 04:05:51','2024-03-29 07:16:06'),
(157,'2024-03-29 09:08:25',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','202.47.35.189','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"202.47.35.189\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-29 04:08:25','2024-03-29 04:08:25'),
(158,'2024-03-29 09:28:45','2024-03-29 11:40:46',22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-29 04:28:45','2024-03-29 06:40:46'),
(159,'2024-03-29 10:54:32',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-29 05:54:32','2024-03-29 05:54:32'),
(160,'2024-03-29 12:08:50',NULL,12,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-29 07:08:50','2024-03-29 07:08:50'),
(161,'2024-03-29 15:10:03',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-29 10:10:03','2024-03-29 10:10:03'),
(162,'2024-03-29 15:22:33',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.216.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.216.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-29 10:22:33','2024-03-29 10:22:33'),
(163,'2024-03-29 22:51:04',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-29 17:51:04','2024-03-29 17:51:04'),
(164,'2024-03-30 09:00:10','2024-03-30 14:59:16',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.43.96','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.43.96\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75800\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9551\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-03-30 04:00:10','2024-03-30 09:59:16'),
(165,'2024-04-01 09:06:20',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.104.144','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"119.73.104.144\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-01 04:06:20','2024-04-01 04:06:20'),
(166,'2024-04-01 12:56:09',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.104.144','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"119.73.104.144\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-01 07:56:09','2024-04-01 07:56:09'),
(167,'2024-04-01 20:54:02',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-01 15:54:02','2024-04-01 15:54:02'),
(168,'2024-04-01 22:47:10',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-01 17:47:10','2024-04-01 17:47:10'),
(169,'2024-04-02 01:51:31',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-01 20:51:31','2024-04-01 20:51:31'),
(170,'2024-04-02 08:02:32',NULL,18,0,'Logged In.','http://cphs.biopharmainfo.net/admin/login','POST','223.123.109.97','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Mobile Safari/537.36','{\"ip\":\"223.123.109.97\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75800\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.9551\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 03:02:32','2024-04-02 03:02:32'),
(171,'2024-04-02 08:16:52',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.73.104.57','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"119.73.104.57\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74600\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 03:16:52','2024-04-02 03:16:52'),
(172,'2024-04-02 08:24:20',NULL,18,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','137.59.227.105','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"137.59.227.105\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74400\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 03:24:20','2024-04-02 03:24:20'),
(173,'2024-04-02 09:04:08',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.150.167','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.150.167\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"PB\",\"regionName\":\"Punjab\",\"cityName\":\"Lahore\",\"zipCode\":\"54000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"31.5826\",\"longitude\":\"74.3276\",\"metroCode\":null,\"areaCode\":\"PB\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 04:04:08','2024-04-02 04:04:08'),
(174,'2024-04-02 09:04:14','2024-04-02 15:00:02',15,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','119.155.162.195','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"119.155.162.195\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75080\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8741\",\"longitude\":\"67.1906\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 04:04:14','2024-04-02 10:00:02'),
(175,'2024-04-02 09:04:45',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','37.111.150.167','Mozilla/5.0 (iPhone; CPU iPhone OS 16_7_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1','{\"ip\":\"37.111.150.167\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"PB\",\"regionName\":\"Punjab\",\"cityName\":\"Lahore\",\"zipCode\":\"54000\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"31.5826\",\"longitude\":\"74.3276\",\"metroCode\":null,\"areaCode\":\"PB\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 04:04:45','2024-04-02 04:04:45'),
(176,'2024-04-02 09:19:40',NULL,22,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','175.107.236.36','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"175.107.236.36\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 04:19:40','2024-04-02 04:19:40'),
(177,'2024-04-02 16:00:39',NULL,23,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.210.104','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.210.104\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 11:00:39','2024-04-02 11:00:39'),
(178,'2024-04-02 22:08:16',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','111.88.209.110','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"111.88.209.110\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"75650\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.7929\",\"longitude\":\"66.9719\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 17:08:16','2024-04-02 17:08:16'),
(179,'2024-04-02 22:48:56',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 17:48:56','2024-04-02 17:48:56'),
(180,'2024-04-03 00:05:09',NULL,17,0,'Logged In.','https://cphs.biopharmainfo.net/admin/login','POST','39.50.175.133','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36','{\"ip\":\"39.50.175.133\",\"countryName\":\"Pakistan\",\"countryCode\":\"PK\",\"regionCode\":\"SD\",\"regionName\":\"Sindh\",\"cityName\":\"Karachi\",\"zipCode\":\"74200\",\"isoCode\":null,\"postalCode\":null,\"latitude\":\"24.8591\",\"longitude\":\"66.9983\",\"metroCode\":null,\"areaCode\":\"SD\",\"timezone\":\"Asia\\/Karachi\",\"driver\":\"Stevebauman\\\\Location\\\\Drivers\\\\IpApi\"}',0,0,'2024-04-02 19:05:09','2024-04-02 19:05:09');

/*Table structure for table `lower_respiratory_sobs` */


CREATE TABLE `lower_respiratory_sobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `OnExertionMild` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `OnExertionModerate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `OnExertionSevere` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Wheezing` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Crackles` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `lower_respiratory_sobs` */

insert  into `lower_respiratory_sobs`(`id`,`form_id`,`GnInfoId`,`OnExertionMild`,`OnExertionModerate`,`OnExertionSevere`,`Wheezing`,`Crackles`,`created_at`,`updated_at`) values 
(8,NULL,8,'Dolore amet eiusmod','Est beatae repellen','Iure maiores ab quam','Sed odit veritatis i','Proident in omnis c','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Dolore amet eiusmod','Est beatae repellen','Iure maiores ab quam','Sed odit veritatis i','Proident in omnis c','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Dolore amet eiusmod','Est beatae repellen','Iure maiores ab quam','Sed odit veritatis i','Proident in omnis c','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Dolore amet eiusmod','Est beatae repellen','Iure maiores ab quam','Sed odit veritatis i','Proident in omnis c','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Dolore amet eiusmod','Est beatae repellen','Iure maiores ab quam','Sed odit veritatis i','Proident in omnis c','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Dolore amet eiusmod','Est beatae repellen','Iure maiores ab quam','Sed odit veritatis i','Proident in omnis c','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Dolore amet eiusmod','Est beatae repellen','Iure maiores ab quam','Sed odit veritatis i','Proident in omnis c','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'On Exertion Mild','On Exertion Moderate','On Exertion Severe','Wheezing','Crackles','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `lower_respiratory_tract_infections` */


CREATE TABLE `lower_respiratory_tract_infections` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `SputumColor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `SputumQuantity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Brasky` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Whooping` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `BloodInSputum` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `lower_respiratory_tract_infections` */

insert  into `lower_respiratory_tract_infections`(`id`,`form_id`,`GnInfoId`,`SputumColor`,`SputumQuantity`,`Brasky`,`Whooping`,`BloodInSputum`,`created_at`,`updated_at`) values 
(8,NULL,8,'Omnis perspiciatis','910','A quasi nostrum aut','Quos assumenda et sa','Eligendi veritatis s','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Omnis perspiciatis','910','A quasi nostrum aut','Quos assumenda et sa','Eligendi veritatis s','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Omnis perspiciatis','910','A quasi nostrum aut','Quos assumenda et sa','Eligendi veritatis s','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Omnis perspiciatis','910','A quasi nostrum aut','Quos assumenda et sa','Eligendi veritatis s','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Omnis perspiciatis','910','A quasi nostrum aut','Quos assumenda et sa','Eligendi veritatis s','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Omnis perspiciatis','910','A quasi nostrum aut','Quos assumenda et sa','Eligendi veritatis s','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Omnis perspiciatis','910','A quasi nostrum aut','Quos assumenda et sa','Eligendi veritatis s','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(19,NULL,17,'Omnis perspiciatis','910','A quasi nostrum aut','Quos assumenda et sa','Eligendi veritatis s','2024-04-01 20:21:29','2024-04-01 20:21:29'),
(20,NULL,18,'Sputum color','Sputum quantity','Brasky','Whooping','Blood in sputum','2024-04-01 21:01:01','2024-04-01 21:01:01'),
(21,NULL,18,'Sputum color','Sputum quantity','Brasky','Whooping','Blood in sputum','2024-04-01 21:22:40','2024-04-01 21:22:40'),
(22,NULL,18,'Sputum color','Sputum quantity','Brasky','Whooping','Blood in sputum','2024-04-01 21:25:24','2024-04-01 21:25:24'),
(23,NULL,18,'Sputum color','Sputum quantity','Brasky','Whooping','Blood in sputum','2024-04-01 21:26:46','2024-04-01 21:26:46'),
(24,NULL,18,'Sputum color','Sputum quantity','Brasky','Whooping','Blood in sputum','2024-04-01 21:26:47','2024-04-01 21:26:47'),
(25,NULL,18,'Sputum color','Sputum quantity','Brasky','Whooping','Blood in sputum','2024-04-01 21:27:40','2024-04-01 21:27:40');

/*Table structure for table `main_complaints` */


CREATE TABLE `main_complaints` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) DEFAULT NULL,
  `Description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Onset` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Duration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Severity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RelievingFactor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `AssociatedSymptoms` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `main_complaints` */

insert  into `main_complaints`(`id`,`form_id`,`GnInfoId`,`Description`,`Onset`,`Duration`,`Severity`,`RelievingFactor`,`AssociatedSymptoms`,`created_at`,`updated_at`) values 
(6,NULL,8,'Quisquam non reicien','Nulla fugiat minus q','Ab consequatur offi','10','Fugiat ad placeat','Rerum eum do Nam bla','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(7,NULL,9,'Quisquam non reicien','Nulla fugiat minus q','Ab consequatur offi','10','Fugiat ad placeat','Rerum eum do Nam bla','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(8,NULL,13,'Quisquam non reicien','Nulla fugiat minus q','Ab consequatur offi','10','Fugiat ad placeat','Rerum eum do Nam bla','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(9,NULL,14,'Quisquam non reicien','Nulla fugiat minus q','Ab consequatur offi','10','Fugiat ad placeat','Rerum eum do Nam bla','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(10,NULL,15,'Quisquam non reicien','Nulla fugiat minus q','Ab consequatur offi','10','Fugiat ad placeat','Rerum eum do Nam bla','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(11,NULL,17,'Quisquam non reicien','Nulla fugiat minus q','Ab consequatur offi','10','Fugiat ad placeat','Rerum eum do Nam bla','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(12,NULL,17,'Quisquam non reicien','Nulla fugiat minus q','Ab consequatur offi','10','Fugiat ad placeat','Rerum eum do Nam bla','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(13,NULL,18,'Description','Onset','Duration','6','Aggravating/Relieving Factors','Associated Symptoms','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `meningitis` */


CREATE TABLE `meningitis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `OnsetAndProgression` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Headache` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Fever` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `meningitis` */

insert  into `meningitis`(`id`,`form_id`,`GnInfoId`,`OnsetAndProgression`,`Headache`,`Fever`,`created_at`,`updated_at`) values 
(8,NULL,8,'none','Headache is typically severe','Neck stiffness, especially when trying to touch the chin to the chest (neck flexion)','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'none','Headache is typically severe','Neck stiffness, especially when trying to touch the chin to the chest (neck flexion)','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'none','Headache is typically severe','Neck stiffness, especially when trying to touch the chin to the chest (neck flexion)','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'none','Headache is typically severe','Neck stiffness, especially when trying to touch the chin to the chest (neck flexion)','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'none','Headache is typically severe','Neck stiffness, especially when trying to touch the chin to the chest (neck flexion)','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'none','Headache is typically severe','Neck stiffness, especially when trying to touch the chin to the chest (neck flexion)','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'none','Headache is typically severe','Neck stiffness, especially when trying to touch the chin to the chest (neck flexion)','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Sudden onset of symptoms','Headache may be described as the worst headache of my life','Nausea and Vomiting','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `migrations` */


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

/*Data for the table `migrations` */

insert  into `migrations`(`id`,`migration`,`batch`) values 
(1,'2014_10_12_000000_create_users_table',1),
(2,'2014_10_12_100000_create_password_reset_tokens_table',1),
(3,'2019_08_19_000000_create_failed_jobs_table',1),
(4,'2019_12_14_000001_create_personal_access_tokens_table',1),
(5,'2023_09_28_165651_create_countries_table',1),
(6,'2023_09_28_165725_create_cities_table',1),
(7,'2023_09_28_165744_create_areas_table',1),
(8,'2023_09_28_165807_create_schools_table',1),
(9,'2023_09_28_165828_create_students_table',1),
(10,'2023_12_21_144142_create_forms_table',2),
(11,'2023_12_21_153634_create_form_steps_table',2),
(12,'2023_12_21_153945_create_form_step_fields_table',2),
(13,'2023_12_21_154330_create_form_step_field_options_table',2),
(14,'2023_12_21_154456_create_fields_registration_values_table',2),
(15,'2023_12_21_154638_create_student_registrations_table',2),
(16,'2023_12_25_142621_create_form_data_table',2),
(17,'2023_12_25_144459_create_form_entries_table',2),
(20,'2024_03_06_181628_create_log_activity_table',3),
(21,'2024_03_08_144147_add_cnic_to_users_table',4),
(22,'2024_03_13_191113_create_general_infos_table',5),
(23,'2024_03_13_191932_create_main_complaints_table',6),
(24,'2024_03_13_203040_create_secondary_complains_table',7),
(25,'2024_03_13_203152_create_recent_changes_or_concerns_table',8),
(26,'2024_03_13_203404_create_vital_signs_table',8),
(27,'2024_03_13_203621_create_fever_histories_table',8),
(28,'2024_03_13_203926_create_headaches_table',8),
(29,'2024_03_13_204140_create_meningitis_table',8),
(30,'2024_03_13_204313_create_abdominal_pain_histories_table',8),
(31,'2024_03_14_153824_create_personal_histories_table',8),
(32,'2024_03_14_154133_create_sleep_routines_table',8),
(33,'2024_03_14_154607_create_nutrition_histories_table',8),
(34,'2024_03_14_155223_create_chest_pains_table',8),
(35,'2024_03_14_155646_create_sobs_table',8),
(36,'2024_03_14_155855_create_respiratory_systems_table',8),
(37,'2024_03_14_161435_create_upper_resps_table',8),
(38,'2024_03_14_161618_create_coughs_table',8),
(39,'2024_03_14_161759_create_history_of_pneumonias_table',8),
(40,'2024_03_14_161950_create_lower_respiratory_tract_infections_table',8),
(41,'2024_03_14_162407_create_lower_respiratory_sobs_table',8),
(42,'2024_03_14_164641_create_history_of_infections_table',8),
(43,'2024_03_14_170028_create_skin_diseases_table',8),
(44,'2024_03_14_172305_create_chief_complaints_table',8),
(45,'2024_03_15_190253_create_previous_menstruation_treatment_or_interventions_table',8),
(46,'2024_03_18_160715_create_past_medical_conditions_table',8),
(47,'2024_03_18_161124_create_allergies_table',8),
(48,'2024_03_18_162219_create_socioeconomics_table',8);

/*Table structure for table `nutrition_histories` */


CREATE TABLE `nutrition_histories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `BreakfastIfYes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RotiTheyEat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Lunch` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `SkipMeals` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `MealPreferences` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `FoodAllergies` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `DietaryRestrictions` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `nutrition_histories` */

insert  into `nutrition_histories`(`id`,`form_id`,`GnInfoId`,`BreakfastIfYes`,`RotiTheyEat`,`Lunch`,`SkipMeals`,`MealPreferences`,`FoodAllergies`,`DietaryRestrictions`,`created_at`,`updated_at`) values 
(8,NULL,8,'Impedit maiores lab','Mollit nisi sunt ut','Fugiat laborum ea qu','Nostrum est eos ex c','Aspernatur deserunt','Velit tempore natus','Minim in est vitae i','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Impedit maiores lab','Mollit nisi sunt ut','Fugiat laborum ea qu','Nostrum est eos ex c','Aspernatur deserunt','Velit tempore natus','Minim in est vitae i','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Impedit maiores lab','Mollit nisi sunt ut','Fugiat laborum ea qu','Nostrum est eos ex c','Aspernatur deserunt','Velit tempore natus','Minim in est vitae i','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Impedit maiores lab','Mollit nisi sunt ut','Fugiat laborum ea qu','Nostrum est eos ex c','Aspernatur deserunt','Velit tempore natus','Minim in est vitae i','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Impedit maiores lab','Mollit nisi sunt ut','Fugiat laborum ea qu','Nostrum est eos ex c','Aspernatur deserunt','Velit tempore natus','Minim in est vitae i','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Impedit maiores lab','Mollit nisi sunt ut','Fugiat laborum ea qu','Nostrum est eos ex c','Aspernatur deserunt','Velit tempore natus','Minim in est vitae i','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Impedit maiores lab','Mollit nisi sunt ut','Fugiat laborum ea qu','Nostrum est eos ex c','Aspernatur deserunt','Velit tempore natus','Minim in est vitae i','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Breakfast if yes','How much roti did they eat?','Lunch','Skip meals','Meal preferences especially dislikes','Food allergies','Dietary restrictions','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Data for the table `password_reset_tokens` */

/*Table structure for table `past_medical_conditions` */


CREATE TABLE `past_medical_conditions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `LongTermHealthConditions` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longterm_health_other` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `AccidentOrInjuries` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Surgeries` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `AnyCurrentMdications` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `past_medical_conditions` */

insert  into `past_medical_conditions`(`id`,`form_id`,`GnInfoId`,`LongTermHealthConditions`,`longterm_health_other`,`AccidentOrInjuries`,`Surgeries`,`AnyCurrentMdications`,`created_at`,`updated_at`) values 
(8,NULL,8,'Asthma',NULL,'Accusamus fugit dol','Culpa saepe enim tot','Id et eos eum sapie','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Asthma',NULL,'Accusamus fugit dol','Culpa saepe enim tot','Id et eos eum sapie','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Asthma',NULL,'Accusamus fugit dol','Culpa saepe enim tot','Id et eos eum sapie','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Asthma',NULL,'Accusamus fugit dol','Culpa saepe enim tot','Id et eos eum sapie','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Asthma',NULL,'Accusamus fugit dol','Culpa saepe enim tot','Id et eos eum sapie','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Asthma',NULL,'Accusamus fugit dol','Culpa saepe enim tot','Id et eos eum sapie','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Asthma',NULL,'Accusamus fugit dol','Culpa saepe enim tot','Id et eos eum sapie','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Other','Please specify 2','Accident or Injuries','Surgeries','Any Current medications','2024-04-01 21:01:01','2024-04-01 21:27:40');

/*Data for the table `personal_access_tokens` */

/*Table structure for table `personal_histories` */


CREATE TABLE `personal_histories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `LifestyleHabits` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `CurrentMedications` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sports` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `personal_histories` */

insert  into `personal_histories`(`id`,`form_id`,`GnInfoId`,`LifestyleHabits`,`CurrentMedications`,`sports`,`created_at`,`updated_at`) values 
(8,NULL,8,'Exercise',NULL,NULL,'2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Exercise',NULL,NULL,'2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Exercise',NULL,NULL,'2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Exercise',NULL,NULL,'2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Exercise',NULL,NULL,'2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Exercise',NULL,NULL,'2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Exercise',NULL,NULL,'2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Current Medications','Current Medications',NULL,'2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `previous_menstruation_treatment_or_interventions` */


CREATE TABLE `previous_menstruation_treatment_or_interventions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `PreviousMenstruationTreatmentOrInterventions` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Specify` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `previous_menstruation_treatment_or_interventions` */

insert  into `previous_menstruation_treatment_or_interventions`(`id`,`form_id`,`GnInfoId`,`PreviousMenstruationTreatmentOrInterventions`,`Specify`,`comment`,`created_at`,`updated_at`) values 
(8,NULL,8,'Other','ewr','ewr','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Other','ewr','ewr','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Other','ewr','ewr','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Other','ewr','ewr','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Other','ewr','ewr','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Other','ewr','ewr','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Other','ewr','ewr','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Other','Please specify','Additional comments or concerns','2024-04-01 21:01:01','2024-04-01 21:26:46');

/*Table structure for table `recent_changes_or_concerns` */


CREATE TABLE `recent_changes_or_concerns` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) DEFAULT NULL,
  `Description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Onset` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Duration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Severity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RelievingFactor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `AssociatedSymptoms` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `recent_changes_or_concerns` */

insert  into `recent_changes_or_concerns`(`id`,`form_id`,`GnInfoId`,`Description`,`Onset`,`Duration`,`Severity`,`RelievingFactor`,`AssociatedSymptoms`,`created_at`,`updated_at`) values 
(6,NULL,8,'Libero quia labore e','Reprehenderit ipsam','Et voluptatem Omnis','8','Esse pariatur Esse','Iure magni laborum','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(7,NULL,9,'Libero quia labore e','Reprehenderit ipsam','Et voluptatem Omnis','8','Esse pariatur Esse','Iure magni laborum','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(8,NULL,13,'Libero quia labore e','Reprehenderit ipsam','Et voluptatem Omnis','8','Esse pariatur Esse','Iure magni laborum','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(9,NULL,14,'Libero quia labore e','Reprehenderit ipsam','Et voluptatem Omnis','8','Esse pariatur Esse','Iure magni laborum','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(10,NULL,15,'Libero quia labore e','Reprehenderit ipsam','Et voluptatem Omnis','8','Esse pariatur Esse','Iure magni laborum','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(11,NULL,17,'Libero quia labore e','Reprehenderit ipsam','Et voluptatem Omnis','8','Esse pariatur Esse','Iure magni laborum','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(12,NULL,17,'Libero quia labore e','Reprehenderit ipsam','Et voluptatem Omnis','8','Esse pariatur Esse','Iure magni laborum','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(13,NULL,18,'Description','Onset','Duration','6','Aggravating/Relieving Factors','Associated Symptoms','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `respiratory_systems` */


CREATE TABLE `respiratory_systems` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `NasalPatency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Clubbing` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Asthma` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `respiratory_systems` */

insert  into `respiratory_systems`(`id`,`form_id`,`GnInfoId`,`NasalPatency`,`Clubbing`,`Asthma`,`created_at`,`updated_at`) values 
(8,NULL,8,'Minima tempore et s','Quos perferendis et','Maiores ex voluptate','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Minima tempore et s','Quos perferendis et','Maiores ex voluptate','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Minima tempore et s','Quos perferendis et','Maiores ex voluptate','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Minima tempore et s','Quos perferendis et','Maiores ex voluptate','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Minima tempore et s','Quos perferendis et','Maiores ex voluptate','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Minima tempore et s','Quos perferendis et','Maiores ex voluptate','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Minima tempore et s','Quos perferendis et','Maiores ex voluptate','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Nasal patency','Clubbing','Asthma','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `schools` */


CREATE TABLE `schools` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `school_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `area` int(11) NOT NULL,
  `school_representative` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `schools` */

insert  into `schools`(`id`,`school_name`,`address`,`area`,`school_representative`,`email`,`status`,`created_by`,`updated_by`,`created_at`,`updated_at`) values 
(1,'The SET School','The Set School Gwalior Society',1,'Mrs Hina Arshad','mrsarshad79@gmail.com',1,1,1,'2024-01-16 05:06:05','2024-01-16 05:06:05'),
(2,'Save The Future School','Khada Market, Lyari',1,'Ms. Najma','ushna@msn.com',1,1,1,'2024-01-16 05:07:45','2024-01-16 05:07:45'),
(3,'Kiran Foundation School','Kiran Foundation School',1,'Sabina khatri','Sabina.khatri3@gmail.com',1,1,1,'2024-02-12 08:39:51','2024-02-12 08:50:44');

/*Table structure for table `secondary_complains` */


CREATE TABLE `secondary_complains` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) DEFAULT NULL,
  `Description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Onset` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Duration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Severity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RelievingFactor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `AssociatedSymptoms` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `secondary_complains` */

insert  into `secondary_complains`(`id`,`form_id`,`GnInfoId`,`Description`,`Onset`,`Duration`,`Severity`,`RelievingFactor`,`AssociatedSymptoms`,`created_at`,`updated_at`) values 
(6,NULL,8,'Expedita obcaecati i','Id nostrud ratione m','Voluptate eius ea id','5','Nulla et molestiae m','Dolor architecto vel','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(7,NULL,9,'Expedita obcaecati i','Id nostrud ratione m','Voluptate eius ea id','5','Nulla et molestiae m','Dolor architecto vel','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(8,NULL,13,'Expedita obcaecati i','Id nostrud ratione m','Voluptate eius ea id','5','Nulla et molestiae m','Dolor architecto vel','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(9,NULL,14,'Expedita obcaecati i','Id nostrud ratione m','Voluptate eius ea id','5','Nulla et molestiae m','Dolor architecto vel','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(10,NULL,15,'Expedita obcaecati i','Id nostrud ratione m','Voluptate eius ea id','5','Nulla et molestiae m','Dolor architecto vel','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(11,NULL,17,'Expedita obcaecati i','Id nostrud ratione m','Voluptate eius ea id','5','Nulla et molestiae m','Dolor architecto vel','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(12,NULL,17,'Expedita obcaecati i','Id nostrud ratione m','Voluptate eius ea id','5','Nulla et molestiae m','Dolor architecto vel','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(13,NULL,18,'Description','Onset','Duration','9','Aggravating/Relieving Factors','Associated Symptoms','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `skin_diseases` */


CREATE TABLE `skin_diseases` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `Rashes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `OnsetOfRashes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Site` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `StartedFrom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Itching` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Fever` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Coryza` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `skin_diseases` */

insert  into `skin_diseases`(`id`,`form_id`,`GnInfoId`,`Rashes`,`OnsetOfRashes`,`Site`,`StartedFrom`,`Itching`,`Fever`,`Coryza`,`created_at`,`updated_at`) values 
(8,NULL,8,'Macular','Alias nulla consequa','Aut ea non in nemo a','Incidunt dolores au','Temporibus maiores n','after rash','Amet voluptatem do','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Macular','Alias nulla consequa','Aut ea non in nemo a','Incidunt dolores au','Temporibus maiores n','after rash','Amet voluptatem do','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Macular','Alias nulla consequa','Aut ea non in nemo a','Incidunt dolores au','Temporibus maiores n','after rash','Amet voluptatem do','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Macular','Alias nulla consequa','Aut ea non in nemo a','Incidunt dolores au','Temporibus maiores n','after rash','Amet voluptatem do','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Macular','Alias nulla consequa','Aut ea non in nemo a','Incidunt dolores au','Temporibus maiores n','after rash','Amet voluptatem do','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Macular','Alias nulla consequa','Aut ea non in nemo a','Incidunt dolores au','Temporibus maiores n','after rash','Amet voluptatem do','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Macular','Alias nulla consequa','Aut ea non in nemo a','Incidunt dolores au','Temporibus maiores n','after rash','Amet voluptatem do','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Macular','Onset of rashes','Site','Started From','Itching','onset','Coryza','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `sleep_routines` */


CREATE TABLE `sleep_routines` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `BedTime` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `SleepDuration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `SleepQuality` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `BedtimeRoutine` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `DaytimeNaps` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `SnoringOrBreathing` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RestlessnessDuringSleep` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `SleepEnvironment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `SleepRelatedBehaviors` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `AffectingSleep` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ImpactingSleep` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Enuresis` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ImmunizationHistory` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `sleep_routines` */

insert  into `sleep_routines`(`id`,`form_id`,`GnInfoId`,`BedTime`,`SleepDuration`,`SleepQuality`,`BedtimeRoutine`,`DaytimeNaps`,`SnoringOrBreathing`,`RestlessnessDuringSleep`,`SleepEnvironment`,`SleepRelatedBehaviors`,`AffectingSleep`,`ImpactingSleep`,`Enuresis`,`ImmunizationHistory`,`created_at`,`updated_at`) values 
(8,NULL,8,'Adipisicing culpa d','Possimus voluptatem','4','Vel cum ut consectet','4','Distinctio Necessit','Explicabo Veritatis','Incidunt id deserun','Optio incidunt ex','Sed et molestiae cum','Nostrud sint est ten','Quasi veniam modi e','Sit ut aut quaerat','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Adipisicing culpa d','Possimus voluptatem','4','Vel cum ut consectet','4','Distinctio Necessit','Explicabo Veritatis','Incidunt id deserun','Optio incidunt ex','Sed et molestiae cum','Nostrud sint est ten','Quasi veniam modi e','Sit ut aut quaerat','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Adipisicing culpa d','Possimus voluptatem','4','Vel cum ut consectet','4','Distinctio Necessit','Explicabo Veritatis','Incidunt id deserun','Optio incidunt ex','Sed et molestiae cum','Nostrud sint est ten','Quasi veniam modi e','Sit ut aut quaerat','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Adipisicing culpa d','Possimus voluptatem','4','Vel cum ut consectet','4','Distinctio Necessit','Explicabo Veritatis','Incidunt id deserun','Optio incidunt ex','Sed et molestiae cum','Nostrud sint est ten','Quasi veniam modi e','Sit ut aut quaerat','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Adipisicing culpa d','Possimus voluptatem','4','Vel cum ut consectet','4','Distinctio Necessit','Explicabo Veritatis','Incidunt id deserun','Optio incidunt ex','Sed et molestiae cum','Nostrud sint est ten','Quasi veniam modi e','Sit ut aut quaerat','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Adipisicing culpa d','Possimus voluptatem','4','Vel cum ut consectet','4','Distinctio Necessit','Explicabo Veritatis','Incidunt id deserun','Optio incidunt ex','Sed et molestiae cum','Nostrud sint est ten','Quasi veniam modi e','Sit ut aut quaerat','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Adipisicing culpa d','Possimus voluptatem','4','Vel cum ut consectet','4','Distinctio Necessit','Explicabo Veritatis','Incidunt id deserun','Optio incidunt ex','Sed et molestiae cum','Nostrud sint est ten','Quasi veniam modi e','Sit ut aut quaerat','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Bed time','Sleep duration','1','Bedtime routine','Daytime naps','Snoring or breathing difficulties','Restlessness during sleep','Sleep environment (noise, light, etc.)','Sleep-related behaviors (sleepwalking, teeth grinding, etc.)','Medical conditions affecting sleep','Medications impacting sleep','Enuresis','Immunization history','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `sobs` */


CREATE TABLE `sobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `OnExertion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `OnRst` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `sobs` */

insert  into `sobs`(`id`,`form_id`,`GnInfoId`,`OnExertion`,`OnRst`,`created_at`,`updated_at`) values 
(8,NULL,8,'Ut tempore quibusda','Sit ipsum anim volup','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Ut tempore quibusda','Sit ipsum anim volup','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Ut tempore quibusda','Sit ipsum anim volup','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Ut tempore quibusda','Sit ipsum anim volup','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Ut tempore quibusda','Sit ipsum anim volup','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Ut tempore quibusda','Sit ipsum anim volup','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Ut tempore quibusda','Sit ipsum anim volup','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'on exertion','on rest','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `socioeconomics` */


CREATE TABLE `socioeconomics` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `Water` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Milk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Rooms` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `AnySick people at home` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `infectious_disease` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `FatherOccupation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `DDX` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `NoteToPrincipal` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `NoteToParent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `socioeconomics` */

insert  into `socioeconomics`(`id`,`form_id`,`GnInfoId`,`Water`,`Milk`,`Rooms`,`AnySick people at home`,`infectious_disease`,`FatherOccupation`,`DDX`,`NoteToPrincipal`,`NoteToParent`,`Picture`,`created_at`,`updated_at`) values 
(8,NULL,8,'Boiled','Boiled (unpasturized milk)','5+',NULL,'Yes','Shopkeeper','Dicta rerum dolores','Deleniti in esse ad','Possimus voluptates','patient-55998.jpeg','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Boiled','Boiled (unpasteurized milk)','5+',NULL,'Yes','Shopkeeper','Dicta rerum dolores','Deleniti in esse ad','Possimus voluptates','patient-2475.jpeg','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Boiled','Boiled (unpasteurized milk)','5+',NULL,'Yes','Shopkeeper','Dicta rerum dolores','Deleniti in esse ad','Possimus voluptates','patient-24271.jpeg','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Boiled','Boiled (unpasteurized milk)','5+',NULL,'Yes','Shopkeeper','Dicta rerum dolores','Deleniti in esse ad','Possimus voluptates','patient-54790.pdf','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Boiled','Boiled (unpasteurized milk)','5+',NULL,'Yes','Shopkeeper','Dicta rerum dolores','Deleniti in esse ad','Possimus voluptates','patient-8273.jpeg','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Boiled','Boiled (unpasturized milk)','5+',NULL,'Yes','Shopkeeper','Dicta rerum dolores','Deleniti in esse ad','Possimus voluptates','patient-13017.jpeg','2024-04-01 19:53:03','2024-04-01 20:21:29'),
(14,NULL,17,'Boiled','Boiled (unpasteurized milk)','5+',NULL,'Yes','Shopkeeper','Dicta rerum dolores','Deleniti in esse ad','Possimus voluptates','patient-90942.pdf','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Tap','Boiled (unpasturized milk)','2',NULL,'Yes','Clerick','DDX','Note to principal','Note to parent','patient-53783.pdf','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `student_registrations` */


CREATE TABLE `student_registrations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `gr_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Table structure for table `upper_resps` */


CREATE TABLE `upper_resps` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `SoreThroat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `EarAche` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `EarDischarge` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RunnyNse` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `upper_resps` */

insert  into `upper_resps`(`id`,`form_id`,`GnInfoId`,`SoreThroat`,`EarAche`,`EarDischarge`,`RunnyNse`,`created_at`,`updated_at`) values 
(8,NULL,8,'Itaque consectetur','Quaerat et ullamco s','odour','Ut provident qui pr','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(9,NULL,9,'Itaque consectetur','Quaerat et ullamco s','odour','Ut provident qui pr','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(10,NULL,13,'Itaque consectetur','Quaerat et ullamco s','odour','Ut provident qui pr','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(11,NULL,14,'Itaque consectetur','Quaerat et ullamco s','odour','Ut provident qui pr','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(12,NULL,15,'Itaque consectetur','Quaerat et ullamco s','odour','Ut provident qui pr','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(13,NULL,17,'Itaque consectetur','Quaerat et ullamco s','odour','Ut provident qui pr','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(14,NULL,17,'Itaque consectetur','Quaerat et ullamco s','odour','Ut provident qui pr','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(15,NULL,18,'Sore throat','Ear Ache','White','Runny nose','2024-04-01 21:01:01','2024-04-01 21:01:01');

/*Table structure for table `vital_signs` */


CREATE TABLE `vital_signs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `GnInfoId` int(11) NOT NULL,
  `pulse` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `temperature` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RespiratoryRate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bmi_weight` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bmi_height` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `vital_signs` */

insert  into `vital_signs`(`id`,`form_id`,`GnInfoId`,`pulse`,`temperature`,`bp`,`RespiratoryRate`,`bmi_weight`,`bmi_height`,`created_at`,`updated_at`) values 
(6,NULL,8,'Aliqua Corporis odi','Velit explicabo Lab','Aliquid ea nisi esse','Voluptatibus qui imp','Tempore eaque adipi','Optio et qui adipis','2024-04-01 16:00:13','2024-04-01 16:00:13'),
(7,NULL,9,'Aliqua Corporis odi','Velit explicabo Lab','Aliquid ea nisi esse','Voluptatibus qui imp','Tempore eaque adipi','Optio et qui adipis','2024-04-01 19:35:55','2024-04-01 19:35:55'),
(8,NULL,13,'Aliqua Corporis odi','Velit explicabo Lab','Aliquid ea nisi esse','Voluptatibus qui imp','Tempore eaque adipi','Optio et qui adipis','2024-04-01 19:44:57','2024-04-01 19:44:57'),
(9,NULL,14,'Aliqua Corporis odi','Velit explicabo Lab','Aliquid ea nisi esse','Voluptatibus qui imp','Tempore eaque adipi','Optio et qui adipis','2024-04-01 19:47:28','2024-04-01 19:47:28'),
(10,NULL,15,'Aliqua Corporis odi','Velit explicabo Lab','Aliquid ea nisi esse','Voluptatibus qui imp','Tempore eaque adipi','Optio et qui adipis','2024-04-01 19:48:11','2024-04-01 19:48:11'),
(11,NULL,17,'Aliqua Corporis odi','Velit explicabo Lab','Aliquid ea nisi esse','Voluptatibus qui imp','Tempore eaque adipi','Optio et qui adipis','2024-04-01 19:53:03','2024-04-01 19:53:03'),
(12,NULL,17,'Aliqua Corporis odi','Velit explicabo Lab','Aliquid ea nisi esse','Voluptatibus qui imp','Tempore eaque adipi','Optio et qui adipis','2024-04-01 19:54:47','2024-04-01 19:54:47'),
(13,NULL,18,'Pulse','Temperature','bp','Respiratory Rate','BMI Weight','BMI Height','2024-04-01 21:01:01','2024-04-01 21:01:01');

