CPS 1.9 Outcomes of Children Completing Family Preservation Services FY2014-2023
This tracks six month, one year, and five year outcomes for children who were provided family preservation services and subsequently alleged as a victim in an investigation within the noted time period.
The date of service is determined by the close of the CPS Family Preservation stage.
The six month period is calculated by following those children who were served within the first six months of the fiscal year (FY) to see if the same child is an alleged victim in an abuse/neglect child protective investigation within six months of the family preservation stage closure.
For the one year outcome, those children who were served in the prior FY are tracked for one year and reported in the next fiscal year. The outcomes reported in FY 2018 had a beginning cohort from FY 2017.
The five year outcomes start with the FY five years prior and follows each child for five years to track the outcomes. FY 2018 would have a beginning cohort of those children who were participated in family preservation services in FY 2013.
This does not track recidivism, which is defined by CPS as subsequent reason to believe finding in a new investigation or subsequent open case to FBSS or removal within a given timeframe.
This dashboard addresses the Texas Human Resources Code Section 40.0516 (a)(9)(A), (B), (C) and (a)(10).
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-19-outcomes-of-children-completing-family-dcv9-t4ns\".\"cps_19_outcomes_of_children_completing_family\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.