vivekkopthsd/cfpb-consumer-complaints
CFPB Consumer Complaint Database (mirror) Official public-domain bulk export of the Consumer Financial Protection Bureau Consumer Complaint Database, mirrored for fast, stable programmatic access. Files File Size Description complaints.csv.zip 1.41 GB Raw bulk export exactly as published by the CFPB (single member complaints.csv, 9.09 GB, 17,021,062 rows) complaints.parquet 1.02 GB Typed, column-pruned parquet (ZSTD) of the same 17,021,062 rows; 16… See the full description on the dataset page: https://huggingface.co/datasets/vivekkopthsd/cfpb-consumer-complaints.
CFPB Consumer Complaint Database (mirror)
Official public-domain bulk export of the Consumer Financial Protection Bureau Consumer Complaint Database, mirrored for fast, stable programmatic access.
Files
Provenance
- Source: https://files.consumerfinance.gov/ccdb/complaints.csv.zip
- Observation period: 2011-12-01 → 2026-08-11 (as-of date of this export)
- License: US federal government work, public domain (CC0-1.0)
- Rows: 17,021,062
sha256
d92239489715c816fa4fc77a27324878cfc88de5b417065ea185e80ac92a6658 complaints.csv.zip
6e0a76bea4a9f5481aba4f895e5fa8f9a55df0751969971035637954c0a8067d complaints.parquetColumns
date_received (DATE) · product · sub_product · issue · sub_issue · narrative (Consumer complaint narrative) · company · company_public_response · state · zip_code · tags · submitted_via · date_sent_to_company (DATE) · company_response (Company response to consumer) · timely_response · complaint_id
Notes
narrativeis present for ~22.5% of rows (3,835,352) — a self-selected subset.- The bulk export no longer contains the
Consumer disputed?field that existed in earlier schema versions; the closest outcome proxy iscompany_response. complaints.parquetwas built with pandas chunked reads (the CFPB CSV has quoted narrative fields that confuse DuckDB's CSV sniffer) and is intended to be queried with DuckDB.
Regenerate
# from the CFPB mirror, rebuild the parquet
unzip -p complaints.csv.zip complaints.csv | python -m build_parquet # see source project