datasets real and made-up data to practise on

Datasets

Data for the Playground, Database Lab and Performance Lab. Pick one and open its files.

dataset

size

Real complaints people sent the U.S. CFPB in 2024 about credit reports, debt collection and banks.

600 complaints1 tableJan 2024 – Dec 2024

what to watch for

Tricky rows

files

Open a file to see what one row means, its columns and a preview. Open in Playground starts a new file there with code that loads it.

complaints600 rows · 15 columns · CSV

One complaint, as the CFPB published it. Most are about credit reports, as in the full database.

In your code: data/complaints.csv

complaint_idintegerkey
CFPB complaint ID
date_receivedtimestamp
When the CFPB received it (date and time as text, UTC)
producttext
Financial product
sub_producttext · can be empty
More specific product
issuetext
What went wrong
sub_issuetext · can be empty
More specific issue
companytext
Company the complaint is about
statetext · can be empty
Consumer’s state
zip_codetext · can be empty
Consumer’s ZIP code; partly masked for small areas
tagstext · can be empty
Older American and/or Servicemember
submitted_viatext
Web, Phone, Referral, …
date_sent_to_companytimestamp
When the CFPB sent it to the company (date and time as text, UTC)
company_responsetext
How the company closed it
company_public_responsetext · can be empty
Company’s optional public statement
timelytext
Yes if the company responded within 15 days

data/complaints.jsonl600 records · JSON Lines

One complaint, as the CFPB published it. Most are about credit reports, as in the full database.

In your code: data/complaints.jsonl

data/api/complaints-2024-01-15.json600 records · JSON

One complaint, as the CFPB published it. Most are about credit reports, as in the full database.

In your code: data/api/complaints-2024-01-15.json