State Real Estate and Bank Risk File
Coverage right now: 55 states · 3,181 counties · 33K zip codes · data as of 2026-06-01
Every county in one state with market phase, HPI, bank exposure and insurance distress, plus bank exposure for every ZIP and the latest ZIP insurance reading.
- County table: market phase and confidence, HPI change and drawdown, bank counts and stress, headwind, insurance distress
- Bank exposure by ZIP for the whole state
- Latest insurance distress score and retreat index for every ZIP
- Full profile of every bank in the file: HQ, parent company, ticker, assets, equity, ROA, ROE, net income, deposits, noncurrent loan ratios, margin, rate-risk scores and stress trend
- Not included: phone numbers, emails or skip tracing. Public-record data, dated, with the source named in every file.
- States
- 55
- Counties
- 3,181
- ZIP codes
- 33K
What is in the file
5 CSV tables in one zip. Every table carries a header with the package, geography, as-of date and order id, and a dlr_ref fingerprint column.
Counties
counties.csvOne row per county.
Bank branches
bank_branches.csvOne row per FDIC branch in the state (Summary of Deposits).
Bank exposure by ZIP
bank_exposure_by_zip.csvOne row per ZIP with a branch.
ZIP insurance distress, latest
zip_insurance_latest.csvOne row per ZIP.
Bank profiles
bank_profiles.csvOne row per bank named in this file: headquarters, holding company and ticker, balance sheet and earnings from the latest call report, noncurrent loan ratios by type, margin and rate-risk scores, capital strength and the current stress score with its 7-day change.
Sample rows
Real rows from Florida, built by the same query as the paid file. Identifiers are blanked and names and addresses partly hidden (••••); your file carries the full values.
counties.csv14 columns · first 5 rows| county_name | county_fips | market_phase | phase_confidence_0_100 | hpi_yoy_pct | hpi_drawdown_pct | bank_count | branch_count_total | weighted_avg_bank_stress | max_bank_stress | county_headwind_score_0_100 | insurance_distress_score | insurance_retreat_index | insurance_as_of |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| alachua | 12001 | CONTRACTION | 30.058293284313467998000 | -0.3 | -2.1 | 18 | 53 | 61.0 | 94 | 39.28 | 86 | 86 | 2026-10-01 |
| baker | 12003 | CONTRACTION | 32.357978489511582549000 | -0.9 | -1.8 | 3 | 3 | 61.0 | 67 | 40.59 | 91 | 91 | 2026-10-01 |
| bay | 12005 | NEUTRAL | 29.228799212826340680000 | 3.8 | -0.5 | 18 | 51 | 58.0 | 80 | 31.72 | 89 | 89 | 2026-10-01 |
| bradford | 12007 | PEAK | 23.196398880733200000000 | 3.8 | 0.0 | 4 | 4 | 56.0 | 65 | 30.48 | 91 | 91 | 2026-10-01 |
| brevard | 12009 | RECOVERY | 12.891752834126870513000 | 1.2 | 0.0 | 17 | 87 | 64.0 | 82 | 52.43 | 97 | 97 | 2026-10-01 |
bank_branches.csv13 columns · first 5 rows| state | county_fips | zip | branch_city | bank_name | bank_cert | holding_company | service_type | branch_deposits_usd_thousands | share_of_bank_deposits_in_scope_pct | bank_stress_score | sod_year | fdic_branch_id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| NC | 12031 | 32225 | Jacksonville | Bank of America, National Association | •••• | BANK OF AMERICA CORPORATION | full service, brick and mortar | 59077939 | 34.68 | 71.29 | 2026 | •••• |
| FL | 12103 | 33716 | Saint Petersburg | Raymond James Bank | •••• | RAYMOND JAMES FINANCIAL, INC. | full service, brick and mortar | 41395171 | 100.00 | 66.91 | 2026 | •••• |
| FL | 12031 | 32202 | Jacksonville | EverBank, National Association | •••• | EVERBANK FINANCIAL CORP | full service, cyber | 27523960 | 82.18 | 73.48 | 2026 | •••• |
| FL | 12086 | 33016 | Hialeah | BankUnited, National Association | •••• | BANKUNITED, INC. | full service, brick and mortar | 13633213 | 65.77 | 76.28 | 2026 | •••• |
| FL | 12086 | 33134 | Miami | City National Bank of Florida | •••• | EMPRESAS JUAN YARUR SPA | full service, brick and mortar | 12642888 | 57.19 | 63.58 | 2026 | •••• |
bank_exposure_by_zip.csv10 columns · first 5 rows| state | county_fips | zip | branches | banks | deposits_usd_thousands | avg_bank_stress | max_bank_stress | largest_bank_by_deposits | sod_year |
|---|---|---|---|---|---|---|---|---|---|
| NC | 12031 | 32225 | 3 | 2 | 59243028 | 68.2 | 71.29 | Bank of America, National Association | 2026 |
| FL | 12103 | 33716 | 1 | 1 | 41395171 | 66.9 | 66.91 | Raymond James Bank | 2026 |
| FL | 12031 | 32202 | 2 | 1 | 27523960 | 73.5 | 73.48 | EverBank, National Association | 2026 |
| FL | 12086 | 33134 | 16 | 15 | 25597133 | 66.4 | 80.79 | City National Bank of Florida | 2026 |
| SD | 12086 | 33131 | 7 | 2 | 13936939 | 70.0 | 74.09 | Wells Fargo Bank, National Association | 2026 |
bank_profiles.csv49 columns · first 5 rows| bank_cert | bank_name | hq_state | hq_city | status | closed_or_merged_date | successor_name | holding_company | holding_company_type | ticker | equity_trend_label | pct_off_52w_hi | call_report_date | total_assets_usd_thousands | equity_usd_thousands | equity_ratio_pct | tangible_equity_ratio_pct | leverage_ratio | roa | roe | net_income_usd_thousands | net_interest_income_usd_thousands | domestic_deposits_usd_thousands | noncurrent_re_loans_pct | noncurrent_commercial_re_pct | noncurrent_nonresi_re_pct | noncurrent_multifamily_pct | noncurrent_construction_pct | net_chargeoff_re_loans_pct | net_chargeoff_commercial_re_pct | net_chargeoff_nonresi_re_pct | net_chargeoff_multifamily_pct | net_chargeoff_construction_pct | net_interest_margin_pct | net_interest_margin_8q_avg_pct | nim_compression | bank_loan_yield | bank_cost_of_funds | fixed_rate_trap_score | bank_rate_exposure_score | bank_risk_type | deal_implication | capital_strength_score | bank_failure_risk | bank_stress_score | dlradar_bank_grade | states_served | counties_served | zips_served |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| •••• | JPMORGAN CHASE BANK NA | OH | active | JPMORGAN CHASE&CO | Holding Company | JPM | STABLE | -6.5 | 20260630 | 4091315000 | 341580000 | 8.35 | 11.98 | 1.59 | 18.55 | 31335000 | 50852000 | 2226790000 | 1.31 | 0.65 | 1.92 | 0.46 | 2.57 | -0.005 | 0.000 | 0.078 | -0.013 | 0.032 | 2.882 | 2.965 | 0.0830 | 57 | 57 | CREDIT_DRIVEN | Borrowers are not paying — expect REOs, asset disposals a… | 83 | STRONG | 64.68 | C | 48 | 629 | 14991 | ||||||
| •••• | BANK OF AMERICA NA | NC | active | BANK OF AMERICA CORP | Holding Company | STABLE | -7.2 | 20260630 | 2654645000 | 240789000 | 9.07 | 11.02 | 1.13 | 12.31 | 14947000 | 30384000 | 1983484000 | 1.21 | 1.12 | 1.96 | 0.25 | 0.25 | 0.033 | -0.006 | 0.192 | 0.024 | 0.000 | 2.526 | 2.491 | -0.0350 | 61 | 61 | CREDIT_DRIVEN | Borrowers are not paying — expect REOs, asset disposals a… | 79 | STRONG | 71.29 | D | 38 | 435 | 11426 | |||||||
| •••• | CITIBANK NATIONAL ASSN | SD | active | CITIGROUP INC | Holding Company | C | WEAKENING | -14.3 | 20260630 | 1976180000 | 171296000 | 8.67 | 11.54 | 1.06 | 11.69 | 10118000 | 25968000 | 896647000 | 0.70 | 0.00 | 2.41 | 0.67 | 0.88 | -0.003 | 0.000 | 0.000 | 0.000 | 0.000 | 3.019 | 3.046 | 0.0271 | 50 | 50 | CREDIT_DRIVEN | Borrowers are not paying — expect REOs, asset disposals a… | 79 | STRONG | 74.09 | D | 13 | 52 | 2834 | ||||||
| •••• | WELLS FARGO BANK NA | SD | active | WELLS FARGO&COMPANY | Holding Company | WFC | WEAKENING | -11.6 | 20260630 | 1907928000 | 169518000 | 8.88 | 11.26 | 1.38 | 14.88 | 12808000 | 26396000 | 1554614000 | 2.21 | 0.17 | 3.43 | 1.51 | 4.28 | 0.004 | -0.007 | -0.012 | 0.334 | 0.498 | 3.129 | 3.268 | 0.1394 | 52 | 52 | CREDIT_DRIVEN | Borrowers are not paying — expect REOs, asset disposals a… | 85 | STRONG | 66.95 | D | 39 | 779 | 13901 | ||||||
| •••• | U S BANK NATIONAL ASSN | OH | active | U S BCORP | Holding Company | 20260630 | 705554946 | 68833913 | 9.76 | 10.25 | 1.23 | 12.38 | 4225746 | 8764536 | 532853394 | 2.74 | 0.24 | 1.65 | 0.63 | 0.37 | 0.006 | 0.000 | 0.085 | 0.055 | -0.220 | 2.868 | 2.838 | -0.0297 | 52 | 52 | CREDIT_DRIVEN | Borrowers are not paying — expect REOs, asset disposals a… | 86 | STRONG | 66.84 | D | 29 | 488 | 9153 |
zip_insurance_latest.csv5 columns · first 5 rows| zip | asof_month | insurance_distress_score | score_price_stress | score_climate |
|---|---|---|---|---|
| 32003 | 2026-06-01 | 0 | 0 | 83 |
| 32008 | 2026-06-01 | 0 | 0 | 32 |
| 32009 | 2026-06-01 | 0 | 0 | 63 |
| 32011 | 2026-06-01 | 0 | 0 | 63 |
| 32013 | 2026-06-01 | 0 | 0 | 16 |
Questions
- How current is the data?
- The as-of date is shown on this page, on the checkout and in the file header. A package is only offered while its datasets pass DLRadar's freshness gate; if a source stalls, the package is withdrawn until it refreshes.
- Can I resell or republish the file?
- No. Each file is licensed to the buyer and every row carries a per-order fingerprint. You may use it for your own research, marketing and acquisitions.