Parsing /home/vanessa/Documents/Dropbox/Code/database/hospital-chargemaster/data/advent-health/latest/central-texas-medical-center-CTMC.xml
---------------------------------------------------------------------------
ExpatError                                Traceback (most recent call last)
<ipython-input-249-5cab8ddfeb7b> in <module>()
     14     if filename.endswith('xml'):
     15         with open(filename, 'r') as filey:
---> 16             content = xmltodict.parse(filey.read())
     17 
     18         if "dataroot" in content:

~/anaconda3/lib/python3.6/site-packages/xmltodict.py in parse(xml_input, encoding, expat, process_namespaces, namespace_separator, disable_entities, **kwargs)
    328         parser.ParseFile(xml_input)
    329     else:
--> 330         parser.Parse(xml_input, True)
    331     return handler.item
    332 

ExpatError: no element found: line 1, column 0

Skipping for now, could be related to xmltodict or the file itself.

I was unable to (quickly) find the chargelist here :/

Perhaps someone can give it a look?

Some of these have embedded frames, or "click to confirm you aren't a robot" or use the price index that blocks ip address, etc. I was unable to parse these hospitals. I don't think this is in compliance with what the CDC mandated, but not much to do about that.

• barnes-jewish-hospital
• cleveland-clinic-hospital
• florida-hospital
• loma-linda-university-medical-center
• massachusetts-general-hospital
• memorial-hermann-texas-medical-center
• memorial-hospital-for-cancer-and-allied-diseases
• new-york-university-hospitals-center
• norton-hospitals-inc.
• robert-wood-johnson-university-hospital
• st.-francis-medical-center
• university-of-alabama-hospital
• university-of-chicago-hospitals
• university-of-kansas-hospitals
• university-of-oklahoma-medical-center

This is scraped from a search from the hospital price index, and my address was denied after a few pages - need to look into more.

Interesting project! I'm looking at the OSHPD CA data. The records appear to list 354 distinct hospital_id values, but there are only 130 in the combined TSVs of the latest data (data-latest-1.tsv and data-latest-2.tsv).

I'll look into the parser and submit PRs if I find anything, but do you have any thoughts?

Nothing comes up when I search for https://www.google.com/search?q=Dartmouth+Hitchcock+prices+CMS-1694-F&oq=Dartmouth+Hitchcock+prices+CMS-1694-F
Any advice? Or is there a central location where all hospitals have to register availability?

likely didn't download correctly.

Options include:

• inpatient
• outpatient
• drg (diagnostic related groups)
• average

University of Oklahoma

The hospital had a server error when I tried to access it.