About this Dataset

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.
Organization: State of Connecticut
Last updated: 2020-11-12T14:58:08.537174
Tags: age, age-group, children, dcf, department-of-children-and-families, placement, trend

Tables

Table 1

@usgov.state_of_connecticut_dcf_children_in_placement_annual__b9aa3652.table_1

40.52 kB
2,588 rows
20 columns

CREATE TABLE table_1 (
  "data_as_of" TIMESTAMP,
  "dcf_region" VARCHAR,
  "dcf_office" VARCHAR,
  "demographic" VARCHAR,
  "out_of_state" VARCHAR,
  "month_in_care" TIMESTAMP,
  "total_cip" BIGINT,
  "foster_care" BIGINT,
  "relative_care" BIGINT,
  "special_study" BIGINT,
  "therapeutic_foster_care" BIGINT,
  "pdc_safe_home" BIGINT,
  "shelter" BIGINT,
  "group_home" BIGINT,
  "residential" BIGINT,
  "dcf_highmeadows" BIGINT,
  "dcf_solnit" BIGINT,
  "dcf_cjts" BIGINT,
  "hospital" BIGINT,
  "independent_living" BIGINT
);