This working paper (authors Brill and Ganz) from the American Enterprise Institute provides an estimation of the economic cost of the opioid crisis to each state and each county.
Brill, A., & Ganz, S. (2018). The Geographic Variation in the Cost of the Opioid Crisis. Georgia Institute of Technology and American Enterprise Institute, 17.