mydata-iowa-gov/iowa-child-welfare-assessments-by-disposition-er5e-kmgq
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 7 months ago
Indexed 1 month ago

Iowa Child Welfare Assessments by Disposition, County and Year

This dataset provides the number and disposition of child welfare assessments conducted by the Department of Human Services beginning January 1, 2004.

On January 1, 2014, the department began using the Differential Response System, which allows for a family assessment in additional to a traditional child abuse investigation for allegations of abuse and neglect. Data prior to 2014 only report child abuse investigations.

The family assessment is not used in physical or sexual abuse cases, or other types of serious abuse cases seen. It is used only in denial of critical care cases where the child is not in imminent danger. If at any time during a family assessment it appears the child isn’t safe, the case is reassigned to the child abuse assessment pathway.

The family assessment pathway results in pairing families with services and supports. The traditional child abuse assessments result in a finding. Findings include: “founded” meaning abuse occurred and results in perpetrator placement on the child abuse registry; “confirmed” meaning abuse occurred, but it was minor, isolated and not likely to reoccur, does not go on the central abuse registry; and “unconfirmed” meaning abuse did not occur.

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-welfare-assessments-by-disposition-er5e-kmgq\".\"iowa_child_welfare_assessments_by_disposition\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • iowa_child_welfare_assessments_by_disposition
     
     
     
     
     
Upstream Metadata