Chicago Microlending Institute (CMI) Microloans - Summary by Ethnicity and Gender

To improve access to capital, the City of Chicago seeded a $2MM revolving loan fund and partnered with Accion to create the Chicago Microlending Institute (CMI). There is a full list of loans in the https://data.cityofchicago.org/id/dpkg-upyz dataset. Certain data elements could not be included for privacy reasons but are summarized in this dataset. Loans without a date are not included in the summary.

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/chicago-microlending-institute-cmi-microloans-4s8s-adbr\".\"chicago_microlending_institute_cmi_microloans\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.