Maternal Sepsis by County and Demographics, SPARCS: 2016-2018

The dataset contains administratively identified maternal sepsis observed event counts and rates related to live births during the pregnancy, delivery, and postpartum windows by patient county and demographics between 2016 and 2018.

Maternal sepsis is a leading cause of maternal mortality in the United States and is associated with increased rates of preterm labor, preterm delivery and fetal infection and maternal chronic pain and fertility problems.

Live births were identified from administrative coding of SPARCS acute care hospital claims between January 1, 2016 and December 31, 2018. Sepsis events were identified from SPARCS claims linked to these live birth events through a maternal identifier and occurring during pregnancy, delivery or within 42 days postpartum. Counts and rates are calculated within each of these thee windows separately, and also combined.

Sepsis events are quantified for ‘All Sepsis’ and ‘Severe Sepsis/Septic Shock’ (a subset of ‘All Sepsis’).

Counts and observed rates are presented by the patient county of residence reported on the live birth claim (including a statewide total) and select maternal demographics.

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/maternal-sepsis-by-county-and-demographics-sparcs-f7ik-e57z\".\"maternal_sepsis_by_county_and_demographics_sparcs\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.