2009 VHA Facility Quality and Safety Report - Hospital Settings

<p>The 2008 Hospital Report Card was mandated by the FY08 Appropriations Act, and focused on Congressionally-mandated metrics applicable to general patient populations. The 2009 VHA Facility Quality and Safety Report report, not required by Congress, shifts to Veteran-centered metrics, and includes information related to infrastructure, care provided in outpatient and hospital settings, quality of care within given patient populations, accreditation status, patient satisfaction and patient outcomes for FY2008. The data in this report have been compiled from multiple sources throughout VHA. This dataset includes adjusted mortality rate for three defined populations: Pneumonia, Congestive Heart Failure, and Acute Myocardial Infarction, Nosocomisal Infections, Percent of patients on prophalaxis for deep vein thrombosis and Observed minus expected length of stay.</p>

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 \"datahub-va-gov/2009-vha-facility-quality-and-safety-report-7n8t-uiin\".\"2009_vha_facility_quality_and_safety_report\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.