About this Dataset

Archived DCWP Charges

An archival list of all charges and their outcomes in DCWP's Accela system. This data set features DCA-issued charges to ensure compliance with local consumer protection and licensing laws, and State and federal regulations.

For the current list of charges, please refer to https://data.cityofnewyork.us/d/5fn4-dr26
Organization: City of New York
Last updated: 2025-03-22T17:41:51.286965
Tags: archival, business, charges, city-government, consumer, dca, department-of-consumer-affairs, license

Tables

Table 1

@usgov.city_of_new_york_archived_dcwp_charges.table_1

29.58 MB
516,555 rows
31 columns

CREATE TABLE table_1 (
  "record_id" VARCHAR,
  "certificate_number" VARCHAR,
  "business_name" VARCHAR,
  "violation_date" TIMESTAMP,
  "industry" VARCHAR,
  "borough" VARCHAR,
  "charge" VARCHAR,
  "charge_number" DOUBLE,
  "outcome" VARCHAR,
  "counts_settled" DOUBLE,
  "counts_guilty" DOUBLE,
  "counts_not_guilty" DOUBLE,
  "building_number" VARCHAR,
  "street" VARCHAR,
  "street2" VARCHAR,
  "unit_type" VARCHAR,
  "unit" DOUBLE,
  "description" VARCHAR,
  "city" VARCHAR,
  "sate" VARCHAR,
  "postcode" DOUBLE,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "census_tract_2020" DOUBLE  -- Census Tract (2020),
  "neighborhood_tabulation_area_nta_2020" VARCHAR  -- Neighborhood Tabulation Area (NTA) (2020)
);