pa-gov/emergency-department-ed-visits-for-overdose-vvvs-z9dr
 
Readme
Updated over 1 year ago
Indexed 3 hours ago

Emergency Department (ED) Visits for Overdose Identified Through Syndromic Surveillance Quarter 3 2016 - Current Quarterly County Health

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: : https://www.health.pa.gov/topics/programs/PDMP/Pages/Data.aspx

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
County Code Numbercounty_code_numbercounty_code_numberNumberDatatype is a number. Numbers represent the counties in Pennsylvania. 0 - represents the total for the Commonwealth of Pennsylvania. Pennsylvania as 67 counties. 1 - 67.
Pennsylvania County Boundaries:@computed_region_nmsq_hqvv:@computed_region_nmsq_hqvvNumber
Pa Senatorial Districts (2017-01):@computed_region_d3gw_znnf:@computed_region_d3gw_znnfNumber
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
Municipality Boundary:@computed_region_amqz_jbr4:@computed_region_amqz_jbr4Number
YearyearyearTextYear the rate is based on
Time Periodtime_periodtime_periodTextTime frame for calculated rate in the format of Year and Calendar Quarter for that year (YYYY QQ)
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.
County NamecountycountyTextThis is the Pennsylvania County Name and includes Pennsylvania as an option
Quarterly RateraterateNumberCalculated rate for each county; includes PENNSYLVANIA for the statewide rates - Type of Rate and Notes Column provides additional details. Blank field indicates data was suppressed due to count between 1 and 4. The following counties have blank fields in the Percent of Emergency Department Visits Related to Overdose due to there being No ED in the County: Cameron, Forest, Juniata, Perry, Pike, Snyder, Sullivan
Time Measuretime_measuretime_measureTextTime frame rate is based on
County Code Textcounty_codecounty_codeTextTwo-digit code for the Pennsylvania County. Text field so the leading zeros show to match other files. Pennsylvania as 67 counties. 01 - 67.
Latitudelocation_1location_1TextThis includes a generic point of Latitude for each county and a generic point for the state of PA to help with creating visuals such as maps. If the statewide total for PA should be shown on the map, this latitude provides the means to show the statewide total at the SE part of PA actually in Maryland, so that the statewide total can be shown on on the map without adding to the total within another county.
LongitudelongitudelongitudeTextThis includes a generic point of Longitude for each county and a generic point for the state of PA to help with creating visuals such as maps. If the statewide total for PA should be shown on the map, this longitude provides the means to show the statewide total at the SE part of PA actually in Maryland, so that the statewide total can be shown on on the map without adding to the total within another county.
Overdose TypeclassclassTextIdentifies the type of overdose = Any Drug Overdose - includes overdose 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 techincal notes here for more details: http://www.health.pa.gov/Your-Department-of-Health/Offices%20and%20Bureaus/PaPrescriptionDrugMonitoringProgram/Documents/OverdoseDataTechnicalNotes.pdf)
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
Type of Ratetype_of_ratetype_of_rateTextIdentifies the type of rate calculated* Rate of ED Visits per 10,000 Population (by patient location) - calculated using quarterly counts as numerators and county populations as denominators and are based on the location of the patient’s residence Rate of ED Visits per 10,000 Visits (by facility location) - calculated using quarterly counts as numerators and total ED visits for any cause as denominators and are based on the location of the facility
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)
Georeferenced Latitude & Longitudegeocoded_columngeocoded_columnPointThis includes a generic georeferenced point of Latitude and Longitude for each county and a generic point for the state of PA to help with creating visuals such as maps. If the statewide total for PA should be shown on the map, this centroid provides the means to show the statewide total at the SE part of PA actually in Maryland, so that the statewide total can be shown on on the map without adding to the total within another county.
Upstream Metadata