2020 Kansas HMDA Data

Mortgage origination and application data

@kaggle.janaedoes_2020_kansas_hmda_data

Table List

1 table(6.38 MB)

State Ks

State Ks

@kaggle.janaedoes_2020_kansas_hmda_data.state_ks

6.38 MB
176109 rows
99 columns

activity_year Activity Year	lei Lei	derived_msa_md Derived Msa-md	state_code State Code	county_code County Code	census_tract Census Tract	conforming_loan_limit Conforming Loan Limit	derived_loan_product_type Derived Loan Product Type	derived_dwelling_category Derived Dwelling Category	derived_ethnicity Derived Ethnicity	derived_race Derived Race	derived_sex Derived Sex	action_taken Action Taken	preapproval Preapproval	loan_type Loan Type	loan_purpose Loan Purpose	lien_status Lien Status	reverse_mortgage Reverse Mortgage	open_end_line_of_credit Open-end Line Of Credit	business_or_commercial_purpose Business Or Commercial Purpose	loan_amount Loan Amount	loan_to_value_ratio Loan To Value Ratio	interest_rate Interest Rate	rate_spread Rate Spread	hoepa_status Hoepa Status	total_loan_costs Total Loan Costs	total_points_and_fees Total Points And Fees	origination_charges Origination Charges	discount_points Discount Points	lender_credits Lender Credits	loan_term Loan Term	prepayment_penalty_term Prepayment Penalty Term	intro_rate_period Intro Rate Period	negative_amortization Negative Amortization	interest_only_payment Interest Only Payment	balloon_payment Balloon Payment	other_nonamortizing_features Other Nonamortizing Features	property_value Property Value	construction_method Construction Method	occupancy_type Occupancy Type	manufactured_home_secured_property_type Manufactured Home Secured Property Type	manufactured_home_land_property_interest Manufactured Home Land Property Interest	total_units Total Units	multifamily_affordable_units Multifamily Affordable Units	income Income	debt_to_income_ratio Debt To Income Ratio	applicant_credit_score_type Applicant Credit Score Type	co_applicant_credit_score_type Co-applicant Credit Score Type	applicant_ethnicity_1 Applicant Ethnicity-1	co_applicant_ethnicity_1 Co-applicant Ethnicity-1	applicant_ethnicity_observed Applicant Ethnicity Observed	co_applicant_ethnicity_observed Co-applicant Ethnicity Observed	applicant_race_1 Applicant Race-1	co_applicant_race_1 Co-applicant Race-1	applicant_race_observed Applicant Race Observed	co_applicant_race_observed Co-applicant Race Observed	applicant_sex Applicant Sex	co_applicant_sex Co-applicant Sex	applicant_sex_observed Applicant Sex Observed	co_applicant_sex_observed Co-applicant Sex Observed	applicant_age Applicant Age	co_applicant_age Co-applicant Age	applicant_age_above_62 Applicant Age Above 62	co_applicant_age_above_62 Co-applicant Age Above 62	submission_of_application Submission Of Application	initially_payable_to_institution Initially Payable To Institution	aus_1 Aus-1	aus_2 Aus-2	aus_3 Aus-3	denial_reason_1 Denial Reason-1	denial_reason_2 Denial Reason-2	tract_population Tract Population	tract_minority_population_percent Tract Minority Population Percent	ffiec_msa_md_median_family_income Ffiec Msa Md Median Family Income	tract_to_msa_income_percentage Tract To Msa Income Percentage	tract_owner_occupied_units Tract Owner Occupied Units	tract_one_to_four_family_homes Tract One To Four Family Homes	tract_median_age_of_housing_units Tract Median Age Of Housing Units
2020	KB1H1DSPRFMYMCUFXT09	99999	KS	20099	20099950600	C	Conventional:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Joint	1	2	1	1	1	2	2	2	105000	83.871	2.875	0.187	2	2887.46	nan	1155.0	nan	105.0	360	nan	nan	2	2	2	2	125000	1	1	3	5	1	nan	49	46	9	3	2	2	2	2	5	5	2	2	1	2	2	2	25-34	25-34	No	No	1	1	5	1	2	10		2303	9.9	64200	97	743	974	44
2020	KB1H1DSPRFMYMCUFXT09	99999	KS	20057	20057961800	C	FHA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Joint	1	2	2	1	1	2	2	2	185000	96.5	3.5	1.595	2	3208.0	nan	0.0	nan	695.0	360	nan	nan	2	2	2	2	195000	1	1	3	5	1	nan	73	30%-<36%	9	1	2	2	2	2	5	5	2	2	1	2	2	2	25-34	<25	No	No	1	1	3			10		8667	53.48	64200	111	1770	2560	32
2020	KB1H1DSPRFMYMCUFXT09	99999	KS	20055	20055960404	C	Conventional:First Lien	Single Family (1-4 Units):Site-Built	Hispanic or Latino	American Indian or Alaska Native	Joint	3	2	1	31	1	2	2	2	195000	85.912	nan	nan	3	nan	nan	nan	nan	nan	180	nan	nan	2	2	2	2	235000	1	1	3	5	1	nan	165	<20%	9	1	1	1	2	2	1	1	2	2	2	1	2	2	<25	25-34	No	No	1	1	5	1	2	9	3	3539	43.8	64200	117	661	906	29
2020	KB1H1DSPRFMYMCUFXT09	99999	KS	20203	20203957600	C	Conventional:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Male	3	2	1	31	1	2	2	2	205000	64.598	nan	nan	3	nan	nan	nan	nan	nan	240	nan	nan	2	2	2	2	375000	1	3	3	5	1	nan	31	>60%	3	10	2	5	2	4	5	8	2	4	1	5	2	4	45-54	9999	No	nan	1	1	6			9	3	2204	31.53	64200	103	564	856	51
2020	KB1H1DSPRFMYMCUFXT09	28140	KS	20091	20091053007	C	Conventional:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Female	3	2	1	31	1	2	2	2	155000	59.245	nan	nan	3	nan	nan	nan	nan	nan	360	nan	nan	2	2	2	2	265000	1	1	3	5	1	nan	28	49	1	10	2	5	2	4	5	8	2	4	2	5	2	4	65-74	9999	Yes	nan	1	1	5	1	2	9		5029	19.65	85900	134	1141	1359
2020	KB1H1DSPRFMYMCUFXT09	28140	KS	20209	20209043600	C	Conventional:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Female	3	2	1	31	1	2	2	2	185000	86.905	nan	nan	3	nan	nan	nan	nan	nan	360	nan	nan	2	2	2	2	215000	1	1	3	5	1	nan	76	20%-<30%	3	10	2	5	2	4	5	8	2	4	2	5	2	4	25-34	9999	No	nan	1	1	5	1	2	7		6552	35.26	85900	75	1464	2311	55
2020	KB1H1DSPRFMYMCUFXT09	28140	KS	20091	20091050400	C	Conventional:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Male	1	2	1	1	1	2	2	2	145000	75.0	3.75	1.084	3	2864.59	nan	1528.13	373.13	91.2	360	nan	nan	2	2	2	2	195000	1	3	3	5	1	nan	139	42	3	10	2	5	2	4	5	8	2	4	1	5	2	4	45-54	9999	No	nan	1	1	5	1	2	10		4775	32.59	85900	81	1063	1904	48
2020	KB1H1DSPRFMYMCUFXT09	28140	KS	20091	20091053709	C	Conventional:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Joint	4	2	1	31	1	2	2	2	175000	nan	nan	nan	3	nan	nan	nan	nan	nan	360	nan	nan	2	2	2	2	nan	1	2	3	5	1	nan	280	nan	9	9	2	2	2	2	5	5	2	2	1	2	2	2	45-54	45-54	No	No	1	1	5	1	2	10		5634	11.73	85900	109	1610	1845	16
2020	KB1H1DSPRFMYMCUFXT09	99999	KS	20037	20037956800	C	Conventional:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Joint	3	2	1	31	1	2	2	2	105000	77.778	nan	nan	3	nan	nan	nan	nan	nan	360	nan	nan	2	2	2	2	135000	1	1	3	5	1	nan	113	30%-<36%	3	9	2	2	2	2	5	5	2	2	1	2	2	2	45-54	45-54	No	No	1	1	5	1	2	3		3339	9.13	64200	85	799	1492	55
2020	KB1H1DSPRFMYMCUFXT09	28140	KS	20209	20209044804	C	Conventional:First Lien	Single Family (1-4 Units):Site-Built	Ethnicity Not Available	Race Not Available	Joint	1	2	1	31	1	2	2	2	235000	78.983	2.0	0.0	2	7288.96	nan	6397.5	5242.5	20.0	180	nan	nan	2	2	2	2	295000	1	1	3	5	1	nan	126	20%-<30%	9	3	3	3	2	2	6	6	2	2	1	2	2	2	55-64	55-64	No	No	1	1	5	1	2	10		4778	31.58	85900	142	1269	1498	15


