Dataset: Business Licenses

About this Dataset

Business Licenses

NOTE, 2/21/2025 - We have added three geographic columns to this dataset. Business licenses issued by the Department of Business Affairs and Consumer Protection in the City of Chicago from 2002 to the present. This dataset contains a large number of records/rows of data and may not be viewed in full in Microsoft Excel. Therefore, when downloading the file, select CSV from the Export menu. Open the file in an ASCII text editor, such as Notepad or Wordpad, to view and search. Data fields requiring description are detailed below. APPLICATION TYPE: ‘ISSUE’ is the record associated with the initial license application. ‘RENEW’ is a subsequent renewal record. All renewal records are created with a term start date and term expiration date. ‘C_LOC’ is a change of location record. It means the business moved. ‘C_CAPA’ is a change of capacity record. Only a few license types may file this type of application. ‘C_EXPA’ only applies to businesses that have liquor licenses. It means the business location expanded. 'C_SBA' is a change of business activity record. It means that a new business activity was added or an existing business activity was marked as expired. LICENSE STATUS: ‘AAI’ means the license was issued. ‘AAC’ means the license was cancelled during its term. ‘REV’ means the license was revoked. 'REA' means the license revocation has been appealed. LICENSE STATUS CHANGE DATE: This date corresponds to the date a license was cancelled (AAC), revoked (REV) or appealed (REA). Business License Owner information may be accessed at: https://data.cityofchicago.org/dataset/Business-Owners/ezma-pppn. To identify the owner of a business, you will need the account number or legal name, which may be obtained from this Business Licenses dataset. Data Owner: Business Affairs and Consumer Protection. Time Period: January 1, 2002 to present. Frequency: Data is updated daily.
Organization: City of Chicago
Last updated: 2020-11-10T16:55:18.358515
Tags: business, licenses

Tables

Table 1

@usgov.city_of_chicago_business_licenses.table_1

135.47 MB
1165559 rows
37 columns


CREATE TABLE table_1 (
  "id" VARCHAR,
  "license_id" BIGINT,
  "account_number" BIGINT,
  "site_number" BIGINT,
  "legal_name" VARCHAR,
  "doing_business_as_name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "ward" DOUBLE,
  "precinct" DOUBLE,
  "ward_precinct" VARCHAR,
  "police_district" DOUBLE,
  "community_area" DOUBLE,
  "community_area_name" VARCHAR,
  "neighborhood" VARCHAR,
  "license_code" BIGINT,
  "license_description" VARCHAR,
  "business_activity_id" VARCHAR,
  "business_activity" VARCHAR,
  "license_number" DOUBLE,
  "application_type" VARCHAR,
  "application_created_date" TIMESTAMP,
  "application_requirements_complete" TIMESTAMP,
  "payment_date" TIMESTAMP,
  "conditional_approval" VARCHAR,
  "license_term_start_date" TIMESTAMP,
  "license_term_expiration_date" VARCHAR,
  "license_approved_for_issuance" TIMESTAMP,
  "date_issued" TIMESTAMP,
  "license_status" VARCHAR,
  "license_status_change_date" TIMESTAMP,
  "ssa" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);