DOHMH New York City Restaurant Inspection Resultsdata.cityofnewyork.us | Last Updated 15 Oct 2018
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.
This dataset has the following 18 columns:
|Column Name||API Column Name||Data Type||Description||Sample Values|
|CAMIS||camis||text||This is an unique identifier for the entity (restaurant); 10-digit integer, static per restaurant permit|
41630632view top 100
|DBA||dba||text||This field represents the name (doing business as) of the entity (restaurant); Public business name, may change at discretion of restaurant owner|
KENNEDY FRIED CHICKENview top 100
|BORO||boro||text||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|
STATEN ISLANDview top 100
|BUILDING||building||text||Building number for establishment (restaurant) location|
10view top 100
|STREET||street||text||Street name for establishment (restaurant) location|
5TH AVEview top 100
|ZIPCODE||zipcode||text||Zip code of establishment (restaurant) location|
10002view top 100
|PHONE||phone||text||Phone Number; Phone number provided by restaurant owner/manager|
7182153308view top 100
|CUISINE DESCRIPTION||cuisine_description||text||This field describes the entity (restaurant) cuisine. ; Optional field provided by provided by restaurant owner/manager|
Latin (Cuban, Dominican, Puerto Rican, South & Central American)view top 100
|INSPECTION DATE||inspection_date||calendar_date||This field represents the date of inspection; NOTE: Inspection dates of 1/1/1900 mean an establishment has not yet had an inspection|
2019-04-03T00:00:00.000view top 100
|ACTION||action||text||This field represents the actions that is associated with each restaurant inspection. ; • Violations were cited in the following area(s). • No violations were recorded at the time of this inspection. • Establishment re-opened by DOHMH • Establishment re-closed by DOHMH • Establishment Closed by DOHMH. Violations were cited in the following area(s) and those requiring immediate action were addressed. • "Missing" = not yet inspected;|
Violations were cited in the following area(s).
Establishment Closed by DOHMH. Violations were cited in the following area(s) and those requiring immediate action were addressed.
No violations were recorded at the time of this inspection.
Establishment re-opened by DOHMH
Establishment re-closed by DOHMHview top 100
|VIOLATION CODE||violation_code||text||Violation code associated with an establishment (restaurant) inspection|
06Cview top 100
|VIOLATION DESCRIPTION||violation_description||text||Violation description associated with an establishment (restaurant) inspection|
Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.
Facility not vermin proof. Harborage or conditions conducive to attracting vermin to the premises and/or allowing vermin to exist.
Evidence of mice or live mice present in facility's food and/or non-food areas.
Food contact surface not properly washed, rinsed and sanitized after each use and following any activity when contamination may have occurred.
Food not protected from potential source of contamination during storage, preparation, transportation, display or service.view top 100
|CRITICAL FLAG||critical_flag||text||Indicator of critical violation; "• Critical • Not Critical • Not Applicable"; Critical violations are those most likely to contribute to food-borne illness|
Not Applicableview top 100
|SCORE||score||number||Total score for a particular inspection; Scores are updated based on adjudication results|
9view top 100
|GRADE||grade||text||Grade associated with the inspection; • N = Not Yet Graded• A = Grade A• B = Grade B• C = Grade C• Z = Grade Pending• P= Grade Pending issued on re-opening following an initial inspection that resulted in a closure|
Not Yet Gradedview top 100
|GRADE DATE||grade_date||calendar_date||The date when the current grade was issued to the entity (restaurant)|
2018-06-27T00:00:00.000view top 100
|RECORD DATE||record_date||calendar_date||The date when the extract was run to produce this data set|
2019-04-18T06:01:37.000view top 100
|INSPECTION TYPE||inspection_type||text||A combination of the inspection program and the type of inspection performed; See Data Dictionary for full list of expected values|
Cycle Inspection / Initial Inspection
Cycle Inspection / Re-inspection
Pre-permit (Operational) / Initial Inspection
Pre-permit (Operational) / Re-inspection
Administrative Miscellaneous / Initial Inspectionview top 100