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.
|Name||Socrata field name||Column name in ||Data type||Description|
|Pennsylvania County Boundaries||:@computed_region_nmsq_hqvv||:@computed_region_nmsq_hqvv||Number|
|County Code Number||county_code_number||county_code_number||Number||Pennsylvania county code provided as a number (1-67 for counties, 0 for Commonwealth).|
|County Code Text||county_code_text||county_code_text||Text||Pennsylvania county code provided as text (1-67 for counties sorted alphabetically, 0 for Commonwealth).|
|State FIPS Code||state_fips_code||state_fips_code||Text||First 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 Code||county_fips_code||county_fips_code||Text||Last 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/Longitude||latitude_longitude||latitude_longitude||Text||Latitude and longitude coordinates in degrees for a centroid point for geographic area.|
|Georeferenced Latitude & Longitude||geocoded_column||geocoded_column||Point||Georeferenced 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.|
|Latitude||latitude||latitude||Number||Latitude coordinates in degrees for a centroid point for geographic area.|
|Longitude||longitude||longitude||Number||Longitude coordinates in degrees for a centroid point for geographic area.|
|Pa House Districts (2017-01)||:@computed_region_r6rf_p9et||:@computed_region_r6rf_p9et||Number|
|Pa School Districts (2017)||:@computed_region_rayf_jjgk||:@computed_region_rayf_jjgk||Number|
|Pa Senatorial Districts (2017-01)||:@computed_region_d3gw_znnf||:@computed_region_d3gw_znnf||Number|
|Geographic Area||geographic_area||geographic_area||Text||Region measured, either total for Commonwealth or county.|
|Geographic Name||geographic_name||geographic_name||Text||Name of geographic area.|
|Gender||gender||gender||Text||Gender of individuals hospitalized.|
|Age||age||age||Text||Ages of individuals hospitalized (21 to 64 years).|
|Year||year||year||Text||Calendar year of measurement (January 1–December 31).|
|Time Period||time_period||time_period||Text||Period of measurement (annual, federal fiscal year, or quarterly if available).|
|Time Period Dates||time_period_dates||time_period_dates||Text||Start and end dates of time period.|
|Number of Days Hospitalized||number_of_days_hospitalized||number_of_days_hospitalized||Number||Total 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 Description||number_of_days_hospitalized_1||number_of_days_hospitalized_1||Text||Description of number of days hospitalized.|
|Number of Days Hospitalized Notes||number_of_days_hospitalized_notes||number_of_days_hospitalized_notes||Text||Describes suppression criteria for protecting confidentiality. Counts less than 11 are not provided.|
|Estimated Lost Wages||estimated_lost_wages||estimated_lost_wages||Number||Estimated 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 Description||estimated_lost_wages_desc||estimated_lost_wages_desc||Text||Description of estimated lost wages.|
|Estimated Lost State Income Tax Revenue||estimated_lost_state_income_tax||estimated_lost_state_income_tax||Number||Estimated state income tax revenue associated with lost wages while hospitalized; 3.07% of lost wages.|
|Estimated Lost State Income Tax Revenue Description||estimated_lost_state_income_tax_desc||estimated_lost_state_income_tax_desc||Text||Description of estimated lost state income tax revenue.|