Name: Open Restaurants Inspections
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Open Restaurants Inspections

The Open Restaurants Inspections dataset contains records of site setup inspections performed throughout the five boroughs of New York City.
Organization: City of New York
Last updated: 2020-11-10T17:00:39.204590
Tags: inspection, open-restaurants, site-setup

Tables

Table 1

@usgov.city_of_new_york_open_restaurants_inspections.table_1

3.24 MB
81,553 rows
20 columns

CREATE TABLE table_1 (
  "borough" VARCHAR,
  "restaurantname" VARCHAR,
  "seatingchoice" VARCHAR,
  "legalbusinessname" VARCHAR,
  "businessaddress" VARCHAR,
  "restaurantinspectionid" BIGINT,
  "issidewaycompliant" VARCHAR,
  "isroadwaycompliant" VARCHAR,
  "skippedreason" VARCHAR,
  "inspectedon" VARCHAR,
  "agencycode" VARCHAR,
  "postcode" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "communityboard" DOUBLE,
  "councildistrict" DOUBLE,
  "censustract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);