Readme
Updated 4 months ago
‧ Indexed 3 hours ago
Emergency Department (ED) Visits for Drug Overdose Identified Through Syndromic Surveillance SFY Quarter 3 2016 - Current Quarterly County Health
Based on Emergency Department (ED) Visits view quarterly trends in overdose rates for Any Drug Overdoses, Any Opioid Overdoses and Heroin Overdoses at the state and county level. Please see Overdose Data Technical Notes for additional details: http://www.health.pa.gov/Your-Department-of-Health/Offices%20and%20Bureaus/PaPrescriptionDrugMonitoringProgram/Documents/OverdoseDataTechnicalNotes.pdf
Syndromic surveillance is the analysis of medical data to detect or anticipate disease outbreaks. According to a CDC definition, "the term 'syndromic surveillance' applies to surveillance using health-related data that precede diagnosis and signal a sufficient probability of a case or an outbreak to warrant further public health response.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| County Code Text | county_code_text | county_code_text | Text | There are 67 counties in Pennsylvania. They are number 01 through 67 in alphabetical order; 00 identifies the statewides totals. This column has the codes formatted as text fields to integrate with other files where county codes are used in place of names and for easier coding within certain software |
| Gender | gender | gender | Text | Gender associated with the reported value |
| Georeferenced Latitude & Longitude | georeferenced_latitude_longitude | georeferenced_latitude_longitude | Point | This is a georeferenced point within each county to help with creating visualizations such as maps. |
| Municipality Boundary 2 | :@computed_region_amqz_jbr4 | :@computed_region_amqz_jbr4 | Number | This column was automatically created in order to record in what polygon from the dataset 'Municipality Boundary' (amqz-jbr4) the point in column 'georeferenced_latitude_longitude' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. |
| Pa School Districts (2017) 2 | :@computed_region_rayf_jjgk | :@computed_region_rayf_jjgk | Number | This column was automatically created in order to record in what polygon from the dataset 'Pa School Districts (2017)' (rayf-jjgk) the point in column 'georeferenced_latitude_longitude' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. |
| Pa House Districts (2017-01) 2 | :@computed_region_r6rf_p9et | :@computed_region_r6rf_p9et | Number | This column was automatically created in order to record in what polygon from the dataset 'Pa House Districts (2017-01)' (r6rf-p9et) the point in column 'georeferenced_latitude_longitude' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. |
| Pa Senatorial Districts (2017-01) 2 | :@computed_region_d3gw_znnf | :@computed_region_d3gw_znnf | Number | This column was automatically created in order to record in what polygon from the dataset 'Pa Senatorial Districts (2017-01)' (d3gw-znnf) the point in column 'georeferenced_latitude_longitude' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. |
| Pennsylvania County Boundaries 2 | :@computed_region_nmsq_hqvv | :@computed_region_nmsq_hqvv | Number | This column was automatically created in order to record in what polygon from the dataset 'Pennsylvania County Boundaries' (nmsq-hqvv) the point in column 'georeferenced_latitude_longitude' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. |
| PA County Boundaries Spatial Data Current Transportation | :@computed_region_4fjn_fq7k | :@computed_region_4fjn_fq7k | Number | |
| Age Group | age_group | age_group | Text | Range of ages associated with the reported value |
| Race Group | race_group | race_group | Text | ED visits by race at the state and county levels |
| County Name | county_name | county_name | Text | Pennsylvania County name; includes PENNSYLVANIA for the statewide rates. There are 67 counties. |
| Rate | rate | rate | Number | Calculated rate for each county; includes PENNSYLVANIA for the statewide rates - Type of Rate Column provides additional details. If the rate is null, please refer to the Type of Rate for description. The nulls could mean any of the following: Not Found, Unknown Not Applicable Not displayed (due to count between 1 and 4) |
| Type of Rate | type_of_rate | type_of_rate | Text | Identifies the type of rate calculated* Rate of Emergency Department Visits Related to Overdose per 1000 Population - calculated using quarterly counts as numerators and county populations as denominators and are based on the location of the patient’s residence Percent of Emergency Department Visits Related to Overdose - calculated using quarterly counts as numerators and total ED visits for any cause as denominators and are based on the location of the facility |
| Overdose Type | overdose_type | overdose_type | Text | Identifies the type of overdose Any Drug Overdose - includes overdoses of any substance, including alcohol, over the counter, prescription and illicit drugs Any Opioid Overdose - includes overdoses of any opioid substance, including prescription and illicit opiates, such as heroin and illicitly manufactured fentanyl Heroin Overdose - includes overdoses where the chief complaint or medical notes indicate suspicion of heroin or diagnosis codes indicating heroin as the cause of the overdose; fentanyl may or may not be present depending on the type of testing performed at the facility. (please see technical notes here for more details: http://www.health.pa.gov/Your-Department of Health/Offices%20and%20Bureaus/PaPrescriptionDrugMonitoringProgram/Documents/OverdoseDataTechnicalNotes.pdf) |
| Time Measure | time_measure | time_measure | Text | Time frame the rate is based on |
| Year | year | year | Number | Year the rate is based on |
| Time Period | time_period | time_period | Text | Time frame the rate is based on in the format of Year and Calendar Quarter (YYYY QQ) |
| Quarter Date Start | quarter_date_start | quarter_date_start | Calendar date | Start date for the Quarter for which the data is being reported |
| Notes | notes | notes | Text | Provides information on limitations (please see technical notes for more details here: http://www.health.pa.gov/Your-Department-of-Health/Offices%20and%20Bureaus/PaPrescriptionDrugMonitoringProgram/Documents/OverdoseDataTechnicalNotes.pdf) |
| County Code Number | county_code_number | county_code_number | Number | There are 67 counties in Pennsylvania. They are number 01 through 67 in alphabetical order; 00 identifies the statewides totals. |
| State FIPS Code | state_fips_code | state_fips_code | Text | These are the 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. For more technical details : Federal Information Processing Standards Publications (FIPS PUBS) are issued by the National Institute of Standards and Technology (NIST) after approval by the Secretary of Commerce pursuant to Section 111 (d) of the Federal Property and Administrative Services Act of 1949 as amended by the Computer Security Act of 1987, Public Law 100-235. Federal Information Processing Standard (FIPS) 6-4, Counties and Equivalent Entities of the U.S., Its Possessions, and Associated Areas -- 90 Aug 31 , provides the names and codes that represent the counties and other entities treated as equivalent legal and/or statistical subdivisions of the 50 States, the District of Columbia, and the possessions and freely associated areas of the United States. Counties are considered to be the "first-order subdivisions" of each State and statistically equivalent entity, regardless of their local designations (county, parish, borough, etc.). Information gathered from census data - https://www.census.gov/geo/reference/codes/cou.html |
| County FIPS Code | county_fips_code | county_fips_code | Text | The FIPS county code is a five-digit Federal Information Processing Standard (FIPS) code (FIPS 6-4) which uniquely identifies counties and county equivalents in the United States, certain U.S. possessions, and certain freely associated states. This is the 3-digit part of the 5-digit county FIPS code specifically standing for the county. |
| Latitude | latitude_longitude | latitude_longitude | Number | This is a chosen generic latitude point within each county to help with creating visualizations such as maps. |
| Longitude | longitude | longitude | Number | This is a chosen generic longitude point within each county to help with creating visualizations such as maps. |
Upstream Metadata