Health Professional Shortage Areas
Health Professional Shortage Areas
By HRSA
Federally designated areas with a shortage of healthcare workers
Product type
Dataset
Update frequency
Annually
Updated
Jun 7, 2023
Delivery method
Download
Metadata is available for each file version of the dataset. A JSON file can be downloaded once you subscribe to the dataset. The information below is an example of the metadata included in each JSON file.
Dataset file name: BCD_HPSA_FCT_DET_MH.csv
Key Statistics
Total records
27,154
Missing values
0.913%
Duplicate rows
0%
Columns
Columns
66
Categorical
35
Numeric
15
Date/time
6
Correlations
Correlations
7
Correlated columns
Primary State FIPS Code and Common State FIPS Code, HPSA Designation Population and HPSA Resident Civilian Population, State FIPS Code and Common State FIPS Code, HPSA Estimated Served Population and HPSA Resident Civilian Population, HPSA Estimated Served Population and HPSA FTE, HPSA Estimated Underserved Population and HPSA Shortage, Primary State FIPS Code and State FIPS Code
Column name | Type | Unique values | Min value | Max value |
|---|---|---|---|---|
HPSA Score | numeric | 24 | 0 | 25 |
HPSA FTE | numeric | 580 | 0 | 133 |
HPSA Designation Population | numeric | 6,939 | 0 | 4401127 |
% of Population Below 100% Poverty | numeric | 366 | 0 | 80 |
Longitude | numeric | 5,692 | -176.65758 | 166.412 |
Latitude | numeric | 5,696 | -14.319 | 71.29902 |
Common Postal Code | numeric | 4,221 | 617 | 99950 |
Common State FIPS Code | numeric | 59 | 1 | 78 |
Discipline Class Number | numeric | 1 | 7 | 7 |
HPSA Estimated Served Population | numeric | 602 | 0 | 1599800 |
HPSA Estimated Underserved Population | numeric | 2,117 | -1397769 | 2592339 |
HPSA Resident Civilian Population | numeric | 337 | 0 | 3702339.2 |
HPSA Shortage | numeric | 919 | -8.66 | 86.41 |
Primary State FIPS Code | numeric | 59 | 1 | 78 |
State FIPS Code | numeric | 59 | 1 | 78 |
HPSA ID | categorical | 8,907 | 6 | 10 |
Primary State Abbreviation | categorical | 59 | 2 | 2 |
HPSA Status | categorical | 3 | 9 | 23 |
Metropolitan Indicator | categorical | 4 | 7 | 16 |
HPSA Geography Identification Number | categorical | 15,605 | 5 | 11 |
HPSA Formal Ratio | categorical | 1,215 | 3 | 10 |
Primary HHS Region Name | categorical | 10 | 8 | 9 |
Rural Status | categorical | 6 | 3 | 15 |
Break in Designation | categorical | 1 | 1 | 1 |
BHCMIS Organization Identification Number | categorical | 1,580 | 3 | 8 |
Common Region Name | categorical | 10 | 8 | 9 |
Common State Abbreviation | categorical | 59 | 2 | 2 |
Common State Name | categorical | 59 | 4 | 30 |
Common State County FIPS Code | categorical | 3,206 | 5 | 5 |
County or County Equivalent Federal Information Processing Standard Code | categorical | 343 | 3 | 3 |
County Equivalent Name | categorical | 1,952 | 3 | 25 |
HPSA Address | categorical | 5,546 | 2 | 51 |
HPSA City | categorical | 3,099 | 3 | 22 |
HPSA Component Source Identification Number | categorical | 6,316 | 3 | 10 |
HPSA Component State Abbreviation | categorical | 60 | 2 | 3 |
HPSA Component Type Code | categorical | 4 | 2 | 4 |
HPSA Metropolitan Indicator Code | categorical | 4 | 1 | 1 |
HPSA Population Type Code | categorical | 12 | 1 | 9 |
HPSA Provider Ratio Goal | categorical | 9 | 3 | 7 |
HPSA Postal Code | categorical | 5,507 | 3 | 10 |
HPSA Status Code | categorical | 3 | 1 | 1 |
HPSA Type Code | categorical | 13 | 3 | 11 |
Primary State Name | categorical | 59 | 4 | 30 |
Provider Type | categorical | 4 | 3 | 33 |
Rural Status Code | categorical | 6 | 1 | 3 |
State Abbreviation | categorical | 59 | 2 | 2 |
State and County Federal Information Processing Standard Code | categorical | 3,207 | 3 | 5 |
State Name | categorical | 59 | 4 | 30 |
U.S. - Mexico Border 100 Kilometer Indicator | categorical | 3 | 1 | 1 |
U.S. - Mexico Border County Indicator | categorical | 3 | 1 | 1 |
HPSA Name | text | 8,320 | 3 | 100 |
Designation Type | text | 10 | 14 | 75 |
HPSA Discipline Class | text | 1 | 13 | 13 |
HPSA Degree of Shortage | text | 30 | 1 | 14 |
HPSA Population Type | text | 13 | 3 | 59 |
Common County Name | text | 3,206 | 7 | 37 |
HPSA Component Name | text | 16,996 | 1 | 100 |
HPSA Component Type Description | text | 4 | 7 | 18 |
HPSA Designation Population Type Description | text | 19 | 14 | 75 |
HPSA Designation Date | date | 2,086 | 01/01/1970 | 07/22/2021 |
HPSA Designation Last Update Date | date | 715 | 10/12/1984 | 07/23/2021 |
Withdrawn Date | date | 252 | 1984-10-12T00:00:00 | 2021-07-07T00:00:00 |
Data Warehouse Record Create Date | date | 1 | 07/25/2021 | 07/25/2021 |
Data Warehouse Record Create Date Text | date | 1 | 2021/07/25 | 2021/07/25 |
HPSA Withdrawn Date String | date | 252 | 1984-10-12T00:00:00 | 2021-07-07T00:00:00 |