Mobile Visitors:

Try our mobile site at http://datawarehouse.hrsa.gov/mobile

Skip Navigation
H H S Department of Health and Human Services
H H S Department of Health and Human Services

Health Resources and Services Administration

Data Warehouse

Full site menu when scripts are turned off:

You are here: skip breadcrumb > Downloadable Data > PCSA Data (2007 edition)     -    Print this page

Primary Care Service Areas - 2007 edition

The 2007 edition of the PCSA database contains nationwide data United States primary health care resources, populations and utilization, compiled and presented in newly developed units of analysis (Primary Care Service Areas) and related to other geopolitical regions.

PCSAs were developed by aggregating ZIP Code Tabulation Areas. The boundary definitions for the 2007 edition of the data are the same as for the previous (2006) edition.

For previous editions of PCSA data click below:

Downloadable PCSA data are in DBF format. With the exception of the Centers for Medicare and Medicaid Services (CMS) data, missing data are identified as -99. In the CMS data suppression rules apply to the Medicare variables; suppressed data values are shown as -999.

The 2007 data are organized by data source or subject; this is in contrast to the 2006 edition which was organized by geographic summary level (State, county, various super-county or sub-county units, PCSA, and ZCTA).

HRSA UPDATE AMA Data - Physician Characteristics 2007

Physician characteristics were derived from 2007 HRSA American Medical Association Physician Masterfile (QUO-56122-JLG5LI.txt, N= 1,204,406 received on April 2009). Characteristics of primary care physicians (family physicians, general internists, and pediatricians), specialists, obstetricians /gynecologists are provided at ZCTA and PCSA levels. Physician supply (unadjusted and age-sex adjusted rates per capita) was calculated at the PCSAlevel only. The method for calculating age-sex adjusted supply was based on the method as described in the Dartmouth Atlas of Health Care, 1999. (www.dartmouthatlas.org) Exit Disclaimer

The two downloadable DBF format files that contain these data are:

  1. ZCTA-level: hrsa_ama0310_zcta.dbf (21,165 KB); 32,011 ZCTAs with 44 variables
  2. PCSA-level: hrsa_ama0310_pcsa.dbf (6,084 KB); 6,542 PCSAs with 61 variables

For detailed information, please refer to the data dictionary: HRSA AMA Data Dictionary 0509.pdf Adobe PDF format (PDF format)

2007 CMS Data (AMA Physician Workforce and Medicare Utilization Data) ZCTA and PCSA Layers

The two downloadable DBF format files that contain these data are:

  1. ZCTA-level: hrsa_cms2007_zcta_v0910.dbf (19,040 KB); 32,011 ZCTAs with 39 variables
  2. PCSA-level: hrsa_cms2007_pcsa_v0910.dbf (11,376 KB); 6,542 PCSAs with 112 variables

For detailed information, please refer to the data dictionary: HRSA CMS 2007 Update Data Dictionary 0910.pdf Adobe PDF format (PDF format)

Health Professional Shortage Area (HPSA) and Medically Underserved Areas / Medically Underserved Populations (MUA/P) link to ZCTAs and PCSAs

This addition to the PCSA dataset provides the user with multiple means to assign markers of under service (Health Professional Shortage Areas (primary care, mental health, and dental) and Medically Underserved Areas/ Medically Underserved Populations) at the ZCTA level and the PCSA level. The data has been prepared in collaboration with the Robert Graham Center for Primary Care Studies. The HPSA/MUA data were accessed on 04/19/2007, and the population was aggregated from 2006 block level population estimates*. Additional information about federal HPSA and MUA designation may be found online at http://bhpr.hrsa.gov/shortage/

The two downloadable DBF format files that contain these data are:

  1. ZCTA-level: ZCTA_HPSA_MUA_0908.dbf (14,633 KB); 32,011 ZCTAs with 67 variables
  2. PCSA-level: PCSA_HPSA_MUA_0908.dbf (2,756 KB); 6,542 PCSAs with 64 variables

For detailed information, please refer to the data dictionary HPSA_MUA_DD.xls Excel icon (Excel format) or HPSA_MUA_DD.PDF Adobe PDF format (PDF format) and to the "readme" file HPSA_MUA_Readme_0908.pdf Adobe PDF format (PDF format)

National Physician Inventory (NPI) Update

The purpose of the NPI update is to provide 2007 primary care physician supply by PCSAs and counties based on 2007 American Medical Association Physician Masterfile (AMA MF) and 20% Centers for Medicare and Medicaid Services (CMS) Medicare Part B and Outpatient claim data.

Because physician residents usually do not have their own UPIN and CMS claims contain services to the elderly only, both lower and upper bounds of primary care supply were provided.

Two DBF format files are:

  1. PCSA-level: hrsa_npi0510_pcsa.dbf (1,681 KB); 6,542 PCSAs with 14 variables
  2. County-level: hrsa_npi0510_cnty.dbf (535 KB); 3141 Counties with 12 variables

For detailed information, please refer to the data dictionary HRSA National Physician Inventory Data Dictionary 0510.pdf Adobe PDF format (PDF format) and to the "readme" file HRSA National Physician Inventory 0510 README.pdf Adobe PDF format (PDF format).

2009 Population Estimates for ZCTAs and 2009 Population, Poverty and Insurance Estimates for PCSAs

Due to the limit on the number of columns that a DBF can contain, the data for these subjects have been split into multiple files for each summary level. The ZCTA summary level comprises 460 unique variables; the PCSA summary level has 457.

The downloadable DBF format files that contain these data are:

  1. ZCTA-level: est09_zcta1.dbf(69,875 KB); 218 variables including 12 header variables (identification and total population variables)
  2. ZCTA-level: est09_zcta2.dbf (84,631 KB); 254 variables with the same 12 header variables
  3. PCSA-level: est09_pcsa1.dbf (13,998 KB); 215 variables including 9 header variables,
  4. PCSA-level: est09_pcsa2.dbf (17,015 KB); 251 variables with the same 9 header variables.

For detailed information about the data elements, please refer to data dictionary file 2009 Population Update Data Dictionary.pdf Adobe PDF format (PDF format).

The methodology is described in Population Estimates 2009.pdf Adobe PDF format (PDF format) and to the "readme" file Readme Populate Estimate 2009.pdf Adobe PDF format (PDF format).

About Congressional District Boundaries:
On January 3, 2013, the 113th Congress began its session. The Census Bureau released the geographies for the new districts on January 7, 2013. The HDW is updating its reference data with the new geographies. In the interim, HDW will use the 112th Congressional District boundaries, which may affect geoprocessing assignments. Read more >>

See HRSA Data Fact Sheets and Comparison Tools
Did You Know
 
  • Play
  • Pause
Related Sites

Daily updates of the HPSA data will resume on March 29, 2013. If you have any questions, please contact CAPT Phil Budashewitz, Director, Division of Policy and Shortage Designation, Bureau of Clinician Recruitment and Service at pbudashewitz@hrsa.gov.

  • RSS
  • Facebook
  • Twitter
  • Youtube