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.