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
This dataset has the following 34 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| ID | id | text | A calculated ID for each record. | 2646812-20190801 2632057-20181108 1618090-20180216 2670810-20190604 1592650-20180416 view top 100 |
| LICENSE ID | license_id | number | An internal database ID for each record. Each license can have multiple records as it goes through renewals and other transactions. See the LICENSE NUMBER field for the number generally known to the public and used in most other data sources that refer to the license. | 2642101 2628532 2656366 2577753 2653987 view top 100 |
| ACCOUNT NUMBER | account_number | number | The account number of the business owner, which will stay consistent across that owner's licenses and can be used to find the owner in the Business Owners dataset. | 147 63160 7551 5273 299710 view top 100 |
| SITE NUMBER | site_number | number | An internal database ID indicating the location of this licensed business to account for business owners with more than one location. | 1 2 3 4 5 view top 100 |
| LEGAL NAME | legal_name | text | WALGREEN CO. SP PLUS CORPORATION BOND DRUG COMPANY OF ILLINOIS, LLC ALDI INC. STARBUCKS CORPORATION view top 100 | |
| DOING BUSINESS AS NAME | doing_business_as_name | text | SUBWAY DUNKIN DONUTS BOOST MOBILE SONDER 7-ELEVEN view top 100 | |
| ADDRESS | address | text | [REDACTED FOR PRIVACY] 2608 S DAMEN AVE 2300 S THROOP ST 4815-4835 W HARRISON ST 1500 N HOOKER ST view top 100 | |
| CITY | city | text | CHICAGO DES PLAINES SKOKIE CICERO NORTHBROOK view top 100 | |
| STATE | state | text | IL IN CA NY TX view top 100 | |
| ZIP CODE | zip_code | text | 60608 60611 60618 60647 60614 view top 100 | |
| WARD | ward | number | The ward where the business is located. | 42 27 25 2 1 view top 100 |
| PRECINCT | precinct | number | The precinct within the ward where the business is located. Note the the same precinct numbers exist in multiple wards. | 9 27 12 21 6 view top 100 |
| WARD PRECINCT | ward_precinct | text | The ward and precinct where the business is located. This column can be used to filter by precinct more easily across multiple wards. | 42-9 42- 27- 42-12 41-27 view top 100 |
| POLICE DISTRICT | police_district | number | 1 18 19 12 8 view top 100 | |
| LICENSE CODE | license_code | number | 1010 1006 4404 1475 1781 view top 100 | |
| LICENSE DESCRIPTION | license_description | text | Limited Business License Retail Food Establishment Regulated Business License Consumption on Premises - Incidental Activity Tobacco view top 100 | |
| BUSINESS ACTIVITY ID | business_activity_id | text | 775 638 735 781 763 view top 100 | |
| BUSINESS ACTIVITY | business_activity | text | Retail Sales of Perishable Foods Consumption of Liquor on Premises Preparation of Food and Dining on Premise With Seating Sale of Food Prepared Onsite With Dining Area Retail Sale of Tobacco view top 100 | |
| LICENSE NUMBER | license_number | number | The license number known to the public and generally used in other data sources that refer to the license. This is the field most users will want for most purposes. Each license has a single license number that stays consistent throughout the lifetime of the license. By contrast, the LICENSE ID field is an internal database ID and not generally useful to external users. | 2042348 1942862 2560888 1518236 2569279 view top 100 |
| APPLICATION TYPE | application_type | text | RENEW ISSUE C_LOC C_EXPA C_SBA view top 100 | |
| APPLICATION CREATED DATE | application_created_date | calendar_date | The date the business license application was created. RENEW type records do not have an application. | 2019-03-05T00:00:00.000 2019-02-11T00:00:00.000 2019-05-31T00:00:00.000 2019-03-29T00:00:00.000 2019-02-13T00:00:00.000 view top 100 |
| APPLICATION REQUIREMENTS COMPLETE | application_requirements_complete | calendar_date | For all application types except RENEW, this is the date all required application documents were received. For RENEW type records, this is the date the record was created. | 2019-05-15T00:00:00.000 2019-01-15T00:00:00.000 2019-02-22T00:00:00.000 2019-07-15T00:00:00.000 2018-07-15T00:00:00.000 view top 100 |
| PAYMENT DATE | payment_date | calendar_date | 2019-10-15T00:00:00.000 2019-04-25T00:00:00.000 2019-03-07T00:00:00.000 2018-04-20T00:00:00.000 2019-05-15T00:00:00.000 view top 100 | |
| CONDITIONAL APPROVAL | conditional_approval | text | This pertains to applications that contain liquor licenses. Customers may request a conditional approval prior to building out the space. | N Y view top 100 |
| LICENSE TERM START DATE | license_start_date | calendar_date | 2019-07-16T00:00:00.000 2019-03-16T00:00:00.000 2019-04-16T00:00:00.000 2019-09-16T00:00:00.000 2018-09-16T00:00:00.000 view top 100 | |
| LICENSE TERM EXPIRATION DATE | expiration_date | calendar_date | 2020-09-15T00:00:00.000 2020-08-15T00:00:00.000 2020-02-15T00:00:00.000 2020-05-15T00:00:00.000 2020-10-15T00:00:00.000 view top 100 | |
| LICENSE APPROVED FOR ISSUANCE | license_approved_for_issuance | calendar_date | This is the date the license was ready for issuance. Licenses may not be issued if the customer owes debt to the City. | 2019-10-15T00:00:00.000 2019-03-07T00:00:00.000 2019-04-25T00:00:00.000 2018-04-20T00:00:00.000 2019-01-14T00:00:00.000 view top 100 |
| DATE ISSUED | date_issued | calendar_date | 2019-03-12T00:00:00.000 2019-11-14T00:00:00.000 2018-04-24T00:00:00.000 2019-04-16T00:00:00.000 2019-10-15T00:00:00.000 view top 100 | |
| LICENSE STATUS | license_status | text | AAI view top 100 | |
| LICENSE STATUS CHANGE DATE | license_status_change_date | calendar_date | view top 100 | |
| SSA | ssa | text | Special Service Areas are local tax districts that fund expanded services and programs, to foster commercial and economic development, through a localized property tax. In other cities these areas are sometimes called Business Improvement Districts (BIDs). This portal contains a map of all Chicago SSAs | 33 1 17 34 3 view top 100 |
| LATITUDE | latitude | number | 42.008536401 41.888074281 41.881921563 41.819441426 41.844511469 view top 100 | |
| LONGITUDE | longitude | number | -87.914428439 -87.634955203 -87.62606306 -87.665375545 -87.675788039 view top 100 | |
| LOCATION | location | location | view top 100 |