CPI 3.2 Completed Investigations Initiated Timely by County FY2014-FY2023

Priority 1 investigations must have initial contact within 24 hours and Priority 2 within 72 hours.

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.

A description of Alternative Response and how it differs from a traditional investigation and priority response times are in the CPS glossary.

Visit dfps.texas.gov for information on all DFPS programs

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-32-completed-investigations-initiated-timely-fyq2-nr3p\".\"cpi_32_completed_investigations_initiated_timely\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.