About this Dataset

DCWP Charges

This dataset features charges issued by DCWP's Enforcement division during the course of an inspection and charges filed by DCWP's General Counsel division stemming from an investigation into consumer protection laws and deceptive business practices.

For the archived DCWP Charges, please refer to https://data.cityofnewyork.us/d/wyj6-frpa
Organization: City of New York
Last updated: 2020-11-10T17:00:47.730177
Tags: business, charges, consumer, dca, department-of-consumer-affairs, enforcement-charges, license

Tables

Table 1

@usgov.city_of_new_york_charges.table_1

2.12 MB
80,712 rows
18 columns

CREATE TABLE table_1 (
  "record_id" VARCHAR,
  "related_record_type" VARCHAR,
  "business_unique_id" VARCHAR,
  "business_name" VARCHAR,
  "dba_trade_name" VARCHAR,
  "business_category" VARCHAR,
  "certificate_of_inspection" VARCHAR,
  "inspection_number" VARCHAR,
  "noh_number" VARCHAR,
  "violation_date" TIMESTAMP,
  "charge" VARCHAR,
  "charge_count" DOUBLE,
  "cure_eligible" VARCHAR,
  "cured" VARCHAR,
  "outcome" VARCHAR,
  "guilty" DOUBLE,
  "not_guilty" DOUBLE,
  "dismissed" DOUBLE
);