Building Code Scofflaw List

Chicago's Building Code Scofflaw Ordinance (Section 2-92-416 of the Municipal Code of Chicago) prohibits the owners of buildings that are identified as "priority buildings with serious and chronic code violations" from being awarded City contracts, receiving financial assistance from the City, or having certain applications accepted or processed by the City. Buildings on the list are also subject to follow-up inspections by the Department of Buildings at least every 12 months, and once removed from the list, continuing inspections until the building receives two consecutive inspections, at least six months apart, during which no serious violations are found. The owners of buildings included on the list are designated as "building code scofflaws."

Pursuant to the ordinance, as amended in 2021, lists of buildings are published on September 1 and March 1 of each year and lists of owners associated with those buildings are published one month later.

The structure of this dataset was modified on 9/1/2021 to be consistent with the amended ordinance.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofchicago/building-code-scofflaw-list-crg5-4zyp\".\"building_code_scofflaw_list\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.