The Area Health Resources Files (AHRF) provide current as well as historic data for more than 6,000 variables for each of the nation's counties, as well as state and national data. They contain information on health facilities, health professions, measures of resource scarcity, health status, economic activity, health training programs, and socioeconomic and environmental characteristics. In addition, the basic file contains geographic codes and other metadata which enable it to be linked to other files.

The Area Resource File is a database of health resources data, measured at the county level for over 6,000 indicators. The information includes measures of employment in various health professions including numbers of professionals registered as M.D., D.O., DDS, R.N., L.P.N., veterinarian, pharmacist, optometrist, podiatrist, and dental hygienist; availability of health facilities including hospital size, type, utilization, staffing and services, and nursing home data; frequency of utilization including utilization rates, inpatient days, outpatient visits and operations data; hospital and Medicare expenditures and demographic and geographic indicators by county. The information is collected from several sources which are noted in the technical documentation and provided by the Bureau of Health Professions, Health Resources and Services Administration of the US Department of Health and Human Services. The data here are from the 2005 Area Resource File that was purchased by the Woodruff Library in 2006. The data are available in Stata 13 (.dta) and comma-delimited (.csv) formats and are available for use by Emory students, faculty and staff. They are also provided as a whole, and in smaller datasets that are divided into broad subjects (Professions, Population, Facilities and Expenditures and Utilization). The files are available in both "wide" (one row per county) and "long" (one row per county-year) formats. We are also providing lists of variables for both the wide and long data, along with the original data and documentation and SAS code. The data cover the years 1940-2004. Note, however, that the data are not purely annual, as the vast majority of the variables are only available for selected years. For more recent ARF data, see https://data.hrsa.gov/topics/health-workforce/ahrf. County-level, state-level, and national data are freely available to download. Older ARF data are also available via the ICPSR.

The Bureau of Health Professions Area Resource File is a county-based data file summarizing secondary data from a wide variety of sources into a single file to facilitate health analysis. The file contains over 6,000 data elements for all counties in the United States with the exception of Alaska, for which there is a state total, and certain independent cities that have been combined into their appropriate counties. The data elements include: (1) County descriptor codes (name, FIPS, HSA, PSRO, SMSA, SEA, BEA, city size, P/MSA, Census Contiguous County, shortage area designation, etc.), (2) Health professions data (number of professionals registered as M.D., D.O., DDS, R.N., L.P.N., veterinarian, pharmacist, optometrist, podiatrist, and dental hygienist), (3) Health facility data (hospital size, type, utilization, staffing and services, and nursing home data), (4) Population data (size, composition, employment, housing, morbidity, natality, mortality by cause, by sex and race, and by age, and crime data), (5) Health Professions Training data (training programs, enrollments, and graduates by type), (6) Expenditure data (hospital expenditures, Medicare enrollments and reimbursements, and Medicare prevailing charge data), (7) Economic data (total, per capita, and median income, income distribution, and AFDC recipients), and (8) Environment data (land area, large animal population, elevation, latitude and longitude of population centroid, water hardness index, and climate data). (ICPSR 3/16/2015)

A database containing more than 6,000 variables for U.S. counties. ARF contains information on health facilities, health professions, measures of resource scarcity, health status, economic activity, health training programs, and socioeconomic and environmental characteristics. In addition, the basic file contains geographic codes and descriptors which enable it to be linked to many other files and to aggregate counties into various geographic groupings.

Data downloads for health resources - organ donation and transplantation centers, shortage areas, health professions training programs, health center service delivery and look-alike sites, mental health, dental health, etc. Download metadata, Excel, and CSV files.

DATA.HRSA.GOV is the go-to source for data, dashboards, maps, reports, locators, APIs and downloadable data files on HRSA's public health programs, including:

• HRSA-funded Health Center grants, grantees, sites, and related primary care programs
• Health Professional Shortage Areas (HPSA) and Medically Underserved Areas/Populations (MUA/P)
• Ryan White HIV/AIDS services, grantees, and providers
• Maternal and Child Health grants (Title V, Home Visiting, Healthy Start)
• National Health Service Corps (NHSC), Nurse Corps, and other workforce loan repayment/scholarship programs
• Grants for workforce training programs in medicine, nursing, dentistry, and public health
• Grants for rural health programs
• Organ donation

DATA.HRSA.GOV allows you to search by topic area, by geography, and by tool.

