{"text_format":"1","workbook":"xlsx","n_sheets":79,"sheets":["Slide Descriptions","ExcelPowerpointinstructions","table_view","age_in care","table_rates","rates over time","table_entries","entries by plctype","table_caseload","caseload by plctype","table_exits","exits by plctype","table_caseloadtrends","ent_exit_caseload","table_race_contact","race_contact","entry disparity","exit disparity","table_allegrates","3d allegations","table_substantiations","3D subrates","table_entrates","3D entries","table_incarerates","3D in care","table_racerates","3D black","3D white","3D latino","3D asian","Alleg_overtime_race","Alleg_time_race Chart","Subs_overtime_race","Subs_time_race Chart","Entries_overtime_race","Entry_time_race Chart","Incare_overtime_race","Incare_time_race Chart","table_logged_disparity","Disparity Indices","table_logged_disparity_pov","Disparity Indices_pov","table_C1.3 perm","C1.3 perm","table_C1.3 perm_race","C1.3  perm race","table_C1.3 perm_raceplctype","C1.3  perm white rel","C1.3  perm black rel","C1.3  perm white nonrel","C1.3 perm black nonrel","table_servcomponents","service components by race","table_servcomponents_time","servcomponents_time","table_plcmt_dist","plcmt_dist","table_siblings","placed siblings","table_recurrence","recurrence of alleg","table_perm_raw","table_perm_overtime","exits to perm over time","table_C3.1","C3.1","table_c3.3","C3.3","table_C4.1.2.3","C4.1.2.3","table_C1.4 reentry","C1.4 reentry","table_636 measures","AB 636 performance","table_fedmeas","fed measure perform","table_relative_performance","Performance Relative to Fed Std"],"not_rendered":{"charts":85,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"age_in care","index":3,"reason":"not_a_worksheet"},{"sheet":"rates over time","index":5,"reason":"not_a_worksheet"},{"sheet":"entries by plctype","index":7,"reason":"not_a_worksheet"},{"sheet":"caseload by plctype","index":9,"reason":"not_a_worksheet"},{"sheet":"exits by plctype","index":11,"reason":"not_a_worksheet"},{"sheet":"ent_exit_caseload","index":13,"reason":"not_a_worksheet"},{"sheet":"race_contact","index":15,"reason":"not_a_worksheet"},{"sheet":"entry disparity","index":16,"reason":"not_a_worksheet"},{"sheet":"exit disparity","index":17,"reason":"not_a_worksheet"},{"sheet":"3d allegations","index":19,"reason":"not_a_worksheet"},{"sheet":"3D subrates","index":21,"reason":"not_a_worksheet"},{"sheet":"3D entries","index":23,"reason":"not_a_worksheet"},{"sheet":"3D in care","index":25,"reason":"not_a_worksheet"},{"sheet":"3D black","index":27,"reason":"not_a_worksheet"},{"sheet":"3D white","index":28,"reason":"not_a_worksheet"},{"sheet":"3D latino","index":29,"reason":"not_a_worksheet"},{"sheet":"3D asian","index":30,"reason":"not_a_worksheet"},{"sheet":"Alleg_time_race Chart","index":32,"reason":"not_a_worksheet"},{"sheet":"Subs_time_race Chart","index":34,"reason":"not_a_worksheet"},{"sheet":"Entry_time_race Chart","index":36,"reason":"not_a_worksheet"},{"sheet":"Incare_time_race Chart","index":38,"reason":"not_a_worksheet"},{"sheet":"Disparity Indices","index":40,"reason":"not_a_worksheet"},{"sheet":"Disparity Indices_pov","index":42,"reason":"not_a_worksheet"},{"sheet":"C1.3 perm","index":44,"reason":"not_a_worksheet"},{"sheet":"C1.3  perm race","index":46,"reason":"not_a_worksheet"},{"sheet":"C1.3  perm white rel","index":48,"reason":"not_a_worksheet"},{"sheet":"C1.3  perm black rel","index":49,"reason":"not_a_worksheet"},{"sheet":"C1.3  perm white nonrel","index":50,"reason":"not_a_worksheet"},{"sheet":"C1.3 perm black nonrel","index":51,"reason":"not_a_worksheet"},{"sheet":"service components by race","index":53,"reason":"not_a_worksheet"},{"sheet":"servcomponents_time","index":55,"reason":"not_a_worksheet"},{"sheet":"plcmt_dist","index":57,"reason":"not_a_worksheet"},{"sheet":"placed siblings","index":59,"reason":"not_a_worksheet"},{"sheet":"recurrence of alleg","index":61,"reason":"not_a_worksheet"},{"sheet":"exits to perm over time","index":64,"reason":"not_a_worksheet"},{"sheet":"C3.1","index":66,"reason":"not_a_worksheet"},{"sheet":"C3.3","index":68,"reason":"not_a_worksheet"},{"sheet":"C4.1.2.3","index":70,"reason":"not_a_worksheet"},{"sheet":"C1.4 reentry","index":72,"reason":"not_a_worksheet"},{"sheet":"AB 636 performance","index":74,"reason":"not_a_worksheet"},{"sheet":"fed measure perform","index":76,"reason":"not_a_worksheet"},{"sheet":"Performance Relative to Fed Std","index":78,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Slide Descriptions","index":0,"n_rows":48,"n_cols":4,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Q4_14"]
[]
["Updates","Slide Order","DESCRIPTION","TITLE"]
["quarterly",1,"presentation title page","California's Child Welfare Performance Indicators Project: Q2_13 Slides"]
["n/a",2,"placement system","The Current Placement System (highly simplified)"]
["n/a",3,"outcome wheel","Tracking Child Welfare Outcomes"]
["n/a",4,"view example","The View Matters…How Long do Children Stay in Foster Care?"]
["quarterly",5,"entry, pit and exit data by age","California Example: Age of Children in Foster Care (2012 entries, July 1, 2012 caseload, 2012 exits)"]
["quarterly",6,"allegation, substantiation, and entry rates over time","California: Allegation, Substantiation, and Entry Rates (per 1,000)"]
["n/a",7,"problem with summary statistics","The Problem with Summary Statistics"]
["quarterly",8,"all entries over time, by placement type","California: Entries To Foster Care Over Time, by placement type"]
["quarterly",9,"foster care caseload over time, by placement type","California: Out-of-Home Caseload Over Time, by placement type"]
["quarterly",10,"exits over time, by placement type","California: Exits From Foster Care Over Time, by placement type"]
["quarterly",11,"entries, exits, and caseload over time","California: Entries, Exits, and Out-of-Home Caseload Over Time"]
["quarterly",12,"stacked bar by point of contact, population, allegation, substantiation, entries, in care, exits","California: Ethnicity and Path Through the Child Welfare System (missing values and other race excluded from % calculations)"]
["n/a",13,"definitions of disproportionality and disparity","Definitions"]
["quarterly",14,"disparity index calculation example 1","California: Disparity Index, Entry Disparity"]
["quarterly",15,"disparity index calculation example 2","California: Disparity Index, Exit Disparity"]
["quarterly",16,"3d rates of allegations by age and ethnicity","California: Allegations per 1,000, by age and ethnicity"]
["quarterly",17,"3d rates of substantiations by age and ethnicity","California: Substantiations per 1,000, by age and ethnicity"]
["quarterly",18,"3d rates of entries to care by age and ethnicity","California: Entries to Care per 1,000, by age and ethnicity"]
["quarterly",19,"3d rates of children in care by age and ethnicity","California: Children in Care per 1,000, by age and ethnicity"]
["quarterly",20,"3d slides for all points of contact, organized by race, common scale","California: Allegation, Substantiation, Entry, and In Care Rates per 1,000"]
["n/a",21,"population data information","Updates to Population Data"]
["quarterly",22,"Allegation rates over time by race/ethnicity","California: Allegation Rates Over Time (per 1,000) by race/ethnicity"]
["quarterly",23,"Substantiation Rates over time by race/ethnicity","California: Substantiation Rates Over Time (per 1,000) by race/ethnicity"]
["quarterly",24,"Entry Rates over time by Race/ethnicity","California: Entry Rates Over Time (per 1,000) by race/ethnicity"]
["quarterly",25,"In Care Rates over time by race/ethnicity","California: In Care Rates Over Time (per 1,000) by race/ethnicity"]
["n/a",26,"poverty data information","Poverty Data"]
["quarterly",27,"logged racial disparity by point of contact compared with white (general)","California: General Population Racial Disparity Indices (group compared to White)"]
["quarterly",28,"logged racial disparity by point of contact compared with white (poverty)","California: Poverty Population Racial Disparity Indices (group compared to White)"]
["quarterly",29,"first entry cohort slide, 48 months from entry","California: Percent Exited to Permanency 48 Months From Entry"]
["quarterly",30,"first entry cohort slide, 48 months from entry, by race","California: Percent Exited to Permanency 48 Months From Entry, by race"]
["quarterly",31,"first entry cohort slide, 48 months from entry, by race and placement type","California: Percent Exited to Permanency 48 Months From Entry, by race and placement type"]
["quarterly",32,"caseload service components by race","California: Caseload Case Service Components by Race/Ethnicity  (missing values and other race excluded from % calculations, children of all ages included) "]
["quarterly",33,"caseload services components over time","California: Caseload Case Service Components Over Time"]
["quarterly",34,"kin vs. non-kin placement distances from home over time","California: Children Still in Care 12m After Entry, Placement Distance from Home by Kin vs. Non-Kin (missing values excluded from % calculations)"]
["quarterly",35,"children placed with some, or all, siblings","California: Out-of-Home Caseload, Children Placed with Siblings (includes only those children who have siblings in care)"]
["quarterly",36,"recurrence of allegations by base (and follow-up) disposition type","California: Recurrence of Allegations Over 24 Months, by disposition type"]
["quarterly",37,"first entry cohort view of exits to permanency over time","California: Percent Exiting to Permanency Over Time: First Entry Cohorts, 8+ Days in Care, 1998-2009"]
["quarterly",38,"c3.1 performance over time","California: C3.1: Exits to Permanency (24m in Care), by exit type"]
["quarterly",39,"c3.3 performance over time","California: C3.3: In Care 3 Years or Longer (Emancipated or Age 18)"]
["quarterly",40,"trends in placement stability over time for the three federal stability measures","California: C4.1,2,3: Placement Stability"]
["quarterly",41,"c1.4 reentry after reunification ","California: C1.4: Reentering Care After Exit to Reunification at 12 and 24 Months"]
["quarterly",42,"cws outcomes system, ab636 improvement/decline","California CWS Outcomes System: Federal Measures, % Improvement/Decline"]
["quarterly",43,"cws outcomes system, federal measures improvement/decline","California CWS Outcomes System: AB636, % Improvement/Decline"]
["quarterly",44,"calculation of federal measure performance relative to std/goal","California CWS Outcomes System: Performance Relative to Federal Standard/Goal"]
["quarterly",45,"citation slide","n/a"]

{"sheet":"ExcelPowerpointinstructions","index":1,"n_rows":30,"n_cols":1,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Instructions for Excel: "]
["1.  All of the basic URLs for the tables in the \"Source\" row of each of the worksheets."]
["2.  The Agency Type is always Child Welfare.  The Output Type required for each of the tables is at the top of each worksheet."]
["On the CMS/CWS website, the option for choosing single or multiple time periods is referred to as either Output Type or Drill Down Report.  For consistency, throughout this workbook, that option is always referred to as Output Type.  "]
["3.  Each table has the filters needed to create county reports identical to the California reports shown in the worksheets."]
["(The only filter not included is the one for selecting individual counties or CA as a whole)."]
["If the filters read \"Subgroups: No Restrictions\" either clicking all of the subgroups or not clicking any will provide the same data.  "]
["If a filter is not described, any of the options can be selected to provide the data.  Generally, the filters are not included when the CMS/CWS website provides the option for a more detailed breakdown than the table/chart uses. "]
["4.  Some of the worksheets also have additional notes; these are used to convey information when the original reports were manipulated to create the ones shown in the worksheets"]
["(I.E. when two rows from the CWS/CMS table have to be added together to create the row used in the worksheet). "]
["5. Some of the reports are created using DataDude; if your county does not have the DataDude tool or needs a users' guide for the tool; please contact "]
["Emily Putnam Hornstein at eputnamhornstein@berkeley.edu or Bryn King at brynking@berkeley.edu. Alternately, data can be entered manually from the static reports by following the report link."]
["6.  If you do not download the slide workbook every quarter from the website, the tables that show changes over time will have to have their source data extended an extra column"]
["in order to include the new data."]
["7.  The racial disparity rates  do not automatically link to the updated numbers in the chart; the numbers are in text boxes that must be updated."]
[]
[]
[]
["Instructions for Powerpoint: "]
["1. Go to the worksheet for the table/chart that you want to copy."]
["2. Click on Edit at the top of Excel and then select \"Copy\""]
["3.  In Powerpoint, click on \"Edit\" and click \"Paste Special.\""]
["4.  In the menu that comes up, select \"Bitmap\" and then click ok. "]
["5.  The table/chart should be centered and sized appropriately. "]
[]
[]
[]
["Questions? Please contact: "]
["Emily Putnam Hornstein at eputnamhornstein@berkeley.edu"]
["Bryn King at brynking@berkeley.edu"]

{"sheet":"table_view","index":2,"n_rows":48,"n_cols":4,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California Example: Age of Children in Foster Care (2013 entries, July 1, 2013 caseload, 2013 exits)"]
["NOTES:","Some of the age groups will have to be added together to create the rows provided in this worksheet; "]
[null,"Formulas are in place to calcuate percentages and totals; do not include 18-20 in totals"]
["OUTPUT TYPE:","Single Time Period (California or Individual County)"]
["SOURCE:","Entries (http://cssr.berkeley.edu/ucb_childwelfare/Entries.aspx);  "]
[null,"Point in Time (http://cssr.berkeley.edu/ucb_childwelfare/PIT.aspx);"]
[null,"Exits (http://cssr.berkeley.edu/ucb_childwelfare/Exits.asp)"]
["FILTERS:","See below"]
[]
[null,"Entries","Point in Time","Exits"]
["<1 yr",{"$f":"B19/B$25*100","v":19.260323608421317},7.2845933303153769,5.9255704053754705]
["1-5 yrs",33.31355032173424,31.665912177455862,42.461049988924167]
["6-10 yrs",22.271506216030488,22.99117247623359,26.489699475743926]
["11-15 yrs",18.488786156056726,24.475629998491023,18.648010042088163]
["16-17 yrs",6.6658336977572317,13.582692017504151,6.4756700878682709]
[]
["Age","Entries (raw counts)","PIT (raw counts)","Exits (raw count)"]
["<1 yr",6166,3862,1605]
["1-5 yrs",10665,16788,11501]
["6-10 yrs",7130,12189,7175]
["11-15 yrs",5919,12976,5051]
["16-17 yrs",2134,7201,1754]
[]
["TOTAL",{"$f":"SUM(B19:B23)","v":32014},{"$f":"SUM(C19:C23)","v":53016},{"$f":"SUM(D19:D23)","v":27086}]
["PCT TOTAL",{"$f":"SUM(B12:B16)","v":100.00000000000001},{"$f":"SUM(C12:C16)","v":100},{"$f":"SUM(D12:D16)","v":100}]
[]
["FILTERS"]
["Entries:"]
["Time Period:","Jan-Dec 2013"]
["Rate Type:","All Children Entering"]
["Table Output: ","Count"]
["Row Dimension:","Age Group"]
["Subgroups:","No Restrictions"]
[]
["Point in Time:"]
["Time Period:","2013-07-01"]
["Table Output: ","Count"]
["Row Dimension:","Age group"]
["Subgroups:","No Restrictions"]
[]
["Exits:"]
["Time Period:","Jan-Dec 2013"]
["Days in Care:","All"]
["Episode Count:","All Exit"]
["Table Output:","Count"]
["Column Dimension:","Age Group"]
["Subgroups:","No Restrictions"]

{"sheet":"table_rates","index":4,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Allegation, Substantiation, and Entry Rates (per 1,000)"]
["NOTES:","For Percent Change, download the CWS Outcomes Summary Sheet.  "]
[null,"The first sheet has a \"comparison to baseline data percent change\" column for referral (allegation) rates, substantiation rates, and entry rates."]
[null,"Those numbers will have to be manually changed in the parentheses in order for the slides to reflect the correct numbers.  "]
[null,"Three separate tables will need to be access from the Rate Reports - Entries, Substantiations, and Allegations"]
["OUTPUT TYPE:","Multiple Time Periods Summary Table (California and All Counties)"]
["SOURCE:","Allegation and Substantiation Rate Reports (http://cssr.berkeley.edu/ucb_childwelfare/RefRates.aspx)"]
[null,"CWS Outcomes Summary Sheet (http://cssr.berkeley.edu/ucb_childwelfare/Ccfsr.aspx)"]
["FILTERS:","See below"]
[]
[null,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014]
["Entry Rate (5-year % change: +2.3)",3.7,3.9,3.9,3.8,3.4,3.4,3.3,3.3,3.4,3.5,3.5]
["Substantiation Rate (5-year % change: -12.5)",11.6,11.5,11.3,11.2,10.199999999999999,9.9,9.6,9.5,9.3000000000000007,9.1999999999999993,8.6999999999999993]
["Allegation Rate (5-year % change: +7.8)",51.2,50.3,50.5,51.5,51,50.7,51.6,51.6,53.2,53,54.6]
[]
["allegation rate percent change",7.8," "]
["substantiation rate percent change",-12.5]
["entry rate percent change",2.2999999999999998]
[]
[]
["FILTERS:"]
["Statistic:","Entry: Incidence per 1,000 Children"]
[null,"Substantiations: Incidence per 1,000 Children"]
[null,"Allegations: Incidence per 1,000 Children"]
["Subgroups:","No Restrictions"]

{"sheet":"table_entries","index":6,"n_rows":21,"n_cols":42,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,17],[4,1,4,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Entries to Foster Care Over Time, by placement type"]
["NOTES:","Group and Shelter must be added together; the report places them in separate rows; total includes all placements, not only those included in this chart. "]
["OUTPUT TYPE:","Multiple Time Periods (California or Individual County)"]
["SOURCE:","Entries report (http://cssr.berkeley.edu/ucb_childwelfare/Entries.aspx)"]
["FILTERS:","See below"]
[]
[null,2004,null,null,null,2005,null,null,null,2006,null,null,null,2007,null,null,null,2008,null,null,null,2009,null,null,null,2010,null,null,null,2011,null,null,null,2012,null,null,null,2013,null,null,null,2014]
["Kin",5745,5971,6304,6642,6975,7111,7230,7250,7378,7565,7774,7853,7441,6869,6342,6022,5823,5712,5513,5452,5600,5637,5824,6135,6272,6336,6506,6429,6540,6837,7081,7325,7592,7661,7868,8235,8380,8534,8461,8341,8093]
["Foster",9816,9695,9280,9088,8852,8270,8081,7836,7941,7968,7735,7776,7293,6974,6908,6556,6602,6618,6435,6330,6217,6045,6069,6049,5977,5978,5784,5609,5396,5281,5302,5367,5418,5412,5422,5303,5328,5351,5380,5394,5300]
["FFA",11738,12322,12884,13069,13408,13336,13431,13842,14292,14485,14929,14775,14452,14176,13993,14184,14244,14473,14250,14460,14555,14290,14136,13872,13795,14124,14103,13746,13388,13008,12965,12973,13298,13548,13806,14228,14243,14018,13880,13898,13762]
["Group/Shelter",6669,6557,6607,6744,6959,6996,6802,6636,6492,6340,6335,5998,5761,5477,5235,5134,5017,4823,4588,4385,4142,3940,3805,3677,3602,3699,3698,3684,3756,3669,3616,3623,3587,3425,3397,3409,3400,3609,3784,3885,3910]
["Total",35342,35955,36465,36940,37623,37061,36863,36831,37334,37567,37920,37552,36101,34675,33652,33062,32876,32794,31958,31840,31696,31062,30941,30803,30705,31250,31182,30508,30105,29768,29973,30369,31060,31229,31671,32332,32462,32684,32716,32704,32184]
[]
["FILTERS:"]
["Days in Care:","All"]
["Episode Count:","All Children Entering"]
["Table Output:","Count"]
["Row Dimension: ","Placement Type"]
["Interval:","All"]
["Subgroups:","No Restrictions"]

{"sheet":"table_caseload","index":8,"n_rows":19,"n_cols":42,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[4,1,4,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Out-of-Home Caseload Over Time, by placement type"]
["NOTES:","Group and Shelter must be added together; the report places them in separate rows; total includes all placement types, not only those shown in this chart. "]
["OUTPUT TYPE","Multiple Time Periods (California or Individual County)"]
["SOURCE:","Point in Time Report (http://cssr.berkeley.edu/ucb_childwelfare/PIT.aspx)"]
["FILTERS:","See below"]
[]
[null,2005,null,null,null,2006,null,null,null,2007,null,null,null,2008,null,null,null,2009,null,null,null,2010,null,null,null,2011,null,null,null,2012,null,null,null,2013,null,null,null,2014,null,null,null,2015]
["Kin",26097,26207,26306,26334,26731,26753,26589,26519,26469,26486,26365,25825,25284,24092,23169,22136,21510,20841,20142,19557,19105,18583,18465,18547,18869,18834,18967,18909,19144,19225,19594,19806,20226,20194,20777,21161,21765,21705,21752,22015,22260]
["Foster",9794,9837,9451,9212,8769,8661,8422,8130,7961,7914,7545,7465,7073,7060,6745,6495,6346,6273,5933,5775,5603,5673,5637,5617,5547,5608,5425,5375,5255,5275,5281,5297,5186,5262,5385,5464,5413,5584,5606,5660,5608]
["FFA",18361,18998,18872,18772,18513,19109,19158,19156,18936,19481,19491,19179,18358,18437,18114,18036,17601,17939,17641,17681,17368,17345,16961,16880,16391,16553,16032,15674,14799,14849,14713,14657,14482,14977,15050,15433,15256,15511,15561,15911,15749]
["Group/Shelter",6901,6944,6826,6634,6560,6470,6283,6074,5985,5879,5779,5559,5408,5316,4990,4771,4615,4514,4271,4169,3964,3960,3956,3874,3929,4070,3925,3805,3799,3849,3843,3892,3821,3836,3854,3830,3855,3893,3914,3918,3926]
["Total",78887,79834,79054,78257,76995,77389,76729,75973,75163,75638,74825,73343,71016,69975,67858,65964,64260,63679,61924,60555,59157,58326,57338,57006,56530,56836,55972,55287,54416,54933,55286,55799,56207,57414,58689,59950,60532,61490,62097,62844,62898]
[]
["FILTERS:"]
["Table Output:","Count"]
["Row Dimension:","Placement Type"]
["Point in Time:","All"]
["Subgroups:","No Restrictions"]

{"sheet":"table_exits","index":10,"n_rows":21,"n_cols":42,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,17],[5,1,5,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Exits from Foster Care Over Time, by placement type"]
["NOTES:","The tables for placement type need to be created separately by changing the subgroup restriction on placement type; select both group and shelter to obtain the numbers for that row"]
[null,"Total includes all placement types, not only those shown in this chart."]
["OUTPUT TYPE:","Multiple Time Periods (California or Individual County)"]
["SOURCE:","Exits (http://cssr.berkeley.edu/ucb_childwelfare/Exits.aspx)"]
["FILTERS:","See below"]
[]
[null,2004,null,null,null,2005,null,null,null,2006,null,null,null,2007,null,null,null,2008,null,null,null,2009,null,null,null,2010,null,null,null,2011,null,null,null,2012,null,null,null,2013,null,null,null,2014]
["Kin",11225,11026,10918,10912,10984,11204,11336,11405,11570,11651,11794,12064,12106,12264,12394,12380,12098,11777,11325,10967,10900,10791,10503,10338,10031,9865,10056,10007,10045,10114,9916,9824,9830,9819,9776,9847,9758,9812,10040,10033,9988]
["Foster",5636,5450,5305,5151,5054,4903,4641,4557,4415,4324,4374,4318,4192,4106,3978,3818,3739,3689,3559,3483,3426,3346,3338,3281,3206,3143,3082,2977,2899,2859,2692,2617,2550,2443,2381,2294,2302,2254,2304,2288,2180]
["FFA",9203,9130,9214,9410,9568,9667,9717,9739,9904,10022,10252,10344,10309,10400,10577,10742,10693,10559,10172,10008,9986,10096,10060,9837,9670,9648,9562,9374,9079,8696,8190,7811,7543,7334,7161,7122,7265,7225,7396,7459,7214]
["Group/Shelter",4716,4657,4588,4712,4749,4728,4686,4548,4442,4423,4302,4175,4078,3891,3819,3678,3566,3451,3299,3247,3151,3049,2912,2768,2653,2618,2648,2728,2732,2678,2546,2376,2327,2205,2180,2191,2109,2220,2257,2246,2274]
["Total",39951,39550,39384,39677,39955,40003,39656,39510,39490,39641,40141,40466,40525,40576,40854,40724,39988,39293,38047,37473,37119,36809,35894,34678,33590,33024,32850,32536,32369,31887,30884,30032,29532,28973,28589,28521,28443,28697,29334,29529,29222]
[]
["FILTERS:"]
["Days in Care:","All"]
["Episode Count:","Children Exiting"]
["Table Output:","Count"]
["Interval:","All"]
["Subgroups:","No restrictions on age, gender, ethnic group, or caregiver relationship"]

{"sheet":"table_caseloadtrends","index":12,"n_rows":12,"n_cols":42,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[3,1,3,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Entries, Exits, and Caseload Over Time"]
["NOTES:","To align with Caseload (In Care/PIT) data, Entries and Exits values are plotted at time period end, as indicated by the dates in gray.  For example, Jan-Dec 2013 Entries are plotted at Jan 1, 2014--a 1-year shift from the Entries and Exits charts, in which labels correspond to time period start."]
["SOURCE:","Entries, Exits, and PIT (see earlier URLS and tabs…these data have already been downloaded)"]
["FILTERS: ","See above"]
[]
[null,2005,null,null,null,2006,null,null,null,2007,null,null,null,2008,null,null,null,2009,null,null,null,2010,null,null,null,2011,null,null,null,2012,null,null,null,2013,null,null,null,2014,null,null,null,2015]
[null,"JAN2004-DEC2004","APR2004-MAR2005","JUL2004-JUN2005","OCT2004-SEP2005","JAN2005-DEC2005","APR2005-MAR2006","JUL2005-JUN2006","OCT2005-SEP2006","JAN2006-DEC2006","APR2006-MAR2007","JUL2006-JUN2007","OCT2006-SEP2007","JAN2007-DEC2007","APR2007-MAR2008","JUL2007-JUN2008","OCT2007-SEP2008","JAN2008-DEC2008","APR2008-MAR2009","JUL2008-JUN2009","OCT2008-SEP2009","JAN2009-DEC2009","APR2009-MAR2010","JUL2009-JUN2010","OCT2009-SEP2010","JAN2010-DEC2010","APR2010-MAR2011","JUL2010-JUN2011","OCT2010-SEP2011","JAN2011-DEC2011","APR2011-MAR2012","JUL2011-JUN2012","OCT2011-SEP2012","JAN2012-DEC2012","APR2012-MAR2013","JUL2012-JUN2013","OCT2012-SEP2013","JAN2013-DEC2013","APR2013-MAR2014","JUL2013-JUN2014","OCT2013-SEP2014","JAN2014-DEC2014"]
["Entries",35342,35955,36465,36940,37623,37061,36863,36831,37334,37567,37920,37552,36101,34675,33652,33062,32876,32794,31958,31840,31696,31062,30941,30803,30705,31250,31182,30508,30105,29768,29973,30369,31060,31229,31671,32332,32462,32684,32716,32704,32184]
["Exits",39951,39550,39384,39677,39955,40003,39656,39510,39490,39641,40141,40466,40525,40576,40854,40724,39988,39293,38047,37473,37119,36809,35894,34678,33590,33024,32850,32536,32369,31887,30884,30032,29532,28973,28589,28521,28443,28697,29334,29529,29222]
[null,"2005-01-01","2005-04-01","2005-07-01","2005-10-01","2006-01-01","2006-04-01","2006-07-01","2006-10-01","2007-01-01","2007-04-01","2007-07-01","2007-10-01","2008-01-01","2008-04-01","2008-07-01","2008-10-01","2009-01-01","2009-04-01","2009-07-01","2009-10-01","2010-01-01","2010-04-01","2010-07-01","2010-10-01","2011-01-01","2011-04-01","2011-07-01","2011-10-01","2012-01-01","2012-04-01","2012-07-01","2012-10-01","2013-01-01","2013-04-01","2013-07-01","2013-10-01","2014-01-01","2014-04-01","2014-07-01","2014-10-01","2015-01-01"]
["In Care",78887,79834,79054,78257,76995,77389,76729,75973,75163,75638,74825,73343,71016,69975,67858,65964,64260,63679,61924,60555,59157,58326,57338,57006,56530,56836,55972,55287,54416,54933,55286,55799,56207,57414,58689,59950,60532,61490,62097,62844,62898]

{"sheet":"table_race_contact","index":14,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[6,1,6,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Ethnicity and Path Through the Child Welfare System (missing values and other race excluded from % calculations)"]
["NOTES:","Calculate percentages using raw count numbers rather than the % provided in the charts; subtract out \"Missing\" and \"Multi-Race\" when calculating percentages"]
[null,"I.E. Black child total population/(total child population-multi-race population) *100"]
[null,"Disparity rates must be calculated manually"]
["OUTPUT TYPE:","Single Time Period (California or Individual County)"]
["SOURCE:","Allegation and Substantiation Rates Reports (http://cssr.berkeley.edu/ucb_childwelfare/RefRates.aspx)"]
[null,"In Care Rates Report (http://cssr.berkeley.edu/ucb_childwelfare/InCareRates.aspx)"]
[null,"Exit Report (http://cssr.berkeley.edu/ucb_childwelfare/Exits.aspx)"]
["FILTERS:","See below"]
[]
[null,"Black ","White","Latino","Asian/PI ","Native American",null,"Population Counts"]
["Population \n(9,097,971)",5.6208421570360887,28.403071541247705,53.849614732708758,11.72195099195025,0.40452057705720179,{"$f":"SUM(B13:F13)","v":100},9097971]
["Allegations \n(496,972)",14.627240919656234,24.954729459678518,55.752763679964637,3.7908914109895213,0.87437452971109475,100,496972]
["Substantiations \n(79,179)",14.805994500217096,23.47275765430312,57.445100851282184,3.2340828651500599,1.0420641290475376,99.999999999999986,79179]
["Entries \n(31,667)",18.238332058148433,24.521805661820963,53.500382555470537,2.486610558530987,1.2528691660290743,99.999999999999986,31667]
["In Care \n(54,631)",21.45489211139018,23.508167268594057,51.460208627422219,2.1852714173098429,1.3914605752837004,100,54631]
["Exits* \n(28,177)",17.943591574437701,25.405212424134238,52.866833273830771,2.6204926811852913,1.1638700464119958,100.00000000000001,28177]
[]
["FILTERS:"]
["Allegation and Substantiation Rates:"]
["Time Period:","Most recent available"]
["Row Dimension: ","Ethnic Group"]
["Subgroups:","No restrictions"]
[]
["In Care Rates:"]
["Time Period:","2014-07-01"]
["Row Dimension: ","Ethnic Group"]
["Subgroups:","No restrictions"]
[]
["Exit Rates:"]
["Time Period:","Jan 1, 2014 to Dec 31, 2014"]
["Column Dimension: ","Ethnic Group"]
["Days in Care:","All"]
["Episode Count: ","Children Exiting"]
["Table Output in: ","Count"]
["Subgroups:","Ages 0-18 (Includes both subgroups of 18 year-olds)"]

{"sheet":"table_allegrates","index":18,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[6,1,6,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Allegations per 1000 by age and ethnicity"]
["NOTES:","Need to create separate tables for each ethnicity"]
[null,"Totals in \"(XX.X*)\" will need to be manually updated each quarter"]
[null,"The data for this worksheet, the Substantiations per 1000 by age and ethnicity, and the Entries per 1000 by age and ethnicity are all on the table created by inputting these filters. "]
["OUTPUT TYPE:","Single Time Period (California or Individual County)"]
["SOURCE:","Allegation and Substantiation Rates Reports (http://cssr.berkeley.edu/ucb_childwelfare/RefRates.aspx)"]
["FILTERS:","See below"]
[]
[null,"<1 yr ","1-2 yrs ","3-5 yrs ","6-10 yrs ","11-15 yrs","16-17 yrs","total"]
["Black (134.2*)",211,149.1,148.6,140.69999999999999,117,98.8,134.19999999999999]
["ALL (54.6*)",68.7,52,57.2,58.1,51.6,45.5,54.6]
["White (45.3*)",55.9,38.4,45.7,49.7,44.1,39.200000000000003,45.3]
["Latino (53.4*)",60.5,50.3,55.7,56.8,51.5,45.4,53.4]
["Asian/PI (16.7*)",14.8,12.2,15.9,18.899999999999999,17.5,15.9,16.7]
[]
["FILTERS:"]
["Time Period:","Jan-Dec 2014"]
["Row Dimension:","Age Group"]
["Subgroup Restrictions:","No restriction on gender"]

{"sheet":"table_substantiations","index":20,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[6,1,6,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Substantiations per 1000 by age and ethnicity"]
["NOTES:","Need to create separate tables for each ethnicity"]
[null,"Totals in \"(XX.X*)\" will need to be manually updated each quarter"]
[null,"The data for this worksheet, the Allegations per 1000 by age and ethnicity, and the Entries per 1000 by age and ethnicity are all on the table created by inputting these filters. "]
["OUTPUT TYPE:","Single Time Period (California or Individual County)"]
["SOURCE:","Allegation and Substantiation Rates Reports (http://cssr.berkeley.edu/ucb_childwelfare/RefRates.aspx)"]
["FILTERS:","See below"]
[]
[null,"<1 yr ","1-2 yrs ","3-5 yrs ","6-10 yrs ","11-15 yrs","16-17 yrs","total"]
["Black (23.1*)",73.400000000000006,32.9,26.3,20.7,16.100000000000001,11.6,23.1]
["ALL (8.7*)",22.6,10.8,9.8000000000000007,8.3000000000000007,6.4,4.8,8.6999999999999993]
["White (7.2*)",20.7,8.8000000000000007,8,7,5.2,3.9,7.2]
["Latino (9.3*)",22.5,11.6,10.6,9.1,7,5.3,9.3000000000000007]
["Asian/PI (2.4*)",4.8,2.6,2.5,2.5,2,1.5,2.4]
[]
["FILTERS:"]
["Time Period:","Jan-Dec 2014"]
["Row Dimension:","Age Group"]
["Subgroup Restrictions:","No restriction on gender"]

{"sheet":"table_entrates","index":22,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[6,1,6,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Entries per 1000 by age and ethnicity"]
["NOTES:","Need to create separate tables for each ethnicity"]
[null,"Totals in \"(XX.X*)\" will need to be manually updated each quarter"]
[null,"The data for this worksheet, the Substantiations per 1000 by age and ethnicity, and the Allegations per 1000 by age and ethnicity are all on the table created by inputting these filters. "]
["OUTPUT TYPE:","Single Time Period (California or Individual County)"]
["SOURCE:","Allegation and Substantiation Rates Reports (http://cssr.berkeley.edu/ucb_childwelfare/RefRates.aspx)"]
["FILTERS:","See below"]
[]
[null,"<1 yr ","1-2 yrs ","3-5 yrs ","6-10 yrs ","11-15 yrs","16-17 yrs","total"]
["Black (11.7*)",42.7,17,12.5,9.1,8.4,7.2,11.7]
["ALL (3.5*)",12.2,4.7,3.8,2.8,2.2999999999999998,2,3.5]
["White (3.1*)",12.4,4.2,3.3,2.5,1.9,1.8,3.1]
["Latino (3.6*)",12.2,5,4,3,2.2999999999999998,2,3.6]
["Asian/PI (0.8*)",2.4,0.8,0.8,0.7,0.6,0.6,0.8]
[]
[]
["FILTERS:"]
["Time Period:","Jan-Dec 2014"]
["Row Dimension:","Age Group"]
["Subgroup Restrictions:","No restriction on gender"]

{"sheet":"table_incarerates","index":24,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,17],[5,1,5,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Children in Foster Care per 1000 by age and ethnicity"]
["NOTES:","Need to create separate tables for each ethnic group. "]
[null,"Totals in \"(XX.X*)\" will need to be manually updated each quarter"]
["OUTPUT TYPE:","Single Time Period (California or Individual County)"]
["SOURCE:","In Care Rates reports (http://cssr.berkeley.edu/ucb_childwelfare/InCareRates.aspx)"]
["FILTERS:","See below"]
[]
[null,"<1 yr ","1-2 yrs ","3-5 yrs ","6-10 yrs ","11-15 yrs","16-17 yrs","total"]
["Black (24.0*)",27.7,33.6,23.8,19.100000000000001,21.9,30.4,24]
["ALL (6.0*)",7.8,8.1999999999999993,6.3,5.2,5.0999999999999996,6.8,6]
["White (5.2*)",7.9,7.1,5.4,4.5,4.2,5.8,5.2]
["Latino (6.0*)",8,8.5,6.6,5.4,4.9000000000000004,6.1,6]
["Asian/PI (1.2*)",1.3,1.3,1,1,1.1000000000000001,1.7,1.2]
[]
["Time Period:","2014-07-01"]
["Row Dimension:","Age Group"]
["Subgroup Restrictions:","No restriction on gender"]

{"sheet":"table_racerates","index":26,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[3,1,3,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","Black Children / White Children / Hispanic Children / Asian Pacific Islander Children"]
["NOTES:","Unique children, <18 yrs , no restriction on days in care; all of this data has already been downloaded"]
["SOURCE:","All of the data pulls from the tables for the 3D charts"]
[]
[]
["BLACK","<1 yr","1-2 yrs","3-5 yrs","6-10 yrs","11-15 yrs","16-17 yrs"]
["allegations",{"$f":"table_allegrates!B11","v":211},{"$f":"table_allegrates!C11","v":149.1},{"$f":"table_allegrates!D11","v":148.6},{"$f":"table_allegrates!E11","v":140.69999999999999},{"$f":"table_allegrates!F11","v":117},{"$f":"table_allegrates!G11","v":98.8}]
["substantiations",{"$f":"table_substantiations!B11","v":73.400000000000006},{"$f":"table_substantiations!C11","v":32.9},{"$f":"table_substantiations!D11","v":26.3},{"$f":"table_substantiations!E11","v":20.7},{"$f":"table_substantiations!F11","v":16.100000000000001},{"$f":"table_substantiations!G11","v":11.6}]
["entries",{"$f":"table_entrates!B11","v":42.7},{"$f":"table_entrates!C11","v":17},{"$f":"table_entrates!D11","v":12.5},{"$f":"table_entrates!E11","v":9.1},{"$f":"table_entrates!F11","v":8.4},{"$f":"table_entrates!G11","v":7.2}]
["in care",{"$f":"table_incarerates!B10","v":27.7},{"$f":"table_incarerates!C10","v":33.6},{"$f":"table_incarerates!D10","v":23.8},{"$f":"table_incarerates!E10","v":19.100000000000001},{"$f":"table_incarerates!F10","v":21.9},{"$f":"table_incarerates!G10","v":30.4}]
[]
["WHITE","<1 yr","1-2 yrs","3-5 yrs","6-10 yrs","11-15 yrs","16-17 yrs"]
["allegations",{"$f":"table_allegrates!B13","v":55.9},{"$f":"table_allegrates!C13","v":38.4},{"$f":"table_allegrates!D13","v":45.7},{"$f":"table_allegrates!E13","v":49.7},{"$f":"table_allegrates!F13","v":44.1},{"$f":"table_allegrates!G13","v":39.200000000000003}]
["substantiations",{"$f":"table_substantiations!B13","v":20.7},{"$f":"table_substantiations!C13","v":8.8000000000000007},{"$f":"table_substantiations!D13","v":8},{"$f":"table_substantiations!E13","v":7},{"$f":"table_substantiations!F13","v":5.2},{"$f":"table_substantiations!G13","v":3.9}]
["entries",{"$f":"table_entrates!B13","v":12.4},{"$f":"table_entrates!C13","v":4.2},{"$f":"table_entrates!D13","v":3.3},{"$f":"table_entrates!E13","v":2.5},{"$f":"table_entrates!F13","v":1.9},{"$f":"table_entrates!G13","v":1.8}]
["in care",{"$f":"table_incarerates!B12","v":7.9},{"$f":"table_incarerates!C12","v":7.1},{"$f":"table_incarerates!D12","v":5.4},{"$f":"table_incarerates!E12","v":4.5},{"$f":"table_incarerates!F12","v":4.2},{"$f":"table_incarerates!G12","v":5.8}]
[]
["LATINO","<1 yr","1-2 yrs","3-5 yrs","6-10 yrs","11-15 yrs","16-17 yrs"]
["allegations",{"$f":"table_allegrates!B14","v":60.5},{"$f":"table_allegrates!C14","v":50.3},{"$f":"table_allegrates!D14","v":55.7},{"$f":"table_allegrates!E14","v":56.8},{"$f":"table_allegrates!F14","v":51.5},{"$f":"table_allegrates!G14","v":45.4}]
["substantiations",{"$f":"table_substantiations!B14","v":22.5},{"$f":"table_substantiations!C14","v":11.6},{"$f":"table_substantiations!D14","v":10.6},{"$f":"table_substantiations!E14","v":9.1},{"$f":"table_substantiations!F14","v":7},{"$f":"table_substantiations!G14","v":5.3}]
["entries",{"$f":"table_entrates!B14","v":12.2},{"$f":"table_entrates!C14","v":5},{"$f":"table_entrates!D14","v":4},{"$f":"table_entrates!E14","v":3},{"$f":"table_entrates!F14","v":2.2999999999999998},{"$f":"table_entrates!G14","v":2}]
["in care",{"$f":"table_incarerates!B13","v":8},{"$f":"table_incarerates!C13","v":8.5},{"$f":"table_incarerates!D13","v":6.6},{"$f":"table_incarerates!E13","v":5.4},{"$f":"table_incarerates!F13","v":4.9000000000000004},{"$f":"table_incarerates!G13","v":6.1}]
[]
["ASIAN/PI","<1 yr","1-2 yrs","3-5 yrs","6-10 yrs","11-15 yrs","16-17 yrs"]
["allegations",{"$f":"table_allegrates!B15","v":14.8},{"$f":"table_allegrates!C15","v":12.2},{"$f":"table_allegrates!D15","v":15.9},{"$f":"table_allegrates!E15","v":18.899999999999999},{"$f":"table_allegrates!F15","v":17.5},{"$f":"table_allegrates!G15","v":15.9}]
["substantiations",{"$f":"table_substantiations!B15","v":4.8},{"$f":"table_substantiations!C15","v":2.6},{"$f":"table_substantiations!D15","v":2.5},{"$f":"table_substantiations!E15","v":2.5},{"$f":"table_substantiations!F15","v":2},{"$f":"table_substantiations!G15","v":1.5}]
["entries",{"$f":"table_entrates!B15","v":2.4},{"$f":"table_entrates!C15","v":0.8},{"$f":"table_entrates!D15","v":0.8},{"$f":"table_entrates!E15","v":0.7},{"$f":"table_entrates!F15","v":0.6},{"$f":"table_entrates!G15","v":0.6}]
["in care",{"$f":"table_incarerates!B14","v":1.3},{"$f":"table_incarerates!C14","v":1.3},{"$f":"table_incarerates!D14","v":1},{"$f":"table_incarerates!E14","v":1},{"$f":"table_incarerates!F14","v":1.1000000000000001},{"$f":"table_incarerates!G14","v":1.7}]

{"sheet":"Alleg_overtime_race","index":31,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[4,1,4,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Allegation Rates over Time (Per 1,000), by Race/Ethnicity"]
["NOTES:","Need to create separate tables for each ethnicity"]
["OUTPUT TYPE:","Multiple Time Periods Summary (California and All Counties)"]
["SOURCE:","Allegation and Substantiation Rates reports (http://cssr.berkeley.edu/ucb_childwelfare/RefRates.aspx)"]
["FILTERS:","See below"]
[]
[null,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014]
["Black",112.6,113.4,116.5,117.7,118.7,121.4,126.5,126.6,129.80000000000001,131.1,134.19999999999999]
["White",46.9,45.8,45.5,45.8,44.9,45.4,47.1,46.8,47.3,45.5,45.3]
["Latino",47.7,47.7,49.2,51.2,50.9,50,50.7,50.1,51.5,51.8,53.4]
["Asian/PI",17.3,17.3,17.7,18.3,18.600000000000001,18,16.899999999999999,16.7,17.3,17,16.7]
["Native American",97.7,102,95.2,93.3,91.8,95.8,100.4,99.6,102,104,111.5]
["All",51.2,50.3,50.5,51.5,51,50.7,51.6,51.6,53.2,53,54.6]
[]
["FILTERS:"]
["Statistic:","Allegations: Incidence Per 1,000 Children"]
["Subgroups: ","No restriction on age or gender"]

{"sheet":"Subs_overtime_race","index":33,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[4,1,4,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Substantiation Rates over Time (Per 1,000), by Race/Ethnicity"]
["NOTES:","Need to create separate tables for each ethnicity"]
["OUTPUT TYPE:","Multiple Time Periods Summary (California and All Counties)"]
["SOURCE:","Allegation and Substantiation Rates reports (http://cssr.berkeley.edu/ucb_childwelfare/RefRates.aspx)"]
["FILTERS:","See below"]
[]
[null,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014]
["Black",26.2,26,26.2,26,25.4,25.4,24.2,24.2,24,25.1,23.1]
["White",10.6,10.3,10.1,9.9,9.1999999999999993,8.9,8.6,8.5,8.1999999999999993,7.8,7.2]
["Latino",11.8,11.8,11.9,11.9,10.6,10.4,10.199999999999999,10,9.8000000000000007,9.9,9.3000000000000007]
["Asian/PI",4,4.3,4.3,4.4000000000000004,4,3.5,2.8,2.9,2.7,2.6,2.4]
["Native American",27.1,28.7,26.7,27.7,23.6,23.6,20.3,22.7,24.1,19.5,22.6]
["All",11.6,11.5,11.3,11.2,10.199999999999999,9.9,9.6,9.5,9.3000000000000007,9.1999999999999993,8.6999999999999993]
[]
["FILTERS:"]
["Statistic:","Substantiations: Incidence Per 1,000 Children"]
["Subgroups:","No restriction on age or gender"]

{"sheet":"Entries_overtime_race","index":35,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[4,1,4,17]]}
["EXTRACT:",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Entry Rates over Time (Per 1,000), by Race/Ethnicity"]
["NOTES:","Need to create separate tables for each ethnicity"]
["OUTPUT TYPE:","Multiple Time Periods Summary (California and All Counties)"]
["SOURCE:","Allegation and Substantiation Rates reports (http://cssr.berkeley.edu/ucb_childwelfare/RefRates.aspx)"]
["FILTERS:","See below"]
[]
[null,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014]
["Black",11.1,11.5,11.8,11.4,11.7,11.6,10.9,10.8,11.1,11.8,11.7]
["White",3.5,3.6,3.5,3.2,3,3,3.1,3.1,3.2,3.2,3.1]
["Latino",3.6,3.9,3.9,3.9,3.4,3.4,3.3,3.2,3.4,3.6,3.6]
["Asian/PI",1.1000000000000001,1.2,1.2,1.3,1.1000000000000001,1,0.8,0.9,0.8,0.8,0.8]
["Native American",10.6,11.3,12.1,11.9,10,10,9.6,11.4,12.6,10.5,11.2]
["All",3.7,3.9,3.9,3.8,3.4,3.4,3.3,3.3,3.4,3.5,3.5]
[]
["FILTERS:"]
["Statistic:","Entries: Incidence Per 1,000 Children"]
["Subgroups: ","No restriction on age or gender"]

{"sheet":"Incare_overtime_race","index":37,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[4,1,4,17]]}
["EXTRACT:",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: In Care Rates over Time (Per 1,000), by Race/Ethnicity"]
["NOTES:","Need to create separate tables for each ethnicity"]
["OUTPUT TYPE:","Multiple Time Periods Summary (California and All Counties); Statistic: Entries: Incidence Per 1,000 Children; No restrictrion on age or gender subgroups"]
["SOURCE:","In Care Rates (http://cssr.berkeley.edu/ucb_childwelfare/InCareRates.aspx)"]
["FILTERS:","See below"]
[]
[null,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014]
["Black",39,36.5,34.5,32.299999999999997,29.6,27.9,25.9,24.7,23.4,23.6,24]
["White",6.9,6.7,6.5,6.2,5.6,5.3,5.0999999999999996,5.2,5,5.0999999999999996,5.2]
["Latino",6.9,6.9,6.9,6.9,6.3,5.8,5.4,5.4,5.4,5.7,6]
["Asian/PI",1.6,1.7,1.7,1.7,1.7,1.6,1.4,1.3,1.2,1.2,1.2]
["Native American",21.6,22.2,24.1,23.8,21.9,19.8,20.7,21.6,21.8,22.4,21.6]
["All",8.3000000000000007,8,7.8,7.5,6.8,6.4,5.9,5.8,5.7,5.8,6]
[]
["FILTERS:"]
["Statistic:","Prevalence per 1,000 Children"]
["Subgroups: ","No restriction on age or gender"]

{"sheet":"table_logged_disparity","index":39,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[6,1,6,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Racial Disparity Indices: General Population, 2010 (group compared to White)"]
["NOTES:","To show relative rates / disparity rates, the log of all numbers must be taken, Value lables must be manually entered on the tablein order to reflect the raw disparity numbers (rather than the logged numbers)"]
[null,"Enter the raw numbers into the bottom table; the formulas are in place to create the logged numbers table. "]
[null,"Must create separate tables for each level of system contact"]
["OUTPUT TYPE:","By County and Level of System Contact"]
["SOURCE:","Disparity Indices (http://cssr.berkeley.edu/ucb_childwelfare/DisparityIndices.aspx)"]
["FILTERS:","Age Group: Total (0 to 17 years)"]
[]
["LOGGED NUMBERS","in care","entries","substantiations","allegations"]
["Asian/PI",{"$f":"LOG(B18)","v":-0.64734798048244091},{"$f":"LOG(C18)","v":-0.60957926649510841},{"$f":"LOG(D18)","v":-0.47644756510881553},-0.43404611519197162]
["Latino",6.2435477581381016E-2,6.0987148403182589E-2,0.11087158854747017,7.1296241631178148E-2]
["Native American",0.61867682322652284,{"$f":"LOG(C20)","v":0.55477796440753901},0.49375502114794378,0.39096932191093775]
["Black",{"$f":"LOG(B21)","v":0.66387148073744129},0.57499659017272531,0.50343738680378047,{"$f":"LOG(E21)","v":0.47157346658672239}]
[]
[]
["RAW NUMBERS","in care","entries","substantiations","allegations"]
["Asian/PI",0.2252433715880722,0.24570881278439755,0.33385081047707443,0.36808988625431899]
["Latino",1.1546104333685361,1.1507663350837307,1.2908375445357614,1.1784095179754372]
["Native American",4.1560122905790955,3.5873848060787665,3.11713076245442,2.4601938125987974]
["Black",4.6118107864493902,3.7583445344367306,3.1874060071928292,2.9619209706542264]

{"sheet":"table_logged_disparity_pov","index":41,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[7,1,7,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Racial Disparity Indices: Poverty Population, 2010 (group compared to White)"]
["NOTES:","To show relative rates / disparity rates, the log of all numbers must be taken, Value lables must be manually entered on the tablein order to reflect the raw disparity numbers (rather than the logged numbers)"]
[null,"Enter the raw numbers into the bottom table; the formulas are in place to create the logged numbers table. "]
[null,"Download the excel spreadsheet from the disparity indices page"]
[null,"Must create separate tables for each level of system contact"]
["OUTPUT TYPE:","By County and Level of System Contact"]
["SOURCE:","Disparity Matrix: California 2010 Data--Estimated Population in Poverty (http://cssr.berkeley.edu/ucb_childwelfare/DisparityIndices.aspx)"]
["FILTERS:","Age Group: Total (0 to 17 years)"]
[]
["LOGGED NUMBERS","in care","entries","substantiations","allegations"]
["Asian/PI",{"$f":"LOG(B19)","v":-0.74285400505209342},{"$f":"LOG(C19)","v":-0.70508529106476081},{"$f":"LOG(D19)","v":-0.57195358967846788},-0.52955213976162407]
["Latino",-0.40467838542250356,-0.40612671460070204,-0.35624227445641454,-0.39581762137270649]
["Native American",0.12338046032845953,{"$f":"LOG(C21)","v":5.9481601509475825E-2},-1.5413417501194105E-3,-0.10432704098712534]
["Black",{"$f":"LOG(B22)","v":0.15384245164351842},6.4967561078802666E-2,-6.5916422901422063E-3,{"$f":"LOG(E22)","v":-3.8455562507200391E-2}]
[]
[]
["RAW NUMBERS","in care","entries","substantiations","allegations"]
["Asian/PI",0.18077817382534367,0.19720354101780307,0.26794546459964486,0.29542541905440933]
["Latino",0.39384162490898966,0.39253038964639059,0.4403091651876877,0.401959575242751]
["Native American",1.3285578209012536,1.1467839379354137,0.9964572199697862,0.78645333606690937]
["Black",1.4250905218723973,1.1613618645617196,0.98493678525496731,0.91525990489825804]

{"sheet":"table_C1.3 perm","index":43,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[4,1,4,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Percent Exited to Permanency 60 Months from Entry, First Entries to Care, 8+days"]
["NOTES:","Table produced by CWS/CMS website has several time periods not used by this table (3, 18, and 30 months). "]
["OUTPUT TYPE:","Selected Cohort Over time: Single Time Period Selection (California or Individual County)"]
["SOURCE:","C1.3  - selected cohort over time (http://cssr.berkeley.edu/ucb_childwelfare/C1M3.aspx)"]
["FILTERS:","See below"]
[]
["months","In Care","Other","Emancipated","Guardianship","Adopted ","Reunified"]
[6,72.8,0.6,0.3,0.6,0.1,25.6]
[12,52.4,0.8,0.8,0.8,1.1000000000000001,44]
[24,24.3,1.1000000000000001,1.9,3.8,7.3,61.6]
[36,12.5,1.3,2.9,5.7,14.4,63.2]
[48,7.3,1.4,3.3,6.2,18,63.8]
[60,5,1.5,3.7,6.5,19.2,64.099999999999994]
[]
[]
["Full Cohort Count",10835]
[]
["FILTERS:"]
["Time Period:","Jul 1, 2009 to Dec 31, 2009"]
["Days in Care:","8 Days or More"]
["Episode Count:","First Entry"]
["Table Output in:","Percent"]
["Subgroups:","No Restrictions"]

{"sheet":"table_C1.3 perm_race","index":45,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[4,1,4,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Percent Exited to Permanency 60 Months from Entry, First Entries to Care, 8+days"]
["NOTES:","Table produced by CWS/CMS website has several time periods not used by this table (3, 18, and 30 months). "]
["OUTPUT TYPE:","Selected Cohort Over time: Single Time Period Selection (California or Individual County)"]
["SOURCE:","C1.3  - selected cohort over time (http://cssr.berkeley.edu/ucb_childwelfare/C1M3.aspx)"]
["FILTERS:","See below"]
[]
["white","In Care","Other","Emancipated","Guardianship","Adopted ","Reunified"]
[3,82.8,0.6,0.1,0.4,0.1,15.9]
[6,73.5,0.9,0.4,0.8,0.2,24.2]
[12,49.6,1.2,1.1000000000000001,1,1.8,45.3]
[24,22.4,1.6,2.1,3.3,10.1,60.5]
[36,11.1,1.7,2.9,3.9,18.8,61.6]
[48,6.1,1.7,3.5,4,22.8,62]
[60,4.2,1.8,3.7,4.2,24,62.1]
[]
[3,81.8,0.4,0.2,0.8,0,16.7]
[6,72.8,0.7,0.3,1.1000000000000001,0.1,24.9]
[12,56,0.9,0.8,1.4,0.9,39.9]
[24,29.8,1.4,2.2999999999999998,5.5,5.6,55.3]
[36,16.600000000000001,1.6,3.3,9.8000000000000007,11.4,57.3]
[48,10.7,1.8,3.8,10.7,15,57.9]
[60,7.8,2.1,4.4000000000000004,11.1,16.399999999999999,58.1]
["black","In Care","Other","Emancipated","Guardianship","Adopted ","Reunified"]
[]
["Black Cohort Count",2004,{"$f":"A24 & \" (n=\" & TEXT(B26,\"#,##0\") & \")\"","v":"black (n=2,004)"}]
["White Cohort Count",2774,{"$f":"A8& \" (n=\" & TEXT(B27,\"#,##0\") & \")\"","v":"white (n=2,774)"}]
[]
["FILTERS:"]
["Time Period:",{"$f":"'table_C1.3 perm'!B20","v":"Jul 1, 2009 to Dec 31, 2009"}]
["Days in Care:","8 Days or More"]
["Episode Count:","First Entry"]
["Table Output in:","Percent"]
["Subgroups:","No restrictions on age, gender, first placement type, first caregiver relationship, last placement type, last caregiver relationship, and removal reason"]
[null,"For Black tables, check black as the ethnic group"]
[null,"For White tables, check white as the ethnic group"]

{"sheet":"table_C1.3 perm_raceplctype","index":47,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[5,1,5,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Percent Exited to Permanency 60 Months from Entry, First Entries to Care, 8+days"]
["NOTES:","Table produced by CWS/CMS website has several time periods not used by this table (3, 18, and 30 months). "]
[null,"Table produced by CWS/CMS website has several time periods not used by this table (3, 18, and 30 months). "]
["OUTPUT TYPE:","Selected Cohort Over time: Single Time Period Selection (California or Individual County)"]
["SOURCE:","C1.3  - selected cohort over time (http://cssr.berkeley.edu/ucb_childwelfare/C1M3.aspx)"]
["FILTERS:","See below"]
[]
["white, relative placements",1022,{"$f":"A9 & \" (n=\" & TEXT(B9,\"#,##0\") & \")\"","v":"white, relative placements (n=1,022)"},null,null,null,null,null,"black, relative placements",758,{"$f":"I9 & \" (n=\" & TEXT(J9,\"#,##0\") & \")\"","v":"black, relative placements (n=758)"}]
["WHITE w/KIN","In Care","Other","Emancipated","Guardianship","Adopted ","Reunified",null,"BLACK w/KIN","In Care","Other","Emancipated","Guardianship","Adopted ","Reunified"]
[12,50.3,0.3,0.7,2,0.4,46.4,null,12,63.6,0.4,0.4,1.5,0.7,33.5]
[24,20.2,0.5,1.3,6.8,7.7,63.6,null,24,32.799999999999997,0.8,1.1000000000000001,9.8000000000000007,4.0999999999999996,51.5]
[36,7.3,0.5,1.4,8.1,17.899999999999999,64.8,null,36,15,0.9,1.8,17.7,11.1,53.4]
[48,3.7,0.5,1.4,8.1,21.3,65,null,48,7.5,0.9,2,19.8,16,53.8]
[60,1.7,0.6,1.4,8.6999999999999993,22.6,65.099999999999994,null,60,4.7,1.1000000000000001,2,20.8,17.5,53.8]
["white, non-relative placements",1730,{"$f":"A16 & \" (n=\" & TEXT(B16,\"#,##0\") & \")\"","v":"white, non-relative placements (n=1,730)"},null,null,null,null,null,"black, non-relative placements",1214,{"$f":"I16 & \" (n=\" & TEXT(J16,\"#,##0\") & \")\"","v":"black, non-relative placements (n=1,214)"}]
["White w/NONKIN","In Care","Other","Emancipated","Guardianship","Adopted ","Reunified",null,"BLACK w/NONKIN","In Care","Other","Emancipated","Guardianship","Adopted ","Reunified"]
[12,48.6,1.7,1.3,0.5,2.7,45.3,null,12,50.1,1.3,1.1000000000000001,1.4,1.2,45]
[24,22.8,2.2999999999999998,2.6,1.3,11.6,59.5,null,24,26.1,1.8,3.1,3,6.8,59.1]
[36,12.1,2.5,3.9,1.4,19.600000000000001,60.5,null,36,15.4,2,4.3,5.0999999999999996,11.9,61.3]
[48,6.4,2.5,4.7,1.6,23.9,60.9,null,48,10.5,2.4,5,5.3,14.8,61.9]
[60,4.5999999999999996,2.5,5,1.6,25.1,61.1,null,60,8.4,2.5,5.3,5.4,16.100000000000001,62.4]
[]
["FILTERS:"]
["Time Period:",{"$f":"'table_C1.3 perm'!B20","v":"Jul 1, 2009 to Dec 31, 2009"}]
["Days in Care:","8 Days or More"]
["Episode Count:","First Entry"]
["Table Output in:","Percent"]
["Subgroups:","No restrictions on age, gender, first placement type, first caregiver relationship, last placement type, and removal reason"]
[null,"For Kin Tables, check subgroup \"Last Caregiver Relationship: Relative Guardian; Relative NonGuardian\""]
[null,"For NonKin tables, check subgroup \"Last Caregiver Relationship: Nonrelative Guardian; Nonrelative Nonguardian\""]
[null,"For Black tables, check black as the ethnic group"]
[null,"For White tables, check white as the ethnic group"]

{"sheet":"table_servcomponents","index":52,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[8,1,8,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Caseload Case Service Components by Race/Ethnicity (missing values and other race excluded from % calculations, children of all ages included)"]
["NOTES:","Must populate caseload size numbers from raw data"]
[null,"In order to calculate percentages, divide race count by (total-missing)*100"]
[null,"Sample Formula: Black Total Caseload/(Total Caseload-Missing Total Caseload)*100"]
[null,"SUM CHECK ensures that the missing have been subtracted out; all of the rows should add up to 100.  "]
[null,"Must manually change numbers in parentheses"]
["OUTPUT TYPE:","Single Time Period (California or Individual County)"]
["SOURCE:","Foster Care: Point in Time/Case Service Components (http://cssr.berkeley.edu/ucb_childwelfare/CaseServiceComponents.aspx)"]
["FILTERS:","See below"]
[]
[null,"Black ","White","Latino","Asian/PI ","Native American","SUM CHECK"]
["Total Caseload \n(94,316)",20.343934240967197,21.838651556019915,54.065695064874141,2.5032783564506325,1.2484407816881138,{"$f":"SUM(B13:F13)","v":100}]
["Emergency Response \n(3,726)",18.285873813512005,22.724734785036294,54.299274148520382,2.5404801786711335,2.1496370742601898,100]
["No Placement \nFamily Maintenance\n(16,707)",15.027157513578757,15.890162945081473,64.665057332528662,3.5244417622208815,0.89318044659022333,99.999999999999986]
["Post-Placement \nFamily Maintenance \n(8,702)",16.148710865561693,21.995856353591158,58.839779005524861,2.4286372007366483,0.58701657458563539,99.999999999999986]
["Family Reunification \n(27,776)",18.73554077501446,22.205754771544246,55.852371312897631,2.0387507229612489,1.1675824175824177,100.00000000000001]
["Permanent  Placement \n(30,806)",24.208881364761037,24.081911707253546,47.916395363979689,2.1942961323088945,1.5985154316968355,100]
["Supportive Transition\n(6,599)",29.116618519081648,24.114337844001824,42.131670974608483,3.4058081192032845,1.231564543104759,{"$f":"SUM(B19:F19)","v":99.999999999999986}]
[]
["Caseload N",94316]
["ER N",3726]
["No Placement FM N",16707]
["Post Placement FM N",8702]
["FR N",27776]
["Perm Place N",30806]
["Supp Trans N",6599]
[]
["FILTERS:"]
["Time Period","2015-01-01"]
["View Service Component Types As:","Column Dimension"]
["Table Out:","Count"]
["Row Dimension:","Ethnic Group"]
["Subgroups:","No Restrictions"]

{"sheet":"table_servcomponents_time","index":54,"n_rows":19,"n_cols":42,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[4,1,4,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Caseload Case Service Components: 2000-2013, children of all ages included)"]
["NOTES:","Supportive Transition excluded from table"]
["OUTPUT TYPE:","Multiple Time Periods Summary (California and All Counties)"]
["SOURCE:","Foster Care: Point in Time/Case Service Components (http://cssr.berkeley.edu/ucb_childwelfare/CaseServiceComponents.aspx)"]
["FILTERS:","See below"]
[]
[null,2005,null,null,null,2006,null,null,null,2007,null,null,null,2008,null,null,null,2009,null,null,null,2010,null,null,null,2011,null,null,null,2012,null,null,null,2013,null,null,null,2014,null,null,null,2015]
["Emergency Response",4234,4815,4458,4759,4565,4679,4471,4743,4163,4743,4200,4450,3800,3652,3639,3694,3224,3421,3319,3874,4031,4501,4554,4591,4199,4486,4022,4040,3913,4392,4220,4394,4189,4323,4347,4475,4348,4579,4736,4657,3726]
["No Placement FM",17101,17977,18576,18063,18031,18239,17966,17774,18606,18868,18766,18232,18549,18782,17547,16397,16318,15994,15878,15080,15151,15427,15848,16297,17120,17946,18540,18436,18374,18164,18464,18402,18156,18017,17924,17718,17765,17752,17249,16828,16707]
["Post-Placement FM",11217,10783,10823,10859,10949,10917,10913,11405,11748,11696,11997,12460,12510,12319,12447,12404,11980,11769,11252,11160,10962,10560,10263,10146,9820,9895,10185,10370,10243,9991,9821,9718,9321,9181,9042,9285,9377,9417,9454,9402,8702]
["Family Reunification",24772,25458,25756,26136,25869,26127,26204,25820,26265,26415,26973,26711,26061,25018,24054,23585,23178,22910,22753,22767,22579,22057,22274,22774,23230,23148,23120,23007,22651,22435,22810,22963,23525,23821,24841,25553,25940,25504,25997,26793,27776]
["Permanent Placement",65321,64845,64623,63672,63399,62244,60387,55897,53670,52995,51650,50353,48887,48466,47284,45568,44159,43662,42448,40916,39595,39121,38222,37097,36402,36123,35514,34380,32917,32550,31757,31065,30521,30615,30384,30299,30254,31082,31211,31072,30806]
[]
[]
["FILTERS:"]
["Table Out:","Count"]
["Point in Time:","All"]
["Subgroups:","No Restrictions"]

{"sheet":"table_plcmt_dist","index":56,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,1,4,20],[1,1,1,20],[2,1,2,20]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Children Still in Care 12m After Entry, Placement Distance from Home by Kin vs. Non-Kin (missing values excluded from % calculations)"]
["NOTES:","Note: Because of rounding, some totals do not add up to 100 - so slight changes were made to reflect a perfect sum; download data into Datadude tool"]
[null,"SUM CHECK ensures that all of the rows add up to 100.  "]
["SOURCE:","Distances (http://cssr.berkeley.edu/ucb_childwelfare/Distances.aspx)"]
["FILTERS:","N/A"]
[]
[null,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013]
["With Kin, <5 mile",57.099999999999994,60.4,59.5,62.3,61.099999999999994,61.8,61.2,60.7,61.3,61.099999999999994]
["With Kin, 11+ miles",31.3,28.8,29.3,27.3,28.6,28.7,28.1,27.8,28.3,28.3]
["Not with Kin, <5 mile",36.200000000000003,37.9,38.200000000000003,38.9,39.400000000000006,42.2,43.4,39.6,39.4,38.299999999999997]
["Not with Kin, 11+ miles",45.3,44.6,43.3,44.1,44.1,42.4,38.9,42.2,43.3,44.8]

{"sheet":"table_siblings","index":58,"n_rows":10,"n_cols":42,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[4,1,4,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Placement with All or Some Siblings"]
["NOTES:","Use Datadude tool"]
["OUTPUT TYPE:","Summary Tables"]
["SOURCE:","Sibling Report (http://cssr.berkeley.edu/ucb_childwelfare/siblings.aspx)"]
["FILTERS:","N/A. Datadude Tool."]
[]
[null,2005,null,null,null,2006,null,null,null,2007,null,null,null,2008,null,null,null,2009,null,null,null,2010,null,null,null,2011,null,null,null,2012,null,null,null,2013,null,null,null,2014,null,null,null,2015]
["Placement with All Siblings ",42,41.8,42.1,42.8,43.2,43,43.5,43.6,44.6,44.6,45.3,46,46.1,46.4,46.7,47.2,47.7,48,48.9,49.4,50.3,50.5,50.9,51.3,51.8,52.1,52.8,53.5,53.5,53.3,53.8,54.4,54.3,54.5,54.5,55.1,55.2,55.3,54.4,54.4,53.8]
["Placement with All or Some Siblings ",66.099999999999994,66.099999999999994,66.099999999999994,66.5,66.599999999999994,66.400000000000006,66.400000000000006,66.8,67.099999999999994,67.400000000000006,67.8,68.3,68.3,68.5,68.5,69,69.3,69.599999999999994,70.099999999999994,70.599999999999994,71,71.099999999999994,71.400000000000006,71.900000000000006,72,72.2,72.7,73.2,73.3,72.900000000000006,73.2,73.599999999999994,73.400000000000006,73.400000000000006,73.7,74.2,74.2,74.2,73.7,73.5,73.3]

{"sheet":"table_recurrence","index":60,"n_rows":36,"n_cols":24,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,19,8,23],[16,1,16,4],[16,6,16,9],[16,11,16,14],[16,16,16,19],[1,1,1,17],[4,1,4,17],[8,0,10,0],[8,1,8,5],[8,7,8,11],[8,13,8,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Recurrence of Allegations Over 24 Months, by base and follow-up disposition type"]
["NOTES:","Must manually update base period in title, manually enter base numbers in text boxes; base numbers are obtained same as percents; simply change output count; reformatted table is linked to cells in raw table, so does not need to be changed"]
["OUTPUT TYPE:","Selected Base Period Over Time: Single Time Period (California or Individual County)"]
["SOURCE:","Recurrence tables (http://cssr.berkeley.edu/ucb_childwelfare/RecurAlleg.aspx)"]
["FILTERS:","See below"]
[]
["RAW TABLE"]
["Base Disp","Recur 6 mos. Disposition",null,null,null,null,null,"Recur 12 mos. Disposition",null,null,null,null,null,"Recur 18 mos. Disposition",null,null,null,null,null,"Recur 24 mos. Disposition"]
[null,"S","I","U","A","N",null,"S","I","U","A","N",null,"S","I","U","A","N",null,"S","I","U","A","N"]
[null,"6m","6m","6m","6m","6m",null,"12m","12m","12m","12m","12m",null,"18m","18m","18m","18m","18m",null,"24m","24m","24m","24m","24m"]
["S",6.5,3.7,6.2,7.6,76,null,10.3,6.1,9.6,8.5,65.5,null,12.9,7.8,11.7,8.6,59,null,15,9,12.9,8.8000000000000007,54.2]
["I",5.5,6.5,6.3,6.1,75.599999999999994,null,9.4,9.6,9.1,6.6,65.3,null,12.1,11.3,10.7,6.8,59.1,null,14.2,12.7,11.3,7.1,54.7]
["U",3.2,3.2,8.5,5.4,79.7,null,5.9,5.5,12.4,6.2,69.900000000000006,null,7.8,7.3,14.5,6.6,63.8,null,9.4,8.6,15.7,7,59.3]
["A",4,4.2,8.3000000000000007,9,74.599999999999994,null,6.2,6,10.9,10.5,66.400000000000006,null,7.8,7.4,12.3,11.1,61.4,null,9.1,8.4,13.1,11.4,58.1]
[]
["REFORMATTED TABLE","substantiated",null,null,null,null,"inconclusive",null,null,null,null,"unfounded",null,null,null,null,"assessment only"]
[null,"6m","12m","18m","24m",null,"6m","12m","18m","24m",null,"6m","12m","18m","24m",null,"6m","12m","18m","24m"]
["substantiated",{"$f":"$B$12","v":6.5},{"$f":"$H$12","v":10.3},{"$f":"$N$12","v":12.9},{"$f":"$T$12","v":15},null,{"$f":"$B$13","v":5.5},{"$f":"$H$13","v":9.4},{"$f":"$N$13","v":12.1},{"$f":"$T$13","v":14.2},null,{"$f":"$B$14","v":3.2},{"$f":"$H$14","v":5.9},{"$f":"$N$14","v":7.8},{"$f":"$T$14","v":9.4},null,{"$f":"$B$15","v":4},{"$f":"$H$15","v":6.2},{"$f":"$N$15","v":7.8},{"$f":"$T$15","v":9.1}]
["inconclusive",{"$f":"$C$12","v":3.7},{"$f":"$I$12","v":6.1},{"$f":"$O$12","v":7.8},{"$f":"$U$12","v":9},null,{"$f":"$C$13","v":6.5},{"$f":"$I$13","v":9.6},{"$f":"$O$13","v":11.3},{"$f":"$U$13","v":12.7},null,{"$f":"$C$14","v":3.2},{"$f":"$I$14","v":5.5},{"$f":"$O$14","v":7.3},{"$f":"$U$14","v":8.6},null,{"$f":"$C$15","v":4.2},{"$f":"$I$15","v":6},{"$f":"$O$15","v":7.4},{"$f":"$U$15","v":8.4}]
["unsubstantiated",{"$f":"$D$12","v":6.2},{"$f":"$J$12","v":9.6},{"$f":"$P$12","v":11.7},{"$f":"$V$12","v":12.9},null,{"$f":"$D$13","v":6.3},{"$f":"$J$13","v":9.1},{"$f":"$P$13","v":10.7},{"$f":"$V$13","v":11.3},null,{"$f":"$D$14","v":8.5},{"$f":"$J$14","v":12.4},{"$f":"$P$14","v":14.5},{"$f":"$V$14","v":15.7},null,{"$f":"$D$15","v":8.3000000000000007},{"$f":"$J$15","v":10.9},{"$f":"$P$15","v":12.3},{"$f":"$V$15","v":13.1}]
["assessment only",{"$f":"$E$12","v":7.6},{"$f":"$K$12","v":8.5},{"$f":"$Q$12","v":8.6},{"$f":"$W$12","v":8.8000000000000007},null,{"$f":"$E$13","v":6.1},{"$f":"$K$13","v":6.6},{"$f":"$Q$13","v":6.8},{"$f":"$W$13","v":7.1},null,{"$f":"$E$14","v":5.4},{"$f":"$K$14","v":6.2},{"$f":"$Q$14","v":6.6},{"$f":"$W$14","v":7},null,{"$f":"$E$15","v":9},{"$f":"$K$15","v":10.5},{"$f":"$Q$15","v":11.1},{"$f":"$W$15","v":11.4}]
[]
["Base Counts"]
["S",34503]
["I",40089]
["U",90920]
["A",62554]
[]
["FILTERS:"]
["Exclude At Risk, Sibling Abused and Substantial Risk Allegations as excluded in the Federal CFSR Measure S1.1:",null,null,null,null,null,null,null,null,null,null,"Exclude"]
["Apply Restriction on Disposition Dates as applied in the Federal CFSR Measure S1.1*:",null,null,null,null,null,null,null,null,null,null,"Do Not Apply"]
["Limit Report to First Allegation**:",null,null,null,null,null,null,null,null,null,null,"No"]
["Limit Report to Children Not Removed from Home***:",null,null,null,null,null,null,null,null,null,null,"No"]
["Time Period:",null,null,null,null,null,null,null,null,null,null,"July 1, 2012 - December 31, 2012"]
["Table Output in:",null,null,null,null,null,null,null,null,null,null,"Percent (Also need to access count data in order to obtain data for \"Base Counts\" table)"]

{"sheet":"table_perm_raw","index":62,"n_rows":20,"n_cols":44,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Exits to permanency over time, by placement type"]
["NOTES:","Data needs to be reverse-sorted once it is obtained; first entries into care; 8+ days in care; limited to 120 months (10 years) in care"]
["SOURCE:","C1.3 - Exit Status at Most Recent Available Follow-up Period (http://cssr.berkeley.edu/ucb_childwelfare/C1M3.aspx)"]
["FILTERS:","Data below have been reverse sorted by row 8"]
[]
["California"]
[null,43,42,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1]
[]
["Interval","JAN2014-JUN2014","JAN2014-JUN2014","OCT2013-MAR2014","JUL2013-DEC2013","APR2013-SEP2013","JAN2013-JUN2013","OCT2012-MAR2013","JUL2012-DEC2012","APR2012-SEP2012","JAN2012-JUN2012","OCT2011-MAR2012","JUL2011-DEC2011","APR2011-SEP2011","JAN2011-JUN2011","OCT2010-MAR2011","JUL2010-DEC2010","APR2010-SEP2010","JAN2010-JUN2010","OCT2009-MAR2010","JUL2009-DEC2009","APR2009-SEP2009","JAN2009-JUN2009","OCT2008-MAR2009","JUL2008-DEC2008","APR2008-SEP2008","JAN2008-JUN2008","OCT2007-MAR2008","JUL2007-DEC2007","APR2007-SEP2007","JAN2007-JUN2007","OCT2006-MAR2007","JUL2006-DEC2006","APR2006-SEP2006","JAN2006-JUN2006","OCT2005-MAR2006","JUL2005-DEC2005","APR2005-SEP2005","JAN2005-JUN2005","OCT2004-MAR2005","JUL2004-DEC2004","APR2004-SEP2004","JAN2004-JUN2004","OCT2003-MAR2004"]
[null,"3 months","6 months","6 months","12 months","12 months","18 months","18 months","24 months","24 months","30 months","30 months","36 months","36 months","36 months","36 months","48 months","48 months","48 months","48 months","60 months","60 months","60 months","60 months","72 months","72 months","72 months","72 months","84 months","84 months","84 months","84 months","96 months","96 months","96 months","96 months","108 months","108 months","108 months","108 months","120 months","120 months","120 months","120 months"]
[null,null,null,"%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%","%"]
["PERCENT"]
["Reunified",12,18.8,19.899999999999999,35.5,35.4,47.5,49.1,53.8,54.6,56.5,56.5,57.7,58.6,61,61.3,60.4,60.9,61.9,63.2,64.099999999999994,63.8,63.5,63.1,63.3,63.8,64.599999999999994,64.099999999999994,63.9,64.3,64.5,63.4,60.8,60.6,61,60,58.5,58.2,58.8,57.4,57,58,58.6,58.2]
["Adopted",0,0,".",1.1000000000000001,0.9,4,3.9,8.4,8.1,12.9,12.8,16.899999999999999,16.3,14.8,15,19.600000000000001,19.600000000000001,18.899999999999999,18.100000000000001,19.2,19.3,19.5,20.100000000000001,20.3,19,18,18.8,19.8,19.899999999999999,20,21,22.5,23.1,23.1,24.3,25.9,25.4,24.2,25,25.6,24.5,23.7,23.9]
["Guardianship",0.1,0.2,0.3,1.1000000000000001,1.2,3.2,2.9,5.7,5.7,7.1,7.3,7.9,7.2,6.7,7,7.7,7.4,7.4,6.7,6.5,6.8,6.6,6,6.5,6.8,6.6,6.7,6.9,6.8,6.6,6.4,7.2,7.1,6.5,6.2,6.1,6.5,6.9,7.6,7.4,6.9,6.9,6.6]
["Emancipated",0.1,0.2,0.2,0.3,0.4,0.7,0.8,0.9,0.8,1.2,1.3,1.3,1.5,1.7,1.8,2.4,2.9,3.1,3.2,3.7,3.7,4.0999999999999996,4.7,4.9000000000000004,4.5999999999999996,4.8,5.0999999999999996,5.0999999999999996,4.8,4.8,4.7,5.3,5.0999999999999996,5.2,5.4,5.4,5.3,5.7,5.8,5.7,5.9,5.9,6.5]
["Other",0.3,0.6,0.5,0.7,0.8,0.9,0.8,1,0.9,1.1000000000000001,1.1000000000000001,1.3,1.2,1.1000000000000001,0.9,1.2,1.2,1.2,1.2,1.5,1.7,1.5,1.6,1.7,1.7,1.8,1.7,1.7,1.8,2,2.2000000000000002,2.4,2.4,2.4,2.4,2.9,3.2,2.9,2.7,2.8,3.1,3.4,3.4]
["Still in care",87.5,80.2,79.2,61.2,61.4,43.7,42.5,30.2,29.8,21.3,21,14.9,15.2,14.6,14,8.6,8,7.7,7.5,5,4.8,4.9000000000000004,4.5999999999999996,3.5,4.0999999999999996,4,3.7,2.6,2.2999999999999998,2.2000000000000002,2.2000000000000002,1.8,1.7,1.8,1.7,1.3,1.5,1.4,1.6,1.5,1.5,1.5,1.3]
["Total",100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]

{"sheet":"table_perm_overtime","index":63,"n_rows":18,"n_cols":45,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[7,37,7,40],[7,41,7,44],[7,13,7,16],[7,17,7,20],[7,21,7,24],[7,25,7,28],[7,29,7,32],[7,33,7,36],[7,1,7,2],[7,3,7,4],[7,5,7,6],[7,9,7,10],[3,1,3,17]]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: Exits to permanency over time, by placement type"]
["NOTES:","Data needs to be reverse-sorted once it is obtained; unique children entering care, no restriction on days in care"]
["SOURCE:","C1.3 - Exit Status at Most Recent Available Follow-up Period (http://cssr.berkeley.edu/ucb_childwelfare/C1M3.aspx)"]
["FILTERS:","See below"]
[]
[null,"3 months","3 months","6 months","6 months","12 months","12 months","18 months","18 months","24 months","24 months","30 months","30 months","36 months","36 months","36 months","36 months","48 months","48 months","48 months","48 months","60 months","60 months","60 months","60 months","72 months","72 months","72 months","72 months","84 months","84 months","84 months","84 months","96 months","96 months","96 months","96 months","108 months","108 months","108 months","108 months","120 months","120 months","120 months","120 months"]
[null,"3m",null,"6m",null,"1yr",null,null,null,"2yrs",null,null,null,"3yrs",null,null,null,"4yrs",null,null,null,"5yrs",null,null,null,"6yrs",null,null,null,"7yrs",null,null,null,"8yrs",null,null,null,"9yrs",null,null,null,"10yrs"]
["Reunified",null,{"$f":"table_perm_raw!B14","v":12},{"$f":"table_perm_raw!C14","v":18.8},{"$f":"table_perm_raw!D14","v":19.899999999999999},{"$f":"table_perm_raw!E14","v":35.5},{"$f":"table_perm_raw!F14","v":35.4},{"$f":"table_perm_raw!G14","v":47.5},{"$f":"table_perm_raw!H14","v":49.1},{"$f":"table_perm_raw!I14","v":53.8},{"$f":"table_perm_raw!J14","v":54.6},{"$f":"table_perm_raw!K14","v":56.5},{"$f":"table_perm_raw!L14","v":56.5},{"$f":"table_perm_raw!M14","v":57.7},{"$f":"table_perm_raw!N14","v":58.6},{"$f":"table_perm_raw!O14","v":61},{"$f":"table_perm_raw!P14","v":61.3},{"$f":"table_perm_raw!Q14","v":60.4},{"$f":"table_perm_raw!R14","v":60.9},{"$f":"table_perm_raw!S14","v":61.9},{"$f":"table_perm_raw!T14","v":63.2},{"$f":"table_perm_raw!U14","v":64.099999999999994},{"$f":"table_perm_raw!V14","v":63.8},{"$f":"table_perm_raw!W14","v":63.5},{"$f":"table_perm_raw!X14","v":63.1},{"$f":"table_perm_raw!Y14","v":63.3},{"$f":"table_perm_raw!Z14","v":63.8},{"$f":"table_perm_raw!AA14","v":64.599999999999994},{"$f":"table_perm_raw!AB14","v":64.099999999999994},{"$f":"table_perm_raw!AC14","v":63.9},{"$f":"table_perm_raw!AD14","v":64.3},{"$f":"table_perm_raw!AE14","v":64.5},{"$f":"table_perm_raw!AF14","v":63.4},{"$f":"table_perm_raw!AG14","v":60.8},{"$f":"table_perm_raw!AH14","v":60.6},{"$f":"table_perm_raw!AI14","v":61},{"$f":"table_perm_raw!AJ14","v":60},{"$f":"table_perm_raw!AK14","v":58.5},{"$f":"table_perm_raw!AL14","v":58.2},{"$f":"table_perm_raw!AM14","v":58.8},{"$f":"table_perm_raw!AN14","v":57.4},{"$f":"table_perm_raw!AO14","v":57},{"$f":"table_perm_raw!AP14","v":58},{"$f":"table_perm_raw!AQ14","v":58.6},{"$f":"table_perm_raw!AR14","v":58.2}]
["Adopted",null,{"$f":"table_perm_raw!B15","v":0},{"$f":"table_perm_raw!C15","v":0},{"$f":"table_perm_raw!D15","v":"."},{"$f":"table_perm_raw!E15","v":1.1000000000000001},{"$f":"table_perm_raw!F15","v":0.9},{"$f":"table_perm_raw!G15","v":4},{"$f":"table_perm_raw!H15","v":3.9},{"$f":"table_perm_raw!I15","v":8.4},{"$f":"table_perm_raw!J15","v":8.1},{"$f":"table_perm_raw!K15","v":12.9},{"$f":"table_perm_raw!L15","v":12.8},{"$f":"table_perm_raw!M15","v":16.899999999999999},{"$f":"table_perm_raw!N15","v":16.3},{"$f":"table_perm_raw!O15","v":14.8},{"$f":"table_perm_raw!P15","v":15},{"$f":"table_perm_raw!Q15","v":19.600000000000001},{"$f":"table_perm_raw!R15","v":19.600000000000001},{"$f":"table_perm_raw!S15","v":18.899999999999999},{"$f":"table_perm_raw!T15","v":18.100000000000001},{"$f":"table_perm_raw!U15","v":19.2},{"$f":"table_perm_raw!V15","v":19.3},{"$f":"table_perm_raw!W15","v":19.5},{"$f":"table_perm_raw!X15","v":20.100000000000001},{"$f":"table_perm_raw!Y15","v":20.3},{"$f":"table_perm_raw!Z15","v":19},{"$f":"table_perm_raw!AA15","v":18},{"$f":"table_perm_raw!AB15","v":18.8},{"$f":"table_perm_raw!AC15","v":19.8},{"$f":"table_perm_raw!AD15","v":19.899999999999999},{"$f":"table_perm_raw!AE15","v":20},{"$f":"table_perm_raw!AF15","v":21},{"$f":"table_perm_raw!AG15","v":22.5},{"$f":"table_perm_raw!AH15","v":23.1},{"$f":"table_perm_raw!AI15","v":23.1},{"$f":"table_perm_raw!AJ15","v":24.3},{"$f":"table_perm_raw!AK15","v":25.9},{"$f":"table_perm_raw!AL15","v":25.4},{"$f":"table_perm_raw!AM15","v":24.2},{"$f":"table_perm_raw!AN15","v":25},{"$f":"table_perm_raw!AO15","v":25.6},{"$f":"table_perm_raw!AP15","v":24.5},{"$f":"table_perm_raw!AQ15","v":23.7},{"$f":"table_perm_raw!AR15","v":23.9}]
["Guardianship",null,{"$f":"table_perm_raw!B16","v":0.1},{"$f":"table_perm_raw!C16","v":0.2},{"$f":"table_perm_raw!D16","v":0.3},{"$f":"table_perm_raw!E16","v":1.1000000000000001},{"$f":"table_perm_raw!F16","v":1.2},{"$f":"table_perm_raw!G16","v":3.2},{"$f":"table_perm_raw!H16","v":2.9},{"$f":"table_perm_raw!I16","v":5.7},{"$f":"table_perm_raw!J16","v":5.7},{"$f":"table_perm_raw!K16","v":7.1},{"$f":"table_perm_raw!L16","v":7.3},{"$f":"table_perm_raw!M16","v":7.9},{"$f":"table_perm_raw!N16","v":7.2},{"$f":"table_perm_raw!O16","v":6.7},{"$f":"table_perm_raw!P16","v":7},{"$f":"table_perm_raw!Q16","v":7.7},{"$f":"table_perm_raw!R16","v":7.4},{"$f":"table_perm_raw!S16","v":7.4},{"$f":"table_perm_raw!T16","v":6.7},{"$f":"table_perm_raw!U16","v":6.5},{"$f":"table_perm_raw!V16","v":6.8},{"$f":"table_perm_raw!W16","v":6.6},{"$f":"table_perm_raw!X16","v":6},{"$f":"table_perm_raw!Y16","v":6.5},{"$f":"table_perm_raw!Z16","v":6.8},{"$f":"table_perm_raw!AA16","v":6.6},{"$f":"table_perm_raw!AB16","v":6.7},{"$f":"table_perm_raw!AC16","v":6.9},{"$f":"table_perm_raw!AD16","v":6.8},{"$f":"table_perm_raw!AE16","v":6.6},{"$f":"table_perm_raw!AF16","v":6.4},{"$f":"table_perm_raw!AG16","v":7.2},{"$f":"table_perm_raw!AH16","v":7.1},{"$f":"table_perm_raw!AI16","v":6.5},{"$f":"table_perm_raw!AJ16","v":6.2},{"$f":"table_perm_raw!AK16","v":6.1},{"$f":"table_perm_raw!AL16","v":6.5},{"$f":"table_perm_raw!AM16","v":6.9},{"$f":"table_perm_raw!AN16","v":7.6},{"$f":"table_perm_raw!AO16","v":7.4},{"$f":"table_perm_raw!AP16","v":6.9},{"$f":"table_perm_raw!AQ16","v":6.9},{"$f":"table_perm_raw!AR16","v":6.6}]
[]
[]
["FILTERS:"]
["Report Type","Exit Status at Most Recent Available Follow Up Period:"]
["Days in Care","8 days"]
["Episode Count","First Entry"]
["Interval","All"]

{"sheet":"table_C3.1","index":65,"n_rows":19,"n_cols":58,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["EXTRACT: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"California: C3.1: Exits to Permanency (24m in Care), by exit type"]
["NOTES:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total comes from count, not percent; %Exits to Permanency will not come up on table, that row has the formula in it necessary for the calculation"]
["URL:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multiple Time Periods (California or Individual County)"]
["SOURCE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C3.1 (http://cssr.berkeley.edu/ucb_childwelfare/C3M1.aspx)"]
["FILTERS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"See below"]
[]
[null,1998,null,null,null,1999,null,null,null,2000,null,null,null,2001,null,null,null,2004,null,null,null,2005,null,null,null,2006,null,null,null,2007,null,null,null,2008,null,null,null,2009,null,null,null,2010,null,null,null,2011,null,null,null,2012,null,null,null,2013,null,null,null,2014]
["% Reunified",3.3,3.8,4.2,4.5,4.9000000000000004,5.6,7.1,7.8,8.3000000000000007,8.4,7.3,6.3,5.6,5.2,5.0999999999999996,5.0999999999999996,4.8,4.5999999999999996,4.5,4.3,4.5,4.4000000000000004,4.0999999999999996,4,3.8,3.8,3.9,3.8,3.7,3.5,3.5,3.6,3.8,3.6,3.6,3.4,3.7,3.9,4,3.9,3.8,4,4,4.0999999999999996,4.0999999999999996,3.8,3.7,3.4,3.4,3.5,3.5,3.1,3.2,3.2,3.3,3.2,3.1]
["% Guardianship",1.2,1.2,1.2,1.1000000000000001,1.1000000000000001,2.9,4.7,5.9,7,5.9,4.9000000000000004,4.5,4.4000000000000004,4.4000000000000004,4.3,4.3,4.9000000000000004,4.2,3.9,3.4,3.2,3.1,3.2,3.1,3,2.8,2.9,3,3.5,4,4.5,4.7,4.5999999999999996,4.5,4.5,4.0999999999999996,3.9,3.7,4,4.0999999999999996,4.3,4.2,4.3,4.2,4.0999999999999996,4.4000000000000004,4.4000000000000004,4.7,4.8,4.7,5,5.0999999999999996,5.2,4.8,4.5999999999999996,4.5,4.5]
["% Exits to Permanency",9.0999999999999943,9.9000000000000057,10.700000000000003,11.400000000000006,12.900000000000006,16,20,22.799999999999997,24.299999999999997,23.900000000000006,22.200000000000003,21.200000000000003,21.200000000000003,21,21.099999999999994,20.900000000000006,{"$f":"SUM(R9:R10)+R12","v":20.5},20.200000000000003,20.100000000000001,19.600000000000001,19.899999999999999,19.8,19.3,19.399999999999999,18.7,19,19.5,20.2,21.1,21.9,23,23.9,23.5,23.9,24.1,24.6,25.1,{"$f":"SUM(AM9:AM10)+AM12","v":25.9},26,24.9,23.799999999999997,23.7,23.3,23.700000000000003,{"$f":"SUM(AT9:AT10)+AT12","v":24.1},24.9,25.5,25.6,24.599999999999998,25.2,{"$f":"SUM(AZ9:AZ10)+AZ12","v":25.3},25.5,24.700000000000003,24.9,24.7,25.4,25.299999999999997]
["% Adopted",4.5999999999999996,4.9000000000000004,5.3,5.8,6.9,7.5,8.1999999999999993,9,9,9.6,10.1,10.4,11.2,11.5,11.7,11.5,10.8,11.4,11.7,11.9,12.2,12.3,12,12.3,11.9,12.4,12.7,13.4,13.9,14.4,15,15.6,15.1,15.8,16,17.100000000000001,17.5,18.3,18,16.899999999999999,15.7,15.5,15,15.4,15.9,16.7,17.399999999999999,17.5,16.399999999999999,17,16.8,17.3,16.3,16.899999999999999,16.8,17.7,17.7]
["Total",43777,45433,46785,48494,49960,52140,53783,55169,55378,55100,52911,51037,49152,48350,47471,46193,36518,35868,34852,33832,32890,32416,31643,30894,29643,29521,29179,28504,27675,27590,27253,26601,25514,25230,24497,23674,22902,22434,21821,20674,19520,18905,18389,17942,17086,16809,16334,15865,15110,15005,14699,14480,13995,14024,13912,13869,13586]
[]
["FILTERS:"]
["Time in Care",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"24 Months or Longer"]
["Table Output in:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent (Also need \"Count\" for Total)"]
["Interval:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All"]
["Subgroups:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Restrictions"]

{"sheet":"table_c3.3","index":67,"n_rows":11,"n_cols":42,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: C3.3: In Care 3 Years or Longer (Emancipated or Age 18)"]
["NOTES:","In order to get # Emancipating, change % to count.; National goal is not from any chart but remains the same each quarter"]
["OUTPUT TYPE:","Multiple Time Periods (California or Individual County)"]
["SOURCE:","C3.3 (http://cssr.berkeley.edu/ucb_childwelfare/C3M3.aspx)"]
["FILTERS:","Table Output in: Percent; Interval: All; Subgroups: No Restrictions"]
[]
[null,2004,null,null,null,2005,null,null,null,2006,null,null,null,2007,null,null,null,2008,null,null,null,2009,null,null,null,2010,null,null,null,2011,null,null,null,2012,null,null,null,2013,null,null,null,2014]
["% in Care 3+ Years",65.5,65.599999999999994,66.3,66.099999999999994,65.7,66,65,64.400000000000006,64.099999999999994,63.6,63.7,63.7,62.8,61.9,61,60.5,60.8,61,60.5,60.2,59.9,59.4,60.2,59.5,58.9,59.6,59.1,59.5,58.9,57.7,56.2,54.9,54.9,54.4,53.9,52.9,51.4,50.5,49.5,49.3,48.6]
["National Goal (37.5%)",37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5,37.5]
["# Emancipating or Age 18 in Care",4466,4418,4380,4422,4417,4435,4470,4536,4584,4629,4702,4694,4712,4690,4615,4623,4575,4564,4549,4486,4449,4429,4365,4227,4163,4060,3956,3912,3815,3761,3764,3683,3683,3666,3595,3548,3468,3431,3423,3427,3421]

{"sheet":"table_C4.1.2.3","index":69,"n_rows":12,"n_cols":42,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: C4.1,2,3: Placement Stability, Percent of Children with 2 or Fewer Placements"]
["NOTES:","Have to create 3 separate tables; one for 8d to 12m, onefor 12m to 24m, and one for 24m+"]
["OUTPUT TYPE:","Multiple Time Periods (California or Individual County)"]
["FILTERS:","Table Output in: Percent; Interval: All; No restrictions on subgroups"]
["SOURCE:","C4.1.2.3 measures (http://cssr.berkeley.edu/ucb_childwelfare/C4M123.aspx)"]
["FILTERS:","Table Output in: Percent; Interval: All; Subgroups: No Restrictions"]
[]
[null,2004,null,null,null,2005,null,null,null,2006,null,null,null,2007,null,null,null,2008,null,null,null,2009,null,null,null,2010,null,null,null,2011,null,null,null,2012,null,null,null,2013,null,null,null,2014]
["8d to 12m",81.099999999999994,81.900000000000006,82.2,82,81.599999999999994,81.599999999999994,81.599999999999994,81.599999999999994,81.900000000000006,82.7,82.8,82.1,82,82.5,83,82.7,82.7,83.5,83.6,84,84,83.9,83.9,84.2,84.6,84.9,84.7,84.9,84.8,85.5,85.6,85.6,86.1,86.6,86.8,86.7,86.8,86.8,87,86.6,86.6]
["12m to 24m",59.1,59.5,59.6,59.8,59.8,60.7,60.7,61.2,61,60.7,61.1,61.6,61.9,62.4,63,63.1,62.9,63.1,63,62.7,62.8,63.4,63.5,63.9,63.9,64.5,65.3,65.5,65.7,66.099999999999994,66.3,66.599999999999994,67,67.3,67.900000000000006,68.3,69,69.5,69.8,69.599999999999994,69.7]
["24m+",36.1,35.6,35.1,34.700000000000003,34.200000000000003,34,33.700000000000003,33.4,33.4,33.799999999999997,33.9,34,34,34,33.9,34.1,33.9,33.9,33.9,33.6,33.4,33.4,33.1,33.1,32.9,33.4,33.4,33.9,33.9,34.4,34.9,35.4,35.799999999999997,36.5,37,37.5,37.6,38.4,39.200000000000003,39.799999999999997,40.700000000000003]

{"sheet":"table_C1.4 reentry","index":71,"n_rows":10,"n_cols":42,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE","California: C1.4: Reentering Care After Exit to Reunification at 12 and 24 Months"]
["NOTES:","Have to create 2 separate tables; one for24m, one for 24m"]
["OUTPUT TYPE:","Multiple Time Periods (California or Individual County)"]
["FILTERS:","Table Output in: Percent; Interval: All; Episode Count: All; Days in Care: 8 days or more; "]
["SOURCE:","C1.4: http://cssr-test.berkeley.edu/ucb_childwelfare/C1M4.aspx"]
[]
[null,2003,null,null,null,2004,null,null,null,2005,null,null,null,2006,null,null,null,2007,null,null,null,2008,null,null,null,2009,null,null,null,2010,null,null,null,2011,null,null,null,2012,null,null,null,2013]
["Reentered in less than 12 months",11.2,11.1,11,11.3,11.5,12,12,12.2,12.4,12.4,12.6,12.6,12.2,12,12,11.8,11.8,11.5,11.4,11.6,11.8,11.8,11.7,11.6,11.7,11.8,11.8,11.9,11.8,11.6,11.9,12,12.2,12.3,12.2,11.8,11.8,11.5,11.6,11.9,11.7]
["Reentered in less than 24 months",16.2,16.2,16.2,16.399999999999999,16.8,17.100000000000001,17.100000000000001,17.3,17.8,17.7,17.7,17.7,17,16.7,16.8,16.7,16.5,16.2,15.9,16,16.399999999999999,16.5,16.3,16,15.9,15.9,16.100000000000001,16.2,16.5,16.5,16.899999999999999,17.2,17.399999999999999,17.8,17.399999999999999,17.100000000000001,17.100000000000001,0,0,0,0]

{"sheet":"table_636 measures","index":73,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE:","California CWS Outcomes System: AB 636 Measures,  % IMPROVEMENT/DECLINE  "]
["NOTES:","If % change has the same sign (+ or -) as the directional goal, it is entered as a positive number; if the signs are different, it is entered as a negative number."]
["SOURCE:","CWS Outcomes (http://cssr.berkeley.edu/ucb_childwelfare/Ccfsr.aspx)"]
["FILTERS:","N/A."]
[]
["4B: PIT Placement (Group/Shelter) (-)",6.8000000000000005E-2]
["4B: PIT Placement (Relative) (+)",9.6000000000000002E-2]
["4B: Entries First Placement (Group/Shelter) (-)",2.1999999999999999E-2]
["4B: Entries First Placement (Relative) (+)",0.40100000000000002]
[]
[]
["4A: Siblings (Some or All) (+)",-0.03]
["4A: Siblings (All) (+)",-0.06]
[]
[]
["2F: Timely Social Worker Visits in Residence (+)",0.129]
["2F: Timely Social Worker Visits (+)",8.4000000000000005E-2]
[]
[]
["2B: Timely Response (10 day) (+)",-4.2000000000000003E-2]
["2B: Timely Response (1 day) (+)",-1.2E-2]
[]
[]
["PR: In Care Rate (-)",5.5E-2]
["PR: Entry Rate (-)",-2.3E-2]
["PR: Substantiation Rate (-)",0.125]
["PR: Referral Rate (-)",-7.8E-2]

{"sheet":"table_fedmeas","index":75,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE:","California CWS Outcomes System: Federal Measures, 5-Year % IMPROVEMENT/DECLINE "]
["NOTES:","If % change has the same sign (+ or -) as the directional goal, it is entered as a positive number; if the signs are different, it is entered as a negative number; "]
[null,"If % improvement is above 100%, it will need to be cut off in the table and the value label changed manually (like the adoption composite in the CA workbook)"]
["SOURCE:","CWS Outcomes (http://cssr.berkeley.edu/ucb_childwelfare/Ccfsr.aspx)"]
["FILTERS:","N/A."]
[]
["C4.3: Placement Stability (24m+ In Care) (+)",0.218]
["C4.2: Placement Stability (12-24m In Care) (+)",0.109]
["C4.1: Placement Stability (8d-12m In Care) (+)",3.1E-2]
["C3.3: In Care 3+ Yrs (Emancipated/Age 18) (-)",0.188]
["C3.2:  Exits to Permanency (Legally Free) (+)",8.9999999999999993E-3]
["C3.1:  Exits to Permanency (24m In Care) (+)",0.01]
["C2.5: Adoption w/in 12m (Legally Free) (+)",5.8999999999999997E-2]
["C2.4: Legally Free w/in 6m (17m In Care) (+)",0.217]
["C2.3: Adoption w/in 12m (17m In Care) (+)",1.7000000000000001E-2]
["C2.2: Median Time to Adoption (-)",0.128]
["C2.1: Adoption w/in 24m (+)",0.35599999999999998]
["C1.4: Reentry Following Reunification (-)",-1.6E-2]
["C1.3: Reunification w/in 12m (Entry Cohort) (+)",-0.159]
["C1.2: Median Time to Reunification (-)",-8.5999999999999993E-2]
["C1.1: Reunification w/in 12m (Exit Cohort) (+)",-7.0000000000000001E-3]
["S2.1: No Maltreatment in Foster Care (+)",1.2999999999999999E-3]
["S1.1: No Recurrence of Maltreatment (+)",3.0000000000000001E-3]

{"sheet":"table_relative_performance","index":77,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["EXTRACT: ",{"$f":"'Slide Descriptions'!A1","v":"Q4_14"}]
["TITLE:","TITLE: California CWS Outcomes System: Performance Relative to Federal Standard/Goal"]
["NOTES:","\"Difference to Goal\" Column has formula for calculation; no need to manually calculate"]
[null,"If Current Relative Performance is above 100, only use 100."]
["SOURCE:","CWS Outcomes (http://cssr.berkeley.edu/ucb_childwelfare/Ccfsr.aspx)"]
["FILTERS:","N/A."]
[]
[null,"Current Relative Performance","Difference to Goal"]
["C4.3: Placement Stability (24m+ In Care)",97.3,{"$f":"100-B9","v":2.7000000000000028}]
["C4.2: Placement Stability (12-24m In Care)",100,{"$f":"100-B10","v":0}]
["C4.1: Placement Stability (8d-12m In Care)",100,{"$f":"100-B11","v":0}]
[]
["C3.3: In Care 3+ Yrs (Emancipated/Age 18)",77.099999999999994,{"$f":"100-B13","v":22.900000000000006}]
["C3.2:  Exits to Permanency (Legally Free)",99.9,{"$f":"100-B14","v":9.9999999999994316E-2}]
["C3.1:  Exits to Permanency (24m In Care)",87.2,{"$f":"100-B15","v":12.799999999999997}]
[]
["C2.5: Adoption w/in 12m (Legally Free)",100,{"$f":"100-B17","v":0}]
["C2.4: Legally Free w/in 6m (17m In Care)",88.4,{"$f":"100-B18","v":11.599999999999994}]
["C2.3: Adoption w/in 12m (17m In Care)",96.1,{"$f":"100-B19","v":3.9000000000000057}]
["C2.2: Median Time to Adoption",100,{"$f":"100-B20","v":0}]
["C2.1: Adoption w/in 24m",100,{"$f":"100-B21","v":0}]
[]
["C1.4: Reentry Following Reunification",82.3,{"$f":"100-B23","v":17.700000000000003}]
["C1.3: Reunification w/in 12m (Entry Cohort)",73.400000000000006,{"$f":"100-B24","v":26.599999999999994}]
["C1.2: Median Time to Reunification",61.4,{"$f":"100-B25","v":38.6}]
["C1.1: Reunification w/in 12m (Exit Cohort)",84.6,{"$f":"100-B26","v":15.400000000000006}]
[]
["S2.1: No Maltreatment in Foster Care",100,{"$f":"100-B28","v":0}]
["S1.1: No Recurrence of Maltreatment ",98.7,{"$f":"100-B29","v":1.2999999999999972}]