CPS 3.4 Children in Substitute Care on August 31 - Sibling Groups Placed Together FY2014-2023

Divides sibling groups into two groups: Those sibling groups where all siblings are in the same placement on August 31 and those who are not all together with an additional filter for sibling group size.

In this context, siblings are defined as children in substitute care who were removed from the same household whether in the same, or separate, removal events.

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-34-children-in-substitute-care-on-august-31-njas-z4my\".\"cps_34_children_in_substitute_care_on_august_31\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.