Icon for Socrata external plugin
Open repository in Console
Updated 10 months ago
Indexed 2 hours ago

CPI 3.10 Abuse/Neglect Investigations - Perpetrators by Region FY2013-FY2022

Counts perpetrators in completed investigations. 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 confirmed perpetrator on a completed investigation is an individual who is a confirmed perpetrator on at least one allegation with a disposition of reason to believe.

An alleged perpetrator on a completed investigation is an individual where all the allegations on which they were an alleged perpetrator have a disposition of ruled out, unable to complete or unable to determine.

A description of Alternative Response and how it differs from a traditional investigation and the definitions of the different dispositions in a traditional investigation are in the glossary.

  1. Each victim may have more than one perpetrator in an investigation.

  2. Each perpetrator may have more than one victim.

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" \
{"sql": "
    SELECT *
    FROM \"texas-gov/cpi-310-abuseneglect-investigations-perpetrators-fjvj-sq4y\".\"cpi_310_abuseneglect_investigations_perpetrators\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • cpi_310_abuseneglect_investigations_perpetrators
Upstream Metadata