Available now

List of health professional shortage areas, medically underserved areas and health center sites

HRSA shortage designations for primary care, dental and mental health, medically underserved areas and populations, and health center sites, split into designations and the areas they cover, with a county summary. 10 tables, about 260,000 rows.

Coverage: About 21,600 designated Health Professional Shortage Areas: about 7,800 primary care, 7,200 dental health and 6,500 mental health. About 4,200 designated Medically Underserved Areas and Populations. About 19,000 active health center and FQHC look-alike sites run by about 1,600 organizations. The 50 states, DC, Puerto Rico and the other territories and freely associated states HRSA covers. Refreshed monthly from HRSA. Withdrawn and proposed-for-withdrawal designations stay in, with their dates.

Why pay for public data

HRSA publishes primary care, dental and mental health shortage areas as separate files, with each designation and the areas it covers in one layout, a few IDs reused for two different designations, and text that needs repair. This package splits designations from their components, separates the reused IDs, repairs the text and adds a county summary on standard FIPS codes that joins to Census, CDC and CMS county data.

How it is built

  1. 1

    Pull the HRSA primary care, dental and mental health HPSA files, the MUA/P file, the health center service delivery and look-alike site file, and the Census 2026 Gazetteer county file.

  2. 2

    Split each designation from the census tracts, county subdivisions and counties it covers, add a sequence number where HRSA reuses an ID, and summarize designations and sites for 3,296 counties and county equivalents.

  3. 3

    Drop the site file columns that name members of Congress and remove web address values that were email addresses. Rebuilt monthly from files HRSA refreshes daily.

What is in each record

FieldNotes
DISCIPLINE_CODE, HPSA_ID, RECORD_SEQHPSA key. RECORD_SEQ separates the few designations that share an ID
HPSA_NAME, DESIGNATION_TYPE, HPSA_CATEGORY, STATUSGeographic, population group or facility designation, and designated, proposed for withdrawal or withdrawn
HPSA_SCORE, DESIGNATION_DATE, LAST_UPDATE_DATE, WITHDRAWN_DATE
PROVIDER_FTE, SHORTAGE_FTE, DESIGNATION_POPULATION, FORMAL_RATIOPractitioners counted, practitioners needed to end the shortage, and the population to provider ratio
COMPONENT_TYPE, COMPONENT_GEOID, COUNTY_FIPS, RURAL_STATUSHPSA_COMPONENT: about 170,000 census tract, county subdivision, single county and unknown rows
MUA_ID, SERVICE_AREA_NAME, IMU_SCORE, STATUSMUA_MUP: about 4,900 designations with the Index of Medical Underservice score and its inputs where HRSA publishes them
BPHC_SITE_NUMBER, SITE_NAME, IS_LOOK_ALIKE, LOCATION_SETTING, OPERATING_HOURS_PER_WEEKHEALTH_CENTER_SITE: about 19,000 sites
SITE_ADDRESS, SITE_ZIP5, SITE_PHONE, LATITUDE, LONGITUDESite business address and main phone line
SITE_NPI, MEDICARE_BILLING_NUMBER, CONGRESSIONAL_DISTRICT_GEOIDNPI on about 6,100 sites and a Medicare billing number on about 8,600
COUNTY_SHORTAGE_SUMMARYOne row per county, with PC_HPSAS_DESIGNATED, DH_WHOLE_COUNTY_HPSA, MH_MAX_HPSA_SCORE, MUA_MUP_DESIGNATED and HEALTH_CENTER_SITES
STATE, CODE_VALUE, SOURCE_FILE, DATA_DICTIONARYHHS region lookup, every code with its meaning, source URLs and hashes, and one row for each of the 228 columns

Who uses it

  • Health systems, clinics and telehealth companies choosing where to locate
  • Workforce, recruitment and residency program planners
  • Health policy and access-to-care researchers

Pricing

$599 a year, including each monthly refresh.

No personal contact data is collected or sold in any QuestionPunk dataset.

Questions

Is this data not free from the government?
Yes. The source files are public and we link to them. You pay for the cleaning, the joins, the documented schema and the refresh, not for the data itself.
How is it delivered?
As Parquet or CSV files, by download link or to your own cloud bucket. The same tables load into Snowflake with the scripts we include.
Can I see the data before paying?
Yes. Ask for a sample and we send the Vermont rows from every table, plus the full data dictionary.
Can I use it to confirm that a location qualifies for a program?
No. HRSA refreshes its files daily and this is a monthly snapshot, so check HRSA before relying on a designation for an application or payment. Nothing here is an official eligibility determination.
Does it include the Area Health Resources Files?
No. The AHRF terms do not allow reuse or resale without HRSA permission, and parts of the file are copyrighted by other organizations, so it is left out.
Does it include personal data?
No. Every row is a designation, an area or a facility. The site file columns that name members of Congress are dropped, email addresses found in the web address column are removed, and domestic violence sites keep the blank address HRSA publishes.
Does it include map boundaries?
No. Components are listed by Census GEOID, so they join to boundary files or your own geography.
What is the license?
The HRSA files and the Census Gazetteer file are US government works, and HRSA lists no usage limitations for the shortage area and health center site files. HRSA does not endorse this product.

Tell us what you need

Geography, size and fields. A two-line email is enough, and a person replies.

Request a sample

More from the catalog