CPS 3.2 in Substitute Care on August 31 by Placement Type with Demographics FY2014-2023

Children in the Custody of the Texas Department of Family and Protective Services (DFPS)- All children for whom DFPS legal responsibility through court ordered 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 trial home visit. 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 - all children in DFPS custody 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-in-substitute-care-on-august-31-by-6mty-mwk9\".\"cps_32_in_substitute_care_on_august_31_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.