(528201,'P30293','Adult Institutions','Ketchikan Correctional Center',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','907-228-7350','Ketchikan Gateway County','AK','Ketchikan','99901','1201 Schoenbar Rd',NULL,'1201 Schoenbar Rd','Ketchikan','AK','99901','',NULL,NULL,'','','58','','907-225-7031',1,NULL,'2021-10-08 12:20:23',8,'2021-10-08 18:01:21',NULL,NULL,NULL,'',0,0,7),(528202,'P30309','Adult Probation and Parole','Ketchikan Probation Office',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','907-228-8600','Ketchikan Gateway County','AK','Ketchikan','99901','415 Main St Rm 202',NULL,'415 Main St Rm 202','Ketchikan','AK','99901','',NULL,NULL,'','','','','907-247-3178',1,NULL,'2021-10-08 12:20:23',8,'2021-10-08 18:01:21',NULL,NULL,NULL,'',0,0,7),(528203,'P32858','Juvenile Probation and Parole','Ketchikan District Probation Ofc',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','907-523-6828','Ketchikan Gateway County','AK','Ketchikan','99901','415 Main St Ste 203',NULL,'415 Main St Ste 203','Ketchikan','AK','99901','',NULL,NULL,'','','','','907-225-1934',1,NULL,'2021-10-08 12:20:23',8,'2021-10-08 18:01:22',NULL,NULL,NULL,'',0,0,7),(528204,'P60871','Juvenile Probation and Parole','Prince of Wales Probation Ofc',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','907-225-9639','Ketchikan Gateway County','AK','Ketchikan','99901','415 Main St Rm 203',NULL,'415 Main St Rm 203','Ketchikan','AK','99901','',NULL,NULL,'','','','','907-225-1934',1,NULL,'2021-10-08 12:20:23',8,'2021-10-08 18:01:22',NULL,NULL,NULL,'',0,0,7),(528205,'P48321','Ports of Entry','Port of Entry','123213','2023-12-21','11','11','null','null','null','null',NULL,'907-225-2254','Ketchikan Gateway County','AK','Ketchikan','99901','648 Mission St Ste 101',NULL,'648 Mission St Ste 101','Ketchikan','99901','99901','11',NULL,'google.com','2132123123','11','11',NULL,'907-225-2288',1,NULL,'2021-10-08 12:20:23',8,'2023-12-21 11:54:45',NULL,NULL,NULL,'Port of Ketchikan & Prince Rupert',0,0,7),(528206,'P11227','Municipal Law Enforcement','Craig Police Dept',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','907-826-3300','Prince Wales Ketchikan County','AK','Craig','99921','506 2nd St',NULL,'PO Box 25','Craig','AK','99921','2000',NULL,NULL,'Drug Task Force','5','','','907-826-3878',1,NULL,'2021-10-08 12:20:24',8,'2021-10-08 18:01:22',NULL,NULL,NULL,'',0,0,7),(528207,'P8575','Municipal Law Enforcement','Klawock Police Dept','333','2023-12-21','33','33','null','null','null','null',NULL,'907-755-2777','Prince Wales Ketchikan County','AK','Klawock','99925','Klawock Hollis Highway',NULL,'PO Box 650','Klawock','99925','99925','900',NULL,'google.com','DARE Program, Water Patrol, School Resource Officer','3','2',NULL,'907-755-2419',1,NULL,'2021-10-08 12:20:24',8,'2023-12-21 18:30:46',NULL,NULL,NULL,'Division of Police Services',0,0,7),(528208,'P29010','Tribal Law Enforcement','Metlakatla PD',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','907-886-4011','Prince Wales Ketchikan County','AK','Metlakatla','99926','8th Ave',NULL,'PO Box 399','Metlakatla','AK','99926','',NULL,NULL,'','','','','907-886-4050',1,NULL,'2021-10-08 12:20:24',8,'2023-12-21 18:30:46',NULL,NULL,NULL,'',0,0,7),(528209,'P8576','Municipal Law Enforcement','Wrangell Police Dept',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','907-874-3304','Wrangell Petersburg County','AK','Wrangell','99929','431 Zimovia Hwy',NULL,'PO Box 1168','Wrangell','AK','99929','2200',NULL,NULL,'DARE Program, School Resource Officer, Water Patrol','7','','','907-874-2173',1,NULL,'2021-10-08 12:20:24',8,'2024-02-08 11:32:08',NULL,NULL,NULL,'',0,0,7),(528211,'PK007','Campus Law Enforcement','Westfield State College','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. \n\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. ','10/01/2021','M-F','9:00-6:00',NULL,NULL,NULL,NULL,'203','413-572-5262','Hampden County','MA','Westfield','10862','577 Western Ave',NULL,'577 Western Ave','Westfield','10862','10862','50001',NULL,'testing.com','Bike Patrol','18','123123','1','999 999-9999',1,NULL,'2021-10-08 19:18:14',8,'2021-11-02 11:09:50',NULL,NULL,NULL,NULL,0,0,7),(528218,'P78756269','Coroners and Medical Examiners testing','Jefferson Cnty Med Examiner Ofc',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','315-786-3755','Jefferson County','NY','Watertown','13601','531 Meade St',NULL,'531 Meade St','Watertown','NY','13601','110943',NULL,NULL,'test','','','','315-786-3791',1,NULL,'2021-10-15 09:49:43',NULL,'2021-10-15 09:49:43',NULL,NULL,NULL,NULL,0,0,0),(528219,'P7876620','Prosecutors testing','Jefferson Cnty Dist Attys Ofc',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','315-785-3053','Jefferson County','NY','Watertown','13601','175 Arsenal St Fl 7',NULL,'175 Arsenal St Fl 7','Watertown','NY','13601','',NULL,NULL,'test','','','','315-785-3371',1,NULL,'2021-10-15 09:49:43',NULL,'2021-10-15 09:49:43',NULL,NULL,NULL,NULL,0,0,0),(528220,'P78776277','Campus Law Enforcement testing','SUNY-Jefferson Community College',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','315-786-6517','Jefferson County','NY','Watertown','13601','1220 Coffeen St',NULL,'1220 Coffeen St','Watertown','NY','13601','3800',NULL,NULL,'test','12','','','',1,NULL,'2021-10-15 09:49:43',NULL,'2021-10-15 09:49:43',NULL,NULL,NULL,NULL,0,0,0),(528222,'P4994','Trueblueservices','Law Enforcement','According to the information you have supplied to this office, the Town of Malabar Code of Ordinances requires that the town administrator be a resident of Brevard Country','2022-01-05','5','40','null','null','null','null','66666','890 678-5690','Florida','Melbourne','Florida','32941','Post Office Box 410818',NULL,'Post Office Box 410818','Florida','32941','32941','50',NULL,'www.law.com','Town Council of the Town of Malabar','67','500','25479','999 999-9999',1,8,'2021-10-29 08:58:28',8,'2022-01-26 11:03:41',NULL,NULL,NULL,NULL,0,7,7),(528278,'P41983','County Jails','Jefferson Cnty Jail',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','315-786-2664','Jefferson County','NY','Watertown','13601','753 Waterman Dr',NULL,'753 Waterman Dr','Watertown','NY','13601','',NULL,NULL,'','74','195','','315-786-2684',1,NULL,'2021-10-08 10:51:53',8,'2024-01-02 09:19:08',NULL,NULL,NULL,'',0,0,7),(528279,'ITTED001','HeadQuarter','ITT Law Depart','Solving crimes, such as homicide, robbery, burglary, fraud, cybercrime, etc. Detectives collect evidence, interview witnesses and suspects, conduct surveillance, and prepare reports for prosecution.','2023-12-21','7','24',NULL,NULL,NULL,NULL,'12','819-222-9999','Fayette County','KY','Lexington','40511','4089 Iron Works Parkway',NULL,'Usa','kentucky','40511','40511','100000',NULL,'https://www.ittstar.com/.','Homicide, fraud, burglary ','10','20','12','222-222-2222',1,8,'2023-12-21 10:09:24',541177,'2024-03-11 12:44:05',NULL,NULL,NULL,NULL,135,7,2),(528283,'P225588','Municipal Law Enforcement','Amherst Police Dept',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','413-259-3000','Hampshire County','MA','Amherst','1002','111 Main St',NULL,'111 Main St','Amherst','MA','1002','35827',NULL,NULL,'Drug Task Force, Bike Patrol, Gang Task Force, Motorcycle, School Resource Officer','50','','','413-259-2408',1,NULL,'2024-04-08 15:15:42',8,'2024-04-08 15:23:53',NULL,NULL,NULL,'',0,0,7),(528284,'P1','Municipal Law Enforcement','Pelham Police Dept',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','413-253-0484','Hampshire County','MA','Pelham','1002','2 S Valley Rd',NULL,'2 S Valley Rd','Pelham','MA','1002','1500',NULL,NULL,'DARE Program, Drug Task Force, Bike Patrol, Motorcycle, SWAT/Tactical','10','','','413-253-4031',1,NULL,'2024-04-08 15:23:53',NULL,'2024-04-08 15:23:53',NULL,NULL,NULL,NULL,0,0,0),(528285,'p3','Campus Law Enforcement','University of Massachusetts',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','413-545-2121','Hampshire County','MA','Amherst','1003','585 E Pleasant St',NULL,'585 E Pleasant St','Amherst','MA','1003','25000',NULL,NULL,'','62','','','413-545-1725',1,NULL,'2024-04-08 15:23:54',NULL,'2024-04-08 15:23:54',NULL,NULL,NULL,NULL,0,0,0),(528286,'1061','police','Indiana Police','testing','2024-05-12','10','10',NULL,NULL,NULL,NULL,'21','232-333-1100','Los Angeles County','CA','Norwalk','90650','12400 Imperial Highway',NULL,'12400 Imperial Highway','Norwalk','CA','90650','100',NULL,'www.google.com','testing ','10','10','31','224-689-0000',1,8,'2024-05-16 14:38:10',NULL,'2024-05-16 14:38:10',NULL,NULL,NULL,NULL,0,7,0),(528293,'789','Developer Community','Developer Community ','developer','2024-05-24','21','21',NULL,NULL,NULL,NULL,'2','233-211-2312','New York County','NY','New York','10038','123 William Street',NULL,'123 William Street','NewYork','NY','10038','21',NULL,'www.developer.com','developer','21','21','21','234-443-3332',1,8,'2024-05-21 14:02:20',NULL,'2024-05-21 14:02:20',NULL,NULL,NULL,NULL,0,7,0),(528294,'878','Devops community','Devops community','devops','2024-05-23','21','21',NULL,NULL,NULL,NULL,'34','231-111-2355','New York County','NY','New York','10038','123 William Street',NULL,'123 William Street','NewYork','NY','10038','21',NULL,'www.devops.com','Devops','21','21','21','231-224-5555',1,8,'2024-05-21 14:05:50',NULL,'2024-05-21 14:05:50',NULL,NULL,NULL,NULL,0,7,0),(528295,'777','Ocean Law','Ocean Airport  law','police','2024-05-25','77','77',NULL,NULL,NULL,NULL,'21','895-621-3890','New York County','NY','New York','10013','11 Howard Street',NULL,'11 Howard Street','NewYork','NY','10013','77',NULL,'www.ocean.law','police','77','77',NULL,NULL,1,8,'2024-05-24 10:36:48',NULL,'2024-05-24 10:36:48',NULL,NULL,NULL,NULL,0,7,0),(528303,'777','Fire Law','Airport Fire Law','hello','2024-06-01','5','40',NULL,NULL,NULL,NULL,'01','278-900-1111','New York County','NY','NewYork','10038','123 William Street',NULL,'123 William Street','NewYork','NY','10038','89',NULL,'www.firelaw.com','testing the email integration','89','89',NULL,NULL,1,8,'2024-06-03 11:20:00',NULL,'2024-06-03 11:20:00',NULL,NULL,NULL,NULL,0,7,0),(528337,'DEPT0811111','name','testing new1','testing','2024-05-10','3','12','testing','testing','testing','testing',NULL,'535-353-5343','Bangalore Division','KA','Bengaluru','560092',' 4th Cross Road',NULL,'Nice Mart','Bengaluru','California','56002','2332',NULL,'testing.com','test','23','232',NULL,'353-453-4343',1,8,'2024-06-03 14:36:36',NULL,'2024-06-03 14:36:36',NULL,NULL,NULL,NULL,0,7,0),(528338,'678','name','testing new2','wrwsferfe','2018-07-11','5','10','WFASFS','AFASDFDFD','SFASFASF','ASFASDFSF',NULL,'214-333-3333','Bangalore Division','KA','Bengaluru','560092',' 4th Cross Road',NULL,'testing','gytu','drthfgv','56002','1535',NULL,'wrwRFW','testing','24','241',NULL,'214-444-4444',1,8,'2024-06-03 14:41:51',NULL,'2024-06-03 14:41:51',NULL,NULL,NULL,NULL,0,7,0),(528339,'2324','testing','testing new 3','SFDFDF','2023-09-10','4','74','testing','testing','testing','testing',NULL,'133-333-3333','Bangalore Division','KA','Bengaluru','560092',' 4th Cross Road',NULL,'Nice Mart ban','Bengaluru','56002','56002','37437',NULL,'SDF','testing','43','3647',NULL,'333-311-1111',1,8,'2024-06-03 14:44:02',8,'2024-06-03 14:48:45',NULL,NULL,NULL,NULL,0,7,7),(528340,'1331','testing','testing 4','qeqed','2024-05-31','21','11','testing','testing','testing','testing',NULL,'132-222-2222','Bangalore Division','KA','Bengaluru','560092',' Bellary Road',NULL,'Nice Mart ban','Bengaluru','56002','56002','1212',NULL,'testing','testing','1212','1212121',NULL,'122-222-2222',1,8,'2024-06-03 14:57:38',8,'2024-06-03 14:57:51',NULL,NULL,NULL,NULL,0,7,7),(528341,'121','testing 5','testing','2eq','2024-05-30','33','232','sdfasdFA','dsfvsdgvsd','sfsdfs','dfsdfs',NULL,'131-111-1111','Bangalore Division','KA','Bengaluru','560092',' 4th Cross Road',NULL,'Nice Mart ban','Bengaluru','California','56002','322323',NULL,'wsfS','testing','32','322',NULL,'132-222-2222',1,8,'2024-06-03 15:00:06',NULL,'2024-06-03 15:00:06',NULL,NULL,NULL,NULL,0,7,0),(528342,'3123','name','testing 5','2e','2024-05-30','3','31','SAFASF','SFASF','ASFSAF','ASFSF',NULL,'122-222-2222','Bangalore Division','KA','Bengaluru','560045',' Rachenahalli Main Road',NULL,'hebbal','hebbal','California','56002','23232',NULL,'qwdS','testing','22','1313',NULL,'133-333-3333',1,8,'2024-06-03 15:02:12',NULL,'2024-06-03 15:02:12',NULL,NULL,NULL,NULL,0,7,0),(528343,'34','testing','testing 6','2EQWEAD','2024-05-29','2','23','EFESF','SDFSDF','DSGSDG','DFSDF',NULL,'132-222-2222','Bangalore Division','KA','Bengaluru','560055',' Doctor Rajkumar Road',NULL,'Nice Mart ban','Bengaluru','California','56002','123234',NULL,'testing','testing','23','213',NULL,'223-122-2222',1,8,'2024-06-03 15:03:46',NULL,'2024-06-03 15:03:46',NULL,NULL,NULL,NULL,0,7,0),(528344,'312','Fire Law Agency','Test Fire Law','Police','2024-06-02','7','70',NULL,NULL,NULL,NULL,'21','345-211-6742','New York County','NY','New York','10038','123 William Street',NULL,'123 William Street','NewYork','NY','10038','23',NULL,'www.google.com','Police','24','12',NULL,NULL,1,8,'2024-06-05 13:10:44',NULL,'2024-06-05 13:10:44',NULL,NULL,NULL,NULL,0,7,0),(528345,'808','Developer','AWS Security Agency','testing the developer option','2024-06-02','22','22',NULL,NULL,NULL,NULL,'3','908-900-2190','New York County','NY','New York','10038','123 William Street',NULL,'123 William Street','NewYork','NY','10038','22',NULL,'www.test.com','testing the agency','22','22','2','980-987-7222',1,8,'2024-06-11 10:51:46',NULL,'2024-06-11 10:51:46',NULL,NULL,NULL,NULL,0,7,0),(528347,'13132322','testing','super agency','fwsaef','2024-06-07','21','21',NULL,NULL,NULL,NULL,NULL,'133-333-3333','Pampanga','Central Luzon','Angeles','12442',' California Avenue',NULL,'testing','testing','testing','23123','2412',NULL,'testing','testing','12','1241',NULL,'133-333-3333',1,8,'2024-06-13 11:24:32',NULL,'2024-06-13 11:24:32',NULL,NULL,NULL,NULL,0,7,0),(528348,'777','Police','Azure Cloud Security','testing','2024-06-16','11','11',NULL,NULL,NULL,NULL,'1','234-112-1212','New York County','NewYork','New York','10038','123 William Street',NULL,'123 William Street','NewYork','NewYork','10338','11',NULL,'testing.com','testing','11','11',NULL,'890-099-3333',1,8,'2024-06-13 13:24:35',NULL,'2024-06-13 13:24:35',NULL,NULL,NULL,NULL,0,7,0),(528349,'999','police HQ','Fireunion','testing the agency','2024-12-12','6','24',NULL,NULL,NULL,NULL,NULL,'988-762-6225','New York County','NY','New York','10038','123 William Street',NULL,'123 William Street','Newyork','Ny','78999','1900',NULL,'www.google.com','police','10','20',NULL,NULL,1,8,'2024-12-12 11:02:51',NULL,'2024-12-12 11:02:51',NULL,NULL,NULL,NULL,0,7,0);

--
-- Table structure for table `agency_account_onboarding`
--

CREATE TABLE `agency_account_onboarding` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accId` varchar(100) DEFAULT NULL,
  `userId` varchar(100) NOT NULL,
  `agencyId` int(100) NOT NULL DEFAULT '0',
  `precintId` int(100) NOT NULL DEFAULT '0',
  `activationLink` varchar(600) DEFAULT NULL,
  `collect` varchar(100) NOT NULL DEFAULT 'eventually_due',
  `status` varchar(100) DEFAULT NULL,
  `business_type` varchar(100) DEFAULT NULL,
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `agency_account_onboarding`
--

INSERT INTO `agency_account_onboarding` VALUES (60,'acct_1LcTJjPchjYnVN0A','',528202,527244,'https://connect.stripe.com/setup/e/acct_1LcTJjPchjYnVN0A/HY7glQmBikcK','eventually_due','true','government_entity','2022-08-30 12:13:23','2022-08-30 12:16:52'),(62,'acct_1LcTdMBAPMuQtMKL','',524831,523873,'https://connect.stripe.com/setup/e/acct_1LcTdMBAPMuQtMKL/k1T9AUGhaHE1','eventually_due','false','government_entity','2022-08-30 12:33:39','2022-08-30 12:59:31'),(63,'acct_1LcU1hB0oMAfubLn','',528173,527215,'https://connect.stripe.com/setup/e/acct_1LcU1hB0oMAfubLn/xqJFn4dv8ert','eventually_due','false','government_entity','2022-08-30 12:58:49','2022-08-30 13:36:39'),(69,'acct_1LdBw7PbsNckFi8D','',491192,490234,'https://connect.stripe.com/setup/e/acct_1LdBw7PbsNckFi8D/Ox399dMybHgS','eventually_due','true','government_entity','2022-09-01 11:51:58','2022-09-01 11:54:57'),(70,'acct_1LdC1lB2JqJNpa3F','',491193,490235,'https://connect.stripe.com/setup/e/acct_1LdC1lB2JqJNpa3F/1sNf30ZjQPib','eventually_due','true','government_entity','2022-09-01 11:57:48','2022-09-01 15:36:48'),(72,'acct_1LdCHwBIhvBoHO9Q','',491190,490232,'https://connect.stripe.com/setup/e/acct_1LdCHwBIhvBoHO9Q/n87MR8KZekUu','eventually_due','true','government_entity','2022-09-01 12:14:31','2022-09-01 12:17:42'),(73,'acct_1LdCW6PcvPauMP5c','',491194,490236,'https://connect.stripe.com/setup/e/acct_1LdCW6PcvPauMP5c/tvWidFiUMXxx','eventually_due','true','government_entity','2022-09-01 12:29:08','2022-09-01 12:32:36'),(75,'acct_1LdFXGPnenFjSqbN','',491198,490240,'https://connect.stripe.com/setup/e/acct_1LdFXGPnenFjSqbN/aY8DHlc7FwkE','eventually_due','true','government_entity','2022-09-01 15:42:33','2022-09-01 15:46:17'),(84,'acct_1LfQlBPjt057XbQU','',491650,490692,'https://connect.stripe.com/setup/e/acct_1LfQlBPjt057XbQU/8dsumcof9It1','eventually_due','false','government_entity','2022-09-07 16:05:56','2022-09-07 16:06:08'),(86,'acct_1Lg88NB3PaDlMDMe','',491649,490691,'https://connect.stripe.com/setup/e/acct_1Lg88NB3PaDlMDMe/q46ivEgVuYyK','eventually_due','true','government_entity','2022-09-09 14:24:45','2022-09-09 14:32:24'),(87,'acct_1Lg8OZBBIkqfE25B','',500599,499641,'https://connect.stripe.com/setup/e/acct_1Lg8OZBBIkqfE25B/RbHRNhf2Hj7o','eventually_due','false','government_entity','2022-09-09 14:41:29','2022-09-09 14:45:06'),(88,'acct_1Lg9ElPXfFxYPxSN','',500438,499480,'https://connect.stripe.com/setup/e/acct_1Lg9ElPXfFxYPxSN/zdOQhyPG335j','eventually_due','true','government_entity','2022-09-09 15:35:25','2022-09-09 15:38:34'),(89,'acct_1Lhsm1BBZ0RnxT5l','',528203,527245,'https://connect.stripe.com/setup/e/acct_1Lhsm1BBZ0RnxT5l/AcfMFTYghO1n','eventually_due','true','government_entity','2022-09-14 10:24:56','2022-09-14 10:28:10'),(90,'acct_1LhsyLPjXoGf7xji','',528208,527250,'https://connect.stripe.com/setup/e/acct_1LhsyLPjXoGf7xji/4znP0lBmndpG','eventually_due','true','government_entity','2022-09-14 10:37:40','2022-09-14 10:40:53'),(93,'acct_1Lkl0RBCxDeVo3hj','',494680,493722,'https://connect.stripe.com/setup/e/acct_1Lkl0RBCxDeVo3hj/KZh4YKyT12Ix','eventually_due','false','government_entity','2022-09-22 08:43:42','2022-09-22 08:48:25'),(96,'acct_1NH5RBPcl79pBGus','',528190,527232,'https://connect.stripe.com/setup/e/acct_1NH5RBPcl79pBGus/0VVqHZYnBie9','eventually_due','false','government_entity','2023-06-09 13:33:12','2023-06-09 13:37:54'),(97,'acct_1NI4y9BQIwnoGRVZ','',528190,527232,'https://connect.stripe.com/setup/e/acct_1NI4y9BQIwnoGRVZ/16ceHn9y1GJk','eventually_due','false','government_entity','2023-06-12 07:15:20','2023-06-12 07:21:10'),(98,'acct_1NI5GTBM4WOYUAi7','',528190,527232,'https://connect.stripe.com/setup/e/acct_1NI5GTBM4WOYUAi7/2tNMmJVEcO3O','eventually_due',NULL,'government_entity','2023-06-12 07:34:15','2023-06-12 07:34:15'),(99,'acct_1NI5GVPVd5TQyhS7','',528190,527232,'https://connect.stripe.com/setup/e/acct_1NI5GVPVd5TQyhS7/FGync72biRmV','eventually_due','false','government_entity','2023-06-12 07:34:17','2023-06-12 08:25:08'),(100,'acct_1NI63mPgyuyGfaPr','',528190,527232,'https://connect.stripe.com/setup/e/acct_1NI63mPgyuyGfaPr/ELN1Bn3ccGD0','eventually_due','false','government_entity','2023-06-12 08:25:12','2023-06-12 10:27:59'),(101,'acct_1NI7HRPYb0WFWLhg','789',0,0,'https://connect.stripe.com/setup/e/acct_1NI7HRPYb0WFWLhg/iS3QURn3bgre','eventually_due',NULL,'government_entity','2023-06-12 09:43:24','2023-06-12 09:43:24'),(102,'acct_1NI7U5PY8sMCvQ5E','789',0,0,'https://connect.stripe.com/setup/e/acct_1NI7U5PY8sMCvQ5E/rJKeKHf2p2kw','eventually_due',NULL,'government_entity','2023-06-12 09:56:29','2023-06-12 09:56:29'),(103,'acct_1NI7UPBHiJrIOOlx','789',0,0,'https://connect.stripe.com/setup/e/acct_1NI7UPBHiJrIOOlx/Zy5aKm6kf7sg','eventually_due',NULL,'government_entity','2023-06-12 09:56:48','2023-06-12 09:56:48'),(104,'acct_1NI7ZYBVAkd2mVx1','789',0,0,'https://connect.stripe.com/setup/e/acct_1NI7ZYBVAkd2mVx1/ooNEuNJiG8fT','eventually_due',NULL,'government_entity','2023-06-12 10:02:07','2023-06-12 10:02:07'),(105,'acct_1NI7awPXhDjRvLhA','789',0,0,'https://connect.stripe.com/setup/e/acct_1NI7awPXhDjRvLhA/cnjP0iKmp7M8','eventually_due',NULL,'government_entity','2023-06-12 10:03:33','2023-06-12 10:03:33'),(106,'acct_1NI7cgB4o2VP3eYA','789',0,0,'https://connect.stripe.com/setup/e/acct_1NI7cgB4o2VP3eYA/8quARgsiW3rF','eventually_due',NULL,'government_entity','2023-06-12 10:05:21','2023-06-12 10:05:21'),(107,'acct_1NI7ghB3GqtQwJ2l','789',0,0,'https://connect.stripe.com/setup/e/acct_1NI7ghB3GqtQwJ2l/zZBHcLbczPHd','eventually_due',NULL,'government_entity','2023-06-12 10:09:30','2023-06-12 10:09:30'),(108,'acct_1NI7j1BAoxKhlwoz','789',0,0,'https://connect.stripe.com/setup/e/acct_1NI7j1BAoxKhlwoz/f1Jti6FZc0nc','eventually_due',NULL,'government_entity','2023-06-12 10:11:53','2023-06-12 10:11:53'),(109,'acct_1NI7k8B1EyYdhmE3','789',0,0,'https://connect.stripe.com/setup/e/acct_1NI7k8B1EyYdhmE3/Nf1dDWCsAtPv','eventually_due','true','government_entity','2023-06-12 10:13:03','2023-06-12 10:19:38'),(110,'acct_1NI8sgBLGewyGuX9','789',0,0,'https://connect.stripe.com/setup/e/acct_1NI8sgBLGewyGuX9/tZpgOUrTpXM5','eventually_due','false','government_entity','2023-06-12 11:25:57','2023-06-12 11:26:36'),(111,'acct_1NI9JnBSgDHSXOO8','',528190,527232,'https://connect.stripe.com/setup/e/acct_1NI9JnBSgDHSXOO8/PjIBZRJC0RHc','eventually_due','false','government_entity','2023-06-12 11:53:58','2023-06-12 12:00:10'),(112,'acct_1NIBQVBItW1hsWA3','684',0,0,'https://connect.stripe.com/setup/e/acct_1NIBQVBItW1hsWA3/jZSLC7roIbgl','eventually_due','false','government_entity','2023-06-12 14:09:01','2023-06-12 14:10:48'),(113,'acct_1NIBUZBHypCnZRwP','541091',0,0,'https://connect.stripe.com/setup/e/acct_1NIBUZBHypCnZRwP/lurmwHBiW6r2','eventually_due',NULL,'government_entity','2023-06-12 14:13:14','2023-06-12 14:13:14'),(114,'acct_1NIBYsPX2lNopJ4E','750',0,0,'https://connect.stripe.com/setup/e/acct_1NIBYsPX2lNopJ4E/4XiurOAesrfs','eventually_due','false','government_entity','2023-06-12 14:17:41','2023-06-12 14:44:23'),(115,'acct_1NIBrgPh3700PT76','513217',0,0,'https://connect.stripe.com/setup/e/acct_1NIBrgPh3700PT76/rJm87lxvRdzf','eventually_due','true','government_entity','2023-06-12 14:37:07','2024-03-11 14:09:10'),(116,'acct_1NIqOLBARJcgITEg','',528190,527232,'https://connect.stripe.com/setup/e/acct_1NIqOLBARJcgITEg/jFOvYUZhsfsD','eventually_due',NULL,'government_entity','2023-06-14 09:53:31','2023-06-14 09:53:31'),(117,'acct_1NIqQbB47H8Nhqji','',528190,527232,'https://connect.stripe.com/setup/e/acct_1NIqQbB47H8Nhqji/h7Mfnw9gwztH','eventually_due','false','government_entity','2023-06-14 09:55:51','2023-06-14 10:43:00'),(118,'acct_1NIqnAB2DmXqYwI9','446',0,0,'https://connect.stripe.com/setup/e/acct_1NIqnAB2DmXqYwI9/mTH84F5OqChS','eventually_due','false','government_entity','2023-06-14 10:19:11','2023-06-14 10:19:37'),(119,'acct_1NIr61Pjfgav635P','797',0,0,'https://connect.stripe.com/setup/e/acct_1NIr61Pjfgav635P/CzLQGPpffC0V','eventually_due','false','government_entity','2023-06-14 10:38:40','2023-06-14 10:39:23'),(120,'acct_1NIrAJBOw6iiSGxm','',528190,527232,'https://connect.stripe.com/setup/e/acct_1NIrAJBOw6iiSGxm/Hk24RnWocgJb','eventually_due','false','government_entity','2023-06-14 10:43:05','2023-06-14 13:17:53'),(121,'acct_1NItaEPauy7sSk2Y','',528190,527232,'https://connect.stripe.com/setup/e/acct_1NItaEPauy7sSk2Y/LWbs8bXog3eq','eventually_due','false','government_entity','2023-06-14 13:18:01','2023-06-14 13:18:30'),(122,'acct_1NItalBNcfLynOvy','',528190,527232,'https://connect.stripe.com/setup/e/acct_1NItalBNcfLynOvy/ZgobtbvZcUfI','eventually_due',NULL,'government_entity','2023-06-14 13:18:34','2023-06-14 13:18:34'),(123,'acct_1NItb6B2cktyDADG','',528190,527232,'https://connect.stripe.com/setup/e/acct_1NItb6B2cktyDADG/5qROUXG7Y5Oa','eventually_due',NULL,'government_entity','2023-06-14 13:18:55','2023-06-14 13:18:55'),(124,'acct_1NItbWBRLZpb5ALT','',528190,527232,'https://connect.stripe.com/setup/e/acct_1NItbWBRLZpb5ALT/vzmiAEp8lZrT','eventually_due',NULL,'government_entity','2023-06-14 13:19:21','2023-06-14 13:19:21'),(125,'acct_1NItgMBDR7BR1xa0','',528190,527232,'https://connect.stripe.com/setup/e/acct_1NItgMBDR7BR1xa0/77BslyUsy69M','eventually_due','false','government_entity','2023-06-14 13:24:21','2023-06-14 13:30:21'),(126,'acct_1NJHFcBSmBSDbCsx','798',0,0,'https://connect.stripe.com/setup/e/acct_1NJHFcBSmBSDbCsx/UlFDTv5RKnRU','eventually_due','false','government_entity','2023-06-15 14:34:18','2023-06-15 14:39:10'),(127,'acct_1NJxlfPh0hJzxMJu','799',0,0,'https://connect.stripe.com/setup/e/acct_1NJxlfPh0hJzxMJu/GtsY7RlmdA1F','eventually_due','false','government_entity','2023-06-17 11:58:13','2023-06-17 12:05:22'),(128,'acct_1NKfuqB0FWDMUQYQ','800',0,0,'https://connect.stripe.com/setup/e/acct_1NKfuqB0FWDMUQYQ/2ZCkUy6xVBgy','eventually_due','true','individual','2023-06-19 11:06:39','2023-06-19 11:12:07'),(129,'acct_1NKg6rBRCwKP6dsi','801',0,0,'https://connect.stripe.com/setup/e/acct_1NKg6rBRCwKP6dsi/q5sF2LpbUfSq','eventually_due','true','individual','2023-06-19 11:19:04','2023-06-19 11:23:35'),(130,'acct_1NKixJBRNiZule9E','743',0,0,'https://connect.stripe.com/setup/e/acct_1NKixJBRNiZule9E/u8G4mbjD5fxF','eventually_due','false','individual','2023-06-19 14:21:23','2023-06-19 14:24:55'),(131,'acct_1NND1GPUqF2SENKl','789',0,0,'https://connect.stripe.com/setup/e/acct_1NND1GPUqF2SENKl/zGFJ3TJTAyZk','eventually_due',NULL,'individual','2023-06-26 10:51:45','2023-06-26 10:51:45'),(132,'acct_1NND2fBVYxXoG5H8','789',0,0,'https://connect.stripe.com/setup/e/acct_1NND2fBVYxXoG5H8/WLS8fFDLJTVY','eventually_due','true','individual','2023-06-26 10:53:11','2023-06-26 10:56:21'),(133,'acct_1NND7hPc1JJlwIbE','446',0,0,'https://connect.stripe.com/setup/e/acct_1NND7hPc1JJlwIbE/laCnhZxrXsoV','eventually_due','false','individual','2023-06-26 10:58:23','2023-06-26 11:00:25'),(134,'acct_1NND9kPYJLu0zAwr','446',0,0,'https://connect.stripe.com/setup/e/acct_1NND9kPYJLu0zAwr/yIRthRcYOHB0','eventually_due','false','individual','2023-06-26 11:00:30','2023-06-26 13:41:21'),(135,'acct_1NNDBzBQB3zp12gM','802',0,0,'https://connect.stripe.com/setup/e/acct_1NNDBzBQB3zp12gM/vpuro50mqjW1','eventually_due','true','individual','2023-06-26 11:02:49','2023-06-26 11:05:36'),(136,'acct_1NNGWJBHBnQtgmAq','743',0,0,'https://connect.stripe.com/setup/e/acct_1NNGWJBHBnQtgmAq/yZhTrUXmqeh7','eventually_due','true','individual','2023-06-26 14:36:02','2023-06-26 14:38:54'),(137,'acct_1NOdYCBM8GHmaOlQ','804',0,0,'https://connect.stripe.com/setup/e/acct_1NOdYCBM8GHmaOlQ/s9SKeWykoQi5','eventually_due','true','individual','2023-06-30 09:23:38','2023-06-30 09:27:01'),(138,'acct_1NPl4LPbVVEILDJ7','803',0,0,'https://connect.stripe.com/setup/e/acct_1NPl4LPbVVEILDJ7/MDOi7sa1sxhy','eventually_due','true','individual','2023-07-03 11:37:28','2023-07-03 11:40:40'),(139,'acct_1NY5KJB1tVzTijZ1','',528190,0,'https://connect.stripe.com/setup/e/acct_1NY5KJB1tVzTijZ1/xhfUJKD4T7wf','eventually_due',NULL,'government_entity','2023-07-26 10:52:23','2023-07-26 10:52:23'),(140,'acct_1Nf0EEPimmw2Ywah','855',0,0,'https://connect.stripe.com/setup/e/acct_1Nf0EEPimmw2Ywah/pcUfSTENERNo','eventually_due','false','individual','2023-08-14 12:50:40','2023-08-14 12:50:58'),(141,'acct_1Nk0gZBDkoatnRs7','',528190,527232,'https://connect.stripe.com/setup/e/acct_1Nk0gZBDkoatnRs7/pcVx04HzIg3i','eventually_due','true','government_entity','2023-08-28 08:20:38','2023-08-28 08:24:56'),(142,'acct_1O5UT9B72Xw0F4QT','',491167,490209,'https://connect.stripe.com/setup/e/acct_1O5UT9B72Xw0F4QT/6ufhL52LuKXq','eventually_due',NULL,'government_entity','2023-10-26 14:23:33','2023-10-26 14:23:33'),(143,'acct_1O5UTJBQjHFgAlFE','',491167,490209,'https://connect.stripe.com/setup/e/acct_1O5UTJBQjHFgAlFE/mnMM7eFcurvU','eventually_due','true','government_entity','2023-10-26 14:23:43','2023-10-26 14:27:21'),(144,'acct_1OUUsKBIK0soXC5M','968',0,0,'https://connect.stripe.com/setup/e/acct_1OUUsKBIK0soXC5M/1WlobnDTxQNZ','eventually_due','false','individual','2024-01-03 13:52:54','2024-01-03 13:53:57'),(145,'acct_1OUUvXB7QarAHyYr','968',0,0,'https://connect.stripe.com/setup/e/acct_1OUUvXB7QarAHyYr/NqsFGbvEk8jw','eventually_due','true','individual','2024-01-03 13:56:14','2024-01-03 14:01:39'),(146,'acct_1OfJUWPX0fk7J0wL','',528279,527341,'https://connect.stripe.com/setup/e/acct_1OfJUWPX0fk7J0wL/aG71fQu7tpAg','eventually_due','false','government_entity','2024-02-02 09:57:02','2024-02-02 10:01:14'),(147,'acct_1OmyiiPWQGGKv86S','541165',0,0,'https://connect.stripe.com/setup/e/acct_1OmyiiPWQGGKv86S/Zsuj88lMCeZx','eventually_due','false','individual','2024-02-23 13:23:22','2024-02-23 13:24:57'),(148,'acct_1Omz5mPdCLkoHz0F','541165',0,0,'https://connect.stripe.com/setup/e/acct_1Omz5mPdCLkoHz0F/lnaFptMmjDHE','eventually_due','true','individual','2024-02-23 13:47:12','2024-02-23 13:54:56'),(149,'acct_1OoWACB1kvStTcI1','650',0,0,'https://connect.stripe.com/setup/e/acct_1OoWACB1kvStTcI1/UJ61YCeKU0lk','eventually_due','true','individual','2024-02-27 19:18:07','2024-02-27 19:28:48'),(150,'acct_1OolGvB4mM8OpLGo','680',0,0,'https://connect.stripe.com/setup/e/acct_1OolGvB4mM8OpLGo/854Sxv1sBLfA','eventually_due','false','individual','2024-02-28 11:26:04','2024-02-28 11:26:37'),(151,'acct_1Oom1cPYtHCgR4uR','680',0,0,'https://connect.stripe.com/setup/e/acct_1Oom1cPYtHCgR4uR/ErVXWW6kUqXD','eventually_due','false','individual','2024-02-28 12:14:19','2024-02-28 12:16:16'),(152,'acct_1OomoKPkDYnMVH7W','680',0,0,'https://connect.stripe.com/setup/e/acct_1OomoKPkDYnMVH7W/W2Scw2vMHZxF','eventually_due','false','individual','2024-02-28 13:04:39','2024-02-28 13:05:50'),(153,'acct_1Op97ABFBE0OFuRL','856',0,0,'https://connect.stripe.com/setup/e/acct_1Op97ABFBE0OFuRL/nc2A2spLIgdu','eventually_due','false','individual','2024-02-29 12:53:34','2024-02-29 12:53:56'),(154,'acct_1Op9qyBDacM037l9','856',0,0,'https://connect.stripe.com/setup/e/acct_1Op9qyBDacM037l9/SBOsMzxAMPUV','eventually_due','false','individual','2024-02-29 13:40:54','2024-02-29 13:41:11'),(155,'acct_1OpTllB6ZhLlH2EX','672',0,0,'https://connect.stripe.com/setup/e/acct_1OpTllB6ZhLlH2EX/Rd78NSta0zWm','eventually_due','false','individual','2024-03-01 10:56:52','2024-03-01 10:57:13'),(156,'acct_1OyY5WBXuAieszNf','',528279,527341,'https://connect.stripe.com/setup/e/acct_1OyY5WBXuAieszNf/2W5dN83U1oL7','eventually_due','false','government_entity','2024-03-26 11:22:44','2024-03-26 11:32:41'),(157,'acct_1Ozd5DBXU6zs5VHf','',528279,527341,'https://connect.stripe.com/setup/e/acct_1Ozd5DBXU6zs5VHf/OeR9kepRRUxT','eventually_due','false','government_entity','2024-03-29 10:54:54','2024-03-29 10:55:13'),(158,'acct_1Ozd9BPcPr3ZES9W','',528279,527341,'https://connect.stripe.com/setup/e/acct_1Ozd9BPcPr3ZES9W/Ad7IYi0d22CY','eventually_due','false','government_entity','2024-03-29 10:59:01','2024-03-29 11:02:41'),(159,'acct_1PpWMVB1RAaP2IkH','1250',0,0,'https://connect.stripe.com/setup/e/acct_1PpWMVB1RAaP2IkH/b9f4d7UvB1EL','eventually_due','true','individual','2024-08-19 14:15:14','2024-08-19 14:23:47'),(160,'acct_1QDm0MBURFEFkmgO','',528345,527421,'https://connect.stripe.com/setup/e/acct_1QDm0MBURFEFkmgO/nNcwbncejM30','eventually_due','true','government_entity','2024-10-25 11:48:37','2024-10-25 12:20:56'),(161,'acct_1QWcGRBUCvit9DuT','',528349,527435,'https://connect.stripe.com/setup/e/acct_1QWcGRBUCvit9DuT/hWksxY3EfF55','eventually_due','true','government_entity','2024-12-16 11:15:06','2024-12-16 11:31:25'),(162,'acct_1Qex6oBOoDYofgsQ','1414',0,0,'https://connect.stripe.com/setup/e/acct_1Qex6oBOoDYofgsQ/6Dsht7hJ97KV','eventually_due','true','individual','2025-01-08 11:07:37','2025-01-08 11:26:40');

--
-- Table structure for table `agency_article_comment`
--

CREATE TABLE `agency_article_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(100) NOT NULL DEFAULT '0',
  `officerId` int(100) NOT NULL DEFAULT '0',
  `articleId` int(100) NOT NULL DEFAULT '0',
  `comment` text,
  `createdBy` int(100) NOT NULL DEFAULT '0',
  `updatedBy` int(100) NOT NULL DEFAULT '0',
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updateAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=214 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `agency_article_comment`
--

INSERT INTO `agency_article_comment` VALUES (1,8,0,3,'COMMENT ADDED',8,0,'2022-01-26 13:04:58','2022-01-26 13:08:51'),(2,0,504429,5,'ITTSTAR DEMO ',504429,0,'2022-01-26 13:05:15','2022-01-26 13:34:38'),(7,0,504429,2,'OFFICER COMMENT FOR EVENT  1',504429,0,'2022-01-26 13:08:00','2022-01-26 13:08:00'),(8,0,504429,4,'OFFICER COMMENT FOR EVENT  4',504429,0,'2022-01-26 13:08:11','2022-01-26 13:08:11'),(9,0,504429,6,'OFFICER COMMENT FOR EVENT  6',504429,0,'2022-01-26 13:08:17','2022-01-26 13:08:17'),(10,0,504429,10,'ITTSTAR DEMO  100',504429,504429,'2022-01-26 13:08:21','2022-01-26 13:35:31'),(11,339,0,7,'OFF ',339,0,'2022-01-26 13:08:27','2022-01-26 13:40:28'),(12,0,541015,2,'Welcome',541015,0,'2022-01-26 13:08:00','2022-01-26 13:40:29'),(13,340,0,3,'SEE YOU',340,0,'2022-01-26 13:08:11','2022-01-26 13:59:57'),(14,0,541015,6,'ITTSTAR',541015,0,'2022-01-26 13:08:17','2022-01-26 13:40:30'),(15,341,0,10,'ITTSTAR GA',341,504429,'2022-01-26 13:08:21','2022-01-26 13:40:11'),(16,0,541014,7,'MA',541014,0,'2022-01-26 13:08:27','2022-01-26 13:40:12'),(17,340,0,4,'MMAMMA',340,0,'2022-01-26 13:08:11','2022-01-26 13:40:13'),(18,0,541014,3,'GA',541014,0,'2022-01-26 13:08:17','2022-01-26 13:59:58'),(19,0,541015,10,'HA',541015,504429,'2022-01-26 13:08:21','2022-01-26 13:40:14'),(20,0,541014,1,'LA',541014,0,'2022-01-26 13:08:27','2022-01-26 13:40:15'),(21,0,504429,11,'OFFICER COMMENT FOR EVENT  7',504429,0,'2022-01-27 11:17:40','2022-01-27 11:17:40'),(22,8,0,12,'Lorem Ipsum is simply dummy text of the printing and typesetting industry. manoj',8,0,'2022-01-27 11:18:47','2022-01-27 11:18:47'),(23,8,0,11,'comment added testing ',8,0,'2022-01-27 11:20:14','2022-01-27 11:20:14'),(24,8,0,12,'comment added ',8,0,'2022-01-27 11:21:29','2022-01-27 11:21:29'),(25,8,0,12,'Lorem Ipsum is simply dummy text of the printing and typesetting industry. manoj test',8,0,'2022-01-27 12:33:40','2022-01-27 12:33:40'),(27,8,0,10,'testing comment test',8,0,'2022-01-28 06:49:03','2022-01-28 06:49:03'),(28,8,0,0,'Lorem Ipsum is simply dummy text of the printing and typesetting industry. manoj',8,0,'2022-01-28 07:46:23','2022-01-28 07:46:23'),(29,8,0,10,'Lorem Ipsum is simply dummy text of the printing and typesetting industry. manoj 1',8,0,'2022-01-28 07:48:26','2022-01-28 07:48:26'),(30,8,0,10,'Lorem Ipsum is simply dummy text of the printing and typesetting industry. manoj 2',8,0,'2022-01-28 07:51:18','2022-01-28 07:51:18'),(31,8,0,10,'printing and typesetting industry. manoj 4',8,0,'2022-01-28 07:52:47','2022-01-28 07:52:47'),(32,8,0,10,'test 5',8,0,'2022-01-28 07:57:47','2022-01-28 07:57:47'),(33,8,0,10,'message test 6',8,0,'2022-01-28 07:58:48','2022-01-28 07:58:48'),(34,8,0,10,'Test from search precint manoj 1',8,0,'2022-01-28 08:03:38','2022-01-28 08:03:38'),(35,8,0,10,'test from the frontend for article 10',8,0,'2022-01-28 08:04:14','2022-01-28 08:04:14'),(36,8,0,10,'test',8,0,'2022-01-28 09:02:24','2022-01-28 09:02:24'),(37,0,513217,10,'test',513217,0,'2022-01-28 12:14:03','2022-01-28 12:14:03'),(38,8,0,0,'testing comment manoj 1',8,0,'2022-01-28 12:19:48','2022-01-28 12:19:48'),(39,8,0,0,'testing comment',8,0,'2022-01-28 12:20:25','2022-01-28 12:20:25'),(40,8,0,14,'testing from the back office 1',8,0,'2022-01-28 12:21:34','2022-01-28 12:21:34'),(41,0,513217,18,'Crime is getting our to hand!',513217,0,'2022-01-28 16:34:30','2022-01-28 16:34:30'),(42,0,513217,18,'test',513217,0,'2022-01-28 16:39:10','2022-01-28 16:39:10'),(43,0,504429,11,'commented 1',504429,0,'2022-02-02 16:16:06','2022-02-02 16:16:06'),(44,343,0,11,'commented 2',343,0,'2022-02-02 16:21:09','2022-02-02 16:21:09'),(45,0,541015,11,'commented 3',541015,0,'2022-02-02 16:25:34','2022-02-02 16:25:34'),(46,0,504429,11,'ITTSTAR MANOJ PLEASE CHAT',504429,0,'2022-02-04 11:40:51','2022-02-04 11:40:51'),(47,0,504429,8,'HIIII MANOJ',504429,0,'2022-02-04 11:52:19','2022-02-04 11:52:19'),(48,0,504429,8,'HII WALTER',504429,0,'2022-02-04 11:52:49','2022-02-04 11:52:49'),(49,0,504429,20,'weclome',504429,0,'2022-02-11 15:41:39','2022-02-11 15:41:39'),(50,0,504429,22,'abc ',504429,0,'2022-02-15 11:39:19','2022-02-15 11:39:19'),(51,0,513217,21,'adsfasdfsd',513217,0,'2022-02-28 16:05:59','2022-02-28 16:05:59'),(52,0,513217,21,'asdfsdf',513217,0,'2022-02-28 16:06:15','2022-02-28 16:06:15'),(53,0,513217,21,'asdfsdfsd',513217,0,'2022-02-28 16:07:52','2022-02-28 16:07:52'),(54,365,0,18,'asdfasdfsdf',365,0,'2022-02-28 16:19:09','2022-02-28 16:19:09'),(55,8,0,22,'we 11',8,0,'2022-03-01 16:35:42','2022-03-01 16:35:42'),(56,0,504429,22,'sa',504429,0,'2022-03-04 05:42:25','2022-03-04 05:42:25'),(57,369,0,22,'adfsadfsdf',369,0,'2022-03-04 17:11:42','2022-03-04 17:11:42'),(58,365,0,22,'asdfasdfasdd',365,0,'2022-03-15 15:47:14','2022-03-15 15:47:14'),(59,401,0,20,'adsfsdfasdfsd',401,0,'2022-03-15 15:49:42','2022-03-15 15:49:42'),(60,365,0,22,'lsdkfsldfjdkf',365,0,'2022-03-22 14:03:19','2022-03-22 14:03:19'),(61,0,541023,22,'commented testing ',541023,0,'2022-03-23 12:33:52','2022-03-23 12:33:52'),(62,0,541023,22,'',541023,0,'2022-03-23 12:39:03','2022-03-23 12:39:03'),(63,0,541023,22,'',541023,0,'2022-03-23 12:39:03','2022-03-23 12:39:03'),(64,0,541023,22,'',541023,0,'2022-03-23 12:39:03','2022-03-23 12:39:03'),(65,0,541023,22,'qwerty',541023,0,'2022-03-23 12:41:02','2022-03-23 12:41:02'),(66,0,541023,22,'qwerty test',541023,0,'2022-03-23 12:46:11','2022-03-23 12:46:11'),(67,405,0,22,'testing resident res',405,0,'2022-03-23 12:49:34','2022-03-23 12:49:34'),(68,365,0,21,'dfgfdgsrdtg54etdg',365,0,'2022-03-28 15:00:40','2022-03-28 15:00:40'),(69,8,0,25,'commented',8,0,'2022-08-01 08:14:12','2022-08-01 08:14:12'),(70,620,0,25,'aaaaa',620,0,'2023-04-18 08:26:11','2023-04-18 08:26:11'),(71,0,540969,32,'aaddasdd',540969,0,'2023-05-06 11:13:12','2023-05-06 11:13:12'),(72,0,513217,0,'I am a witness and saw him too.',513217,0,'2023-05-19 14:53:45','2023-05-19 14:53:45'),(73,0,513217,39,'asdasdfasdfasdf',513217,0,'2023-05-19 14:54:44','2023-05-19 14:54:44'),(74,0,513217,39,'I was this whole thing unfold',513217,0,'2023-05-19 14:55:05','2023-05-19 14:55:05'),(75,0,540969,39,'hello',540969,0,'2023-05-19 15:25:06','2023-05-19 15:25:06'),(76,0,503951,64,'vbhnjmkl',503951,0,'2023-07-06 13:36:52','2023-07-06 13:36:52'),(77,0,540969,0,'vdssdfsdfsdf',540969,0,'2023-07-26 14:50:08','2023-07-26 14:50:08'),(78,8,0,118,'well',8,0,'2023-09-19 13:19:41','2023-09-19 13:19:41'),(79,872,0,118,'Test',872,0,'2023-09-29 16:49:44','2023-09-29 16:49:44'),(80,8,0,115,'sertghj',8,0,'2023-11-06 10:57:30','2023-11-06 10:57:30'),(81,8,0,0,'check test',8,0,'2023-11-20 14:52:41','2023-11-20 14:52:41'),(82,8,0,118,'check new',8,0,'2023-11-20 14:53:15','2023-11-20 14:53:15'),(83,8,0,118,'',8,0,'2023-11-20 15:02:29','2023-11-20 15:02:29'),(84,8,0,118,'',8,0,'2023-11-20 15:02:30','2023-11-20 15:02:30'),(85,789,0,0,'New comment',789,0,'2023-12-14 10:49:05','2023-12-14 10:49:05'),(86,789,0,0,'',789,0,'2023-12-14 10:49:15','2023-12-14 10:49:15'),(87,789,0,0,'Another comment',789,0,'2023-12-14 10:49:35','2023-12-14 10:49:35'),(88,789,0,115,'New comment',789,0,'2023-12-14 10:50:28','2023-12-14 10:50:28'),(89,789,0,115,'Another new comment',789,0,'2023-12-14 10:50:42','2023-12-14 10:50:42'),(90,789,0,0,'Comments',789,0,'2023-12-14 10:51:15','2023-12-14 10:51:15'),(91,789,0,0,'Another new comment',789,0,'2023-12-14 10:52:00','2023-12-14 10:52:00'),(92,789,0,0,'ASXCS',789,0,'2023-12-14 10:52:17','2023-12-14 10:52:17'),(93,789,0,107,'hi',789,0,'2023-12-14 10:52:46','2023-12-14 10:52:46'),(94,789,0,107,'Checking like button',789,0,'2023-12-14 10:53:28','2023-12-14 10:53:28'),(95,789,0,107,'asd',789,0,'2023-12-14 10:55:18','2023-12-14 10:55:18'),(96,789,0,107,'',789,0,'2023-12-14 10:55:31','2023-12-14 10:55:31'),(97,789,0,107,'',789,0,'2023-12-14 10:55:36','2023-12-14 10:55:36'),(98,919,0,114,'dfsdfdsfdsf',919,0,'2023-12-14 13:51:15','2023-12-14 13:51:15'),(99,919,0,0,'karthik testing',919,0,'2023-12-14 13:54:16','2023-12-14 13:54:16'),(100,919,0,0,'karthik testing',919,0,'2023-12-14 13:54:26','2023-12-14 13:54:26'),(101,919,0,0,'karthik testing',919,0,'2023-12-14 13:54:27','2023-12-14 13:54:27'),(102,919,0,0,'karthik testing',919,0,'2023-12-14 13:54:29','2023-12-14 13:54:29'),(103,919,0,0,'karthik testing',919,0,'2023-12-14 13:54:30','2023-12-14 13:54:30'),(104,919,0,0,'karthik testing',919,0,'2023-12-14 13:54:31','2023-12-14 13:54:31'),(105,919,0,0,'karthik testing',919,0,'2023-12-14 13:54:35','2023-12-14 13:54:35'),(106,919,0,0,'karthick',919,0,'2023-12-14 13:55:19','2023-12-14 13:55:19'),(107,919,0,114,'karthick',919,0,'2023-12-14 13:56:08','2023-12-14 13:56:08'),(108,919,0,114,'karthick',919,0,'2023-12-14 13:56:55','2023-12-14 13:56:55'),(109,919,0,114,'try',919,0,'2023-12-14 13:58:01','2023-12-14 13:58:01'),(110,919,0,0,'checkout',919,0,'2023-12-14 14:01:05','2023-12-14 14:01:05'),(111,919,0,0,'another',919,0,'2023-12-14 14:02:09','2023-12-14 14:02:09'),(112,919,0,0,'chjeck',919,0,'2023-12-14 14:07:38','2023-12-14 14:07:38'),(113,919,0,114,'sdfsdfsdf',919,0,'2023-12-14 14:10:28','2023-12-14 14:10:28'),(114,919,0,114,'checking',919,0,'2023-12-14 14:11:57','2023-12-14 14:11:57'),(115,919,0,114,'lastcheck',919,0,'2023-12-14 14:12:31','2023-12-14 14:12:31'),(116,919,0,114,'check',919,0,'2023-12-14 14:24:25','2023-12-14 14:24:25'),(117,919,0,114,'check again',919,0,'2023-12-14 14:25:35','2023-12-14 14:25:35'),(118,919,0,114,'checking the comments',919,0,'2023-12-14 14:31:46','2023-12-14 14:31:46'),(119,919,0,0,'check comments\n',919,0,'2023-12-14 14:33:15','2023-12-14 14:33:15'),(120,919,0,114,'another comment',919,0,'2023-12-14 14:34:21','2023-12-14 14:34:21'),(121,919,0,115,'new check',919,0,'2023-12-14 14:56:39','2023-12-14 14:56:39'),(122,919,0,115,'check again',919,0,'2023-12-14 15:04:26','2023-12-14 15:04:26'),(123,919,0,0,'check once again',919,0,'2023-12-14 15:15:30','2023-12-14 15:15:30'),(124,919,0,0,'sdfsdfsdf',919,0,'2023-12-14 15:20:42','2023-12-14 15:20:42'),(125,919,0,115,'new check',919,0,'2023-12-14 15:21:39','2023-12-14 15:21:39'),(126,919,0,0,'Hello',919,0,'2023-12-14 15:26:03','2023-12-14 15:26:03'),(127,919,0,0,'comments adding now\n',919,0,'2023-12-14 15:26:24','2023-12-14 15:26:24'),(128,919,0,0,'proper',919,0,'2023-12-14 15:27:04','2023-12-14 15:27:04'),(129,919,0,0,'recent',919,0,'2023-12-14 15:29:02','2023-12-14 15:29:02'),(130,919,0,115,'recent comment\n',919,0,'2023-12-14 15:29:38','2023-12-14 15:29:38'),(131,919,0,0,'checkout',919,0,'2023-12-14 15:31:50','2023-12-14 15:31:50'),(132,919,0,0,'again',919,0,'2023-12-14 15:33:44','2023-12-14 15:33:44'),(133,919,0,0,'new',919,0,'2023-12-14 15:33:59','2023-12-14 15:33:59'),(134,919,0,0,'checkout',919,0,'2023-12-14 15:36:08','2023-12-14 15:36:08'),(135,919,0,0,'checkout',919,0,'2023-12-14 15:36:41','2023-12-14 15:36:41'),(136,919,0,115,'asdasdasd',919,0,'2023-12-14 15:37:32','2023-12-14 15:37:32'),(137,919,0,115,'issue with comments',919,0,'2023-12-14 15:38:53','2023-12-14 15:38:53'),(138,0,513217,109,'test',513217,0,'2023-12-14 18:53:48','2023-12-14 18:53:48'),(139,919,0,127,'',919,0,'2023-12-15 10:50:27','2023-12-15 10:50:27'),(140,919,0,127,'asdasdasdasd',919,0,'2023-12-15 11:01:02','2023-12-15 11:01:02'),(141,968,0,0,'test sadasdasad',968,0,'2024-01-03 13:26:27','2024-01-03 13:26:27'),(142,968,0,127,'testing the development ssss',968,0,'2024-01-03 13:27:43','2024-01-03 13:27:43'),(143,968,0,0,'hello testing',968,0,'2024-01-03 14:47:21','2024-01-03 14:47:21'),(144,968,0,129,'asasdasdasdada',968,0,'2024-01-03 14:47:38','2024-01-03 14:47:38'),(145,968,0,129,'sssssssssss',968,0,'2024-01-03 14:47:48','2024-01-03 14:47:48'),(146,0,513217,104,'ghrtytrytryh',513217,0,'2024-01-15 15:08:19','2024-01-15 15:08:19'),(147,0,513217,132,'hi',513217,0,'2024-01-17 08:55:47','2024-01-17 08:55:47'),(148,0,540969,135,'Trump is great',540969,0,'2024-01-17 12:26:39','2024-01-17 12:26:39'),(149,789,0,133,'Testing comments\n',789,0,'2024-01-18 10:13:48','2024-01-18 10:13:48'),(150,8,0,135,'test comment',8,0,'2024-01-29 15:31:58','2024-01-29 15:31:58'),(151,979,0,0,'I agree',979,0,'2024-01-31 12:20:04','2024-01-31 12:20:04'),(152,979,0,133,'I agree need more better laws',979,0,'2024-01-31 12:22:01','2024-01-31 12:22:01'),(153,789,0,133,'hello\n',789,0,'2024-02-01 10:20:50','2024-02-01 10:20:50'),(154,789,0,133,'second testing\n',789,0,'2024-02-01 10:21:21','2024-02-01 10:21:21'),(155,789,0,0,'hello bods',789,0,'2024-02-01 13:06:41','2024-02-01 13:06:41'),(156,789,0,0,'hello bods',789,0,'2024-02-01 13:06:48','2024-02-01 13:06:48'),(157,789,0,0,'asdasdad',789,0,'2024-02-01 13:07:20','2024-02-01 13:07:20'),(158,789,0,0,'adadsads',789,0,'2024-02-01 13:22:05','2024-02-01 13:22:05'),(159,789,0,135,'asdasd',789,0,'2024-02-01 13:28:14','2024-02-01 13:28:14'),(160,789,0,0,'testing',789,0,'2024-02-01 13:31:40','2024-02-01 13:31:40'),(161,789,0,135,'asdasds',789,0,'2024-02-01 13:35:56','2024-02-01 13:35:56'),(162,789,0,135,'test',789,0,'2024-02-01 13:36:38','2024-02-01 13:36:38'),(163,0,541165,139,'jkl',541165,0,'2024-02-23 15:25:27','2024-02-23 15:25:27'),(164,0,541165,140,'Hi',541165,0,'2024-03-14 11:28:07','2024-03-14 11:28:07'),(165,0,541165,140,'hi',541165,0,'2024-03-14 11:29:29','2024-03-14 11:29:29'),(166,0,541165,141,'hi ',541165,0,'2024-03-14 11:49:30','2024-03-14 11:49:30'),(167,0,541160,142,'hi',541160,0,'2024-03-14 12:56:54','2024-03-14 12:56:54'),(168,0,541160,142,'hi',541160,0,'2024-03-14 13:01:32','2024-03-14 13:01:32'),(169,0,541160,142,'hi',541160,0,'2024-03-14 13:03:52','2024-03-14 13:03:52'),(170,8,0,143,'hi',8,0,'2024-03-15 11:52:26','2024-03-15 11:52:26'),(171,0,541177,144,'hi',541177,0,'2024-03-15 12:09:40','2024-03-15 12:09:40'),(172,0,513217,114,'test',513217,0,'2024-03-18 11:08:51','2024-03-18 11:08:51'),(173,0,513217,114,'test this',513217,0,'2024-03-18 11:09:03','2024-03-18 11:09:03'),(174,0,513217,132,'hi',513217,0,'2024-03-18 11:16:32','2024-03-18 11:16:32'),(175,0,513217,132,'hidx',513217,0,'2024-03-18 11:16:58','2024-03-18 11:16:58'),(176,0,540969,143,'check',540969,0,'2024-03-18 11:32:59','2024-03-18 11:32:59'),(177,8,0,144,'aaaaaaaaaaaaaaaaa',8,0,'2024-03-25 08:17:54','2024-03-25 08:17:54'),(178,8,0,144,'hello',8,0,'2024-03-25 10:08:43','2024-03-25 10:08:43'),(179,0,541177,142,'hello',541177,0,'2024-03-26 11:13:49','2024-03-26 11:13:49'),(180,0,541176,144,'red',541176,0,'2024-03-26 12:30:51','2024-03-26 12:30:51'),(181,0,540969,144,'new comment',540969,0,'2024-03-26 12:31:46','2024-03-26 12:31:46'),(182,0,541165,160,'hi',541165,0,'2024-04-17 11:05:06','2024-04-17 11:05:06'),(183,0,541165,160,'',541165,0,'2024-04-17 11:05:22','2024-04-17 11:05:22'),(184,789,0,160,'hi\n',789,0,'2024-09-08 17:17:27','2024-09-08 17:17:27'),(185,789,0,160,'hello new comment',789,0,'2024-09-10 06:00:27','2024-09-10 06:00:27'),(186,789,0,156,'hello',789,0,'2024-09-10 06:03:52','2024-09-10 06:03:52'),(187,789,0,156,'',789,0,'2024-09-10 06:05:30','2024-09-10 06:05:30'),(188,789,0,156,'',789,0,'2024-09-10 06:06:41','2024-09-10 06:06:41'),(189,789,0,0,'156',789,0,'2024-09-10 06:09:05','2024-09-10 06:09:05'),(190,789,0,0,'160',789,0,'2024-09-10 06:14:08','2024-09-10 06:14:08'),(191,789,0,0,'157',789,0,'2024-09-10 06:15:36','2024-09-10 06:15:36'),(192,789,0,158,'First comment',789,0,'2024-09-10 06:17:47','2024-09-10 06:17:47'),(193,789,0,158,'Thank you',789,0,'2024-09-10 06:17:57','2024-09-10 06:17:57'),(194,789,0,160,'good afternoon ',789,0,'2024-09-10 06:37:52','2024-09-10 06:37:52'),(195,789,0,156,'bye',789,0,'2024-09-10 07:22:56','2024-09-10 07:22:56'),(196,789,0,156,'he International Cricket Council (ICC) released a comprehensive economic report on Wednesday, September 11, detailing the impressive economic gains generated by the men\'s Cricket World Cup 2023. Hoste',789,0,'2024-09-12 10:05:58','2024-09-12 10:05:58'),(197,789,0,156,'good ',789,0,'2024-09-12 19:27:07','2024-09-12 19:27:07'),(198,789,0,160,'go',789,0,'2024-09-16 17:17:24','2024-09-16 17:17:24'),(199,789,0,160,'afternoon test',789,0,'2024-09-17 11:18:55','2024-09-17 11:18:55'),(200,789,0,160,'new comment for reply',789,0,'2024-09-17 14:09:03','2024-09-17 14:09:03'),(201,789,0,160,'new comment',789,0,'2024-09-17 14:09:18','2024-09-17 14:09:18'),(202,789,0,149,'My new comment',789,0,'2024-09-17 14:52:44','2024-09-17 14:52:44'),(203,789,0,160,'new comment',789,0,'2024-09-18 13:00:25','2024-09-18 13:00:25'),(204,789,0,160,'11th',789,0,'2024-09-18 13:02:03','2024-09-18 13:02:03'),(205,789,0,160,'12th',789,0,'2024-09-18 13:03:25','2024-09-18 13:03:25'),(206,789,0,148,'1st comment',789,0,'2024-09-18 13:29:12','2024-09-18 13:29:12'),(207,789,0,160,'New comment',789,0,'2024-09-18 14:08:10','2024-09-18 14:08:10'),(208,789,0,159,'new comment, to check synchronity across app',789,0,'2024-09-18 14:22:33','2024-09-18 14:22:33'),(209,789,0,160,'14the comment',789,0,'2024-09-23 10:30:39','2024-09-23 10:30:39'),(210,789,0,160,'15th comment',789,0,'2024-09-23 10:32:47','2024-09-23 10:32:47'),(211,789,0,153,'Hi',789,0,'2024-09-27 14:19:23','2024-09-27 14:19:23'),(212,789,0,161,'New comments',789,0,'2024-10-11 16:01:41','2024-10-11 16:01:41'),(213,0,541536,165,'test',541536,0,'2025-01-07 10:28:19','2025-01-07 10:28:19');

--
-- Table structure for table `agency_article_comment_like`
--

CREATE TABLE `agency_article_comment_like` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `commentId` int(100) NOT NULL DEFAULT '0',
  `userId` int(100) NOT NULL DEFAULT '0',
  `officerId` int(100) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `agency_article_comment_like`
--

INSERT INTO `agency_article_comment_like` VALUES (1,1,0,540998),(2,10,0,540998),(3,11,0,540998),(4,14,0,504429),(5,16,0,540998),(6,18,0,504429),(7,9,0,540998),(8,9,345,0),(9,8,345,0),(10,10,345,0),(11,13,345,0),(12,14,345,0),(13,17,345,0),(15,20,0,504429),(16,40,8,0),(17,23,0,540998),(20,36,0,513217),(22,36,8,0),(23,37,0,504429),(24,36,8,0),(25,37,8,0),(26,46,0,504429),(27,46,8,0),(28,47,0,503946),(29,48,8,0),(31,47,0,503946),(32,47,8,0),(33,48,8,0),(34,41,0,513217),(37,42,0,513217),(44,35,0,513217),(45,34,0,513217),(46,37,0,513217),(47,23,0,504429),(48,43,0,504429),(49,47,8,0),(50,46,0,541016),(51,46,0,541016),(52,45,0,541016),(53,45,0,541016),(54,45,0,541016),(55,23,0,541016),(56,46,0,541016),(57,46,0,541016),(58,45,0,541016),(59,45,0,541016),(60,46,0,541016),(61,46,0,541016),(62,46,0,541016),(63,46,0,541016),(64,44,0,541016),(65,43,0,541016),(66,21,0,541016),(67,48,0,504429),(68,47,0,504429),(69,48,0,541016),(70,16,0,504429),(71,49,0,504429),(72,51,0,513217),(73,53,0,513217),(74,52,0,513217),(75,50,8,0),(76,67,432,0),(77,54,0,504429),(78,66,0,504429),(79,66,0,513217),(80,65,0,513217),(81,69,620,0),(82,70,620,0),(83,70,0,540969),(84,69,0,540969),(85,74,0,513217),(86,73,0,513217),(87,78,8,0),(88,84,8,0),(89,80,855,0),(90,80,789,0),(91,80,789,0),(92,80,789,0),(93,82,789,0),(94,83,789,0),(95,84,789,0),(96,79,789,0),(97,78,789,0),(98,93,789,0),(99,94,789,0),(100,118,8,0),(101,17,968,0),(102,84,968,0),(103,83,968,0),(104,140,968,0),(105,120,0,513217),(106,148,0,540969),(107,149,789,0),(108,152,979,0),(109,149,979,0),(110,147,789,0),(111,154,8,0),(112,168,0,541160),(113,183,789,0),(114,184,789,0),(115,184,789,0),(116,184,789,0),(117,184,789,0),(118,183,789,0),(119,182,789,0),(120,184,789,0),(121,183,789,0),(122,184,789,0),(123,174,789,0),(124,182,789,0),(125,182,789,0),(126,193,789,0),(127,194,789,0),(128,194,789,0),(129,194,789,0),(130,194,789,0),(131,185,789,0),(132,192,789,0),(133,198,789,0),(134,199,789,0),(135,200,789,0),(136,201,789,0),(137,202,789,0),(138,211,789,0),(139,192,1327,0),(140,212,789,0);

--
-- Table structure for table `agency_article_comment_reply`
--

CREATE TABLE `agency_article_comment_reply` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(100) NOT NULL DEFAULT '0',
  `officerId` int(100) NOT NULL DEFAULT '0',
  `commentId` int(100) NOT NULL DEFAULT '0',
  `comment` text,
  `createdBy` int(100) NOT NULL DEFAULT '0',
  `updatedBy` int(100) NOT NULL DEFAULT '0',
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updateAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `agency_article_comment_reply`
--

INSERT INTO `agency_article_comment_reply` VALUES (1,343,0,1,'Comment reply 11',343,0,'2022-01-27 13:26:31','2022-01-27 13:26:31'),(2,343,0,2,'Comment reply 12',343,0,'2022-01-27 13:27:00','2022-01-27 13:29:12'),(3,343,0,10,'Comment reply 13',343,0,'2022-01-27 13:27:03','2022-01-27 13:29:13'),(4,343,0,15,'Comment reply 12566',343,0,'2022-01-27 13:27:10','2022-01-27 13:29:14'),(5,345,0,15,'weclome Comment reply  1',345,0,'2022-01-27 13:29:48','2022-01-27 13:29:48'),(6,345,0,15,'weclome Comment reply  1234567',345,0,'2022-01-27 13:29:50','2022-01-27 13:30:03'),(7,0,540986,2,'weclome Comment reply  1',540986,0,'2022-01-27 13:31:55','2022-01-27 13:31:55'),(8,0,540986,20,'weclome Comment reply  1werthjk',540986,0,'2022-01-27 13:32:02','2022-01-27 13:32:02'),(9,0,540986,18,'asdfghjk',540986,0,'2022-01-27 13:32:08','2022-01-27 13:32:08'),(10,0,540986,15,'aaaaaaaaaaaa',540986,0,'2022-01-27 13:32:14','2022-01-27 13:32:14'),(11,0,540990,14,'DEMO TODAY ',540986,540990,'2022-01-27 13:32:23','2022-01-27 13:53:31'),(12,0,540990,14,'MATRIX RELOADED 1 ',540990,0,'2022-01-27 13:33:47','2022-01-27 13:33:47'),(13,0,540990,10,'MATRIX RELOADED 1 2222',540990,0,'2022-01-27 13:33:51','2022-01-27 13:34:09'),(14,0,540990,11,'MATRIX RELOADED 1 2222zxdfghjkl',540990,0,'2022-01-27 13:33:56','2022-01-27 13:34:10'),(15,8,0,10,'manoj Commanted',8,0,'2022-01-28 06:45:00','2022-01-28 06:45:00'),(16,8,0,19,'manoj commented',8,0,'2022-01-28 06:46:14','2022-01-28 06:46:14'),(17,8,0,19,'testing comment manoj',8,0,'2022-01-28 06:48:33','2022-01-28 06:48:33'),(18,8,0,35,'Replay is added for the id 35 ',8,0,'2022-01-28 08:04:44','2022-01-28 08:04:44'),(19,8,0,33,'replay id added for the id 33 from search precint ',8,0,'2022-01-28 08:05:24','2022-01-28 08:05:24'),(20,8,0,36,'testing 1',8,0,'2022-01-28 09:02:43','2022-01-28 09:02:43'),(21,8,0,36,'testing 2',8,0,'2022-01-28 09:03:16','2022-01-28 09:03:16'),(22,8,0,23,'test',8,0,'2022-01-28 09:56:26','2022-01-28 09:56:26'),(23,0,513217,36,'test',513217,0,'2022-01-28 11:21:54','2022-01-28 11:21:54'),(24,0,513217,37,'test 1123',513217,0,'2022-01-28 12:14:16','2022-01-28 12:14:16'),(25,8,0,40,'testing reply from the back office',8,0,'2022-01-28 12:22:00','2022-01-28 12:22:00'),(26,8,0,21,'testing from search 24',8,0,'2022-01-28 13:28:18','2022-01-28 13:28:18'),(27,0,513217,36,'test 2',513217,0,'2022-01-28 14:22:01','2022-01-28 14:22:01'),(28,0,513217,41,'You\'re the criminal!',513217,0,'2022-01-28 16:34:44','2022-01-28 16:34:44'),(29,343,0,43,'commented replied 1',343,0,'2022-02-02 16:19:51','2022-02-02 16:19:51'),(31,343,0,23,'commented replied 2',343,0,'2022-02-02 16:20:11','2022-02-02 16:20:11'),(32,343,0,21,'commented replied 2',343,0,'2022-02-02 16:20:27','2022-02-02 16:20:27'),(33,8,0,44,'commented replied 1',8,0,'2022-02-02 16:21:38','2022-02-02 16:21:38'),(34,0,504429,43,'commented replied 2',504429,0,'2022-02-02 16:21:54','2022-02-02 16:21:54'),(35,0,504429,23,'commented replied 1',504429,0,'2022-02-02 16:22:39','2022-02-02 16:22:39'),(36,0,541015,44,'commented replied 3',541015,0,'2022-02-02 16:25:57','2022-02-02 16:25:57'),(37,0,541015,43,'commented replied 3',541015,0,'2022-02-02 16:26:15','2022-02-02 16:26:15'),(38,0,541015,23,'commented replied 3',541015,0,'2022-02-02 16:26:34','2022-02-02 16:26:34'),(39,0,541015,21,'commeted replied 3',541015,0,'2022-02-02 16:26:50','2022-02-02 16:26:50'),(40,541016,0,44,'commented replied 4',541016,0,'2022-02-02 16:28:45','2022-02-02 16:28:45'),(41,541016,0,43,'commented replied 4',541016,0,'2022-02-02 16:28:58','2022-02-02 16:28:58'),(42,541016,0,23,'commented replied 4',541016,0,'2022-02-02 16:29:13','2022-02-02 16:29:13'),(43,541016,0,21,'commented replied 4',541016,0,'2022-02-02 16:29:27','2022-02-02 16:29:27'),(44,0,504429,36,'paul comment replied\n',504429,0,'2022-02-03 11:48:50','2022-02-03 11:48:50'),(45,0,541015,36,'manoj commented replied',541015,0,'2022-02-03 11:50:03','2022-02-03 11:50:03'),(46,0,503939,36,'living stone commented replied',503939,0,'2022-02-03 11:51:17','2022-02-03 11:51:17'),(47,8,0,42,'Why are you testing?',8,0,'2022-02-03 16:18:08','2022-02-03 16:18:08'),(48,0,503946,46,'yes please ',503946,0,'2022-02-04 11:41:59','2022-02-04 11:41:59'),(49,0,504429,46,'HOW ARE YOU ??',504429,0,'2022-02-04 11:43:04','2022-02-04 11:43:04'),(50,0,503946,46,'I am good ',503946,0,'2022-02-04 11:45:15','2022-02-04 11:45:15'),(51,8,0,46,'MANOJ THERE ?????',8,0,'2022-02-04 11:47:25','2022-02-04 11:47:25'),(52,0,503946,46,'YES SIR ',503946,0,'2022-02-04 11:48:42','2022-02-04 11:48:42'),(53,0,503946,47,'HI HARISH.....\n',503946,0,'2022-02-04 11:52:51','2022-02-04 11:52:51'),(54,8,0,47,'Hi Guys',8,0,'2022-02-04 11:53:23','2022-02-04 11:53:23'),(55,0,513217,42,'Testing Again',513217,0,'2022-02-04 16:34:59','2022-02-04 16:34:59'),(56,0,513217,41,'Tired',513217,0,'2022-02-04 16:35:08','2022-02-04 16:35:08'),(57,0,541016,48,'Mnaoj replied',541016,0,'2022-02-10 11:16:10','2022-02-10 11:16:10'),(58,8,0,49,'hgfdhgfdfdgg',8,0,'2022-02-11 16:35:11','2022-02-11 16:35:11'),(59,8,0,49,'asdfsdfsdf',8,0,'2022-02-11 16:35:16','2022-02-11 16:35:16'),(60,8,0,49,'asdfsdfds',8,0,'2022-02-11 16:35:19','2022-02-11 16:35:19'),(61,0,504429,50,'abc replay',504429,0,'2022-02-15 11:51:33','2022-02-15 11:51:33'),(62,0,513217,51,'asdfsadfsd',513217,0,'2022-02-28 16:06:20','2022-02-28 16:06:20'),(63,0,513217,52,'asdfsdfsd',513217,0,'2022-02-28 16:07:12','2022-02-28 16:07:12'),(64,8,0,53,'sdfghjklkjhgfdsdfghjklkjhgfds',8,0,'2022-03-01 16:35:20','2022-03-01 16:35:20'),(65,8,0,50,'we 11 we 11 we 11',8,0,'2022-03-01 16:35:52','2022-03-01 16:35:52'),(66,8,0,55,'weclome here ',8,0,'2022-03-01 16:36:06','2022-03-01 16:36:06'),(67,8,0,55,'aaaaaaaaaaaaa',8,0,'2022-03-01 16:37:22','2022-03-01 16:37:22'),(68,8,0,55,'dvgfhhj,jhgfdghjkjhgf',8,0,'2022-03-01 16:42:38','2022-03-01 16:42:38'),(69,8,0,56,'asdfasfasdf',8,0,'2022-03-04 16:35:02','2022-03-04 16:35:02'),(70,8,0,53,'wwwwwww',8,0,'2022-05-10 16:24:35','2022-05-10 16:24:35'),(71,0,504429,51,'asdadadas',504429,0,'2022-05-24 08:55:18','2022-05-24 08:55:18'),(72,0,513217,74,'Did you call the police.',513217,0,'2023-05-19 14:55:36','2023-05-19 14:55:36'),(73,0,540969,74,'aaa',540969,0,'2023-05-22 13:17:30','2023-05-22 13:17:30'),(74,968,0,140,'test',968,0,'2024-01-03 13:25:47','2024-01-03 13:25:47'),(75,968,0,139,'hello',968,0,'2024-01-03 13:26:10','2024-01-03 13:26:10'),(76,789,0,149,'No\n',789,0,'2024-01-18 10:13:59','2024-01-18 10:13:59'),(77,979,0,149,'Need proactive actions and better laws ',979,0,'2024-01-31 12:19:46','2024-01-31 12:19:46'),(78,789,0,152,'testing',789,0,'2024-02-01 10:21:11','2024-02-01 10:21:11'),(79,789,0,152,'record',789,0,'2024-02-01 10:21:31','2024-02-01 10:21:31'),(80,789,0,142,'testing',789,0,'2024-02-01 13:06:32','2024-02-01 13:06:32'),(81,789,0,150,'asdasdads',789,0,'2024-02-01 13:07:17','2024-02-01 13:07:17'),(82,789,0,147,'aaaaaaaaa',789,0,'2024-02-01 13:29:00','2024-02-01 13:29:00'),(83,789,0,150,'hello',789,0,'2024-02-01 13:31:34','2024-02-01 13:31:34'),(84,789,0,161,'asdasda',789,0,'2024-02-01 13:36:02','2024-02-01 13:36:02'),(85,0,540969,161,'asdsadsda',540969,0,'2024-02-07 08:45:55','2024-02-07 08:45:55'),(86,0,541165,165,'hello\n',541165,0,'2024-03-14 11:53:24','2024-03-14 11:53:24'),(87,0,541160,168,'hello',541160,0,'2024-03-14 13:03:42','2024-03-14 13:03:42'),(88,8,0,170,'hi',8,0,'2024-03-15 11:52:48','2024-03-15 11:52:48'),(89,789,0,184,'hello\n',789,0,'2024-09-09 15:55:07','2024-09-09 15:55:07'),(90,789,0,184,'hi 2',789,0,'2024-09-17 11:19:37','2024-09-17 11:19:37'),(91,789,0,160,'hello',789,0,'2024-09-17 13:08:36','2024-09-17 13:08:36'),(92,789,0,160,'hello',789,0,'2024-09-17 13:08:53','2024-09-17 13:08:53'),(93,789,0,160,'hello',789,0,'2024-09-17 13:10:05','2024-09-17 13:10:05'),(94,789,0,185,'hello',789,0,'2024-09-17 13:16:17','2024-09-17 13:16:17'),(95,789,0,199,'hello',789,0,'2024-09-17 13:16:34','2024-09-17 13:16:34'),(96,789,0,199,'Good evening',789,0,'2024-09-17 13:18:27','2024-09-17 13:18:27'),(97,789,0,199,'bye',789,0,'2024-09-17 13:20:40','2024-09-17 13:20:40'),(98,789,0,184,'hi 3',789,0,'2024-09-17 13:21:48','2024-09-17 13:21:48'),(99,789,0,184,'yy',789,0,'2024-09-17 13:22:21','2024-09-17 13:22:21'),(100,789,0,184,'ii',789,0,'2024-09-17 13:24:21','2024-09-17 13:24:21'),(101,789,0,198,'K going with fins to swim',789,0,'2024-09-17 13:31:22','2024-09-17 13:31:22'),(102,789,0,184,'hello',789,0,'2024-09-17 13:38:02','2024-09-17 13:38:02'),(103,789,0,201,'reply for comment',789,0,'2024-09-17 14:10:06','2024-09-17 14:10:06'),(104,789,0,202,'My own replies',789,0,'2024-09-17 14:53:34','2024-09-17 14:53:34'),(105,789,0,212,'replying to my comment',789,0,'2024-10-11 16:02:02','2024-10-11 16:02:02');

--
-- Table structure for table `agency_article_like`
--

CREATE TABLE `agency_article_like` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `articleId` int(100) NOT NULL DEFAULT '0',
  `userId` int(100) NOT NULL DEFAULT '0',
  `officerId` int(100) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `agency_article_like`
--

INSERT INTO `agency_article_like` VALUES (1,2,0,503957),(2,2,338,0),(3,2,339,0),(4,2,340,0),(5,2,0,504429),(6,1,0,504429),(10,14,8,0),(11,11,8,0),(12,10,8,0),(13,9,8,0),(15,7,8,0),(20,3,8,0),(21,18,0,513217),(23,8,8,0),(24,11,8,0),(25,18,8,0),(28,22,0,541016),(29,22,0,541016),(30,20,0,541016),(31,21,0,513217),(32,21,0,513217),(33,21,0,513217),(35,21,0,504429),(36,22,0,504429),(37,22,0,504429),(38,22,0,504429),(39,10,0,504429),(40,22,8,0),(41,20,8,0),(42,25,620,0),(43,25,789,0),(44,78,0,540969),(45,118,8,0),(46,115,8,0),(47,32,8,0),(48,115,789,0),(49,114,789,0),(50,112,789,0),(51,110,919,0),(52,112,919,0),(53,118,919,0),(54,108,919,0),(55,113,919,0),(56,114,919,0),(57,108,8,0),(58,132,0,513217),(59,135,0,540969),(60,135,8,0),(61,135,968,0),(62,133,979,0),(63,132,979,0),(64,112,979,0),(65,133,8,0),(66,132,789,0),(67,135,789,0),(68,133,789,0),(69,127,789,0),(70,140,0,541165),(72,158,789,0),(73,159,789,0),(74,157,789,0),(75,157,789,0),(76,157,789,0),(77,159,789,0),(78,159,789,0),(79,159,789,0),(81,156,789,0),(83,159,789,0),(84,159,789,0),(85,156,789,0),(86,156,789,0),(87,153,789,0),(88,152,789,0),(89,150,789,0),(90,157,789,0),(91,156,789,0),(92,156,789,0),(93,155,789,0),(94,153,789,0),(95,156,789,0),(96,150,789,0),(98,156,789,0),(99,156,789,0),(100,156,789,0),(101,158,789,0),(104,160,789,0),(105,148,789,0),(106,146,789,0),(107,140,789,0),(108,149,789,0),(109,131,789,0),(110,137,789,0),(111,160,1309,0),(112,156,1317,0),(113,155,1317,0),(114,156,1317,0),(115,160,1327,0),(116,156,1327,0),(117,156,1327,0),(118,161,1327,0),(119,159,1327,0),(120,161,789,0),(121,160,1327,0),(122,158,1327,0),(123,161,789,0),(124,161,789,0),(125,161,789,0),(126,153,1327,0);

--
-- Table structure for table `agency_article_reply_like`
--

CREATE TABLE `agency_article_reply_like` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `replyId` int(100) NOT NULL DEFAULT '0',
  `userId` int(100) NOT NULL DEFAULT '0',
  `officerId` int(100) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `agency_article_reply_like`
--

INSERT INTO `agency_article_reply_like` VALUES (1,3,0,504429),(2,1,0,504429),(3,6,0,504429),(4,8,0,504429),(5,10,0,504429),(6,11,0,504429),(7,4,0,504429),(8,4,345,0),(9,3,345,0),(10,10,345,0),(11,7,345,0),(12,11,345,0),(13,11,343,0),(14,10,343,0),(15,9,343,0),(16,1,343,0),(17,11,0,504429),(18,25,8,0),(19,26,8,0),(20,22,8,0),(22,21,0,513217),(23,23,0,513217),(24,9,0,513217),(27,28,0,513217),(28,34,0,504429),(29,50,0,504429),(30,49,0,503946),(31,54,0,504429),(32,53,0,504429),(33,45,0,513217),(34,44,0,513217),(35,24,0,513217),(36,19,0,513217),(37,36,0,504429),(38,46,8,0),(39,44,8,0),(40,23,8,0),(41,27,8,0),(42,53,8,0),(43,41,0,541016),(44,42,0,541016),(45,37,0,541016),(46,57,0,504429),(47,14,0,504429),(48,63,0,513217),(49,72,0,513217),(50,76,789,0),(51,79,789,0),(52,78,789,0),(53,89,789,0),(54,90,789,0),(55,199,789,0),(56,199,789,0),(57,199,789,0),(58,97,789,0),(59,103,789,0),(60,103,789,0),(61,103,789,0),(62,103,789,0),(63,96,789,0),(64,97,789,0),(65,95,789,0),(66,102,789,0),(67,102,789,0),(68,100,789,0),(69,99,789,0),(70,98,789,0),(71,104,789,0),(72,105,789,0);

--
-- Table structure for table `agency_articles`
--

CREATE TABLE `agency_articles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agencyId` int(100) NOT NULL DEFAULT '0',
  `precintId` int(100) NOT NULL DEFAULT '0',
  `officerId` int(100) NOT NULL DEFAULT '0',
  `title` varchar(250) DEFAULT NULL,
  `subject` varchar(1000) DEFAULT NULL,
  `detail` longtext,
  `image` varchar(500) DEFAULT NULL,
  `status` varchar(500) NOT NULL,
  `pulishDate` varchar(500) NOT NULL,
  `rewardStatus` varchar(100) NOT NULL,
  `totalReward` varchar(100) NOT NULL,
  `donation` varchar(100) NOT NULL,
  `donationPrice` varchar(100) NOT NULL,
  `createdBy` int(100) NOT NULL DEFAULT '0',
  `updatedBy` int(100) NOT NULL DEFAULT '0',
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `agency_articles`
--

INSERT INTO `agency_articles` VALUES (1,491650,490692,504429,'ITTSTAR TSTING ARTICLE 25-01-2022','RTICLE 25-01-2022','<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\r\n<div style=\"text-align:left;\"><img src=\"https://cdn.pixabay.com/photo/2018/08/14/13/23/ocean-3605547__340.jpg\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\r\n<p></p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/download.jpg','public','2022-01-25 07:59:30','','','','',504429,0,'2022-01-25 09:56:56','2022-01-26 15:19:22'),(2,491650,490692,504429,'DEMO ITTSTAR','DEMO SUB','<p>welcome test here&nbsp;</p>\r\n<img src=\"data:image/jpeg;base64,[encoded data, 7536 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/>\r\n<p>BYEEEEEEEEEEEE</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/Document%20%282%29.jpg','public','2022-01-25 15:56:20','','','','',504429,0,'2022-01-25 15:58:57','2022-01-26 15:19:06'),(4,491650,490692,541016,'welcome 1','aa','<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\r\n<div style=\"text-align:left;\"><img src=\"https://cdn.pixabay.com/photo/2018/08/14/13/23/ocean-3605547__340.jpg\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\r\n<p></p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/Document%20%282%29.jpg','public','2022-01-25 07:59:30','','','','',504429,0,'2022-01-25 09:56:56','2022-01-26 15:19:07'),(5,491650,490692,541014,'welcome 2','bb','<p>welcome test here&nbsp;</p>\r\n<img src=\"data:image/jpeg;base64,[encoded data, 7536 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/>\r\n<p>BYEEEEEEEEEEEE</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/download.jpg','private','2022-01-25 15:56:20','','','','',504429,0,'2022-01-25 15:58:57','2022-01-26 15:19:24'),(7,491650,490692,541014,'welcome 4','dddd','<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\r\n<div style=\"text-align:left;\"><img src=\"https://cdn.pixabay.com/photo/2018/08/14/13/23/ocean-3605547__340.jpg\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\r\n<p></p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/Document%20%282%29.jpg','public','2022-01-25 07:59:30','','0','','',504429,0,'2022-01-25 09:56:56','2023-06-27 07:26:37'),(8,491650,490692,541016,'welcome 5','eeee','<p>welcome test here&nbsp;</p>\r\n<img src=\"data:image/jpeg;base64,[encoded data, 7536 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/>\r\n<p>BYEEEEEEEEEEEE</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/download.jpg','public','2022-01-25 15:56:20','','','','',504429,0,'2022-01-25 15:58:57','2022-01-26 15:19:25'),(10,491650,490692,541016,'welcome 8','ggg','<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\r\n<div style=\"text-align:left;\"><img src=\"https://cdn.pixabay.com/photo/2018/08/14/13/23/ocean-3605547__340.jpg\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\r\n<p></p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/policeforce-old.png','private','2022-01-25 07:59:30','','0','','',504429,0,'2022-01-25 09:56:56','2023-06-27 07:26:38'),(11,491650,490692,504429,'welcome 8','hhh','<p>welcome test here&nbsp;</p>\r\n<img src=\"data:image/jpeg;base64,[encoded data, 7536 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/>\r\n<p>BYEEEEEEEEEEEE</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/policeforce-old.png','public','2022-01-25 15:56:20','','','','',504429,0,'2022-01-25 15:58:57','2022-01-26 15:19:36'),(18,500438,499480,513217,'Homicide Investigation','Homicide Investigation  on Jimmy Carter Blvd','<p style=\"text-align:start;\"><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: inherit;font-family: inherit;\">(Norcross, GA) Gwinnett Police Detectives are investigating a homicide that occurred on Jimmy Carter Blvd around 12:30 am. Officers responded to a person shot call in a parking lot of a shopping plaza. When officers arrived on scene they located two males suffering from gunshot wounds. One male was deceased on scene while the other male was transported to a local hospital where he died from his injuries.</span></p>\r\n<p style=\"margin-left:0px;\"><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: inherit;font-family: inherit;\"> Homicide detectives are currently investigating, and the Crime Scene Unit is processing the scene.  Detectives are still working on the timeline of events that led up to the homicide.  The name of both parties is being withheld until next of kin is notified. </span></p>\r\n<p style=\"margin-left:0px;\"><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: inherit;font-family: Roboto, sans-serif;\"> If anyone has any information to share in this case, please contact GCPD detectives at 770-513-5300.  To remain anonymous, tipsters should contact Crime Stoppers at 404-577-TIPS (8477) or visit</span> <a href=\"https://www.atlantapolicefoundation.org/programs/crime-stoppers/\" target=\"_self\"><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: inherit;font-family: Roboto, sans-serif;\"><strong><ins>www.stopcrimeATL.com</ins></strong></span></a><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: inherit;font-family: Roboto, sans-serif;\">.  Crime Stoppers tipsters can receive a cash reward for information leading to an arrest and indictment in this case. </span></p>\r\n<p style=\"margin-left:0px;\"><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: inherit;font-family: inherit;\">Case Number: 22004135</span><br>&nbsp;</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/articles/Norcross.jpg','public','2022-01-28 16:28:16','','','','',513217,0,'2022-01-28 16:33:59','2022-01-28 16:33:59'),(20,491650,490692,504429,'aaad','ccccca','baada','https://bbpimagesandvideos.s3.amazonaws.com/articles/istockphoto-165615148-612x612-e17ef08d430e98cb727619159e761b76.jpg','public','2022-02-01 12:57:08','','0','','',504429,0,'2022-02-01 07:29:09','2023-06-27 07:26:39'),(21,491167,490209,503946,'ARTICLE TESTING 2 TEST','ARTICLE TESTING 2  2 TEST','<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</span>   2 TEST</p>\r\n<p style=\"text-align:left;\"></p>\r\n<img src=\"https://www.google.com/url?sa=i&url=https%3A%2F%2Funsplash.com%2Fs%2Fphotos%2Fpolice-officer&psig=AOvVaw1WBgCZbukkWzE-lKS79FN9&ust=1644059436892000&source=images&cd=vfe&ved=0CAgQjRxqFwoTCKCczen05fUCFQAAAAAdAAAAABAD\" alt=\"undefined\" style=\"height: auto;width: auto\"/>\r\n<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</span>   2 TEST</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/articles/Stevens%20Point%20Police%20Dept-cb9ccc89f214eec619946c77b67e874c.jpg','public','2022-02-04 10:16:45','','','','',503946,0,'2022-02-04 11:11:44','2022-02-04 11:14:03'),(22,491650,490692,504429,'ITTSTAR EDIT','ITTSTAR DESC EDIT','<p>ITTSTAR DESCRIPTIONSSSSSSSSSS EDIT</p>\r\n<p></p>\r\n<p></p>\r\n<img src=\"data:image/jpeg;base64,[encoded data, 10808 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/>\r\n<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.</span>&nbsp;</p>\r\n<p></p>\r\n<img src=\"data:image/jpeg;base64,[encoded data, 7800 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/>\r\n<p><span style=\"color: rgba(0,0,0,0.87);background-color: rgb(255,255,255);font-size: medium;font-family: -apple-system, BlinkMacSystemFont, \"Segoe UI\", Roboto, Oxygen, Ubuntu, Cantarell, \"Fira Sans\", \"Droid Sans\", \"Helvetica Neue\", sans-serif;\"><strong>Lorem Ipsum</strong></span> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.</span>  <span style=\"color: rgba(0,0,0,0.87);background-color: rgb(255,255,255);font-size: medium;font-family: -apple-system, BlinkMacSystemFont, \"Segoe UI\", Roboto, Oxygen, Ubuntu, Cantarell, \"Fira Sans\", \"Droid Sans\", \"Helvetica Neue\", sans-serif;\"><strong>Lorem Ipsum</strong></span> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.</span>&nbsp;&nbsp;</p>\r\n',NULL,'public','2022-02-04 10:16:45','','','','',504429,0,'2022-02-04 11:12:09','2022-02-04 11:13:06'),(25,499779,498821,512558,'testing the  article','sub','<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\r\n<p></p>\r\n<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\r\n<p></p>\r\n<p></p>\r\n<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\r\n<p></p>\r\n<p></p>\r\n<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/articles/3-3273cc50735bd03d5e4176e983022bc4.PNG','public','2022-07-20 00:28:15','','0','','',512558,0,'2022-07-20 11:36:35','2023-06-27 07:26:39'),(30,528190,527232,540969,'Report Type: Victim','Offense Name: Aggravated Assualt - Offense Name: Attempt to murder/rape/rob with a deadly weapon resulting in serious bodily injury','aswerfg','https://bbpimagesandvideos.s3.amazonaws.com/download2-5a5334e75486174a6728ac4f773590d4.jpg','public','2023-05-05 10:49:34','','0','','',540969,0,'2023-05-05 10:56:58','2023-06-27 07:26:40'),(32,528190,527232,540969,'Report Type: Victim','Offense Name: Aggravated Assualt - Offense Name: Attempt to murder/rape/rob with a deadly weapon resulting in serious bodily injury','aswerfg','https://bbpimagesandvideos.s3.amazonaws.com/a7-d35d9abdb7d60ed3bfb1fd205823a7da.jpg','public','2023-05-05 11:02:58','','0','','',540969,0,'2023-05-05 11:06:19','2023-06-27 07:26:41'),(33,528190,527232,540969,'Report Type: Tip','Offense Name: Aggravated Stalking - Offense Name: Violate court order by contacting person without consent to harass or intimidate','Data engineering refers to the building of systems to enable the collection and usage of data. This data is usually used to enable subsequent analysis and data science; which often involves machine learning.','https://bbpimagesandvideos.s3.amazonaws.com/a5-8090d2ef5f9e23b6292c513586e470f1.jpg','public','2023-05-05 11:02:58','','0','','',540969,0,'2023-05-05 11:18:55','2023-06-27 07:26:41'),(34,528190,527232,540969,'Report Type: Witness','Offense Name: Aggravated Stalking - Offense Name: Violate court order by contacting person without consent to harass or intimidate','asdasdasdasdasdadasdasdasdasdasdas','https://bbpimagesandvideos.s3.amazonaws.com/test-85d7aec443264885c99ce23606554863.jpeg','public','2023-05-08 10:18:15','','0','','',540969,0,'2023-05-08 10:55:25','2023-06-27 07:26:42'),(35,528190,527232,540969,'Report Type: Witness','Offense Name: Aggravated Stalking - Offense Name: Violate court order by contacting person without consent to harass or intimidate','asdasdasdasdasdadasdasdasdasdasdas','https://bbpimagesandvideos.s3.amazonaws.com/Norcross-0aee8f1526991103a5e52cf4cd82eb3c.jpg','public','2023-05-08 10:55:27','','0','','',540969,0,'2023-05-08 10:56:45','2023-06-27 07:26:42'),(36,528190,527232,540969,'Report Type: Witness','Offense Name: Aggravated Assualt','asdaadsadadasdasasdasdasdasdasadsdasdas','https://bbpimagesandvideos.s3.amazonaws.com/Norcross-3fe313c74a0f46c6b10da3a5b6be1472.jpg','public','2023-05-08 10:55:27','','0','','',540969,0,'2023-05-08 12:12:33','2023-06-27 07:26:43'),(37,528190,527232,540969,'Report Type: Witness','Offense Name: Aggravated Assualt','asdaadsadadasdasasdasdasdasdasadsdasdasaaaaaaaaa','https://bbpimagesandvideos.s3.amazonaws.com/test%20%282%29-43d22c8e3ca0e7d56d41ee934d0d5859.jpeg','public','2023-05-08 10:55:27','','0','yes','21',540969,0,'2023-05-08 13:39:44','2023-06-27 07:26:44'),(38,500438,499480,513217,'Credit Card Scam','Credit Card Scam in the Norcross Area','Credit card fraud occurred on my son\'s account','https://bbpimagesandvideos.s3.amazonaws.com/1-a89512a630f89e90711b6ceccd33ea5c.png','public','2023-05-08 14:17:54','','0','','',513217,0,'2023-05-08 14:20:20','2023-06-27 07:26:44'),(39,500438,499480,513217,'ENTERING AUTO TURNS INTO ARMED ROBBERY','Offense Name: Robbery','Gwinnett County Robbery Detectives are asking the public’s help in identifying a robbery suspect. \r\n\r\nOn May 9, the victim was inside McKendree United Methodist Church at 1570 Lawrenceville Suwanee Road when she noticed someone inside her vehicle in the parking lot.  The victim confronted the suspect, and the suspect fled the scene, leaving his cell phone inside the victim’s car. \r\n\r\nShortly after leaving, the suspect returned and demanded his cell phone back.  The victim stated she was waiting for the police when the suspect pulled a gun and pointed it at her.  He then proceeded to break out the window of the victim’s car and retrieve his cell phone. \r\n\r\nThe suspect is described as a black male, 19-20 years old, approximately 6 feet tall, weighing 180 lbs. and wearing a white t-shirt and blue jeans.  He fled in a gray or silver Jeep Liberty driven by another male.  The vehicle had distinctive decals on the back windshield that read “Cars $500 Down www.GreatCityCars.com (614) 522-6500.”\r\n','https://bbpimagesandvideos.s3.amazonaws.com/lville-guy_p3-9c5ef29791f4f9136f5e181351511a0c.jpg','public','2023-05-19 13:42:46','','5900','','',513217,0,'2023-05-19 14:04:07','2023-08-18 15:20:34'),(40,528190,527232,540969,'adasdas','asdasdas','<p>adasdadasdasd</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/articles/policeforce-old%20%281%29-be8e6433b20e639cb5c51d6299ec6a88.png','public','2023-05-22 10:45:47','','0','','',540969,0,'2023-05-22 10:47:51','2023-06-27 07:26:46'),(41,528190,527232,540969,'Report Type: Victim','Offense Name: Vehicle Impound','A man travels in time from the year 2027 to relive his school years and to correct a bad decision.','https://bbpimagesandvideos.s3.amazonaws.com/test%20%282%29-fe2b0963562e39d9e50f478a9ac7d991.jpeg','public','2023-06-02 00:59:19','','0','','14500',540969,0,'2023-06-02 07:48:51','2023-06-28 09:51:16'),(42,528190,527232,540969,'Report Type: a','Offense Name: Arson','mmmmmmmmmmmmmmmm','https://bbpimagesandvideos.s3.amazonaws.com/Norcross-f47a948514b2190d4bd36476b0fcd0ee.jpg','public','2023-06-02 10:04:51','','0','','',540969,0,'2023-06-02 10:24:30','2023-06-27 07:26:47'),(43,528190,527232,540969,'Report Type: Victim','Offense Name: Aggravated Stalking','Donate for food for speedy recovery for poor leprosy patients in hospitals and care homes. You can contribute for food for leprosy patients recovering in our 14 hospitals. Urgent Hep. Immediate help. Support Now. Types: Specialised leprosy care, 149 years of excellence.','https://bbpimagesandvideos.s3.amazonaws.com/Weed-a084235917d3c63cce4fead27a245b67-c29dd68fedcd4844d5de32fbe18e2e87.jpg','public','2023-06-02 10:46:10','','0','','',540969,0,'2023-06-02 10:52:18','2023-06-27 07:26:48'),(44,528190,527232,540969,'Report Type: Witness','Offense Name: Child Molestation','A scary scene at a traveling carnival in India was captured on video on Sept. 4. In the clip verified by NBC News, a \"drop tower\" — the classic carnival ride that spins passengers around while moving up and down along a pole — malfunctions and crashes to the ground.','https://bbpimagesandvideos.s3.amazonaws.com/Norcross-28f19781e84c10788f42573463011eba.jpg','public','2023-06-05 11:01:39','','3677','','',540969,0,'2023-06-05 11:24:02','2024-01-19 11:08:05'),(45,528190,527232,540969,'Report Type: Witness','Offense Name: Child Molestation','A scary scene at a traveling carnival in India was captured on video on Sept. 4. In the clip verified by NBC News, a \"drop tower\" — the classic carnival ride that spins passengers around while moving up and down along a pole — malfunctions and crashes to the ground.','https://bbpimagesandvideos.s3.amazonaws.com/Norcross-28f19781e84c10788f42573463011eba.jpg','public','2023-06-13 10:39:10','','0','','',540969,0,'2023-06-13 10:39:32','2023-06-27 07:26:49'),(46,528190,527232,540969,'Report Type: Witness','Offense Name: Aggravated Stalking','asdasdasdasdasdadasdasdasdasdasdas','https://bbpimagesandvideos.s3.amazonaws.com/Norcross-0aee8f1526991103a5e52cf4cd82eb3c.jpg','public','2023-06-27 07:22:32','','','','',540969,0,'2023-06-27 07:23:04','2023-06-27 07:23:04'),(48,528190,527232,540969,'avengers end game','testing the avenger end game','<p>sdasdasdasda</p>\r\n','null','public','2023-06-27 07:44:36','no','','','',540969,0,'2023-06-27 07:47:25','2023-06-27 07:47:25'),(49,528190,527232,540969,'Report Type: Victim','Offense Name: Aggravated Assualt','aswerfg','https://bbpimagesandvideos.s3.amazonaws.com/download2-5a5334e75486174a6728ac4f773590d4.jpg','public','2023-06-27 07:44:36','yes','','','',540969,0,'2023-06-27 07:50:26','2023-06-27 07:50:26'),(50,528190,527232,540969,'Report Type: Witness','Offense Name: Aggravated Stalking','asdasdasdasdasdadasdasdasdasdasdas','https://bbpimagesandvideos.s3.amazonaws.com/Norcross-0aee8f1526991103a5e52cf4cd82eb3c.jpg','public','2023-06-27 11:25:31','yes','','','',540969,0,'2023-06-27 11:40:26','2023-06-27 11:40:26'),(51,528190,527232,540969,'Report Type: Witness','Offense Name: Cruelty to Children','abcccccccccabcccccccccabcccccccccabcccccccccabcccccccccabcccccccccabcccccccccabcccccccccabccccccccc','https://bbpimagesandvideos.s3.amazonaws.com/a1-5a2ef945f2055fb8e4ea66feffd5c75b.jpg','public','2023-06-27 13:44:25','yes','5800','','',540969,0,'2023-06-27 13:57:00','2023-07-05 13:29:33'),(52,528190,527232,540969,'Report Type: Victim','Offense Name: Chop Shop','asdasdasasadasdasdasdasdasd','https://bbpimagesandvideos.s3.amazonaws.com/test%20%282%29-5200c81eaf3cfa24ebecaf9013039a80.jpeg','public','2023-06-30 01:17:41','yes','9667','','10000',540969,0,'2023-06-30 05:58:21','2023-07-05 12:45:17'),(53,528190,527232,540969,'Report Type: Victim','Offense Name: Cruelty to Children','asdasdasdaasd','https://bbpimagesandvideos.s3.amazonaws.com/tiger-f1d3979ad3a79fda601d1614f86ef16d.jpg','public','2023-06-30 06:54:40','yes','','','',540969,0,'2023-06-30 07:04:41','2023-06-30 07:04:41'),(55,528190,527232,540969,'Report Type: Victim Iron man avenger','Offense Name: Aggravated Assualt','asdasdasdasdsdasdasdasdasd','https://bbpimagesandvideos.s3.amazonaws.com/tiger-1f0cd7f8c288220c575e39569da9a342.jpg','public','2023-06-30 07:26:56','yes','','','',540969,0,'2023-06-30 07:27:53','2023-06-30 07:27:53'),(57,528190,527232,540969,'welcome 11 aaaaa','demoooaa','welcome to ITTstar 11234aaa','https://bbpimagesandvideos.s3.amazonaws.com/articles/a3-6e5eac1b2387dca467dab6c90fdeab8c.jpg','','','no','','','',540969,0,'2023-06-30 07:34:49','2023-06-30 07:34:51'),(58,528190,527232,540969,'Report Type: Victim captain america','Offense Name: Aggravated Assualt','asdasdasdasdsdasdasdasdasd','https://bbpimagesandvideos.s3.amazonaws.com/tiger-1f0cd7f8c288220c575e39569da9a342.jpg','public','2023-06-30 07:36:55','yes','24301','','',540969,0,'2023-06-30 07:37:38','2023-06-30 13:10:39'),(59,528190,527232,540969,'Report Type: Witness new test artivle','Offense Name: Child Molestation','asdasdasdsaasdasd','https://bbpimagesandvideos.s3.amazonaws.com/nature-f06497d81fbb40f3d43546728984a458.jpg','public','2023-06-30 09:29:19','yes','6500','','20000',540969,0,'2023-06-30 09:30:38','2023-06-30 10:30:07'),(60,528190,527232,540969,'Report Type: Witness lastest testing ','Offense Name: Aggravated Assualt','asdsdadasdsd','https://bbpimagesandvideos.s3.amazonaws.com/nature-77ecfef54bda6ed5e126a4fcbae1fffd.jpg','public','2023-06-30 12:27:54','yes','5000','','',540969,0,'2023-06-30 12:38:59','2023-06-30 12:39:31'),(61,528190,527232,540969,'Report Type: Witness article test','Offense Name: Aggravated Sexual Battery','adsasdasdsd','https://bbpimagesandvideos.s3.amazonaws.com/tiger-39417f054a9962a90e84a1395af9a558.jpg','public','2023-07-03 06:12:40','yes','35000','','',540969,0,'2023-07-03 07:29:39','2023-07-03 07:58:30'),(62,528190,527232,540969,'Report Type: Witness  edddtest','Offense Name: Aggravated Stalking','xczxzzczczxzxccx','https://bbpimagesandvideos.s3.amazonaws.com/nature-2af5fad701516492251c5ee46f1e7d53.jpg','public','2023-07-03 10:00:35','yes','10000','','',540969,0,'2023-07-03 10:39:21','2023-07-03 10:41:34'),(63,491172,490214,503951,'Report Type: Victim cartlon article','Offense Name: Aggravated Battery','asdasdasdsdsdasd','https://bbpimagesandvideos.s3.amazonaws.com/tiger-ea9e2b96b45fec6b383973c0e749060b.jpg','public','2023-07-06 09:31:21','yes','10000','','',503951,0,'2023-07-06 09:37:25','2023-07-06 09:52:35'),(64,491172,490214,503951,'Report Type: Victim added','Offense Name: Battery','asdfghjk','https://bbpimagesandvideos.s3.amazonaws.com/a4-ed030677b8ed3d31666ab7a358d59b61.jpg','public','2023-07-06 12:13:37','yes','500','','',503951,0,'2023-07-06 13:27:26','2023-07-06 13:40:41'),(65,500438,499480,513217,'Report Type: Victim','Offense Name: Fraudulent Use of Credit Card','Someone stole my credit card information','https://bbpimagesandvideos.s3.amazonaws.com/test%20%282%29-c3bf171162327d3774af313b192eaa62.jpeg','public','2023-07-06 14:29:34','yes','5000','','',513217,0,'2023-07-06 14:36:15','2023-07-25 10:59:36'),(66,528190,527232,540969,'welcome 11 aaaaa','demoooaa','welcome to ITTstar 11234aaa','https://bbpimagesandvideos.s3.amazonaws.com/articles/jh-8e9925fd52e21d4a591a3d1598bb4253.jpg','public','2023-07-17 09:33:58','','','','',540969,540969,'2023-07-17 09:53:27','2023-07-17 10:21:14'),(67,528190,527232,540969,'a','dcv','<p>ddcf</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/articles/a6-a06b1b9e11468a4af58d397597a35982.jpg','public','2023-07-17 10:23:28','no','','','',540969,0,'2023-07-17 10:24:45','2023-07-17 10:24:45'),(68,500438,499480,513217,'Report Type: Victim','Offense Name: Porch Piracy','UPS drop off packages and some one drove up and stole them.','https://bbpimagesandvideos.s3.amazonaws.com/download-bc11378987a398c8570fc8c910ebf7bb.jpeg','public','2023-07-17 11:18:07','yes','400','','',513217,0,'2023-07-17 14:32:57','2023-07-17 14:42:47'),(69,528190,527232,540969,'Report Type: Victim','Offense Name: Aggravated Assualt','asdasdadsaddsdss','https://bbpimagesandvideos.s3.amazonaws.com/tiger-c2d1647eacdbf68ccfd8aa10b04290cf.jpg','public','2023-07-24 12:41:22','yes','','','',540969,0,'2023-07-24 13:12:03','2023-07-24 13:12:03'),(70,500438,499480,513217,'Report Type: Victim','Offense Name: Aggravated Assualt','Doordash driver punched me in the face.','https://bbpimagesandvideos.s3.amazonaws.com/doordash-5a8e890441cefd3140f74afc5da52c0c.jpg','public','2023-07-24 12:41:22','yes','500','','',513217,0,'2023-07-24 14:51:19','2023-07-24 14:53:13'),(72,528190,527232,540969,'Report Type: Witness','Offense Name: Aggravated Assualt','zxczxcxzccxz','https://bbpimagesandvideos.s3.amazonaws.com/tiger-6f173262a48270d86d8060d11ffb7abc.jpg','public','2023-07-26 12:37:46','yes','100','','',540969,0,'2023-07-26 13:44:07','2023-07-29 09:43:54'),(75,528190,527232,540969,'Report Type: Victim','Offense Name: Burglary','asddasdasdasdasdasdsadasdasd','https://bbpimagesandvideos.s3.amazonaws.com/Norcross-ee106b8332292dbaaa5729a46939033d.jpg','public','2023-07-31 07:24:31','yes','1000','','',540969,0,'2023-07-31 09:17:52','2023-07-31 09:35:58'),(76,528190,527232,540969,'Report Type: Victim tyuoihhjkjkjk','Offense Name: Aggravated Assualt','asdadasddasdsd','https://bbpimagesandvideos.s3.amazonaws.com/tiger-2b581dca290bb4e0c0f8bf8bb68fa17e.jpg','public','2023-07-31 09:21:45','yes','1850','','',540969,0,'2023-07-31 09:44:42','2023-07-31 12:11:30'),(77,500438,499480,513217,'Report Type: Witness','Offense Name: Porch Piracy','We have someone following the UP Truck and stealing packages.','https://bbpimagesandvideos.s3.amazonaws.com/doordash-b7ec68db685e2d15f531ef1b778e6ac1.jpg','public','2023-07-31 12:21:14','yes','10000','','',513217,0,'2023-07-31 12:32:51','2023-07-31 14:16:14'),(78,528190,527232,540969,'Report Type: Victim','Offense Name: Burglary','qqqqwwwweeeerrrrttttyyyy','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-65bc39b61f2dee39576290850061e3cb.jpg','public','2023-07-31 12:21:14','yes','697','','',540969,0,'2023-07-31 13:07:05','2023-12-11 09:43:36'),(79,528190,527232,540969,'Report Type: Victim','Offense Name: Child Molestation','asdasdasdadasdasd','https://bbpimagesandvideos.s3.amazonaws.com/tiger-16237eb174ec90d01789f40b6b013c0b.jpg','public','2023-08-02 07:41:45','yes','1050','','',540969,0,'2023-08-02 08:11:35','2023-08-02 08:12:24'),(80,528190,527232,540969,'Report Type: Witness','Offense Name: Aggravated Assualt','dasdadasdasdasdadasddad','https://bbpimagesandvideos.s3.amazonaws.com/articles/test%20%282%29-fb082a7ad356af6596a7139c0541cb8b.jpeg','public','2023-08-02 10:03:25','yes','','','',540969,0,'2023-08-02 11:12:17','2023-08-02 11:12:17'),(81,528190,527232,540969,'adding article','asdsdsadasdsdeesasasdasdassdsdasd','asdasdsdasdasdasdasd','https://bbpimagesandvideos.s3.amazonaws.com/20f3ebeec673f6f273a50d56f231cf8dtiger.jpg','public','2023-08-02 11:38:15','yes','','','',540969,0,'2023-08-02 12:24:05','2023-08-03 10:30:51'),(82,528190,527232,540969,'welcome 11 aaaaa','demoooaa','welcome to ITTstar 11234aaa','https://bbpimagesandvideos.s3.amazonaws.com/articles/a4-e3ff1db318c50b0f6e6b6ae0efe0d6f1.jpg','','','no','','','',540969,0,'2023-08-03 09:07:42','2023-08-03 09:07:44'),(83,528190,527232,540969,'welcome 11 aaaaa','demoooaa','welcome to ITTstar 11234aaa','https://bbpimagesandvideos.s3.amazonaws.com/articles/a4-5c8182c3c327dcf9d624d49287907d05.jpg','','','no','','','',540969,0,'2023-08-03 09:08:18','2023-08-03 09:08:20'),(84,528190,527232,540969,'welcome 11 aaaaa','demoooaa','welcome to ITTstar 11234aaa','https://bbpimagesandvideos.s3.amazonaws.com/articles/a4-13ae14784206e4d16cfc80c7915a0c01.jpg','','','no','','','',540969,0,'2023-08-03 09:08:37','2023-08-03 09:08:38'),(86,528190,527232,540969,'testing artilce','asdasdasdadad','asddasdasdasdasdasdasdasdasdasdasdasd','https://bbpimagesandvideos.s3.amazonaws.com/117cc1cbb55cd748a5f0a65d641d3455nature.jpg','public','2023-08-03 14:30:03','yes','','','',540969,0,'2023-08-03 14:30:11','2023-08-03 14:30:11'),(87,528190,527232,540969,'Report Type: Victim','Offense Name: Aggravated Assualt','adasdasdassdaadasdsa asdasdsadasddadasd','https://bbpimagesandvideos.s3.amazonaws.com/tiger-586f379f713350d5e9169fbaabfedcb5.jpg','public','2023-08-03 14:34:06','yes','','','',540969,0,'2023-08-03 14:45:34','2023-08-03 14:45:34'),(88,528190,527232,540969,'eeeee my new article from whisteblower','asdasdasdasda','sdfsdfsdf','https://bbpimagesandvideos.s3.amazonaws.com/10d6a40c0511f2e1c7869c554b6ee86cdownload.jfif','public','2023-08-04 09:29:17','yes','1000','','',540969,0,'2023-08-04 09:50:49','2023-08-04 11:14:09'),(89,528190,527232,540969,'Report Type: Witness','Offense Name: Aggravated Assualt','asdaaasdadassdsadadasdasdasd','https://bbpimagesandvideos.s3.amazonaws.com/tiger-a0eefd28972276fbf709b8d3c56ea7ea.jpg','public','2023-08-04 10:41:25','yes','9900','','',540969,0,'2023-08-04 11:44:39','2023-08-18 14:53:36'),(90,528190,527232,540969,'testing artilce','sdfg','asddasdasdasdasdasdasdasdasdasdasdasd','https://bbpimagesandvideos.s3.amazonaws.com/117cc1cbb55cd748a5f0a65d641d3455nature.jpg','public','2023-08-09 06:13:51','yes','','','',540969,0,'2023-08-09 07:33:10','2023-08-09 07:33:10'),(92,528190,527232,540969,'testing artilce','new article testin glinking of article','asddasdasdasdasdasdasdasdasdasdasdasd','https://bbpimagesandvideos.s3.amazonaws.com/117cc1cbb55cd748a5f0a65d641d3455nature.jpg','public','2023-08-09 23:06:27','yes','','','',540969,0,'2023-08-10 09:03:35','2023-08-10 09:03:35'),(93,528190,527232,540969,'Report Type: Victim','Offense Name: Aggravated Sexual Battery','asdsdaaasd','https://bbpimagesandvideos.s3.amazonaws.com/forest-15c35eaa7f7581c7861c6ab14a1fab8b.jpg','public','2023-08-09 23:06:27','yes','1500','','',540969,0,'2023-08-10 09:36:06','2023-08-10 10:34:29'),(94,528190,527232,540969,'testing the donation','testt the whistleblower testing donation','asdasdasdasdasdasdasdasdasdasdasds','https://bbpimagesandvideos.s3.amazonaws.com/eea7fca78cab18bc8931f2bb6d0a0699nature.jpg','public','2023-08-09 23:06:27','yes','20150','','',540969,0,'2023-08-10 09:50:07','2023-08-18 14:52:37'),(95,528190,527232,540969,'testing the donation and tips','my article for whistle blower','asdasdasdasdasdasdasdasdasdasdasdasdasdasdasd','https://bbpimagesandvideos.s3.amazonaws.com/1622c6e9b637e5c7784a087661dfdfc6flower1.jpg','public','2023-08-11 09:55:01','yes','13000','','',540969,0,'2023-08-11 11:24:56','2023-08-16 13:47:17'),(98,528190,527232,540969,'teesting the payment of whistleblower','test  ererea','asdadasdasdasdasdasdasdasdasdas','https://bbpimagesandvideos.s3.amazonaws.com/2919bdb32d55accf0b1038189d8cbfd9tiger.jpg','public','2023-08-17 00:46:58','yes','200','','',540969,0,'2023-08-17 06:23:43','2023-08-17 06:24:08'),(99,528190,527232,540969,'Report Type: Victim','Offense Name: Aggravated Stalking','asdasdasdasd','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-ff05262f1068ac560f25be38a8edfcf9.jpg','public','2023-08-17 07:01:07','yes','3000','','',540969,0,'2023-08-17 07:01:13','2023-08-17 07:07:52'),(100,500438,499480,513217,'ARTICLE TESTING','asdfghj','assssssssssss','https://bbpimagesandvideos.s3.amazonaws.com/a8-30801510dc27aedd3bdd2e7119e900a0.jpg','public','2023-08-17 09:59:56','yes','7500','','',513217,0,'2023-08-17 10:05:43','2023-08-17 10:06:54'),(101,500438,499480,513217,'WELCOME 123','asdfgh','aaaaaaaaaaaaaaaa','https://bbpimagesandvideos.s3.amazonaws.com/8d7946767e643c947efdbcd7e9ac8a1ea5.jpg','public','2023-08-17 09:59:56','yes','170','','',513217,0,'2023-08-17 10:18:53','2023-08-17 10:20:16'),(102,500438,499480,513217,'ARTICLE DEMO','Offense Name: Child Molestation','aaaaaaaaaaaaaaaaaaaa','https://bbpimagesandvideos.s3.amazonaws.com/2-0dc8fe917f4593b97e7e94a2ce8dcb6f.jpg','public','2023-08-17 09:59:56','yes','700','','',513217,0,'2023-08-17 10:40:15','2023-08-17 10:42:03'),(103,500438,499480,513217,'MANI ARTICLE','asdfghjmk','aaaaaaaaaaaa','https://bbpimagesandvideos.s3.amazonaws.com/59e5704342536e2804091adecc7a80c1a8.jpg','public','2023-08-17 10:47:47','yes','9','','',513217,0,'2023-08-17 10:50:07','2023-08-17 11:51:58'),(104,500438,499480,513217,'aaaaaaaaaaa MANI','qwedfgh','aaaaaaaaaaaaaaaaaa','https://bbpimagesandvideos.s3.amazonaws.com/78cbca1b79398c08087dda01c89843e4a8.jpg','public','2023-08-17 11:09:48','yes','55','','',513217,0,'2023-08-17 11:58:30','2023-08-17 14:28:49'),(105,528190,527232,540969,'CRIME- 354','Offense Name: Battery','uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu','https://bbpimagesandvideos.s3.amazonaws.com/a4-f709d75ae33640c2bd59f1064b138e53.jpg','public','2023-08-17 11:09:48','yes','95','','',540969,0,'2023-08-17 12:17:03','2023-08-17 12:20:19'),(106,528190,527232,540969,'Report Type: Victim','Offense Name: Cruelty to Children','asdasdsdasdasdadasdasdasdasdad','https://bbpimagesandvideos.s3.amazonaws.com/4-af410b1175a01548acb6040e46c88b61.avif','public','2023-08-21 04:28:44','yes','100','','',540969,0,'2023-08-21 06:55:17','2023-08-21 06:56:10'),(107,528190,527232,540969,'testing the soft close in whistleblower','easdadsadasad','asdadsdasdadasdadsdadasdad','https://bbpimagesandvideos.s3.amazonaws.com/0d82e517681056c65dfe384c396c15683.avif','public','2023-08-21 04:28:44','yes','300','','',540969,0,'2023-08-21 09:25:06','2024-01-04 13:23:46'),(108,528190,527232,540969,'Report Type: Victim','Offense Name: Aggravated Assualt','dsfsdfsdf','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-598e7cff89807bcc716855b64c1b9f9b.jpg','public','2023-08-21 12:12:22','yes','60','','',540969,0,'2023-08-21 12:13:17','2023-08-21 12:27:25'),(109,528190,527232,540969,'new whitsleblower for softclose','testing article','asdsadasdadasdasdasasasd','https://bbpimagesandvideos.s3.amazonaws.com/56f566577b2a9c9db44448282d1ef2663.avif','public','2023-08-21 12:42:59','yes','992','','',540969,0,'2023-08-21 12:44:03','2023-08-21 13:09:42'),(110,528190,527232,540969,'Closing Test','closing test','Testing close','https://bbpimagesandvideos.s3.amazonaws.com/41beb9387f2958e472d2144938aee505download.jpeg','public','2023-08-22 10:03:10','yes','1000','','',540969,0,'2023-08-22 10:03:37','2023-08-22 12:46:23'),(112,528190,527232,540969,'Slave Narratives from the Federal Writers\' Project.','Offense Name: Aggravated Assualt','asdasdasdsdasdasdasdasdasdasd',' https://bbpimagesandvideos.s3.amazonaws.com/img3-12481f5fb99e2c3e14f65d7b01a5cb95.jpg','public','2023-08-22 10:42:37','yes','17000','','',540969,0,'2023-08-22 12:40:55','2024-01-22 14:31:30'),(113,528190,527232,540969,'Andrew Goodman recounted the painful torture he witnessed.','Offense Name: Cruelty to Children','asdadsdasdasdsadaaasdsds','https://bbpimagesandvideos.s3.amazonaws.com/1-ad9ed426acedde5bc980c17de2451b5a.avif','public','2023-08-22 23:28:30','yes','0','','',540969,0,'2023-08-23 07:56:07','2024-01-22 14:09:00'),(114,528190,527232,540969,' Mary Crane spoke about the slave trade','Report Type: Victim','testing the soft close and submit the donation','https://bbpimagesandvideos.s3.amazonaws.com/77b048f3d044c4c0018fb9a6948d000f2.avif','public','2023-08-22 23:28:30','yes','1000','','',540969,0,'2023-08-23 08:31:54','2024-01-22 14:09:58'),(115,528190,527232,540969,'hese are some of the more than 2,300 first-person accounts','Report Type: Victim','qWW','https://bbpimagesandvideos.s3.amazonaws.com/Justice_GettyImages-1140705087%20%281%29-355f52c4871baaf6e9f967fd8c21c07b-e6ff996b11ddd8747d13787933450533.jpg','public','2023-08-23 11:53:47','yes','12200','','',540969,0,'2023-08-23 12:45:45','2024-01-22 14:09:58'),(118,528190,527232,541165,'Betty Simmons recalled the day she was freed1','Report Type: Victim1','<p>1aaaaaaaaaaaaaaaaaaaaaaaa</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/articles/a6-7039e8c604550e3f5bd5a27fddbc3a24.jpg','public','2023-09-08 09:15:15','','','','',540969,541165,'2023-09-08 09:24:10','2024-02-23 15:23:04'),(131,528279,527341,541177,'First-person accounts of slavery from the 1930\'s spotlight America\'s long history of racism.','Report Type: Victim','sdasdsadadadsds',' https://bbpimagesandvideos.s3.amazonaws.com/img2-7d105d326f1f1b63833b68bfd05924df.jpg','public','2024-01-04 13:16:49','yes','2535','','',541177,0,'2024-01-04 13:38:19','2024-01-22 14:30:35'),(132,500438,499480,513217,'JULIA RENDLEMAN FOR USN&WR','Report Type: Victim','asdfg hghh','https://bbpimagesandvideos.s3.amazonaws.com/284be49b7584719296dd711c74df91a4a2.jpg','public','2024-01-12 17:40:56','yes','500','','',513217,0,'2024-01-12 17:44:02','2024-02-06 11:31:42'),(137,528279,527341,541177,'Very rude and threatening','illtreatment','Very rude and threatening','https://bbpimagesandvideos.s3.amazonaws.com/c93a43e56308cb789897bb6728584984Ads-Sakkas-2.jpg','public','2024-02-14 14:14:19','yes','2212','','',541177,0,'2024-02-14 14:25:13','2024-02-14 14:40:40'),(140,528279,527341,541165,'test','testing','<p>Testing</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/articles/images-f6b29a67142d161c3e5650e340065e95.jpg','public','2024-03-14 13:27:23','no','3','','',541165,0,'2024-03-14 11:27:05','2024-03-14 13:28:18'),(142,491255,490297,541160,'Article ','test Article ','<p style=\"text-align:left;\"><span style=\"font-size: 18px;font-family: Tahoma;\">testing </span></p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/nature-2af5fad701516492251c5ee46f1e7d53.jpg','','','','2','','',541160,541160,'2024-03-14 12:56:04','2024-03-18 11:06:19'),(143,528190,527232,540969,'aaaaaaaaaaaa','bbbbbbbbbbb','<p>ssssssssssssssss</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/articles/images%20%2813%29-99ca18a8cc4fe34a51ce8fe91b5e5725.jpg','public','2024-03-15 11:41:20','','','','',540969,8,'2024-03-15 09:55:35','2024-03-15 11:53:21'),(144,528279,527341,541177,'tesst','testing','<p>testing</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/articles/a4-13ae14784206e4d16cfc80c7915a0c01.jpg','','','no','2','','',541177,0,'2024-03-15 12:05:55','2024-03-18 11:06:19'),(146,528279,527341,541177,'Report Type: Victim','Offense Name: Burglary','creating new article from Crime ','https://bbpimagesandvideos.s3.amazonaws.com/articles/a1a2fefc-27be-4dd4-a41f-f2cc6b198e64-Fees%20%281%29-06a05a00306d451f93ac696a542cafef.jpg','public','2024-03-27 07:00:25','yes','','','',541177,0,'2024-03-27 07:06:37','2024-03-27 07:06:37'),(147,528279,527341,541177,'testing the article for save to daft','reasdas','<p><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 16px;font-family: arial, helvetica, sans-serif;\">Use this calculator to add or subtract time (days, hours, minutes, seconds) from a starting time and date. The result will be the new time and date based on the subtracted or added period of time. To calculate the amount of time (days, hours, minutes, seconds) between times on two different dates, use th</span>&nbsp;</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/articles/healthcare-7263193aa5b2a88cd1521f6710818604.png','','','no','','','',541177,0,'2024-03-27 08:48:08','2024-03-27 08:48:08'),(148,491650,490692,504429,'ITTSTAR TSTING ARTICLE 25-01-2022','RTICLE 25-01-2022','<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\r\n<div style=\"text-align:left;\"><img src=\"https://cdn.pixabay.com/photo/2018/08/14/13/23/ocean-3605547__340.jpg\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\r\n<p></p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/download.jpg','public','2022-01-25 07:59:30','','','','',504429,0,'2022-01-25 09:56:56','2022-01-26 15:19:22'),(149,491650,490692,504429,'DEMO ITTSTAR','DEMO SUB','<p>welcome test here&nbsp;</p>\r\n<img src=\"data:image/jpeg;base64,[encoded data, 7536 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/>\r\n<p>BYEEEEEEEEEEEE</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/Document%20%282%29.jpg','public','2022-01-25 15:56:20','','','','',504429,0,'2022-01-25 15:58:57','2022-01-26 15:19:06'),(150,491650,490692,541016,'welcome 1','aa','<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\r\n<div style=\"text-align:left;\"><img src=\"https://cdn.pixabay.com/photo/2018/08/14/13/23/ocean-3605547__340.jpg\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\r\n<p></p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/Document%20%282%29.jpg','public','2022-01-25 07:59:30','','','','',504429,0,'2022-01-25 09:56:56','2022-01-26 15:19:07'),(151,491650,490692,541014,'welcome 2','bb','<p>welcome test here&nbsp;</p>\r\n<img src=\"data:image/jpeg;base64,[encoded data, 7536 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/>\r\n<p>BYEEEEEEEEEEEE</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/download.jpg','private','2022-01-25 15:56:20','','','','',504429,0,'2022-01-25 15:58:57','2022-01-26 15:19:24'),(152,491650,490692,541014,'welcome 4','dddd','<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\r\n<div style=\"text-align:left;\"><img src=\"https://cdn.pixabay.com/photo/2018/08/14/13/23/ocean-3605547__340.jpg\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\r\n<p></p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/Document%20%282%29.jpg','public','2022-01-25 07:59:30','','0','','',504429,0,'2022-01-25 09:56:56','2023-06-27 07:26:37'),(153,491650,490692,541016,'welcome 5','eeee','<p>welcome test here&nbsp;</p>\r\n<img src=\"data:image/jpeg;base64,[encoded data, 7536 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/>\r\n<p>BYEEEEEEEEEEEE</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/download.jpg','public','2022-01-25 15:56:20','','','','',504429,0,'2022-01-25 15:58:57','2022-01-26 15:19:25'),(154,491650,490692,541016,'welcome 8','ggg','<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\r\n<div style=\"text-align:left;\"><img src=\"https://cdn.pixabay.com/photo/2018/08/14/13/23/ocean-3605547__340.jpg\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\r\n<p></p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/policeforce-old.png','private','2022-01-25 07:59:30','','0','','',504429,0,'2022-01-25 09:56:56','2023-06-27 07:26:38'),(155,491650,490692,504429,'welcome 8','hhh','<p>welcome test here&nbsp;</p>\r\n<img src=\"data:image/jpeg;base64,[encoded data, 7536 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/>\r\n<p>BYEEEEEEEEEEEE</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/policeforce-old.png','public','2022-01-25 15:56:20','','','','',504429,0,'2022-01-25 15:58:57','2022-01-26 15:19:36'),(156,500438,499480,513217,'Homicide Investigation','Homicide Investigation  on Jimmy Carter Blvd','<p style=\"text-align:start;\"><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: inherit;font-family: inherit;\">(Norcross, GA) Gwinnett Police Detectives are investigating a homicide that occurred on Jimmy Carter Blvd around 12:30 am. Officers responded to a person shot call in a parking lot of a shopping plaza. When officers arrived on scene they located two males suffering from gunshot wounds. One male was deceased on scene while the other male was transported to a local hospital where he died from his injuries.</span></p>\r\n<p style=\"margin-left:0px;\"><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: inherit;font-family: inherit;\"> Homicide detectives are currently investigating, and the Crime Scene Unit is processing the scene.  Detectives are still working on the timeline of events that led up to the homicide.  The name of both parties is being withheld until next of kin is notified. </span></p>\r\n<p style=\"margin-left:0px;\"><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: inherit;font-family: Roboto, sans-serif;\"> If anyone has any information to share in this case, please contact GCPD detectives at 770-513-5300.  To remain anonymous, tipsters should contact Crime Stoppers at 404-577-TIPS (8477) or visit</span> <a href=\"https://www.atlantapolicefoundation.org/programs/crime-stoppers/\" target=\"_self\"><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: inherit;font-family: Roboto, sans-serif;\"><strong><ins>www.stopcrimeATL.com</ins></strong></span></a><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: inherit;font-family: Roboto, sans-serif;\">.  Crime Stoppers tipsters can receive a cash reward for information leading to an arrest and indictment in this case. </span></p>\r\n<p style=\"margin-left:0px;\"><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: inherit;font-family: inherit;\">Case Number: 22004135</span><br>&nbsp;</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/articles/Norcross.jpg','public','2022-01-28 16:28:16','','','','',513217,0,'2022-01-28 16:33:59','2022-01-28 16:33:59'),(157,491650,490692,504429,'aaad','ccccca','baada','https://bbpimagesandvideos.s3.amazonaws.com/articles/istockphoto-165615148-612x612-e17ef08d430e98cb727619159e761b76.jpg','public','2022-02-01 12:57:08','','0','','',504429,0,'2022-02-01 07:29:09','2023-06-27 07:26:39'),(158,528279,527341,541177,'Report Type: Victim','Offense Name: Aggravated Assualt','testinggdada','https://bbpimagesandvideos.s3.amazonaws.com/healthcare%20%282%29-e3ca19559c7884c1b94aacce684d335f.png','public','2024-04-12 10:21:23','yes','75','','',541177,0,'2024-04-12 10:44:59','2024-04-12 10:52:59'),(159,528279,527341,541177,'Report Type: Witness','Offense Name: Aggravated Assualt','In publishing and graphic design, Lorem ipsum is a placeholder text commonly used to demonstrate the visual form of a document or a typeface without relying on meaningful content. Lorem ipsum may be us','https://bbpimagesandvideos.s3.amazonaws.com/articles/a1a2fefc-27be-4dd4-a41f-f2cc6b198e64-Fees%20%281%29-23cb63f7b42776b6efdbe1e10c88138d.jpg','public','2024-04-12 10:21:23','yes','1785','','',541177,0,'2024-04-12 11:18:53','2024-08-26 11:28:37'),(160,528190,527232,541165,'Test Add','test','<p>test&nbsp;</p>\r\n','https://bbpimagesandvideos.s3.amazonaws.com/articles/images-874ae7b6c371a328466a5b1a6d461b1a.jpg','public','2024-04-16 22:26:35','','','','',541165,541165,'2024-04-17 11:04:08','2024-04-17 11:07:12'),(161,500438,499480,513217,'Report Type: Victim','Offense Name: Damage to property','A recent uptick of car break-ins in the Midtown East area is raising concerns for many Midtown students who use street parking in the neighborhood for school. \r\n\r\n“We definitely do not have enough parking, and it is a shame that students and teachers are pushed out into an area where we can’t patrol,” Midtown Principal Dr. Betsy Bockman said. “The officers do a great job patrolling the student lots, but that cannot cover all students.”\r\n\r\nVehicle theft accounted for 48 percent of all crimes in the Midtown Improvement District in 2022 with over 258 cases, according to a report from the Atlanta Police Department. Midtown’s Resource Officer Derrick Hammond has been working at the school for eight years and finds the recent uptick disconcerting.\r\n\r\n“In all my time working here, I’ve never seen anything like this on surrounding streets,” Hammond said. “The students that have to park on the streets need to be vigilant and aware of their surroundings.”\r\n\r\nOn Aug. 15, at around 1 a.m., about 60 cars were broken into on Vedado Way and Charles Allen Drive, which connect to the school. Midtown Neighbors Association safety chairperson Paul Luppino believes these events align with a national trend of property theft and smash-and-grab car theft.\r\n\r\n“It is happening everywhere and we saw a big national increase after Covid in 2021,” Luppino said. “As a neighborhood, I feel like we’ve recently experienced larger events where a large strand or whole street of cars is affected, rather than just one or two at a certain time.”\r\n\r\nSince the start of the year, school officers have maintained a system of patrol and surveillance through cameras and physical watch. JROTC teacher Major Veleka Douglas is on duty three times a day around the school.\r\n\r\n“Many teachers and staff have duty at different points so that we can keep eyes on what is going on at all times,” Douglas said. “Safety is a pre-emptive thing, and we all have to help and talk about what we need to do to be diligent.”\r\n\r\nDespite these efforts, some students are still concerned about the safety of their cars at school, especially on the adjacent streets. Junior Leia Beinenson parks in the lower 10th Street lot and wants to see increased safety mechanisms. \r\n\r\n“We need better security at this school to make sure unwanted people cannot come into the lots,”Beinenson said. “Since the school is located in the peak part of the city, hundreds of people pass by the school daily, and without proper security for the cars and students at the school, it is unpredictable what will happen.”\r\n\r\nPublic safety nonprofit Midtown Blue has worked to patrol the area, instituting a program where there are 750 hours of combined patrols each week in Midtown, including surveillance from off-duty APD and public safety officers.\r\n\r\n“Our public safety program is pretty bolstered, where we have a couple of APD officers that patrol on top of what the zone officers do,” Midtown Blue public safety and operations director, said. “We want to go above and beyond to put more people in our area and try to make it a little safer, so there’s at least two APS officers in the community 24/7.”\r\n\r\nDue to these issues, APD launched the “Clear Car Campaign” in 2009 to encourage people to remove all valuables from their cars. The MA has continued these efforts in the community. Neville believes that this philosophy will be very impactful on the community.\r\n\r\n“The number one thing we focus on is education,” Neville said. “Residents need to realize that you cannot leave anything in your car for people to see, like phone chargers that allude to other valuables, and especially do not leave a weapon or gun out because those weapons are a massive motive for car break-ins now.”\r\n\r\nJunior Ava Johnson is dual enrolled in classes at Georgia State, which means she only spends the latter half of her day at Midtown. By the time she arrives, she has to park on the Midtown East streets, which has prompted her to engage in more preventive measures.\r\n\r\n“I am very careful to ensure the safety of myself and my car, so I never leave anything in it and leave the door unlocked,” Johnson said. “That way, if anyone tries to break into my car, they will open the door and find nothing, rather than break my window and cost me a lot of money.”\r\n\r\nSenior Jameson Knight also has a late start in her schedule, and she has also been careful about how she leaves her car during the school day.\r\n\r\n“I got a club [device that locks the wheels on a parked car] on my car because I had heard of a lot of break-ins over the summer,” Knight said. “I drive a Kia Soul, which is particularly targeted, so I just did this to know no one could easily take my car.”\r\n\r\nCarlos Cordoba, a resident of Garden Hills Midtown East, has been targeted twice in the past year and said that both times, the perpetrators have not been caught. \r\n\r\n“A few neighbors have cameras, but they are in and out in 10 minutes, so each time they have never gotten caught,” Cordoba said. “The neighbors are going to have to start being more vigilant because I don’t expect the police to be here in 10 minutes.”\r\n\r\nThese close incidents to Midtown are causing some students to reconsider their daily routines.\r\n\r\n“Before this year, Vedado and those other roads were a great place to park in the morning,” Knight said. “Now knowing what has been happening on those streets might make me stop parking there at all.”','https://bbpimagesandvideos.s3.amazonaws.com/IMG_6206.jpg','public','2024-10-07 13:59:25','yes','','','',513217,0,'2024-10-07 14:39:57','2024-10-07 14:39:57'),(162,528345,527421,541536,'Report Type: Victim','Offense Name: Burglary','testing the records','https://bbpimagesandvideos.s3.amazonaws.com/articles/hori4-abeb3f42fea0769520a686c328275e91.jpg','public','2024-11-25 10:56:36','yes','45','','',541536,0,'2024-11-25 05:28:57','2024-11-25 05:31:20'),(163,528190,527232,540969,'Report Type: Business','Offense Name: Aggravated Battery','testing','https://bbpimagesandvideos.s3.amazonaws.com/articles/fullimage-db447f1023be2ba7f8f09cfd2886099b.avif','public','2024-11-27 23:00:11','yes','','','',540969,0,'2024-11-28 11:21:52','2024-11-28 11:21:52'),(164,528345,527421,541536,'Report Type: Victim','Offense Name: Child Molestation','asdasdsa','https://bbpimagesandvideos.s3.amazonaws.com/articles/hori3-c70c8510db36a293b412c5d0f3fa6a93.jpg','public','2024-12-28 10:54:29','yes','10','','',541536,0,'2024-12-28 05:25:40','2025-01-08 11:00:06'),(165,528345,527421,541536,'sai leaked ittstar policy to another company','testing','testing the complaint','https://bbpimagesandvideos.s3.amazonaws.com/image%20%2825%29.png','public','2025-01-07 06:28:17','yes','','','',541536,0,'2025-01-07 10:27:14','2025-01-07 10:27:14'),(166,528349,527435,541555,'Report Type: Victim','Offense Name: Aggravated Assualt','test','https://bbpimagesandvideos.s3.amazonaws.com/articles/image%20%2825%29-60a371c0218e27e8a8566d88a5b08d82.png','public','2025-01-09 10:27:24','yes','10','','',541555,0,'2025-01-09 11:45:57','2025-01-09 11:51:07');

--
-- Table structure for table `agency_event_attendies`
--

CREATE TABLE `agency_event_attendies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eventId` int(100) NOT NULL DEFAULT '0',
  `userId` int(100) NOT NULL DEFAULT '0',
  `officerId` int(100) NOT NULL DEFAULT '0',
  `fullName` varchar(250) DEFAULT NULL,
  `email` varchar(250) DEFAULT NULL,
  `phone` varchar(250) DEFAULT NULL,
  `gender` varchar(250) DEFAULT NULL,
  `address` varchar(250) DEFAULT NULL,
  `city` varchar(250) DEFAULT NULL,
  `state` varchar(250) DEFAULT NULL,
  `zip` int(250) NOT NULL DEFAULT '0',
  `contactInfo` varchar(250) DEFAULT NULL,
  `enrolementdate` varchar(250) DEFAULT NULL,
  `createdat` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `agency_event_attendies`
--

INSERT INTO `agency_event_attendies` VALUES (1,88,0,504429,'PaulHeath','publicsafety@thomas.edu','999-999-9999','M','WELCOME','GA','MA',56004,'PaulHeath,GA,MA,56004,999-999-9999,publicsafety@thomas.edu','','2022-01-25 15:48:09','2022-03-22 13:34:22'),(2,139,0,504430,'a','a@gmail.com','999-999-9999','M','a1','GA','MA',56001,'PaulHeath,GA,MA,56004,999-999-9999,publicsafety@thomas.edu','','2022-01-25 15:48:09','2022-01-26 08:26:54'),(3,11,0,504431,'b','b@gmail.com','999-999-9999','M','a2','GA','MA',56002,'PaulHeath,GA,MA,56004,999-999-9999,publicsafety@thomas.edu','','2022-01-25 15:48:09','2022-03-22 13:34:23'),(5,139,0,504433,'d','d@gmail.com','999-999-9999','M','a4','GA','MA',56004,'PaulHeath,GA,MA,56004,999-999-9999,publicsafety@thomas.edu','','2022-01-25 15:48:09','2022-01-26 08:26:57'),(6,139,0,504434,'e','e@gmail.com','999-999-9999','M','a5','GA','MA',56005,'PaulHeath,GA,MA,56004,999-999-9999,publicsafety@thomas.edu','','2022-01-25 15:48:09','2022-01-26 08:26:58'),(7,139,0,504435,'f','f@gmail.com','999-999-9999','M','a6','GA','MA',56006,'PaulHeath,GA,MA,56004,999-999-9999,publicsafety@thomas.edu','','2022-01-25 15:48:09','2022-01-26 08:26:59'),(8,139,0,504436,'g','g@gmail.com','999-999-9999','M','a7','GA','MA',56007,'PaulHeath,GA,MA,56004,999-999-9999,publicsafety@thomas.edu','','2022-01-25 15:48:09','2022-01-26 08:27:00'),(9,139,0,504437,'h','i@gmail.com','999-999-9999','M','a8','GA','MA',56008,'PaulHeath,GA,MA,56004,999-999-9999,publicsafety@thomas.edu','','2022-01-25 15:48:09','2022-01-26 08:27:01'),(10,139,0,504438,'i','k@gmail.com','999-999-9999','M','a9','GA','MA',56009,'PaulHeath,GA,MA,56004,999-999-9999,publicsafety@thomas.edu','','2022-01-25 15:48:09','2022-01-26 08:27:13'),(11,139,0,504439,'asdf','iz@gmail.com','999-999-9999','M','a811','GA','MA',56008,'PaulHeath,GA,MA,56004,999-999-9999,publicsafety@thomas.edu','','2022-01-25 15:48:09','2022-01-26 08:27:38'),(13,148,503945,0,'Pavitra','pavitra@gmail.com','33','d','sd','xc','dcf',0,NULL,NULL,'2022-01-26 10:00:08','2022-01-26 10:00:08'),(14,141,0,504429,'PaulHeath','publicsafety@thomas.edu','null','null','null','null','null',0,'PaulHeath,null,null,0,null,publicsafety@thomas.edu','','2022-02-01 11:22:40','2022-02-01 11:22:40'),(15,142,0,504429,'PaulHeath','publicsafety@thomas.edu','222-222-2222','m','q2w3e4r5t6','qwert','asdf',1234,'PaulHeath,qwert,asdf,01234,222-222-2222,publicsafety@thomas.edu','','2022-02-01 11:23:01','2022-02-01 11:23:01'),(16,143,0,504429,'PaulHeath','publicsafety@thomas.edu','678-990-8989','m','qwertyuio','wertyu','ertyuio',96536,'PaulHeath,wertyu,ertyuio,96536,678-990-8989,publicsafety@thomas.edu','','2022-02-01 11:23:27','2022-02-01 11:23:27'),(18,9,8,0,'WalterJones','superuser@betterblueperformance.com','877-643-6038','Male',' 11175 Cicero Drive, Suite 100','Alpharetta','Georgia',30022,'WalterJones,Alpharetta,Georgia,30022,877-643-6038,superuser@betterblueperformance.com','','2022-02-04 13:58:17','2022-02-04 13:58:17'),(19,10,0,504429,'PaulHeath','publicsafety@thomas.edu','null','null','null','null','null',0,'PaulHeath,null,null,0,null,publicsafety@thomas.edu','','2022-02-04 14:11:11','2022-02-04 14:11:11'),(20,26,541016,0,'Harish k ','harish@gmail.com','984-802-2338','Male','#27, new down town streeet','arizona','Arizona',12312,'Harish k ,arizona,Arizona,12312,984-802-2338,harish@gmail.com','','2022-03-02 10:18:32','2022-03-02 10:18:32'),(21,72,0,504429,'PaulHeath','publicsafety@thomas.edu','888-888-8888','Male','address','city','Hawaii',23133,'PaulHeath,city,Hawaii,23133,888-888-8888,publicsafety@thomas.edu','','2022-03-17 14:24:43','2022-03-17 14:24:43'),(22,43,0,504429,'PaulHeath','publicsafety@thomas.edu','888-888-8888','Male','address','city','Hawaii',23133,'PaulHeath,city,Hawaii,23133,888-888-8888,publicsafety@thomas.edu','','2022-03-17 14:28:53','2022-03-17 14:28:53'),(23,71,0,504429,'PaulHeath','publicsafety@thomas.edu','888-888-8888','Male','address','city','Hawaii',23133,'PaulHeath,city,Hawaii,23133,888-888-8888,publicsafety@thomas.edu','','2022-03-17 15:52:12','2022-03-17 15:52:12'),(29,78,0,541015,'manojkumar','manoj@gmail.com','984 802-2338','Male',' Banglore','Banglore','California',56221,'manojkumar,Banglore,California,56221,984 802-2338,manoj@gmail.com','','2022-03-18 11:33:05','2022-03-18 11:33:05'),(30,90,0,541023,'IRONMAN','manu@gmail.com','984-802-2338','male','b','a','b',12345,'IRONMAN,a,b,12345,984-802-2338,manu@gmail.com','','2022-03-22 13:42:34','2022-03-22 13:42:34'),(31,90,398,0,'kamalsharma','sharma@gmail.com','985-624-5789','Female','address','city','Arkansas',56234,'kamalsharma,city,Arkansas,56234,985-624-5789,sharma@gmail.com','','2022-03-22 13:45:09','2022-03-22 13:45:09'),(32,100,0,541023,'IRONMAN','manu@gmail.com','984-802-2338','male','adderess','c','v',45124,'IRONMAN,c,v,45124,984-802-2338,manu@gmail.com','','2022-03-23 16:19:34','2022-03-23 16:19:34'),(35,90,0,541014,'amitittstar','amitofficer@gmail.com','8095129206 1','m','a','a','b',45454,'amitittstar,a,b,45454,8095129206 1,amitofficer@gmail.com','','2022-03-23 16:45:01','2022-03-23 16:45:01'),(36,100,0,504429,'PaulHeath','publicsafety@thomas.edu','888-888-8888','Male','address','city','Hawaii',23133,'PaulHeath,city,Hawaii,23133,888-888-8888,publicsafety@thomas.edu','','2022-03-28 14:11:00','2022-03-28 14:11:00'),(37,93,0,365,'LeeJones','wjones07@comcast.net','678-777-7777','Male','111 Main Street','Norcross','Georgia',30092,'LeeJones,Norcross,Georgia,30092,678-777-7777,wjones07@comcast.net','','2022-03-28 15:02:14','2022-03-28 15:02:14'),(38,107,0,504429,'PaulHeath','publicsafety@thomas.edu','888-888-8888','Male','address','city','Hawaii',23133,'PaulHeath,city,Hawaii,23133,888-888-8888,publicsafety@thomas.edu','','2022-04-12 09:25:55','2022-04-12 09:25:55'),(39,109,0,541014,'amitittstar','amitofficer@gmail.com','8095129206 1','dsf','asdfgh','aa','sdf',0,'amitittstar,aa,sdf,0,8095129206 1,amitofficer@gmail.com','','2022-04-15 12:50:58','2022-04-15 12:50:58'),(40,108,0,513378,'KevinRoberts','kevin.roberts@claytoncountyga.gov','770-477-3601','Male',' 7911 North McDonough Street',' Jonesboro','Georgia',30236,'KevinRoberts, Jonesboro,Georgia,30236,770-477-3601,kevin.roberts@claytoncountyga.gov','','2022-04-15 15:08:39','2022-04-15 15:08:39'),(41,108,0,513217,'BillGrogan','bgrogan@norcrosspd.com','770 448-2111','Male','65 Lawrenceville Street NW','Norcross','Georgia',30092,'BillGrogan,Norcross,Georgia,30092,770 448-2111,bgrogan@norcrosspd.com','','2022-04-18 15:52:49','2022-04-18 15:52:49'),(42,111,743,0,'Lee Jones','ptiresumes1@gmail.com','123-456-7890','Male','5425 Peachtree Parkway NW','Peachtree','Georgia',30092,'Lee Jones,Peachtree,Georgia,30092,123-456-7890,ptiresumes1@gmail.com','','2023-08-03 14:19:46','2023-08-03 14:19:46'),(43,115,0,541177,'AlexMartin','karthick.j@ittstar.com','112-233-4442','Female','4089 Iron Works Parkway','Lexington','Delaware',40511,'AlexMartin,Lexington,Delaware,40511,112-233-4442,karthick.j@ittstar.com','','2024-02-14 16:24:54','2024-02-14 16:24:54');

--
-- Table structure for table `agency_job`
--

CREATE TABLE `agency_job` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jobCode` varchar(900) DEFAULT NULL,
  `precintId` int(100) NOT NULL DEFAULT '0',
  `agencyId` int(100) NOT NULL DEFAULT '0',
  `ownerId` varchar(100) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `postingDate` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `zipCode` varchar(100) DEFAULT NULL,
  `maxSubmit` varchar(100) DEFAULT NULL,
  `priority` varchar(100) DEFAULT NULL,
  `stage` int(100) NOT NULL DEFAULT '0',
  `openings` varchar(100) DEFAULT NULL,
  `endDate` varchar(100) DEFAULT NULL,
  `jobType` varchar(100) NOT NULL,
  `education` varchar(100) DEFAULT NULL,
  `submissionDeadline` varchar(100) DEFAULT NULL,
  `description` longtext,
  `yearlySalary` varchar(500) DEFAULT NULL,
  `hourlySalary` varchar(500) DEFAULT NULL,
  `createdBy` int(10) NOT NULL DEFAULT '0',
  `updatedBy` int(10) NOT NULL DEFAULT '0',
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `agency_job`
--

INSERT INTO `agency_job` VALUES (1,'ITT12',490692,491650,'504429','ITTSTAR SE','Active','Fri Apr 22 2022 19:19:00 GMT+0530 (India Standard Time)','GOKAK','IN','591307',NULL,'High',2,'11','','Fulltime','BS/BA','','<p>qqq</p>\n','11111111','1111',504429,0,'2022-04-21 13:50:52','2022-04-21 13:50:52'),(2,'UB123',499480,500438,'513217','NORCROSS SE','Active','Fri Apr 22 2022 19:26:00 GMT+0530 (India Standard Time)','bangalore','IL','56004',NULL,'High',7,'12','','Fulltime','PhD','','<p>adsfghjk</p>\n','12345','12',513217,513217,'2022-04-21 13:56:40','2022-04-21 13:59:34'),(3,'UB123',490692,491650,'504429','NORCROSS SE','Active','Fri Apr 22 2022 19:26:00 GMT+0530 (India Standard Time)','bangalore','IL','56004',NULL,'High',4,'12','','Fulltime','PhD','','<p>adsfghjk</p>\n','12345','12',513217,504429,'2022-04-21 13:56:40','2022-04-22 12:42:59'),(4,'12s31427',490692,491650,'504429','Thomas college testing','Active','Fri Apr 22 2022 17:05:00 GMT+0530 (India Standard Time)','city test','HI','32012',NULL,'High',8,'120','','Fulltime','AS/AA','','<p>thomas college testing in the server&nbsp;</p>\n','12000','120',504429,0,'2022-04-22 11:36:23','2022-04-22 11:36:23'),(5,'1213427',490692,491650,'504429','create job testing ','Active','Mon Apr 25 2022 16:34:00 GMT+0530 (India Standard Time)','banglore','KS','56001',NULL,'High',3,'120','','Fulltime','AS/AA','','<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\n<p></p>\n<ul>\n<li><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, </span></li>\n<li><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">when an unknown printer took a galley of type and scrambled it to make a type specimen book. </span></li>\n<li><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. </span></li>\n<li><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</li>\n<li style=\"text-align:start;\"></li>\n<li style=\"text-align:left;\"><span style=\"color: rgba(0,0,0,0.87);background-color: rgb(255,255,255);font-size: 16px;font-family: Roboto, Helvetica, Arial, sans-serif;\"><strong>Lorem Ipsum</strong></span> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Roboto, Helvetica, Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, </span></li>\n<li style=\"text-align:start;\"></li>\n<li style=\"text-align:left;\"><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Roboto, Helvetica, Arial, sans-serif;\">when an unknown printer took a galley of type and scrambled it to make a type specimen book. </span></li>\n<li style=\"text-align:start;\"></li>\n<li style=\"text-align:left;\"><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Roboto, Helvetica, Arial, sans-serif;\">It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. </span></li>\n<li style=\"text-align:start;\"></li>\n<li style=\"text-align:left;\"><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Roboto, Helvetica, Arial, sans-serif;\">It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;&nbsp;</li>\n</ul>\n','12000','120',504429,0,'2022-04-25 11:06:40','2022-04-25 11:06:40'),(6,'6',499480,500438,'513217','Court Security Officer','Active','Sat May 21 2022 20:37:00 GMT+0530 (India Standard Time)','Duluth','GA','30096',NULL,'High',3,'1','','Parttime','BS/BA','','<p>Onsite Position.</p>\n<p></p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">City of Brookhaven, located in metro Atlanta, is seeking highly qualified applicants for the position of Part-time court security police officer. </span>&nbsp;</p>\n<p><span style=\"font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">The court security police officer will provide service to our Municipal Court and be responsible for prisoner transport</span> Brookhaven\'s Municipal Court hours are currently Monday and Thursday from 1:00 PM until 5:00 PM.&nbsp;&nbsp;</p>\n<p><span style=\"font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Bench Trials are held the third Wednesday of each month 8:30 AM until 1:00 PM. </span>&nbsp;</p>\n<p><span style=\"font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">This position is considered Continuous Part-Time, working up to 25 hours per week. Only Georgia P.O.S.T. certified candidates will be considered for employment at this time. </span>&nbsp;</p>\n<p></p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Essential Job Functions:</span></p>\n<ul>\n<li><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Provides security for Municipal Court Prepares incident and accident reports Arrests and transports criminals Transport inmates to and from Municipal court Performs other duties as assigned </span>&nbsp;</li>\n</ul>\n','52,000.00','25.00',513217,513217,'2022-04-25 15:11:56','2022-05-23 11:08:44'),(7,'12s13577',490692,491650,'504429','TESTING JOB CREATING ','Active','Tue Apr 26 2022 08:21:00 GMT+0530 (India Standard Time)','CITY','GA','38001',NULL,'High',8,'120','','Fulltime','HighSchool','','<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\n<ul>\n<li><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. </span></li>\n<li><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. </span></li>\n<li><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.</span></li>\n<li><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</li>\n</ul>\n','12000','120',504429,0,'2022-04-26 02:53:31','2022-04-26 02:53:31'),(8,'12s13427',490692,491650,'504429','title','Active','Mon May 02 2022 20:37:00 GMT+0530 (India Standard Time)','city','ID','572141',NULL,'High',8,'120','','Fulltime','HighSchool','','<p>Description</p>\n','12547','254',504429,0,'2022-05-02 15:08:00','2022-05-02 15:08:00'),(9,'13s31577',490692,491650,'504429','software engineer','Active','Tue May 03 2022 17:29:00 GMT+0530 (India Standard Time)','city','DE','560010',NULL,'High',6,'1201','','Fulltime','SomeCollege','','<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\n<p></p>\n<ul>\n<li><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">is simply dummy text of the printing and typesetting industry. </span></li>\n<li><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</span></li>\n<li><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\"> It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. </span></li>\n<li><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</li>\n<li style=\"margin-left:1.5em;\"><span style=\"color: rgba(0,0,0,0.87);background-color: rgb(255,255,255);font-size: 16px;font-family: Roboto, Helvetica, Arial, sans-serif;\"><strong>Lorem Ipsum</strong></span> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Roboto, Helvetica, Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. </span></li>\n<li style=\"margin-left:1.5em;\"><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Roboto, Helvetica, Arial, sans-serif;\">Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</span></li>\n<li style=\"margin-left:1.5em;\"><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Roboto, Helvetica, Arial, sans-serif;\">It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. </span></li>\n<li style=\"margin-left:1.5em;\"><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Roboto, Helvetica, Arial, sans-serif;\">it was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</li>\n</ul>\n','12000','120',504429,504429,'2022-05-03 12:01:02','2022-05-26 09:05:30'),(10,'532022',499480,500438,'513217','Police Officer','Active','Tue May 03 2022 11:11:00 GMT-0400 (Eastern Daylight Time)','Norcross','GA','30092',NULL,'High',1,'1','','Fulltime','HighSchool','','<p>&nbsp;<span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">The purpose of this classification is to protect lives, property<br>and rights of the public; enforce statutory law and municipal ordinances,<br>respond to emergency/non-emergency situations, and investigate criminal<br>activity</span>&nbsp;</p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Position may also perform tasks relating to a special function<br>or division as assigned</span>&nbsp;</p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">The omission of specific statements of the duties does not<br>exclude them from the classification if the work is similar, related, or a<br>logical assignment for this classification</span>&nbsp;</p>\n<p style=\"margin-left:0.25in;\">&nbsp;&nbsp;</p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Other duties may be required<br>and assigned</span>&nbsp;</p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Patrols designated areas via motor vehicle, bicycle, all-terrain<br>vehicle, or on foot to detect and deter criminal activity and traffic<br>violations; inspects doors, windows, and premises of residential/commercial<br>buildings/properties to ensure security or to detect suspicious conditions;<br>responds to active alarms at residences, businesses, and industries; checks<br>suspicious vehicles, persons, or situations; investigates and reports public<br>safety issues such as roadway hazards, malfunctioning traffic signals, damaged<br>street signs, or other problems; investigates and reports non-criminal offenses<br>such as non-criminal damage to property for civil reporting purposes; maintains<br>high visibility in the community</span>&nbsp;</p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Enforces all applicable codes, ordinances, laws and regulations<br>(including traffic, criminal and civil) in order to protect life and property,<br>prevent crime, and promote security</span>&nbsp;</p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Responds to calls relayed by dispatchers, including domestic<br>disputes, abuse, assaults, rape, burglaries, thefts, fatalities, abduction,<br>lost/missing persons, search/rescue operations, traffic accidents, property<br>damage, alarms, bomb threats, natural disasters, public service duties,<br>stranded motorists, or other problem situations</span>&nbsp;</p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Prevents/discovers commission of crime; issues citations;<br>pursues fleeing suspects; apprehends, arrests, and processes criminals,<br>fugitives and offenders; conducts searches of suspects or arrestees; develops<br>informants to provide information in criminal investigations</span>&nbsp;</p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Conducts preliminary investigations of complaints or incidents;<br>interviews victims, complainants and witnesses and records statements; secures<br>crime scenes, processes crime scenes for basic evidence, and protects integrity<br>of evidence; gathers information and evidence, and makes photographic records<br>of scenes; places evidence into custodial control; sends evidence to crime<br>laboratory as appropriate, such as blood evidence in DUI cases; prepares<br>detailed reports and sketches</span>&nbsp;</p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Performs rescue functions at accidents, emergencies, and<br>disasters, which may include lifting, dragging or carrying people away from<br>dangerous situations, securing/evacuating people from particular areas,<br>administering CPR or first aid, or extinguishing small fires</span>&nbsp;</p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Enforces vehicle operating laws, parking laws, and DUI laws;<br>conducts field sobriety tests; uses visual observation and radar/laser speed<br>detection units to enforce speed laws</span>&nbsp;</p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Responds to traffic accidents/complaints; investigates<br>collisions/accidents involving fatalities, personal injuries, and hit-and-run<br>drivers; measures accident scenes and makes drawings of accidents; reviews<br>evidence, reconstructs accidents, and makes recommendations; investigates<br>traffic hazards; coordinates removal of debris or other hazards from roadways</span>&nbsp;</p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Provides traffic control, crowd control, police protection, or<br>security escorts for accident scenes, malfunctioning traffic signals, school<br>crossings, funerals, businesses, sporting events, dignitary visits, special<br>events, or other situations as appropriate</span>&nbsp;</p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Transports arrestees, mental patients, members of the general<br>public, or other individuals as required</span>&nbsp;</p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Participates in court activities; responds to court subpoenas;<br>assists in preparing case files and evidence for court presentation; testifies<br>and presents evidence during court</span>&nbsp;</p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Provides assistance or backup support to other officers,<br>emergency medical providers, fire department personnel, state/federal law<br>enforcement agencies, other law enforcement agencies, or other public service<br>agencies; provides emergency response on a twenty-four hour basis as needed</span>&nbsp;</p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Processes various paperwork pertaining to course of duty;<br>reviews reports and documentation completed/submitted by assigned personnel;<br>coordinates delivery of inter-organizational mail to other City departments;<br>serves arrest warrants, search warrants, subpoenas, or other documentation</span>&nbsp;</p>\n<p><span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Symbol;\">·</span> <span style=\"color: rgb(32,33,36);background-color: white;font-size: 10.5pt;font-family: Roboto;\">Performs public service duties; provides general assistance to<br>the public, such as providing directions, changing fire alarm batteries,<br>inspecting properties, assisting stranded motorists, or completing VIN/tag<br>inspections; provides general information pertaining to safety, juvenile<br>problems, civil/criminal matters, legal assistance, ordinances, or other<br>issues; assists visitors with filing police reports or obtaining copies of<br>reports</span>&nbsp;&nbsp;</p>\n','54,752.88','25.00',513217,0,'2022-05-03 15:15:19','2022-05-03 15:15:19'),(11,'sd',490692,491650,'504429','df','Active','Wed May 04 2022 21:33:00 GMT+0530 (India Standard Time)','Bangalore East','GA','560040',NULL,'High',2,'32','','Fulltime','SomeCollege','','<p>sdfghj</p>\n','132','123',504429,0,'2022-05-03 16:03:59','2022-05-23 11:08:44'),(12,'12s31577',490692,491650,'504429','police ','Active','Thu May 12 2022 18:04:00 GMT+0530 (India Standard Time)','city','IN','54002',NULL,'High',0,'120','','Fulltime','HighSchool','','<p>description&nbsp;</p>\n<p></p>\n<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\n<p></p>\n<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\n','12000','120',504429,504429,'2022-05-11 12:38:11','2022-05-11 12:41:32'),(13,'12s31577',490692,491650,'504429','police ','Active','Thu May 12 2022 18:04:00 GMT+0530 (India Standard Time)','city','IN','54002',NULL,'High',11,'120','','Fulltime','HighSchool','','<p>description&nbsp;</p>\n<p></p>\n<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\n<p></p>\n<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans\", Arial, sans-serif;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\n','12000','120',504429,0,'2022-05-11 12:38:49','2022-05-11 12:38:49'),(15,'12s31432',490692,491650,'504429','title','Active','Fri May 13 2022 17:02:00 GMT+0530 (India Standard Time)','city','GA','12045',NULL,'High',11,'10','','Fulltime','BS/BA','','<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\n<p></p>\n<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\n','1200000','120',504429,504429,'2022-05-12 11:38:19','2022-05-12 11:43:46'),(18,'12',490692,491650,'504429','testing','In-active','Fri May 20 2022 18:05:00 GMT+0530 (India Standard Time)','city','DE','23333',NULL,'High',12,'2','','Fulltime','SomeCollege','','<p>asasxa</p>\n','2','2',504429,0,'2022-05-19 13:49:20','2022-05-19 13:49:20'),(19,'12',490692,491650,'504429','adasa','Active','Fri May 20 2022 19:20:00 GMT+0530 (India Standard Time)','sad','CA','23333',NULL,'High',11,'2','','Fulltime','HighSchool','','<p>asdasdasd</p>\n','2','2',504429,0,'2022-05-19 13:51:39','2022-05-19 13:51:39'),(20,'1',490692,491650,'504429','welcome','Active','Fri May 20 2022 19:32:00 GMT+0530 (India Standard Time)','city','KS','12222',NULL,'High',8,'2','','Fulltime','HighSchool','','<p>asdas</p>\n','2','2',504429,0,'2022-05-19 14:02:45','2022-06-07 13:14:23'),(21,'21',490692,491650,'504429','see','Active','Sat May 21 2022 19:42:00 GMT+0530 (India Standard Time)','city','AZ','12222',NULL,'High',1,'1','','Fulltime','SomeCollege','','<p>saasda</p>\n','1','1',504429,504429,'2022-05-19 14:13:23','2022-06-07 13:14:24'),(22,'22',490692,491650,'504429','asdfgsadasas','In-active','Sat May 21 2022 23:13:00 GMT+0530 (India Standard Time)','GOKAK','ID','591307',NULL,'High',2,'1','','Fulltime','HighSchool','','<p>dfghjkl;</p>\n','1500','142',504429,504429,'2022-05-20 17:47:36','2022-05-23 11:08:47'),(23,'2593',499480,500438,'513217','Administrative Clerk ','Active','Fri May 20 2022 15:36:00 GMT-0400 (Eastern Daylight Time)','Atlanta','GA','30303',NULL,'High',4,'1','Fri Jun 30 2023 00:00:00 GMT-0400 (Eastern Daylight Time)','Contract','BS/BA','','<p><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">We are seeking an IT Administrative Clerk to provide various administrative and support services. The position duties will include:</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• scheduling and coordinating the logistics of meetings</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• managing and tracking phone calls and electronic correspondence</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• managing paperwork and department administrative needs</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• providing data entry and light support to end-users</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• preparing reports, memos, letters, presentations, and other documents</span><br><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">This job requires a flexible and self-motivated multi-tasker who is polite and customer-service oriented.</span><br><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">The ideal candidate has excellent:</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Interpersonal skills</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Organizational skills</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Strong verbal and written communication skills.</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• At least two years of administrative experience is preferred.</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• This is a fast paced learning environment that requires the ability and willingness to learn new tasks and tools quickly.</span>&nbsp;</p>\n','31200.00','15.00',513217,513217,'2022-05-20 19:41:01','2022-05-23 11:08:48'),(24,'70581',499480,500438,'513217','Administrative Assistant','Active','Fri May 20 2022 15:48:00 GMT-0400 (Eastern Daylight Time)','Atlanta','GA','30303',NULL,'High',8,'1','','Fulltime','BS/BA','','<p><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">The Administrative Assistant will be based at the client location and support other sites as required.</span><br><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">Responsibilities:</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Serve as the interim book and digital resource manager until a full-time replacement is found</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Support all aspects of textbook negotiations, purchasing and inventory.</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Assist with the development of the book and Digital Marketplace</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">o o Virtually attend meetings</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">o o Write the SOP for the ordering of resources vetted by Curriculum and Instruction</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">o o Assist with communication of the new order process and marketplace</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Support with the procurement of curricular resources vetted by Curriculum and Instruction</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">o o Gather necessary information from vendors and create documents to support procurement of resources</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Serve as logistics liaison</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Process and review all requisitions; adjust requisitions as needed</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Support client with the invoicing and closing of POs</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">o o Serve as a liaison to update vendors on the payment status of purchase orders</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">o o Run open PO reports on behalf of clients</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Oversee district and site level inventory</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Respond to all book and digital resource related emails and phone calls</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Collaborate with Teaching and Learning coordinators and vendors</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">o Ensure material needs are fulfilled</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">o Provide support in the book adoption process</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Establish and maintain records to prepare reports; submit reports as required</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Respond to inquiries to provide information and/or resolve issues; communicate with personnel and/or vendors regarding order status</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Coordinate and complete special administrative projects</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Support training for new employee as needed</span><br><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">Personal Attributes:</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Creativity and strong attention to detail</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Ability to work effectively on tight deadlines, as necessary</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Oral and written communication skills</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Exceptional customer service skills, including the ability to interact professionally with a diverse group of customers</span><br><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">• Positive, productive team player</span>&nbsp;</p>\n','33,200.00','19.00',513217,513217,'2022-05-20 19:52:24','2022-05-23 11:08:49'),(29,'12sw123121',490692,491650,'504429','localhost testing ittstar','Active','Tue May 24 2022 16:35:00 GMT+0530 (India Standard Time)','city','HI','56200',NULL,'High',0,'12','','Fulltime','SomeCollege','','<p><span style=\"font-size: 18px;\"><strong>Lorem Ipsum</strong></span> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 18px;font-family: Open Sans;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\n','120000','12',504429,504429,'2022-05-23 11:07:22','2022-05-23 11:15:59'),(30,'12d427',490692,491650,'504429','local test','Active','Wed May 25 2022 15:11:00 GMT+0530 (India Standard Time)','city','GA','54003',NULL,'High',0,'12','','Parttime','SomeCollege','','<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\n','12000','12',504429,504429,'2022-05-24 09:44:36','2022-05-24 09:52:43'),(31,'test12',490692,491650,'504429','testing ittstar','Active','Tue May 24 2022 16:38:00 GMT+0530 (India Standard Time)','city','GA','54002',NULL,'Medium',3,'23','','Fulltime','HighSchool','','<p><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.</span>&nbsp;</p>\n','120000','12',504429,504429,'2022-05-24 11:09:46','2022-05-24 11:37:26'),(32,'1s31577',490692,491650,'504429','dev testing ','Active','Wed May 25 2022 18:27:00 GMT+0530 (India Standard Time)','city','GA','56001',NULL,'High',11,'12','','Fulltime','SomeCollege','','<p>descriptio</p>\n','12000','12',504429,504429,'2022-05-25 12:59:03','2022-05-25 13:21:01'),(33,'12s31427',490692,491650,'513217','title','Active','Wed May 25 2022 18:27:00 GMT+0530 (India Standard Time)','city','GA','56001',NULL,'High',11,'12','','Fulltime','SomeCollege','','<p></p>\n','12000','12',513217,504429,'2022-05-25 15:59:07','2022-06-07 13:15:03'),(34,'12s421212',490692,491650,'504429','Local dev testing ','Active','Wed May 25 2022 21:50:00 GMT+0530 (India Standard Time)','city','GA','56001',NULL,'High',10,'12','','Fulltime','SomeCollege','','<p><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\n','120000','12',504429,504429,'2022-05-25 16:22:00','2022-05-25 16:22:23'),(35,'12s31425',490692,491650,'504429','Testing in the local','Active','Thu May 26 2022 14:18:00 GMT+0530 (India Standard Time)','city','GA','54112',NULL,'High',11,'13','','Fulltime','HighSchool','','<p>description</p>\n','120000','12',504429,504429,'2022-05-26 08:56:18','2022-05-26 08:58:33'),(36,'342wa',490692,491650,'504429','qwe','Active','Sat May 28 2022 17:47:00 GMT+0530 (India Standard Time)','sdf','IN','591307',NULL,'High',8,'2','','Fulltime','HighSchool','','<p>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa</p>\n','150000','120',504429,504429,'2022-05-27 12:18:29','2022-05-27 12:19:33'),(38,'qwe',490692,491650,'504429','qwer','Active','Fri May 27 2022 18:47:00 GMT+0530 (India Standard Time)','city','GA','57214',NULL,'High',11,'14','','Fulltime','HighSchool','','<p>qwhjfgh</p>\n','12000','12',504429,504429,'2022-05-27 13:18:43','2022-05-27 14:30:46'),(40,'1234',490692,491650,'504429','ITTSTAR React Js','Active','Thu May 05 2022 17:05:00 GMT+0530 (India Standard Time)','dfgdfg','IL','2343',NULL,'High',7,'51','','Fulltime','HighSchool','','<p>zzzzzzzzzzzzzzzzzzzzzzzzzsdfg</p>\n','150000','150',504429,504429,'2022-05-31 11:35:40','2022-05-31 11:46:29'),(41,'10918',499480,500438,'513217','Data Analyst ','Active','Tue May 31 2022 11:07:00 GMT-0400 (Eastern Daylight Time)','Richmond','VA','23219',NULL,'High',1,'1','','Fulltime','BS/BA','','<p><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 13px;font-family: Verdana, Arial, Helvetica, sans-serif;\">We are seeking an Analytics and Visualization Specialist to assist with the data reporting and analysis. The candidate is responsible for the organization, presentation, analysis, and verification of information. The Analytics and Visualization Specialist will be responsible for data analysis and development of data visualization projects. This position will report to the Data Analytics Manager.</span>&nbsp;</p>\n','87,776.00','42.30',513217,513217,'2022-05-31 15:08:43','2022-05-31 15:12:36'),(42,'qw12qa1',490692,491650,'504429','testing fro the ','Active','Thu Jun 02 2022 15:39:00 GMT+0530 (India Standard Time)','city','DC','57214',NULL,'High',10,'15','','Fulltime','AS/AA','','<p><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\n<p></p>\n<p><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\n','12000','120',504429,504429,'2022-06-01 10:10:22','2022-06-01 14:02:02'),(43,'12s31421',490692,491650,'504429','testing ','Active','Wed Jun 01 2022 21:39:00 GMT+0530 (India Standard Time)','city','ID','57412',NULL,'High',10,'15','','Fulltime','SomeCollege','','<p><span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\n','12000','120',504429,504429,'2022-06-01 16:09:51','2022-06-01 16:12:11'),(47,'1245',490692,491650,'504429','aaaaaaaa','Active','Wed Jun 08 2022 18:49:00 GMT+0530 (India Standard Time)','bangalore','GA','56004',NULL,'High',5,'25','','Fulltime','PhD','','<p>aaaaaaaaaaaaassssssssssss</p>\n','1500','120',504429,504429,'2022-06-06 13:20:09','2022-06-06 13:21:41'),(51,'12427',498821,499779,'512558','qa','Active','Wed Jun 01 2022 15:31:00 GMT+0530 (India Standard Time)','qa','DC','572145',NULL,'High',22,'10','','Fulltime','SomeCollege','','<p><strong>Lorem Ipsum</strong> <span style=\"color: rgb(0,0,0);background-color: rgb(255,255,255);font-size: 14px;font-family: Open Sans;\">is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</span>&nbsp;</p>\n','232','2453',512558,512558,'2022-07-20 10:02:42','2022-07-20 10:04:24'),(53,'3432',527341,528279,'541177','SE Leval 3','Active','Thu Jan 04 2024 16:24:00 GMT+0530 (India Standard Time)','aa','ID','54323',NULL,'High',11,'4','','Contract','HighSchool','','<p>welcome <span style=\"color: rgba(0,0,0,0.87);background-color: rgb(255,255,255);font-size: 16px;font-family: Roboto, serif;\">welcome </span> <span style=\"color: rgba(0,0,0,0.87);background-color: rgb(255,255,255);font-size: 16px;font-family: Roboto, serif;\">welcome </span> <span style=\"color: rgba(0,0,0,0.87);background-color: rgb(255,255,255);font-size: 16px;font-family: Roboto, serif;\">welcome </span> <span style=\"color: rgba(0,0,0,0.87);background-color: rgb(255,255,255);font-size: 16px;font-family: Roboto, serif;\">welcome </span> <span style=\"color: rgba(0,0,0,0.87);background-color: rgb(255,255,255);font-size: 16px;font-family: Roboto, serif;\">welcome </span> <span style=\"color: rgba(0,0,0,0.87);background-color: rgb(255,255,255);font-size: 16px;font-family: Roboto, serif;\">welcome </span> <br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">My name is Christopher John Francis Boone. I know all the countries of the world and their capital cities and every prime number up to 7,057.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">Eight years ago, when I first met Siobhan, she showed me this picture</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">[sad face]</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">and I knew that it meant ‘sad,’ which is what I felt when I found the dead dog.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">Then she showed me this picture</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">[smiley face]</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">and I knew that it meant ‘happy’, like when I’m reading about the Apollo space missions, or when I am still awake at 3 am or 4 am in the morning and I can walk up and down the street and pretend that I am the only person in the whole world.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">Then she drew some other pictures</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">[various happy, sad, confused, surprised faces]</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">but I was unable to say what these meant.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">I got Siobhan to draw lots of these faces and then write down next to them exactly what they meant. I kept the piece the piece of paper in my pocket and took it out when I didn’t understand what someone was saying. But it was very difficult to decide which of the diagrams was most like the face they were making because people’s faces move very quickly.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">When I told Siobhan that I was doing this, she got out a pencil and another piece of paper and said it probably made people feel very</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">[confused face]</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">and then she laughed. So I tore the original piece of paper up and threw it away. And Siobhan apologised. And now if I don’t know what someone is saying I ask them what they mean or I walk away.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">5</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">I pulled the fork out of the dog and lifted him into my arms and hugged him. He was leaking blood from the fork-holes.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">I like dogs. You always know what a dog is thinking. It has four moods. Happy, sad, cross and concentrating. Also, dogs are faithful and they do not tell lies because they cannot talk.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">I had been hugging the dog for 4 minutes when I heard screaming. I looked up and saw Mrs Shears running towards me from the patio. She was wearing pyjamas and a housecoat. Her toenails were painted bright pink and she had no shoes on.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">She was shouting, ‘What in fuck’s name have you done to my dog?’.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">I do not like people shouting at me. It makes me scared that they are going to hit me or touch me and I do not know what is going to happen.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">‘Let go of the dog,’ she shouted. ‘Let go of the fucking dog for Christ’s sake.’</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">I put the dog down on the lawn and moved back 2 metres.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">She bent down. I thought she was going to pick the dog up herself, but she didn’t. Perhaps she noticed how much blood there was and didn’t want to get dirty. Instead, she started screaming again.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">I put my hands over my ears and closed my eyes and rolled forward till I was hunched up with my forehead pressed onto the grass. The grass was wet and cold. It was nice.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">7</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">This is a murder mystery novel.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">Siobhan said that I should write something I would want to read myself. Mostly I read books about science and maths. I do not like proper novels. In proper novels people say things like, ‘I am veined with iron, with silver and with streaks of common mud. I cannot contract into the firm fist which those clench who do not depend on stimulus’ . What does this mean? I do not know. Nor does Father. Nor do Siobhan or Mr Jeavons. I have asked them.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">Siobhan has long blonde hair and wears glasses which are made of green plastic. And Mr Jeavons smells of soap and wears brown shoes that have approximately 60 tiny circular holes in each of them.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">But I do like murder mystery novels. So I am writing a murder mystery novel.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">In a murder mystery novel someone has to work out who the murderer is and then catch them. It is a puzzle. If it is a good puzzle you can sometimes work out the answer before the end of the book.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">Siobhan said that the book should begin with something to grab people’s attention. That is why I started with the dog. I also started with the dog because it happened to me and I find it hard to imagine things which did not happen to me.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">Siobhan read the first page and said that it was different. She put this word into inverted commas by making the wiggly quotation sign with her first and second fingers. She said that it was usually people who were killed in murder mystery novels. I said that two dogs were killed in</span> <span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">The Hound of the Baskervilles, the hound itself and James Mortimer’s spaniel, but Siobhan said they weren’t the victims of the murder, Sir Charles Baskerville was. She said that this was because readers cared more about people than dogs, so if a person was killed in the book readers would want to carry on reading.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">I said that I wanted to write about something real and I knew people who had died but I did not know any people who had been killed, except Edward’s father from school, Mr Paulson, and that was a gliding accident, not murder, and I didn’t really know him. I also said that I cared about dogs because they were faithful and honest, and some dogs were cleverer and more interesting than some people. Steve, for example, who comes to centre on Thursdays, needs help to eat his food and could not even fetch a stick. Siobhan asked me not to say this to Steve’s mother.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">11</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">Then the police arrived. I like the police. They have uniforms and numbers and you know what they are meant to be doing. There was a policewoman and a policeman. The policewoman had a little hole in her tights on her left ankle and a red scratch in the middle of the hole. The policeman had a big orange leaf stuck to the bottom of his shoe which was poking out from one side.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">The policewoman put her arms round Mrs Shears and led her back towards the house.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">I lifted my head off the grass.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">The policeman squatted down beside me and said, ‘Would you like to tell me what’s going on here, young man?’.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">I sat up and said ‘The dog is dead.’</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">‘I’d got that far,’ he said.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">I said, ‘I think someone killed the dog.’</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">‘How old are you?’ he asked.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">I replied, ‘I am 15 years and 3 months and 2 days.’</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">‘And what, precisely, were you doing in the garden?’ he asked.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">‘I was holding the dog,’ I replied.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">‘And why were you holding the dog?’ he asked.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">This was a difficult question. It was something I wanted to do. I like dogs. It made me sad to see that the dog was dead.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">I like policemen, too, and I wanted to answer the question properly, but the policeman did not give me enough time to work out the correct answer.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">‘Why were you holding the dog?’ he asked again.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">‘I like dogs,’ I said.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">‘Did you kill the dog?’ he asked.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">I said, ‘I did not kill the dog.’</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">‘Is this your fork?’ he asked.</span><br><br><span style=\"color: rgb(0,0,0);font-size: medium;font-family: Times New Roman;\">I said, ‘No.’</span>&nbsp;</p>\n','10000','150',541177,541177,'2024-01-04 10:56:24','2024-01-04 11:17:29'),(54,'sdfghrert',527232,528190,'540969','Police Communications Specialist I Emergency Dispatcher','Active','Wed Jan 17 2024 18:53:00 GMT+0530 (India Standard Time)','washington','DC','20001',NULL,'High',8,'3','','Fulltime','SomeCollege','','<ul>\n<li><span style=\"color: rgba(0,0,0,0.9);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, system-ui, BlinkMacSystemFont, \"Segoe UI\", Roboto, \"Helvetica Neue\", \"Fira Sans\", Ubuntu, Oxygen, \"Oxygen Sans\", Cantarell, \"Droid Sans\", \"Apple Color Emoji\", \"Segoe UI Emoji\", \"Segoe UI Emoji\", \"Segoe UI Symbol\", \"Lucida Grande\", Helvetica, Arial, sans-serif;\">The Police Communications Specialist position plays a critical role in the success of the Washington Metropolitan Area Transit Authority’s (WMATA’s) Metro Transit Police Department. Police Communication Specialists are responsible for answering and dispatching the appropriate Police, Fire, or Emergency Medical Services personnel for calls received by Metro customers and employees. The Police Communications Unit operates 365 days per year to ensure the safety of our riders. Metro is seeking dependable professionals with a background in emergency services dispatching or experience as a sworn police officer to fill several open positions. This is an onsite position.</span><br><br><span style=\"color: rgba(0,0,0,0.9);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, system-ui, BlinkMacSystemFont, \"Segoe UI\", Roboto, \"Helvetica Neue\", \"Fira Sans\", Ubuntu, Oxygen, \"Oxygen Sans\", Cantarell, \"Droid Sans\", \"Apple Color Emoji\", \"Segoe UI Emoji\", \"Segoe UI Emoji\", \"Segoe UI Symbol\", \"Lucida Grande\", Helvetica, Arial, sans-serif;\">This position offers an annual salary range of $62,201.25 to $93,944.96. WMATA offers a rich benefit package to include health, dental, group life insurance, paid holidays, annual and sick leave, 457 Deferred Compensation Plan and 401A Retirement Plan as well as tuition reimbursement, flexible spending accounts, and free transportation on Metrobus and rail.</span><br><br><span style=\"color: rgba(0,0,0,0.9);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, system-ui, BlinkMacSystemFont, \"Segoe UI\", Roboto, \"Helvetica Neue\", \"Fira Sans\", Ubuntu, Oxygen, \"Oxygen Sans\", Cantarell, \"Droid Sans\", \"Apple Color Emoji\", \"Segoe UI Emoji\", \"Segoe UI Emoji\", \"Segoe UI Symbol\", \"Lucida Grande\", Helvetica, Arial, sans-serif;\">Ideal candidates will have police emergency dispatcher experience for this role.</span>&nbsp;</li>\n</ul>\n','2344','2',540969,540969,'2024-01-17 13:26:45','2024-02-02 10:30:11'),(55,'redUAGS',527232,528190,'540969','Entry Level - Police Officer Recruit','','Wed Jan 17 2024 19:00:00 GMT+0530 (India Standard Time)','Los Angeles','CA','90001',NULL,'High',8,'4','','Fulltime','AS/AA','','<p style=\"text-align:start;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: 16px;font-family: Noto Sans;\">About us</span></p>\n<p style=\"text-align:start;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: 16px;font-family: Noto Sans;\">We offer demanding, fast-paced, and rewarding employment. Our goal is to Protect and Serve.</span></p>\n<p style=\"text-align:start;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: 16px;font-family: Noto Sans;\">Visit JoinLAPD.com to apply today</span></p>\n<p style=\"text-align:start;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: 16px;font-family: Noto Sans;\">Our work environment includes:</span></p>\n<ul>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Growth opportunities</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Wellness programs</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">On-the-job training</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">New Hire Rent Subsidy</span></li>\n</ul>\n<p style=\"text-align:start;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: 16px;font-family: Noto Sans;\">We are looking for dedicated and reliable Police Officers to join our team. Successful candidates will be responsible for patrolling assigned areas, responding to emergency calls, enforcing laws and ordinances, conducting investigations, making arrests, and maintaining public order. Ideal candidates will have a strong sense of justice and integrity, as well as excellent communication and problem-solving skills. This is a unique opportunity for a motivated individual to make a positive impact in their community.</span></p>\n<p style=\"text-align:start;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: 16px;font-family: Noto Sans;\">Responsibilities:</span></p>\n<ul>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Enforce laws and ordinances.</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Protect life and property.</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Respond to emergency calls for service.</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Conduct investigations and gather evidence.</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Interview witnesses and suspects.</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Write reports and maintain records.</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Provide assistance to the public.</span></li>\n</ul>\n<p style=\"text-align:start;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: 16px;font-family: Noto Sans;\">Job Type: Full-time</span></p>\n<p style=\"text-align:start;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: 16px;font-family: Noto Sans;\">Pay: $86,192.00 - $117,408.00 per year</span></p>\n<p style=\"text-align:start;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: 16px;font-family: Noto Sans;\">Benefits:</span></p>\n<ul>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">401(k)</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Dental insurance</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Employee assistance program</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Employee discount</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Flexible schedule</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Flexible spending account</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Health insurance</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Health savings account</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Life insurance</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Paid time off</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Parental leave</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Professional development assistance</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Referral program</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Relocation assistance</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Retirement plan</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Tuition reimbursement</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Vision insurance</span></li>\n</ul>\n<p style=\"text-align:start;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: 16px;font-family: Noto Sans;\">Schedule:</span></p>\n<ul>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">10 hour shift</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">12 hour shift</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Day shift</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Evening shift</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Holidays</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Monday to Friday</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Night shift</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Overnight shift</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Overtime</span></li>\n<li style=\"margin-left:revert;\"><span style=\"color: rgb(45,45,45);background-color: rgb(255,255,255);font-size: inherit;font-family: Noto Sans;\">Weekends as needed</span></li>\n</ul>\n<p style=\"text-align:start;\"></p>\n','8619','2',540969,540969,'2024-01-17 13:32:44','2024-03-06 14:07:35'),(56,'34',527232,528190,'541159','teest','Active','Tue Mar 26 2024 15:51:00 GMT+0530 (India Standard Time)','','','',NULL,'',0,'','','Fulltime','HighSchool','','<p></p>\n','','',541159,0,'2024-03-26 10:22:19','2024-03-26 10:22:19'),(58,'22',527232,528190,'540969','rewq','Active','Tue Apr 09 2024 13:24:00 GMT+0530 (India Standard Time)','New York','DE','11111',NULL,'High',2,'3','','Fulltime','SomeCollege','','<ol>\n<li></li>\n</ol>\n<p style=\"margin-left:0px;\"><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: var(--cib-type-body2-font-size);font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\"><strong>Crime Record Management System</strong>:</span></p>\n<ul>\n<li><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\">This project encompasses three user interfaces:</span> <span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\"><strong>CID</strong>,</span> <span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\"><strong>admin</strong>, and</span> <span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\"><strong>officer</strong>. It employs PHP, HTML, JavaScript, CSS, and MySQL to offer efficient crime data management. Seamlessly handle records and interactions within the law enforcement ecosystem through this comprehensive system.</span> <a href=\"https://github.com/ddarrsh/Crime_Record_Managment_System\" target=\"_self\"><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\">You can find the code on GitHub:</span> </a><a href=\"https://github.com/ddarrsh/Crime_Record_Managment_System\" target=\"_blank\"><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\">Crime Record Management System</span></a><a href=\"https://github.com/ddarrsh/Crime_Record_Managment_System\" target=\"_blank\"><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\"><sup>1</sup></span></a><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\">.</span></li>\n</ul>\n<ol>\n<li></li>\n</ol>\n<p style=\"margin-left:0px;\"><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: var(--cib-type-body2-font-size);font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\"><strong>Microsoft Office JavaScript Examples</strong>:</span></p>\n<ul>\n<li><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\">If you’re interested in building applications that integrate with Microsoft Office, check out the</span> <span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\"><strong>@microsoft/office-js</strong></span> <span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\">examples on CodeSandbox. This online playground allows you to view and fork example apps and templates.</span> <a href=\"https://codesandbox.io/examples/package/@microsoft/office-js\" target=\"_blank\"><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\">Click any example to run it instantly or explore pre-built solutions:</span> </a><a href=\"https://codesandbox.io/examples/package/@microsoft/office-js\" target=\"_blank\"><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\">Office JavaScript Examples on CodeSandbox</span></a><a href=\"https://codesandbox.io/examples/package/@microsoft/office-js\" target=\"_blank\"><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\"><sup>2</sup></span></a><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\">.</span></li>\n</ul>\n<ol>\n<li></li>\n</ol>\n<p style=\"margin-left:0px;\"><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: var(--cib-type-body2-font-size);font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\"><strong>Office JS Snippets</strong>:</span></p>\n<ul>\n<li><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\">The</span> <span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\"><strong>Office JS Snippets</strong></span> <span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\">repository contains a collection of code snippets built with</span> <span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\"><strong>Script Lab</strong>. These snippets cover various scenarios related to Microsoft Office.</span> <a href=\"https://github.com/OfficeDev/office-js-snippets\" target=\"_blank\"><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\">To contribute, fork the project into your GitHub account:</span> </a><a href=\"https://github.com/OfficeDev/office-js-snippets\" target=\"_blank\"><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\">Office JS Snippets on GitHub</span></a><a href=\"https://github.com/OfficeDev/office-js-snippets\" target=\"_blank\"><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\"><sup>3</sup></span></a><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\">.</span></li>\n</ul>\n<p style=\"text-align:start;\"><span style=\"color: rgb(17,17,17);background-color: rgb(255,255,255);font-size: 16px;font-family: -apple-system, Roboto, SegoeUI, \"Segoe UI\", \"Helvetica Neue\", Helvetica, \"Microsoft YaHei\", \"Meiryo UI\", Meiryo, \"Arial Unicode MS\", sans-serif;\">Feel free to explore these resources and dive deeper into JavaScript development for agency, police, and office-related applications! ????????‍♂️????</span>&nbsp;</p>\n','777','2',540969,0,'2024-04-09 07:56:57','2024-04-09 07:56:57'),(60,'8797',527232,528190,'541161','test update','Active','Mon Apr 15 2024 17:00:00 GMT+0530 (India Standard Time)','Bangalore ','CA','560051',NULL,'Medium',8,'1','','Fulltime','AS/AA','','<p>Test Job</p>\n','50','50',541161,540969,'2024-04-16 11:33:49','2025-06-06 12:36:24'),(61,'231',527341,528279,'541177','Development','Active','Mon Jun 03 2024 15:26:00 GMT+0530 (India Standard Time)','Georgia','FL','603002',NULL,'High',2,'2','','Fulltime','HighSchool','','<p>teesint engineer</p>\n','10000','200',541177,541177,'2024-06-03 09:58:03','2024-06-03 09:58:28'),(62,'42',0,0,'541516',' Entry Level - Police Officer ','Active','Mon Jun 03 2024 17:49:00 GMT+0530 (India Standard Time)','Gerogia','DE','209009',NULL,'Medium',2,'2','','Fulltime','HighSchool','','<p>testing</p>\n','10000','200',541516,8,'2024-06-03 12:20:35','2025-06-06 12:00:04'),(63,'87',0,0,'541555',' Entry Level - Police Officer','Active','Thu Dec 12 2024 16:59:00 GMT+0530 (India Standard Time)','newyork','CO','8909999',NULL,'High',1,'2','','Fulltime','HighSchool','','<p>new openings</p>\n','1000','100',541555,8,'2024-12-12 11:31:22','2025-06-06 11:59:17');

--
