Consumer Complaint Database

Consumer Finance Complaints (Bureau of Consumer Financial Protection)

@kaggle.selener_consumer_complaint_database

Table List

1 table(230.96 MB)

Rows

@kaggle.selener_consumer_complaint_database.rows

230.96 MB
1282355 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
Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Checking or savings account	Checking account	Managing an account	Problem using a debit or ATM card	nan	nan	NAVY FEDERAL CREDIT UNION	FL	328XX	Older American	nan	Web	Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	3238275
Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Checking or savings account	Other banking product or service	Managing an account	Deposits and withdrawals	nan	nan	BOEING EMPLOYEES CREDIT UNION	WA	98204	nan	nan	Referral	Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	nan	3238228
Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Debt collection	Payday loan debt	Communication tactics	Frequent or repeated calls	nan	nan	CURO Intermediate Holdings	TX	751XX	nan	nan	Web	Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	nan	3237964
Fri May 10 2019 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	Old information reappears or never goes away	nan	nan	Ad Astra Recovery Services Inc	LA	708XX	nan	nan	Web	Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	nan	3238479
Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Checking or savings account	Checking account	Managing an account	Banking errors	nan	nan	ALLY FINANCIAL INC.	AZ	85205	nan	nan	Postal mail	Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	3238460
Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Mortgage	Other type of mortgage	Closing on a mortgage	nan	nan	nan	Statebridge Company	NJ	08302	nan	nan	Web	Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	nan	3237885
Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Debt collection	Other debt	Attempts to collect debt not owed	Debt is not yours	nan	nan	Diversified Consultants, Inc.	TX	nan	Servicemember	nan	Web	Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	3238585
Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Student loan	Federal student loan servicing	Struggling to repay your loan	Problem lowering your monthly payments	nan	nan	Student Loan Direct	TX	773XX	Older American	nan	Web	Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	nan	3238221
Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Debt collection	Other debt	Attempts to collect debt not owed	Debt was paid	nan	nan	Diversified Consultants, Inc.	SC	296XX	Servicemember	nan	Web	Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	3238545
Fri May 10 2019 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	CONTRACT CALLERS INC	MD	20774	nan	nan	Web	Fri May 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	nan	3238458


CREATE TABLE rows (
  "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
);