CPS 3.2 Children in Substitute Care by Placement Type on August 31 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. These children may be residing in substitute care or may be living with a parent, referred to as a return and monitor. DFPS legal responsibility terminates when a court orders DFPS custody ended or a youth turns 18, whichever comes first.

Substitute care - all children who are living in a DFPS out of home placement. It does not include children in DFPS custody who are living with a parent on a return and monitor. Unless otherwise noted, it does include youth over 18 who are in extended foster care but are not in DFPS custody.

Kinship care- a subset of substitute care that includes all children in DFPS custody who are living with a legal or blood relative or other individual who has a significant relationship with the child or the child's family known as "fictive kin."

Foster care - a subset of substitute care that includes all children living in a placement that has been verified to provide 24-hour residential care for a child, in accordance with Chapter 42 of the Human Resources Code and related regulations. These placements include foster homes, including kinship care where the caregiver has been verified, general residential operations (GRO), emergency shelters, residential treatment centers (RTC), and juvenile facilities.

Paid foster care - a subset of foster care where DFPS is making foster care payments.

Visit https://www.dfps.texas.gov/ for information on substitute care placements 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-32-children-in-substitute-care-by-placement-kgpb-mxxd\".\"cps_32_children_in_substitute_care_by_placement\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.