Icon for Socrata external plugin
Open repository in Console
Updated 10 months ago
Indexed 2 hours ago

DCF Children in Placement: Annual Point-in-Time Trend By Age Group

This file contains a row for the unique combination of in-care date (first of each state fiscal year), DCF Region/Office responsible for the child's case, Age Group and whether the placement is inside or outside of CT. This file will be updated on an annual basis, on or about October 1st of each year. Rollups that Sum across Month-In-Care dates are NOT valid; though Averages, Medians, Minimum or Maximum values can be calculated with meaningful results. See attached metadata document for more detail and column definitions.

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" \
{"sql": "
    SELECT *
    FROM \"ct-gov/dcf-children-in-placement-annual-pointintime-trend-v6zb-h5e2\".\"dcf_children_in_placement_annual_pointintime_trend\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • dcf_children_in_placement_annual_pointintime_trend
Upstream Metadata