CFPB Consumer Complaint Database
Product type
Dataset
Update frequency
Daily
Updated
Jun 7, 2023
Delivery method
Download
Metadata is available for each file version of the dataset. A JSON file can be downloaded once you subscribe to the dataset. The information below is an example of the metadata included in each JSON file.
Dataset file name: complaints-csv.zip
Key Statistics
Total records
2,190,954
Missing values
1%
Duplicate rows
0%
Columns
Columns
18
Categorical
6
Numeric
1
Date/time
2
Column name | Type | Unique values | Min value | Max value |
|---|---|---|---|---|
Complaint ID | numeric | 2,190,954 | 1 | 4575796 |
State | categorical | 64 | 2 | 36 |
ZIP code | categorical | 25,130 | 3 | 5 |
Tags | categorical | 4 | 3 | 29 |
Submitted via | categorical | 6 | 3 | 11 |
Timely response? | categorical | 2 | 2 | 3 |
Consumer disputed? | categorical | 3 | 2 | 3 |
Product | text | 18 | 8 | 76 |
Sub-product | text | 77 | 3 | 42 |
Issue | text | 165 | 4 | 80 |
Sub-issue | text | 222 | 3 | 85 |
Company | text | 6,088 | 3 | 88 |
Company public response | text | 12 | 3 | 119 |
Consumer consent provided? | text | 5 | 3 | 20 |
Consumer complaint narrative | text | 684,065 | 3 | 32317 |
Company response to consumer | text | 9 | 3 | 31 |
Date received | date | 3,525 | 2011-12-01 | 2021-07-26 |
Date sent to company | date | 3,474 | 2011-12-01 | 2021-07-26 |