About this Dataset

Lending Equity - Residential 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 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.
Organization: City of Chicago
Last updated: 2021-12-03T10:32:21.908515
Tags: 2020, 2021, 2022, 2023, 2024, equity, lending, lending-equity

Tables

Table 1

@usgov.city_of_chicago_lending_equity_residential_lending.table_1

1.15 MB
90,804 rows
46 columns

CREATE TABLE table_1 (
  "reporting_year" BIGINT,
  "bank" VARCHAR,
  "rfp_source" VARCHAR,
  "data_description" VARCHAR,
  "census_tract" DOUBLE,
  "action_taken" VARCHAR,
  "total_units" DOUBLE,
  "open_end_line_of_credit" VARCHAR,
  "loan_type" VARCHAR,
  "loan_purpose" VARCHAR,
  "loan_amount" DOUBLE,
  "application_date" TIMESTAMP,
  "interest_rate" DOUBLE,
  "loan_term_months" DOUBLE  -- Loan Term (Months),
  "total_points_and_fees" DOUBLE,
  "lien_status" VARCHAR,
  "property_value" DOUBLE,
  "combined_loan_value_ratio" DOUBLE,
  "purchase_price" DOUBLE,
  "down_payment_amount" DOUBLE,
  "reason_for_denial_1" VARCHAR  -- Reason For Denial (1),
  "reason_for_denial_2" VARCHAR  -- Reason For Denial (2),
  "reason_for_denial_3" VARCHAR  -- Reason For Denial (3),
  "reason_for_denial_4" VARCHAR  -- Reason For Denial (4),
  "race_of_applicant_or_borrower_1" VARCHAR  -- Race Of Applicant Or Borrower (1),
  "race_of_applicant_or_borrower_2" VARCHAR  -- Race Of Applicant Or Borrower (2),
  "race_of_applicant_or_borrower_3" VARCHAR  -- Race Of Applicant Or Borrower (3),
  "race_of_applicant_or_borrower_4" VARCHAR  -- Race Of Applicant Or Borrower (4),
  "race_of_applicant_or_borrower_5" VARCHAR  -- Race Of Applicant Or Borrower (5),
  "race_of_co_applicant_or_borrower_1" VARCHAR  -- Race Of Co-Applicant Or Borrower (1),
  "race_of_co_applicant_or_borrower_2" VARCHAR  -- Race Of Co-Applicant Or Borrower (2),
  "race_of_co_applicant_or_borrower_3" VARCHAR  -- Race Of Co-Applicant Or Borrower (3),
  "race_of_co_applicant_or_borrower_4" VARCHAR  -- Race Of Co-Applicant Or Borrower (4),
  "race_of_co_applicant_or_borrower_5" VARCHAR  -- Race Of Co-Applicant Or Borrower (5),
  "ethnicity_of_applicant_or_borrower_1" VARCHAR  -- Ethnicity Of Applicant Or Borrower (1),
  "ethnicity_of_applicant_or_borrower_2" VARCHAR  -- Ethnicity Of Applicant Or Borrower (2),
  "ethnicity_of_applicant_or_borrower_3" VARCHAR  -- Ethnicity Of Applicant Or Borrower (3),
  "ethnicity_of_applicant_or_borrower_4" VARCHAR  -- Ethnicity Of Applicant Or Borrower (4),
  "ethnicity_of_applicant_or_borrower_5" VARCHAR  -- Ethnicity Of Applicant Or Borrower (5),
  "ethnicity_of_co_applicant_or_borrower_1" VARCHAR  -- Ethnicity Of Co-Applicant Or Borrower (1),
  "ethnicity_of_co_applicant_or_borrower_2" VARCHAR  -- Ethnicity Of Co-Applicant Or Borrower (2),
  "ethnicity_of_co_applicant_or_borrower_3" VARCHAR  -- Ethnicity Of Co-Applicant Or Borrower (3),
  "ethnicity_of_co_applicant_or_borrower_4" VARCHAR  -- Ethnicity Of Co-Applicant Or Borrower (4),
  "ethnicity_of_co_applicant_or_borrower_5" VARCHAR  -- Ethnicity Of Co-Applicant Or Borrower (5),
  "sex_of_applicant_or_borrower" VARCHAR,
  "sex_of_co_applicant_or_borrower" VARCHAR
);