About this Dataset

Lending Equity - Commercial And Consumer Lending

Pursuant to the City of Chicago Municipal Code, certain banks are required to report, and the City of Chicago Comptroller is required to make public, information related to lending equity. The datasets in this series and additional information 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 Lending Equity - Residential Lending.
Organization: City of Chicago
Last updated: 2021-12-03T10:32:17.770905
Tags: 2020, 2021, 2022, 2023, 2024, equity, lending, lending-equity

Tables

Table 1

@usgov.city_of_chicago_lending_equity_commercial_and_consumer_lending.table_1

400.47 kB
25,114 rows
9 columns

CREATE TABLE table_1 (
  "reporting_year" BIGINT,
  "bank" VARCHAR,
  "rfp_source" VARCHAR,
  "data_description" VARCHAR,
  "zip_code" VARCHAR,
  "census_tract" VARCHAR,
  "number_of_loans" BIGINT,
  "total_combined_loan_amount" DOUBLE,
  "record_id" VARCHAR
);