DOHMH School Cafeteria Inspections by US Government | Demographics and Population Studies

About this Dataset

DOHMH School Cafeteria Inspections

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: 2021-08-07T16:39:33.652784
Tags: cafeteria, inspections, parochial, private, public, school, violations

Tables

Table 1

@usgov.city_of_new_york_dohmh_school_cafeteria_inspections.table_1

764.23 KB
24550 rows
22 columns


CREATE TABLE table_1 (
  "record_id" BIGINT,
  "schoolname" VARCHAR,
  "borough" VARCHAR,
  "building" VARCHAR,
  "street" VARCHAR,
  "address_line_1" VARCHAR,
  "city" VARCHAR,
  "zipcode" DOUBLE,
  "last_inspection_date" TIMESTAMP,
  "permittee" VARCHAR,
  "inspection_date" TIMESTAMP,
  "code" VARCHAR,
  "violation_description" VARCHAR,
  "critical_level" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "communityboard" DOUBLE,
  "councildistrict" DOUBLE,
  "censustract" DOUBLE,
  "bin" DOUBLE,
  "bbl" BIGINT,
  "nta" VARCHAR
);