About this Dataset

Sidewalk Cafe Permits

A list of permits for sidewalk cafes -- outdoor restaurant seating on the public way. Businesses may begin sidewalk cafe operations on March 1 and operate through December 1.

For more information on this type of permit, see https://www.cityofchicago.org/city/en/depts/bacp/supp_info/sidewalk_cafe_current_permits.html.
Organization: City of Chicago
Last updated: 2020-11-10T16:55:12.956099
Tags: business, licenses, link-to-article-present, seasonal, sidewalk-cafes, summer

Tables

Table 1

@usgov.city_of_chicago_sidewalk_cafe_permits.table_1

987.11 KB
24507 rows
22 columns


CREATE TABLE table_1 (
  "permit_number" BIGINT,
  "account_number" BIGINT,
  "site_number" BIGINT,
  "legal_name" VARCHAR,
  "doing_business_as_name" VARCHAR,
  "issued_date" TIMESTAMP,
  "expiration_date" TIMESTAMP,
  "payment_date" TIMESTAMP,
  "address" VARCHAR,
  "address_number_start" BIGINT,
  "address_number" BIGINT,
  "street_direction" VARCHAR,
  "street" VARCHAR,
  "street_type" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "ward" BIGINT,
  "police_district" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);