Consumer Complaints

Consumer Complaints on Financial Products

@kaggle.heemalichaudhari_consumer_complaints

Table List

1 table(102.66 MB)

Consumer Complaints

@kaggle.heemalichaudhari_consumer_complaints.consumer_complaints

102.66 MB
777959 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
Tue Mar 21 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit reporting	nan	Incorrect information on credit report	Information is not mine	nan	Company has responded to the consumer and the CFPB and chooses not to provide a public response	EXPERIAN DELAWARE GP	TX	77075	Older American	nan	Phone	Tue Mar 21 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with non-monetary relief	Yes	No	2397100
Wed Apr 19 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Debt collection	Other (i.e. phone, health club, etc.)	Disclosure verification of debt	Not disclosed as an attempt to collect	nan	nan	Security Credit Services, LLC	IL	60643	nan	nan	Web	Thu Apr 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	No	2441777
Wed Apr 19 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit card	nan	Other	nan	nan	Company has responded to the consumer and the CFPB and chooses not to provide a public response	CITIBANK, N.A.	IL	62025	nan	nan	Referral	Thu Apr 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	No	2441830
Fri Apr 14 2017 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	Shellpoint Partners, LLC	CA	90305	nan	nan	Referral	Fri Apr 14 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	No	2436165
Wed Apr 19 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Credit card	nan	Credit determination	nan	nan	Company has responded to the consumer and the CFPB and chooses not to provide a public response	U.S. BANCORP	LA	70571	nan	nan	Postal mail	Fri Apr 21 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	No	2441726
Tue Apr 18 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Debt collection	Other (i.e. phone, health club, etc.)	Disclosure verification of debt	Not given enough info to verify debt	nan	nan	Rubin & Rothman, LLC	NY	14063	nan	nan	Referral	Wed Apr 19 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	No	2440364
Tue Apr 18 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Mortgage	Other mortgage	Loan servicing, payments, escrow account	nan	nan	nan	QUICKEN LOANS, INC.	FL	33772	Older American	nan	Referral	Wed Apr 19 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	In progress	Yes	No	2441409
Wed May 18 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Mortgage	Other mortgage	Loan modification,collection,foreclosure	nan	nan	Company has responded to the consumer and the CFPB and chooses not to provide a public response	WELLS FARGO BANK, NATIONAL ASSOCIATION	NJ	08618	nan	nan	Referral	Mon May 23 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	No	1931957
Fri Mar 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Bank account or service	Checking account	Making/receiving payments, sending money	nan	nan	Company believes it acted appropriately as authorized by contract or law	UNITED SERVICES AUTOMOBILE ASSOCIATION	WI	54005	nan	nan	Referral	Mon Mar 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with explanation	Yes	No	2393048
Fri Nov 18 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Mortgage	Conventional fixed mortgage	Settlement process and costs	nan	Started the refinance of home mortgage process with cash out option on XX/XX/2016. Necessary documents were submitted by XXXX. After initial review, got good faith estimate with loan amount and closing cost. Based on this estimate, a deposit of {$350.00} was made towards appraisal. Appraisal came wi…	nan	AMERICAN NEIGHBORHOOD MORTGAGE	NJ	088XX	nan	Consent provided	Web	Mon Nov 21 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Closed with monetary relief	No	No	2216206


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