pa-gov/hospitalization-count-and-rate-of-hospitalization-ns2a-t87x
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated almost 2 years ago
Indexed 3 hours ago

Hospitalization Count and Rate of Hospitalization for Opioid Use Disorder Related Diseases 2016 - Current Quarterly County Pennsylvania Health Care Cost Containment Council (PHC4)

This indicator includes the hospitalization count and rate of hospitalization per 1,000 individuals estimated to have Drug Use Disorder for any of the following reasons: Opioid Use Disorder (OUD), Cellulitis, Osteomyelitis, Endocarditis, Soft skin tissue infection, or Viral Hepatitis (B, C, and D) for individuals diagnosed with OUD in the same calendar year.

Analyses were completed by the University of Pittsburgh using data from the PA Health Care Cost Containment Council and in cooperation with PA DOH.

PHC4’s database contains statewide hospital discharge data submitted to PHC4 by Pennsylvania hospitals. Every reasonable effort has been made to ensure the accuracy of the information obtained from the Uniform Claims and Billing Form (UB-82/92/04) data elements. Computer collection edits and validation edits provide opportunity to correct specific errors that may have occurred prior to, during or after submission of data. The ultimate responsibility for data accuracy lies with individual providers.<br>

<B> NOTE: </B>

This data set measures how many hospitalizations per 1,000 individuals are primarily for conditions related to opioid use. Each of the categories in this data set—Opioid Use Disorder, Intracranial and intraspinal Abscess, Osteomyelitis, Endocarditis, Soft skin tissue infection (Cellulitis), and Viral Hepatitis (B, C, and D)—measure the number of individuals with a primary diagnosis for that condition on their hospitalization record. Each of those records, except for Opioid Use Disorder, must also have at least one secondary diagnosis for Opioid Use Disorder. The full list of ICD-10 codes used to identify these conditions are in the excel spreadsheet listed under attachments below.

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/hospitalization-count-and-rate-of-hospitalization-ns2a-t87x\".\"hospitalization_count_and_rate_of_hospitalization\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • hospitalization_count_and_rate_of_hospitalization
     
     
     
     
     
Upstream Metadata