Chicago Building Violations
High-view building violation feed relevant to property due diligence, lead-gen, compliance, and civic watchdogs.
Rows2,010,838
Freshness field
violation_last_modified_dateMax freshness2026-05-26T17:14:46.000
Last checked2026-05-28T06:30:47Z
Reliability checks
- okfreshness is current enough (1 days old)
- okrow count changed by 0.0%
Changes since previous run
- None
Schema columns
| # | Field | Type | Name |
|---|---|---|---|
| 1 | id | text | ID |
| 2 | violation_last_modified_date | calendar_date | VIOLATION LAST MODIFIED DATE |
| 3 | violation_date | calendar_date | VIOLATION DATE |
| 4 | violation_code | text | VIOLATION CODE |
| 5 | violation_status | text | VIOLATION STATUS |
| 6 | violation_status_date | calendar_date | VIOLATION STATUS DATE |
| 7 | violation_description | text | VIOLATION DESCRIPTION |
| 8 | violation_location | text | VIOLATION LOCATION |
| 9 | violation_inspector_comments | text | VIOLATION INSPECTOR COMMENTS |
| 10 | violation_ordinance | text | VIOLATION ORDINANCE |
| 11 | inspector_id | text | INSPECTOR ID |
| 12 | inspection_number | number | INSPECTION NUMBER |
| 13 | inspection_status | text | INSPECTION STATUS |
| 14 | inspection_waived | text | INSPECTION WAIVED |
| 15 | inspection_category | text | INSPECTION CATEGORY |
| 16 | department_bureau | text | DEPARTMENT BUREAU |
| 17 | address | text | ADDRESS |
| 18 | street_number | number | STREET NUMBER |
| 19 | street_direction | text | STREET DIRECTION |
| 20 | street_name | text | STREET NAME |
| 21 | street_type | text | STREET TYPE |
| 22 | property_group | number | PROPERTY GROUP |
| 23 | ssa | text | SSA |
| 24 | latitude | number | LATITUDE |
| 25 | longitude | number | LONGITUDE |
| 26 | location | location | LOCATION |
| 31 | :@computed_region_vrxf_vc4k | number | Community Areas |
| 32 | :@computed_region_6mkv_f3dw | number | Zip Codes |
| 33 | :@computed_region_rpca_8um6 | number | Boundaries - ZIP Codes |
| 34 | :@computed_region_bdys_3d7i | number | Census Tracts |
| 35 | :@computed_region_43wa_7qmu | number | Wards |
| 36 | :@computed_region_awaf_s7ux | number | Historical Wards 2003-2015 |