DOHMH New York City Restaurant Inspection Results

43nn-pn8jHealth31 columns

The dataset contains every sustained or not yet adjudicated violation citation from every full or special program inspection conducted up to three years prior to the most recent inspection for restaurants and college cafeterias in an active status on the RECORD DATE (date of the data pull). When an inspection results in more than one violation, values for associated fields are repeated for each additional violation record. Establishments are uniquely identified by their CAMIS (record ID) number. Keep in mind that thousands of restaurants start business and go out of business every year; only restaurants in an active status are included in the dataset. Records are also included for each restaurant that has applied for a permit but has not yet been inspected and for inspections resulting in no violations. Establishments with inspection date of 1/1/1900 are new establishments that have not yet received an inspection. Restaurants that received no violations are represented by a single row and coded as having no violations using the ACTION field. Because this dataset is compiled from several large administrative data systems, it contains some illogical values that could be a result of data entry or transfer errors. Data may also be missing. This dataset and the information on the Health Department’s Restaurant Grading website come from the same data source. The Health Department’s Restaurant Grading website is here: http://www1.nyc.gov/site/doh/services/restaurant-grades.page See the data dictionary file in the Attachments section of the OpenData website for a summary of data fields and allowable values.

View on NYC Open Data

Quality

B85.9 / 100

From a 500-row sample across 31 columns.

completeness70/ 25% weight

consistency69/ 20% weight

accuracy97/ 20% weight

timeliness100/ 15% weight

usability100/ 20% weight

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

Related datasets

Rodent Inspection0.40
joins oncouncil_districtcensus_tract:@computed_region_yeji_bk3q+12
NYC Cooling Tower System Inspection Results0.34
joins oncouncil_districtcensus_tractviolation_code+7
DOHMH School Cafeteria Inspections (2020-Present)0.33
joins onlatitudestreetzipcode+4
Self-Reported Drinking Water Tank Inspection Results0.33
joins on

Geography

Mappable — Socrata point column `location`.

Open on the map →

Sample rows

camis	dba	boro	building	street	zipcode	phone	inspection_date	critical_flag	record_date	latitude	longitude
50180694	BEANS AND VINES EXPRESS	Manhattan	3908	BROADWAY	10032	3477499915	1900-01-01T00:00:00.000	Not Applicable	2026-10-13T06:00:32.000	40.83807992227	-73.941923449169
50182112

Columns

27 queryable · 27 profiled

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

Field	Type	Description	Null	Values
`camis`	text	This is an unique identifier for the entity (restaurant); 10-digit integer, static per restaurant permit	0%	`501392595000121550138270`
`dba`	text	This field represents the name (doing business as) of the entity (restaurant); Public business name, may change at discretion of restaurant owner	0%	`DUNKINSUBWAYMCDONALD'S`
`boro`	categorical	Borough in which the entity (restaurant) is located.;• 1 = MANHATTAN • 2 = BRONX • 3 = BROOKLYN • 4 = QUEENS • 5 = STATEN ISLAND • Missing; NOTE: There may be discrepancies between zip code and listed boro due to differences in an establishment's mailing address and physical location	0%	`ManhattanBrooklynQueens`of 6
`building`	text	Building number for establishment (restaurant) location

Query this from your own app

GET /api/datasets/43nn-pn8j
GET /api/datasets/43nn-pn8j/quality
GET /api/datasets/43nn-pn8j/related
GET /api/columns?dataset=43nn-pn8j