Posted by: IXXXI
Date: Wednesday, July 31, 2024
Category: Data Breach
A significant data breach involving Sun West Mortgage Company (swmc.com) has been disclosed by user IXXXI on an online forum. The breach involves extensive details on mortgage leads and broker users, with the database containing 6 million lines of data and a total size of 2.3 GB.
Breach Details
Data Format and Size:
- Format: SQL
- Size: 2.3 GB
- Lines in File: 6 million lines
SQL Table Details:
The provided SQL queries indicate the following data has been compromised:
- Mortgage Leads Data:
INSERT INTO `pop_mlo_leads` (
`lead_id`, `active`, `date_added`, `recruiter_name`, `created_by`, `lead_first_name`, `lead_last_name`,
`company`, `position_title`, `campaign`, `lead_source`, `priority`, `assigned_on`, `street_address`,
`city`, `state`, `zip`, `alternate_city`, `alternate_st`, `alternate_zip`, `address_3`, `address_4`,
`address_5`, `home_phone`, `alt_home_phone`, `work_phone`, `work_ext`, `mobile_phone`, `mobile_phone_2`,
`mobile_phone_3`, `mobile_phone_4`, `email_address`, `alternate_email`, `fax`, `website`, `facebook_url`,
`linkedin_url`, `twitter_url`, `nmls_id`, `rev_mtg_units`, `refi_loan_units`, `purchase_loan_units`,
`loan_volume_7_month`, `loan_volume_14_month`, `transactions_14`, `conv_loan_units`, `fha_loan_units`,
`va_loan_units`, `calling_assigned_to`, `calling_assigned_on`, `remark_home_phone`, `remark_alt_home_phone`,
`remark_work_phone`, `remark_mobile_phone`, `remark_mobile_phone_2`, `remark_mobile_phone_3`,
`remark_mobile_phone_4`, `remark_alternate_email`, `do_not_solicit`, `do_not_solicit_reason`, `lead_type`,
`broker_code`, `package_sent_date`, `package_received_date`, `broker_approval_status`,
`broker_package_signing_authority_email`, `GNMA_approved`, `FNMA_approved`, `FreddieMac_approved`,
`cold_calling`, `CRM`, `CRM_added_date`, `CRM_update_date`, `hash_key`
) VALUES- Broker Users Data:
INSERT INTO `broker_users` (
`id`, `first_name`, `last_name`, `TYPE`, `email`, `company_code`, `company_name`, `crm_first_name`,
`crm_last_name`, `crm_email`, `crm_phone_num`, `created_at`, `updated_at`, `ss_id`
) VALUES
