DOHMH School Cafeteria inspections (2020 - Present)

Citation URL https://data.cityofnewyork.us/Health/DOHMH-School-Cafeteria-inspections-2020-Present-/5ery-qagt
Data URL https://data.cityofnewyork.us/api/views/5ery-qagt/rows.csv?accessType=DOWNLOAD
Output URL https://wegov-research-api.s3.amazonaws.com/dohmhInspections.csv

Source Metadata

name DOHMH School Cafeteria Inspections (2020-Present)
description This is an official DOHMH dataset. Creating derivative/community datasets based on this dataset is allowed so long as it is done in a manner that is not misleading and does not imply endorsement of such datasets by DOHMH. The dataset contains current inspection data for cafeterias permitted in public, private, and parochial schools in NYC. Data for cafeterias that have ceased operations and any violations cited during the inspection that were dismissed during adjudication are excluded from this dataset. During COVID-19 public health emergency, Health Department inspections have followed a modified inspection protocol designed to reduce the risk of COVID-19 transmission among inspectors and staff of facilities being inspected. As a result, there may be differences in the data collected during this time period compared to data collected prior to March 2020.
attribution Department of Health and Mental Hygiene
id 5ery-qagt
assetType dataset
category Health
createdAt 2023-03-24 21:01:27
provenance official
rowsUpdatedAt 2025-12-17 11:02:56
Columns
Name Data Type Description Field Name
Record ID text Unique identifier for the establishment (school) entityid
SchoolName text Establishment (school) name schoolname
Number text Building number for establishment (school) location number
Street text Street name for establishment (school) location street
City text Municipality of establishment (school) city
State text State of establishment (school) state
Borough text Borough of establishment (school) location borough
ZipCode text Zip code of establishment (school) location zipcode
LastInspection calendar_date Date of last inspection lastinspection
Permittee text Name of business owner holding the permit permittee
InspectionDate calendar_date Date an inspection was conducted inspectiondate
PTET text Permit Type Establishment Type - The four digit code indicating the type of permit and the type of food service establishment (FSE) ptet
Site Type text The description of the type of food service establishment (FSE) site_type
Level text Indicator of the type of violation; Critical violations are those most likely to contribute to foodborne illness. level
Code text Violation code associated with inspection finding; Blank field indicates no violations were cited during inspection code
ViolationDescription text Violation description associated with inspection finding; Blank field indicates no violations were cited during inspection violationdescription
LATITUDE number Latitude latitude
LONGITUDE number Longitude longitude
COMMUNITYBOARD text Community Board communityboard
COUNCILDISTRICT text NYC Council District councildistrict
CENSUSTRACT text Census Tract censustract
BIN text Building Identification Number bin
BBL text Borough-Block-Lot bbl
NTA text Neighborhood Tabulation Area nta
BOROCODE number Numerical code for the borough of establishment (school) location borocode

Databook Transformation

Normalized Fields COMMUNITYBOARD, COUNCILDISTRICT, SchoolName
Next Update Scheduled
Activity
Source Data Last Updated 2025-12-17 11:02:56
Transformed Data Last Updated 09/23/2025 13:53
Columns Added Calculating...
Added Column Names Calculating...

Data Previews

Loading data...

Loading data...