City of Chicago / Business Affairs & Consumer Protection: Chicago Business Licenses

Category Inference

A comprehensive registry of business licenses issued by the City of Chicago covering all types of commercial enterprises from 2002 to present, including restaurants, retail stores, contractors, service providers, entertainment venues, healthcare facilities, and any other entity requiring a city business license.

Fallback category: business_to_business›business

Source category mappings

(3)

Source category	Overture category	Confidence	Valid
C_LOC	business_to_business›business	0.60	✓
ISSUE	business_to_business›business	0.20	✓
RENEW	business_to_business›business	0.20	✓

Source Schema

(37 columns)

Name	Type	Null %	Unique	Sample values
ID	object	0.0%	10000	`54238-20040216` `2385499-20190316` `2775975-20250316`
LICENSE ID	int64	0.0%	10000	`1460511` `2645455` `3009871`
ACCOUNT NUMBER	int64	0.0%	8849	`85596` `396663` `468831`
SITE NUMBER	int64	0.0%	159	`2` `1` `2`
LEGAL NAME	object	0.0%	8841	`AMERICAN IGLOO BUILDERS INC` `BBP PLUMBING INC.` `FOUR SEASONS HOME SERVICES, LLC`
DOING BUSINESS AS NAME	object	0.0%	9151	`AMERICAN IGLOO BUILDERS,INC` `BBP PLUMBING INC` `FOUR SEASONS HOME SERVICES`
ADDRESS	object	0.0%	9178	`504 NORTH AVE` `209 CATHY LN` `9934 S 76 AVE B`
CITY	object	0.0%	320	`LIBERTYVILLE` `MOUNT PROSPECT` `BRIDGEVIEW`
STATE	object	0.0%	31	`IL` `IL` `IL`
ZIP CODE	float64	0.0%	386	`60048.0` `60056.0` `60455.0`
WARD	float64	8.0%	50	`6.0` `50.0` `34.0`
PRECINCT	float64	8.2%	75	`19.0` `12.0` `53.0`
WARD PRECINCT	object	8.0%	1975	`6-` `50-19` `34-12`
POLICE DISTRICT	float64	8.0%	22	`3.0` `24.0` `1.0`
COMMUNITY AREA	float64	8.8%	77	`2.0` `28.0` `30.0`
COMMUNITY AREA NAME	object	8.8%	77	`WEST RIDGE` `NEAR WEST SIDE` `SOUTH LAWNDALE`
NEIGHBORHOOD	object	8.8%	98	`WEST RIDGE` `WEST LOOP` `LITTLE VILLAGE`
LICENSE CODE	int64	0.0%	107	`1010` `4404` `4404`
LICENSE DESCRIPTION	object	0.0%	107	`Limited Business License` `Regulated Business License` `Regulated Business License`
BUSINESS ACTIVITY ID	object	46.2%	490	`673` `673` `763`
BUSINESS ACTIVITY	object	46.2%	490	`Home Repair Services` `Home Repair Services` `Retail Sale of Tobacco`
LICENSE NUMBER	int64	0.0%	9790	`54238` `2385499` `2775975`
APPLICATION TYPE	object	0.0%	6	`RENEW` `RENEW` `RENEW`
APPLICATION CREATED DATE	object	76.7%	1749	`10/08/2020` `06/11/2024` `05/04/2022`
APPLICATION REQUIREMENTS COMPLETE	object	1.5%	2150	`12/15/2003` `01/15/2019` `01/15/2025`
PAYMENT DATE	object	1.9%	4473	`01/08/2004` `02/16/2019` `03/12/2025`
CONDITIONAL APPROVAL	object	0.0%	2	`N` `N` `N`
LICENSE TERM START DATE	object	0.2%	2023	`02/16/2004` `03/16/2019` `03/16/2025`
LICENSE TERM EXPIRATION DATE	object	0.0%	471	`02/15/2005` `07/15/2021` `03/15/2027`
LICENSE APPROVED FOR ISSUANCE	object	4.5%	4385	`12/22/2003` `02/16/2019` `03/12/2025`
DATE ISSUED	object	0.0%	4313	`01/09/2004` `02/19/2019` `03/13/2025`
LICENSE STATUS	object	0.0%	3	`AAI` `AAI` `AAI`
LICENSE STATUS CHANGE DATE	object	93.0%	449	`03/05/2021` `07/12/2017` `12/28/2015`
SSA	float64	74.6%	53	`43.0` `59.0` `26.0`
LATITUDE	float64	8.0%	7442	`41.7659027811` `41.9977708754` `41.8804631471`
LONGITUDE	float64	8.0%	7442	`-87.6104916604` `-87.693945749` `-87.6408038843`
LOCATION	object	8.0%	7442	`(41.765902781071134, -87.61049166037887)` `(41.99777087543091, -87.69394574897939)` `(41.880463147078466, -87.6408038842781)`

Quality Report

✅ Dataset is usable

Geographic Bounds

Coordinates: Southwest (-87.9340, 41.6445) - Northeast (-87.5248, 42.0227)

City of Chicago / Business Affairs & Consumer ProtectionChicago Business Licenses

Categories

Category Inference

Source category mappings

Source Schema

Quality Report

Geographic Bounds