Real Estate Investors
Identify distressed markets by ZIP codes with high denial rates, low origination rates, or rising DTI — before foreclosure data catches up.
Mortgage approval rates, denial reasons, loan amounts, and lending patterns for every US ZIP code. Part of the EnrichZip dataset — all 33,000+ US ZIP codes, instant download.
How to use this data
Real Estate Investors
Identify distressed markets by ZIP codes with high denial rates, low origination rates, or rising DTI — before foreclosure data catches up.
Mortgage Brokers & Lenders
Prospect in underserved ZIP codes with high application volumes and low origination rates. Find where competitors are losing business.
Housing Researchers
Analyze lending disparities, fair lending compliance, and mortgage market access across geographies with pre-aggregated HMDA metrics.
Site Selectors & Developers
Understand the mortgage market health of target markets — LTV ratios, income levels, and loan types signal purchasing power and market demand.
Columns Included
Source: Consumer Financial Protection Bureau (CFPB). All columns are pre-joined and ready to use — no API key or GIS software required.
| Column Name | Description |
|---|---|
hmda_total_applications |
Total mortgage applications in the ZIP code area |
hmda_origination_rate |
% of applications that were approved and funded |
hmda_denial_rate |
% of applications denied |
hmda_withdrawal_rate |
% withdrawn or left incomplete |
hmda_median_loan_amount |
Median loan size in dollars |
hmda_median_property_value |
Median reported property value |
hmda_median_ltv |
Median loan-to-value ratio (%) |
hmda_median_interest_rate |
Median interest rate on originated loans |
hmda_median_dti |
Median debt-to-income ratio (%) |
hmda_median_income_000 |
Median applicant income ($000s) |
hmda_pct_fha |
% of loans that are FHA-insured |
hmda_pct_va |
% of loans that are VA-backed |
hmda_pct_purchase |
% of applications for home purchase |
hmda_pct_refinance |
% of applications for refinance |
hmda_top_denial_reason |
Most common mortgage denial reason |
About This Data
HMDA data is the most comprehensive public record of mortgage lending activity in the United States. Every year, the CFPB collects and publishes loan-level data from thousands of mortgage lenders — but working with that raw data requires downloading files that are 10GB+ and writing complex aggregation code.
EnrichZip solves that. We process the full HMDA dataset and produce clean ZIP code-level summaries covering approval rates, denial rates, loan economics, and borrower characteristics for all 33,000+ US ZIP codes.
The mortgage denial rate by ZIP code is particularly valuable — it's a leading indicator of market stress. Areas where a high percentage of applications are denied often precede rising vacancy rates, falling property values, and eventual distress sales. Real estate investors use this data to identify emerging opportunities before they show up in traditional market reports.
The HMDA dataset also reveals lending disparities. ZIP codes with high FHA loan percentages are often lower-income, first-time buyer markets with thinner credit profiles. Areas with high VA loan percentages are near military installations. High refinance percentages in 2021-2022 data reflected the rate environment; a return to high purchase percentages in 2023 shows a market adjusting to higher rates.
The top denial reason column tells you why lenders are saying no in each ZIP — whether it's debt-to-income ratios, credit history, collateral concerns, or employment history. Different denial reasons call for different investment or lending strategies.
FAQ
The Home Mortgage Disclosure Act (HMDA) requires most mortgage lenders to publicly report data on every loan application they receive. The CFPB publishes this data annually — roughly 20 million records per year — covering loan amounts, property values, applicant demographics, and outcomes. EnrichZip aggregates this to the ZIP code level so you don't need to process gigabytes of raw data yourself.
The CFPB releases the full HMDA dataset approximately 9-12 months after the end of each calendar year. Our current dataset uses 2023 HMDA data, released in late 2024. We update annually when CFPB publishes new data.
The denial rate is the percentage of mortgage applications in a ZIP code that were outright rejected by lenders. High denial rates (above 25-30%) may indicate credit-challenged borrowers, overvalued properties, or lender risk aversion in that market. Combined with income and DTI data, it paints a picture of mortgage market health.
No — individual HMDA records are publicly available from CFPB but are not what we sell. EnrichZip sells the pre-aggregated ZIP-level summary, which is what most buyers actually need for market analysis. The full individual record dataset from CFPB is free but requires significant data engineering to use.