About this Dataset

Allegheny County Fatal Accidental Overdoses

NOTE: The cumulative Fatal Accidental Overdoses resource (the first table below) has been modified to address a number of issues, including (but not limited to) duplication of many records.

Fatal accidental overdose incidents in Allegheny County, denoting age, gender, race, drugs present, zip code of incident and zip code of residence.

Zip code of incident is where the Office of the Medical Examiner received the body, not necessarily where the overdose occurred.

Data includes closed cases only and the previous calendar year data will be updated monthly until the close of the current calendar year. For example, the 2014 resource will be updated monthly until December 2015.

If you are looking for the old yearly files they have been archived and compressed and are available below as a zip file.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T17:59:01.553532
Tags: _etl, accidental, alcohol, alprazolam, cocaine, codeine, death, drugs, fatal, fentanyl, heroin, od, opiate, opioid, overdose, oxycodone

Tables

Fatal Accidental Overdoses

@usgov.allegheny_county_city_of_pitts_allegheny_county_fatal__e6c6657e.fatal_accidental_overdoses

170.01 kB
7,351 rows
20 columns

CREATE TABLE fatal_accidental_overdoses (
  "n__id" BIGINT  -- Id,
  "death_date_and_time" TIMESTAMP,
  "manner_of_death" VARCHAR,
  "age" DOUBLE,
  "sex" VARCHAR,
  "race" VARCHAR,
  "case_dispo" VARCHAR,
  "combined_od1" VARCHAR,
  "combined_od2" VARCHAR,
  "combined_od3" VARCHAR,
  "combined_od4" VARCHAR,
  "combined_od5" VARCHAR,
  "combined_od6" VARCHAR,
  "combined_od7" VARCHAR,
  "combined_od8" VARCHAR,
  "combined_od9" VARCHAR,
  "combined_od10" VARCHAR,
  "incident_zip" VARCHAR,
  "decedent_zip" VARCHAR,
  "case_year" BIGINT
);