NYC Open Data

DOHMH New York City Restaurant Inspection ResultsThe 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.Visit the full page to view this data.

This view cannot be displayed

Embed this Dataset

      <div><iframe width="_width_px" title="DOHMH New York City Restaurant Inspection Results" height="_height_px" src="https://data.cityofnewyork.us/w/43nn-pn8j/25te-f2tw?cur=Y0Pho0ijYyp&from=RyST5gKOU0w" frameborder="0"scrolling="no"><a href="https://data.cityofnewyork.us/Health/DOHMH-New-York-City-Restaurant-Inspection-Results/43nn-pn8j" title="DOHMH New York City Restaurant Inspection Results" target="_blank">DOHMH New York City Restaurant Inspection Results</a></iframe><p><a href="http://www.socrata.com/" target="_blank">Powered by Tyler Technologies</a></p></div>

Size

500x425
760x646
950x808

Custom Size

425x425 is the minimum size

Width

Height

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

CAMIS: camis
DBA: dba
BORO: boro
BUILDING: building
STREET: street
ZIPCODE: zipcode
PHONE: phone
CUISINE DESCRIPTION: cuisine_description
INSPECTION DATE: inspection_date
ACTION: action
VIOLATION CODE: violation_code
VIOLATION DESCRIPTION: violation_description
CRITICAL FLAG: critical_flag
SCORE: score
GRADE: grade
GRADE DATE: grade_date
RECORD DATE: record_date
INSPECTION TYPE: inspection_type
Latitude: latitude
Longitude: longitude
Community Board: community_board
Council District: council_district
Census Tract: census_tract
BIN: bin
BBL: bbl
NTA: nta
Location Point1: location_point1
Zip Codes: :@computed_region_efsh_h5xi
Community Districts: :@computed_region_f5dn_yrer
Borough Boundaries: :@computed_region_yeji_bk3q
City Council Districts: :@computed_region_92fq_4b7q
Police Precincts: :@computed_region_sbqj_enih

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

NYC Open Data

API Endpoint:

Field Names:

OData V4 Endpoint:

OData V2 Endpoint:

Want to leave a comment?

You are leaving data.cityofnewyork.us.

Notice