Hospital Charges to Medicare for Inpatient Services Utah 2013

The data set includes hospital-specific charges for Utah 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. 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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"opendata-utah-gov/hospital-charges-to-medicare-for-inpatient-ah6w-ica8\".\"hospital_charges_to_medicare_for_inpatient\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.