Iowa Child Abuse Occurrences by Year, County and Type of Abuse
This dataset summarizes occurrences of abuse by type identified during child welfare assessments conducted by DHS with "founded" or "confirmed" findings beginning January 1, 2004. “Founded” means abuse occurred and resulted in perpetrator placement on the child abuse registry. "Confirmed” means abuse occurred, but it was minor, isolated and not likely to reoccur, and perpetrator was not placed on the central abuse registry.
Data is grouped by calendar year, county and type of abuse. For each child included in the assessment, up to 10 types of abuse may be indicated. Each child may be confirmed of multiple types of abuse on a single assessment, and may have multiple assessments.
The county is determined according to the child's county of residence at time of the assessment.
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 \"mydata-iowa-gov/iowa-child-abuse-occurrences-by-year-county-and-mh9d-fias\".\"iowa_child_abuse_occurrences_by_year_county_and\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.