Northwestern Medecine [NO CREDITS]
by - Thursday, January 1, 1970 at 12:00 AM
Breached in April 2021, i don't know who leaked it tho.
317 lines of the following:

`id` int(11) NOT NULL AUTO_INCREMENT,
  `mdm_id` varchar(255) DEFAULT NULL,
  `aissel_id` varchar(255) DEFAULT NULL,
  `salutation` tinyint(3) NOT NULL,
  `first_name` varchar(250) NOT NULL,
  `middle_name` varchar(250) DEFAULT NULL,
  `last_name` varchar(250) NOT NULL,
  `suffix` varchar(250) DEFAULT NULL,
  `specialty` int(11) NOT NULL,
  `sub_specialty` varchar(50) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `gender` varchar(6) NOT NULL,
  `org_id` int(11) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `division` varchar(250) DEFAULT NULL,
  `primary_phone` varchar(25) DEFAULT NULL,
  `primary_email` varchar(250) DEFAULT NULL,
  `address1` varchar(255) NOT NULL,
  `address2` varchar(255) NOT NULL,
  `city_id` int(5) NOT NULL,
  `state_id` int(5) NOT NULL,
  `country_id` int(5) NOT NULL,
  `postal_code` varchar(50) NOT NULL,
  `fax` varchar(15) DEFAULT NULL,
  `research_interests` mediumtext NOT NULL,
  `license` varchar(50) DEFAULT NULL,
  `biography` mediumtext NOT NULL,
  `notes` mediumtext,
  `profile_image` varchar(255) DEFAULT NULL,
  `url` mediumtext,
  `blog` mediumtext,
  `linked_in` mediumtext,
  `facebook` mediumtext,
  `twitter` mediumtext,
  `myspace` mediumtext,
  `you_tube` mediumtext,
  `created_by` varchar(40) NOT NULL,
  `created_on` datetime NOT NULL,
  `modified_by` varchar(40) DEFAULT NULL,
  `modified_on` datetime DEFAULT NULL,
  `is_pubmed_processed` tinyint(1) DEFAULT NULL,
  `is_clinical_trial_processed` tinyint(1) NOT NULL,
  `pin` varchar(50) NOT NULL DEFAULT '0',
  `is_imported` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(255) DEFAULT NULL,
  `approved_by` int(11) DEFAULT NULL,
  `npi_num` varchar(255) DEFAULT NULL,
  `profile_type` varchar(255) DEFAULT NULL,
  `asmt_score` float(10,2) DEFAULT NULL,
  `customer_status` varchar(100) DEFAULT 'ACTV',
  `fma_speciality_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `additional_role_id` int(11) DEFAULT NULL,
  `speaker_id` int(11) DEFAULT NULL,
  `degree_id` int(11) DEFAULT NULL,
  `patients_range` varchar(255) DEFAULT NULL,
  `compliance_flag` tinyint(1) DEFAULT NULL,
  `is_kol` tinyint(1) DEFAULT NULL,
  `profile_from` varchar(255) DEFAULT NULL,
  `is_speaker` tinyint(1) NOT NULL,
  `is_duplicate_case` tinyint(1) NOT NULL,
  `extra_json_data` blob,

Here the link: https://a.pomf.cat/hzgrtl.7z
Reply
What is the name of the database?
Reply
@Meleagant, thanks for sharing.

@GG44bb, it's just a small MySQL dump (114 MB uncompressed). Name of database is org_kols_parsing_dev according to line 3 of file. Domain appears to be nm.org.
Bottom of file says: "Dump completed on 2017-10-27"
Reply
Jah bless, handful of emails but could be good leads
Reply
The link in this thread is dead. Please reply to the PM you were sent to get your thread moved back to the Databases section.
https://baph.is | Telegram: @enemy

Reply
Hello,

The link on this thread has been updated as of this post.
https://baph.is | Telegram: @enemy

Reply


 Users viewing this thread: Northwestern Medecine [NO CREDITS]: No users currently viewing.