cityofchicago/lending-equity-commercial-and-consumer-lending-4t5u-cj3n
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 2 months ago
Indexed 2 days ago

Lending Equity - Commercial and Consumer 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 commercial and consumer loans of responding banks, aggregated by either ZIP Code or Census Tract.

For further information applicable to all datasets in this series, please see the dataset description for <a href="https://data.cityofchicago.org/d/b77m-uuhb">Lending Equity - Residential Lending</a>.

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-commercial-and-consumer-lending-4t5u-cj3n\".\"lending_equity_commercial_and_consumer_lending\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • lending_equity_commercial_and_consumer_lending
     
     
     
     
     
Upstream Metadata