Name: DCWP Consumer Complaints
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

DCWP Consumer Complaints

This dataset features consumer complaints submitted to the NYC Department of Consumer and Worker Protection (DCWP).
Organization: City of New York
Last updated: 2020-11-10T17:04:27.322843
Tags: business, business-practice, complaint, consumer, dca, department-of-consumer-affairs, inspection, license

Tables

Table 1

@usgov.city_of_new_york_consumer_services_mediated_complaints.table_1

3.06 MB
41,836 rows
33 columns

CREATE TABLE table_1 (
  "record_id" VARCHAR,
  "intake_date" TIMESTAMP,
  "intake_channel" VARCHAR,
  "n_311_sr_number" VARCHAR  -- 311 SR Number,
  "business_category" VARCHAR,
  "complaint_code" VARCHAR,
  "business_unique_id" VARCHAR,
  "business_name" VARCHAR,
  "result_date" TIMESTAMP,
  "result" VARCHAR,
  "referred_to" VARCHAR,
  "contract_cancelled_amount" DOUBLE,
  "refund_amount" DOUBLE,
  "address_type" VARCHAR,
  "building_nbr" VARCHAR,
  "street1" VARCHAR,
  "street2" VARCHAR,
  "street3" VARCHAR,
  "unit_type" VARCHAR,
  "apt_suite" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postcode" VARCHAR,
  "borough" VARCHAR,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR,
  "census_block_2010" DOUBLE  -- Census Block (2010),
  "census_tract_2010" DOUBLE  -- Census Tract (2010),
  "latitude" DOUBLE,
  "longitude" DOUBLE
);