Consumer Services Mediated Complaints

$179 / year

This data set features consumer complaints against businesses that were mediated by the DCA (Department of Consumer Affairs) Consumer Services Division during the last and current calendar years. It excludes complaints that may have ongoing legal investigations.


A consumer complaint or customer complaint is “an expression of dissatisfaction on a consumer’s behalf to a responsible party” (Landon, 1980). It can also be described in a positive sense as a report from a consumer providing documentation about a problem with a product or service.

Consumer complaints are usually informal complaints directly addressed to a company or public service provider, and most consumers manage to resolve problems with products and services in this way, but it sometimes requires persistence.

If the grievance is not addressed in a way that satisfies the consumer, the consumer sometimes registers the complaint with a third party such as the Better Business Bureau, a county government (if it has a “consumer protection” office) and Federal Trade Commission (in the United States). These and similar organizations in other countries accept consumer complaints and assist people with customer service issues, as do government representatives like attorneys general. Consumers however rarely file complaints in the more formal legal sense, which consists of a formal legal process.

Date Created


Last Modified




Update Frequency


Temporal Coverage

2016-10 to 2018-05

Spatial Coverage

United States


John Snow Labs; Data City of New York;

Source License URL

Source License Requirements


Source Citation



Consumer Complaint, Consumer Complaint Data, Consumer Data, Mediated Complaints

Other Titles

Consumer Mediated Complaints Complaint, Business Mediation Complaints

Business_NameName of the business against which a complaint has been made.string-
IndustryThe business category of the business against which a complaint has been made.string-
Complaint_TypeIndicates the type of complaint made.string-
Mediation_Start_DateDate mediation started. During the mediation process, DCA sends a copy of complaint to the business for written response. Then, mostly over the phone, a DCA mediator speaks with both consumer and the business to reach an agreement and settle the
Mediation_Close_DateDate mediation
Complaint_ResultOutcome of mediation efforts.string-
Is_SatisfactionThis section indicates whether the complaint was mediated to the satisfaction of both the business and consumer.boolean-
RestitutionRestoringintegerlevel : Nominal
Business_BuildingThe building number of the business’s address.string-
Business_StreetThe street name of the business’s address.string-
Building_Address_UnitThe unit number of the business’s address (e.g., Apartment/Suite/Other).string-
Business_CityThe city where the business is located.string-
Business_StateThe state where the business is located.string-
Business_ZIPThe zip code where the business is located.string-
Complainant_ZIPThe zip code where the individual who filed the complaint is located.string-
LongitudeLongitude Location of Businessnumber-
LatitudeLatitude Location of Businessnumber-
Other2017-05-092017-06-05Referred to Outside - RTO21228
Auctioneer - 0362018-03-232018-04-19Resolved and Consumer Satisfied - SPFtrue10465
Garage - 049Damage / Estimate2017-03-292017-05-08Referred to Hearing - RTHfalse11104
Auction House - 128Lost Property - L022017-09-012017-09-22Advised to Sue - ATSfalse10514
Pedicab Driver - 131Surcharge/Overcharge - S022017-09-132017-11-06Advised to Sue - ATSfalse
WALL PARK 45 LLCGarage - 049Misrepresentation - M012017-01-202017-02-16Cash Amount - AMTtrue62
Misc Non-Food Retail - 817Refund Policy - R012017-03-172017-03-31Advised to Sue - ATSfalse11368
COACH USA, INC.Travel Agency - 4402017-07-242017-08-23Referred to Outside - RTO160PARAMUSNJ7652
THE PIXEL HUBElectronic Store - 001Unlicensed2018-01-122018-01-18No Business Response - NVRfalse
Locksmith - 062Non-Delivery of Service - N022018-03-022018-03-15Goods Repaired - GRStrue27211234
Related Data Packages