Area Health Resources File

County panel of facilities, doctors, nurse practitioners and physician assistants, shortage flags, and rurality.

Published by HRSA Finest detail county Tables 3

How we use this · on 8 desks

“How many doctors and nurse practitioners does this county have?”

Where you'll see it

CareSite Ops: Facility dossier
Health Markets: Help, Money and rules, What goes with it
Health Care Loans & Sales: Facility dossier
Region Brief: All counties, At a glance, Compare places, Start here, and 3 more
Disaster Readiness: Build a region, Know the risk
Rural Development: Check an address, County profile
Legislative: Help
Business & Site Planning: Farms & food, Pick a site
AI & Spreadsheets: at Level 3, link it into Excel or Google Sheets, download it, or ask your AI assistant about it

What we added

Matched to the same county codes as every other source, so it lines up cleanly with all of them
Connecticut's new planning regions filled in, where the agency still reports the old counties
Refreshed every week

See the desks →

AHRF county panel Sample of 25 rows out of about 3,213 · 30 columns

fips	state	county_name	state_fips	county_fips	cbsa_2023	cbsa_name	cbsa_ind	rucc_ahrf_2023	urban_influence_2013	hpsa_pc_2025	hpsa_dental_2025	hpsa_mh_2025	hospitals_2023	stgh_2023	cah_2023	community_hosp_2023	rhc_2023	snf_2023	home_health_2023	asc_2023	md_active_2023	do_active_2023	pc_phys_excl_res_2023	md_pc_excl_res_2023	np_npi_2023	pa_npi_2023	aprn_npi_2023
01001	AL	Autauga	01	001	33860	Montgomery, AL Metro SA	1	2	2	1	2	1	1	1	0	1	0	1	1	0	41	1	22	21	29	5	35
01003	AL	Baldwin	01	003	19300	Daphne-Fairhope-Foley, AL Metro SA	1	3	2	2	0	1	4	3	0	3	0	7	6	2	523	71	172	151	219	54	253
01005	AL	Barbour	01	005	21640	Eufaula, AL-GA Micro SA	2	6	6	1	2	1	1	1	0	1	2	1	0	0	12	1	7	6	22	1	22
01007	AL	Bibb	01	007	13820	Birmingham, AL Metro SA	1	1	1	1	2	2	1	1	0	1	1	1	1	0	38	16	26	23	30	5	31
01009	AL	Blount	01	009	13820	Birmingham, AL Metro SA	1	1	1	1	2	2	1	1	1	1	5	2	3	0	16	0	10	10	21	1	23
01011	AL	Bullock	01	011		No data	0	8	6	1	2	1	1	1	0	1	3	1	0	0	3	0	2	2	6	0	6
01013	AL	Butler	01	013		No data	0	6	6	1	2	1	1	1	0	1	4	2	3	0	13	0	5	5	18	2	21
01015	AL	Calhoun	01	015	11500	Anniston-Oxford, AL Metro SA	1	3	2	2	2	1	2	1	0	1	1	5	2	1	160	16	60	54	127	14	171
01017	AL	Chambers	01	017	29300	LaGrange, GA-AL Micro SA	2	6	5	1	2	2	0	0	0	0	0	4	2	0	25	3	12	11	12	0	17
01019	AL	Cherokee	01	019		No data	0	8	6	1	2	1	1	1	0	1	4	1	2	0	10	2	10	8	26	0	28
01021	AL	Chilton	01	021	13820	Birmingham, AL Metro SA	1	1	1	2	2	1	1	1	0	1	1	1	2	0	22	0	11	11	15	2	16
01023	AL	Choctaw	01	023		No data	0	9	10	1	2	1	1	1	1	1	2	1	1	0	7	0	6	6	7	0	7
01025	AL	Clarke	01	025		No data	0	9	11	1	2	1	2	2	0	2	3	2	1	0	11	4	10	9	21	1	24
01027	AL	Clay	01	027		No data	0	9	10	1	2	1	1	1	0	1	0	2	1	0	6	0	4	4	6	0	6
01029	AL	Cleburne	01	029		No data	0	8	4	1	2	1	0	0	0	0	0	1	0	0	5	1	4	3	4	1	4
01031	AL	Coffee	01	031	21460	Enterprise, AL Micro SA	2	4	5	2	2	1	1	1	0	1	1	2	2	1	49	8	26	21	43	5	51
01033	AL	Colbert	01	033	22520	Florence-Muscle Shoals, AL Metro SA	1	3	2	2	0	1	2	2	0	2	0	3	0	0	87	16	37	30	116	3	137
01035	AL	Conecuh	01	035		No data	0	9	11	2	2	1	1	1	0	1	1	1	1	0	6	0	5	5	5	0	5
01037	AL	Coosa	01	037	45180	Talladega-Sylacauga, AL Micro SA	2	8	3	1	2	1	0	0	0	0	1	1	0	0	1	1	0	0	6	0	6
01039	AL	Covington	01	039		No data	0	6	6	2	2	1	2	2	0	2	3	3	2	0	38	4	19	17	45	4	52
01041	AL	Crenshaw	01	041		No data	0	8	6	1	2	1	2	1	0	1	1	1	0	0	4	0	2	2	11	2	12
01043	AL	Cullman	01	043	18980	Cullman, AL Micro SA	2	4	3	2	0	2	1	1	0	1	3	4	2	1	91	9	43	36	127	7	164
01045	AL	Dale	01	045	37120	Ozark, AL Micro SA	2	4	5	2	2	1	1	1	0	1	0	2	2	0	31	5	10	9	30	12	33
01047	AL	Dallas	01	047	42820	Selma, AL Micro SA	2	4	5	1	2	1	1	1	0	1	0	3	2	0	86	7	41	40	37	1	42
01049	AL	DeKalb	01	049	22840	Fort Payne, AL Micro SA	2	6	6	1	2	1	1	1	0	1	6	3	2	0	51	5	31	28	82	0	92

Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.

See pricing