guns.com
Jan 4, 2021
Database backup from an online firearms retailer (likely Guns.com or a similar platform) containing order-to-FFL (Federal Firearms Licensee) transfer records. Data includes FFL license numbers, FFL dealer names, order IDs, transfer statuses (contact_ffl, confirmed_ffl, canceled_ffl), and timestamps. Records date from February 2019 onward. The backup filename suggests it was taken on January 4, 2021.
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.
guns-backup-0104_2021__order_ffl.csv2 columns84,900 rows
File structure
Format: CSV·Delimiter: comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 4 | fullName | high | [4] values are business names, but some entries contain personal names like "DUBIN, RICHARD B", indicating mixed usage. However, given the context of FFL transfers, it's more likely to represent dealer names rather than personal PII. Thus, mapped as skip per exclusion rules for company/business fields. |
| 5 | skip | high | [5] column named 'message' contains internal notes like 'selected-in-error' or 'no-store-front', clearly non-PII metadata |
Notes: File contains FFL transfer records. All columns with business/dealer names (ffl_name) are excluded per company/business rule. No personal PII fields (email, phone, dob, etc.) appear in the first 50 rows.