CPS 3.5 1st Children in Substitute Care First Placement Type after Removal FY2014-2023

A removal occurs when CPS determines that a child cannot safely remain in their own home and DFPS needs to seek legal custody to ensure child safety. Removals can occur in an investigation, family preservation, family substitute care or family reunification stage.

For removals at the end of the Fiscal Year, the placement represented may be from the following Fiscal Year.

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-35-1st-children-in-substitute-care-first-inxw-xxif\".\"cps_35_1st_children_in_substitute_care_first\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.