Page 1 PreviewSample US Customers Mock Dataset CSV (100 Rows)
Download a clean mock dataset of 100 US customers in CSV format. Realistic names, emails, addresses, and dates for SQL testing and seeding.
Template Highlights & Included Features
100 Clean Mock Records
Pre-populated with realistic, synthetically generated customer demographics without containing any personally identifiable real-world information (PII).
15 Rich Data Attributes
Includes Customer_ID, First_Name, Last_Name, Email, Phone, Company, Job_Title, Street, City, State, ZIP, Country, Balance, Status, and Created_Date.
Standard RFC 4180 CSV Compliant
UTF-8 encoded with clean comma delimiters and proper quote escaping for seamless import into SQL databases and analytical tools.
Ideal for QA Testing & Database Seeding
Perfect for testing CRM migrations, data pagination, search indexing, machine learning pipelines, and SQL join queries.
When building software, developing relational database schemas, or testing CRM integrations, having clean, realistic dummy data is essential. Using production data in staging environments introduces severe compliance and privacy risks under GDPR and CCPA. This Sample US Customers Mock Dataset (.csv) gives engineers, database administrators, and data analysts an immediate, ready-to-use tabular dataset.
Dataset Schema & Field Descriptions
The CSV file contains 100 rows and 15 standard fields structured as follows:
| Column Header | Data Type | Example Value | Description |
|---|---|---|---|
Customer_ID | String | CUST-1001 | Unique primary key identifier |
First_Name | String | James | Customer given name |
Last_Name | String | Smith | Customer family surname |
Email | String | james.smith1@example.com | Standard formatted test email |
Phone | String | +1 (555) 101-2017 | Standard North American format |
Company | String | Apex Digital | Associated employer or business |
Job_Title | String | Software Engineer | Professional role title |
Street_Address | String | 104 Elm Street, Suite 1 | Primary mailing address |
City | String | New York | Standard US metropolitan city |
State | String (2-Char) | NY | Two-letter state postal abbreviation |
Postal_Code | String | 10001 | 5-digit US ZIP code |
Country | String | United States | Country of residence |
Account_Balance_USD | Decimal | 1324.50 | Numerical financial balance |
Customer_Status | Enum | Active / Pending | Operational account status |
Created_Date | Date (ISO 8601) | 2026-04-12 | Account creation timestamp |
Common Use Cases
- PostgreSQL & MySQL Database Seeding: Populate your local development database with realistic foreign keys and customer balances in one click.
- Frontend UI Pagination & Sorting: Test search bars, table column sort orders, and mobile responsive card layouts with realistic name lengths.
- Data Science & Python Pandas: Practice writing pandas filtering, groupby aggregations, and data visualization scripts without needing an API key.
- CRM Import Testing: Verify that your Hubspot, Salesforce, or custom CRM mapping matches expected column headers prior to live customer migration.