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 2020-08

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-
Business NameIndustryComplaint TypeMediation Start DateMediation Close DateComplaint ResultIs SatisfactionRestitutionBusiness BuildingBusiness StreetBuilding Address UnitBusiness CityBusiness StateBusiness ZIPComplainant ZIPLongitudeLatitude
ASUS COMPUTER INTERNATIONALElectronic Store - 001Defective Goods - D022019-01-112019-01-30Goods Exchanged - GEXTrue048720.0KATO RDFREMONTCA94538.011385.0
NUTRACARE PHARMACYDrug Store Retail - 810Exchange Goods/Contract Cancelled - E012020-07-162020-08-10Cash Amount - AMTTrue1622036.0HILLSIDE AVEQUEENS VILLAGENY11427.0-73.7426351540.73104844
ADORAMA INC.Electronic Store - 0012020-05-192020-06-02Resolved and Consumer Satisfied - SPFTrue042.0W 18TH STNEW YORKNY10011.094920.0-73.9932267240.73909801
SPECTRUMMisc Non-Food Retail - 817Misrepresentation - M012019-03-152019-04-08Bill Reduced - BLRTrue528400.0ATLANTIC ST10STAMFORDCT6901.010312.0
Home Improvement Contractor - 100Quality of Work - Q012020-05-292020-07-09Advised to Sue - ATSFalse011414.0-73.8425060940.65880752
THE LAW FIRM OF RYAN J. WALSH & ASSOCIATES, PLLCOtherNon-Delivery of Service - N022019-10-182019-11-06Referred to Outside - RTO07612.041ST AVEELMHURSTNY11373.011102.0-73.8144489840.71775642
ASTOR PARKING LLCParking Lot - 050Surcharge/Overcharge - S022019-07-152019-08-26Credit Card Refund and/or Contract Cancelled - CRCTrue23270.0MADISON AVE2 FLNEW YORKNY10016.0-73.9858035540.75763536
CVS PHARMACY INCDrug Store Retail - 810Refund Policy - R012020-04-172020-05-11Resolved and Consumer Satisfied - SPFTrue01.0CVS DRWOONSOCKETRI2895.011208.0-73.8821137740.64815851
ABC CARPET- RUG CLEANINGOther2019-11-152019-11-26Goods Received - GDRTrue300412.0AVENUE OF THE AMERICASNEW YORKNY10011.0
LINDA'S RESTAURANT & BAKERYRestaurant - 818Refund Policy - R012019-05-062019-05-10Resolved and Consumer Satisfied - SPFTrue05322.0CHURCH AVEBROOKLYNNY11203.011203.0-73.9272161340.65233229
Related Data Packages