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 2019-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-
OtherMisrepresentation - M012018-05-082018-05-25Complaint Invalid - CIN11377
Auctioneer - 0362018-03-232018-04-19Resolved and Consumer Satisfied - SPFtrue10465
CLUB PILATESTRIBECAHealth Spa - 8392019-02-132/25/201972847MURRAY STNEW YORKNY10007
THE PIXEL HUBElectronic Store - 001Unlicensed2018-01-122018-01-18No Business Response - NVRfalse
Locksmith - 062Non-Delivery of Service - N022018-03-022018-03-15Goods Repaired - GRStrue27211234
Tow Truck Company - 124Misrepresentation - M012018-08-212018-09-10Advised to Sue - ATSfalse11572
MOTT PARK LLCGarage - 049Surcharge/Overcharge - S022018-05-222018-05-25Complaint Invalid - CIN7605
Misc Non-Food Retail - 817Surcharge/Overcharge - S022018-01-162018-01-24Cash Amount - AMTtrue7010027
Employment Agency - 034Non-Delivery of Service - N022018-09-122018-10-01Complaint Invalid - CIN11372
Home Improvement Contractor - 100Quality of Work - Q012018-08-032018-08-23Complaint Invalid - CIN10465
Related Data Packages