CWS Outcomes System Summary Files

Note: Note: As of the Quarter 1, 2018 data extract, we use the CWS/CMS placement history table, PLACEMENT_FACILITY_TYPE_HISTORY (PFACHIST), and placement history data derived from an analysis of facility type change between extracts to more accurately determine placement types over time.

Important note: Prior to mid-2017, it was not possible for Resource Family Approval (RFA) early implementing counties to accurately capture the number of children living in "Kin" placement types (now called "Relative/NREFM"). Early implementing counties were instructed to enter all new placements with resource families into the Child Welfare Services/Case Management System as "Foster" placement types, including those placed with relatives.

Note: [10/17/2016]: The Children's Bureau has determined they will use the Child and Family Services Reviews, Round 3 (CFSR3) statewide data indicators and national standards to provide context for the CFSR3 reviews, rather than in conformity determinations. They are revising the indicators, which is likely to affect performance results for states and the national standards. For details, please see CFSR Technical Bulletin 9. For your reference, the CWS Outcomes workbooks will include the original national standards and related calculations until the Children's Bureau publishes corrected national standards.

Q1 19 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, 2019 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