Chicago

Close
Author
State of IL
Description
This dataset contains all current and active business licenses issued by the Department of Business Affairs and Consumer Protection. 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 my file this type of application. 'C_EXPA' only applies to businesses that have liquor licenses. It means the business location expanded. LICENSE STATUS: 'AAI' means the license was issued. Business license owners may be accessed at: http://data.cityofchicago.org/Community-Economic-Development/Business-Owners/ezma-pppn To identify the owner of a business, you will need the account number or legal name. Data Owner: Business Affairs and Consumer Protection Time Period: Current Frequency: Data is updated daily
Category
Community & Economic Development
Tags
business, licenses, current
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:

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
POLICE DISTRICT
police_district
LICENSE CODE
license_code
LICENSE DESCRIPTION
license_description
LICENSE NUMBER
license_number
APPLICATION TYPE
application_type
PAYMENT DATE
payment_date
LICENSE TERM START DATE
license_start_date
LICENSE TERM EXPIRATION DATE
expiration_date
DATE ISSUED
date_issued
LICENSE STATUS
license_status
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.