{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["All local authorities","East of England","East Midlands","Greater London","North East","North West","South East","South West","Yorkshire & the Humber","West Midlands","Scotland","Sheet1"],"not_rendered":{"charts":107,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"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":"All local authorities","index":0,"n_rows":274,"n_cols":7,"rows_kept":274,"cut":false,"hidden":false,"merged":[]}
["Description - all local authorities 2020-2021","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of local authorities subscribing at end of quarter",67,69,69,70]
["Number of local authorities with data uploaded at end of quarter - all case types",67,67,68,68]
["Number of local authorities with data for family cases",67,67,67,67]
["Number of local authorities with data for adult cases",42,42,43,43]
["Number of local authorities with data for children / care leaver cases",29,30,28,28]
[]
[]
[]
["Family cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",1580,1614,1674,1636]
["Number of dependants of financially supported households at end of quarter",2957,2987,3054,2932]
["Total weekly spend for the cases supported at the end of the quarter",471270,488064,514946,517079]
["Average annual cost per case",{"$f":"B13/B11*52","v":15510.151898734179},{"$f":"C13/C11*52","v":15724.490706319702},{"$f":"D13/D11*52","v":15995.933094384707},{"$f":"E13/E11*52","v":16435.273838630805}]
["Average annual cost (weekly spend X 52)",{"$f":"B13*52","v":24506040},{"$f":"C13*52","v":25379328},{"$f":"D13*52","v":26777192},{"$f":"E13*52","v":26888108}]
["Average number of days on support, cases open at end of quarter",599,555,572,589]
["Of Row 11 - Number that are non EEA and unresolved",1212,1244,1271,1204]
["Of Row 11 - EEA national or EEA family member / derivative rights",164,184,188,195]
["Of Row 11 - Number that are non EEA but have LTR with recourse",204,186,215,237]
["Of Row 17 - Number that are 1000 day cases",196,189,190,184]
["Of Row 18 - Number of 1000 day EEA national cases without 'settled status ",29,34,32,28]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 20 / row 17)",0.16,0.15,0.15,0.15]
["EEA 1000 day cases, percentage of unresolved cohort (row 21 / row 18)",0.18,0.19,0.18,0.15]
["Total number of referrals per quarter",928,836,781,728]
["Total number of new cases taken on for support within quarter",429,363,326,276]
["Total number of supported cases closed within quarter",244,329,266,314]
[]
[]
[]
["Adult cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",664,665,707,708]
["Total weekly spend for the cases supported at the end of the quarter",240897,237616,251458,248979]
["Average annual cost per case",{"$f":"B32/B31*52","v":18865.427710843374},{"$f":"C32/C31*52","v":18580.499248120301},{"$f":"D32/D31*52","v":18494.789250353606},{"$f":"E32/E31*52","v":18286.593220338982}]
["Average annual cost (weekly spend X 52)",{"$f":"B32*52","v":12526644},{"$f":"C32*52","v":12356032},{"$f":"D32*52","v":13075816},{"$f":"E32*52","v":12946908}]
["Average number of days on support, cases open at end of quarter",917,930,893,911]
["Of Row 31 - Number that are non EEA and unresolved",510,512,535,531]
["Of Row 31 - EEA national or EEA family member / derivative rights",121,127,145,140]
["Of Row 31 - Number that are non EEA but have LTR with recourse",33,26,27,37]
["Of Row 31 - Number that are 1000 day cases",172,174,178,531]
["Of Row 31 - Number of 1000 day EEA national cases without 'settled status ",23,21,22,21]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 39 / row 36)",0.34,0.34,0.33,0.34]
["EEA 1000 day cases, percentage of unresolved cohort (row 40 / row 37)",0.2,0.17,0.15,0.15]
["Total number of referrals per quarter",506,407,432,473]
["Total number of new cases taken on for support within quarter",159,95,120,97]
["Total number of supported cases closed within quarter",85,94,78,96]
[]
[]
[]
["Looked after children and care leavers","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of open cases at end of quarter",2175,2265,2394,2493]
["Of which under age of 18",214,272,346,397]
["Of which aged 18-21",1088,1132,1184,1255]
["Of which aged 21 and over",873,861,864,841]
["Of number of open cases (row 50), number financially supported",761,788,806,856]
["Total weekly spend for the cases financially supported at end of quarter",287870,291420,307997,331720]
["Average annual cost per case",{"$f":"B55/B54*52","v":19670.486202365308},{"$f":"C55/C54*52","v":19230.761421319796},{"$f":"D55/D54*52","v":19870.774193548386},{"$f":"E55/E54*52","v":20151.214953271028}]
["Average annual cost (weekly spend X 52)",{"$f":"B55*52","v":14969240},{"$f":"C55*52","v":15153840},{"$f":"D55*52","v":16015844},{"$f":"E55*52","v":17249440}]
["Total number of new cases recorded within the quarter",116,145,189,227]
["Total number of cases closed ",115,52,60,131]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason family and adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",61,{"$f":" 100/1510*B71","v":4.039735099337749}]
["Non-EEA national - left the UK (HO / LA funded)",10,0.66225165562913912]
["Accessed Asylum Support",109,7.2185430463576168]
["No longer eligible",{"$f":"133+33","v":166},10.993377483443709]
["EEA national / family member - accessed benefits / employment",65,4.3046357615894042]
["Granted Leave to Remain",{"$f":" 994 + 76+29","v":1099},{"$f":" 100/1510*B76","v":72.78145695364239}]
[]
[]
[]
[]
["Closure reason family cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",36,{"$f":" 100/1156*B82","v":3.1141868512110724}]
["Non-EEA national - left the UK (HO / LA funded)",8,0.69204152249134943]
["Accessed Asylum Support",67,5.7958477508650512]
["No longer eligible",{"$f":"2+81","v":83},7.1799307958477501]
["EEA national / family member - accessed benefits / employment",45,3.8927335640138407]
["Granted Leave to Remain",{"$f":" 833 + 62+22","v":917},{"$f":" 100/1156*B87","v":79.325259515570934}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",25,{"$f":" 100/354*B110","v":7.0621468926553677}]
["Non-EEA national - left the UK (HO / LA funded)",2,1]
["Accessed Asylum Support",42,{"$f":" 100/354*B112","v":11.864406779661017}]
["Deceased",31,8.7570621468926557]
["No longer eligible",52,14.689265536723164]
["EEA national / family member - accessed benefits / employment",20,5]
["Granted Leave to Remain",{"$f":" 14 + 7 + 161","v":182},51.412429378531073]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Immigration status families - open cases as of 31 March 2021","Total","Percentage",null,"Summary - families - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",128,{"$f":" 100/1578*B137","v":8.1115335868187586},null,"EEA national or EU residence rights ",{"$f":"B137+B138+B139","v":194},{"$f":" 100/1578*F137","v":12.29404309252218}]
["Indefinite leave to remain (EU Settlement Scheme)",11,{"$f":" 100/1578*B138","v":0.69708491761723712},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B143+B144","v":153},9.6958174904942975]
["Leave to remain (EU Settlement Scheme)",55,{"$f":" 100/1578*B139","v":3.4854245880861852},null,"No current immigration permission",{"$f":"B155+B152+B147","v":733},47]
["Limited leave with recourse to public funds (10 year route)",129,8.1749049429657799,null,"Asylum seeker / asylum seeker ARE",{"$f":"B157+B154+B156+B153+B145","v":241},15.272496831432194]
["Limited leave with recourse to public funds (following COC)",38,2.4081115335868191,null,"Leave to Remain (LTR) with recourse ",{"$f":"B149+B150+B151+B148+B146+B142+B141+B140","v":250},15.842839036755388]
["Limited Leave with Recourse to Public Funds (other)",26,1.6476552598225602,null,"British",{"$f":"B158","v":7},0.44359949302915086]
["Limited leave with NRPF (10 year route)",67,4.245880861850444]
["Limited leave with NRPF (other)",86,5.4499366286438535]
["UASC leave",1,6.3371356147021551E-2]
["No record held by HO (non EEA)",36,2.2813688212927756]
["Humanitarian Protection",3,0.19011406844106465]
["Refugee Status",5,0.31685678073510776]
["Indefinite leave   ",16,1.0139416983523448]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",647,41.001267427122947]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",123,7.7946768060836504]
["In Country Asylum Seeker",12,0.76045627376425862]
["Illegal entrant - asylum claimed 'no'",83,5.2598225602027888]
["Illegal entrant - asylum claimed 'yes'",85,5.3865652724968323]
["Port Case",20,1.267427122940431]
["British",7,0.44359949302915086]
[]
[]
[]
[]
[]
[]
["Adults - open cases as of 31 March 2021","Total","Percentage",null,"Summary - adults - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",117,{"$f":" 100/687*B166","v":17.030567685589517},null,"EEA national or EU residence rights ",{"$f":"B166+B167+B168","v":139},{"$f":" 100/687*F166","v":20.232896652110625}]
["Indefinite leave to remain (EU Settlement Scheme)",2,{"$f":" 100/687*B167","v":0.29112081513828236},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B172+B173","v":34},6]
["Leave to remain (EU Settlement Scheme)",20,2.9112081513828238,null,"No current immigration permission",{"$f":"B184+B181+B176","v":264},{"$f":" 100/687*F168","v":38.427947598253269}]
["Limited leave with recourse to public funds (10 year route)",10,1.4556040756914119,null,"Asylum seeker / asylum seeker ARE",{"$f":"B186+B183+B185+B182+B174","v":214},31.149927219796211]
["Limited leave with recourse to public funds (following COC)",5,0.72780203784570596,null,"Leave to Remain (LTR) with recourse ",{"$f":"B178+B179+B180+B177+B175+B171+B170+B169","v":35},5.0946142649199411]
["Limited Leave with Recourse to Public Funds (other)",18,2.6200873362445414,null,"British",{"$f":"B187","v":1},0.14556040756914118]
["Limited leave with NRPF (10 year route)",8,1.1644832605531295]
["Limited leave with NRPF (other)",26,3.7845705967976708]
["UASC leave",0,0]
["Indefinite Leave",1,0.14556040756914118]
["No record held by HO (non EEA)",42,6.1135371179039293]
["Humanitarian Protection",0,0]
["Refugee Status",1,0.14556040756914118]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",192,27.947598253275107]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",94,13.682678311499272]
["In Country Asylum Seeker",12,1.7467248908296942]
["Illegal entrant - asylum claimed 'no'",30,4.3668122270742353]
["Illegal entrant - asylum claimed 'yes'",93,13.537117903930129]
["Port Case",15,2.1834061135371177]
["British",1,0.14556040756914118]
[]
[]
[]
[]
[]
[]
["looked after children and care leavers - open cases as of 31 March 2021","Total","Percentage",null,"Summary - LAC / CL - 31 March 21","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",79,{"$f":" 100/3137*B195","v":2.5183296142811606},null,"EEA national or EU residence rights ",{"$f":"B195+B196+B197","v":85},{"$f":" 100/2374*F195","v":3.5804549283909015}]
["Indefinite leave to remain (EU Settlement Scheme)",2,{"$f":" 100/3137*B196","v":6.375518010838381E-2},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B201+B202","v":17},{"$f":" 100/2374*F196","v":0.7160909856781803}]
["Leave to remain (EU Settlement Scheme)",4,0.12751036021676762,null,"No current immigration permission",{"$f":"B213+B210+B205","v":231},9.7304128053917438]
["Limited leave with recourse to public funds (10 year route)",15,0.4781638508128786,null,"Asylum seeker / asylum seeker ARE",{"$f":"B215+B212+B214+B211+B203","v":1516},63.858466722830663]
["Limited leave with recourse to public funds (following COC)",8,0.25502072043353524,null,"Leave to Remain (LTR) with recourse ",{"$f":"B207+B208+B209+B206+B204+B200+B199+B198","v":524},22.07245155855097]
["Limited Leave with Recourse to Public Funds (other)",97,3.092126235256615,null,"British",{"$f":"B216","v":1},4.2122999157540017E-2]
["Limited leave with NRPF (10 year route)",6,0.19126554032515142]
["Limited leave with NRPF (other)",11,0.35065349059611095]
["UASC leave",61,1.9445329933057063]
["Indefinite Leave",33,1.0519604717883329]
["No record held by HO (non EEA)",93,2.964615875039847]
["Humanitarian Protection",28,0.89257252151737332]
["Refugee Status",342,10.902135798533632]
["Discretionary leave - trafficking",1,3.1877590054191905E-2]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",37,1.1794708320051004]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",174,5.5467006694293914]
["In Country Asylum Seeker",111,3.5384124960153014]
["Illegal entrant - asylum claimed 'no'",101,3.2196365954733825]
["Illegal entrant - asylum claimed 'yes'",1115,35.543512910423978]
["Port Case",55,1.7532674529805548]
["British",1,3.1877590054191905E-2]
[]
[]
[]
[]
[]
[]
["Immigration status families - all referrals for the year","Total","Percentage",null,"Summary - families referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",275,{"$f":" 100/3137*B224","v":8.7663372649027735},null,"EEA national or EU residence rights ",{"$f":"B224+B225+B226","v":480},{"$f":" 100/3137*F224","v":15.301243226012115}]
["Indefinite leave to remain (EU Settlement Scheme)",51,{"$f":" 100/3137*B225","v":1.6257570927637872},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B230+B231","v":673},22]
["Leave to remain (EU Settlement Scheme)",154,4.9091488683455538,null,"No current immigration permission",{"$f":"B242+B239+B234","v":956},31]
["Limited leave with recourse to public funds (10 year route)",136,4.3353522473700989,null,"Asylum seeker / asylum seeker ARE",{"$f":"B244+B241+B243+B240+B232","v":409},{"$f":" 100/3137*F227","v":13.03793433216449}]
["Limited leave with recourse to public funds (following COC)",180,5.7379662097545427,null,"Leave to Remain (LTR) with recourse ",{"$f":"B236+B237+B238+B235+B233+B229+B228+B227","v":578},18.42524705132292]
["Limited Leave with Recourse to Public Funds (other)",76,2.422696844118585,null,"British",{"$f":"B245","v":41},1.3069811922218681]
["Limited leave with NRPF (10 year route)",365,11.635320369780045]
["Limited leave with NRPF (other)",308,9.8182977366911075]
["UASC leave",0,0]
["Indefinite Leave",65,2.0720433535224738]
["No record held by HO (non EEA)",180,5.7379662097545427]
["Humanitarian Protection",5,0.15938795027095953]
["Refugee Status",32,1.020082881734141]
["Discretionary leave - trafficking",0,0]
["DDV Concession",84,2.6777175645521201]
["Over-stayer / Deception / Breach - asylum claimed 'no'",697,22.218680267771759]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",153,4.8772712782913619]
["In Country Asylum Seeker",50,1.5938795027095953]
["Illegal entrant - asylum claimed 'no'",79,2.5183296142811606]
["Illegal entrant - asylum claimed 'yes'",175,5.5785782594835833]
["Port Case",31,0.98820529167994908]
["British",41,1.3069811922218681]
[]
[]
[]
[]
[]
[]
["Immigration status adults - all referrals for the year","Total","Percentage",null,"Summary - adults referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",338,{"$f":" 100/1732*B253","v":19.515011547344109},null,"EEA national or EU residence rights ",{"$f":"B253+B254+B255","v":479},{"$f":" 100/1732*F253","v":27.655889145496534}]
["Indefinite leave to remain (EU Settlement Scheme)",50,{"$f":" 100/1732*B254","v":2.8868360277136258},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B259+B260","v":165},9]
["Leave to remain (EU Settlement Scheme)",91,5.2540415704387993,null,"No current immigration permission",{"$f":"B271+B268+B263","v":495},{"$f":" 100/1732*F255","v":28.579676674364894}]
["Limited leave with recourse to public funds (10 year route)",16,0.92378752886836024,null,"Asylum seeker / asylum seeker ARE",{"$f":"B273+B270+B272+B269+B261","v":402},23.210161662817551]
["Limited leave with recourse to public funds (following COC)",13,0.75057736720554269,null,"Leave to Remain (LTR) with recourse ",{"$f":"B265+B266+B267+B264+B262+B258+B257+B256","v":190},10.969976905311778]
["Limited Leave with Recourse to Public Funds (other)",37,2.1362586605080831,null,"British",{"$f":"B274","v":1},5.7736720554272515E-2]
["Limited leave with NRPF (10 year route)",56,3.2332563510392607]
["Limited leave with NRPF (other)",109,6.2933025404157039]
["UASC leave",0,0]
["Indefinite Leave",78,4.5034642032332561]
["No record held by HO (non EEA)",179,10.334872979214779]
["Humanitarian Protection",4,0.23094688221709006]
["Refugee Status",24,1.3856812933025404]
["Discretionary leave - trafficking",0,0]
["DDV Concession",18,1.0392609699769053]
["Over-stayer / Deception / Breach - asylum claimed 'no'",272,15.704387990762124]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",156,9.0069284064665123]
["In Country Asylum Seeker",17,0.98152424942263272]
["Illegal entrant - asylum claimed 'no'",44,2.5404157043879905]
["Illegal entrant - asylum claimed 'yes'",200,11.547344110854503]
["Port Case",29,1.674364896073903]
["British",1,5.7736720554272515E-2]

{"sheet":"East of England","index":1,"n_rows":265,"n_cols":8,"rows_kept":265,"cut":false,"hidden":false,"merged":[]}
["Description - all local authorities 2020-2021","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of local authorities subscribing at end of quarter",4,4,4,4]
["Number of local authorities with data uploaded at end of quarter - all case types",4,4,4,4]
["Number of local authorities with data for family cases",4,4,4,4]
["Number of local authorities with data for adult cases",2,2,2,2]
["Number of local authorities with data for children / care leaver cases",1,1,1,1]
[]
[]
[]
["Family cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",56,56,69,74]
["Number of dependants of financially supported households at end of quarter",107,110,120,143]
["Total weekly spend for the cases supported at the end of the quarter",12639.55,13452,16312,18211]
["Average annual cost per case",{"$f":"B13*52/B11","v":11736.725},{"$f":"C13*52/C11","v":12491.142857142857},12293.101449275362,12796.918918918918]
["Average annual cost (weekly spend X 52)",{"$f":"B13*52","v":657256.6},{"$f":"C13*52","v":699504},848224,946972]
["Average number of days on support, cases open at end of quarter",423,458,408,427]
["Of Row 11 - Number that are non EEA and unresolved",37,34,47,44]
["Of Row 11 - EEA national or EEA family member / derivative rights",14,16,18,23]
["Of Row 11 - Number that are non EEA but have LTR with recourse",5,6,4,7]
["Of Row 17 - Number that are 1000 day cases",2,1,1,3]
["Of Row 18 - Number of 1000 day EEA national cases without 'settled status ",1,2,3,5]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 20 / row 17)",0.05,0.03,0.02,7.0000000000000007E-2]
["EEA 1000 day cases, percentage of unresolved cohort (row 21 / row 18)",7.0000000000000007E-2,0.13,0.17,0.22]
["Total number of referrals per quarter",52,44,31,29]
["Total number of new cases taken on for support within quarter",18,7,21,15]
["Total number of supported cases closed within quarter",9,11,8,10]
[]
[]
[]
[]
["Adult cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",30,35,41,42]
["Total weekly spend for the cases supported at the end of the quarter",9879,10049,10580,11013]
["Average annual cost per case",{"$f":"B33*52/B32","v":17123.599999999999},{"$f":"C33*52/C32","v":14929.942857142858},{"$f":"D33*52/D32","v":13418.536585365853},13635.142857142857]
["Average annual cost (weekly spend X 52)",{"$f":"B33*52","v":513708},{"$f":"C33*52","v":522548},{"$f":"D33*52","v":550160},572676]
["Average number of days on support, cases open at end of quarter",682,661,607,636]
["Of Row 31 - Number that are non EEA and unresolved",15,15,15,14]
["Of Row 31 - EEA national or EEA family member / derivative rights",15,19,25,28]
["Of Row 31 - Number that are non EEA but have LTR with recourse",0,1,1,0]
["Of Row 31 - Number that are 1000 day cases",3,3,3,5]
["Of Row 31 - Number of 1000 day EEA national cases without 'settled status ",1,2,2,2]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 39 / row 36)",0.2,0.2,0.2,0.36]
["EEA 1000 day cases, percentage of unresolved cohort (row 40 / row 37)",7.0000000000000007E-2,0.1,0.08,7.0000000000000007E-2]
["Total number of referrals per quarter",107,30,42,79]
["Total number of new cases taken on for support within quarter",11,8,12,11]
["Total number of supported cases closed within quarter",7,3,6,10]
[]
[]
[]
[]
[]
[]
["Looked after children and care leavers","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of open cases at end of quarter",200,240,239,240]
["Of which under age of 18",42,71,71,72]
["Of which aged 18-21",97,108,107,107]
["Of which aged 21 and over",61,61,61,61]
["Of number of open cases (row 54), number financially supported",108,108,106,107]
["Total weekly spend for the cases financially supported at end of quarter",62855,62178.93,61370,61984]
["Average annual cost per case",{"$f":"B59/B58*52","v":30263.518518518518},{"$f":"C59/C58*52","v":29938.00333333333},30106.037735849055,30123.065420560746]
["Average annual cost (weekly spend X 52)",{"$f":"B59*52","v":3268460},{"$f":"C59*52","v":3233304.36},3191240,3223168]
["Total number of new cases recorded within the quarter",5,40,1,1]
["Total number of cases closed ",0,0,2,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason family and adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",8,{"$f":" 100/64*B74","v":12.5}]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/64*B75","v":0}]
["Accessed Asylum Support",6,9.375]
["No longer eligible",{"$f":"2+1","v":3},4.6875]
["EEA national / family member - accessed benefits / employment",3,4.6875]
["Granted Leave to Remain",{"$f":"34+10","v":44},68.75]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null," "]
["Closure reason family cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",2,{"$f":" 100/38*B96","v":5.2631578947368425},null,"         "]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/38*B97","v":0}]
["Accessed Asylum Support",4,10.526315789473685]
["No longer eligible",{"$f":"1+1","v":2},5.2631578947368425]
["EEA national / family member - accessed benefits / employment",1,2.6315789473684212]
["Granted Leave to Remain",{"$f":"5+24","v":29},76.31578947368422]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",6,{"$f":" 100/26*B118","v":23.076923076923077}]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/26*B119","v":0}]
["Accessed Asylum Support",2,7]
["No longer eligible",0,0]
["Deceased",1,3.8461538461538463]
["EEA national / family member - accessed benefits / employment",2,7.6923076923076925]
["Granted Leave to Remain",{"$f":"5+10","v":15},57.692307692307693]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Immigration status families - open cases as of 31 March 2021","Total","Percentage",null,"Summary - families - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",18,{"$f":" 100/63*B140","v":28.571428571428569},null,"EEA national or EU residence rights ",{"$f":"B140+B141+B142","v":23},36]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/63*B141","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B146+B147","v":10},{"$f":" 100/63*F141","v":15.873015873015872}]
["Leave to remain (EU Settlement Scheme)",5,7.9365079365079358,null,"No current immigration permission",{"$f":"B158+B155+B150","v":15},23.809523809523807]
["Limited leave with recourse to public funds (10 year route)",3,4.7619047619047619,null,"Asylum seeker / asylum seeker ARE",{"$f":"B160+B157+B159+B156+B148","v":7},11.111111111111111]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B152+B153+B154+B151+B149+B145+B144+B143","v":7},11.111111111111111]
["Limited Leave with Recourse to Public Funds (other)",0,0,null,"British",{"$f":"B161","v":1},1.5873015873015872]
["Limited leave with NRPF (10 year route)",4,6.3492063492063489]
["Limited leave with NRPF (other)",6,9.5238095238095237]
["UASC leave",0,0]
["No record held by HO (non EEA)",3,4.7619047619047619]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Indefinite leave   ",1,1.5873015873015872]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",13,20.634920634920633]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",3,4.7619047619047619]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",2,3.1746031746031744]
["Illegal entrant - asylum claimed 'yes'",2,3.1746031746031744]
["Port Case",2,3.1746031746031744]
["British",1,1.5873015873015872]
[]
[]
[]
["Adults - open cases as of 31 March 2021","Total","Percentage",null,"Summary - adults - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",18,{"$f":" 100/42*B166","v":42.857142857142854},null,"EEA national or EU residence rights ",{"$f":"B166+B167+B168","v":28},{"$f":" 100/42*F166","v":66.666666666666671}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/42*B167","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B172+B173","v":1},{"$f":" 100/42*F167","v":2.3809523809523809}]
["Leave to remain (EU Settlement Scheme)",10,23.80952380952381,null,"No current immigration permission",{"$f":"B184+B181+B176","v":8},19.047619047619047]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B186+B183+B185+B182+B174","v":5},11.904761904761905]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B178+B179+B180+B177+B175+B171+B170+B169","v":0},0]
["Limited Leave with Recourse to Public Funds (other)",0,0,null,"British",{"$f":"B187","v":0},0]
["Limited leave with NRPF (10 year route)",0,0]
["Limited leave with NRPF (other)",1,2.3809523809523809]
["UASC leave",0,0]
["Indefinite Leave",0,0]
["No record held by HO (non EEA)",1,2.3809523809523809]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",7,16.666666666666668]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",4,9.5238095238095237]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",0,0]
["Illegal entrant - asylum claimed 'yes'",0,0]
["Port Case",1,2.3809523809523809]
["British",0,0]
[]
[]
[]
["looked after children and care leavers - open cases as of 31 March 2021","Total","Percentage",null,"Summary - LAC / CL - 31 March 21","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",12,{"$f":" 100/240*B192","v":5},null,"EEA national or EU residence rights ",{"$f":"B192+B193+B194","v":12},{"$f":" 100/240*F192","v":5}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/240*B193","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B198+B199","v":0},{"$f":" 100/240*F193","v":0}]
["Leave to remain (EU Settlement Scheme)",0,0,null,"No current immigration permission",{"$f":"B210+B207+B202","v":21},8.75]
["Limited leave with recourse to public funds (10 year route)",1,0.41666666666666669,null,"Asylum seeker / asylum seeker ARE",{"$f":"B212+B209+B211+B208+B200","v":163},67.916666666666671]
["Limited leave with recourse to public funds (following COC)",1,0.41666666666666669,null,"Leave to Remain (LTR) with recourse ",{"$f":"B204+B205+B206+B203+B201+B197+B196+B195","v":44},18.333333333333336]
["Limited Leave with Recourse to Public Funds (other)",9,3.75,null,"British",{"$f":"B213","v":0},0]
["Limited leave with NRPF (10 year route)",0,0]
["Limited leave with NRPF (other)",0,0]
["UASC leave",11,4.5833333333333339]
["Indefinite Leave",2,0.83333333333333337]
["No record held by HO (non EEA)",9,3.75]
["Humanitarian Protection",1,0.41666666666666669]
["Refugee Status",30,12.5]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",1,0.41666666666666669]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",4,1.6666666666666667]
["In Country Asylum Seeker",14,5.8333333333333339]
["Illegal entrant - asylum claimed 'no'",11,4.5833333333333339]
["Illegal entrant - asylum claimed 'yes'",102,42.5]
["Port Case",32,13.333333333333334]
["British",0,0]
[]
[]
[]
["Immigration status families - all referrals for the year","Total","Percentage",null,"Summary - families referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",19,{"$f":" 100/147*B218","v":12.92517006802721},null,"EEA national or EU residence rights ",{"$f":"B218+B219+B220","v":33},{"$f":" 100/147*F218","v":22.448979591836736}]
["Indefinite leave to remain (EU Settlement Scheme)",2,{"$f":" 100/147*B219","v":1.3605442176870748},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B224+B225","v":32},{"$f":" 100/147*F219","v":21.768707482993197}]
["Leave to remain (EU Settlement Scheme)",12,8.1632653061224492,null,"No current immigration permission",{"$f":"B236+B233+B228","v":23},15.646258503401359]
["Limited leave with recourse to public funds (10 year route)",6,4.0816326530612246,null,"Asylum seeker / asylum seeker ARE",{"$f":"B238+B235+B237+B234+B226","v":41},27.891156462585034]
["Limited leave with recourse to public funds (following COC)",3,2.0408163265306123,null,"Leave to Remain (LTR) with recourse ",{"$f":"B230+B231+B232+B229+B227+B223+B222+B221","v":16},10.884353741496598]
["Limited Leave with Recourse to Public Funds (other)",2,1.3605442176870748,null,"British",{"$f":"B239","v":2},1.3605442176870748]
["Limited leave with NRPF (10 year route)",13,8.8435374149659864]
["Limited leave with NRPF (other)",19,12.92517006802721]
["UASC leave",3,2.0408163265306123]
["Indefinite Leave",0,0]
["No record held by HO (non EEA)",4,2.7210884353741496]
["Humanitarian Protection",0,0]
["Refugee Status",1,0.68027210884353739]
["Discretionary leave - trafficking",0,0]
["DDV Concession",4,2.7210884353741496]
["Over-stayer / Deception / Breach - asylum claimed 'no'",17,11.564625850340136]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",11,7.482993197278911]
["In Country Asylum Seeker",2,1.3605442176870748]
["Illegal entrant - asylum claimed 'no'",2,1.3605442176870748]
["Illegal entrant - asylum claimed 'yes'",21,14.285714285714285]
["Port Case",4,2.7210884353741496]
["British",2,1.3605442176870748]
[]
[]
[]
["Immigration status adults - all referrals for the year","Total","Percentage",null,"Summary - adults referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",96,{"$f":" 100/265*B244","v":36.226415094339629},null,"EEA national or EU residence rights ",{"$f":"B244+B245+B246","v":139},{"$f":" 100/265*F244","v":52.452830188679251}]
["Indefinite leave to remain (EU Settlement Scheme)",17,{"$f":" 100/265*B245","v":6.4150943396226419},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B250+B251","v":24},{"$f":" 100/265*F245","v":9.0566037735849072}]
["Leave to remain (EU Settlement Scheme)",26,9.8113207547169825,null,"No current immigration permission",{"$f":"B262+B259+B254","v":18},6.7924528301886795]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B264+B261+B263+B260+B252","v":66},24.905660377358494]
["Limited leave with recourse to public funds (following COC)",1,0.37735849056603776,null,"Leave to Remain (LTR) with recourse ",{"$f":"B256+B257+B258+B255+B253+B249+B248+B247","v":16},6.0377358490566042]
["Limited Leave with Recourse to Public Funds (other)",2,0.75471698113207553,null,"British",{"$f":"B265","v":2},0.75471698113207553]
["Limited leave with NRPF (10 year route)",12,4.5283018867924536]
["Limited leave with NRPF (other)",12,4.5283018867924536]
["UASC leave",0,0]
["Indefinite Leave",6,2.2641509433962268]
["No record held by HO (non EEA)",12,4.5283018867924536]
["Humanitarian Protection",0,0]
["Refugee Status",5,1.8867924528301887]
["Discretionary leave - trafficking",0,0]
["DDV Concession",2,0.75471698113207553]
["Over-stayer / Deception / Breach - asylum claimed 'no'",5,1.8867924528301887]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",8,3.0188679245283021]
["In Country Asylum Seeker",1,0.37735849056603776]
["Illegal entrant - asylum claimed 'no'",1,0.37735849056603776]
["Illegal entrant - asylum claimed 'yes'",50,18.867924528301888]
["Port Case",7,2.6415094339622645]
["British",2,0.75471698113207553]

{"sheet":"East Midlands","index":2,"n_rows":266,"n_cols":7,"rows_kept":266,"cut":false,"hidden":false,"merged":[]}
["Description - all local authorities 2020-2021","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of local authorities subscribing at end of quarter",5,5,5,5]
["Number of local authorities with data uploaded at end of quarter - all case types",5,5,5,5]
["Number of local authorities with data for family cases",5,5,5,5]
["Number of local authorities with data for adult cases",1,1,3,3]
["Number of local authorities with data for children / care leaver cases",3,3,3,3]
[]
[]
[]
["Family cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",73,76,76,81]
["Number of dependants of financially supported households at end of quarter",168,177,174,180]
["Total weekly spend for the cases supported at the end of the quarter",23039,24780,23736,23060]
["Average annual cost per case",{"$f":"B13*52/B11","v":16411.342465753423},{"$f":"C13*52/C11","v":16954.736842105263},{"$f":"D13*52/D11","v":16240.421052631578},{"$f":"E13*52/E11","v":14803.95061728395}]
["Average annual cost (weekly spend X 52)",{"$f":"B13*52","v":1198028},{"$f":"C13*52","v":1288560},{"$f":"D13*52","v":1234272},{"$f":"E13*52","v":1199120}]
["Average number of days on support, cases open at end of quarter",486,512,576,547]
["Of Row 11 - Number that are non EEA and unresolved",53,55,50,51]
["Of Row 11 - EEA national or EEA family member / derivative rights",15,18,21,22]
["Of Row 11 - Number that are non EEA but have LTR with recourse",5,3,5,8]
["Of Row 17 - Number that are 1000 day cases",9,10,11,7]
["Of Row 18 - Number of 1000 day EEA national cases without 'settled status ",3,4,3,3]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 20 / row 17)",0.17,0.18,0.22,0.14000000000000001]
["EEA 1000 day cases, percentage of unresolved cohort (row 21 / row 18)",0.2,0.22,0.14000000000000001,0.14000000000000001]
["Total number of referrals per quarter",73,65,62,66]
["Total number of new cases taken on for support within quarter",24,19,10,14]
["Total number of supported cases closed within quarter",10,16,12,9]
[]
[]
[]
["Adult cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",15,15,18,19]
["Total weekly spend for the cases supported at the end of the quarter",5196,5120,6475,6771]
["Average annual cost per case",{"$f":"B32*52/B31","v":18012.8},{"$f":"C32*52/C31","v":17749.333333333332},18705.555555555555,18531.157894736843]
["Average annual cost (weekly spend X 52)",{"$f":"B32*52","v":270192},{"$f":"C32*52","v":266240},336700,352092]
["Average number of days on support, cases open at end of quarter",1423,1236,1114,994]
["Of Row 31 - Number that are non EEA and unresolved",12,13,15,17]
["Of Row 31 - EEA national or EEA family member / derivative rights",1,1,1,2]
["Of Row 31 - Number that are non EEA but have LTR with recourse",2,1,2,0]
["Of Row 31 - Number that are 1000 day cases",6,6,7,7]
["Of Row 31 - Number of 1000 day EEA national cases without 'settled status ",0,0,0,0]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 39 / row 36)",0.5,0.46,0.47,0.41]
["EEA 1000 day cases, percentage of unresolved cohort (row 40 / row 37)",0,0,0,0]
["Total number of referrals per quarter",21,13,14,27]
["Total number of new cases taken on for support within quarter",2,1,5,3]
["Total number of supported cases closed within quarter",1,1,2,2]
[]
[]
[]
[]
[]
[]
["Looked after children and care leavers","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of open cases at end of quarter",483,465,465,464]
["Of which under age of 18",79,77,77,77]
["Of which aged 18-21",236,231,231,230]
["Of which aged 21 and over",168,157,157,157]
["Of number of open cases (row 53), number financially supported",37,39,41,44]
["Total weekly spend for the cases financially supported at end of quarter",12881,13364,15018,15510]
["Average annual cost per case",{"$f":"B58/B57*52","v":18103.027027027027},{"$f":"C58/C57*52","v":17818.666666666668},19047.219512195123,18330]
["Average annual cost (weekly spend X 52)",{"$f":"B58*52","v":669812},{"$f":"C58*52","v":694928},780936,806520]
["Total number of new cases recorded within the quarter",14,11,25,14]
["Total number of cases closed ",49,18,0,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason family and adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",2,{"$f":" 100/54*B76","v":3.7037037037037037}]
["Non-EEA national - left the UK (HO / LA funded)",2,{"$f":" 100/54*B77","v":3.7037037037037037}]
["Accessed Asylum Support",8,14.814814814814815]
["No longer eligible",2,3.7037037037037037]
["EEA national / family member - accessed benefits / employment",7,12.962962962962964]
["Granted Leave to Remain",33,61.111111111111114]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason family cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",2,{"$f":" 100/48*B99","v":4.166666666666667}]
["Non-EEA national - left the UK (HO / LA funded)",2,{"$f":" 100/48*B100","v":4.166666666666667}]
["Accessed Asylum Support",5,10.416666666666668]
["No longer eligible",2,4.166666666666667]
["EEA national / family member - accessed benefits / employment",7,14.583333333333334]
["Granted Leave to Remain",30,62.500000000000007]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",0,{"$f":" 100/212*B125","v":0}]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/212*B126","v":0}]
["Accessed Asylum Support",3,50]
["No longer eligible",0,0]
["Deceased",0,0]
["EEA national / family member - accessed benefits / employment",0,0]
["Granted Leave to Remain",3,50]
[]
[]
[]
[]
[]
[]
[]
[]
["Immigration status families - open cases as of 31 March 2021","Total","Percentage",null,"Summary - families - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",12,{"$f":" 100/78*B141","v":15.384615384615387},null,"EEA national or EU residence rights ",{"$f":"B141+B142+B143","v":22},{"$f":" 100/78*F141","v":28.205128205128208}]
["Indefinite leave to remain (EU Settlement Scheme)",3,{"$f":" 100/78*B142","v":3.8461538461538467},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B147+B148","v":8},{"$f":" 100/78*F142","v":10.256410256410257}]
["Leave to remain (EU Settlement Scheme)",7,8.9743589743589745,null,"No current immigration permission",{"$f":"B159+B156+B151","v":25},32.051282051282051]
["Limited leave with recourse to public funds (10 year route)",8,10.256410256410257,null,"Asylum seeker / asylum seeker ARE",{"$f":"B161+B158+B160+B157+B149","v":15},19.230769230769234]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B153+B154+B155+B152+B150+B146+B145+B144","v":8},11]
["Limited Leave with Recourse to Public Funds (other)",0,0,null,"British",{"$f":"B162","v":0},0]
["Limited leave with NRPF (10 year route)",4,5.1282051282051286]
["Limited leave with NRPF (other)",4,5.1282051282051286]
["UASC leave",0,0]
["No record held by HO (non EEA)",0,0]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Indefinite leave   ",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",22,28.205128205128208]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",8,10.256410256410257]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",3,3.8461538461538467]
["Illegal entrant - asylum claimed 'yes'",6,7.6923076923076934]
["Port Case",1,1.2820512820512822]
["British",0,0]
[]
[]
[]
["Adults - open cases as of 31 March 2021","Total","Percentage",null,"Summary - adults - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",2,{"$f":" 100/18*B167","v":11.111111111111111},null,"EEA national or EU residence rights ",{"$f":"B167+B168+B169","v":2},{"$f":" 100/18*F167","v":11.111111111111111}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/18*B168","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B173+B174","v":0},0]
["Leave to remain (EU Settlement Scheme)",0,0,null,"No current immigration permission",{"$f":"B185+B182+B177","v":5},27.777777777777779]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B187+B184+B186+B183+B175","v":11},61.111111111111107]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B179+B180+B181+B178+B176+B172+B171+B170","v":0},0]
["Limited Leave with Recourse to Public Funds (other)",0,0,null,"British",{"$f":"B188","v":0},0]
["Limited leave with NRPF (10 year route)",0,0]
["Limited leave with NRPF (other)",0,0]
["UASC leave",0,0]
["Indefinite Leave",0,0]
["No record held by HO (non EEA)",1,5.5555555555555554]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",3,16.666666666666664]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",7,38.888888888888886]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",1,5.5555555555555554]
["Illegal entrant - asylum claimed 'yes'",3,16.666666666666664]
["Port Case",1,5.5555555555555554]
["British",0,0]
[]
[]
[]
["looked after children and care leavers - open cases as of 31 March 2021","Total","Percentage",null,"Summary - LAC / CL - 31 March 21","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",13,{"$f":" 100/462*B193","v":2.8138528138528138},null,"EEA national or EU residence rights ",{"$f":"B193+B194+B195","v":14},{"$f":" 100/461*F193","v":3.0368763557483733}]
["Indefinite leave to remain (EU Settlement Scheme)",1,{"$f":" 100/462*B194","v":0.21645021645021645},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B199+B200","v":0},{"$f":" 100/461*F194","v":0}]
["Leave to remain (EU Settlement Scheme)",0,0,null,"No current immigration permission",{"$f":"B211+B208+B203","v":49},10.629067245119305]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B213+B210+B212+B209+B201","v":189},40.99783080260304]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B205+B206+B207+B204+B202+B198+B197+B196","v":208},45.119305856832973]
["Limited Leave with Recourse to Public Funds (other)",20,4.329004329004329,null,"British",{"$f":"B214","v":1},0.21691973969631237]
["Limited leave with NRPF (10 year route)",0,0]
["Limited leave with NRPF (other)",0,0]
["UASC leave",12,2.5974025974025974]
["Indefinite Leave",11,2.3809523809523809]
["No record held by HO (non EEA)",19,4.112554112554113]
["Humanitarian Protection",15,3.2467532467532467]
["Refugee Status",161,34.848484848484851]
["Discretionary leave - trafficking",1,0.21645021645021645]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",1,0.21645021645021645]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",21,4.545454545454545]
["In Country Asylum Seeker",4,0.86580086580086579]
["Illegal entrant - asylum claimed 'no'",29,6.2770562770562766]
["Illegal entrant - asylum claimed 'yes'",151,32.683982683982684]
["Port Case",1,0.21645021645021645]
["British",1,0.21645021645021645]
[]
[]
[]
["Immigration status families - all referrals for the year","Total","Percentage",null,"Summary - families referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",44,{"$f":" 100/252*B219","v":17.460317460317459},null,"EEA national or EU residence rights ",{"$f":"B219+B220+B221","v":88},{"$f":" 100/252*F219","v":34.920634920634917}]
["Indefinite leave to remain (EU Settlement Scheme)",16,{"$f":" 100/252*B220","v":6.3492063492063489},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B225+B226","v":40},{"$f":" 100/252*F220","v":15.873015873015872}]
["Leave to remain (EU Settlement Scheme)",28,11.111111111111111,null,"No current immigration permission",{"$f":"B237+B234+B229","v":44},18]
["Limited leave with recourse to public funds (10 year route)",10,3.9682539682539679,null,"Asylum seeker / asylum seeker ARE",{"$f":"B239+B236+B238+B235+B227","v":39},15.476190476190474]
["Limited leave with recourse to public funds (following COC)",4,1.5873015873015872,null,"Leave to Remain (LTR) with recourse ",{"$f":"B231+B232+B233+B230+B228+B224+B223+B222","v":39},15.476190476190474]
["Limited Leave with Recourse to Public Funds (other)",7,2.7777777777777777,null,"British",{"$f":"B240","v":2},0.79365079365079361]
["Limited leave with NRPF (10 year route)",15,5.9523809523809517]
["Limited leave with NRPF (other)",25,9.9206349206349209]
["UASC leave",0,0]
["Indefinite Leave",7,2.7777777777777777]
["No record held by HO (non EEA)",14,5.5555555555555554]
["Humanitarian Protection",0,0]
["Refugee Status",5,1.984126984126984]
["Discretionary leave - trafficking",0,0]
["DDV Concession",6,2.3809523809523809]
["Over-stayer / Deception / Breach - asylum claimed 'no'",23,9.1269841269841265]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",10,3.9682539682539679]
["In Country Asylum Seeker",2,0.79365079365079361]
["Illegal entrant - asylum claimed 'no'",7,2.7777777777777777]
["Illegal entrant - asylum claimed 'yes'",26,10.317460317460316]
["Port Case",1,0.3968253968253968]
["British",2,0.79365079365079361]
[]
[]
[]
["Immigration status adults - all referrals for the year","Total","Percentage",null,"Summary - adults referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",9,{"$f":" 100/72*B245","v":12.5},null,"EEA national or EU residence rights ",{"$f":"B245+B246+B247","v":23},{"$f":" 100/72*F245","v":31.944444444444443}]
["Indefinite leave to remain (EU Settlement Scheme)",2,{"$f":" 100/72*B246","v":2.7777777777777777},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B251+B252","v":6},{"$f":" 100/72*F246","v":8.3333333333333321}]
["Leave to remain (EU Settlement Scheme)",12,16.666666666666664,null,"No current immigration permission",{"$f":"B263+B260+B255","v":23},31.944444444444443]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B265+B262+B264+B261+B253","v":14},19.444444444444443]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B257+B258+B259+B256+B254+B250+B249+B248","v":4},5.5555555555555554]
["Limited Leave with Recourse to Public Funds (other)",0,0,null,"British",{"$f":"B266","v":2},2.7777777777777777]
["Limited leave with NRPF (10 year route)",3,4.1666666666666661]
["Limited leave with NRPF (other)",3,4.1666666666666661]
["UASC leave",0,0]
["Indefinite Leave",2,2.7777777777777777]
["No record held by HO (non EEA)",13,18.055555555555554]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",2,2.7777777777777777]
["Over-stayer / Deception / Breach - asylum claimed 'no'",7,9.7222222222222214]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",5,6.9444444444444446]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",3,4.1666666666666661]
["Illegal entrant - asylum claimed 'yes'",7,9.7222222222222214]
["Port Case",2,2.7777777777777777]
["British",2,2.7777777777777777]

