Lending Equity - Residential Lending

Pursuant to the City of Chicago <a href="https://chicago.legistar.com/LegislationDetail.aspx?ID=4994405&GUID=F8A03263-48F8-49BF-94B5-13AB94F33B02&Options=Advanced&Search=">Municipal Code</a>, certain banks are required to report, and the City of Chicago Comptroller is required to make public, information related to lending equity. The <a href="https://data.cityofchicago.org/browse?limitTo=datasets&q=&sortBy=alpha&tags=lending+equity">datasets in this series</a> and <a href="https://www.chicago.gov/city/en/depts/fin/supp_info/municipal-depositories-rfp.html">additional information</a> on the Department of Finance portion of the City Web site, make up that public sharing of the data.

This dataset shows residential loan applications processed by responding banks.

Answers in some columns are coded. Please see the "Filing Instructions Guide" section of https://ffiec.cfpb.gov for the translations.

For some Number columns, nonsensical text values (e.g., values apparently answering different questions or those indicating no answer available, e.g., "N/A") have been removed in order to maintain the column type and therefore the ability to do numeric analysis of the responses. For original values, as submitted by each bank, please see the actual documents submitted at the "additional information" link above.

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/lending-equity-residential-lending-b77m-uuhb\".\"lending_equity_residential_lending\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.