DOHMH New York City Restaurant Inspection Results
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.
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Fresh
- Says it updates
- Daily
- Actually updates about every
- 1 days
- Publisher last updated the data
- Oct 8, 2026
Our mirror
Whether our copy of this data is current with the source.
Sync error
- We last synced
- Sep 30, 2026, 6:07 PM
- Rows in our copy
- 295,653
- Rows at the source
- 296,507
- Our copy trails the source by
- 8 days
Columns
Each source column, with the name and type we use to store it.
3 of 31 columns carry a concept; 22 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
:@computed_region_sbqj_enih | Police Precincts | This column was automatically created in order to record in what polygon from the dataset 'Police Precincts' (sbqj-enih) the point in column 'location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. | Not bound | Number | :@computed_region_sbqj_enih | numeric | — | |
record_date | RECORD DATE | The date when the extract was run to produce this data set | Not bound | Calendar date | record_date | timestamp | — | |
census_tract | Census Tract | The publisher describes this column nowhere. | Not bound | Text | census_tract | text | — | |
grade_date | GRADE DATE | The date when the current grade was issued to the entity (restaurant) | Not bound | Calendar date | grade_date | timestamp | — | |
:@computed_region_yeji_bk3q | Borough Boundaries |
Download
This file was produced on Sep 30, 2026, 10:04 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/43nn-pn8j
- Version
- Content hash:
763ab5e4a94c4614160b46251d07c394f5fdd0aee8eca57894904010f2c3a4da - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Sep 30, 2026, 6:07 PM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Oct 7, 2026, 5:30 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 4, 2026, 1:15 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 3, 2026, 5:00 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 2, 2026, 1:00 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 2, 2026, 4:45 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 2, 2026, 12:30 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 1, 2026, 10:18 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 1, 2026, 9:00 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 30, 2026, 9:00 PM | full_replace | success | 295,653 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 30, 2026, 12:16 AM | full_replace | success | 295,615 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |