Welcome to the web portal for the California Child Welfare Indicators Project. We have redesigned our home page to promote easier browsing and targeted searches for our users. If you would like to see the site using the classic menu view, click the “Measures” button. To explore data by topic area, click the “By Topic” button.
New in Q2 2018 (Sep 27, 2018)
New in Q1 2018 (June 28, 2018)
- 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.
- 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. To obtain accurate information regarding relative placements, reports should be filtered/restricted by "Relative" caregiver relationship type. Please note, non-related extended family members could not be identified for resource family homes at this time and were reflected as a "Nonrelative" caregiver relationship type.
New in Q4 2017 (Apr 02, 2018)
Exits from Foster Care
- "Emancipation" was renamed to "Aged Out/Emancipated."
- In addition to age of majority [5427, 5506] and emancipation [5433, 5510], the category has been updated to include exits from care to: NMD eligible for reentry [6803, 6812], NRLG eligible for reentry [6804, 6813], NMD age limit exit [6805, 6814], and NRLG age limit exit [6806, 6815]. This results in decreases in the "Other" category. For details, please see the methodology:
New in Q3 2017 (Jan 02, 2018)
- Placement Type
We updated "Relative/NREFM" to reflect the new Caregiver Relationship Codes, NREFM Guardian (6990) and NREFM Nonguardian (6991):
Relative/NREFM Home (1421)
Tribe Specified Home (1422)
County Approved Resource Family Approval (RFA) Home (6914) where SCP_RLTC = 1638, 1639, 6990, or 6991
Foster Family Agency Resource Family Approval (RFA) Home (6915) where SCP_RLTC = 1638, 1639, 6990, or 6991
We updated "Shelter" to reflect the new Placement Type Code, Temporary Shelter Care Facility (7027):
County Shelter/Recving Home (Non EA/AFDC) (1418)
Temporary Shelter Care Facility (7027)
For details, please see:
Note (November 14, 2017)
Entries to Foster Care
We adjusted some views of the data so that the Missing category is excluded from all percentage calculations. You may notice small differences in percentages retrieved from the site 09/29/17 through 11/14/2017 and the current calculations. The only exception is the Census Ethnicity variable: it includes a large number of Missing values, which continue to be represented in percentage calculations.
New in Q2 2017 (Oct 01, 2017)
For all reports, until technical issues regarding the reporting of Resource Family Home placements are resolved, placements in Resource Family Homes are reported as indicated in the placement type methodology:
These issues generally involve the incorrect classification of homes whose status has changed to Resource Family Home from another placement type.
As indicated in the methodology, the new placement types are grouped into more appropriate categories, rather than being assigned to 'Other'. For reports other than In Care/Point in Time, therefore, versus past quarters, you may see a redistribution from the 'Other' category to other placement types, especially in recent time periods.
Correction (July 12, 2017)
New in Q1 2017 (June 29, 2017)
Measure 5B(1&2) Timely Health & Dental Exams:
5B(1&2) has been updated to reflect new exam requirements. For medical exams, the schedule was revised to require more frequent examinations for most age groups. For dental exams, the age range for exams was modified to include all ages 1-20 years and 12-month examination window.
New in Q4 2016 (March 30, 2017)
In Care/Point in Time: We added new placement types to reflect changes resulting from the Resource Family Approval (RFA) process.
For a complete list of the new placement type categories and the corresponding CWS/CMS codes, please see the Point in Time/In Care methodology (link below) and click on the Placement Type link.
There are issues with these placement type data:
(1) A small number of placements are reported as RFA placements before RFA implementation in the indicated county. In these cases, the facility type as of the Q4 16 extract is being reported, rather than the facility type that was in effect at the reported date.
(2) Most, if not all, placements in RFA FFA-Non Relative homes are actually placements in regular FFA homes, incorrectly reported as being in RFA FFA homes.
There are efforts underway to correct both these issues.
National Standards in Quarter 3, 2016 CWS Outcomes Workbooks (Update: January 5, 2016)
As noted below, the National Standards for the federal measures are being re-determined. The Quarter 3, 2016 CWS Outcomes workbooks--Child Welfare and Probation--do not currently include information regarding national standards. For your reference, we will revise the workbooks to include the old national standards and related calculations. These revised workbooks will be available next week (week of Monday, 01/09/2017). We will continue this approach until ACYF publishes corrected national standards.
New in Q3 2016 (December 23, 2016)
Revision of CFSR3 statewide data indicators (October 17, 2016)
- The Children's Bureau is revising the Child and Family Services Reviews, Round 3 (CFSR3) statewide data indicators, which will affect performance results for all states and the national standards. The Children's Bureau expects to complete this process by the end of 2016. The Children's Bureau then will use the statewide data indicators and national standards to provide context for the CFSR3 reviews. For details, please see CFSR Technical Bulletin 9.
CWS Outcomes Spreadsheets Update (October 6, 2016)
New in Q2 2016 (September 29, 2016)
With the Child and Family Service Review, Round 3 (CFSR3) now in place, we have discontinued our CFSR2 reporting.
CFSR2 C1.4 Reentry following reunification (exit cohort) has been renamed to:
'Reentry Following Reunification (Exit Cohort)' and is accessible from our main report index.
New in Q1 2016 (July 01, 2016)
New in Q4 2015 (January 31, 2016)
New in Q3 2015 (December 23, 2015)
New in Q2 2015 (October 2, 2015)
Child and Family Services Review, Round 3 (August 1, 2015)
We have updated our main Measures page: Measures from Round 3 of the Child and Family Services Review (CFSR3) have replaced those from CFSR2. For information about CFSR3, please see the presentation 'CFSR3 Data Overview' on our 'Presentations' page or visit the Children's Bureau website. CFSR2 measures are still available by clicking the button at the top of the measure page, which will take you to a separate CFSR2 listing.
New in Q1 2015 (June 25, 2015)
Data Dashboard (May 12, 2015)
Added dashboard of key counts--Child Population, Children with Allegations, Children with Substantiations, Children with Entries to Foster Care, Children in Foster Care, and Children with Exits.
The dashboard presents California and county-level data as line graphs. Use the dropdown menu at the top to select data for California or a particular county. And use the 'Agency Type' dropdown to select All, Child Welfare, Probation, or Other. Please note that Allegations and Substantiations data are only available for agency type 'Child Welfare.' Hold your pointer over the titles to view the details of each count or mouse over the line graph to see values for specific time periods. Click on the title of any count to go the start page for the corresponding detail report. For example, click on 'Entries' to go the start page of the 'Entries to Foster Care' report.
Transition-Age Youth and the Child Protection System: Demographic and Case Characteristics (March 25, 2015)
The Children’s Data Network and California Child Welfare Indicators Project have released a new report, Transition-Age Youth and the Child Protection System: Demographic and Case Characteristics. Funded by the Conrad N. Hilton Foundation and developed in collaboration with the California Department of Social Services and the Los Angeles Department of Children and Family Services, this report assembles publicly available data from the CCWIP’s site into a narrative overview that can be used by a range of agency and community stakeholders to better understand dynamics of transition-age youth (TAY), including: (1) the composition of the current population, (2) trends observed over the last decade, and (3) service experiences from a first report to final exit.
Findings indicate that the transition-youth child welfare experience differs in several important ways from that of their younger counterparts. For instance, transition-age youth have longer median lengths of stay and less stable placements. Transition-age youth are also more likely to be placed in group homes or to have runaway status and less likely to be placed in family like settings. They are more likely to exit to emancipation or in other ways (i.e., running away, refusing services, incarceration or death), and less likely to exit to permanency (i.e., reunification, adoption, Kin-GAP and guardianship). The information assembled in this report will be used to strengthen collaboration and alignment across the systems that influence foster youth outcomes and help policy makers, agency administrators and community providers better understand transition-age youth in an effort to increase their self-sufficiency through improved college and career readiness, stronger caregivers and special services for the most vulnerable.
LA and CA versions of the report can be found here: http://www.datanetwork.org/research/1011
New in Q4 2014 (March 25, 2015)
Measure 5F Children Authorized for Psychotropic Medications summary tables (California and all counties) are available. Values of 10 or less and calculations based on values of 10 or less are masked (***). Single time period selections for California or an individual county are available with limited features. In these stratified views of the data, additional values (the lowest available) are masked to prevent calculation of values of 10 or less.
New in Q3 2014 (December 18, 2014)
New in Q2 2014 (September 26, 2014)
- C1.3 code update: In developing analyses for the forthcoming CFSR3, we discovered that our reporting for the current entry cohort measure on time to reunification (C1.3) used a calculation function that requires revision. The computation of follow-up intervals included up to 30 days of additional time (e.g., a report for “status at 12 months” reflected a time frame that could include a 13th month). Measure C1.3 will be replaced by a new permanency measure in CFSR3. In the meantime, we have modified the program, and verified that calculations in all other outcome analyses are accurate. Trends in the updated C1.3 data are similar to those previously reported, though counties may note a decrease in the proportion for a given exit outcome and follow-up period (e.g., the statewide proportion reunified at 12 months for the October 2012 to March 2013 cohort is 36.0%, compared with 37.6% reported previously).
We apologize for any inconvenience this may cause, and invite you to contact Daniel Webster (email@example.com) with any questions you may have on the matter.
- New Reports: Timely monthly caseworker visits (in home)
These new reports calculate the percentage of children receiving in-home services who are visited by caseworkers.
2S By Year Timely monthly caseworker visits (in home)
summarizes data in annual views:
2S By Month Timely monthly caseworker visits (in home)
presents monthly views of the data and allows stratification or filtering by service component:
- A link to 2S By Year data on the site has been added to the CWS outcomes child welfare spreadsheets.
Data from this new report will be integrated into the child welfare outcomes spreadsheets next quarter (Quarter 3, 2014 extract).
- The Point-In-Time Placement Grids, which present a cross tabulation of supervising and placement counties, now support export to Excel. Exports to HTML and PDF formats are still available.
Exporting to Excel and using the 'freeze panes' feature will makes these large tables easier to navigate.
After export, you may wish to reduce the magnification (for example, to 80%), to show more on screen and accommodate the tall column header row.
Then, select the top left data cell. In Excel 2007/2010, on the 'View' ribbon, in the 'Window' group, click on the 'Freeze Panes' dropdown and select 'Freeze Panes'.
This will keep row and column headers (county names) visible as you scroll up/down or left/right in the data.
- We have added interactive features to the data highlight on our home page:
and to the highlight on the Latino Practice Advisory Committee (LPAC) home page:
Hold your cursor over a time period to see all values for the period or click on any item in the legend to hide or restore a data series and rescale the chart.
- The Center for Social Services Research (CSSR) at UC Berkeley's School of Social Welfare, of which the California Child Welfare Indicators Project (CCWIP) is a part, has a new web page:
There is a link to California Child Welfare Indicators Project (CCWIP) at the bottom left of the page.
As always, you can access the CCWIP home page directly at:
New in Q1 2014 (June 27, 2014)
- New report: 2F Timely monthly caseworker visits (out of home) by month: This new report calculates the percentage of children in placement who are visited by caseworkers (as 2F does), but presents the data in a monthly, rather than annual, view. 2F by month also allows stratification by placement type.
- New report: Case Openings: This report provides detail on welfare and/or probation supervised child welfare case openings for a specified year. Reports for the probation agency type are available for 2012 onwards.
- New report: Case Closures: This report provides detail on welfare and/or probation supervised child welfare case closures for a specified year. The number of distinct children or case closures per year and the reason for case closure (e.g., Family Stabilized, Adoption) are provided. Reports for the probation agency type are available for 2012 onwards.
- On the report index, we added an indicator (asterisk) to reports that allow stratification by agency type, and that therefore allow you to look specifically for data for agency type probation.
- We continue to be very excited about our partnership with the Children’s Data Network (CDN) at USC, which will increase our research capacity and enhance our ability to make more data publicly available. The Children’s Data Network is a university, agency, and community collaborative focused on the integration and application of data to inform programs and policies for children and their families. Read more about CDN and watch a short and informative video about administrative data linkage at:
- While all individual measures have been retained, CFSR2 composite scores have been removed from the CWS Outcomes spreadsheets.
New in Q4 2013 (March 27, 2014)
New in Q3 2013 (December 20, 2013)
- A new report shortcut allows you to generate 'California CWS Outcomes System Summary Tables' for agency type probation. This feature is available (near the top of the start page) for the following reports: S2.1, C1.1, C1.2, C1.3, C1.4, C2.1, C2.2, C2.3, C2.4, C2.5, C3.1, C3.2, C3.3, C4.1,2,3, 2F, 4B (Entries), 4B (Point-in-Time), and 4E (1&2).
- We added the user-specified 'Begin Year' option to Case Service Components and C3.1. This addition to the multiple time period reports enables you to specify which time period you would like the output to begin with. (This option was added last quarter to the Allegations, Entries, Exits, and Point-in-Time/In Care analyses, and will be incorporated into other analyses in future quarters.)
- All placement-based reports have been modified to also exclude various placement activities for children when the case open during the placement has an Intervention Reason Type of "Incoming ICPC Request" (Code 1226). This modification has slightly reduced the counts of various placement activities (e.g., entries, exits, and point in time) for children with an identified responsible county and has markedly reduced the counts of these activities for children with no identified responsible county (County = Missing).
Latino Practice Advisory Committee (LPAC) (November 8, 2013)
- The Latino Practice Advisory Committee (LPAC) was formed to address the growing population of Latino children and families in California communities and child welfare system. The newly-designed LPAC web site is intended to facilitate the provision of culturally relevant services that respond to the unique needs of these families. The LPAC site provides indexed information and resources for child welfare agencies regarding Latino children and families, including data, research, policy, promising practices, and strategies for organizational improvement. Visit the new page by clicking here, or find it from the CCWIP home page using the "Links" tab at the top right of the page.
Video tutorials 2 and 3 added (November 8, 2013)
We are pleased to announce two new videos [http://cssr.berkeley.edu/ucb_childwelfare/tutorials.htm].
Tutorial 2 provides instructions on how to access summary reports.
Tutorial 3 is an overview of the drill down reports for single time periods for California, an individual county, or grouped counties.
Placement Days Tool Webinar and updated User Guide (November 18, 2013)
New in Q2 2013 (October 1, 2013)
- Discontinuation of Measure 2C -- 2C has been replaced, per request of The Data Committee (TDC), with Measure 2F - Timely caseworker visits with children (http://cssr.berkeley.edu/ucb_childwelfare/CDSS_2F.aspx). This change has been implemented in the CWS Quarterly Outcomes Reports. If you have questions, please contact Deborah Williams (Deborah.Williams@dss.ca.gov), Chief, Child Welfare Data Analysis Bureau.
- Addition of Probation Data for Measure 2F -- probation supervised agency data is now available for time periods beginning in January 2012 to the most recent reporting period.
- Cosmetic changes to the Quarterly Outcomes Spreadsheets -- several modifications were added this quarter to improve the ease of use of these reports (http://cssr.berkeley.edu/ucb_childwelfare/Ccfsr.aspx). These enhancements are described in an upcoming All County Information Notice (ACIN), and include a new "contents" worksheet, default percent changes between most recent time period and corresponding time periods one and five years prior, up and down arrows for measures indicating direction of performance, and tables and graphs that focus on the most recent decade or so of performance for each measure.
- User-specified Begin Year Option -- a new feature for multiple time period reports enables users to specify which time period they would like for the resulting output to begin with. So, for example, for a multi-time table of foster care point-in-time counts--rather than defaulting from July 1, 1998 to July 1, 2013--a user can now stipulate a table that begins with, say, July 1, 2008. (This option was added to Allegations, Entries, Exits, and PIT analyses, and will be incorporated into other analyses in future quarters.)
- Placement days tool and documentation -- a draft Excel tool and accompanying user guide have been added to the placement days report index page (http://cssr.berkeley.edu/ucb_childwelfare/PlacementDays.aspx). This tool is intended to assist California counties in estimating the financial implications of changes in foster care placement types and foster care caseload. Feedback to improve the tool is welcome.
New in Q1 2013 (July 1, 2013)
- New report: 2F Timely monthly caseworker visits (out of home)--this analysis follows the federal methodology to measure the compliance rate for case worker visits with children. The rate is equal to the percentage of children requiring a caseworker contact who received the contact in a timely manner. The monthly reporting period is based on a client (not case) level. Please note that, per decision by The Data Committee (TDC), measure 2F is henceforth replacing 2C on the CWS quarterly outcomes report, which will include a link to the 2F report index page on the CCWIP website. Quarter 1, 2013 will be the last extract for which data for 2C will be updated. Data currently posted for measure 2C will be available for users' reference for another 3 months, at which time they will be taken offline.
- New video tutorial: We are pleased to announce the first of several instructional videos on aspects of the CCWIP website. This initial video [http://cssr.berkeley.edu/ucb_childwelfare/tutorials.htm] provides a brief introduction on how to navigate the website as well as basic features of the report index. Future videos will provide new users with additional instructions on the website's tools and other functionality.
- Rates and Child Population reports time periods: The years 1998 and 1999 are no longer available for rates (allegation, entry, and in care rates) or the child population data index reports. We are discontinuing reporting these time periods since the CWS/CMS data quality for these years is of questionable reliability, and the census data used to make rate calculations do not include multi-race categories.
New in Q4 2012 (April 1, 2013)
- New Report: Placement Days--this analysis computes the number of out of home placements, and the number of care days in different placement facility types for a user-specified 12-month time period.
- Added a new placement type: the Supervised Independent Living Placement (SILP). This category has been included to account for a new placement type for youth 18 and over who elect to remain in care as non-minor dependents as provided by Assembly Bill 12. (Because the SILP placement type was not available prior to the CWS/CMS system revision in November 2012, earlier SILP placements often were categorized as Court Specified or Other.) The new placement type has been added to several analyses:
- CDSS 4E
- Placement Days
- Population Data Index has been updated with California Department of Finance: 2010-2060 Population Projections by Race/Ethnicity, Detailed Age, and Gender.
Updated Navigation Menu: we have reorganized analyses under several broad child welfare continuum headings (i.e., Population, Rates, Safety, Service Delivery, Cases, Foster Care) to streamline and simplify the Dynamic Reporting System index page title bar. [Please contact us if you cannot find what you are looking for.]