CPI 3.1 Completed Abuse/Neglect Investigations by Region FY2013 - FY2022

Child Protective Investigations (CPI) is authorized to investigate abuse and neglect allegedly committed by a person responsible for a child's care, custody or welfare and to protect abused and neglected children from further harm. This authorization is derived from the U.S. Social Securities Act, Texas Family Code, Human Resources Code, Child Abuse Prevention and Treatment Act, Indian Child Welfare Act and the Adam Walsh Act.

CPI conducts either a traditional investigation or Alternative Response (AR). Traditional investigations and Alternative Response require caseworkers to assess safety and take needed actions to protect a child while assessing any risk of abuse or neglect in the foreseeable future. AR cases present a less adversarial more collaborative approach to working with families by allowing for family engagement along with other community supports to ensure child safety. AR differs from traditional investigations in that AR cases are Priority 2 cases involving victims who are age 6 or older, there is no substantiation of allegations, no entry of perpetrators into the Central Registry (a repository for reports of child abuse and neglect), and there is a heightened focus on guiding the family to plan for safety in a way that works for them.

Completed investigations only include those cases conducted as a traditional investigation that were not administratively closed or merged into another stage. An investigation can only be administratively closed if all allegations have a disposition of administrative closure. A completed investigation can include more than one alleged victim. Completed investigations do not include any Alternative Response cases.

An investigation represents a report of abuse or neglect and can involve multiple children.

The data on completed investigations does not include investigative stages that were administratively closed or merged into another investigation.

All completed investigations have a case disposition and a risk finding.

More information at www.dfps.state.tx.us

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-31-completed-abuseneglect-investigations-by-gku3-vdgs\".\"cpi_31_completed_abuseneglect_investigations_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.