{"sheet":"Greater London","index":3,"n_rows":261,"n_cols":7,"rows_kept":261,"cut":false,"hidden":false,"merged":[]}
["Description - all local authorities 2020-2021","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of local authorities subscribing at end of quarter",30,30,30,30]
["Number of local authorities with data uploaded at end of quarter - all case types",30,30,30,30]
["Number of local authorities with data for family cases",30,30,30,30]
["Number of local authorities with data for adult cases",23,22,22,22]
["Number of local authorities with data for children / care leaver cases",13,14,14,14]
[]
[]
[]
["Family cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",995,1002,1087,1045]
["Number of dependants of financially supported households at end of quarter",1814,1785,1914,1809]
["Total weekly spend for the cases supported at the end of the quarter",314275,323450,356091,355416]
["Average annual cost per case",{"$f":"B13/B11*52","v":16424.422110552761},{"$f":"C13/C11*52","v":16785.828343313377},{"$f":"D13/D11*52","v":17034.712051517941},17685.772248803827]
["Average annual cost (weekly spend X 52)",{"$f":"B13*52","v":16342300},{"$f":"C13*52","v":16819400},{"$f":"D13*52","v":18516732},18481632]
["Average number of days on support, cases open at end of quarter",536,552,552,569]
["Of Row 11 - Number that are non EEA and unresolved",767,779,850,794]
["Of Row 11 - EEA national or EEA family member / derivative rights",88,99,95,98]
["Of Row 11 - Number that are non EEA but have LTR with recourse",140,124,142,153]
["Of Row 17 - Number that are 1000 day cases",112,109,112,110]
["Of Row 18 - Number of 1000 day EEA national cases without 'settled status ",19,20,18,13]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 20 / row 17)",0.15,0.14000000000000001,0.13,0.14000000000000001]
["EEA 1000 day cases, percentage of unresolved cohort (row 21 / row 18)",0.2,0.22,0.2,0.14000000000000001]
["Total number of referrals per quarter",564,517,476,431]
["Total number of new cases taken on for support within quarter",262,224,231,169]
["Total number of supported cases closed within quarter",147,217,161,195]
[]
[]
[]
["Adult cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",472,460,490,494]
["Total weekly spend for the cases supported at the end of the quarter",178686,175429,186636,186270]
["Average annual cost per case",{"$f":"B32*52/B31","v":19685.745762711864},{"$f":"C32*52/C31","v":19831.104347826087},{"$f":"D32*52/D31","v":19806.269387755103},19607.36842105263]
["Average annual cost (weekly spend X 52)",{"$f":"B32*52","v":9291672},{"$f":"C32*52","v":9122308},{"$f":"D32*52","v":9705072},9686040]
["Average number of days on support, cases open at end of quarter",962,991,945,949]
["Of Row 31 - Number that are non EEA and unresolved",381,372,384,384]
["Of Row 31 - EEA national or EEA family member / derivative rights",69,70,86,79]
["Of Row 31 - Number that are non EEA but have LTR with recourse",22,18,20,31]
["Of Row 31 - Number that are 1000 day cases",128,130,134,132]
["Of Row 31 - Number of 1000 day EEA national cases without 'settled status ",15,14,14,11]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 39 / row 36)",0.34,0.35,0.35,0.34]
["EEA 1000 day cases, percentage of unresolved cohort (row 40 / row 37)",0.23,0.21,0.16,0.14000000000000001]
["Total number of referrals per quarter",277,244,258,265]
["Total number of new cases taken on for support within quarter",108,52,70,61]
["Total number of supported cases closed within quarter",48,60,43,57]
[]
[]
[]
[]
["Looked after children and care leavers","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of open cases at end of quarter",1143,1175,1244,1327]
["Of which under age of 18",85,105,151,177]
["Of which aged 18-21",569,584,598,660]
["Of which aged 21 and over",489,486,495,490]
["Of number of open cases (row 51), number financially supported",415,436,453,452]
["Total weekly spend for the cases financially supported at end of quarter",153663,164871,170556,176229]
["Average annual cost per case",{"$f":"B56/B55*52","v":19254.159036144578},{"$f":"C56/C55*52","v":19663.51376146789},{"$f":"D56/D55*52","v":19578.172185430463},20274.132743362832]
["Average annual cost (weekly spend X 52)",{"$f":"B56*52","v":7990476},{"$f":"C56*52","v":8573292},{"$f":"D56*52","v":8868912},9163908]
["Total number of new cases recorded within the quarter",65,55,100,159]
["Total number of cases closed ",52,23,31,76]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason family and adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",31,{"$f":" 100/926*B71","v":3.3477321814254859}]
["Non-EEA national - left the UK (HO / LA funded)",7,{"$f":" 100/926*B72","v":0.75593952483801297}]
["Accessed Asylum Support",69,7.4514038876889845]
["No longer eligible",{"$f":"26+83","v":109},11.771058315334773]
["EEA national / family member - accessed benefits / employment",31,3.3477321814254859]
["Granted Leave to Remain",{"$f":"29+638+12","v":679},73.32613390928725]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason family cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",17,{"$f":" 100/714*B93","v":2.3809523809523809}]
["Non-EEA national - left the UK (HO / LA funded)",5,{"$f":" 100/714*B94","v":0.70028011204481788}]
["Accessed Asylum Support",41,5.742296918767507]
["No longer eligible",{"$f":"1+44","v":45},6.3025210084033612]
["EEA national / family member - accessed benefits / employment",22,3.081232492997199]
["Granted Leave to Remain",{"$f":"10+26+548","v":584},81.792717086834742]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",14,{"$f":" 100/212*B115","v":6.6037735849056602}]
["Non-EEA national - left the UK (HO / LA funded)",2,{"$f":" 100/212*B116","v":0.94339622641509435}]
["Accessed Asylum Support",28,13.20754716981132]
["No longer eligible",39,18.39622641509434]
["Deceased",25,11.79245283018868]
["EEA national / family member - accessed benefits / employment",9,4.2452830188679247]
["Granted Leave to Remain",{"$f":"2+3+90","v":95},44.811320754716981]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Immigration status families - open cases as of 31 March 2021","Total","Percentage",null,"Summary - families - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",60,{"$f":" 100/1017*B136","v":5.8997050147492631},null,"EEA national or EU residence rights ",{"$f":"B136+B137+B138","v":98},{"$f":" 100/1017*F136","v":9.636184857423796}]
["Indefinite leave to remain (EU Settlement Scheme)",7,{"$f":" 100/1017*B137","v":0.68829891838741397},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B142+B143","v":92},{"$f":" 100/1017*F137","v":9.0462143559488695}]
["Leave to remain (EU Settlement Scheme)",31,3.0481809242871192,null,"No current immigration permission",{"$f":"B154+B151+B146","v":540},53.097345132743364]
["Limited leave with recourse to public funds (10 year route)",83,8.1612586037364796,null,"Asylum seeker / asylum seeker ARE",{"$f":"B156+B153+B155+B152+B144","v":118},11.60275319567355]
["Limited leave with recourse to public funds (following COC)",32,3.1465093411996068,null,"Leave to Remain (LTR) with recourse ",{"$f":"B148+B149+B150+B147+B145+B141+B140+B139","v":167},16.420845624385446]
["Limited Leave with Recourse to Public Funds (other)",17,1.671583087512291,null,"British",{"$f":"B157","v":2},0.19665683382497542]
["Limited leave with NRPF (10 year route)",44,4.3264503441494595]
["Limited leave with NRPF (other)",48,4.71976401179941]
["UASC leave",0,0]
["No record held by HO (non EEA)",23,2.2615535889872174]
["Humanitarian Protection",1,9.8328416912487712E-2]
["Refugee Status",2,0.19665683382497542]
["Indefinite leave   ",10,0.98328416912487715]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",476,46.804326450344149]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",64,6.2930186823992136]
["In Country Asylum Seeker",3,0.29498525073746312]
["Illegal entrant - asylum claimed 'no'",63,6.1946902654867255]
["Illegal entrant - asylum claimed 'yes'",39,3.834808259587021]
["Port Case",12,1.1799410029498525]
["British",2,0.19665683382497542]
[]
[]
[]
["Adults - open cases as of 31 March 2021","Total","Percentage",null,"Summary - adults - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",70,{"$f":" 100/478*B162","v":14.644351464435147},null,"EEA national or EU residence rights ",{"$f":"B162+B163+B164","v":79},16]
["Indefinite leave to remain (EU Settlement Scheme)",1,{"$f":" 100/478*B163","v":0.20920502092050208},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B168+B169","v":22},{"$f":" 100/478*F163","v":4.6025104602510458}]
["Leave to remain (EU Settlement Scheme)",8,1.6736401673640167,null,"No current immigration permission",{"$f":"B180+B177+B172","v":209},43.723849372384933]
["Limited leave with recourse to public funds (10 year route)",9,1.8828451882845187,null,"Asylum seeker / asylum seeker ARE",{"$f":"B182+B179+B181+B178+B170","v":137},28.661087866108787]
["Limited leave with recourse to public funds (following COC)",3,0.62761506276150625,null,"Leave to Remain (LTR) with recourse ",{"$f":"B174+B175+B176+B173+B171+B167+B166+B165","v":30},6.2761506276150625]
["Limited Leave with Recourse to Public Funds (other)",16,3.3472803347280333,null,"British",{"$f":"B183","v":1},0.20920502092050208]
["Limited leave with NRPF (10 year route)",8,1.6736401673640167]
["Limited leave with NRPF (other)",14,2.9288702928870292]
["UASC leave",0,0]
["Indefinite Leave",1,0.20920502092050208]
["No record held by HO (non EEA)",36,7.531380753138075]
["Humanitarian Protection",0,0]
["Refugee Status",1,0.20920502092050208]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",146,30.543933054393303]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",62,12.97071129707113]
["In Country Asylum Seeker",10,2.0920502092050208]
["Illegal entrant - asylum claimed 'no'",27,5.6485355648535567]
["Illegal entrant - asylum claimed 'yes'",56,11.715481171548117]
["Port Case",9,1.8828451882845187]
["British",1,0.20920502092050208]
[]
[]
[]
["looked after children and care leavers - open cases as of 31 March 2021","Total","Percentage",null,"Summary - LAC / CL - 31 March 21","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",39,{"$f":" 100/1246*B188","v":3.130016051364366},null,"EEA national or EU residence rights ",{"$f":"B188+B189+B190","v":43},{"$f":" 100/1246*F188","v":3.451043338683788}]
["Indefinite leave to remain (EU Settlement Scheme)",1,{"$f":" 100/1246*B189","v":8.0256821829855537E-2},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B194+B195","v":10},{"$f":" 100/1246*F189","v":0.8025682182985554}]
["Leave to remain (EU Settlement Scheme)",3,0.2407704654895666,null,"No current immigration permission",{"$f":"B206+B203+B198","v":107},8.5874799357945424]
["Limited leave with recourse to public funds (10 year route)",14,1.1235955056179776,null,"Asylum seeker / asylum seeker ARE",{"$f":"B208+B205+B207+B204+B196","v":878},71]
["Limited leave with recourse to public funds (following COC)",6,0.4815409309791332,null,"Leave to Remain (LTR) with recourse ",{"$f":"B200+B201+B202+B199+B197+B193+B192+B191","v":203},16.292134831460675]
["Limited Leave with Recourse to Public Funds (other)",49,3.9325842696629212,null,"British",{"$f":"B209","v":5},0.4012841091492777]
["Limited leave with NRPF (10 year route)",5,0.4012841091492777]
["Limited leave with NRPF (other)",5,0.4012841091492777]
["UASC leave",24,1.9261637239165328]
["Indefinite Leave",16,1.2841091492776886]
["No record held by HO (non EEA)",50,4.0128410914927768]
["Humanitarian Protection",7,0.5617977528089888]
["Refugee Status",111,8.9085072231139648]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",25,2.0064205457463884]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",116,9.3097913322632415]
["In Country Asylum Seeker",53,4.2536115569823432]
["Illegal entrant - asylum claimed 'no'",32,2.5682182985553772]
["Illegal entrant - asylum claimed 'yes'",674,54.09309791332263]
["Port Case",11,0.8828250401284109]
["British",5,0.4012841091492777]
[]
[]
[]
["Immigration status families - all referrals for the year","Total","Percentage",null,"Summary - families referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",136,{"$f":" 100/1916*B214","v":7.0981210855949897},null,"EEA national or EU residence rights ",{"$f":"B214+B215+B216","v":240},{"$f":" 100/1916*F214","v":12.526096033402922}]
["Indefinite leave to remain (EU Settlement Scheme)",29,{"$f":" 100/1916*B215","v":1.5135699373695197},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B220+B221","v":391},{"$f":" 100/1916*F215","v":20.407098121085596}]
["Leave to remain (EU Settlement Scheme)",75,3.9144050104384132,null,"No current immigration permission",{"$f":"B232+B229+B224","v":663},34.603340292275576]
["Limited leave with recourse to public funds (10 year route)",88,4.5929018789144047,null,"Asylum seeker / asylum seeker ARE",{"$f":"B234+B231+B233+B230+B222","v":225},11.743215031315239]
["Limited leave with recourse to public funds (following COC)",141,7.3590814196242169,null,"Leave to Remain (LTR) with recourse ",{"$f":"B226+B227+B228+B225+B223+B219+B218+B217","v":369},19.258872651356992]
["Limited Leave with Recourse to Public Funds (other)",43,2.2442588726513568,null,"British",{"$f":"B235","v":28},1.4613778705636742]
["Limited leave with NRPF (10 year route)",243,12.682672233820458]
["Limited leave with NRPF (other)",148,7.7244258872651352]
["UASC leave",0,0]
["Indefinite Leave",38,1.9832985386221293]
["No record held by HO (non EEA)",115,6.0020876826722338]
["Humanitarian Protection",3,0.15657620041753653]
["Refugee Status",17,0.88726513569937371]
["Discretionary leave - trafficking",0,0]
["DDV Concession",39,2.0354906054279751]
["Over-stayer / Deception / Breach - asylum claimed 'no'",493,25.730688935281837]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",86,4.4885177453027136]
["In Country Asylum Seeker",34,1.7745302713987474]
["Illegal entrant - asylum claimed 'no'",55,2.8705636743215033]
["Illegal entrant - asylum claimed 'yes'",86,4.4885177453027136]
["Port Case",19,0.99164926931106467]
["British",28,1.4613778705636742]
[]
[]
[]
["Immigration status adults - all referrals for the year","Total","Percentage",null,"Summary - adults referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",150,{"$f":" 100/987*B240","v":15.19756838905775},null,"EEA national or EU residence rights ",{"$f":"B240+B241+B242","v":211},{"$f":" 100/987*F240","v":21.377912867274567}]
["Indefinite leave to remain (EU Settlement Scheme)",27,{"$f":" 100/987*B241","v":2.735562310030395},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B246+B247","v":86},{"$f":" 100/987*F241","v":8.7132725430597766}]
["Leave to remain (EU Settlement Scheme)",34,3.4447821681864235,null,"No current immigration permission",{"$f":"B258+B255+B250","v":327},33.130699088145896]
["Limited leave with recourse to public funds (10 year route)",14,1.4184397163120566,null,"Asylum seeker / asylum seeker ARE",{"$f":"B260+B257+B259+B256+B248","v":226},22.897669706180345]
["Limited leave with recourse to public funds (following COC)",11,1.1144883485309016,null,"Leave to Remain (LTR) with recourse ",{"$f":"B252+B253+B254+B251+B249+B245+B244+B243","v":124},12.563323201621074]
["Limited Leave with Recourse to Public Funds (other)",26,2.6342451874366768,null,"British",{"$f":"B261","v":13},1.3171225937183384]
["Limited leave with NRPF (10 year route)",44,4.4579533941236065]
["Limited leave with NRPF (other)",42,4.2553191489361701]
["UASC leave",0,0]
["Indefinite Leave",54,5.4711246200607899]
["No record held by HO (non EEA)",110,11.144883485309016]
["Humanitarian Protection",2,0.20263424518743667]
["Refugee Status",17,1.7223910840932117]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",193,19.55420466058764]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",99,10.030395136778115]
["In Country Asylum Seeker",15,1.519756838905775]
["Illegal entrant - asylum claimed 'no'",24,2.43161094224924]
["Illegal entrant - asylum claimed 'yes'",96,9.7264437689969601]
["Port Case",16,1.6210739614994933]
["British",13,1.3171225937183384]

{"sheet":"North East","index":4,"n_rows":240,"n_cols":7,"rows_kept":240,"cut":false,"hidden":false,"merged":[]}
["Description - all local authorities 2020-2021","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of local authorities subscribing at end of quarter",3,3,3,3]
["Number of local authorities with data uploaded at end of quarter - all case types",3,3,3,3]
["Number of local authorities with data for family cases",3,3,3,3]
["Number of local authorities with data for adult cases",3,3,3,3]
["Number of local authorities with data for children / care leaver cases",1,1,1,1]
[]
[]
[]
["Family cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",10,10,8,8]
["Number of dependants of financially supported households at end of quarter",17,17,16,16]
["Total weekly spend for the cases supported at the end of the quarter",3005,3007,2713,2713]
["Average annual cost per case",{"$f":"B13*52/B11","v":15626},{"$f":"C13*52/C11","v":15636.4},17634.5,17634.5]
["Average annual cost (weekly spend X 52)",{"$f":"B13*52","v":156260},{"$f":"C13*52","v":156364},141076,141076]
["Average number of days on support, cases open at end of quarter",1286,1378,1461,1551]
["Of Row 11 - Number that are non EEA and unresolved",6,6,4,4]
["Of Row 11 - EEA national or EEA family member / derivative rights",1,1,1,1]
["Of Row 11 - Number that are non EEA but have LTR with recourse",3,3,3,3]
["Of Row 17 - Number that are 1000 day cases",5,6,4,4]
["Of Row 18 - Number of 1000 day EEA national cases without 'settled status ",0,1,0,0]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 20 / row 17)",0.83,1,1,1]
["EEA 1000 day cases, percentage of unresolved cohort (row 21 / row 18)",0,1,0,0]
["Total number of referrals per quarter",1,0,1,0]
["Total number of new cases taken on for support within quarter",1,0,0,0]
["Total number of supported cases closed within quarter",0,0,2,0]
[]
[]
[]
["Adult cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",10,9,9,8]
["Total weekly spend for the cases supported at the end of the quarter",2393,2112,2119,1883]
["Average annual cost per case",{"$f":"B32*52/B31","v":12443.6},{"$f":"C32*52/C31","v":12202.666666666666},12243.111111111111,12239.5]
["Average annual cost (weekly spend X 52)",{"$f":"B32*52","v":124436},{"$f":"C32*52","v":109824},110188,97916]
["Average number of days on support, cases open at end of quarter",1805,1884,1976,2160]
["Of Row 31 - Number that are non EEA and unresolved",9,7,7,7]
["Of Row 31 - EEA national or EEA family member / derivative rights",1,1,1,1]
["Of Row 31 - Number that are non EEA but have LTR with recourse",0,1,1,0]
["Of Row 31 - Number that are 1000 day cases",7,6,6,6]
["Of Row 31 - Number of 1000 day EEA national cases without 'settled status ",0,1,1,1]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 39 / row 36)",0.78,0.86,0.86,0.86]
["EEA 1000 day cases, percentage of unresolved cohort (row 40 / row 37)",0,1,1,1]
["Total number of referrals per quarter",1,4,5,1]
["Total number of new cases taken on for support within quarter",0,0,0,0]
["Total number of supported cases closed within quarter",1,1,0,1]
[]
[]
[]
[]
[]
["Looked after children and care leavers","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of open cases at end of quarter",12,12,12,12]
["Of which under age of 18",0,0,0,0]
["Of which aged 18-21",3,3,3,3]
["Of which aged 21 and over",9,9,9,9]
["Of number of open cases (row 52), number financially supported",8,8,7,8]
["Total weekly spend for the cases financially supported at end of quarter",1769,1769,1543,1769]
["Average annual cost per case",{"$f":"B57/B56*52","v":11498.5},{"$f":"C57/C56*52","v":11498.5},11462.285714285714,11498.5]
["Average annual cost (weekly spend X 52)",{"$f":"B57*52","v":91988},{"$f":"C57*52","v":91988},80236,91988]
["Total number of new cases recorded within the quarter",0,0,0,0]
["Total number of cases closed ",0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason family and adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",0,{"$f":" 100/5*B71","v":0}]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/5*B72","v":0}]
["Accessed Asylum Support",0,0]
["No longer eligible",2,40]
["EEA national / family member - accessed benefits / employment",0,0]
["Granted Leave to Remain",3,60]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason family cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",null,{"$f":" 100/714*B93","v":0}]
["Non-EEA national - left the UK (HO / LA funded)",null,{"$f":" 100/714*B94","v":0}]
["Accessed Asylum Support",null,0]
["No longer eligible",null,0]
["EEA national / family member - accessed benefits / employment",null,0]
["Granted Leave to Remain",null,0]
[]
[]
[]
["Closure reason adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",null,{"$f":" 100/212*B103","v":0}]
["Non-EEA national - left the UK (HO / LA funded)",null,{"$f":" 100/212*B104","v":0}]
["Accessed Asylum Support",null,0]
["No longer eligible",null,0]
["Deceased",null,0]
["EEA national / family member - accessed benefits / employment",null,0]
["Granted Leave to Remain",null,0]
[]
[]
[]
["Immigration status families - open cases as of 31 March 2021","Total","Percentage",null,"Summary - families - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",1,{"$f":" 100/8*B114","v":12.5},null,"EEA national or EU residence rights ",{"$f":"B114+B115+B116","v":1},{"$f":" 100/8*F114","v":12.5}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/8*B115","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B120+B121","v":1},{"$f":" 100/8*F115","v":12.5}]
["Leave to remain (EU Settlement Scheme)",0,0,null,"No current immigration permission",{"$f":"B132+B129+B124","v":1},12.5]
["Limited leave with recourse to public funds (10 year route)",2,25,null,"Asylum seeker / asylum seeker ARE",{"$f":"B134+B131+B133+B130+B122","v":2},25]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B126+B127+B128+B125+B123+B119+B118+B117","v":3},37]
["Limited Leave with Recourse to Public Funds (other)",1,12.5,null,"British",{"$f":"B135","v":0},0]
["Limited leave with NRPF (10 year route)",0,0]
["Limited leave with NRPF (other)",1,12.5]
["UASC leave",0,0]
["No record held by HO (non EEA)",0,0]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Indefinite leave   ",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",0,0]
["In Country Asylum Seeker",2,25]
["Illegal entrant - asylum claimed 'no'",1,12.5]
["Illegal entrant - asylum claimed 'yes'",0,0]
["Port Case",0,0]
["British",0,0]
[]
[]
[]
[]
["Adults - open cases as of 31 March 2021","Total","Percentage",null,"Summary - adults - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",1,{"$f":" 100/8*B141","v":12.5},null,"EEA national or EU residence rights ",{"$f":"B141+B142+B143","v":1},12]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/8*B142","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B147+B148","v":0},{"$f":" 100/8*F142","v":0}]
["Leave to remain (EU Settlement Scheme)",0,0,null,"No current immigration permission",{"$f":"B159+B156+B151","v":0},0]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B161+B158+B160+B157+B149","v":7},87.5]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B153+B154+B155+B152+B150+B146+B145+B144","v":0},0]
["Limited Leave with Recourse to Public Funds (other)",0,0,null,"British",{"$f":"B162","v":0},0]
["Limited leave with NRPF (10 year route)",0,0]
["Limited leave with NRPF (other)",0,0]
["UASC leave",0,0]
["Indefinite Leave",0,0]
["No record held by HO (non EEA)",0,0]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",2,25]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",0,0]
["Illegal entrant - asylum claimed 'yes'",5,62.5]
["Port Case",0,0]
["British",0,0]
[]
[]
[]
["looked after children and care leavers - open cases as of 31 March 2021","Total","Percentage",null,"Summary - LAC / CL - 31 March 21","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",null,null,null,"EEA national or EU residence rights "]
["Indefinite leave to remain (EU Settlement Scheme)",null,null,null,"Leave to Remain (LTR) with NRPF "]
["Leave to remain (EU Settlement Scheme)",null,null,null,"No current immigration permission"]
["Limited leave with recourse to public funds (10 year route)",null,null,null,"Asylum seeker / asylum seeker ARE"]
["Limited leave with recourse to public funds (following COC)",null,null,null,"Leave to Remain (LTR) with recourse "]
["Limited Leave with Recourse to Public Funds (other)",null,null,null,"British"]
["Limited leave with NRPF (10 year route)"]
["Limited leave with NRPF (other)"]
["UASC leave"]
["Indefinite Leave"]
["No record held by HO (non EEA)"]
["Humanitarian Protection"]
["Refugee Status"]
["Discretionary leave - trafficking"]
["DDV Concession"]
["Over-stayer / Deception / Breach - asylum claimed 'no'"]
["Over-stayer / Deception / Breach - asylum claimed 'yes'"]
["In Country Asylum Seeker"]
["Illegal entrant - asylum claimed 'no'"]
["Illegal entrant - asylum claimed 'yes'"]
["Port Case"]
["British"]
[]
[]
[]
["Immigration status families - all referrals for the year","Total","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS"]
["Indefinite leave to remain (EU Settlement Scheme)"]
["Leave to remain (EU Settlement Scheme)"]
["Limited leave with recourse to public funds (10 year route)"]
["Limited leave with recourse to public funds (following COC)"]
["Limited Leave with Recourse to Public Funds (other)"]
["Limited leave with NRPF (10 year route)"]
["Limited leave with NRPF (other)"]
["UASC leave"]
["Indefinite Leave"]
["No record held by HO (non EEA)"]
["Humanitarian Protection"]
["Refugee Status"]
["Discretionary leave - trafficking"]
["DDV Concession"]
["Over-stayer / Deception / Breach - asylum claimed 'no'"]
["Over-stayer / Deception / Breach - asylum claimed 'yes'"]
["In Country Asylum Seeker"]
["Illegal entrant - asylum claimed 'no'"]
["Illegal entrant - asylum claimed 'yes'"]
["Port Case"]
["British"]
[]
[]
[]
["Immigration status adults - all referrals for the year","Total","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS"]
["Indefinite leave to remain (EU Settlement Scheme)"]
["Leave to remain (EU Settlement Scheme)"]
["Limited leave with recourse to public funds (10 year route)"]
["Limited leave with recourse to public funds (following COC)"]
["Limited Leave with Recourse to Public Funds (other)"]
["Limited leave with NRPF (10 year route)"]
["Limited leave with NRPF (other)"]
["UASC leave"]
["Indefinite Leave"]
["No record held by HO (non EEA)"]
["Humanitarian Protection"]
["Refugee Status"]
["Discretionary leave - trafficking"]
["DDV Concession"]
["Over-stayer / Deception / Breach - asylum claimed 'no'"]
["Over-stayer / Deception / Breach - asylum claimed 'yes'"]
["In Country Asylum Seeker"]
["Illegal entrant - asylum claimed 'no'"]
["Illegal entrant - asylum claimed 'yes'"]
["Port Case"]
["British"]

