All Results API
← All results

Department of Health and Mental Hygiene (DOHMH), NYC OpenDataDOHMH New York City Restaurant Inspection Results

Published Mar 30, 2026 by geohacker

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. Records include violation citations, inspection results, grades, and scores for NYC restaurants across all five boroughs. Updated daily with approximately 295K rows and 27 columns.

📊 View Analysis Report 🗺️ View Interactive Map

Categories

inspection_services restaurant

Category Inference

NYC restaurant and food service establishment inspection records, including violation citations, inspection dates, grades, scores, and location information for restaurants and college cafeterias across all five NYC boroughs

Fallback category: eat_and_drink›restaurant

Source category mappings

(11)
Source category Overture category Confidence Valid
Cycle Inspection / Reopening Inspection professional_services›construction_services›inspection_services 0.82 ✓
Administrative Miscellaneous / Compliance Inspection professional_services›construction_services›inspection_services 0.65 ✓
Trans Fat / Re-inspection eat_and_drink›restaurant 0.60 ✓
Administrative Miscellaneous / Initial Inspection professional_services›construction_services›inspection_services 0.55 ✓
Inter-Agency Task Force / Initial Inspection professional_services›construction_services›inspection_services 0.55 ✓
Pre-permit (Non-operational) / Initial Inspection eat_and_drink›restaurant 0.55 ✓
Pre-permit (Operational) / Initial Inspection eat_and_drink›restaurant 0.55 ✓
Smoke-Free Air Act / Initial Inspection eat_and_drink›restaurant 0.55 ✓
Calorie Posting / Initial Inspection professional_services›construction_services›inspection_services 0.45 ✓
Cycle Inspection / Initial Inspection professional_services›construction_services›inspection_services 0.45 ✓
Cycle Inspection / Re-inspection professional_services›construction_services›inspection_services 0.35 ✓

Source Schema

(27 columns)
Name Type Null % Unique Sample values
CAMIS int64 0.0% 7936
  • 50179758
  • 50156196
  • 50128981
DBA object 0.0% 6845
  • GOLDEN CHILD
  • GINGER AND GLATT LTD
  • LOOSIE'S
BORO object 0.0% 6
  • Manhattan
  • Manhattan
  • Manhattan
BUILDING object 0.4% 3985
  • 444
  • 750
  • 145
STREET object 0.0% 1259
  • PARK AVENUE SOUTH
  • 8 AVENUE
  • BOWERY
ZIPCODE float64 1.1% 204
  • 10016.0
  • 10036.0
  • 10002.0
PHONE object 0.0% 7717
  • 7726963085
  • 3474611355
  • 2122490315
CUISINE DESCRIPTION object 1.2% 85
  • Mediterranean
  • Bottled Beverages
  • Chinese
INSPECTION DATE object 0.0% 1223
  • 01/01/1900
  • 01/01/1900
  • 01/01/1900
ACTION object 1.2% 5
  • Violations were cited in the following area(s).
  • No violations were recorded at the time of this inspection.
  • Violations were cited in the following area(s).
VIOLATION CODE object 1.9% 97
  • 09B
  • 02B
  • 02B
VIOLATION DESCRIPTION object 1.9% 152
  • Thawing procedure improper.
  • Hot food item not held at or above 140º F.
  • Hot TCS food item not held at or above 140 °F.
CRITICAL FLAG object 0.0% 3
  • Not Applicable
  • Not Applicable
  • Not Applicable
SCORE float64 5.6% 128
  • 13.0
  • 23.0
  • 9.0
GRADE object 50.9% 6
  • A
  • A
  • A
GRADE DATE object 54.0% 1050
  • 09/11/2025
  • 01/29/2025
  • 12/08/2023
RECORD DATE object 0.0% 1
  • 03/17/2026
  • 03/17/2026
  • 03/17/2026
INSPECTION TYPE object 1.2% 26
  • Cycle Inspection / Re-inspection
  • Smoke-Free Air Act / Initial Inspection
  • Pre-permit (Operational) / Initial Inspection
Latitude float64 0.7% 7365
  • 40.744697739719
  • 40.759871379059
  • 40.719106667877
Longitude float64 0.7% 7365
  • -73.983081533353
  • -73.987849705278
  • -73.994527427259
Community Board float64 1.7% 63
  • 105.0
  • 105.0
  • 103.0
Council District float64 1.7% 51
  • 2.0
  • 3.0
  • 1.0
Census Tract float64 1.7% 1008
  • 7400.0
  • 12500.0
  • 1800.0
BIN float64 2.2% 6994
  • 1016966.0
  • 1024736.0
  • 1005635.0
BBL float64 0.7% 6954
  • 1008600037.0
  • 1010187502.0
  • 1004230009.0
NTA object 1.7% 191
  • MN17
  • MN17
  • MN27
Location object 1.7% 7364
  • POINT (-73.983081533353 40.744697739719)
  • POINT (-73.987849705278 40.759871379059)
  • POINT (-73.994527427259 40.719106667877)

Quality Report

✅ Dataset is usable

Geographic Bounds

Coordinates: Southwest (-74.2491, 40.4996) - Northeast (-73.7009, 40.9128)