CFPB / FFIEC
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
By county and outcome
Sample of 25 rows out of about 1,669,713
· 10 columns
| id | activity_year | state | county_fips | action_taken | loan_type | loan_purpose | records | loan_amount_sum | loan_amount_n |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 2018 | CA | 06071 | 1 | 2 | 1 | 6235 | 1735205000 | 6235 |
| 2 | 2018 | MN | 27141 | 1 | 1 | 1 | 1209 | 267815000 | 1209 |
| 3 | 2018 | MI | 26125 | 1 | 1 | 1 | 16909 | 4468915000 | 16909 |
| 4 | 2018 | GA | 13057 | 1 | 1 | 1 | 4261 | 1166975000 | 4261 |
| 5 | 2018 | NV | 32003 | 1 | 1 | 1 | 30464 | 9062060000 | 30464 |
| 6 | 2018 | AZ | 04013 | 1 | 1 | 1 | 64502 | 19746050000 | 64502 |
| 7 | 2018 | MN | 27109 | 1 | 1 | 1 | 2603 | 951675000 | 2603 |
| 8 | 2018 | CA | 06065 | 1 | 2 | 1 | 7577 | 2339155000 | 7577 |
| 9 | 2018 | MI | 26099 | 1 | 2 | 1 | 2448 | 381390000 | 2448 |
| 10 | 2018 | WA | 53063 | 1 | 1 | 1 | 7121 | 1642115000 | 7121 |
| 11 | 2018 | FL | 12057 | 3 | 1 | 1 | 2731 | 552405000 | 2731 |
| 12 | 2018 | CA | 06067 | 1 | 1 | 1 | 16523 | 5502275000 | 16523 |
| 13 | 2018 | IN | 18163 | 1 | 2 | 1 | 671 | 81335000 | 671 |
| 14 | 2018 | IL | 17031 | 1 | 2 | 1 | 9824 | 2044040000 | 9824 |
| 15 | 2018 | IN | 18057 | 5 | 1 | 1 | 182 | 55720000 | 182 |
| 16 | 2018 | MN | 27013 | 1 | 1 | 1 | 764 | 159920000 | 764 |
| 17 | 2018 | NJ | 34013 | 3 | 1 | 32 | 739 | 195825000 | 739 |
| 18 | 2018 | CA | 06019 | 1 | 1 | 1 | 7694 | 2175630000 | 7694 |
| 19 | 2018 | PA | 42125 | 1 | 1 | 1 | 1740 | 379850000 | 1740 |
| 20 | 2018 | CA | 06037 | 1 | 1 | 1 | 54312 | 38327590000 | 54312 |
| 21 | 2018 | NC | 37133 | 1 | 2 | 1 | 331 | 47845000 | 331 |
| 22 | 2018 | MI | 26125 | 5 | 1 | 1 | 705 | 161295000 | 705 |
| 23 | 2018 | IL | 17031 | 5 | 1 | 1 | 1473 | 427395000 | 1473 |
| 24 | 2018 | CA | 06065 | 1 | 1 | 1 | 22431 | 7504425000 | 22431 |
| 25 | 2018 | CA | 06071 | 1 | 3 | 1 | 1695 | 545985000 | 1695 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing