About this Dataset

Building Permits

This dataset includes information about building permits issued by the City of Chicago from 2006 to the present, excluding permits that have been voided or revoked after issuance. Most types of permits are issued subject to payment of the applicable permit fee. Work under a permit may not begin until the applicable permit fee is paid.

For more information about building permits, see http://www.chicago.gov/permit.
Organization: City of Chicago
Last updated: 2020-11-10T16:55:37.720164
Tags: buildings, permits

Tables

Table 1

@usgov.city_of_chicago_building_permits.table_1

112.25 MB
805,282 rows
115 columns

CREATE TABLE table_1 (
  "id" VARCHAR,
  "permit" VARCHAR  -- PERMIT#,
  "permit_status" VARCHAR,
  "permit_milestone" VARCHAR,
  "permit_type" VARCHAR,
  "review_type" VARCHAR,
  "application_start_date" TIMESTAMP,
  "issue_date" TIMESTAMP,
  "processing_time" DOUBLE,
  "street_number" DOUBLE,
  "street_direction" VARCHAR,
  "street_name" VARCHAR,
  "work_type" VARCHAR,
  "work_description" VARCHAR,
  "building_fee_paid" DOUBLE,
  "zoning_fee_paid" DOUBLE,
  "other_fee_paid" DOUBLE,
  "subtotal_paid" DOUBLE,
  "building_fee_unpaid" DOUBLE,
  "zoning_fee_unpaid" DOUBLE,
  "other_fee_unpaid" DOUBLE,
  "subtotal_unpaid" DOUBLE,
  "building_fee_waived" DOUBLE,
  "building_fee_subtotal" DOUBLE,
  "zoning_fee_subtotal" DOUBLE,
  "other_fee_subtotal" DOUBLE,
  "zoning_fee_waived" DOUBLE,
  "other_fee_waived" DOUBLE,
  "subtotal_waived" DOUBLE,
  "total_fee" DOUBLE,
  "contact_1_type" VARCHAR,
  "contact_1_name" VARCHAR,
  "contact_1_city" VARCHAR,
  "contact_1_state" VARCHAR,
  "contact_1_zipcode" VARCHAR,
  "contact_2_type" VARCHAR,
  "contact_2_name" VARCHAR,
  "contact_2_city" VARCHAR,
  "contact_2_state" VARCHAR,
  "contact_2_zipcode" VARCHAR,
  "contact_3_type" VARCHAR,
  "contact_3_name" VARCHAR,
  "contact_3_city" VARCHAR,
  "contact_3_state" VARCHAR,
  "contact_3_zipcode" VARCHAR,
  "contact_4_type" VARCHAR,
  "contact_4_name" VARCHAR,
  "contact_4_city" VARCHAR,
  "contact_4_state" VARCHAR,
  "contact_4_zipcode" VARCHAR,
  "contact_5_type" VARCHAR,
  "contact_5_name" VARCHAR,
  "contact_5_city" VARCHAR,
  "contact_5_state" VARCHAR,
  "contact_5_zipcode" VARCHAR,
  "contact_6_type" VARCHAR,
  "contact_6_name" VARCHAR,
  "contact_6_city" VARCHAR,
  "contact_6_state" VARCHAR,
  "contact_6_zipcode" VARCHAR,
  "contact_7_type" VARCHAR,
  "contact_7_name" VARCHAR,
  "contact_7_city" VARCHAR,
  "contact_7_state" VARCHAR,
  "contact_7_zipcode" VARCHAR,
  "contact_8_type" VARCHAR,
  "contact_8_name" VARCHAR,
  "contact_8_city" VARCHAR,
  "contact_8_state" VARCHAR,
  "contact_8_zipcode" VARCHAR,
  "contact_9_type" VARCHAR,
  "contact_9_name" VARCHAR,
  "contact_9_city" VARCHAR,
  "contact_9_state" VARCHAR,
  "contact_9_zipcode" VARCHAR,
  "contact_10_type" VARCHAR,
  "contact_10_name" VARCHAR,
  "contact_10_city" VARCHAR,
  "contact_10_state" VARCHAR,
  "contact_10_zipcode" VARCHAR,
  "contact_11_type" VARCHAR,
  "contact_11_name" VARCHAR,
  "contact_11_city" VARCHAR,
  "contact_11_state" VARCHAR,
  "contact_11_zipcode" VARCHAR,
  "contact_12_type" VARCHAR,
  "contact_12_name" VARCHAR,
  "contact_12_city" VARCHAR,
  "contact_12_state" VARCHAR,
  "contact_12_zipcode" VARCHAR,
  "contact_13_type" VARCHAR,
  "contact_13_name" VARCHAR,
  "contact_13_city" VARCHAR,
  "contact_13_state" VARCHAR,
  "contact_13_zipcode" VARCHAR,
  "contact_14_type" VARCHAR,
  "contact_14_name" VARCHAR,
  "contact_14_city" VARCHAR,
  "contact_14_state" VARCHAR,
  "contact_14_zipcode" VARCHAR
);