pa-gov/estimated-total-lost-wages-due-to-opioid-use-cy-xzsj-mqqr
Icon for Socrata external plugin
 
Readme
Updated 7 months ago
Indexed 5 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

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
LatitudelatitudelatitudeNumber
Georeferenced Latitude & Longitudegeocoded_columngeocoded_columnPointGeoreferenced column as a point used for creating visuals such as maps. A generic point for reach county is supplied so a map can be created.
Latitude/Longitudelatitude_longitudelatitude_longitudeTextLatitude and longitude coordinates in degrees for a centroid point for geographic area.
County FIPS Codecounty_fips_codecounty_fips_codeTextLast 3 digits of the 5-digit Federal Information Processing Standard (FIPS) code that designate the county association. Each state has its own 2-digit number and each county within the state has its own 3-digit number which are combined into a 5-digit number to uniquely identify every US county.
County Code Textcounty_code_textcounty_code_textTextPennsylvania county code provided as text (1-67 for counties sorted alphabetically, 0 for Commonwealth).
Estimated Lost State Income Tax Revenueestimated_lost_state_income_taxestimated_lost_state_income_taxNumberEstimated state income tax revenue associated with lost wages due to opioid use; 3.07% of lost wages.
Estimated Lost Wagesestimated_lost_wagesestimated_lost_wagesNumberEstimated wages lost 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.
Drug Use Disorder Estimatedrug_use_disorder_estimatedrug_use_disorder_estimateNumberEstimated number of individuals with drug use disorder.
AgeageageTextAges of individuals hospitalized (21 to 64 years).
GendergendergenderTextGender of individuals hospitalized.
LongitudelongitudelongitudeNumber
County Code Numbercounty_code_numbercounty_code_numberNumberPennsylvania county code provided as a number (1-67 for counties, 0 for Commonwealth).
Estimated Lost State Income Tax Revenue Descriptionestimated_lost_state_income_tax_descriptionestimated_lost_state_income_tax_descriptionTextDescription of estimated lost state income tax revenue.
Drug Use Disorder Estimate Notesdrug_use_disorder_estimate_notesdrug_use_disorder_estimate_notesTextIndicates if the estimated number of individuals with drug use disorder has been suppressed to protect confidentiality. Counts less than 11 are not provided.
Time Period Datestime_period_datestime_period_datesTextStart and end dates of time period.
Time Periodtime_periodtime_periodTextPeriod of measurement (annual, federal fiscal year, or quarterly if available).
YearyearyearTextCalendar year of measurement (January 1–December 31).
Geographic Namegeographic_namegeographic_nameTextName of geographic area.
Geographic Areageographic_areageographic_areaTextRegion measured, either total for Commonwealth or county.
Pennsylvania County Boundaries:@computed_region_nmsq_hqvv:@computed_region_nmsq_hqvvNumber
Pa Senatorial Districts (2017-01):@computed_region_d3gw_znnf:@computed_region_d3gw_znnfNumber
Pa School Districts (2017):@computed_region_rayf_jjgk:@computed_region_rayf_jjgkNumber
Pa House Districts (2017-01):@computed_region_r6rf_p9et:@computed_region_r6rf_p9etNumber
Municipality Boundary:@computed_region_amqz_jbr4:@computed_region_amqz_jbr4Number
State FIPS Codestate_fips_codestate_fips_codeTextFirst 2 digits of the 5-digit Federal Information Processing Standard (FIPS) code that designate the state association. Each state has its own 2-digit number and each county within the state has its own 3-digit number which are combined into a 5-digit number to uniquely identify every US county.
Estimated Lost Wages Descriptionestimated_lost_wages_descriptionestimated_lost_wages_descriptionTextDescription of estimated lost wages.
Drug Use Disorder Descriptiondrug_use_disorder_descriptiondrug_use_disorder_descriptionTextDescribes number of estimated individuals with drug use disorder.
 
Preview
  • estimated_total_lost_wages_due_to_opioid_use_cy
     
Upstream Metadata