About this Dataset

DOHMH School Cafeteria Inspections (2020-Present)

The dataset contains current inspection data for cafeterias permitted in public, private, and parochial schools in NYC. All school cafeterias are required to be in compliance with NYS and NYC Food Safety Regulations, found in New York City Health Code Article 81. School cafeteria inspections are conducted at least annually to ensure compliance with food safety regulations. This dataset includes information obtained as part of the permitting process and data collected during inspections. This data includes inspection results for active school cafeterias for the last three years. Data for cafeterias that have ceased operations and any violations cited during the inspection that were dismissed during adjudication are excluded from this dataset
Organization: City of New York
Last updated: 2023-04-01T07:16:16.037221
Tags: cafeteria, inspections, parochial, private, public, school, violations

Tables

Table 1

@usgov.city_of_new_york_dohmh_school_cafeteria_inspections_20_118eaa06.table_1

619.64 kB
18,132 rows
25 columns

CREATE TABLE table_1 (
  "record_id" VARCHAR,
  "schoolname" VARCHAR,
  "number" VARCHAR,
  "street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "borough" VARCHAR,
  "zipcode" DOUBLE,
  "lastinspection" TIMESTAMP,
  "permittee" VARCHAR,
  "inspectiondate" TIMESTAMP,
  "ptet" BIGINT,
  "site_type" VARCHAR,
  "level" VARCHAR,
  "code" VARCHAR,
  "violationdescription" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "communityboard" DOUBLE,
  "councildistrict" DOUBLE,
  "censustract" DOUBLE,
  "bin" DOUBLE,
  "bbl" BIGINT,
  "nta" VARCHAR,
  "borocode" BIGINT
);