Medical Examiner-Coroner, Full dataset
Note:
This Dataset is updated nightly and contains all downloadable Medical Examiner-Coroner records, January 1, 2018 to current, related to deaths that occurred in the County of Santa Clara under the Medical Examiner-Coroner’s jurisdiction and those deaths reportable to the Medical Examiner-Coroner (non-jurisdictional cases/NJA) but in which the office did not assume jurisdiction.
The Santa Clara County Medical Examiner- Coroner’s Office determines cause and manner of death for those deaths that fall under the jurisdiction of the Medical Examiner-Coroner, as defined by California Government code 27491.
The Medical Examiner-Coroner will not be responsible for data verification, interpretation or misinformation once data has been downloaded and manipulated from the dashboard.
Refer to the following document to know more of which deaths are reportable:
https://medicalexaminer.sccgov.org/sites/g/files/exjcpb986/files/Reportable%20Death%20Chart%202018.pdf.
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 \"sccgov/medical-examinercoroner-full-dataset-s3fb-yrjp\".\"medical_examinercoroner_full_dataset\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.