CWS Outcomes System Summary Files

Correction (July 12, 2017): Q1 2017 data posted in the Child Welfare workbooks between June 29, 2017 and July 10, 2017 for outcomes 4A Siblings (All) and 4A Siblings (Some or All) contained errors. Corrected data are now posted to the website. We apologize for any inconvenience or confusion.

Note: As of the Quarter 1, 2017, outcome measures 5B(1&2) in these reports reflect compliance standards enacted on July 1, 2016 and reflected in All County Letter No. 17-22 ( Specifically, the schedule was revised to require more frequent medical examinations for most age groups. For dental exams, the age range for exams was modified to include all ages 1-20 years and a 12-month examination window. Please see the methodology for details.

Note: As of the Quarter 4, 2016 extract, placement type categories in the 4B Point in Time measures have been updated to reflect implementation of the RFA process. For details please see the Measure_Methods worksheets in these files and Point in Time/In Care methodology.

Note (National Standards): In the Quarter 3, 2016 version of the CWS Outcomes workbooks (Child Welfare and Probation) available below, information regarding national standards is not included because there are currently no national standards. They are being re-determined as a result of mistakes that ACYF found in their programs for the seven federal measures. Please see Technical Bulletin 9 for details.
Update 01/13/2017: For your reference, the workbooks have been revised to include the old national standards and related calculations. We will continue this approach until ACYF publishes corrected national standards.

Q1 17 County-Specific Outcome Spreadsheets (.xlsx File) by County:
Trouble downloading file? Need .xls (Excel 97-2003)? Please click here.

These spreadsheets contain the data that are included in the California Child Welfare Outcomes and Accountability System quarterly reports. They also include worksheets that allow comparison of performance between time periods and to national and performance standards (where applicable). The child welfare workbooks include graphs of many of the measures. In order to understand any measure, it is necessary to review it in the context of the entire cycle of measures, performance over time, and performance stratified by age, ethnicity, and gender. Please visit the online reports to further explore these measures.

Key Outcomes Presentation Tool (Quarter 1, 2017 Data Extract)
Excel 2003 version

The Key Outcomes Presentation Tool includes data from selected reports on this site, many of which are part of the CWS Outcomes reports above; it is not intended as a replacement for those reports. It allows users to display selected measures and reports for California or individual counties. Users can also control the interval displayed for the state/counties they have selected. In some sections users are able to set the span for percent change calculations. As with the CWS Outcomes reports available above, we encourage users to further explore these data using the dynamic reporting features available on this site.

For questions regarding UCB-created tables, please email Daniel Webster at
and also make sure to copy the email to:
All correspondence regarding the CDSS-created tables should be sent to