CPI 3.11 Child Abuse/Neglect Investigations: Alleged and Confirmed Perpetrator Recidivism FY2014-FY2023

Recidivism is calculated as a percentage of all alleged perpetrators in abuse/neglect investigations closed without services who were a confirmed perpetrator within 12 months after the prior investigation was closed without services.

Calculating this way, for example, the Fiscal Year 2019 rate reflects recidivism of alleged perpetrators in investigations closed without services in Fiscal Year 2018, the Fiscal Year 2018 rate reflects recidivism among alleged perpetrators in investigations closed without services in 2017, and so on.

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-311-child-abuseneglect-investigations-alleged-hyd5-jz8f\".\"cpi_311_child_abuseneglect_investigations_alleged\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.