pa-gov/estimated-lost-lifetime-wages-due-to-premature-8rwb-e4pv
Icon for Socrata external plugin
 
Readme
Updated 7 months ago
Indexed 4 hours ago

Estimated Lost Lifetime Wages Due to Premature Opioid-Related Mortality CY 2016 - 2017 County Annual Centers for Disease Control and Prevention (CDC) United States Department of Labor

This indicator includes the estimated lifetime wages lost due to premature opioid-related mortality. This value is the sum of the product of the number of years of life lost due to premature opioid-related mortality and the average quarterly wages for county of residence—as reported by the Bureau of Labor Statistics—adjusted for inflation and then discounted.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Latitude/Longitudelatitude_longitudelatitude_longitudeTextLatitude and longitude coordinates in degrees for a centroid point for geographic area.
Estimated Lost Lifetime State Income Tax Revenuelost_tax_revenuelost_tax_revenueNumberEstimated state income tax revenue associated with estimated lost lifetime wages; 3.07% of lost wages.
Time Periodtime_periodtime_periodTextPeriod of measurement (annual, federal fiscal year, or quarterly if available).
Geographic Namegeographic_namegeographic_nameTextName of geographic area.
LongitudelongitudelongitudeNumber
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.
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 Numbercounty_code_numbercounty_code_numberNumberPennsylvania county code provided as a number (1-67 for counties, 0 for Commonwealth).
Estimated Lost Lifetime State Income Tax Revenue Descriptionlost_tax_revenue_descriptionlost_tax_revenue_descriptionTextDescription of estimated lost lifetime state income tax revenue.
Estimated Lost Lifetime Wages Descriptionestimated_lost_lifetime_wages_1estimated_lost_lifetime_wages_1TextDescription of estimated lost lifetime wages.
Estimated Lost Lifetime Wagesestimated_lost_lifetime_wagesestimated_lost_lifetime_wagesNumberEstimated lifetime wages lost due to premature opioid-related mortality. This value is the sum of the product of the number of years of life lost due to premature opioid-related mortality and the average quarterly wages for county of residence—as reported by the Bureau of Labor Statistics—adjusted for inflation and then discounted.
County Code Textcounty_code_textcounty_code_textTextPennsylvania county code provided as text (1-67 for counties sorted alphabetically, 0 for Commonwealth).
Time Period Datestime_period_datestime_period_datesTextStart and end dates of time period.
YearyearyearTextCalendar year of measurement (January 1–December 31).
AgeageageTextAges of individuals (0 to 64 years).
Geographic Areageographic_areageographic_areaTextRegion measured, either total for Commonwealth or county.
Pa Senatorial Districts (2017-01):@computed_region_d3gw_znnf:@computed_region_d3gw_znnfNumber
Municipality Boundary:@computed_region_amqz_jbr4:@computed_region_amqz_jbr4Number
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
Pennsylvania County Boundaries:@computed_region_nmsq_hqvv:@computed_region_nmsq_hqvvNumber
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.
GendergendergenderTextGender of individuals.
 
Preview
  • estimated_lost_lifetime_wages_due_to_premature
     
Upstream Metadata