About this Dataset

Open Restaurant Applications (Historic)

The Temporary Program, is no longer accepting applications.
*****Visit Permanent Dining Out website for information: https://www.diningoutnyc.info/

The New York City Open Restaurant is an effort to implement a citywide multi-phase program to expand outdoor seating options for food establishments to promote open space, enhance social distancing, and help them rebound in these difficult economic times.
For real time updates on restaurants registered in the program, please visit NYC Open Restaurants dashboard: https://bit.ly/2Z00kn8
** Please note this Open Restaurant Applications dataset may contain multiple entries (e.g. restaurants submitting 2 or more applications). The Open Restaurants dashboard website containing real time update, noted above, will have fewer total records due to the removal of multiple applications and only list the newest entry.
Organization: City of New York
Last updated: 2020-11-10T17:04:35.463068
Tags: open, restaurant, roadway, sidewalk

Tables

Table 1

@usgov.city_of_new_york_open_restaurant_applications.table_1

2.47 MB
14,428 rows
35 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "globalid" VARCHAR,
  "seating_interest_sidewalk_roadway_both" VARCHAR  -- Seating Interest (Sidewalk/Roadway/Both),
  "restaurant_name" VARCHAR,
  "legal_business_name" VARCHAR,
  "doing_business_as_dba" VARCHAR  -- Doing Business As (DBA),
  "building_number" VARCHAR,
  "street" VARCHAR,
  "borough" VARCHAR,
  "postcode" BIGINT,
  "business_address" VARCHAR,
  "food_service_establishment_permit" VARCHAR  -- Food Service Establishment Permit #,
  "sidewalk_dimensions_length" DOUBLE  -- Sidewalk Dimensions (Length),
  "sidewalk_dimensions_width" DOUBLE  -- Sidewalk Dimensions (Width),
  "sidewalk_dimensions_area" DOUBLE  -- Sidewalk Dimensions (Area),
  "roadway_dimensions_length" DOUBLE  -- Roadway Dimensions (Length),
  "roadway_dimensions_width" DOUBLE  -- Roadway Dimensions (Width),
  "roadway_dimensions_area" DOUBLE  -- Roadway Dimensions (Area),
  "approved_for_sidewalk_seating" VARCHAR,
  "approved_for_roadway_seating" VARCHAR,
  "qualify_alcohol" VARCHAR,
  "sla_serial_number" VARCHAR,
  "sla_license_type" VARCHAR,
  "landmark_district_or_building" VARCHAR,
  "landmarkdistrict_terms" VARCHAR,
  "healthcompliance_terms" VARCHAR,
  "time_of_submission" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);