State SIR for surgical site infections (SSI) associated with knee prosthesis (KPRO) in hospitals, New Jersey, by year: Beginning 2010

Ratio: Total number of "observed" or actual infections (Standardized infection ratio)

Definition: Infections that are acquired in a health care setting, as measured by a standardized infection ratio (SIR), resulting from knee prosthesis surgery.

Data Sources: New Jersey Healthcare-Associated Infections submitted through the National Healthcare Safety Network (NHSN)

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 \"healthdata-nj-gov/state-sir-for-surgical-site-infections-ssi-tyvv-6a4t\".\"state_sir_for_surgical_site_infections_ssi\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.