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.