Go to an accessible version of this page

Chicago
Close
Author
cocadmin
Description
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.
Category
Community & Economic Development
Tags
business, licenses
Rating
Current value: 0 out of 5
Data Provided By
City of Chicago
Source Link
http://www.cityofchicago.org
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size

  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

ID
id
LICENSE ID
license_id
ACCOUNT NUMBER
account_number
SITE NUMBER
site_number
LEGAL NAME
legal_name
DOING BUSINESS AS NAME
doing_business_as_name
ADDRESS
address
CITY
city
STATE
state
ZIP CODE
zip_code
WARD
ward
PRECINCT
precinct
WARD PRECINCT
ward_precinct
POLICE DISTRICT
police_district
LICENSE CODE
license_code
LICENSE DESCRIPTION
license_description
BUSINESS ACTIVITY ID
business_activity_id
BUSINESS ACTIVITY
business_activity
LICENSE NUMBER
license_number
APPLICATION TYPE
application_type
APPLICATION CREATED DATE
application_created_date
APPLICATION REQUIREMENTS COMPLETE
application_requirements_complete
PAYMENT DATE
payment_date
CONDITIONAL APPROVAL
conditional_approval
LICENSE TERM START DATE
license_start_date
LICENSE TERM EXPIRATION DATE
expiration_date
LICENSE APPROVED FOR ISSUANCE
license_approved_for_issuance
DATE ISSUED
date_issued
LICENSE STATUS
license_status
LICENSE STATUS CHANGE DATE
license_status_change_date
SSA
ssa
LATITUDE
latitude
LONGITUDE
longitude
LOCATION
location
Community Areas
:@computed_region_vrxf_vc4k
Historical Wards 2003-2015
:@computed_region_awaf_s7ux
Zip Codes
:@computed_region_6mkv_f3dw
Census Tracts
:@computed_region_bdys_3d7i
Wards
:@computed_region_43wa_7qmu

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.