pa-gov/estimated-accidental-and-undetermined-drug-jkby-9mqm
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 2 months ago
Indexed 10 days ago

Estimated Accidental and Undetermined Drug Overdose Deaths with Demographics CY 2012-Current Statewide Health

View annual counts of Accidental or Undetermined overdose deaths for 2012 forward, including provisional estimates of annual counts of overdose deaths for recent years, as noted with an asterisk and the month the data was pulled.<br> NOTE: Finalized death records for overdose deaths are often delayed by 3-6 months. Counties labeled “no value” have data suppressed because the counts are between 1 and 9.<br>

  • Overdose Deaths are classified using the International Classification of Diseases, Tenth Revision (ICD–10). Drug-poisoning deaths are identified using underlying cause-of-death codes X40–X44, and Y10–Y14, and include the following: <br>

  • R99 when the Injury Description indicates an overdose death.<br>

  • X49 when literal COD is Mixed or Combined or Multiple Substance Toxicity, as these are likely drug overdoses<br>

  • X47 when substance indicated is difluoroethane, alone or in combination with other drugs<BR>

  • Source Pennsylvania Prescription Drug Monitoring Program*<br>

    • These data were supplied by the Bureau of Health Statistics and Registries, Harrisburg, Pennsylvania. The Bureau of Health Statistics and Registries specifically disclaims responsibility for any analyses, interpretations or conclusions.<br>
  • Estimates are broken down by type of drugs involved in the overdose <br>

  • Any Drug Overdose Death - all drug overdose deaths, regardless of type of drug involved, excluding alcohol only deaths<br>

  • Opioid Overdose Death - any overdose death involving opioids, prescription or illegal

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"pa-gov/estimated-accidental-and-undetermined-drug-jkby-9mqm\".\"estimated_accidental_and_undetermined_drug\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • estimated_accidental_and_undetermined_drug
     
     
     
     
     
Upstream Metadata