National Center for Health Workforce Analysis Area Resource File, 2005 Release

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. This information has also been collected for earlier years in an earlier distribution which is available through the Inter-University Consortium for Political and Social Research (ICPSR) data holdings as Study #9075.

The Area Resource File data are provided by the Electronic Data Center in various formats: SAS (XPORT), SPSS (.sav and .por), and Stata. The data 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). They are provided in both wide (cross-sectional) and long (time-series) formats.

PLEASE NOTE THAT SEVERAL OF THESE FILES ARE VERY LARGE. They may exceed the size limits for spreadsheet programs such as Microsoft Excel. If you need assistance getting ARF data into a particular format, please contact the Electronic Data Center staff.

The subject files are smaller because they are created by breaking the complete files into pieces by subject. Downloading these individually may prove faster and more manageable. Note that each subject file includes county identification variables for merging purposes.


Complete Area Resource File

SAS XPORT File (*.xpt)

SPSS Data File (*.sav)

SPSS Portable Data File (*.por)

Stata Data File (*.dta)

arf2005_wide.xpt (155M)

arf2005_wide.sav (50M)

arf2005_wide.por (63M)

arf2005_wide.dta (46 MB)

arf2005_long.xpt (2.7G)

arf2005_long.sav (391M)

arf2005_long.por (733M)

arf2005_long.dta (854 MB)



Area Resource File, by Main Subject

Subject

SAS XPORT File (*.xpt)

SPSS Data File (*.sav)

SPSS Portable Data File (*.por)

Stata Data File (*.dta)

Professions (Wide): Number of doctors in various specialties by county

professions_wide.xpt

professions_wide.sav

professions_wide.por

professions_wide.dta

Professions (Long): Number of doctors in various specialties by county-year

professions_long.xpt

professions_long.sav

professions_long.por

professions_long.dta

Facilities (Wide): Number of hospitals and various capabilities by county

facilities_wide.xpt

facilities_wide.sav

facilities_wide.por

facilities_wide.dta

Facilities (Long): Number of hospitals and various capabilities by county-yer

facilities_long.xpt

facilities_long.sav

facilities_long.por

facilities_long.dta

Expenditures and Utilization (Wide): Medicare and Hospital Expediture and inpatient, outpatient and surgery use by county

expenditures_util_wide.xpt

expenditures_util_wide.sav

expenditures_util_wide.por

expenditures_util_wide.dta

Expenditures and Utilization (Long): Medicare and Hospital Expediture and inpatient, outpatient and surgery use by county-year

expenditures_util_long.xpt

expenditures_util_long.sav

expenditures_util_long.por

expenditures_util_long.dta

Population (Wide): Population demographics by county

population_wide.xpt

population_wide.sav

population_wide.por

population_wide.dta

Population (Long): Population demographics by county

population_long.xpt

population_long.sav

population_long.por

population_long.dta


User Documentation for the 2005 Area Resource File



Other Resources and Links for the Area Resource File Data:

Area Resource File (ARF): National County-Level Health Resource Information Database - The Homepage for the Area Resource File Data

ICPSR Study #9075: Bureau of Health Professions Area Resource File, 1940-1990 - An older version of the Area Resource File hosted by the ICPSR



Home | Analyze Data Online | Help Resources | Contacts & Hours | Emory General Libraries