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-07

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
VARIAZIONIRetail Store - 820Damaged Goods - D012019-01-162019-02-25No Business Response - NVRFalse0325BLEECKER STNEW YORKNY10014-74.0044165340.73367449
SEARS, ROEBUCK AND CO.Appliances - 244Misrepresentation - M012019-10-252019-11-26Cash Amount - AMTTrue2283333BEVERLY RDHOFFMAN ESTATESIL6017910303.0
DESIGNTIME, INC.Home Improvement Contractor - 100Non-Delivery of Service - N022019-08-232019-09-24No Business Response - NVRFalse04557BELL BLVDBAYSIDENY113616877.0-73.7685282740.75878978
NBE SERVICES & ASSOCIATES, INC.Employment Agency - 034Breach of Contract - B032019-05-202019-06-04Resolved and Consumer Satisfied - SPFTrue0479B72ND STBROOKLYNNY1120911214.0-74.0224633340.63203896
NY-NY CONTRACTORS CORPHome Improvement Contractor - 100Breach of Contract - B032019-01-162019-01-31Resolved and Consumer Satisfied - SPFTrue0469E 48TH ST2.0BROOKLYNNY1120311249.0-73.9578894440.67973775
BEST BUY STORES, L.P.Electronic Store - 001Damaged Goods - D012019-10-212019-12-20Cash Amount - AMTTrue229POP O BOX 4401LISLEIL6053211224.0-74.0006265440.59536248
CONSTRUCTION TECHNOLOGIES OF NEW YORK CORP.Home Improvement Contractor - 100Quality of Work - Q012019-07-192019-08-23Unable to Locate Business - ULV014409243RD STROSEDALENY1142211361.0
MOBILESHACK INCElectronic Store - 001Surcharge/Overcharge - S022019-02-222019-03-22Advised to Sue - ATSFalse0566FASHION AVENEW YORKNY1001810001.0-73.9877171140.75500886
TRANSWORLD SYSTEMS INC.Debt Collection Agency - 122Billing Dispute - B022019-06-112019-06-28Bill Reduced - BLRTrue2561500VIRGINIA DR514.0FT WASHINGTONPA1903411378.0
LUNA PARK CONEY ISLANDOtherNon-Delivery of Service - N022019-08-212019-09-18Credit Card Refund and/or Contract Cancelled - CRCTrue1281000SURF AVEBROOKLYNNY11224-73.9780056740.57543312
Related Data Packages