CREATE TABLE state_ks (
  "activity_year" BIGINT,
  "lei" VARCHAR,
  "derived_msa_md" BIGINT,
  "state_code" VARCHAR,
  "county_code" DOUBLE,
  "census_tract" DOUBLE,
  "conforming_loan_limit" VARCHAR,
  "derived_loan_product_type" VARCHAR,
  "derived_dwelling_category" VARCHAR,
  "derived_ethnicity" VARCHAR,
  "derived_race" VARCHAR,
  "derived_sex" VARCHAR,
  "action_taken" BIGINT,
  "purchaser_type" BIGINT,
  "preapproval" BIGINT,
  "loan_type" BIGINT,
  "loan_purpose" BIGINT,
  "lien_status" BIGINT,
  "reverse_mortgage" BIGINT,
  "open_end_line_of_credit" BIGINT,
  "business_or_commercial_purpose" BIGINT,
  "loan_amount" DOUBLE,
  "loan_to_value_ratio" VARCHAR,
  "interest_rate" VARCHAR,
  "rate_spread" VARCHAR,
  "hoepa_status" BIGINT,
  "total_loan_costs" VARCHAR,
  "total_points_and_fees" VARCHAR,
  "origination_charges" VARCHAR,
  "discount_points" VARCHAR,
  "lender_credits" VARCHAR,
  "loan_term" VARCHAR,
  "prepayment_penalty_term" VARCHAR,
  "intro_rate_period" VARCHAR,
  "negative_amortization" BIGINT,
  "interest_only_payment" BIGINT,
  "balloon_payment" BIGINT,
  "other_nonamortizing_features" BIGINT,
  "property_value" VARCHAR,
  "construction_method" BIGINT,
  "occupancy_type" BIGINT,
  "manufactured_home_secured_property_type" BIGINT,
  "manufactured_home_land_property_interest" BIGINT,
  "total_units" VARCHAR,
  "multifamily_affordable_units" VARCHAR,
  "income" DOUBLE,
  "debt_to_income_ratio" VARCHAR,
  "applicant_credit_score_type" BIGINT,
  "co_applicant_credit_score_type" BIGINT,
  "applicant_ethnicity_1" DOUBLE,
  "applicant_ethnicity_2" DOUBLE,
  "applicant_ethnicity_3" DOUBLE,
  "applicant_ethnicity_4" DOUBLE,
  "applicant_ethnicity_5" DOUBLE,
  "co_applicant_ethnicity_1" DOUBLE,
  "co_applicant_ethnicity_2" DOUBLE,
  "co_applicant_ethnicity_3" DOUBLE,
  "co_applicant_ethnicity_4" VARCHAR,
  "co_applicant_ethnicity_5" VARCHAR,
  "applicant_ethnicity_observed" BIGINT,
  "co_applicant_ethnicity_observed" BIGINT,
  "applicant_race_1" DOUBLE,
  "applicant_race_2" DOUBLE,
  "applicant_race_3" DOUBLE,
  "applicant_race_4" DOUBLE,
  "applicant_race_5" DOUBLE,
  "co_applicant_race_1" DOUBLE,
  "co_applicant_race_2" DOUBLE,
  "co_applicant_race_3" DOUBLE,
  "co_applicant_race_4" DOUBLE,
  "co_applicant_race_5" DOUBLE,
  "applicant_race_observed" BIGINT,
  "co_applicant_race_observed" BIGINT,
  "applicant_sex" BIGINT,
  "co_applicant_sex" BIGINT,
  "applicant_sex_observed" BIGINT,
  "co_applicant_sex_observed" BIGINT,
  "applicant_age" VARCHAR,
  "co_applicant_age" VARCHAR,
  "applicant_age_above_62" VARCHAR,
  "co_applicant_age_above_62" VARCHAR,
  "submission_of_application" BIGINT,
  "initially_payable_to_institution" BIGINT,
  "aus_1" BIGINT,
  "aus_2" DOUBLE,
  "aus_3" DOUBLE,
  "aus_4" DOUBLE,
  "aus_5" DOUBLE,
  "denial_reason_1" BIGINT,
  "denial_reason_2" DOUBLE,
  "denial_reason_3" DOUBLE,
  "denial_reason_4" DOUBLE,
  "tract_population" BIGINT,
  "tract_minority_population_percent" DOUBLE,
  "ffiec_msa_md_median_family_income" BIGINT,
  "tract_to_msa_income_percentage" BIGINT,
  "tract_owner_occupied_units" BIGINT,
  "tract_one_to_four_family_homes" BIGINT,
  "tract_median_age_of_housing_units" BIGINT
);