Child Protection Dashboard

These data show counts of new cases and children and total cases and children in those cases for Children's Services intake, assessment, and case management by month and with a break out of children by race/ethnicity. Race/ethnicity data are for children only, not cases. Cells for race/ethnicity with a value of less than seven were removed for data privacy. Children of multiple races where at least one race was American Indian were counted as American Indian.

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 \"ramseycounty-us/child-protection-dashboard-syzh-htvh\".\"child_protection_dashboard\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.