Snowflake Public Data · zero ETL
Florida counties ranked by disaster exposure, poverty, and how few doctors are actually there. Aid deserts are where all three line up.
| County | Disasters | Poverty | Docs /10k | Need |
|---|
Which counties had disasters but fewest doctors?
Cortex Analyst chose doctors per 10,000 residents over the raw headcount on its own, then wrote and ran this:
SELECT county_name, disaster_count, providers_per_10k, poverty_rate_pct, aid_desert_score FROM aid_desert WHERE disaster_count > 0 ORDER BY providers_per_10k ASC LIMIT 10
Top answer: Glades County — 14 disaster declarations, 20.7 doctors per 10k, the thinnest coverage in the state.
Percentile rank across the 67 counties, weighted 35% disaster frequency, 35% poverty rate, 30% scarcity of doctors per capita. Percentiles rather than divide-by-max, so one extreme county can't compress the scale.
FEMA, Census and NPPES all carry a shared
GEO_ID, so the join runs on that spine rather than FIPS codes.
NPPES has no county id, so providers roll up from ZIP through the geography hierarchy.
NPPES stores mailing and practice addresses — counting both double-credits a doctor to two counties. And two counties have no ZIP children at all, so a ZIP-only rollup reports them as having zero doctors.
County population sums to 22.4M against Florida's
actual 22.6M — the joins line up.