Consumer Complaint Database

Consumer Complaint Database of financial products and services

@kaggle.utkarshx27_consumer_complaint

Table List

1 table(729.69 MB)

Complaints

@kaggle.utkarshx27_consumer_complaint.complaints

729.69 MB
3585952 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
Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting, credit repair services, or other personal consumer reports	Credit reporting	Incorrect information on your report	Information belongs to someone else	nan	nan	EQUIFAX, INC.	GA	30308	nan	Other	Web	Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	6896105
Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting, credit repair services, or other personal consumer reports	Credit reporting	Incorrect information on your report	Information belongs to someone else	nan	nan	EQUIFAX, INC.	PA	19145	nan	nan	Web	Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	6896026
Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting, credit repair services, or other personal consumer reports	Credit reporting	Problem with a credit reporting company's investigation into an existing problem	Their investigation did not fix an error on your report	nan	nan	EQUIFAX, INC.	PA	19111	nan	nan	Web	Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	6896030
Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting, credit repair services, or other personal consumer reports	Credit reporting	Incorrect information on your report	Information belongs to someone else	nan	nan	EQUIFAX, INC.	TX	78725	nan	nan	Web	Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	6896035
Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting, credit repair services, or other personal consumer reports	Credit reporting	Improper use of your report	Reporting company used your report improperly	nan	nan	EQUIFAX, INC.	NY	11233	nan	nan	Web	Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	6896060
Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting, credit repair services, or other personal consumer reports	Credit reporting	Problem with a credit reporting company's investigation into an existing problem	Investigation took more than 30 days	nan	nan	EQUIFAX, INC.	NJ	07032	nan	nan	Web	Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	6896103
Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting, credit repair services, or other personal consumer reports	Credit reporting	Improper use of your report	Reporting company used your report improperly	nan	nan	EQUIFAX, INC.	NV	89118	nan	nan	Web	Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	6896108
Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting, credit repair services, or other personal consumer reports	Credit reporting	Incorrect information on your report	Information is missing that should be on the report	nan	nan	EQUIFAX, INC.	TX	77429	nan	nan	Web	Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	6896110
Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting, credit repair services, or other personal consumer reports	Credit reporting	Incorrect information on your report	Information is missing that should be on the report	nan	nan	EQUIFAX, INC.	TX	77429	nan	nan	Web	Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	6896111
Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting, credit repair services, or other personal consumer reports	Credit reporting	Problem with a credit reporting company's investigation into an existing problem	Investigation took more than 30 days	nan	nan	EQUIFAX, INC.	TX	75146	nan	nan	Web	Thu Apr 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	6896113


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
);