Financial CFPB Complaint

Snowflake table name : CYBERSYN.FINANCIAL_CFPB_COMPLAINT

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
ID_ZIP	a unique identifier of the mailing zip code provided by the consumer	VARCHAR	zip/20745
ID_STATE	a unique identifier of the mailing state provided by the consumer	VARCHAR	geoId/45
PRODUCT	type of product identified by the consumer in the complaint. Product categories were consolidated by the CFPB in 2017	VARCHAR	Mortgage
SUB_PRODUCT	type of sub-product identified by the consumer in the complaint. Sub-product categories were consolidated by the CFPB in 2017	VARCHAR	Credit reporting
ISSUE	type of issue identified by the consumer in the complaint. The categorical issues available for selection have evolved over time	VARCHAR	Closing an account
SUB_ISSUE	type of sub-issue identified by the consumer in the complaint. The categorical sub-issues available for selection have evolved over time	VARCHAR	Information belongs to someone else
COMPANY	Company identified by the consumer in the complaint.	VARCHAR	TRANSUNION INTERMEDIATE HOLDINGS, INC.
CONSUMER_COMPLAINT_NARRATIVE	The consumer-submitted description of the complaint, with PII scrubbed by the CFPB. Consumers must opt-in and can opt out at any time	VARCHAR	I earnestly request that you eliminate this from my credit repor...
COMPANY_PUBLIC_RESPONSE	The optional, public-facing response to a consumer complaint chosen by the company from a list	VARCHAR	Company has responded to the consumer and the CFPB and chooses n...
COMPANY_RESPONSE_TO_CONSUMER	Company explanation of how the issue was closed, selected from a list	VARCHAR	In progress
STATE	mailing state provided by the consumer	VARCHAR	IN
ZIP_CODE	mailing zip code provided by the consumer	VARCHAR	89148
TAGS	Categorical data supporting easier searching of complaints submitted by or on behalf of consumers, includes "Older American" and "Servicemember"	VARCHAR	Servicemember
CONSUMER_CONSENT_PROVIDED	Identifies consumer consent in publishing their complaint narrative	VARCHAR	Consent not provided
SUBMITTED_VIA	How the complaint was submitted	VARCHAR	Web
CONSUMER_DISPUTED	Whether the consumer disputed the company response. After April 24, 2017 the Bureau discontinued this option and this field is marked N/A	VARCHAR	N/A
DATE_RECEIVED	Date the CFPB received the complaint	DATE	2020-11-17
DATE_SENT_TO_COMPANY	Date the CFPB sent the complaint to the company	DATE	2012-04-19
TIMELY_RESPONSE	Indicates whether the company gave a timely response	BOOLEAN	True