CPS 2.4 Children In Legal Responsibility on August 31 by Legal Status and Average Days in Care FY2014-2023

Children in DFPS custody are those for whom a court has appointed DFPS legal responsibility through temporary or permanent managing conservatorship or other court ordered legal basis. This chart includes any child in DFPS custody on August 31 of the fiscal year.

A description of the different types of legal statuses is in the CPS glossary: https://www.dfps.texas.gov/About_DFPS/Data_Book/Child_Protective_Services/Resources/glossary.asp

Visit dfps.texas.gov for information on Children In Legal Responsibility and 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/cps-24-children-in-legal-responsibility-on-august-9e7a-4cbm\".\"cps_24_children_in_legal_responsibility_on_august\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.