Research workbook · County data
The Area Health Resources Files can support county-level workforce research, but the analyst must choose the correct file, year and specialty field. County values should not be summed into a national result unless the technical documentation says the data sources and definitions are compatible.
Draft assignment status: open. Candidate contributors Jodi Segal, MD, MPH and Lisa Cooper, MD, MPH are listed for owner selection only. This line is not a byline or medical-review statement.
Start with the file, not the map
HRSA describes the Area Health Resources Files as a collection for planners, policymakers and researchers studying the US health-care delivery system. The county, state and national files span health professions, facilities, population, economics, training, utilization, expenditures and environmental characteristics. HRSA’s current download page says the county file contains more than 6,000 variables and draws from more than 60 sources.
That breadth is the strength and the trap. A field that looks like a surgeon count may refer to a different source year, professional category or geographic assignment than the neighboring population field. The data dictionary and technical documentation are therefore part of the dataset, not optional background reading.
A reproducible five-step workflow
- 01
Freeze the release
Record the AHRF edition, download date, filename and technical-document version.
- 02
Define the specialty
State whether the analysis concerns general surgery, a surgical subspecialty or a broader physician category.
- 03
Inspect the source year
A current file can contain variables collected in different years. Carry the field year into the output.
- 04
Choose the denominator
Use a population denominator from a compatible geography and period, then name it.
- 05
Preserve missingness
Do not silently convert missing, suppressed or inapplicable values to zero.
County and national totals are not interchangeable
HRSA’s January 2026 AHRF Clinician Dashboard methods document warns that county-level and state/national data use different sources, so county values do not necessarily sum to the national or state file. This is a concrete example of why a mathematically correct calculation can still be methodologically wrong.
For county comparisons, remain within the county file and use the same field definition across places. For national context, use the national file as published. If the analysis needs both, display them as separate estimates with their source labels rather than forcing them into one total.
What a defensible output includes
| Field | Why it stays visible | Typical failure |
|---|---|---|
| Variable name | Preserves definition | Friendly label hides scope |
| Source year | Shows data age | File year substituted |
| Geography code | Supports joins | County names collide |
| Missing-value rule | Prevents false zeros | Blanks treated as none |
What the file cannot prove by itself
A county count does not show whether a surgeon is accepting new patients, covers emergencies, has operating-room time or participates in a particular insurance network. It also does not measure the boundary patients actually cross for care. Border counties, referral centers and seasonal populations can make a county-only picture misleading.
The data are better used to identify patterns and questions. A low rate may justify checking regional referral pathways; a high rate may coexist with long waits or limited procedure capacity. Those conclusions need scheduling, facility and service-level records.
Common mistakes
- Mixing release year with the underlying field year.
- Adding county values to reproduce a national total.
- Combining unlike surgical specialty definitions.
- Publishing a rate without its denominator source.