Suicide Related Deaths

This dataset combines historical county-level data from the Community Health Assessment Tool (CHAT) with last year's suicide rate data from the Pierce County Medical Examiners' database (MEDIS). The purpose of this combined dataset is to provide the most up-to-date information on suicide rates in Pierce County with historical data for comparing Pierce County to other neighboring counties.

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 \"internal-open-piercecountywa-gov/suicide-related-deaths-ebwa-34zc\".\"suicide_related_deaths\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.