- 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||-|
|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|
|50059864||GIOVANNI RESTAURANT||Bronx||579||GRAND CONCOURSE||10451||7184026996||Italian||2019-03-25||Violations were cited in the following area(s).||08C||Pesticide use not in accordance with label or applicable laws. Prohibited chemical used/stored. Open bait station used.||False||38||Cycle Inspection / Initial Inspection||40.81930011||-73.92697145|
|50065358||ANDIAMO CAFE||Bronx||2467||GRAND CONCOURSE||10468||7186187989||American||2019-12-03||Violations were cited in the following area(s).||06A||Personal cleanliness inadequate. Outer garment soiled with possible contaminant. Effective hair restraint not worn in an area where food is prepared.||True||12||Cycle Inspection / Initial Inspection||40.86172226||-73.89754343|
|41396908||PRET A MANGER||Manhattan||50||BROADWAY||10004||2123440105||Sandwiches||2016-11-28||Violations were cited in the following area(s).||06C||Food not protected from potential source of contamination during storage, preparation, transportation, display or service.||True||12||A||2016-11-28||Cycle Inspection / Initial Inspection||40.70644172||-74.01276089|
|40596377||LOS PAPIS RESTAURANT||Brooklyn||77||BRIDGE STREET||11201||7185966965||Latin (Cuban, Dominican, Puerto Rican, South & Central American)||2019-03-22||Violations were cited in the following area(s).||10F||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.||False||18||Cycle Inspection / Initial Inspection||40.70210193||-73.98470813|
|41574056||LE PAIN QUOTIDIEN||Manhattan||708||3 AVENUE||10017||6467360949||French||2019-04-25||Violations were cited in the following area(s).||06C||Food not protected from potential source of contamination during storage, preparation, transportation, display or service.||True||13||A||2019-04-25||Cycle Inspection / Re-inspection||40.75232083||-73.97332364|
|50059366||CICCIO CAFE||Manhattan||192||6 AVENUE||10013||6464769498||Ice Cream, Gelato, Yogurt, Ices||2018-11-05||Violations were cited in the following area(s).||06D||Food contact surface not properly washed, rinsed and sanitized after each use and following any activity when contamination may have occurred.||True||10||A||2018-11-05||Cycle Inspection / Initial Inspection||40.72647095||-74.00362594|
|40859224||MAD RIVER BAR & GRILLE||Manhattan||1442||3 AVENUE||10028||2129881832||American||2019-12-19||Violations were cited in the following area(s).||10B||Plumbing 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.||False||13||A||2019-12-19||Cycle Inspection / Initial Inspection||40.77602747||-73.9560302|
|50048625||SWEETS BAKERY||Queens||14406||NORTHERN BLVD||11354||7188868618||Bakery||2019-07-17||Violations were cited in the following area(s).||02B||Hot food item not held at or above 140Âº F.||True||23||Cycle Inspection / Initial Inspection||40.76468715||-73.82304972|
|50081515||COFFEE FACTORY||Queens||4018||150TH ST||11354||7189392405||CafÃ©/Coffee/Tea||2019-03-04||Violations were cited in the following area(s).||10H||Proper sanitization not provided for utensil ware washing operation.||False||20||Cycle Inspection / Initial Inspection||40.7632075||-73.81422385|
|41709543||SUBWAY||Manhattan||35||WEST 33 STREET||10001||2126959194||Sandwiches||2017-02-28||Violations were cited in the following area(s).||09C||Food contact surface not properly maintained.||False||12||A||2017-02-28||Cycle Inspection / Initial Inspection||40.74859856||-73.98701807|