Consumer Complaint Database

Insights and Trends in Consumer Grievances

@kaggle.kirbysasuke_consumer_complaints

Table List

1 table(1.02 GB)

Complaints

@kaggle.kirbysasuke_consumer_complaints.complaints

1.02 GB
5550542 rows
18 columns

date_received Date Received	product Product	sub_product Sub-product	issue Issue	sub_issue Sub-issue	consumer_complaint_narrative Consumer Complaint Narrative	company_public_response Company Public Response	company Company	state State	zip_code ZIP Code	tags Tags	consumer_consent_provided Consumer Consent Provided?	submitted_via Submitted Via	date_sent_to_company Date Sent To Company	company_response_to_consumer Company Response To Consumer	timely_response Timely Response?	consumer_disputed Consumer Disputed?	complaint_id Complaint ID
Sat Jun 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting or other personal consumer reports	Credit reporting	Improper use of your report	Reporting company used your report improperly	nan	nan	TRANSUNION INTERMEDIATE HOLDINGS, INC.	TX	77356	nan	nan	Web	Sat Jun 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	9381862
Thu Jun 27 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting or other personal consumer reports	Credit reporting	Incorrect information on your report	Account status incorrect	nan	Company has responded to the consumer and the CFPB and chooses not to provide a public response	Sa-Vit Enterprises, Inc.	NJ	083XX	nan	nan	Web	Thu Jun 27 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	nan	9362867
Sat Jun 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting or other personal consumer reports	Credit reporting	Incorrect information on your report	Information belongs to someone else	nan	nan	EQUIFAX, INC.	GA	30260	nan	nan	Web	Sat Jun 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	9381866
Sat Jun 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting or other personal consumer reports	Credit reporting	Problem with a company's investigation into an existing problem	Their investigation did not fix an error on your report	nan	nan	TRANSUNION INTERMEDIATE HOLDINGS, INC.	GA	30102	nan	nan	Web	Sat Jun 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	9381868
Sat Jun 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting or other personal consumer reports	Credit reporting	Incorrect information on your report	Information belongs to someone else	nan	nan	Experian Information Solutions Inc.	FL	33594	nan	nan	Web	Sat Jun 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	9381951
Thu Jun 27 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting or other personal consumer reports	Other personal consumer report	Problem with a company's investigation into an existing issue	Problem with personal statement of dispute	nan	nan	McCalla Raymer Leibert Pierce, LLC	SC	29707	nan	nan	Web	Thu Jun 27 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	nan	9362932
Thu Jun 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting or other personal consumer reports	Credit reporting	Problem with a company's investigation into an existing problem	Their investigation did not fix an error on your report	nan	nan	Experian Information Solutions Inc.	GA	30318	nan	nan	Web	Thu Jun 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	9255254
Thu Jun 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting or other personal consumer reports	Credit reporting	Problem with a company's investigation into an existing problem	Investigation took more than 30 days	nan	nan	Experian Information Solutions Inc.	NC	28208	nan	nan	Web	Thu Jun 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	9255722
Sat Jun 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting or other personal consumer reports	Credit reporting	Improper use of your report	Credit inquiries on your report that you don't recognize	nan	nan	Experian Information Solutions Inc.	MA	02155	nan	nan	Web	Sat Jun 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	9270555
Thu Jun 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting or other personal consumer reports	Credit reporting	Unable to get your credit report or credit score	Other problem getting your report or credit score	nan	nan	Experian Information Solutions Inc.	FL	33908	nan	nan	Web	Thu Jun 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	9255565


CREATE TABLE complaints (
  "date_received" TIMESTAMP,
  "product" VARCHAR,
  "sub_product" VARCHAR,
  "issue" VARCHAR,
  "sub_issue" VARCHAR,
  "consumer_complaint_narrative" VARCHAR,
  "company_public_response" VARCHAR,
  "company" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "tags" VARCHAR,
  "consumer_consent_provided" VARCHAR,
  "submitted_via" VARCHAR,
  "date_sent_to_company" TIMESTAMP,
  "company_response_to_consumer" VARCHAR,
  "timely_response" VARCHAR,
  "consumer_disputed" VARCHAR,
  "complaint_id" BIGINT
);