- Restaurant Inspection Results in New York City
- Inspection Scores of Restaurants in New York City
- Restaurant Inspection
- Inspection Grades
- Violation Scores
- Restaurant Scores
Restaurant Inspection Scores in New York City
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.
Get The Data
- ResearchNon-Commercial, Share-Alike, Attribution Free Forever
- CommercialCommercial Use, Remix & Adapt, White Label Log in to download
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.
About this Dataset
New York City
John Snow Labs; Data City of New York, Department of Health and Mental Hygiene (DOHMH);
|Source License URL|
|Source License Requirements||
Restaurant Inspection, Inspection Grades, Violation Scores, Restaurant Scores
Restaurant Inspection Results in New York City, Inspection Scores of Restaurants in New York City
|CAMIS_ID||CAMIS (City-wide Agency Management Information System) is the unique identifier for the entity/restaurant||integer||level : Nominal|
|Restaurant_Name||Name (doing business as) of the entity (restaurant)||string||-|
|Borough_Name||Borough 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 location||string||-|
|Building_Number||Building number for the entity (restaurant)||string||-|
|Street_Name||Street name at which the entity (restaurant) is located||string||-|
|Zip_Code||Zip code as per the address of the entity (restaurant)||integer||level : Nominal|
|Cuisine_Description||Restaurant's cuisine description||string||-|
|Inspection_Date||Date of inspection||date||-|
|Action_Taken||Action that is associated with each restaurant inspection.||string||-|
|Violation_Code||Violation codes that are associated with each restaurant inspection.||string||-|
|Violation_Description||This field is the description that corresponds to the violation codes||string||-|
|Is_Violation_Flag||This indicates if violation is critical, not critical or not applicable.||boolean||-|
|Total_Inspection_Score||Total 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.||integer||level : Ratio|
|Inspection_Grade||N = 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 closure||string||-|
|Grade_Issuance_Date||The date when the current grade was issued to the entity (restaurant)||date||-|
|Inspection_Type||The type of inspection. A combination of the program and inspection type.||string||-|
|Latitude||Latitude location of the restaurant||number||-|
|Longitude||Longitude location of the restaurant||number||-|
|Community_Board||Refers to the community board which are the local representative bodies.||integer||level : Ordinal|
|Council_District||The council district.||integer||level : Ordinal|
|Census_Tract||The geographic region for taking a census.||integer||level : Ratio|
|BIN||Refers to the BIN||integer||level : Ratio|
|BBL||Refers to the BBL||integer||level : Ratio|
|NTA||Refers to the NTA||string||-|
|CAMIS ID||Restaurant Name||Borough Name||Building Number||Street Name||Zip Code||Phone Number||Cuisine Description||Inspection Date||Action Taken||Violation Code||Violation Description||Is Violation Flag||Total Inspection Score||Inspection Grade||Grade Issuance Date||Inspection Type||Latitude||Longitude||Community Board||Council District||Census Tract||BIN||BBL||NTA|
|50138618||Manhattan||214||EAST 10 STREET||10003||7025804521.0||1900-01-01||40.729313700000006||-73.98575541||103||2||4000||1006409.0||1004510018||MN22|
|50136510||BUTTERLY BAKESHOP||Manhattan||341||EAST 78 STREET||10075||6463062806.0||1900-01-01||40.77220342||-73.95447305||108||5||13400||1045246.0||1014530016||MN31|
|50119454||Manhattan||400||WEST 61 STREET||10023||3478791832.0||1900-01-01||40.77335939||-73.99077170000001||107||6||15100||1089723.0||1011710154||MN14|
|50131285||Brooklyn||535||VAN BUREN ST||11221||9294688684.0||1900-01-01||40.69187496||-73.92748658||303||41||38700||3||BK35|
|50125503||ALOHA KRAB||Queens||20413||HILLSIDE AVE||11423||7184702995.0||1900-01-01||40.72040297||-73.76094786||408||23||47800||4224410.0||4105330001||QN06|
|50106301||THE FRIENDS EXPERIENCE||Manhattan||130||EAST 23 STREET||10010||2124706665.0||1900-01-01||40.73962295||-73.98504952||105||2||6800||1018013.0||1008787501||MN21|
|50129506||Manhattan||42||WEST 56 STREET||10019||6318776068.0||1900-01-01||40.76287774||-73.97588963||105||4||10400||1034847.0||1012710061||MN17|
|50134720||CANTON MANOR||Queens||22015||NORTHERN BLVD||11361||9293683366.0||1900-01-01||40.76150678||-73.76134846||411||19||147100||4138709.0||4063230022||QN46|