Use case · 12 files
Test data pipelines
The same fake customer dataset in the formats data pipelines exchange, at sizes from quick smoke tests to about a million rows.
Download all with curl
# 12 files, 106 MB in total
while read -r url; do curl -LO --fail "$url"; done <<'EOF'
https://files.samplefiles.com/data/parquet/sample-1k-rows.parquet
https://files.samplefiles.com/data/parquet/sample-1m-rows.parquet
https://files.samplefiles.com/data/ndjson/sample-100k-records.ndjson
https://files.samplefiles.com/data/sqlite/sample-100k-rows.sqlite
https://files.samplefiles.com/data/sql/sample-10k-rows.sql
https://files.samplefiles.com/data/json/sample-10k-records.json
https://files.samplefiles.com/data/json/sample-orders-nested.json
https://files.samplefiles.com/data/json/sample-types.json
https://files.samplefiles.com/data/xml/sample-orders-nested.xml
https://files.samplefiles.com/archive/gz/sample-10k-rows.csv.gz
https://files.samplefiles.com/archive/bz2/sample-10k-rows.csv.bz2
https://files.samplefiles.com/archive/xz/sample-10k-rows.csv.xz
EOFRead first: CSV vs JSON vs Parquet: choosing a data format
Columnar and line-delimited
For Spark, DuckDB, pandas, BigQuery and Elasticsearch.
| File | Size | Details | Download |
|---|---|---|---|
| Parquet, 1,000 rowssample-1k-rows.parquet | 74.7 KB | 1,000 rows | Download |
| Parquet, 1,000,000 rowssample-1m-rows.parquet | 38.3 MB | 1,000,000 rows | Download |
| NDJSON, 100,000 recordssample-100k-records.ndjson | 30.4 MB | 100,000 rows | Download |
Databases
SQLite databases with related tables, and portable SQL dumps.
| File | Size | Details | Download |
|---|---|---|---|
| SQLite database, 100,000 customerssample-100k-rows.sqlite | 30.7 MB | 100,000 rows | Download |
| SQL dump, 10,000 rowssample-10k-rows.sql | 1.8 MB | 10,000 rows | Download |
JSON and XML
Flat and nested records.
| File | Size | Details | Download |
|---|---|---|---|
| JSON, 10,000 recordssample-10k-records.json | 3.5 MB | 10,000 rows | Download |
| JSON with nested objects and arrayssample-orders-nested.json | 86 KB | 100 rows | Download |
| JSON with every data typesample-types.json | 592 B | Download | |
| XML with namespaces and nested elementssample-orders-nested.xml | 35.6 KB | 50 rows | Download |
Compressed exports
The same CSV compressed three ways, as data exports are often delivered.
| File | Size | Details | Download |
|---|---|---|---|
| GZ-compressed CSVsample-10k-rows.csv.gz | 511 KB | 1 entry | Download |
| BZ2-compressed CSVsample-10k-rows.csv.bz2 | 275 KB | 1 entry | Download |
| XZ-compressed CSVsample-10k-rows.csv.xz | 321 KB | 1 entry | Download |