analyze the area resource file (arf) with r the arf is fun to say out loud. it's also a single county-level data table with about 6,000 variables, produced by the united states health services and resources administration (hrsa). the file contains health information and statistics for over 3,000 us counties. like many government agencies, hrsa provides only a sas importation script and an as cii file. this new github repository contains two scripts: 2011-2012 arf - download.R download the zipped area resource file directly onto your local computer load the entire table into a temporary sql database save the condensed file as an R data file (.rda), comma-separated value file (.csv), and/or stata-readable file (.dta). 2011-2012 arf - analysis examples.R limit the arf to the variables necessary for your analysis sum up a few county-level statistics merge the arf onto other data sets, using both fips and ssa county codes create a sweet county-level map click here to view these two scripts for mo re detail about the area resource file (arf), visit: the arf home page the hrsa data warehouse notes: the arf may not be a survey data set itself, but it's particularly useful to merge onto other survey data. confidential to sas, spss, stata, and sudaan users: time to put down the abacus. time to transition to r. :D

Factor loadings and fit statistics of the new county-level composite SES and HSS indices.

The Area Resource File (ARF) is a compilation from more than 200 sources of the most useful data for assessing the nation's health care resources. The data are merged and summarized at a county level, combined into one computer file.

The Area Resource File is made available by the Bureau of Health Professions. The basic county-specific Area Resource File (ARF) is the nucleus of the overall ARF System. It is a database containing more than 6,000 variables for each of the nation's counties. ARF contains information on health facilities, health professions, measures of resource scarcity, health status, economic activity, health training programs, and socioeconomic and environmental characteristics. In addition, the basic file contains geographic codes and descriptors which enable it to be linked to many other files and to aggregate counties into various geographic groupings.

This repository includes data from the Health Resources & Services Administration's Area Health Resources Files (years 2000, 2004-2019), CDC Wonder, National Conference of State Legislatures, and the Drug Enforcement Agency's Automation of Reports and Consolidated Orders System (ARCOS).

Please cite the following publication when using this dataset:

KN Griffith, Y Feyman, SG Auty, EL Crable, TW Levengood. (in press). County-level data on U.S. opioid distributions, demographics, healthcare supply, and healthcare access, Data in Brief.

These data were originally collected for the following research article:

Griffith, KN, Feyman, Y, Crable, EL, & Levengood, TW. (2021). “Implications of county-level variation in U.S. opioid distribution.” Drug and Alcohol Dependence 219: e108501. https://doi.org/10.1016/j.drugalcdep.2020.108501

Distribution of county characteristics by SES and HSS classes, 2010–2012 SEER 17 combined (N = 611).

Distributions of 3-year age-adjusted cancer incidence rates, by SES and HSS, in 611 SEERa counties.

Context

Health workforce shortage areas are geographic areas, populations, and facilities that have a shortage of outpatient primary care, dental, and mental health providers and services. These areas are designated by the Health Resources and Services Administration (HRSA), a federal agency in the United States Department of Health and Human Services.

There are several types of shortage designations including: - Health Professional Shortage Areas (HPSAs) - Medically Underserved Areas and Populations (MUAPs) - Exceptional Medically Underserved Population (Exceptional MUPs) - Governor's-Designated Secretary-Certified Shortage Areas for Rural Health Clinics

HRSA's Bureau of Health Workforce operates a cooperative agreement and evaluates applications submitted by the Primary Care Office (PCO) of each U.S. state and territory as part of the process to designate some types of shortage areas. These applications are reviewed by HRSA to determine if they meet specific designation criteria which differs by the type of shortage area. Other shortage area types are automatically designated by federal statute or at the request of a state governor. Once HPSAs are designated, score is calculated which represents a relative measure of need for health care services for that discipline. Both HPSAs and MUAPs can be designated to indicate a shortage of primary care services while only HPSAs can be designated to indicate a shortage of dental or mental health services. Shortage area designations and scores are used by various federal programs for distributing resources. Some shortage area designations may also be used by state programs.

See the shortage designation website for more information.

Content

The health workforce shortage area data in the included files represent the HPSA and MUAP (including Exceptional MUP) designation information at a single point in time. The dataset is refreshed weekly from the source data files on data.hrsa.gov.

HPSAs All three file contain the same columns but represent only a single healthcare discipline. Each record represents either a "component" (county, county subdivision or census tract) of a Geographic/Population HPSA service area or represents the physical location of facility HPSA.

Files: - BCD_HPSA_FCT_DET_PC.csv: Primary Care HPSAs - BCD_HPSA_FCT_DET_DH.csv: Dental Health HPSAs - BCD_HPSA_FCT_DET_MH.csv: Mental Health HPSAs

Fields of interest: - [HPSA ID]: Unique identifier for each HPSA designation - [Designation Type]: Type of HPSA Designation. Types for areas designated for a geographic area include "Geographic HPSA", "High Needs Geographic HPSA" and "HPSA Population" - [HPSA Discipline Class]

MUAPs Each record in this file represents a "component" (county, county subdivision or census tract) of a Medically Underserved Area or Medically Underserved Population Group service area

Files: - MUA/_DET.csv: Medically Underserved Areas/Populations

Fields of interest:

Acknowledgements

Inspiration

