Thursday, May 9, 2013

Medicare Provider Charge Data - How Are Things in Spokane?


Disclosure: I am not a health care professional, but just some one interested in playing with data and ways to represent them. I am not going to interpret findings here, but will make a remark or two about how to interpret them from the few graphs shown below.

This project came up in the past couple of days, when I came across headlines about wide variations in prices charged by hospitals for the same procedures across the country, and in some instances, within the same city. (For national coverage, see here, here, and here. For local coverage on this issue, see here, here, and here.) This interest nation-wide came about because the Obama administration released this data recently (as of this post, the source page on the Centers for Medicare and Medicaid Services was last updated on 7 May, 2013). My understanding is that this is the first time something like this has been done. The source page provides public access to the data as well as this description of the data.

The data provided here include hospital-specific charges for the more than 3,000 U.S. hospitals that receive Medicare Inpatient Prospective Payment System (IPPS) payments for the top 100 most frequently billed discharges, paid under Medicare based on a rate per discharge using the Medicare Severity Diagnosis Related Group (MS-DRG) for Fiscal Year (FY) 2011. These DRGs represent almost 7 million discharges or 60 percent of total Medicare IPPS discharges.
Hospitals determine what they will charge for items and services provided to patients and these charges are the amount the hospital bills for an item or service. The Total Payment amount includes the MS-DRG amount, bill total per diem, beneficiary primary payer claim payment amount, beneficiary Part A coinsurance amount, beneficiary deductible amount, beneficiary blood deducible amount and DRG outlier amount.
For these DRGs, average charges and average Medicare payments are calculated at the individual hospital level. Users will be able to make comparisons between the amount charged by individual hospitals within local markets, and nationwide, for services that might be furnished in connection with a particular inpatient stay.

What I did was to download the data and focus specifically on Spokane. Here are some graphs.

1. What is the range and distribution of cost of procedures different providers undertake? Hint: The purple bars on the left indicate that Valley Hospital handles many procedures that are generally lower cost than the few super expensive ones that Providence Sacred Heart or Deaconess (on the right) handle.

2. A better look at the distribution of cost or procedures at different providers can be taken from the graph below, which is also known as a kernel density graph. (Hint: Valley Hospital handles mostly low cost procedures and does not appear to have a presence in the  super expensive section.)

3. What is the pattern of charges imposed by different providers for different procedures? Here, we look at the basic pattern, without focusing on the individual procedures. The procedures along the vertical axis have been arranged by increasing average costs. Hint: Which colored dots appear predominantly on the left and which colored dots appear predominantly on the right? The former generally charge lesser than the latter.

Lot of clutter above... so the following three graphs explore three different sections - 1. Average costs of up to 25,000 (2) average costs between 25k and 50k, and (3) average costs above 50k. Please note that in each graph, there may be truncation in the dots if multiple providers charged costs in different categories (of the three mentioned above.)

 4. Finally, what do different providers charge for different procedures? For this, I'll take you to a different site (hosted by RStudio to enable such interactive applications) to interact with this data. (Please click on the picture below to visit that site.) The site will ask for the procedure and will provide charts of the costs (charges) at different providers, average total payment for that procedure to that provider, and lastly, total discharges by that provider for that procedure. Enjoy.


  1. I am impressed with this site, very I am a fan . cannabidiol store

  2. Sweet web site , super style and design , rattling clean and utilize genial .

  3. CBD oil can also affect the immune system by inhibiting the reuptake of the neurotransmitter adenosine. Through this action, the amount of adenosine in the brain is increased, influencing the A2A adenosine receptors in such a way that reduces inflammation throughout the body.

  4. In order to completely understand the benefits you will receive under Medicare, read the comprehensive brochure for seniors "Choosing a Medigap Policy: A Guide to Health Insurance for People with Medicare". earloop mask singapore

  5. What happens if you miss a dose, or not all the med was taken/given for some reason?: It can happen! Should you skip it? Take it? Double up the next dose? Both my husband and I have given Nick meds through the feeding tube using the medicine port and had the feeding port blow open while pushing the med through with a syringe. CBD gummies

  6. Some anti-anxiety medications are also depressants. Inasmuch, it can be very important to watching for side effects, antiviral masks avoid alcohol and not operate heavy machinery. Side effects can include dizziness and drowsiness.

  7. This potent terpene profile leads to an exceptional heady buzz that squints the eyes and weighs on the body. Enjoy Medical 49s 1:1 THC/CBD ratio for alleviating anxiety, inflammation, and pain

  8. I am curious to find out what blog system you’re utilizing? I’m having some minor security issues with my latest site and I’d like to find something more secure. Do you have any recommendations? 먹튀검증

  9. I like this web blog very much so much excellent information. 청주출장안마
    Hello! I’ve been reading your web site for a while now and finally got the courage to go ahead and give you a shout out from Kingwood Texas! Just wanted to say keep up the good work! 슬롯나라

  10. “Cold Case” is definitely one of the best detective tv shows that you can watch on TV. the story is great“ 먹튀폴리스

  11. I really treasure your work , Great post. 안전놀이터