pa-gov/estimated-total-lost-wages-due-to-opioid-use-cy-xzsj-mqqr
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 10 months ago
Indexed 2 hours ago

Estimated Total Lost Wages Due to Opioid Use CY 2016-2017 County Annual US Department of Health and Human Services, US Department of Labor

This indicator includes the estimated total lost wages related to opioid use and the associated lost tax revenue for the state. Estimated lost wages are due to absenteeism, reduced productivity, hospitalization, unemployment and labor force exits due to opioid use. This value is the product of the estimated number of individuals with drug use disorder, the average weekly wages for county of residence—as reported by the Bureau of Labor Statistics—multiplied by 52 to represent annual wages, and a 17% reduction in productivity.

The 17% reduction in productivity is from the following report: https://www.justice.gov/archive/ndic/pubs44/44731/44731p.pdf

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-total-lost-wages-due-to-opioid-use-cy-xzsj-mqqr\".\"estimated_total_lost_wages_due_to_opioid_use_cy\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • estimated_total_lost_wages_due_to_opioid_use_cy
     
     
     
     
     
Upstream Metadata