Hpsa Score Data By County Data: Dataset Structure and Field Coverage

HPSA score data by county is the federal record of where the United States has formally designated a health-professional shortage, expressed as a 0-26 score per discipline and attachable to county geography. Inside Datadory's health care services pool - 16 primary datasets plus 7 related - exactly one record publishes that designation system itself: HRSA Data Warehouse - Health Workforce Shortage Areas, scored 9 out of 10 for quality and refreshed daily.

Its rows resolve to four grains: individual facility points, census tracts or geographic HPSAs, counties, and state rollups, split across three disciplines (primary care, dental health, mental health). Clinic planners and recruiters read these scores to target Medicare bonus payments and clinician loan-replacement placements, which is why the county join matters - it turns a national designation file into a site-selection screen.

The HRSA Data Warehouse - Health Workforce Shortage Areas is maintained by HRSA's Bureau of Health Workforce, Division of Policy and Shortage Designation, and ships 32 files for the Shortage Areas topic alone. Four are full data marts: primary care (~35 MB CSV, about 66 columns), dental health (~18 MB), mental health (~14 MB) and MUA/P detail (~11 MB). Coverage spans all 50 states, DC, U.S. territories and affiliated jurisdictions, including the freely associated states.

The primary care mart carries the fields analysts actually model, and Table 1 names them. The headline value is the NHSC HPSA Score, running 0-26 with higher meaning greater shortage; sample rows show a Federally Qualified Health Center designation for the Republic of the Marshall Islands scoring 24 sitting beside a High Needs Geographic HPSA there scoring 25.

The supporting fields make a county join defensible rather than approximate. County FIPS ties scores to Census geography, latitude and longitude place facility-level designations straight on a map, and designation population, share below 100% of poverty and estimated underserved population explain why a score landed where it did. HPSA Formal Ratio and Rural Status round out the profile, and the PC MCTA Score records a primary care-specific companion figure beside the NHSC score.

Three workflows consume these fields differently, which is worth knowing before you reshape them. Data scientists join the daily-refreshed scores and boundaries onto internal tables to model care-access deserts, and their continuation lives on the data scientists use cases page. Market researchers treat designation population and underserved estimates as unserved-demand inputs when sizing US care-delivery or clinician-staffing markets. Sales teams filter the opposite direction - finding clinics and community health centers inside designated areas, where staffing grants and expansion budgets concentrate - a motion detailed under the best data for health care services teams. Same table, three different group-bys.

A shortage score is a demand signal; the rest of the industry slice supplies the supply and spending context to interpret it. Table 2 summarizes the fit.

The strongest supply-side companion lives on the same HRSA portal: the Area Health Resources Files, an 86-file annual release whose county CSV zip weighs about 23 MB compressed. Its health-facilities table alone carries 716 columns - hospitals by type, admissions, medical school affiliation, Medicare and Medicaid provider counts - keyed to the stable fips_st_cnty county code, so joining it to HPSA rows is mechanical. Archives reach back to 1999-2000, giving the before-and-after trend work that the current-designation marts cannot. Medicare Care Compare (Hospitals, Nursing Homes, Home Health, Dialysis) contributes facility-level quality for ~5,400 hospitals, ~14,700 nursing homes, ~12,500 home health agencies and ~7,500 dialysis facilities, refreshed quarterly in January, April, July and October - chained with shortage designations, it tests whether clinics inside designated areas actually score worse.

For hands-on continuation, the data scientists use cases page walks join-and-model workflows over the daily marts, and sales teams targeting clinics inside designated areas will find their workflow under the best data for health care services teams.