Consumer Complaints Database

Financial services complaints

@kaggle.sebastienverpile_consumercomplaintsdata

Table List

1 table(128.83 MB)

Consumer Complaints

@kaggle.sebastienverpile_consumercomplaintsdata.consumer_complaints

128.83 MB
903983 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
Wed Mar 12 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mortgage	Other mortgage	Loan modification,collection,foreclosure	nan	nan	nan	M&T BANK CORPORATION	MI	48382	nan	nan	Referral	Mon Mar 17 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	No	759217
Sat Oct 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting	nan	Incorrect information on credit report	Account status	I have outdated information on my credit report that I have previously disputed that has yet to be removed this information is more then seven years old and does not meet credit reporting requirements	Company has responded to the consumer and the CFPB and chooses not to provide a public response	TRANSUNION INTERMEDIATE HOLDINGS, INC.	AL	352XX	nan	Consent provided	Web	Wed Oct 05 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	No	2141773
Mon Oct 17 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Consumer Loan	Vehicle loan	Managing the loan or lease	nan	I purchased a new car on XXXX XXXX. The car dealer called Citizens Bank to get a 10 day payoff on my loan, good till XXXX XXXX. The dealer sent the check the next day. When I balanced my checkbook on XXXX XXXX. I noticed that Citizens bank had taken the automatic payment out of my checking account a…	nan	CITIZENS FINANCIAL GROUP, INC.	PA	177XX	Older American	Consent provided	Web	Thu Oct 20 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	No	2163100
Sun Jun 08 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit card	nan	Bankruptcy	nan	nan	nan	AMERICAN EXPRESS COMPANY	ID	83854	Older American	nan	Web	Tue Jun 10 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	Yes	885638
Sat Sep 13 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Debt collection	Credit card	Communication tactics	Frequent or repeated calls	nan	nan	CITIBANK, N.A.	VA	23233	nan	nan	Web	Sat Sep 13 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	Yes	1027760
Wed Nov 13 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Mortgage	Conventional adjustable mortgage (ARM)	Loan servicing, payments, escrow account	nan	nan	nan	U.S. BANCORP	MN	48322	nan	nan	Phone	Wed Nov 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with monetary relief	Yes	No	596562
Tue Jun 16 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Debt collection	Medical	Improper contact or sharing of info	Contacted employer after asked not to	nan	Company believes it acted appropriately as authorized by contract or law	California Accounts Service	CA	92111	nan	Consent not provided	Web	Fri Jun 19 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	No	1422680
Mon Jun 15 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting	nan	Credit reporting company's investigation	Inadequate help over the phone	An account on my credit report has a mistaken date. I mailed in a debt validation letter to allow XXXX to correct the information. I received a letter in the mail, stating that Experian received my correspondence and found it to be " suspicious '' and that " I did n't write it ''. Experian 's letter…	Company chooses not to provide a public response	Experian Information Solutions Inc.	VA	224XX	nan	Consent provided	Web	Mon Jun 15 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	No	1420702
Fri Nov 13 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Mortgage	Other mortgage	Loan modification,collection,foreclosure	nan	nan	Company believes it acted appropriately as authorized by contract or law	Aldridge Pite, LLP	CA	93101	nan	nan	Referral	Thu Dec 10 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	Yes	1654890
Tue Oct 21 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mortgage	Conventional fixed mortgage	Loan modification,collection,foreclosure	nan	nan	nan	OCWEN LOAN SERVICING LLC	FL	32714	Older American	nan	Web	Tue Oct 21 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	No	1079567


CREATE TABLE consumer_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
);