health-data-ny-gov/all-payer-patient-safety-indicators-psi-area-ya2g-i2gu
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 6 years ago
Indexed 2 hours ago

All Payer Patient Safety Indicators (PSI) Area Measures by Patient County: Calendar Year 2015

The datasets contain hospital discharges counts (numerators, denominators, volume counts), observed, expected and risk-adjusted rates with corresponding 95% confidence intervals for Patient Safety Indicators generated using methodology developed by Agency for Healthcare Research and Quality (AHRQ).

The PSIs are a set of indicators providing information on potential in hospital complications and adverse events following surgeries, procedures, and childbirth. The PSIs were developed by AHRQ after a comprehensive literature review, analysis of ICD-9-CM codes, review by a clinician panel, implementation of risk adjustment, and empirical analyses.

All PSI measures were calculated using Statewide Planning and Research Cooperative System (SPARCS) inpatient data beginning 2009. US Census data files provided by AHRQ were used to derive denominators for county level (area level) PSI measures.

The mortality, volume and utilization measures PSIs are presented by hospital as rates or counts. Area-level measures are presented by county as rates.

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 \"health-data-ny-gov/all-payer-patient-safety-indicators-psi-area-ya2g-i2gu\".\"all_payer_patient_safety_indicators_psi_area\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • all_payer_patient_safety_indicators_psi_area
     
     
     
     
     
Upstream Metadata