About this Dataset

DCWP Inspections

This dataset features business inspections conducted by DCWP. DCWP enforces key consumer protection, licensing, weights and measures, and workplace laws. In addition to patrol (routine) inspections at brick-and-mortar businesses, DCWP inspects licensed vehicles such as horse-drawn cabs, pedicabs, sightseeing buses, and tow trucks to ensure they are in compliance with their respective asset class requirements. DCWP also conducts 'Business Education' inspections, which are educational, violation-free visits. These visits are designed to help business owners learn about and comply with the laws that DCWP enforces.

For the archived DCWP Inspections, please refer to https://data.cityofnewyork.us/d/wyj6-frpa
Organization: City of New York
Last updated: 2020-11-10T17:03:48.984612
Tags: business, compliance, consumer, enforcement, industry, inspections, license, regulations

Tables

Table 1

@usgov.city_of_new_york_inspections.table_1

8.86 MB
163,107 rows
28 columns

CREATE TABLE table_1 (
  "certificate_of_inspection" VARCHAR,
  "inspection_number" VARCHAR,
  "date_of_occurrence" TIMESTAMP,
  "business_unique_id" VARCHAR,
  "business_name" VARCHAR,
  "dba_trade_name" VARCHAR,
  "business_category" VARCHAR,
  "dcwp_license_number" VARCHAR,
  "inspection_type" VARCHAR,
  "inspection_status" VARCHAR,
  "noh_number" VARCHAR,
  "address_type" VARCHAR,
  "building_number" VARCHAR,
  "street_name" VARCHAR,
  "street_name_2" VARCHAR,
  "unit_type" VARCHAR,
  "unit" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postcode" DOUBLE,
  "borough" VARCHAR,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);