DCF Children in Placement: Annual Point-in-Time Trend By Race/Ethnicity

This dataset contains aggregate data concerning the number of unique children placed in open DCF placements on the observation date (July 1st each year). These figures are broken out by the DCF Region and Office responsible for the child's care, the child's Race/Ethnicity, whether the placement setting is in or out-of-state, and by the categorical Placement Type in which the child is residing on the observation date.

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 \"ct-gov/dcf-children-in-placement-annual-pointintime-trend-tnyk-6fv7\".\"dcf_children_in_placement_annual_pointintime_trend\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.