Estimated Lost Wages Due to Hospitalizations for Opioid Use CY 2016 - Current Quarterly County Health Care Cost Containment Council (PHC4) United States Department of Labor

This indicator includes the number of days hospitalized for opioid use and the estimated lost wages due to hospitalization (PHC4 Data). This value is the product of the number of days hospitalized and the average weekly wages for county of residence—as reported by the Bureau of Labor Statistics—divided by seven.

PHC4’s database contains statewide hospital discharge data submitted to PHC4 by Pennsylvania hospitals. Every reasonable effort has been made to ensure the accuracy of the information obtained from the Uniform Claims and Billing Form (UB-82/92/04) data elements. Computer collection edits and validation edits provide opportunity to correct specific errors that may have occurred prior to, during or after submission of data. The ultimate responsibility for data accuracy lies with individual providers.

Analyses were completed by the University of Pittsburgh using data from the PA Health Care Cost Containment Council and in cooperation with PA DOH.

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 \"pa-gov/estimated-lost-wages-due-to-hospitalizations-for-w7cq-ufkw\".\"estimated_lost_wages_due_to_hospitalizations_for\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.