pa-gov/estimated-lost-wages-due-to-hospitalizations-for-w7cq-ufkw

  • disorder
  • doh
  • drug
  • economy
  • health
  • + 6

Estimated Lost Wages Due to Hospitalizations for Opioid Use CY 2016 - Current Quarterly County Health Care Cost Containment Council (PHC4) United States De...

Estimated Lost Wages Due to Hospitalizations for Opioid Use CY 2016 - Current Quarterly County Health Care Cost Containment Council (PHC4) United States Department of Labor

This indicator includes the number of days hospitalized for opioid use and the estimated lost wages due to hospitalization (PHC4 Data). This value is the product of the number of days hospitalized and the average weekly wages for county of residence—as reported by the Bureau of Labor Statistics—divided by seven.

PHC4’s database contains statewide hospital discharge data submitted to PHC4 by Pennsylvania hospitals. Every reasonable effort has been made to ensure the accuracy of the information obtained from the Uniform Claims and Billing Form (UB-82/92/04) data elements. Computer collection edits and validation edits provide opportunity to correct specific errors that may have occurred prior to, during or after submission of data. The ultimate responsibility for data accuracy lies with individual providers.

Analyses were completed by the University of Pittsburgh using data from the PA Health Care Cost Containment Council and in cooperation with PA DOH.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Pennsylvania County Boundaries:@computed_region_nmsq_hqvv:@computed_region_nmsq_hqvvNumber
County Code Numbercounty_code_numbercounty_code_numberNumberPennsylvania county code provided as a number (1-67 for counties, 0 for Commonwealth).
County Code Textcounty_code_textcounty_code_textTextPennsylvania county code provided as text (1-67 for counties sorted alphabetically, 0 for Commonwealth).
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.
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.
Latitude/Longitudelatitude_longitudelatitude_longitudeTextLatitude and longitude coordinates in degrees for a centroid point for geographic area.
Georeferenced Latitude & Longitudegeocoded_columngeocoded_columnPointGeoreferenced column as a point used for creating visuals such as maps. A generic point for each county is supplied so a map can be created.
LatitudelatitudelatitudeNumberLatitude coordinates in degrees for a centroid point for geographic area.
LongitudelongitudelongitudeNumberLongitude coordinates in degrees for a centroid point for geographic area.
Municipality Boundary:@computed_region_amqz_jbr4:@computed_region_amqz_jbr4Number
Pa House Districts (2017-01):@computed_region_r6rf_p9et:@computed_region_r6rf_p9etNumber
Pa School Districts (2017):@computed_region_rayf_jjgk:@computed_region_rayf_jjgkNumber
Pa Senatorial Districts (2017-01):@computed_region_d3gw_znnf:@computed_region_d3gw_znnfNumber
Geographic Areageographic_areageographic_areaTextRegion measured, either total for Commonwealth or county.
Geographic Namegeographic_namegeographic_nameTextName of geographic area.
GendergendergenderTextGender of individuals hospitalized.
AgeageageTextAges of individuals hospitalized (21 to 64 years).
YearyearyearTextCalendar year of measurement (January 1–December 31).
Time Periodtime_periodtime_periodTextPeriod of measurement (annual, federal fiscal year, or quarterly if available).
Time Period Datestime_period_datestime_period_datesTextStart and end dates of time period.
Number of Days Hospitalizednumber_of_days_hospitalizednumber_of_days_hospitalizedNumberTotal number of days for which an individual was hospitalized for opioid use. These hospitalizations were identified as hospital stays that included a diagnosis code for opioid use disorder and a classification code for drug abuse and/or dependence or poisoning from drug use. Any hospitalization duration of at least four hours but less than one day counted as one day.
Number of Days Hospitalized Descriptionnumber_of_days_hospitalized_1number_of_days_hospitalized_1TextDescription of number of days hospitalized.
Number of Days Hospitalized Notesnumber_of_days_hospitalized_notesnumber_of_days_hospitalized_notesTextDescribes suppression criteria for protecting confidentiality. Counts less than 11 are not provided.
Estimated Lost Wagesestimated_lost_wagesestimated_lost_wagesNumberEstimated wages lost due to hospitalization for opioid use. This value is the product of the number of days hospitalized and the average weekly wages for county of residence—as reported by the Bureau of Labor Statistics—divided by seven.
Estimated Lost Wages Descriptionestimated_lost_wages_descestimated_lost_wages_descTextDescription of estimated lost wages.
Estimated Lost State Income Tax Revenueestimated_lost_state_income_taxestimated_lost_state_income_taxNumberEstimated state income tax revenue associated with lost wages while hospitalized; 3.07% of lost wages.
Estimated Lost State Income Tax Revenue Descriptionestimated_lost_state_income_tax_descestimated_lost_state_income_tax_descTextDescription of estimated lost state income tax revenue.

Upstream Metadata