Restaurant Inspection Scores in New York City

$716 / year

This dataset provides restaurant inspection scores, violations, grades and adjudication information for restaurants in New York City. It also provides the name as well as the location and address of the restaurants.

Complexity

The Department of Health and Mental Hygiene (DOHMH) inspects about 24,000 restaurants a year to monitor compliance with city and state food safety regulations. Since July 2010, the Health Department has required restaurants to post letter grades showing sanitary inspection results. Restaurants with a score between 0 and 13 points earn an A, those with 14 to 27 points receive a B and those with 28 or more a C.

The Health Department conducts unannounced inspections of restaurants at least once a year. Inspectors check for compliance in food handling, food temperature, personal hygiene and vermin control. Each violation of a regulation gets a certain number of points. At the end of the inspection, the inspector totals the points, and this number is the restaurant’s inspection score—the lower the score, the better the Grade.

The points for a particular violation depend on the health risk it poses to the public. Violations fall into three categories:
– A public health hazard, such as failing to keep food at the right temperature, triggers a minimum of 7 points. If the violation cannot be corrected before the inspection ends, the Health Department may close the restaurant until it’s fixed.
– A critical violation, for example, serving raw food such as a salad without properly washing it first, carries a minimum of 5 points.
– A general violation, such as not properly sanitizing cooking utensils, receives at least 2 points. Inspectors assign additional points to reflect the extent of the violation. A violation’s condition level can range from 1 (least extensive) to 5 (most extensive). For example, the presence of one contaminated food item is a condition level 1 violation, generating 7 points. Four or more contaminated food items is a condition level 4 violation, resulting in 10 points.

Two types of inspections result in a letter grade: initial inspections for which the restaurant earns an A and re-inspections that result in an A, B or C. A restaurant has two chances to earn an A in every inspection cycle. If it doesn’t earn an A on the first inspection, it’s scored but ungraded. An inspector goes back to the restaurant unannounced, typically within a month, to inspect it again and the re-inspection is graded. If the grade is a B or C, the restaurant will receive a grade card and a grade pending card. It can post either card until it has an opportunity to be heard at the Office of Administrative Trials and Hearings Health Tribunal. Until a restaurant has a graded inspection, it is listed as Not Yet Graded.
In this dataset, “Record Date” the date when the extract was run to produce the results for all the records is 2017-06-03.

Date Created

2015-07-16

Last Modified

2019-11-15

Version

2019-11-15

Update Frequency

Quarterly

Temporal Coverage

2019

Spatial Coverage

New York City

Source

John Snow Labs; Data City of New York, Department of Health and Mental Hygiene (DOHMH);

Source License URL

Source License Requirements

N/A

Source Citation

N/A

Keywords

Restaurant Inspection, Inspection Grades, Violation Scores, Restaurant Scores

Other Titles

Restaurant Inspection Results in New York City, Inspection Scores of Restaurants in New York City

