● Atlas Commons · The Cross-Atlas Join

State Decision Surface

A question no single atlas can answer — joined across five, in one query.

For any state: how many ACA plans you can choose from, how many hospitals are rated, how many FDIC lenders operate there, your storm-damage exposure, and the FEMA mitigation dollars invested. This is the entire point of one unified catalog — coverage, care, finance, and property facts joined on a normalized state key in a single R2 SQL query, no cross-database plumbing.

WITH cov AS (SELECT state_code, COUNT(*) FROM coverage_gold.plan_serving_surface GROUP BY state_code),
     care AS (SELECT state, COUNT(*) FROM care_gold.hospital_quality_serving_surface GROUP BY state), ...
SELECT * FROM cov JOIN care JOIN property JOIN finance ON state  — one warehouse, runs natively
StateACA plansRated hospitalsFDIC lendersStorm damageFEMA mitigation
TX4,277468975$488M$212M
FL2,201221662$21M$31M
WI1,678141480$183M$12M
NC1,10212076$47M$64M
OH1,080196224$7M$82M
AZ1,05610717$38M$3M
OK980135190$88M$13M
NE86893303$53M$9M
TN864122175$54M$2M
MI722148275$18M$20M
SC6976694$1M$48M
MO654121519$1.8B$20M
IA623118445$1M$19M
LA550161180$8M$332M
MT51763131$38M$9M
IN487151258$35M$3M
NH4082872$67K$2M
KS341138434$20M$6M
AL337100163$22M$3M
UT3355270$37M$186M
SD3346181$1M$7M
OR3336244$1M$10M
ND3084793$33M$15M
AR28691171$17M$7M
MS267108112$42M$4M
DE2111313$123K$1M
WV18855110$23M$648K
WY1433055$2M$5M
HI114248$2M$5M
AK982514$22M$8M
CA0378213$70M$74M
CO097215$2M$5M
CT036124$222K$26M
DC01012$2M$34M
GA0149375$4M$5M
ID04823$52M$1M
IL0194872$532M$5M
KY0103148$32M$4M
ME03657$86K$5M
MD05677$10M$15M
MA08497$505K$22M
MN0136435$41M$4M
NV0466$3M$5M
NJ079167$822K$203M
NM04563$62M$5M
NY0191215$33M$63M
PA0187125$12M$53M
PR06010$2M$3M
RI01320$62K$3M
VT01726$2M$4M
VI023$9K$764K
VA096183$25M$40M
WA010089$545M$54M
AS010$6M$3M
GU021$57K$3M
MP010$2M
● New · two atlases joined

Where lending bias meets disaster risk

Two facts that normally live in different worlds — who gets a mortgage, and what nature does to a place — answered together for the first time. HMDA mortgage decisions (finance atlas) joined to the FEMA National Risk Index (property atlas), by state, in one query. The headline number is the Black-vs-White denial disparity: how many times more often a Black applicant is denied than a White applicant in the same state. Beside it, the hazard that tops that state's federal risk index — the compounding exposure a family there actually carries.

SELECT f.state, f.black_white_denial_disparity, p.dominant_hazard, p.avg_nri_risk_score
FROM finance_gold.state_lending_access_surface f
JOIN property_gold.state_risk_profile p ON f.state = p.state
ORDER BY f.black_white_denial_disparity DESC  — one warehouse, two atlases, native join
StateB/W denial disparityBlack vs White deniedDominant hazardNRI risk
DC2.56×40% / 15%Heat Wave98
WI2.42×39% / 16%Cold Wave59
VT2.25×44% / 20%Landslide36
SC1.99×43% / 21%Hurricane71
MI1.95×42% / 21%Strong Wind50
MS1.94×48% / 25%Earthquake51
SD1.94×31% / 16%Wildfire27
LA1.90×48% / 25%Hurricane62
AR1.90×47% / 25%Ice Storm56
IL1.89×39% / 21%Earthquake54
IA1.86×28% / 15%Drought40
NE1.85×30% / 16%Hail26
AL1.81×42% / 23%Hurricane62
NC1.80×38% / 21%Hurricane67

A denial disparity is a measured fact, not a finding of discrimination — many legitimate factors drive any single lending decision. Atlas Commons reports the number with its source and routes to the official free paths: file a CFPB complaint, find a HUD-approved housing counselor, or verify on the HMDA Data Browser. Top 14 states by disparity, ≥8,000 originations. HMDA 2024 · FEMA National Risk Index.

SOURCES · CMS · NOAA · FEMA · FDIC · FFIEC/HMDA — joined across coverage/care/property/finance gold in atlas-commons-lakehouse via one R2 SQL warehouse · 56 states
a public goods project maintained by Atlas Commons · the unified catalog makes the cross-domain question answerable