sccgov/medical-examinercoroner-child-deaths-dataset-mxey-xyf9
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 1 month ago

Medical Examiner-Coroner, Child Deaths 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-child-deaths-dataset-mxey-xyf9\".\"medical_examinercoroner_child_deaths_dataset\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • medical_examinercoroner_child_deaths_dataset