{"sheet":"North West","index":5,"n_rows":262,"n_cols":7,"rows_kept":262,"cut":false,"hidden":false,"merged":[]}
["Description - all local authorities 2020-2021","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of local authorities subscribing at end of quarter",2,2,2,2]
["Number of local authorities with data uploaded at end of quarter - all case types",2,2,2,2]
["Number of local authorities with data for family cases",2,2,2,2]
["Number of local authorities with data for adult cases",1,2,2,1]
["Number of local authorities with data for children / care leaver cases",0,0,0,2]
[]
[]
[]
["Family cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",50,45,38,38]
["Number of dependants of financially supported households at end of quarter",101,91,77,77]
["Total weekly spend for the cases supported at the end of the quarter",12922,12279,11501,11560]
["Average annual cost per case",{"$f":"B13*52/B11","v":13438.88},{"$f":"C13*52/C11","v":14189.066666666668},{"$f":"D13*52/D11","v":15738.21052631579},15818.947368421053]
["Average annual cost (weekly spend X 52)",{"$f":"B13*52","v":671944},{"$f":"C13*52","v":638508},598052,601120]
["Average number of days on support, cases open at end of quarter",377,385,454,493]
["Of Row 11 - Number that are non EEA and unresolved",44,37,34,34]
["Of Row 11 - EEA national or EEA family member / derivative rights",2,3,0,0]
["Of Row 11 - Number that are non EEA but have LTR with recourse",4,5,4,4]
["Of Row 17 - Number that are 1000 day cases",7,5,4,7]
["Of Row 18 - Number of 1000 day EEA national cases without 'settled status ",0,0,0,0]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 20 / row 17)",0.16,0.14000000000000001,0.12,0.21]
["EEA 1000 day cases, percentage of unresolved cohort (row 21 / row 18)",0,0,0,0]
["Total number of referrals per quarter",63,40,29,40]
["Total number of new cases taken on for support within quarter",24,16,13,12]
["Total number of supported cases closed within quarter",17,21,20,12]
[]
[]
[]
[]
["Adult cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",20,22,21,21]
["Total weekly spend for the cases supported at the end of the quarter",6837,7283,7290,5432]
["Average annual cost per case",{"$f":"B33*52/B32","v":17776.2},{"$f":"C33*52/C32","v":17214.363636363636},18051.428571428572,13450.666666666666]
["Average annual cost (weekly spend X 52)",{"$f":"B33*52","v":355524},{"$f":"C33*52","v":378716},379080,282464]
["Average number of days on support, cases open at end of quarter",844,824,802,831]
["Of Row 31 - Number that are non EEA and unresolved",13,14,16,15]
["Of Row 31 - EEA national or EEA family member / derivative rights",7,8,5,6]
["Of Row 31 - Number that are non EEA but have LTR with recourse",0,0,0,0]
["Of Row 31 - Number that are 1000 day cases",6,7,6,5]
["Of Row 31 - Number of 1000 day EEA national cases without 'settled status ",0,0,0,1]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 39 / row 36)",0.46,0.5,0.38,0.33]
["EEA 1000 day cases, percentage of unresolved cohort (row 40 / row 37)",0,0,0,0.17]
["Total number of referrals per quarter",32,23,20,20]
["Total number of new cases taken on for support within quarter",2,6,6,4]
["Total number of supported cases closed within quarter",5,4,7,4]
[]
[]
[]
[]
[]
[]
["Looked after children and care leavers","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of open cases at end of quarter"]
["Of which under age of 18"]
["Of which aged 18-21"]
["Of which aged 21 and over"]
["Of number of open cases (row 54), number financially supported"]
["Total weekly spend for the cases financially supported at end of quarter"]
["Average annual cost per case"]
["Average annual cost (weekly spend X 52)"]
["Total number of new cases recorded within the quarter"]
["Total number of cases closed "]
[]
[]
[]
[]
[]
[]
["Closure reason family and adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",3,{"$f":" 100/90*B71","v":3.3333333333333335}]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/90*B72","v":0}]
["Accessed Asylum Support",4,4.4444444444444446]
["No longer eligible",9,10]
["EEA national / family member - accessed benefits / employment",5,5.5555555555555554]
["Granted Leave to Remain",{"$f":"2+3+64","v":69},76.666666666666671]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason family cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",1,{"$f":" 100/70*B93","v":1.4285714285714286}]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/70*B94","v":0}]
["Accessed Asylum Support",1,1.4285714285714286]
["No longer eligible",6,8.5714285714285712]
["EEA national / family member - accessed benefits / employment",4,5.7142857142857144]
["Granted Leave to Remain",{"$f":"2+2+54","v":58},82.857142857142861]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",2,{"$f":" 100/20*B115","v":10}]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/20*B116","v":0}]
["Accessed Asylum Support",3,15]
["No longer eligible",2,10]
["Deceased",1,5]
["EEA national / family member - accessed benefits / employment",1,5]
["Granted Leave to Remain",11,55]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Immigration status families - open cases as of 31 March 2021","Total","Percentage",null,"Summary - families - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",0,{"$f":" 100/37*B137","v":0},null,"EEA national or EU residence rights ",{"$f":"B137+B138+B139","v":0},{"$f":" 100/37*F137","v":0}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/37*B138","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B143+B144","v":2},6]
["Leave to remain (EU Settlement Scheme)",0,0,null,"No current immigration permission",{"$f":"B155+B152+B147","v":26},{"$f":" 100/37*F139","v":70.270270270270274}]
["Limited leave with recourse to public funds (10 year route)",2,5.4054054054054053,null,"Asylum seeker / asylum seeker ARE",{"$f":"B157+B154+B156+B153+B145","v":6},16.216216216216218]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B149+B150+B151+B148+B146+B142+B141+B140","v":3},8.1081081081081088]
["Limited Leave with Recourse to Public Funds (other)",1,2.7027027027027026,null,"British",{"$f":"B158","v":0},0]
["Limited leave with NRPF (10 year route)",1,2.7027027027027026]
["Limited leave with NRPF (other)",1,2.7027027027027026]
["UASC leave",0,0]
["No record held by HO (non EEA)",0,0]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Indefinite leave   ",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",24,64.86486486486487]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",3,8.1081081081081088]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",2,5.4054054054054053]
["Illegal entrant - asylum claimed 'yes'",3,8.1081081081081088]
["Port Case",0,0]
["British",0,{"$f":" 100/37*B158","v":0}]
[]
[]
[]
["Adults - open cases as of 31 March 2021","Total","Percentage",null,"Summary - adults - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",6,{"$f":" 100/21*B163","v":28.571428571428569},null,"EEA national or EU residence rights ",{"$f":"B163+B164+B165","v":6},28]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/21*B164","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B169+B170","v":1},{"$f":" 100/21*F164","v":4.7619047619047619}]
["Leave to remain (EU Settlement Scheme)",0,0,null,"No current immigration permission",{"$f":"B181+B178+B173","v":6},28.571428571428569]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B183+B180+B182+B179+B171","v":8},38.095238095238095]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B175+B176+B177+B174+B172+B168+B167+B166","v":0},0]
["Limited Leave with Recourse to Public Funds (other)",0,0,null,"British",{"$f":"B184","v":0},0]
["Limited leave with NRPF (10 year route)",0,0]
["Limited leave with NRPF (other)",1,4.7619047619047619]
["UASC leave",0,0]
["Indefinite Leave",0,0]
["No record held by HO (non EEA)",0,0]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",6,28.571428571428569]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",2,9.5238095238095237]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",0,0]
["Illegal entrant - asylum claimed 'yes'",6,28.571428571428569]
["Port Case",0,0]
["British",0,0]
[]
[]
[]
["looked after children and care leavers - open cases as of 31 March 2021","Total","Percentage",null,"Summary - LAC / CL - 31 March 21","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",null,null,null,"EEA national or EU residence rights "]
["Indefinite leave to remain (EU Settlement Scheme)",null,null,null,"Leave to Remain (LTR) with NRPF "]
["Leave to remain (EU Settlement Scheme)",null,null,null,"No current immigration permission"]
["Limited leave with recourse to public funds (10 year route)",null,null,null,"Asylum seeker / asylum seeker ARE"]
["Limited leave with recourse to public funds (following COC)",null,null,null,"Leave to Remain (LTR) with recourse "]
["Limited Leave with Recourse to Public Funds (other)",null,null,null,"British"]
["Limited leave with NRPF (10 year route)"]
["Limited leave with NRPF (other)"]
["UASC leave"]
["Indefinite Leave"]
["No record held by HO (non EEA)"]
["Humanitarian Protection"]
["Refugee Status"]
["Discretionary leave - trafficking"]
["DDV Concession"]
["Over-stayer / Deception / Breach - asylum claimed 'no'"]
["Over-stayer / Deception / Breach - asylum claimed 'yes'"]
["In Country Asylum Seeker"]
["Illegal entrant - asylum claimed 'no'"]
["Illegal entrant - asylum claimed 'yes'"]
["Port Case"]
["British"]
[]
[]
[]
["Immigration status families - all referrals for the year","Total","Percentage",null,"Summary - families referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",14,{"$f":" 100/163*B215","v":8.5889570552147241},null,"EEA national or EU residence rights ",{"$f":"B215+B216+B217","v":21},{"$f":" 100/163*F215","v":12.883435582822086}]
["Indefinite leave to remain (EU Settlement Scheme)",1,{"$f":" 100/163*B216","v":0.61349693251533743},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B221+B222","v":46},{"$f":" 100/163*F216","v":28.220858895705522}]
["Leave to remain (EU Settlement Scheme)",6,3.6809815950920246,null,"No current immigration permission",{"$f":"B233+B230+B225","v":51},31.288343558282207]
["Limited leave with recourse to public funds (10 year route)",4,2.4539877300613497,null,"Asylum seeker / asylum seeker ARE",{"$f":"B235+B232+B234+B231+B223","v":20},12.269938650306749]
["Limited leave with recourse to public funds (following COC)",7,4.294478527607362,null,"Leave to Remain (LTR) with recourse ",{"$f":"B227+B228+B229+B226+B224+B220+B219+B218","v":25},15.337423312883436]
["Limited Leave with Recourse to Public Funds (other)",6,3.6809815950920246,null,"British",{"$f":"B236","v":0},0]
["Limited leave with NRPF (10 year route)",25,15.337423312883436]
["Limited leave with NRPF (other)",21,12.883435582822086]
["UASC leave",0,0]
["Indefinite Leave",2,1.2269938650306749]
["No record held by HO (non EEA)",10,6.1349693251533743]
["Humanitarian Protection",0,0]
["Refugee Status",3,1.8404907975460123]
["Discretionary leave - trafficking",0,0]
["DDV Concession",3,1.8404907975460123]
["Over-stayer / Deception / Breach - asylum claimed 'no'",38,23.312883435582823]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",9,5.5214723926380369]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",3,1.8404907975460123]
["Illegal entrant - asylum claimed 'yes'",7,4.294478527607362]
["Port Case",4,2.4539877300613497]
["British",0,0]
[]
[]
[]
["Immigration status adults - all referrals for the year","Total","Percentage",null,"Summary - adults referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",14,{"$f":" 100/21*B241","v":66.666666666666671},null,"EEA national or EU residence rights ",{"$f":"B241+B242+B243","v":15},0.17]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/21*B242","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B247+B248","v":15},0.17]
["Leave to remain (EU Settlement Scheme)",1,4.7619047619047619,null,"No current immigration permission",{"$f":"B259+B256+B251","v":28},0.31]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B261+B258+B260+B257+B249","v":26},0.28999999999999998]
["Limited leave with recourse to public funds (following COC)",1,4.7619047619047619,null,"Leave to Remain (LTR) with recourse ",{"$f":"B253+B254+B255+B252+B250+B246+B245+B244","v":5},0.05]
["Limited Leave with Recourse to Public Funds (other)",1,4.7619047619047619,null,"British",{"$f":"B262","v":1},0.01]
["Limited leave with NRPF (10 year route)",4,19.047619047619047]
["Limited leave with NRPF (other)",11,52.38095238095238]
["UASC leave",3,14.285714285714285]
["Indefinite Leave",0,0]
["No record held by HO (non EEA)",9,42.857142857142854]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",3,14.285714285714285]
["Over-stayer / Deception / Breach - asylum claimed 'no'",19,90.476190476190482]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",7,33.333333333333336]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",0,0]
["Illegal entrant - asylum claimed 'yes'",13,61.904761904761905]
["Port Case",3,14.285714285714285]
["British",1,4.7619047619047619]

