pa-gov/emergency-department-ed-visits-for-drug-overdose-svnp-capx
Icon for Socrata external plugin
 
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

NameSocrata field nameColumn name in sgr mountData typeDescription
County Code Textcounty_code_textcounty_code_textTextThere 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
GendergendergenderTextGender associated with the reported value
Georeferenced Latitude & Longitudegeoreferenced_latitude_longitudegeoreferenced_latitude_longitudePointThis 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_jbr4NumberThis 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_jjgkNumberThis 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_p9etNumberThis 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_znnfNumberThis 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_hqvvNumberThis 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_fq7kNumber
Age Groupage_groupage_groupTextRange of ages associated with the reported value
Race Grouprace_grouprace_groupTextED visits by race at the state and county levels
County Namecounty_namecounty_nameTextPennsylvania County name; includes PENNSYLVANIA for the statewide rates. There are 67 counties.
RateraterateNumberCalculated 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 Ratetype_of_ratetype_of_rateTextIdentifies 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 Typeoverdose_typeoverdose_typeTextIdentifies 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 Measuretime_measuretime_measureTextTime frame the rate is based on
YearyearyearNumberYear the rate is based on
Time Periodtime_periodtime_periodTextTime frame the rate is based on in the format of Year and Calendar Quarter (YYYY QQ)
Quarter Date Startquarter_date_startquarter_date_startCalendar dateStart date for the Quarter for which the data is being reported
NotesnotesnotesTextProvides 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 Numbercounty_code_numbercounty_code_numberNumberThere are 67 counties in Pennsylvania. They are number 01 through 67 in alphabetical order; 00 identifies the statewides totals.
State FIPS Codestate_fips_codestate_fips_codeTextThese 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 Codecounty_fips_codecounty_fips_codeTextThe 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.
Latitudelatitude_longitudelatitude_longitudeNumberThis is a chosen generic latitude point within each county to help with creating visualizations such as maps.
LongitudelongitudelongitudeNumberThis is a chosen generic longitude point within each county to help with creating visualizations such as maps.
 
Preview
  • emergency_department_ed_visits_for_drug_overdose
     
Upstream Metadata