Inconsistent Data

[Nanda Yadav]

How are we supposed to handle, what seems like wrong/inconsistent data. 

For eg: In the inpatient charges data(csv), there's this row of data: 249 - PERC CARDIOVASC PROC W NON-DRUG-ELUTING STENT W/O MCC,500051,OVERLAKE HOSPITAL MEDICAL CENTER,1035-116TH AVE NE,BELLEVUE,WA,98004,WA - Seattle,23,44499,84499.26087

The last two cols, are Average Covered Charges , Average Total Payments  respectively. So in this case avg covered charges is 44,999 but payments is almost double of that, 84,499.26. how is that possible?

I haven't gone through the whole dataset to test this, just saw this anomaly during some random observation with my visualization. 

[Nanda Yadav]

There are about 500+ such rows/cases in that csv file, where avg payments is higher than charges. 

[Axel]

Thanks Nanda for the question, 

May we have an answer from Heath2.0 team ?

A.

[Hemali Thakkar]

Hi Axel -

I recommend reaching out to CMS directly as they will best be able to answer your questions regarding the data!

You can reach them at: medicareprovi...@cms.hhs.gov

Best,

Hemali

--
You received this message because you are subscribed to the Google Groups "RWJF Hospital Price Transparency Challenge" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rwjf-hospital-price-transpa...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--

Hemali Thakkar

Program Lead & Senior Challenge Manager | Health 2.0

Sign up for The Health 2.0 Weekly

Connect with Health 2.0: tw . fb. in

Join us at the Seventh Annual Fall Conference (Sept. 30 - Oct. 2)!

Check out Health 2.0's Developer Challenges - $1M+ in prizes available!