List of Contractors Doing Business with the City Of Chicago

In accordance with the Governmental Ethics Ordinance, the Department of Innovation & Technology provides the following list of current and former contractors who, during the preceding four reporting years, received from the City of Chicago payments totaling $10,000 or more in any 12 consecutive months period. The data source for this list is the Financial Management and Purchasing Systems (FMPS).

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/list-of-contractors-doing-business-with-the-city-5wd9-d675\".\"list_of_contractors_doing_business_with_the_city\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.