The Healthcare Cost and Utilization Project (HCUP) State Emergency Department Databases (SEDD) contain the universe of emergency department visits in participating States. The data are translated into a uniform format to facilitate multi-State comparisons and analyses. The SEDD consist of data from hospital-based emergency department visits that do not result in an admission. The SEDD include all patients, regardless of the expected payer including but not limited to Medicare, Medicaid, private insurance, self-pay, or those billed as ‘no charge’. Developed through a Federal-State-Industry partnership sponsored by the Agency for Healthcare Research and Quality (AHRQ), HCUP data inform decision making at the national, State, and community levels. The SEDD contain clinical and resource use information included in a typical discharge abstract, with safeguards to protect the privacy of individual patients, physicians, and facilities (as required by data sources). Data elements include but are not limited to: diagnoses, procedures, admission and discharge status, patient demographics (e.g., sex, age, race), total charges, length of stay, and expected payment source, including but not limited to Medicare, Medicaid, private insurance, self-pay, or those billed as ‘no charge’. In addition to the core set of uniform data elements common to all SEDD, some include State-specific data elements. The SEDD exclude data elements that could directly or indirectly identify individuals. For some States, hospital and county identifiers are included that permit linkage to the American Hospital Association Annual Survey File and the Bureau of Health Professions' Area Resource File except in States that do not allow the release of hospital identifiers. Restricted access data files are available with a data use agreement and brief online security training.

The Healthcare Cost and Utilization Project (HCUP) State Inpatient Databases (SID) are a set of hospital databases that contain the universe of hospital inpatient discharge abstracts from data organizations in participating States. The data are translated into a uniform format to facilitate multi-State comparisons and analyses. The SID are based on data from short term, acute care, nonfederal hospitals. Some States include discharges from specialty facilities, such as acute psychiatric hospitals. The SID include all patients, regardless of payer and contain clinical and resource use information included in a typical discharge abstract, with safeguards to protect the privacy of individual patients, physicians, and hospitals (as required by data sources). Developed through a Federal-State-Industry partnership sponsored by the Agency for Healthcare Research and Quality (AHRQ), HCUP data inform decision making at the national, State, and community levels. The SID contain clinical and resource-use information that is included in a typical discharge abstract, with safeguards to protect the privacy of individual patients, physicians, and hospitals (as required by data sources). Data elements include but are not limited to: diagnoses, procedures, admission and discharge status, patient demographics (e.g., sex, age), total charges, length of stay, and expected payment source, including but not limited to Medicare, Medicaid, private insurance, self-pay, or those billed as ‘no charge’. In addition to the core set of uniform data elements common to all SID, some include State-specific data elements. The SID exclude data elements that could directly or indirectly identify individuals. For some States, hospital and county identifiers are included that permit linkage to the American Hospital Association Annual Survey File and county-level data from the Bureau of Health Professions' Area Resource File except in States that do not allow the release of hospital identifiers. Restricted access data files are available with a data use agreement and brief online security training.

[Metadata] Medically Underserved Areas/Populations (MUA/P) for the State of Hawaii as of March 2025. Source: US Health Resources and Services Administration (HRSA). Downloaded by the Hawaii State GIS Program from the Federal Health Resources and Services Administrations (HRSA) website, 3/10/25 (https://data.hrsa.gov/data/download). These data describe geographic areas and populations with a lack of access to primary care health services. Medically Underserved Areas (MUAs) may be a whole county or a group of contiguous counties, a group of county or civil divisions or a group of urban census tracts in which residents have a shortage of personal health services. Medically Underserved Populations (MUPs) may include groups of persons who face economic, cultural or linguistic barriers to health care. HRSA's Bureau of Health Workforce develops shortage designation criteria and uses them to decide whether or not a geographic area or population group is a MUA or MUP.For more information about this layer and attribute values and meanings please see https://files.hawaii.gov/dbedt/op/gis/data/mua_medically_underserved_areas.pdf or contact the Hawaii Statewide GIS Program, Office of Planning and Sustainable Development, State of Hawaii; PO Box 2359, Honolulu, Hi. 96804; (808) 587-2846; email: gis@hawaii.gov; Website: https://planning.hawaii.gov/gis.

The Area Resource File is made available by the Bureau of Health Professions. The basic county-specific Area Resource File (ARF) is the nucleus of the overall ARF System. It is a database containing more than 6,000 variables for each of the nation's counties. ARF contains information on health facilities, health professions, measures of resource scarcity, health status, economic activity, health training programs, and socioeconomic and environmental characteristics. In addition, the basic file contains geographic codes and descriptors which enable it to be linked to many other files and to aggregate counties into various geographic groupings.

The dataset contains information of Healthcare Resource Group unit costs for acute hospital procedures, broken down by Specialty on diagnosis. This a merged dataset from the year 2013 to 2020 for cost different hospital treatment criteria. Thirty-six (36) separate files were merged for this dataset.