Data Dictionary

Column Type Label Description
activity_year text
lei text
derived_msa-md text
state_code text
county_code text
census_tract text
conforming_loan_limit text
derived_loan_product_type text
derived_dwelling_category text
derived_ethnicity text
derived_race text
derived_sex text
action_taken text
purchaser_type text
preapproval text
loan_type text
loan_purpose text
lien_status text
reverse_mortgage text
open-end_line_of_credit text
business_or_commercial_purpose text
loan_amount text
loan_to_value_ratio text
interest_rate text
rate_spread text
hoepa_status text
total_loan_costs text
total_points_and_fees text
origination_charges text
discount_points text
lender_credits text
loan_term text
prepayment_penalty_term text
intro_rate_period text
negative_amortization text
interest_only_payment text
balloon_payment text
other_nonamortizing_features text
property_value text
construction_method text
occupancy_type text
manufactured_home_secured_property_type text
manufactured_home_land_property_interest text
total_units text
multifamily_affordable_units text
income text
debt_to_income_ratio text
applicant_credit_score_type text
co-applicant_credit_score_type text
applicant_ethnicity-1 text
applicant_ethnicity-2 text
applicant_ethnicity-3 text
applicant_ethnicity-4 text
applicant_ethnicity-5 text
co-applicant_ethnicity-1 text
co-applicant_ethnicity-2 text
co-applicant_ethnicity-3 text
co-applicant_ethnicity-4 text
co-applicant_ethnicity-5 text
applicant_ethnicity_observed text
co-applicant_ethnicity_observed text
applicant_race-1 text
applicant_race-2 text
applicant_race-3 text
applicant_race-4 text
applicant_race-5 text
co-applicant_race-1 text
co-applicant_race-2 text
co-applicant_race-3 text
co-applicant_race-4 text
co-applicant_race-5 text
applicant_race_observed text
co-applicant_race_observed text
applicant_sex text
co-applicant_sex text
applicant_sex_observed text
co-applicant_sex_observed text
applicant_age text
co-applicant_age text
applicant_age_above_62 text
co-applicant_age_above_62 text
submission_of_application text
initially_payable_to_institution text
aus-1 text
aus-2 text
aus-3 text
aus-4 text
aus-5 text
denial_reason-1 text
denial_reason-2 text
denial_reason-3 text
denial_reason-4 text
tract_population text
tract_minority_population_percent text
ffiec_msa_md_median_family_income text
tract_to_msa_income_percentage text
tract_owner_occupied_units text
tract_one_to_four_family_homes text
tract_median_age_of_housing_units text

Additional Information

Field Value
Data last updated January 30, 2024
Metadata last updated January 30, 2024
Created December 7, 2023
Format CSV
License Other (Open)
Ckan urlhttps://sistarmortgage.sutra.ai
Datastore activeTrue
Datastore contains all records of source fileTrue
Has viewsTrue
Hash54cbaff094e7dad72b8287fb3ae99233
Idcdcf84c2-32fb-49e3-800b-2481e2d8a04d
Ignore hashFalse
Mimetypeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Original urlhttps://sistarmortgage.sutra.ai/dataset/c02baa39-966d-485b-80e9-6484893f308c/resource/cdcf84c2-32fb-49e3-800b-2481e2d8a04d/download/county_28005_loan_types_1-2-3-4.csv
Package idc02baa39-966d-485b-80e9-6484893f308c
Position0
Resource idcdcf84c2-32fb-49e3-800b-2481e2d8a04d
Set url typeFalse
Size141.6 KiB
Stateactive
Task created2024-01-30 11:31:40.922290
Url typeupload