Hospital Medicare Spending by Claim 2014

Medicare spending by insurance claim type by U.S. hospital for 2014

Originator: United States Department of Health and Human Services

Medicare spending per beneficiary (MSPB) at hospitals in the United States and its territories from Jan. 1, 2014 to Dec. 31, 2014. The averages and percentages are compared to other hospitals providing similar care, the state that the hospital is in, and across the nation. The hospital is identified by its name, location, and provider identification number.

(12 columns, 70598 rows)

Examples

Basic Examples

Retrieve the ResourceObject:

In[1]:=
ResourceObject["Hospital Medicare Spending by Claim 2014"]
Out[1]=

View the data:

In[2]:=
ResourceData["Hospital Medicare Spending by Claim 2014"]
Out[2]=

Visualization

Identify and plot the locations of hospitals whose average spending per inpatient claim during hospital admission exceeded the national average:

In[3]:=
ResourceData["Hospital Medicare Spending by Claim 2014"][
 Select[#ClaimType == "Inpatient" && #Period == 
     "During Index Hospital Admission" && #AvgSpentHospital > \
#AvgSpentNation &]]
Out[3]=
In[4]:=
GeoListPlot[%[All, "Coordinates"]]
Out[4]=

Analysis

Analyze outpatient spending in Los Angeles hospitals compared with the national average:

In[5]:=
outpatientRatios = 
 SortBy[ResourceData["Hospital Medicare Spending by Claim 2014"][
    Select[#City == 
        Entity["City", {"LosAngeles", "California", 
          "UnitedStates"}] && #ClaimType == "Outpatient" && #Period ==
         "1 through 30 days After Discharge from Index Hospital \
Admission" &]][All, {#Hospital, #AvgSpentHospital/#AvgSpentNation} &],
   Last]
Out[5]=
In[6]:=
BarChart[outpatientRatios[All, 2], BarOrigin -> Left, 
 ChartLabels -> Normal[outpatientRatios[All, 1]], ImageSize -> 600]
Out[6]=

Wolfram Research, "Hospital Medicare Spending by Claim 2014" from the Wolfram Data Repository. (2016) https://doi.org/10.24097/wolfram.66894.data

License Information

https://data.medicare.gov/about

Source Metadata