Trends In Consumer
The Consumer Complaint Database is a comprehensive collection.
@kaggle.willianoliveiragibin_trends_in_consumer
Trend Consumer New
@kaggle.willianoliveiragibin_trends_in_consumer.trend_consumer_new
- 23.93 KB
- 590 rows
- 14 columns
date_receivedDate Received | productProduct | sub_productSub-product | issueIssue | sub_issueSub-issue | companyCompany | stateState | zip_codeZIP Code | submitted_viaSubmitted Via | date_sent_to_companyDate Sent To Company | company_response_to_consumerCompany Response To Consumer | timely_responseTimely Response? | consumer_disputedConsumer Disputed? | complaint_idComplaint ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Mon Apr 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Credit reporting or other personal consumer reports | Credit reporting | Problem with a company's investigation into an existing problem | Their investigation did not fix an error on your report | Experian Information Solutions Inc. | MO | 631XX | Web | Mon Apr 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Closed with explanation | Yes | 8878641 | |
| Tue May 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Credit reporting or other personal consumer reports | Credit reporting | Incorrect information on your report | Information belongs to someone else | TRANSUNION INTERMEDIATE HOLDINGS, INC. | NC | 28001 | Web | Tue May 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Closed with non-monetary relief | Yes | 9064241 | |
| Tue May 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Credit reporting or other personal consumer reports | Credit reporting | Improper use of your report | Reporting company used your report improperly | TRANSUNION INTERMEDIATE HOLDINGS, INC. | WI | 53218 | Web | Tue May 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Closed with non-monetary relief | Yes | 9064573 | |
| Tue May 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Credit reporting or other personal consumer reports | Credit reporting | Incorrect information on your report | Account information incorrect | TRANSUNION INTERMEDIATE HOLDINGS, INC. | IL | 62226 | Web | Tue May 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Closed with non-monetary relief | Yes | 9064507 | |
| Tue May 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Credit reporting or other personal consumer reports | Credit reporting | Improper use of your report | Reporting company used your report improperly | TRANSUNION INTERMEDIATE HOLDINGS, INC. | AL | 35126 | Web | Tue May 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Closed with non-monetary relief | Yes | 9064567 | |
| Tue May 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Credit reporting or other personal consumer reports | Credit reporting | Problem with a company's investigation into an existing problem | Their investigation did not fix an error on your report | TRANSUNION INTERMEDIATE HOLDINGS, INC. | NC | 28216 | Web | Tue May 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Closed with non-monetary relief | Yes | 9064620 | |
| Tue May 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Credit reporting or other personal consumer reports | Credit reporting | Problem with a company's investigation into an existing problem | Their investigation did not fix an error on your report | TRANSUNION INTERMEDIATE HOLDINGS, INC. | MD | 21221 | Web | Tue May 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Closed with non-monetary relief | Yes | 9064641 | |
| Tue May 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Credit reporting or other personal consumer reports | Credit reporting | Incorrect information on your report | Information belongs to someone else | TRANSUNION INTERMEDIATE HOLDINGS, INC. | MS | 38654 | Web | Tue May 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Closed with non-monetary relief | Yes | 9064680 | |
| Wed May 22 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Credit reporting or other personal consumer reports | Credit reporting | Problem with a company's investigation into an existing problem | Investigation took more than 30 days | EQUIFAX, INC. | FL | 33463 | Web | Wed May 22 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Closed with non-monetary relief | Yes | 9072895 | |
| Fri May 24 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Debt collection | Credit card debt | Attempts to collect debt not owed | Debt was result of identity theft | Bread Financial Holdings, Inc. | CA | 95818 | Web | Fri May 24 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Closed with explanation | Yes | 9089032 |
CREATE TABLE trend_consumer_new (
"date_received" TIMESTAMP,
"product" VARCHAR,
"sub_product" VARCHAR,
"issue" VARCHAR,
"sub_issue" VARCHAR,
"company" VARCHAR,
"state" VARCHAR,
"zip_code" VARCHAR,
"submitted_via" VARCHAR,
"date_sent_to_company" TIMESTAMP,
"company_response_to_consumer" VARCHAR,
"timely_response" VARCHAR,
"consumer_disputed" VARCHAR,
"complaint_id" BIGINT
);