{"sheet":"South East","index":6,"n_rows":267,"n_cols":7,"rows_kept":267,"cut":false,"hidden":false,"merged":[]}
["Description - all local authorities 2020-2021","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of local authorities subscribing at end of quarter",10,11,11,12]
["Number of local authorities with data uploaded at end of quarter - all case types",10,10,10,11]
["Number of local authorities with data for family cases",10,10,10,10]
["Number of local authorities with data for adult cases",6,6,7,7]
["Number of local authorities with data for children / care leaver cases",6,5,5,5]
[]
[]
[]
["Family cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",102,106,109,113]
["Number of dependants of financially supported households at end of quarter",186,190,194,188]
["Total weekly spend for the cases supported at the end of the quarter",29606,31453,32981,33730]
["Average annual cost per case",{"$f":"B13*52/B11","v":15093.254901960785},{"$f":"C13*52/C11","v":15429.773584905661},{"$f":"D13*52/D11","v":15734.055045871559},{"$f":"E13*52/E11","v":15521.769911504425}]
["Average annual cost (weekly spend X 52)",{"$f":"B13*52","v":1539512},{"$f":"C13*52","v":1635556},{"$f":"D13*52","v":1715012},{"$f":"E13*52","v":1753960}]
["Average number of days on support, cases open at end of quarter",704,710,744,770]
["Of Row 11 - Number that are non EEA and unresolved",64,69,65,60]
["Of Row 11 - EEA national or EEA family member / derivative rights",15,18,20,19]
["Of Row 11 - Number that are non EEA but have LTR with recourse",23,19,24,34]
["Of Row 17 - Number that are 1000 day cases",13,11,11,9]
["Of Row 18 - Number of 1000 day EEA national cases without 'settled status ",4,4,4,4]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 20 / row 17)",0.2,0.16,0.17,0.15]
["EEA 1000 day cases, percentage of unresolved cohort (row 21 / row 18)",0.27,0.22,0.21,0.22]
["Total number of referrals per quarter",45,47,54,50]
["Total number of new cases taken on for support within quarter",17,17,12,28]
["Total number of supported cases closed within quarter",10,13,9,13]
[]
[]
[]
[]
["Adult cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",27,27,32,32]
["Total weekly spend for the cases supported at the end of the quarter",17527,17570,18294,18237]
["Average annual cost per case",{"$f":"B33*52/B32","v":33755.703703703701},{"$f":"C33*52/C32","v":33838.518518518518},{"$f":"D33*52/D32","v":29727.75},29635.125]
["Average annual cost (weekly spend X 52)",{"$f":"B33*52","v":911404},{"$f":"C33*52","v":913640},{"$f":"D33*52","v":951288},948324]
["Average number of days on support, cases open at end of quarter",796,1092,919,1009]
["Of Row 31 - Number that are non EEA and unresolved",18,18,23,21]
["Of Row 31 - EEA national or EEA family member / derivative rights",8,8,8,9]
["Of Row 31 - Number that are non EEA but have LTR with recourse",1,1,1,2]
["Of Row 31 - Number that are 1000 day cases",6,6,8,9]
["Of Row 31 - Number of 1000 day EEA national cases without 'settled status ",2,2,3,3]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 39 / row 36)",0.33,0.33,0.35,0.43]
["EEA 1000 day cases, percentage of unresolved cohort (row 40 / row 37)",0.25,0.25,0.38,0.33]
["Total number of referrals per quarter",0,5,8,7]
["Total number of new cases taken on for support within quarter",2,0,7,0]
["Total number of supported cases closed within quarter",6,0,2,0]
[]
[]
[]
[]
[]
[]
["Looked after children and care leavers","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of open cases at end of quarter",182,197,233,246]
["Of which under age of 18",11,13,19,22]
["Of which aged 18-21",106,119,150,163]
["Of which aged 21 and over",65,65,64,61]
["Of number of open cases (row 54), number financially supported",143,145,147,150]
["Total weekly spend for the cases financially supported at end of quarter",47147,48728.76,49518,49565]
["Average annual cost per case",{"$f":"B59/B58*52","v":17144.363636363636},{"$f":"C59/C58*52","v":17475.14151724138},{"$f":"D59/D58*52","v":17516.571428571428},17182.533333333333]
["Average annual cost (weekly spend X 52)",{"$f":"B59*52","v":2451644},{"$f":"C59*52","v":2533895.52},{"$f":"D59*52","v":2574936},2577380]
["Total number of new cases recorded within the quarter",21,33,37,24]
["Total number of cases closed ",12,8,12,11]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason family and adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",1,{"$f":" 100/53*B75","v":1.8867924528301887}]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/53*B76","v":0}]
["Accessed Asylum Support",3,5.6603773584905657]
["No longer eligible",1,1.8867924528301887]
["EEA national / family member - accessed benefits / employment",1,1.8867924528301887]
["Granted Leave to Remain",{"$f":"1+10+36","v":47},88.679245283018872]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason family cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",0,{"$f":" 100/45*B96","v":0}]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/45*B97","v":0}]
["Accessed Asylum Support",3,6.666666666666667]
["No longer eligible",0,0]
["EEA national / family member - accessed benefits / employment",1,2.2222222222222223]
["Granted Leave to Remain",{"$f":"9+32","v":41},91.111111111111114]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",1,12]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/8*B119","v":0}]
["Accessed Asylum Support",0,0]
["No longer eligible",0,0]
["Deceased",1,12.5]
["EEA national / family member - accessed benefits / employment",0,0]
["Granted Leave to Remain",6,75]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Immigration status families - open cases as of 31 March 2021","Total","Percentage",null,"Summary - families - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",14,{"$f":" 100/111*B142","v":12.612612612612613},null,"EEA national or EU residence rights ",{"$f":"B142+B143+B144","v":19},{"$f":" 100/111*F142","v":17.117117117117118}]
["Indefinite leave to remain (EU Settlement Scheme)",1,{"$f":" 100/111*B143","v":0.90090090090090091},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B148+B149","v":8},{"$f":" 100/111*F143","v":7.2072072072072073}]
["Leave to remain (EU Settlement Scheme)",4,3.6036036036036037,null,"No current immigration permission",{"$f":"B160+B157+B152","v":30},27.027027027027028]
["Limited leave with recourse to public funds (10 year route)",19,17.117117117117118,null,"Asylum seeker / asylum seeker ARE",{"$f":"B162+B159+B161+B158+B150","v":21},18.918918918918919]
["Limited leave with recourse to public funds (following COC)",2,1.8018018018018018,null,"Leave to Remain (LTR) with recourse ",{"$f":"B154+B155+B156+B153+B151+B147+B146+B145","v":32},28.828828828828829]
["Limited Leave with Recourse to Public Funds (other)",3,2.7027027027027026,null,"British",{"$f":"B163","v":1},0.90090090090090091]
["Limited leave with NRPF (10 year route)",3,2.7027027027027026]
["Limited leave with NRPF (other)",5,4.5045045045045047]
["UASC leave",0,0]
["No record held by HO (non EEA)",2,1.8018018018018018]
["Humanitarian Protection",1,0.90090090090090091]
["Refugee Status",1,0.90090090090090091]
["Indefinite leave   ",5,4.5045045045045047]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",28,25.225225225225227]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",9,8.1081081081081088]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",1,0.90090090090090091]
["Illegal entrant - asylum claimed 'yes'",11,9.9099099099099099]
["Port Case",1,0.90090090090090091]
["British",1,0.90090090090090091]
[]
[]
[]
["Adults - open cases as of 31 March 2021","Total","Percentage",null,"Summary - adults - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",7,{"$f":" 100/31*B168","v":22.58064516129032},null,"EEA national or EU residence rights ",{"$f":"B168+B169+B170","v":8},{"$f":" 100/31*F168","v":25.806451612903224}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/31*B169","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B174+B175","v":2},{"$f":" 100/31*F169","v":6.4516129032258061}]
["Leave to remain (EU Settlement Scheme)",1,3.225806451612903,null,"No current immigration permission",{"$f":"B186+B183+B178","v":5},16.129032258064516]
["Limited leave with recourse to public funds (10 year route)",1,3.225806451612903,null,"Asylum seeker / asylum seeker ARE",{"$f":"B188+B185+B187+B184+B176","v":13},41.935483870967737]
["Limited leave with recourse to public funds (following COC)",1,3.225806451612903,null,"Leave to Remain (LTR) with recourse ",{"$f":"B180+B181+B182+B179+B177+B173+B172+B171","v":3},9.6774193548387082]
["Limited Leave with Recourse to Public Funds (other)",1,3.225806451612903,null,"British",{"$f":"B189","v":0},0]
["Limited leave with NRPF (10 year route)",0,0]
["Limited leave with NRPF (other)",2,6.4516129032258061]
["UASC leave",0,0]
["Indefinite Leave",0,0]
["No record held by HO (non EEA)",0,0]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",5,16.129032258064516]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",5,16.129032258064516]
["In Country Asylum Seeker",1,3.225806451612903]
["Illegal entrant - asylum claimed 'no'",0,0]
["Illegal entrant - asylum claimed 'yes'",5,16.129032258064516]
["Port Case",2,6.4516129032258061]
["British",0,0]
[]
[]
[]
["looked after children and care leavers - open cases as of 31 March 2021","Total","Percentage",null,"Summary - LAC / CL - 31 March 21","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",3,{"$f":" 100/237*B194","v":1.2658227848101267},null,"EEA national or EU residence rights ",{"$f":"B194+B195+B196","v":3},{"$f":" 100/237*F194","v":1.2658227848101267}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/237*B195","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B200+B201","v":4},{"$f":" 100/237*F195","v":1.6877637130801688}]
["Leave to remain (EU Settlement Scheme)",0,0,null,"No current immigration permission",{"$f":"B212+B209+B204","v":11},4.6413502109704643]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B214+B211+B213+B210+B202","v":176},74.261603375527429]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B206+B207+B208+B205+B203+B199+B198+B197","v":43},18.143459915611814]
["Limited Leave with Recourse to Public Funds (other)",9,3.79746835443038,null,"British",{"$f":"B215","v":0},0]
["Limited leave with NRPF (10 year route)",1,0.4219409282700422]
["Limited leave with NRPF (other)",3,1.2658227848101267]
["UASC leave",6,2.5316455696202533]
["Indefinite Leave",1,0.4219409282700422]
["No record held by HO (non EEA)",2,0.84388185654008441]
["Humanitarian Protection",3,1.2658227848101267]
["Refugee Status",30,12.658227848101266]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",4,1.6877637130801688]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",21,8.8607594936708871]
["In Country Asylum Seeker",33,13.924050632911392]
["Illegal entrant - asylum claimed 'no'",5,2.109704641350211]
["Illegal entrant - asylum claimed 'yes'",109,45.991561181434598]
["Port Case",7,2.9535864978902953]
["British",0,0]
[]
[]
[]
["Immigration status families - all referrals for the year","Total","Percentage",null,"Summary - families referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",15,{"$f":" 100/195*B220","v":7.6923076923076916},null,"EEA national or EU residence rights ",{"$f":"B220+B221+B222","v":25},{"$f":" 100/195*F220","v":12.820512820512819}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/195*B221","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B226+B227","v":47},{"$f":" 100/195*F221","v":24.102564102564102}]
["Leave to remain (EU Settlement Scheme)",10,5.1282051282051277,null,"No current immigration permission",{"$f":"B238+B235+B230","v":58},29.743589743589741]
["Limited leave with recourse to public funds (10 year route)",8,4.1025641025641022,null,"Asylum seeker / asylum seeker ARE",{"$f":"B240+B237+B239+B236+B228","v":27},13.846153846153845]
["Limited leave with recourse to public funds (following COC)",6,3.0769230769230766,null,"Leave to Remain (LTR) with recourse ",{"$f":"B232+B233+B234+B231+B229+B225+B224+B223","v":34},17.435897435897434]
["Limited Leave with Recourse to Public Funds (other)",3,1.5384615384615383,null,"British",{"$f":"B241","v":4},2.0512820512820511]
["Limited leave with NRPF (10 year route)",24,12.307692307692307]
["Limited leave with NRPF (other)",23,11.794871794871794]
["UASC leave",0,0]
["Indefinite Leave",7,3.5897435897435894]
["No record held by HO (non EEA)",13,6.6666666666666661]
["Humanitarian Protection",0,0]
["Refugee Status",5,2.5641025641025639]
["Discretionary leave - trafficking",0,0]
["DDV Concession",5,2.5641025641025639]
["Over-stayer / Deception / Breach - asylum claimed 'no'",41,21.025641025641022]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",13,6.6666666666666661]
["In Country Asylum Seeker",7,3.5897435897435894]
["Illegal entrant - asylum claimed 'no'",4,2.0512820512820511]
["Illegal entrant - asylum claimed 'yes'",6,3.0769230769230766]
["Port Case",1,0.51282051282051277]
["British",4,2.0512820512820511]
[]
[]
[]
["Immigration status adults - all referrals for the year","Total","Percentage",null,"Summary - adults referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",2,{"$f":" 100/19*B246","v":10.526315789473685},null,"EEA national or EU residence rights ",{"$f":"B246+B247+B248","v":5},27]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/19*B247","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B252+B253","v":3},{"$f":" 100/19*F247","v":15.789473684210527}]
["Leave to remain (EU Settlement Scheme)",3,15.789473684210527,null,"No current immigration permission",{"$f":"B264+B261+B256","v":4},21.05263157894737]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B266+B263+B265+B262+B254","v":5},26.315789473684212]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B258+B259+B260+B257+B255+B251+B250+B249","v":1},5.2631578947368425]
["Limited Leave with Recourse to Public Funds (other)",0,0,null,"British",{"$f":"B267","v":1},5.2631578947368425]
["Limited leave with NRPF (10 year route)",1,5.2631578947368425]
["Limited leave with NRPF (other)",2,10.526315789473685]
["UASC leave",0,0]
["Indefinite Leave",1,5.2631578947368425]
["No record held by HO (non EEA)",1,5.2631578947368425]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",3,15.789473684210527]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",2,10.526315789473685]
["In Country Asylum Seeker",1,5.2631578947368425]
["Illegal entrant - asylum claimed 'no'",0,0]
["Illegal entrant - asylum claimed 'yes'",2,10.526315789473685]
["Port Case",0,0]
["British",1,5.2631578947368425]

