DCWP Inspections

jzhd-m6uvBusiness28 columns

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

View on NYC Open Data

Quality

A92.0 / 100

From a 500-row sample across 27 columns.

completeness80/ 25% weight

consistency85/ 20% weight

accuracy100/ 20% weight

timeliness100/ 15% weight

usability100/ 20% weight

· Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

DCWP Charges0.46
joins onnoh_numberbusiness_categorydba_trade_name+4
DCWP Consumer Complaints0.45
joins onstateboroughaddress_type+11
Weights, Measures, and Other Tests0.43
joins onstateboroughaddress_type+21
License Applications0.41

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

certificate_of_inspection	inspection_number	date_of_occurrence	business_unique_id	business_name	business_category	dcwp_license_number	inspection_type	inspection_status	address_type	street_1	city
A0273783	INS-000938916	2026-03-25T00:00:00.000	BA-1534934-2022	WILSON FOOD MARKET CORP	Tobacco Retail Dealer	2057300-2-DCA	Tobacco - Sale to Minor	Out of Business	Complete Address	WILSON AVE

Columns

28 queryable · 28 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`certificate_of_inspection`	text	An identification number assigned to track DCWP inspections at a business.	0%	`A0163274A0145818A0182154`
`inspection_number`	text	An identification number assigned to an inspection of a business.	0%	`INS-000625938INS-000625961INS-000630892`
`date_of_occurrence`	datetime	The date the inspection was conducted.	0%	`2024-10-23T00:00:00.0002024-10-09T00:00:00.0002024-09-25T00:00:00.000`
`business_unique_id`	text	An identification number assigned by DCWP to track unique businesses across its systems.	0%

Query this from your own app

GET /api/datasets/jzhd-m6uv
GET /api/datasets/jzhd-m6uv/quality
GET /api/datasets/jzhd-m6uv/related
GET /api/columns?dataset=jzhd-m6uv