Loading

Downloads

Geographic Crosswalks and Research Files

Terms and Conditions of Data Use: please read before downloading data.

Contents


ZIP code crosswalks

Our ZIP code to HSA to HRR crosswalk files allow you to aggregate data you may have at the ZIP code level to the hospital service area (HSA) or hospital referral region (HRR) level.

  2015
  2014
  2013
  2012
  2011
  2010
  2009
  2008
  2007
  2006
  2005
  2004
  2003
  2002
  2001
  2000
  1999
  1998
  1997
  1996
  1995

Other crosswalks


Geographic boundary files

Our boundary files allow you to create your own maps using ESRI® ArcGIS® software. The shape files are not projected. The geographic coordinate system is North American Datum 1983.


Coding trends

During each annual CMS data file update, we produce trend files of the year-to-year unsuppressed event and person counts of the diagnosis and procedure codes used in the Medicare claims files: MedPAR, Part B (Carrier), and Outpatient. These coding trends are useful for researchers to determine if there was a change (increase/decrease) over time that may indicate that a code is obsolete or a different code is being used to capture a particular diagnosis or procedure.

The coding trends rely on Medicare claims files. Each of the codes includes a descriptive label. Each file includes a description of the codes and the Medicare file from which the data was derived, as well as a link to the data dictionary located on ResDAC's web site.

The table below shows which files are used by default and the sample size.

Type Source Files Sample Size
Diagnosis Code ptbYYYYclmp1
medparYYYY
opYYYYclmp1
20%
100%
20%
HCPCS Code ptbYYYYlnitp1
opYYYYrevp1
20%
20%
Revenue Code opYYYYrevp1 20%
Procedure Code medparYYYY 100%
DRG medparYYYY 100%
MSDRG medparYYYY 100%

Note: when a 20% sample is used, the resulting code count is multiplied by five to arrive at the final count.


Longitudinal research files

These files are intended to make our database easier to use for researchers conducting longitudinal studies. They include data for multiple years for each measure, most going back at least as far as 2008, allowing researchers to access several years' worth of Dartmouth Atlas rate data. In addition to adjusted rates, the files contain crude rates, numerators, denominators, 95% confidence limits, and standard errors. They are available in STATA (.dta) and Microsoft Access (.mdb) format to allow investigators to use the software of their choice to run analyses. Data are available for states, hospital referral regions, hospital service areas, counties, and individual hospitals.

Topic Microsoft
Access
format (.mdb)
Stata
format (.dta)
Medicare spending State
HRR
HSA
County

State
HRR
HSA
County

Ambulatory care quality State
HRR
HSA
County

State
HRR
HSA
County

Hospital discharges
(medical & surgical)
State
HRR
HSA
County

State
HRR
HSA
County

Post-acute care State
HRR
HSA
County
Hospital

State
HRR
HSA
County
Hospital

End-of-life inpatient care
(all decedents)
State
HRR
HSA
County

State
HRR
HSA
County

Care of chronically ill
patients, last 2 years of life
State
HRR
Hospital

State
HRR
Hospital

Mortality (by HMO status) State
HRR
HSA
State
HRR
HSA





[ CONTACT US ] [ SITE MAP ]

© 2017 The Trustees of Dartmouth College | 35 Centerra Parkway, Lebanon, NH 03766 | (603) 653-0800


The Dartmouth Atlas of Health Care is based at The Dartmouth Institute for Health Policy and Clinical Practice and is supported by a coalition of funders led by the Robert Wood Johnson Foundation, including the WellPoint Foundation, the United Health Foundation, the California HealthCare Foundation, and the Charles H. Hood Foundation.