{"sheet":"South West","index":7,"n_rows":266,"n_cols":7,"rows_kept":266,"cut":false,"hidden":false,"merged":[]}
["Description - all local authorities 2020-2021","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of local authorities subscribing at end of quarter",2,2,2,2]
["Number of local authorities with data uploaded at end of quarter - all case types",2,2,2,2]
["Number of local authorities with data for family cases",2,2,2,2]
["Number of local authorities with data for adult cases",1,1,1,1]
["Number of local authorities with data for children / care leaver cases",2,2,2,1]
[]
[]
[]
["Family cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",64,75,72,62]
["Number of dependants of financially supported households at end of quarter",118,136,123,99]
["Total weekly spend for the cases supported at the end of the quarter",17931,20438,17931,18837]
["Average annual cost per case",{"$f":"B13*52/B11","v":14568.9375},{"$f":"C13*52/C11","v":14170.346666666666},12950.166666666666,{"$f":"E13*52/E11","v":15798.774193548386}]
["Average annual cost (weekly spend X 52)",{"$f":"B13*52","v":932412},{"$f":"C13*52","v":1062776},932412,{"$f":"E13*52","v":979524}]
["Average number of days on support, cases open at end of quarter",618,608,634,602]
["Of Row 11 - Number that are non EEA and unresolved",46,52,50,44]
["Of Row 11 - EEA national or EEA family member / derivative rights",10,10,11,10]
["Of Row 11 - Number that are non EEA but have LTR with recourse",8,13,11,8]
["Of Row 17 - Number that are 1000 day cases",9,8,8,7]
["Of Row 18 - Number of 1000 day EEA national cases without 'settled status ",2,3,3,3]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 20 / row 17)",0.2,0.15,0.16,0.16]
["EEA 1000 day cases, percentage of unresolved cohort (row 21 / row 18)",0.2,0.3,0.3,0.3]
["Total number of referrals per quarter",9,12,19,29]
["Total number of new cases taken on for support within quarter",10,12,8,10]
["Total number of supported cases closed within quarter",10,1,11,20]
[]
[]
[]
[]
[]
[]
["Adult cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",15,18,21,19]
["Total weekly spend for the cases supported at the end of the quarter",4908,5660,6165,6048]
["Average annual cost per case",{"$f":"B35*52/B34","v":17014.400000000001},{"$f":"C35*52/C34","v":16351.111111111111},15265.714285714286,{"$f":"E35*52/E34","v":16552.42105263158}]
["Average annual cost (weekly spend X 52)",{"$f":"B35*52","v":255216},{"$f":"C35*52","v":294320},320580,{"$f":"E35*52","v":314496}]
["Average number of days on support, cases open at end of quarter",740,698,684,784]
["Of Row 31 - Number that are non EEA and unresolved",11,14,17,16]
["Of Row 31 - EEA national or EEA family member / derivative rights",4,4,4,3]
["Of Row 31 - Number that are non EEA but have LTR with recourse",0,0,0,0]
["Of Row 31 - Number that are 1000 day cases",4,4,4,4]
["Of Row 31 - Number of 1000 day EEA national cases without 'settled status ",0,0,0,0]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 39 / row 36)",0.36,0.28999999999999998,0.24,0.25]
["EEA 1000 day cases, percentage of unresolved cohort (row 40 / row 37)",0,0,0,0]
["Total number of referrals per quarter",5,6,6,2]
["Total number of new cases taken on for support within quarter",3,4,3,0]
["Total number of supported cases closed within quarter",3,1,0,2]
[]
[]
[]
[]
[]
["Looked after children and care leavers","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of open cases at end of quarter",135,140,149,123]
["Of which under age of 18",28,31,37,42]
["Of which aged 18-21",57,59,64,50]
["Of which aged 21 and over",50,50,48,31]
["Of number of open cases (row 55), number financially supported",29,29,28,29]
["Total weekly spend for the cases financially supported at end of quarter",5259,5317,5159,6554]
["Average annual cost per case",{"$f":"B60/B59*52","v":9429.9310344827591},{"$f":"C60/C59*52","v":9533.9310344827591},9581,{"$f":"E60/E59*52","v":11752}]
["Average annual cost (weekly spend X 52)",{"$f":"B60*52","v":273468},{"$f":"C60*52","v":276484},268268,{"$f":"E60*52","v":340808}]
["Total number of new cases recorded within the quarter",5,5,13,14]
["Total number of cases closed ",0,0,4,40]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason family and adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",1,{"$f":" 100/49*B75","v":2.0408163265306123}]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/49*B76","v":0}]
["Accessed Asylum Support",2,4.0816326530612246]
["No longer eligible",2,4.0816326530612246]
["EEA national / family member - accessed benefits / employment",2,4.0816326530612246]
["Granted Leave to Remain",42,85.714285714285722]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason family cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",1,{"$f":" 100/42*B97","v":2.3809523809523809}]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/42*B98","v":0}]
["Accessed Asylum Support",0,0]
["No longer eligible",1,2.3809523809523809]
["EEA national / family member - accessed benefits / employment",2,4.7619047619047619]
["Granted Leave to Remain",38,91]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",0,0]
["Non-EEA national - left the UK (HO / LA funded)",0,0]
["Accessed Asylum Support",2,0.28999999999999998]
["No longer eligible",1,0.14000000000000001]
["Deceased",0,0]
["EEA national / family member - accessed benefits / employment",0,0]
["Granted Leave to Remain",4,0.56999999999999995]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Immigration status families - open cases as of 31 March 2021","Total","Percentage",null,"Summary - families - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",6,{"$f":" 100/61*B141","v":9.8360655737704921},null,"EEA national or EU residence rights ",{"$f":"B141+B142+B143","v":10},{"$f":" 100/61*F141","v":16.393442622950822}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/61*B142","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B147+B148","v":4},6.557377049180328]
["Leave to remain (EU Settlement Scheme)",4,6.557377049180328,null,"No current immigration permission",{"$f":"B159+B156+B151","v":17},27.868852459016395]
["Limited leave with recourse to public funds (10 year route)",2,3.278688524590164,null,"Asylum seeker / asylum seeker ARE",{"$f":"B161+B158+B160+B157+B149","v":21},34.42622950819672]
["Limited leave with recourse to public funds (following COC)",1,1.639344262295082,null,"Leave to Remain (LTR) with recourse ",{"$f":"B153+B154+B155+B152+B150+B146+B145+B144","v":8},13.114754098360656]
["Limited Leave with Recourse to Public Funds (other)",1,1.639344262295082,null,"British",{"$f":"B162","v":1},1.639344262295082]
["Limited leave with NRPF (10 year route)",2,3.278688524590164]
["Limited leave with NRPF (other)",2,3.278688524590164]
["UASC leave",1,1.639344262295082]
["No record held by HO (non EEA)",2,3.278688524590164]
["Humanitarian Protection",0,0]
["Refugee Status",2,3.278688524590164]
["Indefinite leave   ",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",14,22.950819672131146]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",8,13.114754098360656]
["In Country Asylum Seeker",3,4.918032786885246]
["Illegal entrant - asylum claimed 'no'",3,4.918032786885246]
["Illegal entrant - asylum claimed 'yes'",9,14.754098360655739]
["Port Case",0,0]
["British",1,1.639344262295082]
[]
[]
[]
["Adults - open cases as of 31 March 2021","Total","Percentage",null,"Summary - adults - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",2,{"$f":" 100/18*B167","v":11.111111111111111},null,"EEA national or EU residence rights ",{"$f":"B167+B168+B169","v":3},{"$f":" 100/18*F167","v":16.666666666666664}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/18*B168","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B173+B174","v":1},5]
["Leave to remain (EU Settlement Scheme)",1,5.5555555555555554,null,"No current immigration permission",{"$f":"B185+B182+B177","v":5},{"$f":" 100/18*F169","v":27.777777777777779}]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B187+B184+B186+B183+B175","v":9},50]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B179+B180+B181+B178+B176+B172+B171+B170","v":0},0]
["Limited Leave with Recourse to Public Funds (other)",0,0,null,"British",{"$f":"B188","v":0},0]
["Limited leave with NRPF (10 year route)",1,5.5555555555555554]
["Limited leave with NRPF (other)",0,0]
["UASC leave",0,0]
["Indefinite Leave",0,0]
["No record held by HO (non EEA)",0,0]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",4,22.222222222222221]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",4,22.222222222222221]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",1,5.5555555555555554]
["Illegal entrant - asylum claimed 'yes'",5,27.777777777777779]
["Port Case",0,0]
["British",0,0]
[]
[]
[]
["looked after children and care leavers - open cases as of 31 March 2021","Total","Percentage",null,"Summary - LAC / CL - 31 March 21","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",5,{"$f":" 100/109*B193","v":4.5871559633027523},null,"EEA national or EU residence rights ",{"$f":"B193+B194+B195","v":6},{"$f":" 100/109*F193","v":5.5045871559633035}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/109*B194","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B199+B200","v":0},{"$f":" 100/109*F194","v":0}]
["Leave to remain (EU Settlement Scheme)",1,0.91743119266055051,null,"No current immigration permission",{"$f":"B211+B208+B203","v":30},27.522935779816514]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B213+B210+B212+B209+B201","v":52},47.706422018348626]
["Limited leave with recourse to public funds (following COC)",1,0.91743119266055051,null,"Leave to Remain (LTR) with recourse ",{"$f":"B205+B206+B207+B204+B202+B198+B197+B196","v":21},19.26605504587156]
["Limited Leave with Recourse to Public Funds (other)",9,8.2568807339449553,null,"British",{"$f":"B214","v":0},0]
["Limited leave with NRPF (10 year route)",0,0]
["Limited leave with NRPF (other)",0,0]
["UASC leave",2,1.834862385321101]
["Indefinite Leave",2,1.834862385321101]
["No record held by HO (non EEA)",7,6.4220183486238538]
["Humanitarian Protection",0,0]
["Refugee Status",9,8.2568807339449553]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",3,2.7522935779816518]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",1,0.91743119266055051]
["In Country Asylum Seeker",2,1.834862385321101]
["Illegal entrant - asylum claimed 'no'",20,18.348623853211009]
["Illegal entrant - asylum claimed 'yes'",40,36.697247706422019]
["Port Case",7,6.4220183486238538]
["British",0,0]
[]
[]
[]
["Immigration status families - all referrals for the year","Total","Percentage",null,"Summary - families referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",9,{"$f":" 100/63*B219","v":14.285714285714285},null,"EEA national or EU residence rights ",{"$f":"B219+B220+B221","v":16},{"$f":" 100/63*F219","v":25.396825396825395}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/63*B220","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B225+B226","v":9},{"$f":" 100/63*F220","v":14.285714285714285}]
["Leave to remain (EU Settlement Scheme)",7,11.111111111111111,null,"No current immigration permission",{"$f":"B237+B234+B229","v":10},15.873015873015872]
["Limited leave with recourse to public funds (10 year route)",3,4.7619047619047619,null,"Asylum seeker / asylum seeker ARE",{"$f":"B239+B236+B238+B235+B227","v":13},20.634920634920633]
["Limited leave with recourse to public funds (following COC)",3,4.7619047619047619,null,"Leave to Remain (LTR) with recourse ",{"$f":"B231+B232+B233+B230+B228+B224+B223+B222","v":14},22.222222222222221]
["Limited Leave with Recourse to Public Funds (other)",3,4.7619047619047619,null,"British",{"$f":"B240","v":1},1.5873015873015872]
["Limited leave with NRPF (10 year route)",5,7.9365079365079358]
["Limited leave with NRPF (other)",4,6.3492063492063489]
["UASC leave",0,0]
["Indefinite Leave",2,3.1746031746031744]
["No record held by HO (non EEA)",3,4.7619047619047619]
["Humanitarian Protection",0,0]
["Refugee Status",1,1.5873015873015872]
["Discretionary leave - trafficking",0,0]
["DDV Concession",2,3.1746031746031744]
["Over-stayer / Deception / Breach - asylum claimed 'no'",5,7.9365079365079358]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",4,6.3492063492063489]
["In Country Asylum Seeker",1,1.5873015873015872]
["Illegal entrant - asylum claimed 'no'",2,3.1746031746031744]
["Illegal entrant - asylum claimed 'yes'",7,11.111111111111111]
["Port Case",1,1.5873015873015872]
["British",1,1.5873015873015872]
[]
[]
[]
["Immigration status adults - all referrals for the year","Total","Percentage",null,"Summary - adults referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",2,{"$f":" 100/18*B245","v":11.111111111111111},null,"EEA national or EU residence rights ",{"$f":"B245+B246+B247","v":2},{"$f":" 100/18*F245","v":11.111111111111111}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/18*B246","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B251+B252","v":2},{"$f":" 100/18*F246","v":11.111111111111111}]
["Leave to remain (EU Settlement Scheme)",0,0,null,"No current immigration permission",{"$f":"B263+B260+B255","v":6},33.333333333333329]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B265+B262+B264+B261+B253","v":8},45]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B257+B258+B259+B256+B254+B250+B249+B248","v":0},0]
["Limited Leave with Recourse to Public Funds (other)",0,0,null,"British",{"$f":"B266","v":0},0]
["Limited leave with NRPF (10 year route)",0,0]
["Limited leave with NRPF (other)",2,11.111111111111111]
["UASC leave",0,0]
["Indefinite Leave",0,0]
["No record held by HO (non EEA)",0,0]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",5,27.777777777777779]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",5,27.777777777777779]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",1,5.5555555555555554]
["Illegal entrant - asylum claimed 'yes'",3,16.666666666666664]
["Port Case",0,0]
["British",0,0]