NameDescriptionTypeConstraints
CAMIS_IDCAMIS (City-wide Agency Management Information System) is the unique identifier for the entity/restaurantintegerlevel : Nominal
Restaurant_NameName (doing business as) of the entity (restaurant)string-
Borough_NameBorough in which the entity (restaurant) is located. There may be discrepancies between zip code and listed borough name due to differences in an establishment's mailing address and physical locationstring-
Building_NumberBuilding number for the entity (restaurant)string-
Street_NameStreet name at which the entity (restaurant) is locatedstring-
Zip_CodeZip code as per the address of the entity (restaurant)integerlevel : Nominal
Phone_NumberPhone Numberstring-
Cuisine_DescriptionRestaurant's cuisine descriptionstring-
Inspection_DateDate of inspectiondate-
Action_TakenAction that is associated with each restaurant inspection.string-
Violation_CodeViolation codes that are associated with each restaurant inspection.string-
Violation_DescriptionThis field is the description that corresponds to the violation codesstring-
Is_Violation_FlagThis indicates if violation is critical, not critical or not applicable.boolean-
Total_Inspection_ScoreTotal Score for a particular inspection. If there was adjudication a judge may reduce the total points for the inspection and this field will have the update amount.integerlevel : Ratio
Inspection_GradeN = Not Yet Graded, A = 0 to 13 points, B = 14 to 27 points, C = 28 points or more, Z = Grade Pending, P= Grade Pending issued on re-opening following an initial inspection that resulted in a closurestring-
Grade_Issuance_DateThe date when the current grade was issued to the entity (restaurant)date-
Inspection_TypeThe type of inspection. A combination of the program and inspection type.string-
LatitudeLatitude location of the restaurantnumber-
LongitudeLongitude location of the restaurantnumber-
CAMIS IDRestaurant NameBorough NameBuilding NumberStreet NameZip CodePhone NumberCuisine DescriptionInspection DateAction TakenViolation CodeViolation DescriptionIs Violation FlagTotal Inspection ScoreInspection GradeGrade Issuance DateInspection TypeLatitudeLongitude
41232877GEO SI GIQueens15228NORTHERN BOULEVARD113547188880001Korean2018-02-13Violations were cited in the following area(s).02GCold food item held above 41º F (smoked fish and reduced oxygen packaged foods above 38 ºF) except during necessary preparation.True12.0A2018-02-13Cycle Inspection / Re-inspection40.764889399999994-73.81214339
50014465MIYABI SUSHI & ASIAN CUISINEManhattan118W 3RD ST100122122281688Japanese2017-12-08Violations were cited in the following area(s).08AFacility not vermin proof. Harborage or conditions conducive to attracting vermin to the premises and/or allowing vermin to exist.False12.0A2017-12-08Cycle Inspection / Re-inspection40.73054424-74.00038607
50056033LA COLOMBIANITA BAKERYQueens10837CORONA AVE113687183930063Bakery2017-05-23Violations were cited in the following area(s).02BHot food item not held at or above 140º F.True29.0Cycle Inspection / Initial Inspection40.74249549-73.85409744
41081943SUBWAYManhattan1PENN PLAZA101192122394212Sandwiches2018-05-07Violations were cited in the following area(s).06APersonal cleanliness inadequate. Outer garment soiled with possible contaminant. Effective hair restraint not worn in an area where food is prepared.True12.0A2018-05-07Cycle Inspection / Initial Inspection40.75109132-73.9929259
41628216OVI'S PLACEBrooklyn2925AVENUE H112107184211640American2019-07-29Violations were cited in the following area(s).22GAdministrative Miscellaneous / Initial Inspection40.63153663-73.94796195
50088976CHICK-N-RICEQueens27119UNION TPKE110409173878585Middle Eastern2019-09-17Violations were cited in the following area(s).10FNon-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.False10.0Pre-permit (Operational) / Initial Inspection40.75190597-73.70274635
50054504SHAKE SHACKQueens7126AUSTIN ST113757189283234American2019-01-10Violations were cited in the following area(s).06DFood contact surface not properly washed, rinsed and sanitized after each use and following any activity when contamination may have occurred.True10.0Cycle Inspection / Initial Inspection40.71984603-73.84395229
50056821GALAXYManhattan125W 55TH ST100193475043209American2018-02-02Violations were cited in the following area(s).10ISingle service item reused, improperly stored, dispensed; not used when required.False10.0A2018-02-02Cycle Inspection / Initial Inspection40.76350696-73.9792755
41652054MEI CHUNG MEI RESTAURANTBronx157WEST 231 STREET104637185496719Chinese2018-07-02Violations were cited in the following area(s).02GCold food item held above 41º F (smoked fish and reduced oxygen packaged foods above 38 ºF) except during necessary preparation.True28.0C2018-07-02Cycle Inspection / Re-inspection40.87825852-73.90303612
50065128AMBASSADOR FOOD @ RIVERVIEW SENIOR INDEPENDENT LIVINGManhattan521W 49TH ST100192125864546Continental2018-05-09Violations were cited in the following area(s).10BPlumbing not properly installed or maintained; anti-siphonage or backflow prevention device not provided where required; equipment or floor not properly drained; sewage disposal system in disrepair or not functioning properly.False5.0A2018-05-09Pre-permit (Operational) / Initial Inspection40.76458733-73.99349844