Dataset: Food Safety Inspections – Current Ratings

About this Dataset

Food Safety Inspections – Current Ratings

Dataset includes all food safety inspections conducted in last 24 months.
Organization: State of New York
Last updated: 2021-08-06T15:10:41.567449
Tags: establishment-types, food-safety, inspections

Tables

Table 1

@usgov.state_of_new_york_food_safety_inspections_current_ratings.table_1

7.98 MB
143601 rows
13 columns


CREATE TABLE table_1 (
  "county" VARCHAR,
  "inspection_grade" VARCHAR,
  "inspection_date" TIMESTAMP,
  "establishment_types" VARCHAR,
  "owner_name" VARCHAR,
  "trade_name" VARCHAR,
  "street" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" BIGINT,
  "deficiency_number" VARCHAR,
  "deficiency_description" VARCHAR,
  "georeference" VARCHAR
);