{"sheet":"Yorkshire & the Humber","index":8,"n_rows":255,"n_cols":7,"rows_kept":255,"cut":false,"hidden":false,"merged":[]}
["Description - all local authorities 2020-2021","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of local authorities subscribing at end of quarter",2,3,3,3]
["Number of local authorities with data uploaded at end of quarter - all case types",3,3,3,3]
["Number of local authorities with data for family cases",3,3,3,3]
["Number of local authorities with data for adult cases",1,1,1,1]
["Number of local authorities with data for children / care leaver cases",0,0,0,0]
[]
[]
[]
["Family cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",84,100,96,82]
["Number of dependants of financially supported households at end of quarter",188,220,215,178]
["Total weekly spend for the cases supported at the end of the quarter",20846,23126,23020,20199]
["Average annual cost per case",{"$f":"B13*52/B11","v":12904.666666666666},{"$f":"C13*52/C11","v":12025.52},12469.166666666666,12809.121951219513]
["Average annual cost (weekly spend X 52)",{"$f":"B13*52","v":1083992},{"$f":"C13*52","v":1202552},1197040,1050348]
["Average number of days on support, cases open at end of quarter",259,251,316,377]
["Of Row 11 - Number that are non EEA and unresolved",72,83,67,63]
["Of Row 11 - EEA national or EEA family member / derivative rights",8,12,15,12]
["Of Row 11 - Number that are non EEA but have LTR with recourse",4,5,14,7]
["Of Row 17 - Number that are 1000 day cases",1,1,2,3]
["Of Row 18 - Number of 1000 day EEA national cases without 'settled status ",0,0,0,0]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 20 / row 17)",0.01,0.01,0.03,0.05]
["EEA 1000 day cases, percentage of unresolved cohort (row 21 / row 18)",0,0,0,0]
["Total number of referrals per quarter",48,39,34,26]
["Total number of new cases taken on for support within quarter",38,40,21,22]
["Total number of supported cases closed within quarter",14,24,25,36]
[]
[]
[]
["Adult cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",30,30,28,26]
["Total weekly spend for the cases supported at the end of the quarter",7507,5877,6339,5761]
["Average annual cost per case",{"$f":"B32*52/B31","v":13012.133333333333},{"$f":"C32*52/C31","v":10186.799999999999},11772.428571428571,11522]
["Average annual cost (weekly spend X 52)",{"$f":"B32*52","v":390364},{"$f":"C32*52","v":305604},329628,299572]
["Average number of days on support, cases open at end of quarter",231,252,227,235]
["Of Row 31 - Number that are non EEA and unresolved",18,21,21,20]
["Of Row 31 - EEA national or EEA family member / derivative rights",8,8,7,4]
["Of Row 31 - Number that are non EEA but have LTR with recourse",4,1,0,2]
["Of Row 31 - Number that are 1000 day cases",1,1,0,0]
["Of Row 31 - Number of 1000 day EEA national cases without 'settled status ",0,0,0,0]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 39 / row 36)",0.06,0.05,0,0]
["EEA 1000 day cases, percentage of unresolved cohort (row 40 / row 37)",0,0,0,0]
["Total number of referrals per quarter",19,18,24,17]
["Total number of new cases taken on for support within quarter",17,17,12,16]
["Total number of supported cases closed within quarter",13,17,15,18]
[]
[]
[]
["Looked after children and care leavers","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of open cases at end of quarter"]
["Of which under age of 18"]
["Of which aged 18-21"]
["Of which aged 21 and over"]
["Of number of open cases (row 50), number financially supported",0,0,0,0]
["Total weekly spend for the cases financially supported at end of quarter",0,0,0,0]
["Average annual cost per case",0,0,0,0]
["Average annual cost (weekly spend X 52)",0,0,0,0]
["Total number of new cases recorded within the quarter"]
["Total number of cases closed "]
[]
[]
[]
["Closure reason family and adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",15,{"$f":" 100/163*B64","v":9.2024539877300615}]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/163*B65","v":0}]
["Accessed Asylum Support",5,3.0674846625766872]
["No longer eligible",26,15.950920245398773]
["EEA national / family member - accessed benefits / employment",10,6.1349693251533743]
["Granted Leave to Remain",{"$f":"80+12+15","v":107},65.644171779141104]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason family cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",13,{"$f":" 100/99*B86","v":13.131313131313131}]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/99*B87","v":0}]
["Accessed Asylum Support",2,2.0202020202020203]
["No longer eligible",18,18.181818181818183]
["EEA national / family member - accessed benefits / employment",2,2.0202020202020203]
["Granted Leave to Remain",{"$f":"45+11+8","v":64},64.646464646464651]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",2,{"$f":" 100/64*B108","v":3.125}]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/64*B109","v":0}]
["Accessed Asylum Support",3,4.6875]
["No longer eligible",8,12]
["Deceased",0,0]
["EEA national / family member - accessed benefits / employment",8,12.5]
["Granted Leave to Remain",{"$f":"4+4+35","v":43},67.1875]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Immigration status families - open cases as of 31 March 2021","Total","Percentage",null,"Summary - families - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",9,{"$f":" 100/79*B130","v":11.39240506329114},null,"EEA national or EU residence rights ",{"$f":"B130+B131+B132","v":11},{"$f":" 100/79*F130","v":13.924050632911394}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/79*B131","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B136+B137","v":17},21]
["Leave to remain (EU Settlement Scheme)",2,2.5316455696202533,null,"No current immigration permission",{"$f":"B148+B145+B140","v":24},{"$f":" 100/79*F132","v":30.37974683544304}]
["Limited leave with recourse to public funds (10 year route)",1,1.2658227848101267,null,"Asylum seeker / asylum seeker ARE",{"$f":"B150+B147+B149+B146+B138","v":19},24.050632911392405]
["Limited leave with recourse to public funds (following COC)",2,2.5316455696202533,null,"Leave to Remain (LTR) with recourse ",{"$f":"B142+B143+B144+B141+B139+B135+B134+B133","v":6},7.59493670886076]
["Limited Leave with Recourse to Public Funds (other)",1,1.2658227848101267,null,"British",{"$f":"B151","v":2},2.5316455696202533]
["Limited leave with NRPF (10 year route)",5,6.3291139240506329]
["Limited leave with NRPF (other)",12,15.18987341772152]
["UASC leave",0,0]
["No record held by HO (non EEA)",2,2.5316455696202533]
["Humanitarian Protection",1,1.2658227848101267]
["Refugee Status",0,0]
["Indefinite leave   ",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",20,25.316455696202532]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",11,13.924050632911394]
["In Country Asylum Seeker",2,2.5316455696202533]
["Illegal entrant - asylum claimed 'no'",3,3.79746835443038]
["Illegal entrant - asylum claimed 'yes'",3,3.79746835443038]
["Port Case",3,3.79746835443038]
["British",2,2.5316455696202533]
[]
[]
[]
["Adults - open cases as of 31 March 2021","Total","Percentage",null,"Summary - adults - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",3,{"$f":" 100/24*B156","v":12.5},null,"EEA national or EU residence rights ",{"$f":"B156+B157+B158","v":4},{"$f":" 100/24*F156","v":16.666666666666668}]
["Indefinite leave to remain (EU Settlement Scheme)",1,{"$f":" 100/24*B157","v":4.166666666666667},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B162+B163","v":4},{"$f":" 100/24*F157","v":16.666666666666668}]
["Leave to remain (EU Settlement Scheme)",0,0,null,"No current immigration permission",{"$f":"B174+B171+B166","v":8},33.333333333333336]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B176+B173+B175+B172+B164","v":7},29.166666666666668]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B168+B169+B170+B167+B165+B161+B160+B159","v":1},4.166666666666667]
["Limited Leave with Recourse to Public Funds (other)",1,4.166666666666667,null,"British",{"$f":"B177","v":0},0]
["Limited leave with NRPF (10 year route)",0,0]
["Limited leave with NRPF (other)",4,16.666666666666668]
["UASC leave",0,0]
["Indefinite Leave",0,0]
["No record held by HO (non EEA)",0,0]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",8,33.333333333333336]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",3,12.5]
["In Country Asylum Seeker",1,4.166666666666667]
["Illegal entrant - asylum claimed 'no'",0,0]
["Illegal entrant - asylum claimed 'yes'",3,12.5]
["Port Case",0,0]
["British",0,0]
[]
[]
[]
["looked after children and care leavers - open cases as of 31 March 2021","Total","Percentage",null,"Summary - LAC / CL - 31 March 21","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",null,null,null,"EEA national or EU residence rights "]
["Indefinite leave to remain (EU Settlement Scheme)",null,null,null,"Leave to Remain (LTR) with NRPF "]
["Leave to remain (EU Settlement Scheme)",null,null,null,"No current immigration permission"]
["Limited leave with recourse to public funds (10 year route)",null,null,null,"Asylum seeker / asylum seeker ARE"]
["Limited leave with recourse to public funds (following COC)",null,null,null,"Leave to Remain (LTR) with recourse "]
["Limited Leave with Recourse to Public Funds (other)",null,null,null,"British"]
["Limited leave with NRPF (10 year route)"]
["Limited leave with NRPF (other)"]
["UASC leave"]
["Indefinite Leave"]
["No record held by HO (non EEA)"]
["Humanitarian Protection"]
["Refugee Status"]
["Discretionary leave - trafficking"]
["DDV Concession"]
["Over-stayer / Deception / Breach - asylum claimed 'no'"]
["Over-stayer / Deception / Breach - asylum claimed 'yes'"]
["In Country Asylum Seeker"]
["Illegal entrant - asylum claimed 'no'"]
["Illegal entrant - asylum claimed 'yes'"]
["Port Case"]
["British"]
[]
[]
[]
["Immigration status families - all referrals for the year","Total","Percentage",null,"Summary - families referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",17,{"$f":" 100/140*B208","v":12.142857142857142},null,"EEA national or EU residence rights ",{"$f":"B208+B209+B210","v":26},{"$f":" 100/140*F208","v":18.571428571428573}]
["Indefinite leave to remain (EU Settlement Scheme)",2,{"$f":" 100/140*B209","v":1.4285714285714286},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B214+B215","v":46},{"$f":" 100/140*F209","v":32.857142857142861}]
["Leave to remain (EU Settlement Scheme)",7,5,null,"No current immigration permission",{"$f":"B226+B223+B218","v":24},17.142857142857142]
["Limited leave with recourse to public funds (10 year route)",3,2.1428571428571428,null,"Asylum seeker / asylum seeker ARE",{"$f":"B228+B225+B227+B224+B216","v":13},9.2857142857142865]
["Limited leave with recourse to public funds (following COC)",8,5.7142857142857144,null,"Leave to Remain (LTR) with recourse ",{"$f":"B220+B221+B222+B219+B217+B213+B212+B211","v":28},20]
["Limited Leave with Recourse to Public Funds (other)",5,3.5714285714285716,null,"British",{"$f":"B229","v":3},2.1428571428571428]
["Limited leave with NRPF (10 year route)",14,10]
["Limited leave with NRPF (other)",32,22.857142857142858]
["UASC leave",0,0]
["Indefinite Leave",2,1.4285714285714286]
["No record held by HO (non EEA)",6,4.2857142857142856]
["Humanitarian Protection",2,1.4285714285714286]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",8,5.7142857142857144]
["Over-stayer / Deception / Breach - asylum claimed 'no'",18,12.857142857142858]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",9,6.4285714285714288]
["In Country Asylum Seeker",1,0.7142857142857143]
["Illegal entrant - asylum claimed 'no'",0,0]
["Illegal entrant - asylum claimed 'yes'",3,2.1428571428571428]
["Port Case",0,0]
["British",3,2.1428571428571428]
[]
[]
[]
["Immigration status adults - all referrals for the year","Total","Percentage",null,"Summary - adults referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",24,{"$f":" 100/87*B234","v":27.586206896551722},null,"EEA national or EU residence rights ",{"$f":"B234+B235+B236","v":31},35]
["Indefinite leave to remain (EU Settlement Scheme)",3,{"$f":" 100/87*B235","v":3.4482758620689653},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B240+B241","v":25},{"$f":" 100/87*F235","v":28.735632183908045}]
["Leave to remain (EU Settlement Scheme)",4,4.5977011494252871,null,"No current immigration permission",{"$f":"B252+B249+B244","v":15},17.241379310344826]
["Limited leave with recourse to public funds (10 year route)",1,1.1494252873563218,null,"Asylum seeker / asylum seeker ARE",{"$f":"B254+B251+B253+B250+B242","v":11},12.643678160919539]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B246+B247+B248+B245+B243+B239+B238+B237","v":5},5.7471264367816088]
["Limited Leave with Recourse to Public Funds (other)",1,1.1494252873563218,null,"British",{"$f":"B255","v":0},0]
["Limited leave with NRPF (10 year route)",0,0]
["Limited leave with NRPF (other)",25,28.735632183908045]
["UASC leave",0,0]
["Indefinite Leave",1,1.1494252873563218]
["No record held by HO (non EEA)",6,6.8965517241379306]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",2,2.2988505747126435]
["Over-stayer / Deception / Breach - asylum claimed 'no'",8,9.1954022988505741]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",5,5.7471264367816088]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",1,1.1494252873563218]
["Illegal entrant - asylum claimed 'yes'",6,6.8965517241379306]
["Port Case",0,0]
["British",0,0]

{"sheet":"West Midlands","index":9,"n_rows":245,"n_cols":7,"rows_kept":245,"cut":false,"hidden":false,"merged":[]}
["Description - all local authorities 2020-2021","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of local authorities subscribing at end of quarter",6,6,6,6]
["Number of local authorities with data uploaded at end of quarter - all case types",6,6,6,6]
["Number of local authorities with data for family cases",6,6,6,5]
["Number of local authorities with data for adult cases",2,2,2,2]
["Number of local authorities with data for children / care leaver cases",1,1,1,1]
[]
[]
[]
["Family cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",122,118,97,106]
["Number of dependants of financially supported households at end of quarter",193,193,159,170]
["Total weekly spend for the cases supported at the end of the quarter",29642,29642,21989,26176]
["Average annual cost per case",{"$f":"B13*52/B11","v":12634.295081967213},{"$f":"C13*52/C11","v":13062.576271186441},{"$f":"D13*52/D11","v":11787.917525773197},{"$f":"E13*52/E11","v":12841.056603773584}]
["Average annual cost (weekly spend X 52)",{"$f":"B13*52","v":1541384},{"$f":"C13*52","v":1541384},{"$f":"D13*52","v":1143428},{"$f":"E13*52","v":1361152}]
["Average number of days on support, cases open at end of quarter",692,749,900,875]
["Of Row 11 - Number that are non EEA and unresolved",106,106,87,90]
["Of Row 11 - EEA national or EEA family member / derivative rights",11,6,5,10]
["Of Row 11 - Number that are non EEA but have LTR with recourse",5,6,5,6]
["Of Row 17 - Number that are 1000 day cases",33,34,34,32]
["Of Row 18 - Number of 1000 day EEA national cases without 'settled status ",0,1,2,2]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 20 / row 17)",0.31,0.32,0.4,0.36]
["EEA 1000 day cases, percentage of unresolved cohort (row 21 / row 18)",0,0.17,0.25,0.33]
["Total number of referrals per quarter",68,65,71,49]
["Total number of new cases taken on for support within quarter",29,17,5,10]
["Total number of supported cases closed within quarter",25,21,11,15]
[]
[]
[]
["Adult cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",12,12,12,12]
["Total weekly spend for the cases supported at the end of the quarter",3795,3795,3808,3813]
["Average annual cost per case",{"$f":"B32*52/B31","v":16445},{"$f":"C32*52/C31","v":16445},16501.333333333332,16523]
["Average annual cost (weekly spend X 52)",{"$f":"B32*52","v":197340},{"$f":"C32*52","v":197340},198016,198276]
["Average number of days on support, cases open at end of quarter",1171,1263,1355,1445]
["Of Row 31 - Number that are non EEA and unresolved",6,6,7,6]
["Of Row 31 - EEA national or EEA family member / derivative rights",5,5,5,5]
["Of Row 31 - Number that are non EEA but have LTR with recourse",1,1,0,1]
["Of Row 31 - Number that are 1000 day cases",4,4,5,5]
["Of Row 31 - Number of 1000 day EEA national cases without 'settled status ",1,2,2,3]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 39 / row 36)",0.67,0.67,0.71,0.5]
["EEA 1000 day cases, percentage of unresolved cohort (row 40 / row 37)",0.2,0.4,0.4,0.6]
["Total number of referrals per quarter",27,46,46,50]
["Total number of new cases taken on for support within quarter",0,0,0,0]
["Total number of supported cases closed within quarter",0,0,0,0]
[]
[]
[]
[]
[]
[]
["Looked after children and care leavers","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of open cases at end of quarter",149,93,101,75]
["Of which under age of 18",16,7,8,3]
["Of which aged 18-21",56,35,41,41]
["Of which aged 21 and over",77,51,52,31]
["Of number of open cases (row 53), number financially supported",24,23,22,22]
["Total weekly spend for the cases financially supported at end of quarter",4841,4786,4466,4455]
["Average annual cost per case",{"$f":"B58/B57*52","v":10488.833333333334},{"$f":"C58/C57*52","v":10820.521739130434},10556,10530]
["Average annual cost (weekly spend X 52)",{"$f":"B58*52","v":251732},{"$f":"C58*52","v":248872},232232,231660]
["Total number of new cases recorded within the quarter",5,1,12,11]
["Total number of cases closed ",2,3,11]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason family and adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",null,{"$f":" 100/926*B76","v":0}]
["Non-EEA national - left the UK (HO / LA funded)",null,{"$f":" 100/926*B77","v":0}]
["Accessed Asylum Support",null,0]
["No longer eligible",null,0]
["EEA national / family member - accessed benefits / employment",null,0]
["Granted Leave to Remain",null,0]
[]
[]
[]
["Closure reason family cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",0,{"$f":" 100/80*B86","v":0}]
["Non-EEA national - left the UK (HO / LA funded)",1,{"$f":" 100/80*B87","v":1.25}]
["Accessed Asylum Support",9,11.25]
["No longer eligible",4,5]
["EEA national / family member - accessed benefits / employment",6,7.5]
["Granted Leave to Remain",{"$f":"2+58","v":60},75]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",null,{"$f":" 100/212*B109","v":0}]
["Non-EEA national - left the UK (HO / LA funded)",null,{"$f":" 100/212*B110","v":0}]
["Accessed Asylum Support",null,0]
["No longer eligible",null,0]
["Deceased",null,0]
["EEA national / family member - accessed benefits / employment",null,0]
["Granted Leave to Remain",null,0]
[]
[]
[]
["Immigration status families - open cases as of 31 March 2021","Total","Percentage",null,"Summary - families - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",5,{"$f":" 100/102*B120","v":4.901960784313725},null,"EEA national or EU residence rights ",{"$f":"B120+B121+B122","v":6},{"$f":" 100/102*F120","v":5.8823529411764701}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/102*B121","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B126+B127","v":11},{"$f":" 100/102*F121","v":10.784313725490195}]
["Leave to remain (EU Settlement Scheme)",1,0.98039215686274506,null,"No current immigration permission",{"$f":"B138+B135+B130","v":54},52.941176470588232]
["Limited leave with recourse to public funds (10 year route)",6,5.8823529411764701,null,"Asylum seeker / asylum seeker ARE",{"$f":"B140+B137+B139+B136+B128","v":22},21]
["Limited leave with recourse to public funds (following COC)",1,0.98039215686274506,null,"Leave to Remain (LTR) with recourse ",{"$f":"B132+B133+B134+B131+B129+B125+B124+B123","v":9},8.8235294117647047]
["Limited Leave with Recourse to Public Funds (other)",2,1.9607843137254901,null,"British",{"$f":"B141","v":0},0]
["Limited leave with NRPF (10 year route)",4,3.9215686274509802]
["Limited leave with NRPF (other)",7,6.8627450980392153]
["UASC leave",0,0]
["No record held by HO (non EEA)",0,0]
["Humanitarian Protection",4,3.9215686274509802]
["Refugee Status",0,0]
["Indefinite leave   ",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",45,44.117647058823529]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",14,13.725490196078431]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",5,4.901960784313725]
["Illegal entrant - asylum claimed 'yes'",7,6.8627450980392153]
["Port Case",1,0.98039215686274506]
["British",0,0]
[]
[]
[]
["Adults - open cases as of 31 March 2021","Total","Percentage",null,"Summary - adults - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",5,{"$f":" 100/12*B146","v":41.666666666666671},null,"EEA national or EU residence rights ",{"$f":"B146+B147+B148","v":5},41]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/12*B147","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B152+B153","v":2},{"$f":" 100/12*F147","v":16.666666666666668}]
["Leave to remain (EU Settlement Scheme)",0,0,null,"No current immigration permission",{"$f":"B164+B161+B156","v":2},16.666666666666668]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B166+B163+B165+B162+B154","v":2},16.666666666666668]
["Limited leave with recourse to public funds (following COC)",1,8.3333333333333339,null,"Leave to Remain (LTR) with recourse ",{"$f":"B158+B159+B160+B157+B155+B151+B150+B149","v":1},8.3333333333333339]
["Limited Leave with Recourse to Public Funds (other)",0,0,null,"British",{"$f":"B167","v":0},0]
["Limited leave with NRPF (10 year route)",0,0]
["Limited leave with NRPF (other)",2,16.666666666666668]
["UASC leave",0,0]
["Indefinite Leave",0,0]
["No record held by HO (non EEA)",0,0]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",2,16.666666666666668]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",0,0]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",0,0]
["Illegal entrant - asylum claimed 'yes'",2,16.666666666666668]
["Port Case",0,0]
["British",0,0]
[]
[]
[]
["looked after children and care leavers - open cases as of 31 March 2021","Total","Percentage",null,"Summary - LAC / CL - 31 March 21","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",3,{"$f":" 100/73*B172","v":4.10958904109589},null,"EEA national or EU residence rights ",{"$f":"B172+B173+B174","v":3},{"$f":" 100/73*F172","v":4.10958904109589}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/73*B173","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B178+B179","v":1},{"$f":" 100/73*F173","v":1.3698630136986301}]
["Leave to remain (EU Settlement Scheme)",0,0,null,"No current immigration permission",{"$f":"B190+B187+B182","v":12},17]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B192+B189+B191+B188+B180","v":55},75.342465753424648]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B184+B185+B186+B183+B181+B177+B176+B175","v":2},2.7397260273972601]
["Limited Leave with Recourse to Public Funds (other)",1,1.3698630136986301,null,"British",{"$f":"B193","v":0},0]
["Limited leave with NRPF (10 year route)",0,0]
["Limited leave with NRPF (other)",1,1.3698630136986301]
["UASC leave",6,8.2191780821917799]
["Indefinite Leave",0,0]
["No record held by HO (non EEA)",6,8.2191780821917799]
["Humanitarian Protection",0,0]
["Refugee Status",1,1.3698630136986301]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",3,4.10958904109589]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",10,13.698630136986301]
["In Country Asylum Seeker",1,1.3698630136986301]
["Illegal entrant - asylum claimed 'no'",3,4.10958904109589]
["Illegal entrant - asylum claimed 'yes'",36,49.315068493150683]
["Port Case",2,2.7397260273972601]
["British",0,0]
[]
[]
[]
["Immigration status families - all referrals for the year","Total","Percentage",null,"Summary - families referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",19,{"$f":" 100/238*B198","v":7.9831932773109244},null,"EEA national or EU residence rights ",{"$f":"B198+B199+B200","v":28},{"$f":" 100/238*F198","v":11.764705882352942}]
["Indefinite leave to remain (EU Settlement Scheme)",1,{"$f":" 100/238*B199","v":0.42016806722689076},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B204+B205","v":61},{"$f":" 100/238*F199","v":25.630252100840337}]
["Leave to remain (EU Settlement Scheme)",8,3.3613445378151261,null,"No current immigration permission",{"$f":"B216+B213+B208","v":77},32.352941176470587]
["Limited leave with recourse to public funds (10 year route)",12,5.0420168067226889,null,"Asylum seeker / asylum seeker ARE",{"$f":"B218+B215+B217+B214+B206","v":27},11.344537815126051]
["Limited leave with recourse to public funds (following COC)",6,2.5210084033613445,null,"Leave to Remain (LTR) with recourse ",{"$f":"B210+B211+B212+B209+B207+B203+B202+B201","v":44},18.487394957983195]
["Limited Leave with Recourse to Public Funds (other)",6,2.5210084033613445,null,"British",{"$f":"B219","v":1},1]
["Limited leave with NRPF (10 year route)",25,10.504201680672269]
["Limited leave with NRPF (other)",36,15.126050420168067]
["UASC leave",0,0]
["Indefinite Leave",4,1.680672268907563]
["No record held by HO (non EEA)",14,5.882352941176471]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",16,6.7226890756302522]
["Over-stayer / Deception / Breach - asylum claimed 'no'",58,24.369747899159663]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",10,4.2016806722689077]
["In Country Asylum Seeker",1,0.42016806722689076]
["Illegal entrant - asylum claimed 'no'",5,2.1008403361344539]
["Illegal entrant - asylum claimed 'yes'",15,6.3025210084033612]
["Port Case",1,0.42016806722689076]
["British",1,0.42016806722689076]
[]
[]
[]
["Immigration status adults - all referrals for the year","Total","Percentage",null,"Summary - adults referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",39,{"$f":" 100/166*B224","v":23.493975903614459},null,"EEA national or EU residence rights ",{"$f":"B224+B225+B226","v":51},{"$f":" 100/166*F224","v":30.722891566265062}]
["Indefinite leave to remain (EU Settlement Scheme)",1,{"$f":" 100/166*B225","v":0.60240963855421692},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B230+B231","v":12},{"$f":" 100/166*F225","v":7.2289156626506035}]
["Leave to remain (EU Settlement Scheme)",11,6.6265060240963862,null,"No current immigration permission",{"$f":"B242+B239+B234","v":46},27.710843373493979]
["Limited leave with recourse to public funds (10 year route)",1,0.60240963855421692,null,"Asylum seeker / asylum seeker ARE",{"$f":"B244+B241+B243+B240+B232","v":40},24.096385542168676]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B236+B237+B238+B235+B233+B229+B228+B227","v":16},9.6385542168674707]
["Limited Leave with Recourse to Public Funds (other)",2,1.2048192771084338,null,"British",{"$f":"B245","v":1},0.60240963855421692]
["Limited leave with NRPF (10 year route)",4,2.4096385542168677]
["Limited leave with NRPF (other)",8,4.8192771084337354]
["UASC leave",0,0]
["Indefinite Leave",9,5.4216867469879526]
["No record held by HO (non EEA)",22,13.253012048192772]
["Humanitarian Protection",1,0.60240963855421692]
["Refugee Status",2,1.2048192771084338]
["Discretionary leave - trafficking",0,0]
["DDV Concession",1,0.60240963855421692]
["Over-stayer / Deception / Breach - asylum claimed 'no'",21,12.650602409638555]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",20,12.048192771084338]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",3,1.8072289156626509]
["Illegal entrant - asylum claimed 'yes'",18,10.843373493975905]
["Port Case",2,1.2048192771084338]
["British",1,0.60240963855421692]

{"sheet":"Scotland","index":10,"n_rows":262,"n_cols":7,"rows_kept":262,"cut":false,"hidden":false,"merged":[]}
["Description - all local authorities 2020-2021","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of local authorities subscribing at end of quarter",3,3,3,3]
["Number of local authorities with data uploaded at end of quarter - all case types",2,2,2,2]
["Number of local authorities with data for family cases",2,2,2,2]
["Number of local authorities with data for adult cases",2,2,2,1]
["Number of local authorities with data for children / care leaver cases",1,1,0,0]
[]
[]
[]
["Family cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",24,26,22,27]
["Number of dependants of financially supported households at end of quarter",65,68,54,72]
["Total weekly spend for the cases supported at the end of the quarter",7382.11,8230,6194,7382.11]
["Average annual cost per case",{"$f":"B13*52/B11","v":15994.571666666665},{"$f":"C13*52/C11","v":16460},14640.363636363636,14217.397037037035]
["Average annual cost (weekly spend X 52)",{"$f":"B13*52","v":383869.72},{"$f":"C13*52","v":427960},322088,383869.72]
["Average number of days on support, cases open at end of quarter",503,520,521,456]
["Of Row 11 - Number that are non EEA and unresolved",15,23,18,20]
["Of Row 11 - EEA national or EEA family member / derivative rights",2,1,1,4]
["Of Row 11 - Number that are non EEA but have LTR with recourse",5,2,3,3]
["Of Row 17 - Number that are 1000 day cases",4,4,3,2]
["Of Row 18 - Number of 1000 day EEA national cases without 'settled status ",0,0,0,0]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 20 / row 17)",0.27,0.17,0.17,0.1]
["EEA 1000 day cases, percentage of unresolved cohort (row 21 / row 18)",0,0,0,0]
["Total number of referrals per quarter",5,7,4,8]
["Total number of new cases taken on for support within quarter",6,7,3,9]
["Total number of supported cases closed within quarter",2,5,7,4]
[]
[]
[]
["Adult cases","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of financially supported households at end of quarter",33,37,35,35]
["Total weekly spend for the cases supported at the end of the quarter",4230,4713,3751,3750]
["Average annual cost per case",{"$f":"B32*52/B31","v":6665.454545454545},{"$f":"C32*52/C31","v":6623.6756756756758},5572.9142857142861,5571.4285714285716]
["Average annual cost (weekly spend X 52)",{"$f":"B32*52","v":219960},{"$f":"C32*52","v":245076},195052,195000]
["Average number of days on support, cases open at end of quarter",562,565,639,780]
["Of Row 31 - Number that are non EEA and unresolved",27,33,31,31]
["Of Row 31 - EEA national or EEA family member / derivative rights",3,3,3,3]
["Of Row 31 - Number that are non EEA but have LTR with recourse",3,1,1,1]
["Of Row 31 - Number that are 1000 day cases",7,7,4,8]
["Of Row 31 - Number of 1000 day EEA national cases without 'settled status ",0,0,0,0]
["Non EEA 1000 day cases, percentage of unresolved cohort (row 39 / row 36)",0.26,0.21,0.13,0.26]
["EEA 1000 day cases, percentage of unresolved cohort (row 40 / row 37)",0,0,0,0]
["Total number of referrals per quarter",12,9,6,5]
["Total number of new cases taken on for support within quarter",14,7,1,1]
["Total number of supported cases closed within quarter",1,3,3,1]
[]
[]
[]
[]
["Looked after children and care leavers","Q1 20/21","Q2 20/21","Q3 20/21","Q4 20/21"]
["Number of open cases at end of quarter",2,2,0,0]
["Of which under age of 18",0,0,0,0]
["Of which aged 18-21",0,0,0,0]
["Of which aged 21 and over",2,2,0,0]
["Of number of open cases (row 51), number financially supported",2,2,0,0]
["Total weekly spend for the cases financially supported at end of quarter",380,376,0,0]
["Average annual cost per case",{"$f":"B56/B55*52","v":9880},{"$f":"C56/C55*52","v":9776},0,0]
["Average annual cost (weekly spend X 52)",{"$f":"B56*52","v":19760},{"$f":"C56*52","v":19552},0,{"$f":"E56*52","v":0}]
["Total number of new cases recorded within the quarter",0,0,0,0]
["Total number of cases closed ",0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason family and adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",0,{"$f":" 100/26*B71","v":0}]
["Non-EEA national - left the UK (HO / LA funded)",0,0]
["Accessed Asylum Support",3,11.538461538461538]
["No longer eligible",8,30.76923076923077]
["EEA national / family member - accessed benefits / employment",0,0]
["Granted Leave to Remain",{"$f":"15","v":15},{"$f":" 100/26*B76","v":57.692307692307693}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason family cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",0,{"$f":" 100/18*B93","v":0}]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/18*B94","v":0}]
["Accessed Asylum Support",2,11.111111111111111]
["No longer eligible",4,22.222222222222221]
["EEA national / family member - accessed benefits / employment",0,0]
["Granted Leave to Remain",12,66.666666666666657]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Closure reason adult cases - all closures in the year","Total","Percentage"]
["EEA national - left the UK (LA Funded / self return)",0,{"$f":" 100/8*B115","v":0}]
["Non-EEA national - left the UK (HO / LA funded)",0,{"$f":" 100/8*B116","v":0}]
["Accessed Asylum Support",1,12]
["No longer eligible",1,12]
["Deceased",3,37.5]
["EEA national / family member - accessed benefits / employment",0,0]
["Granted Leave to Remain",3,37.5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Immigration status families - open cases as of 31 March 2021","Total","Percentage",null,"Summary - families - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",3,{"$f":" 100/22*B137","v":13.636363636363637},null,"EEA national or EU residence rights ",{"$f":"B137+B138+B139","v":4},{"$f":" 100/22*F137","v":18.181818181818183}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/22*B138","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B143+B144","v":0},0]
["Leave to remain (EU Settlement Scheme)",1,4.5454545454545459,null,"No current immigration permission",{"$f":"B155+B152+B147","v":5},22.72727272727273]
["Limited leave with recourse to public funds (10 year route)",3,13.636363636363637,null,"Asylum seeker / asylum seeker ARE",{"$f":"B157+B154+B156+B153+B145","v":10},45.45454545454546]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B149+B150+B151+B148+B146+B142+B141+B140","v":3},13.636363636363637]
["Limited Leave with Recourse to Public Funds (other)",0,0,null,"British",{"$f":"B158","v":0},0]
["Limited leave with NRPF (10 year route)",0,0]
["Limited leave with NRPF (other)",0,0]
["UASC leave",0,0]
["No record held by HO (non EEA)",0,0]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Indefinite leave   ",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",5,22.72727272727273]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",3,13.636363636363637]
["In Country Asylum Seeker",2,9.0909090909090917]
["Illegal entrant - asylum claimed 'no'",0,0]
["Illegal entrant - asylum claimed 'yes'",5,22.72727272727273]
["Port Case",0,0]
["British",0,0]
[]
[]
[]
["Adults - open cases as of 31 March 2021","Total","Percentage",null,"Summary - adults - 31 March 2021","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",3,{"$f":" 100/35*B163","v":8.5714285714285712},null,"EEA national or EU residence rights ",{"$f":"B163+B164+B165","v":3},{"$f":" 100/35*F163","v":8.5714285714285712}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/35*B164","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B169+B170","v":1},{"$f":" 100/35*F164","v":2.8571428571428572}]
["Leave to remain (EU Settlement Scheme)",0,0,null,"No current immigration permission",{"$f":"B181+B178+B173","v":17},48]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B183+B180+B182+B179+B171","v":14},40]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B175+B176+B177+B174+B172+B168+B167+B166","v":0},0]
["Limited Leave with Recourse to Public Funds (other)",0,0,null,"British",{"$f":"B184","v":0},0]
["Limited leave with NRPF (10 year route)",0,0]
["Limited leave with NRPF (other)",1,2.8571428571428572]
["UASC leave",0,0]
["Indefinite Leave",0,0]
["No record held by HO (non EEA)",4,11.428571428571429]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",0,0]
["Over-stayer / Deception / Breach - asylum claimed 'no'",11,31.428571428571431]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",5,14.285714285714286]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",2,5.7142857142857144]
["Illegal entrant - asylum claimed 'yes'",7,20]
["Port Case",2,5.7142857142857144]
["British",0,0]
[]
[]
[]
["looked after children and care leavers - open cases as of 31 March 2021","Total","Percentage",null,"Summary - LAC / CL - 31 March 21","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",null,null,null,"EEA national or EU residence rights "]
["Indefinite leave to remain (EU Settlement Scheme)",null,null,null,"Leave to Remain (LTR) with NRPF "]
["Leave to remain (EU Settlement Scheme)",null,null,null,"No current immigration permission"]
["Limited leave with recourse to public funds (10 year route)",null,null,null,"Asylum seeker / asylum seeker ARE"]
["Limited leave with recourse to public funds (following COC)",null,null,null,"Leave to Remain (LTR) with recourse "]
["Limited Leave with Recourse to Public Funds (other)",null,null,null,"British"]
["Limited leave with NRPF (10 year route)"]
["Limited leave with NRPF (other)"]
["UASC leave"]
["Indefinite Leave"]
["No record held by HO (non EEA)"]
["Humanitarian Protection"]
["Refugee Status"]
["Discretionary leave - trafficking"]
["DDV Concession"]
["Over-stayer / Deception / Breach - asylum claimed 'no'"]
["Over-stayer / Deception / Breach - asylum claimed 'yes'"]
["In Country Asylum Seeker"]
["Illegal entrant - asylum claimed 'no'"]
["Illegal entrant - asylum claimed 'yes'"]
["Port Case"]
["British"]
[]
[]
[]
["Immigration status families - all referrals for the year","Total","Percentage",null,"Summary - families referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",0,{"$f":" 100/20*B215","v":0},null,"EEA national or EU residence rights ",{"$f":"B215+B216+B217","v":1},{"$f":" 100/20*F215","v":5}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/20*B216","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B221+B222","v":1},{"$f":" 100/20*F216","v":5}]
["Leave to remain (EU Settlement Scheme)",1,5,null,"No current immigration permission",{"$f":"B233+B230+B225","v":6},30]
["Limited leave with recourse to public funds (10 year route)",2,10,null,"Asylum seeker / asylum seeker ARE",{"$f":"B235+B232+B234+B231+B223","v":7},35]
["Limited leave with recourse to public funds (following COC)",1,5,null,"Leave to Remain (LTR) with recourse ",{"$f":"B227+B228+B229+B226+B224+B220+B219+B218","v":5},25]
["Limited Leave with Recourse to Public Funds (other)",1,5,null,"British",{"$f":"B236","v":0},0]
["Limited leave with NRPF (10 year route)",1,5]
["Limited leave with NRPF (other)",0,0]
["UASC leave",0,0]
["Indefinite Leave",0,0]
["No record held by HO (non EEA)",1,5]
["Humanitarian Protection",0,0]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",1,5]
["Over-stayer / Deception / Breach - asylum claimed 'no'",4,20]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",1,5]
["In Country Asylum Seeker",2,10]
["Illegal entrant - asylum claimed 'no'",1,5]
["Illegal entrant - asylum claimed 'yes'",4,20]
["Port Case",0,0]
["British",0,0]
[]
[]
[]
["Immigration status adults - all referrals for the year","Total","Percentage",null,"Summary - adults referred - F/Y","Number ","Percentage"]
["EEA nationals or EU residence rights - not granted EUSS",1,{"$f":" 100/23*B241","v":4.3478260869565215},null,"EEA national or EU residence rights ",{"$f":"B241+B242+B243","v":1},{"$f":" 100/23*F241","v":4.3478260869565215}]
["Indefinite leave to remain (EU Settlement Scheme)",0,{"$f":" 100/23*B242","v":0},null,"Leave to Remain (LTR) with NRPF ",{"$f":"B247+B248","v":1},{"$f":" 100/23*F242","v":4.3478260869565215}]
["Leave to remain (EU Settlement Scheme)",0,0,null,"No current immigration permission",{"$f":"B259+B256+B251","v":11},47.826086956521735]
["Limited leave with recourse to public funds (10 year route)",0,0,null,"Asylum seeker / asylum seeker ARE",{"$f":"B261+B258+B260+B257+B249","v":5},21.739130434782609]
["Limited leave with recourse to public funds (following COC)",0,0,null,"Leave to Remain (LTR) with recourse ",{"$f":"B253+B254+B255+B252+B250+B246+B245+B244","v":5},21.739130434782609]
["Limited Leave with Recourse to Public Funds (other)",2,8.695652173913043,null,"British",{"$f":"B262","v":0},0]
["Limited leave with NRPF (10 year route)",0,0]
["Limited leave with NRPF (other)",1,4.3478260869565215]
["UASC leave",0,0]
["Indefinite Leave",1,4.3478260869565215]
["No record held by HO (non EEA)",3,13.043478260869565]
["Humanitarian Protection",1,4.3478260869565215]
["Refugee Status",0,0]
["Discretionary leave - trafficking",0,0]
["DDV Concession",1,4.3478260869565215]
["Over-stayer / Deception / Breach - asylum claimed 'no'",8,34.782608695652172]
["Over-stayer / Deception / Breach - asylum claimed 'yes'",1,4.3478260869565215]
["In Country Asylum Seeker",0,0]
["Illegal entrant - asylum claimed 'no'",0,0]
["Illegal entrant - asylum claimed 'yes'",3,13.043478260869565]
["Port Case",1,4.3478260869565215]
["British",0,0]

{"sheet":"Sheet1","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}