Medicare Mapper App

  • Medicare Mapper
  • Medicare Mapper
  • Medicare Mapper

Medicare Mapper

Medicare Mapper quickly and easily illustrates geographic patterns in the Medicare hospital inpatient expenditures and exemplifies the power of location analytics to make ‘big data’ meaningful. With Medicare Mapper, consumers see where people in their area go for services, providers see where their patients live and the relative amount of services they received.

Based on the Hospital Service Area data file provided by the Centers for Medicare and Medicaid Services (CMS), the Medicare Mapper iPad app makes anonymous data on services, providers, utilization and costs available on an intuitive tablet interface.

Solution Overview

  • Length of Stay
    Length of Stay
    Medicare Mapper can display a range of information from a nationwide view down to zip code level. This view displays the Average Length of Stay for a Medicare beneficiary. Notice the trends in and around Louisiana, as well as the area of New York State. Also note the projected increase of the Total Cost of Care for 2017.
  • Number of Cases
    Number of Cases
    Selecting a specific hospital displays the data and impact of the facility to a zip code level. This image shares where the Total Number of Cases is distributed for Medical City Dallas Hospital. The red circle indicates a 100 mile radius from the facility. Lines extending from the circle connect to other zip codes where beneficiaries live. Darker linesindicate more cases.
  • Beneficiary Sources
    Beneficiary Sources
    In this view, the focus is on a single facility in Palm Coast, Florida. Notice the numerical comparisons across the bottom with the National totals, the not applicable categories, and the strong beneficiary lines connecting the northeast United States, highlighting the snowbird effect. The application is specific enough to capture a beneficiary service from Puerto Rico.
  • Medicare Facility & ZIP Code Comparison
    Medicare Facility & ZIP Code Comparison
    Medicare Mapper allows side-by-side comparisons of facilities and zip codes. Clicking a metric in the center column will show numbers and percentages where relevant. In this comparison, one might question why Average Length of Stay is shorter at one facility, yet its Average Case Cost is 75% higher.

Partnership for Spatial Health Information

Critigen is committed to unlocking essential health information sources and making them accessible to executives, citizens and health professionals. Together, Critigen, Social & Scientific Systems and Esri are bringing the power of GIS location analytics and the ArcGIS Platform to bear on Medicare and other essential health information to realize our vision of informed health policy decisions.

Unlocking the geographic component of large health information databases brings new questions and new answers to key questions on how to manage and invest in our healthcare system and how to improve the health of our nation and communities.

Medicare Mapper on the App Store

Jump in with the Medicare Mapper tutorial

 

Critigen

 

Esri

 

Social & Scientific Systems, Inc.

Hospital Service Area File 2011

The Hospital Service Area data file provided by the Centers for Medicare and Medicaid Services (CMS) for 2011 contains 990,455 unique ZIP code:provider records. Critigen cleansed and geo-enabled the data files with help from the US Census Bureau’s ZIP code file and population data from Esri.

Here’s some interesting results of our processing to keep you can get Medicare Mapper from the Apple App Store.

  • $631,202,926,283 worth of services were reimbursed by Medicare in the United States
  • The average cost per case of Medicare services in the nation was $41,916
  • The top four zip codes that received Medicare services in the country (by total cost) were in New Jersey,
    for a total cost of $1,745,429,524   -  the fifth zip code was in Pennsylvania
  • The top five facilities provided Medicare services totaling $14,376,953,228
  • There were 6,087 unique providers
  • There were 39,060 unique zip codes
  • $31,239,648,320 contained in 134,355 HSA records was not represented in the map because the provider could not be geolocated or the zip code no longer existed

Read The Data Story for more on what geographic analysis of the HSA data revealed.