Kol Management Platform - Konectar.io [30M | 15Gb]
HTML:
`data_automation` (`id`, `npi_num`, `first_name`, `last_name`, `middle_name`, `speciality`, `change_from_source`, `old_org_name`, `old_address_1`, `old_address_2`, `old_city`, `old_state`, `old_postal_code`, `added_by`, `new_org_name`, `new_address_1`, `new_address_2`, `new_city`, `new_state`, `new_postal_code`, `new_phone_number`, `new_email`, `manual_comment`, `action`, `crawled_on`, `updated_by`, `updated_on`, `assigned_to`, `kol_id`, `modified_by`)
------------------
`kols` (`id`, `mdm_id`, `aissel_id`, `salutation`, `first_name`, `middle_name`, `last_name`, `suffix`, `specialty`, `sub_specialty`, `dob`, `gender`, `org_id`, `title`, `division`, `primary_phone`, `primary_email`, `address1`, `address2`, `city_id`, `state_id`, `country_id`, `postal_code`, `zip`, `fax`, `research_interests`, `license`, `biography`, `notes`, `profile_image`, `url`, `blog`, `linked_in`, `facebook`, `twitter`, `myspace`, `you_tube`, `created_by`, `created_on`, `modified_by`, `modified_on`, `is_pubmed_processed`, `is_clinical_trial_processed`, `pin`, `is_imported`, `status`, `approved_by`, `npi_num`, `profile_type`, `asmt_score`, `customer_status`, `fma_speciality_id`, `product_id`, `additional_role_id`, `speaker_id`, `degree_id`, `patients_range`, `compliance_flag`, `is_kol`, `profile_from`, `is_speaker`, `is_duplicate_case`, `data_updated`)
------------------
`client_users` (`id`, `client_id`, `user_name`, `password`, `email`, `contact @fbi_gov `, `is_analyst`, `user_role_id`, `user_last_login`, `created_by`, `created_on`, `modified_by`, `modified_on`, `first_name`, `last_name`, `title`, `company_name`, `phone`, `country`, `mem_pic`, `department`, `address`, `about`, `interest`, `manager_id`, `territory`, `new_password_key`, `new_password_creation`, `name_order`, `status`, `deleted_by`, `deleted_on`, `status_modified_by`, `status_modified_on`, `api_key`, `secret_key`, `find_experts`, `user_from`, `is_marketing`, `failed_attempts`, `state_id`, `city_id`, `preferred_form`, `client_test_user`, `is_super_user`, `planned_interaction_notification`, `auto_deactivate`, `auto_deactivate_days`)
HTML:
(76002, '1003016957', 'Shishir', 'Mathur', '', 'Interventional Cardiology', 'medicare', 'Hartford County Cardiology Pc', '27 Sycamore St', 'Suite 400', 'Glastonbury', 'Connecticut', '06033-7208', NULL, 'STARLING PHYSICIANS PC', '1260 SILAS DEANE HWY', '', 'WETHERSFIELD', 'CT', '061094362', '8602583480', NULL, NULL, 0, '2021-03-18 10:36:31', NULL, '2021-03-18 10:36:31', NULL, 9, ''),
(76003, '1003017666', 'Cory', 'Nitzel', 'Michael Lee', 'Cardiovascular Disease (Cardiology)', 'medicare', 'University Of Utah Adult Services', '1995 Errecart Blvd', '', 'Elko', 'Nevada', '89801-8346', NULL, 'COUNTY OF VENTURA', '300 HILLMONT AVE', '', 'VENTURA', 'CA', '930031651', '8056543306', NULL, NULL, 0, '2021-03-18 10:36:31', NULL, '2021-03-18 10:36:31', NULL, 11, ''),
(76004, '1003018250', 'Domenico', 'Calcaterra', '', 'Cardiothoracic Surgery', 'medicare', 'Allina Health System', '2215 Park Ave', '', 'Minneapolis', 'Minnesota', '55404-3711', NULL, 'BOCACARE INC', '2815 S SEACREST BLVD', '', 'BOYNTON BEACH', 'FL', '334357969', '5617377733', NULL, NULL, 0, '2021-03-18 10:36:31', NULL, '2021-03-18 10:36:31', NULL, 13, ''),
(76005, '1003018250', 'Domenico', 'Calcaterra', '', 'Cardiothoracic Surgery', 'medicare', 'Allina Health System', '2215 Park Ave', '', 'Minneapolis', 'Minnesota', '55404-3711', NULL, 'BETHESDA HEALTH PHYSICIAN GROUP, INC.', '2815 S SEACREST BLVD', '', 'BOYNTON BEACH', 'FL', '334357969', '', NULL, NULL, 0, '2021-03-18 10:36:31', NULL, '2021-03-18 10:36:31', NULL, 13, ''),
(76006, '1003019563', 'John', 'Frank', 'Joseph', 'Cardiovascular Disease (Cardiology)', 'medicare', 'Bay Area Hospital District', '1775 Thompson Rd', '', 'Coos Bay', 'Oregon', '97420-2198', NULL, 'SCL HEALTH MEDICAL GROUP DENVER LLC', '1960 N OGDEN ST', '', 'DENVER', 'CO', '802183667', '', NULL, NULL, 0, '2021-03-18 10:36:31', NULL, '2021-03-18 10:36:31', NULL, 14, ''),
(76007, '1003019563', 'John', 'Frank', 'Joseph', 'Cardiovascular Disease (Cardiology)', 'medicare', 'Bay Area Hospital District', '1775 Thompson Rd', '', 'Coos Bay', 'Oregon', '97420-2198', NULL, 'SCL HEALTH MEDICAL GROUP DENVER LLC', '11900 GRANT ST', '', 'NORTHGLENN', 'CO', '802331117', '', NULL, NULL, 0, '2021-03-18 10:36:31', NULL, '2021-03-18 10:36:31', NULL, 14, ''),
(76008, '1003019563', 'John', 'Frank', 'Joseph', 'Cardiovascular Disease (Cardiology)', 'medicare', 'Bay Area Hospital District', '1775 Thompson Rd', '', 'Coos Bay', 'Oregon', '97420-2198', NULL, 'SCL HEALTH MEDICAL GROUP DENVER LLC', '1960 N OGDEN ST', '', 'DENVER', 'CO', '802183668', '3033183540', NULL, NULL, 0, '2021-03-18 10:36:31', NULL, '2021-03-18 10:36:31', NULL, 14, ''),
(6, 18742, 18748, '1999 Harrison Street, Suite 1650', 7335, 126, 254, '94612', '+15103409101', 'info@cirm.ca.gov', 'https://www.nhlbi.nih.gov/health-topics/education-and-awareness/sickle-cell/our-partners', '', NULL, NULL, NULL, NULL, 'No'),
(7, 18742, 18749, '', NULL, 126, 254, '', '+18555000050 X 805', '', 'https://www.nhlbi.nih.gov/health/educational/wecan/partner-with-us/national-partners-list.htm', '', NULL, NULL, NULL, NULL, 'No'),
(8, 18742, 18729, '1600 Clifton Road', 7839, 132, 254, '30333', '+18002324636', 'cdcinfo@cdc.gov', 'https://www.nhlbi.nih.gov/health/educational/wecan/partner-with-us/national-partners-list.htm', '', NULL, NULL, NULL, NULL, 'No'),
(9, 18742, 1012, 'PO Box 948', 10464, 158, 254, '74465', '+19184535000', 'camp@cherokee.org', 'https://www.nhlbi.nih.gov/health/educational/wecan/partner-with-us/national-partners-list.htm', '', NULL, NULL, NULL, NULL, 'No'),
(10, 18742, 18750, 'The Tisch Building, 212 West 83rd Street', 10182, 154, 254, '10024', '+12127211223', 'info@cmom.org', 'https://www.nhlbi.nih.gov/health/educational/wecan/partner-with-us/national-partners-list.htm', '', NULL, NULL, NULL, NULL, 'No'),
(11, 18742, 18751, '111 Michigan Avenue Northwest', 0, 154, 254, '20010', '+12024765000', '', 'https://www.nhlbi.nih.gov/health/educational/wecan/partner-with-us/national-partners-list.htm', '', NULL, NULL, NULL, NULL, 'No'),
(12, 18742, 18752, '5600 Fishers Lane', 0, 2582, 254, '20857', '+13014433376', 'press@hrsa.gov', 'https://www.nhlbi.nih.gov/health/educational/wecan/partner-with-us/national-partners-list.htm', '', NULL, NULL, NULL, NULL, 'No'),
(13, 18742, 18753, '5600 Fishers Lane', 0, 2582, 254, '20857', '', '', 'https://www.nhlbi.nih.gov/health/educational/wecan/partner-with-us/national-partners-list.htm', '', NULL, NULL, NULL, NULL, 'No'),
(14, 18742, 18754, '325 Swanton Way', 7882, 132, 254, '30030', '', 'info@chronicdisease.org', 'https://www.nhlbi.nih.gov/health/educational/wecan/partner-with-us/national-partners-list.htm', '', NULL, NULL, NULL, NULL, 'No'),
(15, 18742, 18755, '1201 Eye Street, Northwest, 4th Floor', 8001, 132, 254, '20005', '+12027835550', 'info@naccho.org', 'https://www.nhlbi.nih.gov/health/educational/wecan/partner-with-us/national-partners-list.htm', '', NULL, NULL, NULL, NULL, 'No'),
(16, 18742, 18756, '1100 Wayne Avenue, Suite 925', 0, 2582, 254, '20910', '+12408211130', 'nasn@nasn.org', 'https://www.nhlbi.nih.gov/health/educational/wecan/partner-with-us/national-partners-list.htm', '', NULL, NULL, NULL, NULL, 'No'),
(137, 1, 'preetaanalyst@aissel.com', '$2a$08$lPmSEfskpN2wa.K/Rro74uDwqLs4P6uoJCPGS7pcVhSuiL3q5hCxS', 'preetaanalyst@aissel.com', '08362351011', 1, 2, NULL, '8', '2013-04-04 23:18:41', '417', '2019-01-17 17:58:07', 'Preeta', 'Nayak', 'Data Analyst', 'Aissel Solutions', '', 113, NULL, NULL, NULL, NULL, NULL, 137, 'All', '7e509c4ccae9c2d082773c8db06ecddc', '2014-07-24 05:18:55', 3, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, 0, '', 0, 0, 0, 0, NULL),
(161, 32, 'suraj@aissel.com', '$2a$08$5I623yCQzcL.Koa2s.kKYeroATSiF1zUe3U5AfD11feTI82x.0C5.', 'suraj@aissel.com', 'test@test.com', 1, 2, NULL, '11', '2013-12-05 05:09:45', '72', '2018-03-09 19:16:31', 'Suraj', 'Prabhu', 'in IT Project Management ', 'Aissel', '', 113, NULL, NULL, NULL, NULL, NULL, 161, 'All', NULL, '0000-00-00 00:00:00', 3, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 1, 0, 0, '', 0, 0, 0, 0, NULL),
(260, 1, 'laxmank@aissel.com', '$2a$08$x0/7qEbsDKS2SMxvJhYPPOtoFh2w1eLYCcjvA07Yf6KqDJBqNJg42', 'laxmank@aissel.com', '', 1, 2, NULL, '231', '2015-02-18 22:58:08', '358', '2019-01-14 15:34:04', 'Laxman', 'K', 'Developer', 'Aissel', '', 113, NULL, NULL, NULL, NULL, NULL, 260, 'All', NULL, '0000-00-00 00:00:00', 3, 0, NULL, NULL, NULL, NULL, 'ACE0D20D-49A1-4BB9-8C44-C53806B2D941', '64E03FC6-BAA0-4F93-8969-262A2A18B179', 0, NULL, 0, 0, 0, 0, '', 0, 0, 0, 0, NULL),
(272, 19, 'suhasc@aissel.com', '$2a$08$2DWR7VsCM2CyUzEAQ34yn.nIHsrBtPC68bHfbsn5Qmu./1RY879wi', 'xxxsuhasc@aissel.comxxx', '', 1, 2, NULL, '72', '2016-09-08 17:22:27', '358', '2019-01-14 16:05:51', 'Suhas', 'B', 'Marketing Analyst', 'Aissel', '', 254, NULL, NULL, NULL, NULL, NULL, 272, 'All', '8bb8d2bde69fc566d87ead245d4ca430', '2018-04-12 12:33:11', 3, 0, NULL, NULL, NULL, NULL, '536F3D6B-5C74-4C7B-B04B-A7C2283E0551', '87C78EA5-BD92-49B2-8F99-490DB8A7F2C6', 0, NULL, 0, 0, 0, 0, '', 0, 0, 0, 0, NULL),
(273, 1, 'deepikak', '$2a$08$5OMyIt9s0QID8phgMPp5Bur0iAISWbewGk972cHOxtZLSVIKjWP4q', 'deepikak@aissel.com', '', 1, 0, NULL, '72', '2016-09-29 10:19:23', NULL, NULL, 'Deepika', 'Katti', '|Senior Analyst', 'Aissel', '', 113, NULL, NULL, NULL, NULL, NULL, 120, 'All', NULL, '0000-00-00 00:00:00', 3, 1, NULL, NULL, 436, '2020-05-28 10:23:27', 'DD94BF48-2564-41E1-AC5D-B72CFC03551A', 'D6E9156E-5096-4159-A526-9E8BA3BB0396', 0, NULL, 0, 0, 0, 0, '', 0, 0, 0, 0, NULL),
(274, 1, 'anupanalyst@aissel.com', '$2a$08$tNQgNAtr.QU.QVcjZijB.ujABqidPH.9nPgIfWQDS/WgaITxf/Mhe', 'xxxanupanalyst@aissel.comxxx', '', 1, 2, '2021-12-06 13:46:48', '11', '2016-10-27 12:55:45', '455', '2022-01-27 15:28:59', 'Anup', 'M', 'Analyst', 'Aissel Technologies Pvt. Ltd', '', 113, NULL, NULL, NULL, NULL, NULL, 274, 'All', NULL, NULL, 3, 0, NULL, NULL, NULL, NULL, 'FBBD7EE3-2EB2-4B53-B99A-AE249B6945AA', 'A4F16E98-6327-45AD-B5D9-E642FA130DC9', 0, NULL, 0, 0, 0, 0, '', 1, 0, 0, 0, '0000-00-00'),
(277, 1, 'rohinip', '$2a$08$3EGob1qRdCLCgguSD8nKQ.FO2s1ZM1CufU/AXdq7rWeD/OxQK7wke', 'rohinip@aissel.com', '', 1, 1, '2022-03-10 11:40:58', '231', '2016-11-04 12:02:55', '274', '2017-03-20 10:13:46', 'Rohini', 'Patil', 'Data Analyst', 'Aissel', '', 113, NULL, NULL, NULL, NULL, NULL, 274, 'All', NULL, '0000-00-00 00:00:00', 3, 1, NULL, NULL, NULL, NULL, '91BCB25C-0B0C-4A91-AC01-85994E1C0866', '63196512-DBAC-4B2E-8CF6-C5637FB95E94', 0, NULL, 0, 0, 0, 0, '', 0, 0, 0, 0, NULL),
(294, 1, 'ashwinih', '$2a$08$MsLJQeWQ24hmAR.OwFECyOZ0nvZS8DyQR1dM72NDqM66w0B.vSkGG', 'ashwinih@aissel.com', '', 1, 1, NULL, '120', '2017-01-25 10:40:00', NULL, NULL, 'ashiwni', 'hosamani', 'Analyst', 'Aissel', '', 113, NULL, NULL, NULL, NULL, NULL, 277, 'All', NULL, '0000-00-00 00:00:00', 3, 1, NULL, NULL, 436, '2020-05-28 10:23:27', '16CA9DAA-5D30-4D69-BD49-A9B608CF6234', '0921FD63-18CE-467C-9304-B6E275266D14', 0, NULL, 0, 0, 0, 0, '', 0, 0, 0, 0, NULL),
(326, 1, 'prakasham', '$2a$08$U/GdlB9SuhrTJDiKUoTDS.fzi..1spOLaZplzgTY3a19EwU2p3AWW', 'prakashamd@aissel.com', '0987654321', 1, 2, '2022-05-06 15:42:13', '220', '2017-08-28 12:48:42', '220', '2018-03-28 17:27:59', 'Prakash', 'Dara', 'Developer', 'ATPL', '', 113, NULL, NULL, NULL, NULL, NULL, 220, 'All', '6e99f3710b740e8e8c862ad2d16da794', '2020-02-14 14:48:19', 3, 1, NULL, NULL, NULL, NULL, '35705F02-9223-4E7E-BD50-8C00D2A62EB2', '079E7768-9507-4BA2-A98C-6077F6CBF327', 0, NULL, 0, 0, 0, 0, '', 0, 0, 0, 0, NULL),
(337, 1, 'pkumar@gmail.com', '$2a$08$awU1J6Tor29Qq4t41Ob/w.JPnS2FuBXOoi5aqyKApkhxcMQySQnEW', 'pkumar@gmail.com', '', 0, 2, NULL, '275', '2018-04-05 19:35:08', '421', '2019-04-11 12:43:59', 'Pradeep', 'Kumar', 'manager', 'Aissel', '', 113, NULL, NULL, NULL, NULL, NULL, 337, 'All', '53b5d2332726e39fcb74cecfc6ca4318', '2018-08-09 15:56:13', 3, 1, NULL, NULL, 421, '2019-11-18 18:54:38', '335EBC6B-4D2C-44DE-AC1D-D4A168AE467E', '6261F76E-3557-4162-8A25-F5C7E6CCC815', 0, NULL, 0, 0, 0, 0, '', 0, 0, 0, 0, NULL),
(344, 1, 'udayh', '$2a$08$TUgZ.Y0a0ozUZN89XmRWO.QYDDWL40gHrP2tGnEeg1xpBAtgaPEcK', 'udayh@aissel.com', NULL, 1, 0, NULL, '3', '2019-01-01 00:00:00', '231', '2019-01-16 00:00:00', 'Uday', 'H', 'Developer', 'Aissel', '1234560987', 113, '90f28592ef413831d1c9f4c750125505.png', NULL, NULL, NULL, NULL, 344, 'All', 'NULL', '0000-00-00 00:00:00', 3, 1, 0, '0000-00-00 00:00:00', 476, '2021-05-17 13:33:21', 'NULL', 'NULL', 0, 0, 0, 2, 0, 0, '', 0, 0, 0, 0, NULL),
(353, 1, 'shilpac@aissel.com', '$2a$08$YREkeQs3z18i.bzxkLa2F.tQ43ygkJjyG8Z0NAXsL8laTb0u0sYEG', 'shilpac@aissel.com', '', 1, 2, '2022-04-01 10:56:52', '120', '2018-05-24 15:04:59', '475', '2021-12-03 12:09:15', 'Shilpa', 'C', 'Analyst', 'Aissel', '', 113, NULL, NULL, NULL, NULL, NULL, 353, 'All', NULL, NULL, 3, 1, NULL, NULL, NULL, NULL, 'DCA33F57-8415-4588-B629-4BD6FCB21EE6', '0BC318AE-51C1-45B3-AA1E-F9CD63152996', 0, NULL, 0, 0, 0, 0, '', 0, 0, 0, 0, '0000-00-00'),
(359, 1, 'rashmid@aissel.com', '$2a$08$T9xcYIlDC1nVPSPjVxdeDuLMVM.oXmllGGzRxkmq9bCpV5sKDXmq.', 'rashmid@aissel.com', '', 1, 1, NULL, '335', '2018-05-31 15:07:55', '358', '2019-01-14 15:59:02', 'Rashmi', 'D', 'Developer', 'ATPL', '', 113, NULL, NULL, NULL, NULL, NULL, 359, 'All', NULL, '0000-00-00 00:00:00', 3, 0, NULL, NULL, NULL, NULL, '2155E3FB-A14A-4A65-9D6A-59E31BA96B88', '18015569-C59B-4F2A-A55E-E613E377B9F8', 0, NULL, 0, 0, 0, 0, '', 0, 0, 0, 0, NULL),
(366, 37, 'preetanaik', '$2a$08$To1tIBXEurvwhm3S8suvR.njjGv.wj1fK0CyoXxP8VPrczOwhSsPC', 'naikpreeta@gmail.com', '', 0, 1, NULL, '137', '2018-06-07 13:10:43', NULL, NULL, 'preeta test', 'naik', 'analyst', 'atpl', '', 113, NULL, NULL, NULL, NULL, NULL, 343, 'All', NULL, '0000-00-00 00:00:00', 3, 2, 417, '2019-01-17 17:59:00', 417, '2019-01-17 17:59:00', '8C312206-E5D1-44D4-A9DA-4CBC3FF56382', 'ED62E3E0-9AD9-4F25-896C-3258FF98C9A7', 0, NULL, 1, 0, 0, 0, '', 0, 0, 0, 0, NULL),
(383, 1, 'prasadanalyst@aissel.com ', '$2a$08$iZfq9owg3S1zoXFNqVUJhOe6.SwoChbjrecCstYKy0LoqbkFvMPI6', 'prasadanalyst@aissel.com', '', 1, 2, NULL, '72', '2018-06-27 15:27:47', '358', '2019-01-14 15:44:02', 'Prasad', 'P', 'CEO', 'Aissel', '', 113, NULL, NULL, NULL, NULL, NULL, 383, 'All', NULL, '0000-00-00 00:00:00', 3, 0, NULL, NULL, NULL, NULL, 'F796FD16-A08C-44A6-B4A4-9F32C54454E6', '93321413-E025-4F5D-B1A2-BEABE84A7457', 0, NULL, 0, 0, 0, 0, '', 0, 0, 0, 0, NULL),
(401, 1, 'karthikk', '$2a$08$5b.AXvTdUq1byYDVTL6YUO0Vsj7gcq18/T/Sz.QEVDRVT2TE3mgBu', 'contentservice@aissel.com', '', 0, 2, NULL, '341', '2018-09-17 17:11:16', '358', '2019-01-14 15:38:00', 'Karthik', 'K', 'Manager', 'Aissel', '', 113, NULL, NULL, NULL, NULL, NULL, 401, 'All', NULL, '0000-00-00 00:00:00', 3, 0, NULL, NULL, NULL, NULL, '4B73BC59-6CEC-4361-8ABE-A1644E915F7A', '93114FF5-F55D-47B0-AD7A-864A3A050F8D', 0, NULL, 0, 0, 0, 0, '', 0, 0, 0, 0, NULL),
(404, 1, 'richardp@aissel.com', '$2a$08$tNTP6m.E7OBIimYIlo8.e.D6StxRkRxJbSzlRPylIAY.4V7Lgj39S', 'richardp@aissel.com', '', 1, 2, NULL, '120', '2018-10-04 12:59:13', '358', '2019-01-14 16:00:26', 'Richard', 'Peter', 'Senior Analyst - Customer Success', 'Aissel Technologies Pvt. Ltd.', '', 113, NULL, NULL, NULL, NULL, NULL, 404, 'All', NULL, '0000-00-00 00:00:00', 3, 1, NULL, NULL, 476, '2021-05-17 13:36:06', 'F907E822-4256-49CF-985E-C63EA9C9D8AB', 'C34A3991-9210-4727-B60B-2DE81065ABED', 0, NULL, 0, 0, 0, 0, '', 0, 0, 0, 0, NULL),
(407, 40, 'liteuser', '$2a$08$0hu7dHzA04cLGmgt2TMz8uSt4ItSlNfosXLsJ431D4ElvHOYKO21y', 'teenas2@aissel.com', '', 1, 1, NULL, '326', '2019-01-10 15:07:42', '438', '2020-12-23 17:37:00', 'lite', 'user', 'User', 'Aissel', '', 113, NULL, NULL, NULL, NULL, NULL, 422, 'All', NULL, '0000-00-00 00:00:00', 3, 0, NULL, NULL, NULL, NULL, '8BCC78A5-B692-4F94-92DB-AAE7AF925E13', 'EFBCD2AE-176C-4521-AA46-C7B73DABDD87', 0, NULL, 0, 0, 0, 0, '', 1, 0, 0, 0, NULL),
(408, 1, 'vivekanandn@aissel.com', '$2a$08$96XI/WOWFpIq2a8b74XQH.Eu0GNHlAjQv4uR1j9t3Q7g7bGvUFVYa', 'vivekanandn@aissel.com', '974376989', 1, 2, NULL, '326', '2019-01-10 17:14:03', '417', '2019-01-16 11:11:17', 'Vivek', 'N', 'Developer', 'ATPL', '', 113, NULL, NULL, NULL, NULL, NULL, 408, 'All', NULL, '0000-00-00 00:00:00', 3, 1, NULL, NULL, 436, '2020-05-28 10:23:41', '3FDA43A9-0AA4-4C4B-8418-174BC6EC0928', '697ED6AB-A06F-4D42-9D7C-83E392D56226', 0, NULL, 0, 0, 0, 0, '', 0, 0, 0, 0, NULL),
(8, '0', '0', 1, 'Sarah', 'Anne', 'Shaw', 'DO', 1, '', '0000-00-00', 'Female', 3837, NULL, '', '+19184886001', NULL, '6161 S Yale Ave', '', 10467, 158, 254, '74136-1902', '74136', '', '', '5101017367', '', '0', '', NULL, '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003012840', 2, 'Profiling', 0, '1003012840', NULL, 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2020-07-06 19:17:03'),
(9, '0', '0', 1, 'Shishir', '', 'Mathur', 'MD', 3, '', '0000-00-00', 'Male', 4283, NULL, '', '+18602583480', 'drshishirmathur@gmail.com', '1260 Silas Deane Hwy', '', 7658, 128, 254, '06109', '06109', '+18606335250', '', '047888', '', '0', '1003016957.jpeg', NULL, '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003016957', 2, 'Profiling', 0, '1003016957', NULL, 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2020-07-06 19:17:03'),
(10, '0', '0', 1, 'Rhea', 'Bettina', 'Sancassani', 'MD', 1, '', '0000-00-00', 'Female', 3622, NULL, '', '+17864668490', NULL, '1611 Nw 12 Ave', '', 1242, 131, 254, '33136-1005', '33136', '+13055736562', '', 'ME104462', '', '0', '1003017112.jpg', NULL, '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003017112', 2, 'Profiling', 0, '1003017112', NULL, 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2018-10-15 01:01:01'),
(11, '0', '0', 1, 'Cory', 'Michael Lee', 'Nitzel', 'MD', 1, '', '0000-00-00', 'Male', 1235, NULL, '', '+18056543306', NULL, '300 Hillmont Ave', '', 7501, 126, 254, '93003', '93003', '', '', '7676143-1205', '', '0', '', NULL, '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003017666', 2, 'Profiling', 0, '1003017666', NULL, 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2018-10-15 01:01:01'),
(12, '0', '0', 1, 'Joshua', 'Weber', 'Todd', 'MD', 3, '', '0000-00-00', 'Male', 2346, NULL, '', '+18655465111', NULL, '1819 W Clinch Ave', '', 10894, 164, 254, '37916-2435', '37916', '+18655414018', '', '47160', '', '0', '', NULL, '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003017963', 2, 'Profiling', 0, '1003017963', NULL, 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2020-07-06 19:17:03'),
(13, '0', '0', 1, 'Domenico', '', 'Calcaterra', 'MD', 2, '', '0000-00-00', 'Male', 24445, NULL, '', '+19412060325', 'dcalcaterra@iuhealth.org', '2815 S Seacrest Blvd', '', 13267, 131, 254, '33435-7969', '33435', '', '', '38062', '', '0', '', NULL, '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003018250', 2, 'Profiling', 0, '1003018250', NULL, 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2020-07-06 19:17:03'),
(14, '0', '0', 1, 'John', 'Joseph', 'Frank', 'MD', 1, '', '0000-00-00', 'Male', 3924, NULL, '', '+15412664650', NULL, '1960 N Ogden St', '', 7548, 127, 254, '80218-3668', '80218', '+15412664659', '', 'MD179649', '', '0', '', NULL, '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003019563', 2, 'Profiling', 0, '1003019563', NULL, 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2020-07-06 19:17:03'),
(15, '0', '0', 1, 'Scott', 'Eric', 'Henry', 'MD', 2, '', '0000-00-00', 'Male', 4831, NULL, '', '+16012688155', NULL, '5001 Hardy St', '', 9483, 146, 254, '39402', '39402', '', '', '40239', '', '0', '', NULL, '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003020561', 2, 'Profiling', 0, '1003020561', NULL, 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2020-07-06 19:17:03'),
(16, '0', '0', 1, 'Anand', '', 'Deshmukh', 'MD', 1, '', '0000-00-00', 'Male', 3432, NULL, '', '+14023542100', NULL, '1 Edmundson Pl', '', 8047, 137, 254, '51503-4620', '51503', '+14023542155', '', '24749', '', '0', '1003022708.jpg', NULL, '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003022708', 2, 'Profiling', 0, '1003022708', NULL, 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2020-07-06 19:17:03'),
(17, '0', '0', 1, 'Linda', '', 'Fong', 'MD', 1, '', '0000-00-00', 'Female', 4096, NULL, '', '+13108572463', NULL, '6041 Cadillac Ave', '', 7275, 126, 254, '90034-1702', '90034', '', '', 'A105777', '', '0', '', NULL, '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003027558', 2, 'Profiling', 0, '1003027558', NULL, 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2020-07-06 19:17:03'),
(18, '0', '0', 1, 'Neeraj', '', 'Mehta', 'MD', 1, '', '0000-00-00', 'Male', 1979, NULL, '', '+12056635775', NULL, '2022 Brookwood Med Ctr', 'Suite 412', 6845, 122, 254, '35209-2613', '35209', '+12056642112', '', '27910', '', '0', '', NULL, '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003029869', 2, 'Profiling', 0, '1003029869', NULL, 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2020-07-06 19:17:03'),
(19, '0', '0', 1, 'Mohamad', 'A', 'Sobh', 'DO, RPH', 3, '', '0000-00-00', 'Male', 17484, NULL, '', '+13132787100', NULL, '1611 Monroe St', '', 9050, 144, 254, '48124-2912', '48124', '+13135622216', '', '5302031496', '', '0', '', NULL, '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003030685', 2, 'Profiling', 0, '1003030685', NULL, 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2018-10-15 01:01:01'),
(20, '0', '0', 1, 'William', 'Randolph', 'Maddox', 'MD', 1, '', '0000-00-00', 'Male', 4615, NULL, '', '+12059344011', 'wmaddox@uabmc.edu', '619 19Th St S', '', 6845, 122, 254, '35233-1999', '35233', '+12052979411', '', 'RT000472', '', '0', '1003030693.jpg', NULL, '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003030693', 2, 'Profiling', 0, '1003030693', NULL, 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2020-07-06 19:17:03'),
(21, '0', '0', 1, 'Brian', 'Christopher', 'Cambi', 'MD', 1, '', '0000-00-00', 'Male', 3154, NULL, '', '+18606910619', NULL, '196 Pkwy S', 'Suite 103', 17731, 128, 254, '06385', '06385', '', '', '040303', '', '0', '', NULL, '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003033390', 2, 'Profiling', 0, '1003033390', NULL, 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2018-10-15 01:01:01'),
(22, '0', '0', 1, 'Charles', 'D', 'Resor', 'MD', 3, '', '0000-00-00', 'Male', 20946, NULL, '', '+16176365000', 'cresor@tuftsmedicalcenter.org', '800 Washington St', '', 8816, 143, 254, '02111', '02111', '', '', '263385', '', '0', '', NULL, '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003040676', 2, 'Profiling', 0, '1003040676', NULL, 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2020-07-06 19:17:03'),
(23, '0', '0', 1, 'Deirdre', 'Marie', 'Mooney', 'MD,MPH', 1, '', '0000-00-00', 'Female', 3614, '', '', '+18667472455', NULL, '122 W 7Th Ave', '', 11529, 168, 254, '99204-2339', '99204', '', '', 'WA: MD60742078,MT: 68396,ME: MD20449', '', '', 'f91d4221481ea29fc053eafcdbeff3e3.jpg', '', '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003041468', 2, 'Profiling', 0, '1003041468', '0', 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2020-07-06 19:17:03'),
(24, '0', '0', 0, 'Irfan', 'Ahmed', 'Warsy', 'MBBS', 6, '', '0000-00-00', 'Male', 14265, NULL, '', '+19145944370', NULL, '19 Bradhurst Ave', 'Ste 1400', 12978, 154, 254, '10532-2140', '10532', '+19145944513', '', '48712', '', '0', '', NULL, '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003041948', 2, 'Profiling', 0, '1003041948', NULL, 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2019-12-31 14:54:41'),
(25, '0', '0', 1, 'Mayank', 'Kumar', 'Mittal', 'MD', 3, '', '0000-00-00', 'Male', 390, NULL, '', '+15746471610', NULL, '610 N Michigan St', '', 8454, 136, 254, '46601-1081', '46601', '+15742376069', '', 'T2009005450', '', '0', '1003044702.jpeg', NULL, '', '', NULL, '', '', '', '11', '2018-10-15 01:01:01', '429', '2021-07-19 19:02:44', 1, 1, '1003044702', 2, 'Profiling', 0, '1003044702', NULL, 0.00, 'ACTV', 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '2020-07-06 19:17:03'),
HTML:
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
█ Format - .SQL
█ Size file - 15gb / packed 3.5gb
█ All rows - 30m lines / 380k leads
█ Website - Konectar.io
█ Date - 25.02.2023
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
Last edited:
if you can boss
