Name: Consumer Complaint Database
Creator: Kaggle
License: https://www.usa.gov/government-works

About this Dataset

Consumer Complaint Database

➡️The Consumer Complaint Database is a collection of complaints about consumer financial products and services that we sent to companies for response. Complaints are published after the company responds, confirming a commercial relationship with the consumer, or after 15 days, whichever comes first. Complaints referred to other regulators, such as complaints about depository institutions with less than $10 billion in assets, are not published in the Consumer Complaint Database. The database generally updates daily.

Column	Description
Date received	The date when the consumer complaint was received.
Product	The specific financial product or service associated with the complaint.
Sub-product	Further sub-categorization of the product or service, if applicable.
Issue	The main issue or problem described in the consumer complaint.
Sub-issue	Additional details or sub-category related to the main issue.
Consumer complaint narrative	The text description provided by the consumer detailing their complaint.
Company public response	The response or statement issued by the company regarding the complaint.
Company	The name of the company being complained about.
State	The state where the consumer resides.
ZIP code	The ZIP code of the consumer's location.
Tags	Any additional tags or labels associated with the complaint.
Consumer consent provided?	Indicates whether the consumer provided consent for their complaint to be published.
Submitted via	The channel or method through which the complaint was submitted.
Date sent to company	The date when the complaint was sent to the company for response.
Company response to consumer	The company's response or resolution to the consumer's complaint.
Timely response?	Indicates whether the company provided a timely response to the complaint.
Consumer disputed?	Indicates whether the consumer disputed the company's response.
Complaint ID	A unique identifier assigned to each complaint.

Tables

Complaints

@kaggle.utkarshx27_consumer_complaint.complaints

765.14 MB
3,585,952 rows
18 columns

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  -- Consumer Consent Provided?,
  "submitted_via" VARCHAR,
  "date_sent_to_company" TIMESTAMP,
  "company_response_to_consumer" VARCHAR,
  "timely_response" VARCHAR  -- Timely Response?,
  "consumer_disputed" VARCHAR  -- Consumer Disputed?,
  "complaint_id" BIGINT
);