coldfrontdist.com
Aug 1, 2024
Internal data breach of Cold Front Distribution, a food/beverage distribution company operating across the US (including Schwan's products). Contains company employee rosters with full names, job titles, direct phone numbers, cell phones, and corporate email addresses across multiple regional divisions (Albuquerque, Denver, El Paso, Central, Midwest, Southeast Texas, West Texas, Mountain Routes). Also includes customer lists (Emil's master customer list), lease management database, and Schwan's route/customer/invoice data dating back to 2017. The company roster is dated August 2024, indicating the breach occurred around that time.
Data found in this dataset
Source files
Expand any file to inspect its column headers and the LLM's field-mapping reasoning, recorded during ingestion.
ColdFront__COMPANY_ROSTER_AUGUST_2024__Albuquerque.csv4 columns45 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 1 | firstName | high | [1] header 'First Name', values are common given names |
| 2 | lastName | high | [2] header 'Last Name', values are common surnames |
| 5 | phone | high | [5] header 'Number', values are 10-digit phone numbers with optional formatting |
| 6 | high | [6] header 'Company Email', values contain '@' and domain matches organization |
Notes: CSV with header row. Contains employee PII: first name, last name, direct phone, and corporate email. Other columns are organizational/departmental and skipped per rules.
ColdFront__COMPANY_ROSTER_AUGUST_2024__CENTRAL.csv1 column40 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 5 | high | unlabeled column — sampled values parse as email addresses |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__COMPANY_ROSTER_AUGUST_2024__Denver_Phone_Extensions.csv3 columns23 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 1 | firstName | high | [1] header 'First Name', values are common given names (Addy, Adel, Bob) |
| 2 | lastName | high | [2] header 'Last Name', values are common surnames (Cortez, Ortiz, Hill) |
| 4 | phone | high | [4] header 'Cell Phone', values are 10-digit US numbers (720/621-2598, 720/495-5707, 720/937-7784) |
Notes: Only columns 1 (firstName), 2 (lastName), and 4 (phone) contain PII. Columns 0, 3, 5-11 are internal company identifiers, job titles, or non-PII contact information (office lines, toll-free numbers, fax, email placeholder). No emails, DOB, SSN, or address fields are present in this sample.
ColdFront__COMPANY_ROSTER_AUGUST_2024__El_Paso.csv4 columns24 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 0 | firstName | high | [0] header 'First Name', values are common given names (Carlos, Frank, Alex, Pascual, Jose, Aaron, etc.) |
| 1 | lastName | high | [1] header 'Last Name', values are surnames (Rodriguez, Ramirez, Kreuzer, Barajas, etc.). Includes suffix like 'Jr' in some rows (e.g., 'Denney Jr') |
| 4 | phone | high | [4] header 'Contact Number', values are 10-digit phone numbers in formats 806/441-9574, 720/980-0544, 915-503-5397, etc. |
| 5 | high | [5] header 'Company Email', values are corporate email addresses with @coldfrontdist.com domain (crodriguez@coldfrontdist.com, frank.ramirez@coldfrontdist.com, etc.) |
Notes: Cold Front Distribution employee roster (El Paso division). Columns 2 (Route), 3 (Position) are job/operational data and skipped. Column indices: 0=firstName, 1=lastName, 2=route (skip), 3=position (skip), 4=phone, 5=email. Rows with 'OPEN' placeholder have missing PII and should be filtered. Some names contain generational suffixes (e.g., 'Denney Jr') embedded in lastName field.
ColdFront__COMPANY_ROSTER_AUGUST_2024__MIDWEST.csv1 column51 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 6 | emailText | high | free-text column with embedded emails (51/52 cells, 98% density) |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__COMPANY_ROSTER_AUGUST_2024__MTN_RTS_WHSE.csv1 column36 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 7 | emailText | high | free-text column with embedded emails (36/41 cells, 88% density) |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__COMPANY_ROSTER_AUGUST_2024__Managers_Leaders.csv42 rows
File structure
Notes: The provided rows are not in a structured tabular format. They appear to be free-form text with embedded names, phone numbers, and addresses across multiple lines. The format is inconsistent, and the rows have varying content and structure, indicating unstructured data rather than a CSV or similar format. The presence of phone numbers and names confirms this is a free-form text file with embedded PII.
ColdFront__COMPANY_ROSTER_AUGUST_2024__South_East_Texas.csv1 column8 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 5 | emailText | high | free-text column with embedded emails (8/9 cells, 89% density) |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__COMPANY_ROSTER_AUGUST_2024__West_Texas.csv1 column15 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 5 | emailText | high | free-text column with embedded emails (15/16 cells, 94% density) |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__Copy_of_Copy_of_Emils_master_customer_list_Complete_10-12-new__Breakout_2.csv4 columns1,000 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 3 | address1 | high | header "Street Address" resolves to PII field "address1" |
| 4 | city | high | header "City" resolves to PII field "city" |
| 5 | state | high | header "STATE" resolves to PII field "state" |
| 6 | phone | high | header "Phone" resolves to PII field "phone" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__Copy_of_Copy_of_Emils_master_customer_list_Complete_10-12-new__Customer_Name___Address.csv5 columns1,000 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 0 | fullName | high | header "Customer Name" resolves to PII field "fullName" |
| 1 | address1 | high | header "Street Address" resolves to PII field "address1" |
| 2 | city | high | header "City" resolves to PII field "city" |
| 3 | state | high | header "STATE" resolves to PII field "state" |
| 4 | phone | high | header "Phone" resolves to PII field "phone" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__Copy_of_Copy_of_Emils_master_customer_list_Complete_10-12-new__Fund_Raisers.csv1 column40 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 6 | phone | high | [6] column name 'Phone', values are 10-digit numbers with area codes and hyphens |
ColdFront__Copy_of_Copy_of_Emils_master_customer_list_Complete_10-12-new__On_Premise_.csv4 columns409 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 1 | address1 | high | header "Street Address" resolves to PII field "address1" |
| 2 | city | high | header "City" resolves to PII field "city" |
| 3 | state | high | header "STATE" resolves to PII field "state" |
| 4 | phone | high | header "Phone" resolves to PII field "phone" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__Copy_of_Copy_of_Emils_master_customer_list_Complete_10-12-new__Orginal_QB_List_Alphabetically.csv5 columns1,000 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 2 | fullName | high | header "Customer Name" resolves to PII field "fullName" |
| 3 | address1 | high | header "Street Address" resolves to PII field "address1" |
| 4 | city | high | header "City" resolves to PII field "city" |
| 5 | state | high | header "STATE" resolves to PII field "state" |
| 6 | phone | high | header "Phone" resolves to PII field "phone" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__Copy_of_Copy_of_Emils_master_customer_list_Complete_10-12-new__Orginal_QB_List_By__.csv5 columns1,000 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 2 | fullName | high | header "Customer Name" resolves to PII field "fullName" |
| 3 | address1 | high | header "Street Address" resolves to PII field "address1" |
| 4 | city | high | header "City" resolves to PII field "city" |
| 5 | state | high | header "STATE" resolves to PII field "state" |
| 6 | phone | high | header "Phone" resolves to PII field "phone" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__Copy_of_Copy_of_Emils_master_customer_list_Complete_10-12-new__Portesi_Costumers_.csv5 columns114 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 1 | fullName | high | header "Customer Name" resolves to PII field "fullName" |
| 2 | address1 | high | header "Street Address" resolves to PII field "address1" |
| 3 | city | high | header "City" resolves to PII field "city" |
| 4 | state | high | header "STATE" resolves to PII field "state" |
| 5 | phone | high | header "Phone" resolves to PII field "phone" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__Copy_of_Copy_of_Emils_master_customer_list_Complete_10-12-new__Retail.csv5 columns322 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 1 | address1 | high | header "Street Address" resolves to PII field "address1" |
| 2 | city | high | header "City" resolves to PII field "city" |
| 3 | state | high | header "STATE" resolves to PII field "state" |
| 4 | zip | high | header "ZIP" resolves to PII field "zip" |
| 5 | phone | high | header "Phone" resolves to PII field "phone" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__Emils_Master_Customer_List-10-11-22__Breakout_2.csv4 columns1,000 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 3 | address1 | high | header "Street Address" resolves to PII field "address1" |
| 4 | city | high | header "City" resolves to PII field "city" |
| 5 | state | high | header "STATE" resolves to PII field "state" |
| 6 | phone | high | header "Phone" resolves to PII field "phone" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__Emils_Master_Customer_List-10-11-22__Customer_Name___Address.csv5 columns1,000 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 0 | fullName | high | header "Customer Name" resolves to PII field "fullName" |
| 1 | address1 | high | header "Street Address" resolves to PII field "address1" |
| 2 | city | high | header "City" resolves to PII field "city" |
| 3 | state | high | header "STATE" resolves to PII field "state" |
| 4 | phone | high | header "Phone" resolves to PII field "phone" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__Emils_Master_Customer_List-10-11-22__Fund_Raisers.csv1 column40 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 6 | phone | high | [6] header 'Phone', values are 10-digit numbers with area codes |
Notes: CSV file with 10 columns. Only column 6 (Phone) contains PII (phone numbers). Other columns contain organization names, addresses, cities, states, comments, and status — no personal identifiers beyond phone numbers.
ColdFront__Emils_Master_Customer_List-10-11-22__On_Premise_.csv4 columns409 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 1 | address1 | high | header "Street Address" resolves to PII field "address1" |
| 2 | city | high | header "City" resolves to PII field "city" |
| 3 | state | high | header "STATE" resolves to PII field "state" |
| 4 | phone | high | header "Phone" resolves to PII field "phone" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__Emils_Master_Customer_List-10-11-22__Orginal_QB_List_Alphabetically.csv5 columns1,000 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 2 | fullName | high | header "Customer Name" resolves to PII field "fullName" |
| 3 | address1 | high | header "Street Address" resolves to PII field "address1" |
| 4 | city | high | header "City" resolves to PII field "city" |
| 5 | state | high | header "STATE" resolves to PII field "state" |
| 6 | phone | high | header "Phone" resolves to PII field "phone" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__Emils_Master_Customer_List-10-11-22__Orginal_QB_List_By__.csv5 columns1,000 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 2 | fullName | high | header "Customer Name" resolves to PII field "fullName" |
| 3 | address1 | high | header "Street Address" resolves to PII field "address1" |
| 4 | city | high | header "City" resolves to PII field "city" |
| 5 | state | high | header "STATE" resolves to PII field "state" |
| 6 | phone | high | header "Phone" resolves to PII field "phone" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__Emils_Master_Customer_List-10-11-22__Portesi_Costumers_.csv5 columns114 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 1 | fullName | high | header "Customer Name" resolves to PII field "fullName" |
| 2 | address1 | high | header "Street Address" resolves to PII field "address1" |
| 3 | city | high | header "City" resolves to PII field "city" |
| 4 | state | high | header "STATE" resolves to PII field "state" |
| 5 | phone | high | header "Phone" resolves to PII field "phone" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__Emils_Master_Customer_List-10-11-22__Retail.csv5 columns333 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 1 | address1 | high | header "Street Address" resolves to PII field "address1" |
| 2 | city | high | header "City" resolves to PII field "city" |
| 3 | state | high | header "STATE" resolves to PII field "state" |
| 4 | zip | high | header "ZIP" resolves to PII field "zip" |
| 5 | phone | high | header "Phone" resolves to PII field "phone" |
Notes: Heuristic auto-detection: header-named PII columns confirmed by data conformance
ColdFront__Lease_Back_End_All_Tables.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: All provided rows are structured tables containing business/contract data (asset types, chart of accounts, divisions, filters, lessors, branches, leases). No PII fields (names, emails, phone numbers, etc.) appear in the visible data. The rows are purely organizational/financial metadata with no personal identifiers.
ColdFront__Lease_Back_End_CSV__AssetType.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This is not structured data with PII columns. The sample shows only asset type records (Auto, Building, Equipment, Delivery Vehicles) with descriptions and a flag column. There are no columns containing personal identifiable information (PII) such as names, emails, phone numbers, addresses, etc. The data appears to be an inventory/asset listing, not a roster or customer list.
ColdFront__Lease_Back_End_CSV__Branches.csv0 rows
ColdFront__Lease_Back_End_CSV__ChartOfAccount.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This is purely an accounting/lease structure file with no personal or identifiable data. Columns contain only account codes, lease classifications, and financial categories. No PII fields present.
ColdFront__Lease_Back_End_CSV__Divisions.csv2 columns0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 4 | fullName | high | [4] header 'ContactPerson', values are full names |
| 5 | skip | high | [5] header 'Email', values contain '@' |
Notes: Only columns 4 (ContactPerson) and 5 (Email) contain PII. Other columns are internal IDs, division codes, job titles, and phone numbers that are empty in the sample rows.
ColdFront__Lease_Back_End_CSV__Filters.csv0 rows
File structure
Notes: This is a configuration/metadata file describing filters for a lease list, not actual data records. It contains filter definitions and does not include any personal identifiable information (PII) in the rows provided. Therefore, no columns map to PII fields.
ColdFront__Lease_Back_End_CSV__Leases.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: No PII fields detected in the first 50 rows. The data appears to be purely financial/lease management records (dates, amounts, lease terms, asset classifications). All columns contain transaction metadata, vehicle IDs, accounting codes, and payment schedules — no names, addresses, emails, phones, or other personal identifiers.
ColdFront__Lease_Back_End_CSV__Lessors.csv2 columns0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 3 | fullName | high | [3] header 'ContactPerson', values are full names |
| 4 | skip | high | [4] header 'Email', contains valid email addresses |
Notes: Columns 5-8 are labeled 'JobTitle', 'OfficePhoneNumber', 'MobilePhoneNumber', and 'Other Information' but appear empty in all sample rows. If future rows contain values, they should be mapped as: JobTitle (skip), OfficePhoneNumber (phone), MobilePhoneNumber (phone), Other Information (skip).
ColdFront__Lease_Back_End_CSV__Property.csv0 rows
ColdFront__Lease_Back_End_CSV__Settings.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This file is purely internal accounting data. All columns represent internal identifiers (ID), flags (ShowWelcome), currency codes (RepC), percentages (TermMajor, ValueSubAll, DiscountRate), period codes (PeriodR), and fiscal year configuration. No personal or customer data is present. All columns are marked as skip per exclusion rules (internal IDs, flags, financial/transactional data).
ColdFront__SchwansCustomerList7.28.17__Sheet1.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This file contains only store identifiers and flags — no PII present. CustomerID appears to be store codes (e.g., KS012, CM401) and CustomerName contains store names/brand identifiers (e.g., KING SOOPERS, CITY MARKET, WALMART #0549). No personal names, addresses, emails, or other PII fields are present in the visible data.
ColdFront__Schwans_Backup_CSV__RouteDetails.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: No PII columns detected. The file contains only internal IDs (CustomerID, HH_Rt#, RtDetailID) and a timestamp. These are all non-personal identifiers or timestamps, and no emails, names, addresses, phone numbers, or other PII are present in the sample.
ColdFront__Schwans_Backup_CSV__SalesmanIDwithRoute.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This is a pure internal route/sales management file with no personal identifiers. Columns contain only internal codes (route numbers, salesman IDs) and start dates. No email addresses, phone numbers, names, or other PII appear in the sample. All columns map to skip per exclusion rules (internal IDs, counters).
ColdFront__Schwans_Backup_CSV__SalesmanTables.csv2 columns0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 0 | firstName | high | Header 'FName' maps to firstName, values are common given names |
| 1 | lastName | high | Header 'LName' maps to lastName, values are common surnames |
Notes: Only firstName and lastName columns contain PII; SalesmanID and SalesmanCommissionRate are internal identifiers and commission data, respectively, and are skipped per rules
ColdFront__Schwans_Backup_CSV___TMPCLP358751.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: no·Quote: "
Notes: The provided sample shows an error row rather than actual data. The row contains only error messages and field names without any PII values. Since no valid data rows are present to analyze column mappings, no PII columns can be identified. The file appears to be an error log rather than the actual breach data file.
ColdFront__Schwans_Backup_CSV__tblCustomerList.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: No PII columns detected. The file contains only customer IDs and store names, which are not personally identifiable information. The values are store identifiers (e.g., 'ALBERTSONS #2837') and boolean flags, none of which map to any PII fields. All columns are marked as skip per exclusion rules for company/business data and internal flags.
ColdFront__Schwans_Backup_CSV__tblInvoiceTracking.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: No PII fields detected. All columns appear to be internal identifiers, dates, monetary values, and notes — none map to email, phone, name, address, DOB, SSN, password, username, or other PII categories. The 'Notes' column contains only the string 'NO DEX' and empty values. This is purely transactional/invoice data.
ColdFront__Schwans_Backup_CSV__tblLoc-Acct_.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: no·Quote: "
Notes: This file contains only two columns: Loc# and DSD_Cust#. Both appear to be internal identifiers or codes (likely location and customer codes) with no personal information. There are no PII fields present in this sample. The values are numeric codes with no names, addresses, emails, or other identifiable data.
ColdFront__Schwans_Backup_CSV__tblRoute_s_Names.csv0 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
Notes: This file contains only route/division identifiers, house route numbers, commission rates, and location numbers. No PII fields are present. All columns map to skip categories (internal route IDs, business divisions, commission rates, location codes).