About this Dataset

HISTORICAL Sidewalk Café Licenses And Applications

NOTE: This dataset reflects a historical program that is no longer active. The NYC Department of Transportation will be responsible for regulating outdoor dining under the new Dining Out program, and will be publishing program data once its available. In the interim, please consult the Open Restaurants dataset. This dataset features detailed information about sidewalk café license applications and, if applicable, issued licenses.
Organization: City of New York
Last updated: 2021-08-07T17:30:23.364827
Tags: business, cafe, city-government, dca, department-of-consumer-affairs, license, sidewalk

Tables

Table 1

@usgov.city_of_new_york_sidewalk_cafe_licenses_and_applications.table_1

79.94 kB
324 rows
47 columns

CREATE TABLE table_1 (
  "license_nbr" VARCHAR,
  "lic_status" VARCHAR,
  "business_name" VARCHAR,
  "business_name2" VARCHAR,
  "building" VARCHAR,
  "street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "swc_type" VARCHAR,
  "swc_sq_ft" BIGINT,
  "swc_tables" BIGINT,
  "swc_chairs" BIGINT,
  "dohmh" VARCHAR,
  "final_x" BIGINT,
  "final_y" BIGINT,
  "community_district" BIGINT,
  "city_council_district" BIGINT,
  "cd_url" VARCHAR,
  "app_id" VARCHAR,
  "app_swc_type" VARCHAR,
  "app_sq_ft" BIGINT,
  "app_tables" BIGINT,
  "app_chairs" BIGINT,
  "app_status" VARCHAR,
  "app_status_date" TIMESTAMP,
  "expiration_date" TIMESTAMP,
  "app_too_date" TIMESTAMP,
  "submit_date" TIMESTAMP,
  "intake" VARCHAR,
  "intake_dd" TIMESTAMP,
  "dpqa" VARCHAR,
  "send_package_dd" TIMESTAMP,
  "cp" VARCHAR,
  "cp_dd" TIMESTAMP,
  "cb" VARCHAR,
  "cb_dd" TIMESTAMP,
  "hearing" VARCHAR,
  "hearing_dd" TIMESTAMP,
  "hearing_public" VARCHAR,
  "hearing_public_dd" TIMESTAMP,
  "cc" VARCHAR,
  "cc_dd" TIMESTAMP,
  "moo" VARCHAR,
  "moo_dd" TIMESTAMP,
  "issuance" VARCHAR,
  "issuance_dd" TIMESTAMP
);