Mortgage lending (HMDA)

Home loans that lenders made, as reported under the Home Mortgage Disclosure Act (a selection, not every loan in the country).

Published by CFPB / FFIEC Finest detail tract Tables 3

How we use this · on 1 desk

“Which banks are making home loans in this county?”

Where you'll see it

Health Care Loans & Sales: Where home loans closed
AI & Spreadsheets: at Level 3, link it into Excel or Google Sheets, download it, or ask your AI assistant about it

What we added

Each year kept side by side (2024 and 2025 so far)
Lender names attached, so you can see who made the loans in a county
Rolled up by county and neighborhood

See the desks →

Every loan application, every column Sample of 25 rows out of about 16,550,058 · 100 columns

id	activity_year	lei	derived_msa_md	state_code	county_code	census_tract	conforming_loan_limit	derived_loan_product_type	derived_dwelling_category	derived_ethnicity	derived_race	derived_sex	action_taken	purchaser_type	preapproval	loan_type	loan_purpose	lien_status	reverse_mortgage	open_end_line_of_credit	business_or_commercial_purpose	loan_amount	loan_to_value_ratio	interest_rate	rate_spread	hoepa_status	total_loan_costs	total_points_and_fees	origination_charges	discount_points	lender_credits	loan_term	prepayment_penalty_term	intro_rate_period	negative_amortization	interest_only_payment	balloon_payment	other_nonamortizing_features	property_value	construction_method	occupancy_type	manufactured_home_secured_property_type	manufactured_home_land_property_interest	total_units	multifamily_affordable_units	income	debt_to_income_ratio	applicant_credit_score_type	co_applicant_credit_score_type	applicant_ethnicity_1	applicant_ethnicity_2	co_applicant_ethnicity_1	applicant_ethnicity_observed	co_applicant_ethnicity_observed	applicant_race_1	co_applicant_race_1	co_applicant_race_2	applicant_race_observed	co_applicant_race_observed	applicant_sex	co_applicant_sex	applicant_sex_observed	co_applicant_sex_observed	applicant_age	co_applicant_age	applicant_age_above_62	co_applicant_age_above_62	submission_of_application	initially_payable_to_institution	aus_1	denial_reason_1	tract_population	tract_minority_population_percent	ffiec_msa_md_median_family_income	tract_to_msa_income_percentage	tract_owner_occupied_units	tract_one_to_four_family_homes	tract_median_age_of_housing_units
1	2024	549300LYRWPSYPK6S325	11260	AK	02020	02020002603	C	FHA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	Native Hawaiian or Other Pacific Islander	Male	1	2	2	2	32	1	2	2	2	355000.0	80.00000	6.750	0.865	2	25282.48	NA	14505.48	14505.48		360	NA	NA	2	2	2	2	445000	1	1	3	5	1	NA	102	46	1	10	2		5	2	4	4	8		2	4	1	5	2	4	45-54	9999	No	NA	1	1	3	10	6434	45.55	117200	125	1512	1970	35
2	2024	549300LYRWPSYPK6S325	11260	AK	02020	02020002305	C	FHA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Male	1	0	2	2	1	1	2	2	2	285000.0	92.81900	4.625	NA	2	1586.00	NA	900.00			284	NA	NA	2	2	2	2	335000	1	1	3	5	1	NA	93	30%-<36%	1	10	2		5	2	4	5	8		2	4	1	5	2	4	65-74	9999	Yes	NA	1	1	6	10	2647	57.61	117200	84	334	668	31
3	2024	549300LYRWPSYPK6S325	21820	AK	02090	02090000600	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Male	1	0	2	3	1	1	2	2	2	295000.0	98.18900	3.250	NA	2	1952.39	NA	300.00			330	NA	NA	2	2	2	2	305000	1	1	3	5	1	NA	122	20%-<30%	3	10	2		5	2	4	5	8		2	4	1	5	2	4	25-34	9999	No	NA	1	1	1	10	3753	44.31	110000	102	1066	1536	44
4	2024	549300LYRWPSYPK6S325	11260	AK	02020	02020000202	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Male	1	0	2	3	1	1	2	2	2	475000.0	92.43000	2.250	NA	2	2874.81	NA	300.00			327	NA	NA	2	2	2	2	515000	1	1	3	5	4	NA	74	50%-60%	3	10	2		5	2	4	5	8		2	4	1	5	2	4	25-34	9999	No	NA	1	1	1	10	6384	26.14	117200	110	1787	2375	35
5	2024	549300LYRWPSYPK6S325	11260	AK	02020	02020002301	C	FHA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Joint	1	2	2	2	32	1	2	2	2	325000.0	80.00000	6.750	0.777	2	22074.38	NA	12057.38	12057.38		360	NA	NA	2	2	2	2	395000	1	1	3	5	1	NA	115	30%-<36%	3	9	2		2	2	2	5	5		2	2	1	2	2	2	45-54	35-44	No	No	1	1	3	10	7653	36.67	117200	145	2473	2874	34
6	2024	549300LYRWPSYPK6S325	11260	AK	02020	02020000205	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Joint	1	2	2	3	31	1	2	2	2	415000.0	NA	6.250	-0.524	2	7318.04	NA	3244.08		2146.00	360	NA	NA	2	2	2	2	NA	1	1	3	5	1	NA	NA	NA	9	9	2		2	2	2	5	5		2	2	1	2	2	2	35-44	25-34	No	No	1	1	6	10	7421	26.78	117200	124	1944	2541	29
7	2024	549300LYRWPSYPK6S325	11260	AK	02020	02020000205	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Joint	1	0	2	3	1	1	2	2	2	365000.0	96.54400	2.750	NA	2	2706.22	NA	300.00			324	NA	NA	2	2	2	2	375000	1	1	3	5	1	NA	159	49	1	9	2		2	2	2	5	5		2	2	1	2	2	2	35-44	25-34	No	No	1	1	1	10	7421	26.78	117200	124	1944	2541	29
8	2024	549300LYRWPSYPK6S325	11260	AK	02170	02170000603	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Joint	1	2	2	3	32	1	2	2	2	385000.0	97.43600	6.125	-0.54	2	12259.80	NA	8592.20	7577.20	2.50	360	NA	NA	2	2	2	2	395000	1	1	3	5	1	NA	149	46	2	9	2		2	2	2	5	5		2	2	1	2	2	2	45-54	45-54	No	No	2	1	1	10	7887	27.03	117200	115	1669	2242	18
9	2024	549300LYRWPSYPK6S325	21820	AK	02090	02090001200	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Ethnicity Not Available	Race Not Available	Sex Not Available	1	0	2	3	1	1	2	2	2	415000.0	97.61000	3.500	NA	2	3075.01	NA	763.00			332	NA	NA	2	2	2	2	425000	1	1	3	5	1	NA	123	38	2	10	3		5	2	4	6	8		2	4	3	5	2	4	35-44	9999	No	NA	1	1	1	10	6743	24.65	110000	137	2436	2966	36
10	2024	549300LYRWPSYPK6S325	11260	AK	02170	02170001100	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Joint	1	0	2	3	1	1	2	2	2	285000.0	93.01600	2.750	NA	2	2280.45	NA	763.00			312	NA	NA	2	2	2	2	305000	1	1	3	5	1	NA	376	30%-<36%	1	9	2		2	2	2	5	5		2	2	2	1	2	2	55-64	55-64	No	No	1	1	1	10	7354	24.07	117200	121	1640	1992	23
11	2024	549300LYRWPSYPK6S325	11260	AK	02170	02170001300	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	American Indian or Alaska Native	Male	1	2	2	3	31	1	2	2	2	375000.0	NA	6.250	-0.354	2	6870.88	NA	2965.50		2172.12	360	NA	NA	2	2	2	2	NA	1	1	3	5	1	NA	NA	NA	9	10	2		5	2	4	1	8		2	4	1	5	2	4	35-44	9999	No	NA	1	1	6	10	5885	17.2	117200	96	1628	2174	32
12	2024	549300LYRWPSYPK6S325	11260	AK	02020	02020000206	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	Black or African American	Joint	1	2	2	3	31	1	2	2	2	565000.0	NA	6.250	-0.579	2	9872.59	NA	4313.70	4313.70		360	NA	NA	2	2	2	2	NA	1	1	3	5	1	NA	NA	NA	2	9	2		2	2	2	3	4	44	2	2	1	2	2	2	<25	<25	No	No	2	2	6	10	3413	24.29	117200	172	871	1096	36
13	2024	549300LYRWPSYPK6S325	11260	AK	02020	02020000202	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Male	1	2	2	3	31	1	2	2	2	495000.0	NA	5.625	-1.069	2	6243.40	NA	3887.90	3887.90	17.50	360	NA	NA	2	2	2	2	NA	1	1	3	5	1	NA	NA	NA	2	10	2		5	2	4	5	8		2	4	1	5	2	4	45-54	9999	No	NA	2	1	6	10	6384	26.14	117200	110	1787	2375	35
14	2024	549300LYRWPSYPK6S325	21820	AK	02090	02090001902	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Joint	1	2	2	3	1	1	2	2	2	425000.0	100.00000	6.000	-0.581	2	8540.50	NA	6040.00	4250.00	33.76	360	NA	NA	2	2	2	2	425000	1	1	3	5	1	NA	144	49	3	9	2		2	2	2	5	5		2	2	1	2	2	2	35-44	35-44	No	No	1	1	1	10	5255	20.89	110000	116	1832	2909	32
15	2024	549300LYRWPSYPK6S325	11260	AK	02020	02020000202	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Male	1	2	2	3	31	1	2	2	2	395000.0	NA	6.990	0.247	2	7066.98	NA	3085.07		2161.00	360	NA	NA	2	2	2	2	NA	1	1	3	5	1	NA	NA	NA	9	10	2		5	2	4	5	8		2	4	1	5	2	4	25-34	9999	No	NA	1	1	6	10	6384	26.14	117200	110	1787	2375	35
16	2024	549300LYRWPSYPK6S325	11260	AK	02020	02020000701	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Female	1	2	2	3	31	1	2	2	2	225000.0	NA	6.625	-0.039	2	3028.30	NA	1751.30		1418.15	360	NA	NA	2	2	2	2	NA	1	1	3	5	1	NA	NA	NA	9	10	2		5	2	4	5	8		2	4	2	5	2	4	25-34	9999	No	NA	1	1	6	10	6986	63.71	117200	92	1275	2065	34
17	2024	549300LYRWPSYPK6S325	11260	AK	02170	02170000800	C	FHA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Male	1	2	2	2	1	1	2	2	2	625000.0	96.50000	5.750	-0.19	2	14927.39	NA	784.28	784.28		360	NA	NA	2	2	2	2	635000	1	1	3	5	2	NA	142	47	2	10	2		5	2	4	5	8		2	4	1	5	2	4	25-34	9999	No	NA	2	1	3	10	5621	30.33	117200	80	1195	2181	29
18	2024	549300LYRWPSYPK6S325	11260	AK	02170	02170000601	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Joint	1	0	2	3	1	1	2	2	2	365000.0	87.13300	2.250	NA	2	3224.79	NA	763.00			313	NA	NA	2	2	2	2	425000	1	1	3	5	1	NA	115	38	1	9	2		2	2	2	5	5		2	2	1	2	2	2	35-44	35-44	No	No	1	1	1	10	5880	25.51	117200	102	1410	1869	22
19	2024	549300LYRWPSYPK6S325	11260	AK	02020	02020001500	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Joint	1	0	2	3	1	1	2	2	2	455000.0	94.94600	2.250	NA	2	3743.94	NA	763.00			327	NA	NA	2	2	2	2	485000	1	1	3	5	1	NA	433	30%-<36%	3	9	2		2	2	2	5	5		2	2	1	2	2	2	35-44	35-44	No	No	1	1	1	10	5165	35.88	117200	102	1403	1985	51
20	2024	549300LYRWPSYPK6S325	11260	AK	02170	02170001100	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	Black or African American	Joint	1	2	2	3	31	1	2	2	2	555000.0	NA	5.750	-0.462	2	6791.84	NA	4350.96		2565.88	360	NA	NA	2	2	2	2	NA	1	1	3	5	1	NA	NA	NA	9	9	2		2	2	2	3	3		2	2	1	2	2	2	45-54	45-54	No	No	1	1	6	10	7354	24.07	117200	121	1640	1992	23
21	2024	549300LYRWPSYPK6S325	11260	AK	02020	02020001731	C	FHA:First Lien	Single Family (1-4 Units):Site-Built	Hispanic or Latino	American Indian or Alaska Native	Male	1	2	2	2	32	1	2	2	2	385000.0	63.02000	6.250	0.601	2	26341.69	NA	15364.24	15364.24		360	NA	NA	2	2	2	2	595000	1	1	3	5	1	NA	89	50%-60%	2	10	1	11	5	2	4	1	8		2	4	1	5	2	4	65-74	9999	Yes	NA	1	1	3	10	6119	58.51	117200	115	1712	1987	43
22	2024	549300LYRWPSYPK6S325	11260	AK	02170	02170001201	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Male	1	2	2	3	31	1	2	2	2	425000.0	NA	5.750	-0.417	2	7468.95	NA	3328.57		2153.30	360	NA	NA	2	2	2	2	NA	1	1	3	5	1	NA	NA	NA	9	10	2		5	2	4	5	8		2	4	1	5	2	4	25-34	9999	No	NA	1	1	6	10	5621	27.25	117200	72	1302	1700	29
23	2024	549300LYRWPSYPK6S325	11260	AK	02170	02170000604	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Joint	1	2	2	3	31	1	2	2	2	295000.0	NA	6.375	0.448	2	3949.18	NA	2335.30		1743.88	348	NA	NA	2	2	2	2	NA	1	1	3	5	1	NA	NA	NA	9	9	2		2	2	2	5	5		2	2	1	2	2	2	55-64	55-64	Yes	No	1	1	6	10	7470	33.72	117200	98	1144	1837	19
24	2024	549300LYRWPSYPK6S325	11260	AK	02020	02020001731	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	White	Male	1	2	2	3	31	1	2	2	2	345000.0	NA	5.875	-0.3	2	6019.77	NA	2693.54		1749.40	360	NA	NA	2	2	2	2	NA	1	1	3	5	1	NA	NA	NA	9	10	2		5	2	4	5	8		2	4	1	5	2	4	55-64	9999	No	NA	1	1	6	10	6119	58.51	117200	115	1712	1987	43
25	2024	549300LYRWPSYPK6S325	11260	AK	02020	02020002711	C	VA:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	Black or African American	Joint	1	2	2	3	31	1	2	2	2	665000.0	NA	5.250	-0.647	2	11494.26	NA	8530.66	8331.66		360	NA	NA	2	2	2	2	NA	1	1	3	5	1	NA	NA	NA	3	9	2		2	2	2	3	3		2	2	1	2	2	2	45-54	45-54	No	No	2	1	6	10	6817	36.06	117200	152	2021	2370	37

Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.

See pricing