Debarred Firms and Individuals

Entities, individuals or both are subject to debarment. The following list provides info regarding entities or individuals, date of debarment, length of debarment and cause. Lifetime debarment pertains to individuals, permanent pertains to entities. In addition, this list also identifies individuals and entities that are ineligible to do business with the City pursuant to Section 1-23-020 of the Municipal Code, and Building Code Scofflaws ineligible to do business with the City pursuant to Section 2-92-416 of the Municipal Code.

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/debarred-firms-and-individuals-y93d-d9e3\".\"debarred_firms_and_individuals\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.