CPI 3.9 Abuse/Neglect Investigations and Alternative Response: Alleged and Confirmed Victim Recidivism FY2014-FY2023

Recidivism is calculated as a percentage of all alleged victims and child principals in alternative response and investigation stages, who did not receive any ongoing services, who had a subsequent confirmed allegation, or case open for ongoing services within 12 months.

Numerator: Number of children who have a confirmed allegation in an investigation or an open family preservation or substitute care stage within 12 months of a closed investigation or alternative response stage with no ongoing services.

Denominator: Number of alleged and confirmed victims in investigations (excluding admin closures) and alternative response stages closed 12 months prior with no ongoing services.

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 \"texas-gov/cpi-39-abuseneglect-investigations-and-alternative-2h73-cxnv\".\"cpi_39_abuseneglect_investigations_and_alternative\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.