Iowa Child Abuse Victims by Year, County and Age Group
This dataset provides the number of victims associated with 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 age group. If a child had multiple assessments, age is counted into the age category the child meets at the time the most adverse assessment was reported during the year. The county is also determined according to the child's county of residence for the most adverse 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-victims-by-year-county-and-age-n84y-ufum\".\"iowa_child_abuse_victims_by_year_county_and_age\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
