2009 VHA Facility Quality and Safety Report - Infrastructure

<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 Repor 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 is a compilation of available services within each medical center, whether a medical center is accreditated by Joint commission and/or CARF and details the number of admissions by bed section, admissions per 1000 uniques, and average length of stay by bed sections. Total number of outpatient visits, number of unique patients and the medical center staffing.</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-bwbs-yum6\".\"2009_vha_facility_quality_and_safety_report\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.