{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Guide_tables","PivotTable Help"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":14,"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":"Guide_tables","index":0,"n_rows":176,"n_cols":13,"rows_kept":176,"cut":false,"hidden":false,"merged":[[127,11,130,11],[127,12,130,12],[127,1,128,1],[129,2,130,2],[129,1,130,1],[127,2,128,2],[108,12,118,12],[6,10,6,12],[37,10,37,12],[64,10,64,12],[76,10,76,12],[92,10,92,12],[104,10,104,12],[123,10,123,12],[103,0,103,13],[122,0,122,13],[109,4,111,4],[109,7,111,8],[112,4,118,4],[112,5,114,5],[112,6,114,6],[115,5,116,5],[115,6,116,6],[80,11,87,11],[38,1,38,3],[96,1,99,1],[105,4,105,5],[108,10,118,10],[108,9,111,9],[101,5,101,7],[5,0,5,13],[36,0,36,13],[75,0,75,13],[91,0,91,13],[96,8,97,10],[93,5,93,6],[93,9,93,10],[93,7,93,8],[7,5,7,6],[41,1,59,1],[41,2,59,2],[41,3,59,3],[61,2,61,3],[96,11,99,11],[96,12,99,12],[98,4,99,4],[98,7,99,7],[98,8,99,8],[98,9,99,9],[98,10,99,10],[96,2,99,2],[96,3,99,3],[96,4,97,4],[93,1,93,3],[139,12,148,12],[144,7,148,7],[132,3,132,4],[132,5,132,6],[134,0,134,13],[135,10,135,12],[139,1,148,1],[139,2,148,2],[139,3,148,3],[139,7,143,7],[139,4,148,4],[142,6,148,6],[142,5,148,5],[139,5,141,5],[117,5,118,5],[127,9,130,10],[89,3,89,4],[139,10,148,10],[139,6,141,6],[132,1,132,2],[120,1,120,4],[129,4,130,4],[129,8,130,8],[108,1,118,1],[108,2,118,2],[108,3,118,3],[108,6,108,8],[89,1,89,2],[101,9,101,11],[139,11,148,11],[108,11,118,11],[105,8,105,9],[89,6,89,7],[112,9,118,9],[129,7,130,7],[127,4,128,4],[120,6,120,7],[128,7,128,8],[127,3,130,3],[124,3,124,4],[0,0,0,13],[10,1,32,1],[10,2,32,2],[10,3,32,3],[48,4,53,4],[48,7,59,7],[54,4,59,4],[80,12,87,12],[82,4,83,4],[82,7,83,7],[82,8,83,8],[84,4,85,4],[84,6,85,8],[44,6,46,6],[41,8,59,10],[86,7,87,7],[86,8,87,8],[80,1,87,1],[80,2,87,2],[80,3,87,3],[80,4,81,4],[80,7,81,7],[1,0,1,13],[2,5,2,13],[150,5,150,6],[136,2,136,3],[136,8,136,9],[150,7,150,8],[63,0,63,13],[65,3,65,4],[65,5,65,6],[65,7,65,8],[68,1,70,1],[68,2,70,2],[68,3,70,3],[68,4,70,4],[68,7,70,10],[68,11,70,11],[68,12,70,12],[73,1,73,2],[117,6,118,6],[96,7,97,7],[73,7,73,8],[89,10,89,11],[105,6,105,7],[105,1,105,3],[101,2,101,4],[77,5,77,6],[10,12,32,12],[23,4,25,4],[26,4,29,4],[30,4,32,4],[41,4,45,4],[41,5,43,5],[10,4,22,4],[41,11,59,11],[41,12,59,12],[23,7,25,7],[23,8,25,8],[26,7,28,7],[26,8,28,8],[31,5,32,5],[29,7,29,8],[30,7,30,8],[32,7,32,8],[10,7,22,10],[23,9,32,10],[10,11,32,11],[80,8,81,8],[80,9,87,10],[61,4,61,5],[86,4,87,4],[77,8,77,9],[77,3,77,4],[73,5,73,6],[73,3,73,4],[44,7,46,7],[175,7,175,8],[171,8,173,8],[171,9,173,9],[166,0,166,13],[167,10,167,12],[168,2,168,3],[168,8,168,9],[171,1,173,1],[171,2,173,2],[171,3,173,3],[171,4,173,4],[171,5,173,5],[171,6,173,6],[171,7,173,7],[171,10,173,10],[171,11,173,11],[171,12,173,12],[152,0,152,13],[157,1,161,1],[157,2,161,2],[157,6,161,6],[157,7,160,7],[157,8,161,8],[154,4,154,5],[164,4,164,5],[154,7,154,8],[164,8,164,9],[153,11,153,13]]}
["Guide tables"]
[]
[null,null,null,null,null,"General:\n\nThe information provides the user with breakdowns of Legal Aid data from April 2000 in some areas but also quarterly for the last five year where possible. The aim is to maximise the usage of data by users so analytical work can be carried out independently.\n\nThe data is provided in a comma separated value (CSV) machine-readable format so that it can easily be imported into analytical software packages. These packages include R, Access, SQL, SAS, up-to-date versions of Excel but not versions of Excel prior to 2010 (because of insufficient number of rows). This format enables the user to manipulate and aggregate the published data in different ways. \n\nFigures displayed may differ from previously published due to improvements in data processing.\n\nEach data-set has the following standard variables:\n\n\n\n\n\n\n\n\n\n\n\n\nWithin each scheme and category the underlying sub-categories are grouped into their area of law with the use of a prefix to allow easier analysis of variables. For example CR = civil representation, CAG = courts applications and grants, LH = legal help, MED = family mediation, APR = appeals and representations, ECF = expectional case funding, CL = crime lower and CH = crime higher\n\nEach area except for appeals and representations has a monetary or time based 'value' field with the exceptions being civil representation where further figures are also provided giving the expenditure breakdown for solictors, counsel, disbusements and where appropriate the amount paid to costs by the opponent and ECF where the value relates to number of working days to process applications minus time on hold.\nClient diversity is an annual addition and is released in a separate CSV.\n\n\n\n"]
[]
[]
["Crime Lower: This area covers pre-charge, the early court system and prison assistance. It covers work carried out by legal aid providers at police stations and in magistrates’ courts in relation to people accused of or charged with criminal offences. Prison law is also included within the latter category."]
[null,null,null,null,null,null,null,null,null,null,"return to top of page"]
[null,null,null,"category: Broad breakdown of crime lower",null,"sub_cat1&2: breakdown by category of law",null,null,"Duty solicitor standby: scheme ended in 2007-08"]
[]
[null,"fin_yr","fin_qtr","scheme","category","sub_cat1","sub_cat2","sub_cat3","sub_cat4","sub_cat5","sub_cat6","volume","value"]
[null,"2001-02 \nonwards","1 to 4","Crime Lower","Charged defendants","Advice and assistance","Advice and assistance","No Further Breakdown",null,null,null,null,"In £'s"]
[null,null,null,null,null,"Advocacy assistance","Advocacy assistance"]
[null,null,null,null,null,"Appeals, reviews and other courts","Appeals, reviews and other courts"]
[null,null,null,null,null,"Assistance by way of representation","Assistance by way of representation"]
[null,null,null,null,null,"Civil assistance on criminal matters","Civil assistance on criminal matters"]
[null,null,null,null,null,"Early cover","Early cover"]
[null,null,null,null,null,"Early first or administrative hearings","Early first or administrative hearings"]
[null,null,null,null,null,"Extended court sitting hours pilot","Extended court sitting hours pilot"]
[null,null,null,null,null,"Firms claiming for file review payments","Firms claiming for file review payments"]
[null,null,null,null,null,"Free standing advice and assistance","Free standing advice and assistance"]
[null,null,null,null,null,"Post charge police station advice and assistance","Post charge police station advice and assistance"]
[null,null,null,null,null,"Preparation: representation order refused","Preparation: representation order refused"]
[null,null,null,null,null,"Refused means test form completion fee","Refused means test form completion fee"]
[null,null,null,null,"Pre-charge suspects","Attendance and duty solicitor standby","Attendance\nDuty solicitor standby (claims)","N/A\nAnti-social behaviour orders \nBurglary\nCriminal Damage\nDriving and motor vehicle offences (other than those covered by codes 1,6 &7)\nDrug offences\nFraud and forgery and other offences of dishonesty not otherwise categorised\nHomicide and related grave offences\nOffences against the person\nOther offences\nOther prescribed proceedings\nPublic order offences\nRobbery\nSexual offences and associated offences against children\nSexual offender orders\nTerrorism\nTheft (including taking vehicle without consent)\nUnknown","N/A\nChange of Solicitor (Investigations)\nClient charged/summons/caution/FPN (Investigations)\nNo further action/client not charged (Investigations)\nUnknown","No futher breakdown"]
[null,null,null,null,null,"Other police station work","Attendance on immigration issues\nFree standing advice and assistance (not in police station)\nWarrants of further detention"]
[null,null,null,null,null,"Telephone advice and admin costs","CDD Direct telephone advice\nTelephone advice admin costs\nTelephone advice only"]
[null,null,null,null,"Prison Law","Advocacy assistance at parole board hearings","Advocacy assistance at parole board hearings","Disciplinary matters - Written Representations\nParole and disciplinary matters - Oral Representations\nParole Board - Written Representations\nPrison Law Advice and Assistance Matters\nUnknown","Adjudication\nNo further action (Prison Law)\nParole Board hearing\nUnknown\nWritten Representations"]
[null,null,null,null,null,"Advocacy assistance at prison discipline hearings","Advocacy assistance at prison discipline hearings"]
[null,null,null,null,null,"Free standing advice and assistance","Free standing advice and assistance"]
[null,null,null,null,null,"Prison law","Prison law","No Further Breakdown"]
[null,null,null,null,"Representation at magistrates' court","Court duty solicitor (sessions)","Court duty solicitor (sessions)","No Further Breakdown"]
[null,null,null,null,null,"Representation order required","Higher standard fees\nLower standard fees\nNon-standard fees and exempt cases","N/A\nAnti-social behaviour orders \nBurglary\nCriminal Damage\nDriving and motor vehicle offences (other than those covered by codes 1,6 &7)\nDrug offences\nFraud and forgery and other offences of dishonesty not otherwise categorised\nHomicide and related grave offences\nOffences against the person\nOther offences\nOther prescribed proceedings\nPublic order offences\nRobbery\nSexual offences and associated offences against children\nSexual offender orders\nTerrorism\nTheft (including taking vehicle without consent)\nUnknown\n","N/A\nASBOs and other court orders\nChange of Solicitor (Proceedings)\nCommittal/Remitted\nDiscounted trial\nGuilty plea\nMisc (Proceedings)\nMixed pleas\nNo further action (Proceedings)\nTrial\nUnknown"]
[null,null,null,null,null,null,"Second claims for deferred sentencing","No Further Breakdown"]
[]
[null,"fin_qtr: Quarterly breakdown available from 2009-10",null,null,"Prison Law: breakdown only available from 2009-10",null,"Telephone advice and admin costs: CDD and telephone advice admin costs only available from 2007-08"]
[]
["Crime Higher: Information is provided on legal representation in the Crown Court and above. This includes, Crown Court cases (typically solicitor prepares case for trial and barrister or solicitor advocate provides representation), Very High Cost Cases (extensive evidence reviewed and case prepared by solicitor where the senior counsel (QC) often presents)"]
[null,null,null,null,null,null,null,null,null,null,"return to top of page"]
[null,"Higher Courts: annual figures split by the court of appeal, costs offices and Supreme Court",null,null,"Crown Court: Annual figures on national taxing team work under proceeds of crime ","High Cost Crime: cases heard in Crown Court. Mainly cover complex fraud since trial length extended to 60 day","Contracts: These are actively managed by central teams monitoring workload and issuing and closing contracts once complete.","Expenditure: measured on an ongoing payment basis for each live contract."]
[]
[null,"fin_yr","fin_qtr","scheme","category","sub_cat1","sub_cat2","sub_cat3","sub_cat4","sub_cat5","sub_cat6","volume","value"]
[null,"2001-02 \nonwards","1 to 4","Crime Higher","High Cost Crime","Cases Opened","Fraud","Carousel Fraud\nMoney Laundering\nPhoenix Fraud\nVAT Fraud\nOther Fraud","No further breakdown",null,null,null,"In £'s"]
[null,null,null,null,null,null,"Violence","Terrorism\nMurder\nOther Violence"]
[null,null,null,null,null,null,"Other","Drugs\nOther"]
[null,null,null,null,null,"Contracts Opened\nContracts Closed","No further breakdown","No further breakdown"]
[null,null,null,null,null,"Expenditure"]
[null,null,null,null,"Crown Court","Discretionary and legacy claims"]
[null,null,null,null,"Higher Courts","Court of appeal and supreme court","N/A\nCourt of Appeal\nSenior Court costs office\nSupreme Court","Advocate\n\nLitigator"]
[null,null,null,null,"Litigator Graduated Fee Scheme","Appeal","Appeal Against Conviction\nAppeal Against Sentence","A Homicide and related grave offences\nB Offences involving serious violence or damage and serious drug offences\nC Lesser offences involving violence or damage, and less serious drug offences\nD Serious sexual offences and offences against children\nE Burglary, etc\nF Other offences of dishonesty\nG Other offences of dishonesty\nH Miscellaneous other offences\nI Offences against public justice and similar offences\nJ Serious Sexual Offences\nK Other offences of dishonesty (high value)"]
[null,null,null,null,null,"Committal for Sentence","Committal for Sentence"]
[null,null,null,null,null,"Cracked Trial","Cracked Trial"]
[null,null,null,null,null,"Guilty Plea","Elected Case Not Proceeded\nGuilty Plea"]
[null,null,null,null,null,"Trial","Trial"]
[null,null,null,null,null,"Other","Breach Crown Court Order\nContempt\nHearing Subsequent To Sentence\nUnknown"]
[null,null,null,null,"Advocate Graduated \nFee Scheme","Appeal","Appeal Against Conviction\nAppeal Against Sentence"]
[null,null,null,null,null,"Committal for Sentence","Committal for Sentence"]
[null,null,null,null,null,"Cracked Trial","Cracked before retrial\nCracked Trial"]
[null,null,null,null,null,"Guilty Plea","Elected Case Not Proceeded\nGuilty Plea"]
[null,null,null,null,null,"Trial","Retrial\nTrial"]
[null,null,null,null,null,"Other","Breach Crown Court Order\nContempt\nDiscontinuance\n"]
[]
[null,null,"LGFS & AGFS: Two funding elements in Crown Court mainly covering litigators (solicitor firms) and advocates (barristers)",null,"sub_cat1 (LGFS & AGFS): Type of case and a further breakdown are provided.\nWith full trials, guilty pleas and cracked trials (guilty on the day) being the largest proportion of work",null,"Appeals & Committals for sentence: \nfrom the magistrates’ court","Retrials: these are available in AGFS only","Offence: Offence groupings to give an indication of severity of case this is based on the agreed offence type paid upon"]
[]
["Crime Court Applications and Grants: Data on the granting and failed applications for Legal Aid in the criminal courts"]
[null,null,null,null,null,null,null,null,null,null,"return to top of page"]
[null,"fin_yr: available from 2010-11 only as system creation ",null,"Applications: Applications for legal aid in magistrates’ court with a small number applying while in the Crown Court (ie late applications)",null,"Magistrates court: In Magistrates’ court trials are either summary or either way. Some trials are committed for the final sentence portion at the higher crown court",null,"sub_cat2: Types of work in the magistrates' court and Crown Court differ slightly."]
[]
[null,"fin_yr","fin_qtr","scheme","category","sub_cat1","sub_cat2","sub_cat3","sub_cat4","sub_cat5","sub_cat6","volume","value"]
[null,"2010-11 \nonwards\n\n\n\n\n\n2013-14 onwards","1 to 4","Crime Apps and Grants","Applications\n\n\n\nGrants\n\n\n\nCentral Funds","Magistrates court","Committal for Sentence\nEither Way\nSummary Only\nUnknown","No further breakdown",null,null,null,null,"In £'s"]
[null,null,null,null,null,"Crown court","Appeal\nCommittal for Sentence\nEither Way\nIndictable\nSummary Only\nUnknown"]
[null,null,null,null,null,"Central Funds","Legacy Systems\nMagistrates' court\nCrown Court\nCourts central fund payments\nExperts and defendant costs\nInterpreter and translation"]
[]
[]
[null,null,null,"Grants: Grants of legal aid for defendants in magistrates’ cases that either result in the mags court or continue to the Crown Court",null,"Crown court: In the Crown court they hear these sentence hearings, or appeals against mags decisions. Plus those either way cases that are to be heard in the higher court alongside the other indictable only offences.",null,"Unknown: Unknown categories are due to early system implementation where this field was not collected. More recent data is accurate and contains this information."]
[]
["Legal Help: This is a form of civil legal services which includes advice and assistance about a legal problem, but does not include representation or advocacy in proceedings. It is usually the first point of civil legal advice."]
[null,null,null,null,null,null,null,null,null,null,"return to top of page"]
[null,"fin_yr: Financial year",null,"category: type of work being measured. Matters completed and Other work starts available from 2008-09. Oher work completed only started in 2013-14.",null,"sub_cat1&2: These can be split by family and non-family types with a further breakdown to the full category of law; which is a thematic definition of areas of law",null,"sub_cat3: The current status of the provider at the time of the report being run is used to classify all of the provider’s cases, albeit of the status of the provider when the case was actually undertaken","Matters started: breakdown by provider available from 2002-03; 2005-06 specialist telephone advice was introduced and CLAC data available between 2006-07 to 2013-14, data relating to this category are only available annually",null,"sub_cat4: The benefit type is only applicable to matters completed, it provides information on outcomes."]
[]
[null,"fin_yr","fin_qtr","scheme","category","sub_cat1","sub_cat2","sub_cat3","sub_cat4","sub_cat5","sub_cat6","volume","value"]
[null,"2000-01\nonwards","1 to 4","Legal help","Matters started","Family","Family","Solicitor\n\nNot for profit\n\nSpecialist telephone advice service\n\nCommunity Legal Aid Centres \n(CLAC)","No further breakdown","No further \nbreakdown",null,null,"In £'s"]
[null,null,null,null,null,"Non-family","Public law\nCommunity care\nDebt\nDiscrimination\nEmployment\nHousing\nWelfare Benefits\nImmigration - Asylum\nImmigration - Nationality and visit visas\nMental health"]
[null,null,null,null,"Matters completed","Family","Private law family\nPublic law family\nHelp with family mediation\nFamily","Not for profit\n\n\nSolicitor\n\n\nSpecialist telephone advice service","Financial benefit\n\nNon-financial benefit\n\nOutcome not known or client \nceased to give instruction\n\nProceeded under other civil funding"]
[null,null,null,null,null,"Non-family","Public law\nCommunity care\nDebt\nDiscrimeination\nEmployment\nHousing\nWelfare Benefits\nImmigration - Asylum\nImmigration - Nationality and visit visas\nMental health"]
[null,null,null,null,"Other work starts","Housing possession court duty \nscheme","No further breakdown"]
[null,null,null,null,null,"Telephone operator service"]
[null,null,null,null,"Other work completed","Family","Family","Specialist telephone advice service","Determination"]
[null,null,null,null,null,"Non-family","Discrimination\nEducation\nMiscellaneous\nDebt\nEmployment\nHousing\nWelfare Benefits"]
[]
[null,"fin_qtr: Financial quarters only available from 2009-10",null,"Matters completed: Data available from 2009-10. Data for CLAC are unavailable for this category",null,"Housing possession court duty scheme: Annual data only from 2008-09","Family: Further split only available for completed matters in Solicitors and Not for Profit cases. Specialist Telephone advice service cases are not broken down at present.",null,"Determination: Introduced in 2013-14 for matters referred by the operator service to advice specialists to provide assessment on scope and eligibility",null,"value: The sum of the value of claims within the category, including VAT. Available for matters completed (solicitors and NfPs) from 2008-09, specialist telephone advice service from 2010-11 and determinations from 2013-14"]
[]
["Civil representation: Civil Representation is representation by solicitors and barristers for civil cases, which could go to court. Many legal help cases will extend to civil representation with full investigations undertaken or in court representation given although it is possible enter straight into civil representation."]
[null,null,null,null,null,null,null,null,null,null,"return to top of page"]
[null,"Grants: the volume of legal aid in the period. These are not linked with Applications with an application in one period possibly being granted in a later period",null,null,"Applications: volume received in the period. These are not linked to Grants with an application in one period possibly being granted in a later period","\n\nsub_cat1&2: All civil representation areas can be split by family and non-family types with a further breakdown to the full category of law; which is a thematic definition of areas of law",null,"sub_cat3: All Civil Representation areas can be split by a final subdivision of whether a claim is a Judicial review or if the claim has evidence attached from a domestic violence or child abuse angle",null,"None: This category is where they were none of the above and for those that are N/A the information does not currently exist"]
[]
[null,"fin_yr","fin_qtr","scheme","category","sub_cat1","sub_cat2","sub_cat3","sub_cat4","sub_cat5","sub_cat6","volume","value"]
[null,"2006-07\nonwards","1 to 4","Civil Representation","Applications\n\n\n\n\n\n\n\n\n\nGrants","Family","Combined family proceedings\nDomestic violence\nFinancial provision\nHelp with Mediation\nOther family proceedings\nOther public law Children Act proceedings\nPrivate law Children Act proceedings\nSpecial Children Act proceedings","N/A\n\n\nBoth Domestic Violence or Child Abuse\n\n\nChild Abuse\n\n\nDomestic Violence\n\n\nEither Domestic Violence or Child Abuse\n\n\nJudicial Review\n\n\nNone","No further breakdown",null,null,null,"In £'s"]
[null,null,null,null,null,"Non-family","Actions against the police etc.\nClinical negligence\nCommunity care\nConsumer\nDebt\nDiscrimination\nEducation\nEmployment\nHousing\nImmigration\nMental health\nMiscellaneous\nPersonal injury\nPublic law\nWelfare Benefits"]
[null,null,null,null,"Closed case cost\n\n - met by LAA\n - met by opponent (where some or all cost met by opponent)","Family","Combined family proceedings\nDomestic violence\nFinancial provision\nHelp with Mediation\nOther family proceedings\nOther public law Children Act proceedings\nPrivate law Children Act proceedings\nSpecial Children Act proceedings","N/A\n\n\nBoth Domestic Violence or Child Abuse\n\n\nChild Abuse\n\n\nDomestic Violence\n\n\nEither Domestic Violence or Child Abuse\n\n\nJudicial Review\n\n\nNone","N/A\n\n\n\nFinal_Hearing\n\n\n\n\nNo_Final_Hearing\n\n\n\n\nProc_Issued ","N/A\n\n\n\n\n\nBenefit to client\n\n\n\n\n\n\nNo benefit to client","Normal \n\n\n\n\nHigh cost"]
[null,null,null,null,null,"Non-family","Actions against the police etc.\nClinical negligence\nCommunity care\nConsumer\nDebt\nDiscrimination\nEducation\nEmployment\nHousing\nImmigration\nMental health\nMiscellaneous\nPersonal injury\nPublic law\nWelfare Benefits"]
[null,null,null,null,0]
[null,null,"Family: In Civil Representation the family category can be split further than for Legal Help",null,null,"sub_cat4: Closed cases as well as having an expenditure are also split by the majority payment being either LAA or the opponent (ie the claimant won and the judge ordered them to pay legal costs)",null,null,null,"sub_cat6: The benefit type is only applicable to matters completed, it provides information on outcome type and benefit type."]
[]
["Mediation: Family mediation allows a neutral mediator help the parties to reach a mutually acceptable compromise while conciliation gives the mediator the power to suggest grounds for compromise. Those in mediation may have also required Legal Help in the first instance and after mediation may result in Civil Representation in court."]
[null,null,null,null,null,null,null,null,null,null,"return to top of page"]
[null,"Category: Broad breakdown of mediation into assessments, starts for full mediation and outcomes.",null,null,"sub_cat1: Type of mediation.  For assessments this will be alone, separate and together.  For full mediation it will give the category: all (property & finance and children), property & finance and children.",null,"sub_cat2: This relates to the number of mediators involved.  Only available for starts and outcomes.",null,"sub_cat4: Indicates whether there was a proposal written up if there was full agreement and, for a partial agreement, whether this agreement was for children or property & finance."]
[]
[null,"fin_yr","fin_qtr","scheme","category","sub_cat1","sub_cat2","sub_cat3","sub_cat4","sub_cat5","sub_cat6","volume","value"]
[null,"2006-07 \nonwards","1 to 4","Mediation","Mediation Assessments","Assessment Meeting - Alone\nAssessment Meeting - Separate\nAssessment Meeting - Together","No further breakdown",null,null,"No further breakdown","No further breakdown",null,"In £'s"]
[null,null,null,null,"Mediation Starts","All Issues","Co Mediation\nSole Mediation","No further breakdown"]
[null,null,null,null,null,"Children Only","Co Mediation\nSole Mediation"]
[null,null,null,null,null,"Property & Finance","Co Mediation\nSole Mediation"]
[null,null,null,null,"Mediation Outcomes","All issues","Co Mediation\nSole Mediation","Full Agreement","Success- no proposal\nSuccess- proposal","1\n2\n3\n4\n5 or more"]
[null,null,null,null,null,null,null,"Partial Agreement","Agreed- children\nAgreed- property & finance"]
[null,null,null,null,null,null,null,"No Agreement","Broken down"]
[null,null,null,null,null,"Children Only","Co Mediation\nSole Mediation","Full Agreement","Success- no proposal\nSuccess- proposal"]
[null,null,null,null,null,null,null,"No Agreement","Broken down"]
[null,null,null,null,null,"Property & Finance","Co Mediation\nSole Mediation","Full Agreement","Success- no proposal\nSuccess- proposal"]
[null,null,null,null,null,null,null,"No Agreement","Broken down"]
[]
[null,null,null,null,null,null,"sub_cat3: This is the outcome of the mediation.  ‘Partial agreement’ is only possible for ‘all issues’: it indicates that there was agreement for either children or property & finance, but not both areas.",null,null,"sub_cat5: Number of mediation sessions. This can be 1, 2, 3, 4 and 5 or more"]
[]
["Appeals and representations: Individuals who are unhappy with decisions in relation to legal aid determinations can ask for an internal review. If pursued, the matter, if eligible, may then be referred to an independent adjudicator."]
[null,null,null,null,null,null,null,null,null,null,"return to top of page"]
[null,null,null,"Representations against the grant of legal aid: Upon granting public funding, opponents or third parties may appeal against the grant or continuation of funding. ",null,"category (Representations closed out): \nThese can include representations received in the previous year due to time lag between receipt and close.","sub_cat1 (Representations against the grant of legal aid): Representations can be made concerning the legal merits of the case, the financial means of the applicant or both.",null,"sub_cat2 (Representations closed out): \nThis describes the outcome of the investigation. \"No change\" may include representations that did not merit investigation."]
[]
[null,"fin_yr","fin_qtr","scheme","category","sub_cat1","sub_cat2","sub_cat3","sub_cat4","sub_cat5","sub_cat6","volume","value"]
[null,"2006-07",null,"Appeals and representations","Representations against the grant of legal aid","Representations closed out","Means\n\nMerits\n\nMerits and means","Application refused\nCertificate amended\nCertificate discharged\nCertificate revoked\nNo change\nNumber received","No further breakdown","No further breakdown"]
[null,null,null,null,null,"Representations received","Means\nMerits\nMerits and means","No further breakdown"]
[null,"2010-11 onwards","1 to 4",null,"Civil Representation appeals","Family","Combined family proceedings\nDomestic violence\nFinancial provision\nHelp with Mediation\nOther family proceedings\nOther public law Children Act proceedings\nPrivate law Children Act proceedings\nSpecial Children Act proceedings","Financial\n\n\n\n\n\n\n\n\n\n\nLegal","Granted\n\n\n\n\n\n\n\n\n\n\nNot granted"]
[null,null,null,null,null,"Non-Family","Actions against the police etc.\nClinical negligence\nCommunity care\nConsumer\nDebt\nDiscrimination\nEducation\nEmployment\nHousing\nImmigration\nMental health\nMiscellaneous\nPersonal injury\nPublic law\nWelfare benefits"]
[]
[null,"fin_qtr: Financial quarters available from 2010-11 for civil representation appeals only",null,"Civil Representation Appeals: \nThese are appeals against legal aid determinationss, specifically within civil representation. ",null,"category & sub_cat1 (Civil Representation Appeals): \nThe civil representation work being appealed can be split by family and non-family types with a further breakdown to the full category of law; which is a thematic definition of areas of law",null,"sub_cat2 (Civil Representation Appeals): Appeals against civil representation decisions may be made on either financial means or legal merits grounds.\n",null,"sub_cat3 (Civil Representation Appeals): Civil representation appeals may either be granted or not granted."]
[]
["Exceptional Case Funding: This scheme was introduced in April 2013 for clients whose case falls outside the scope of legal aid, but failure to grant funding could breach their human rights or EU legal rights. The same means and merits criteria apply as for legal aid, but there is an additional ECF merits criteria to be met."]
[null,null,null,null,null,null,null,null,null,null,"return to top of page"]
[null,null,"category: Whether the case is a new application or a request for the review of a previous determination.\n",null,null,null,"sub_cat3: \nWhether the application was submitted by an individual or legal aid provider. ",null,"sub_cat4: This is the determination (decision) of the application.  Full definitions of these can be found in the glossary. Awaiting applications are those without a determination by the date the data were extracted."]
[]
[null,"fin_yr","fin_qtr","scheme","category","sub_cat1","sub_cat2","sub_cat3","sub_cat4","sub_cat5","sub_cat6","volume","value"]
[null,"2013-14 \nonwards","1 to 4","Exceptional Case Funding","New\n\n\n\n\n\n\n\n\n\nReview","Family","Family","Individual\n","Awaiting","Awaiting","No further breakdown",null,"In £'s"]
[null,null,null,null,null,null,null,null,"Positive Preliminary view","Granted"]
[null,null,null,null,null,null,null,null,"Refused","ECF Merits\nMeans\nMeans & ECF Merits\nMeans & Merits (both)\nMeans & Normal Merits\nNormal & ECF Merits\nNormal Merits"]
[null,null,null,null,null,"Non-family","Debt/Consumer/Contract\n\nDiscrimination\n\nEducation\n\nHousing/Land Law\n\nImmigration\n\nInquest\n\nInquiry/Tribunal\n\nOther\n\nPI/Clinical Negligence\n\nWelfare Benefits",null,"Rejected\n","In Scope\nIncomplete application\nOther"]
[null,null,null,null,null,null,null,null,"Withdrawn",".."]
[null,null,null,null,null,null,null,"Provider","Awaiting","Awaiting"]
[null,null,null,null,null,null,null,null,"Granted","Granted"]
[null,null,null,null,null,null,null,null,"Refused","ECF Merits\nMeans\nMeans & ECF Merits\nMeans & Merits (both)\nMeans & Normal Merits\nNormal & ECF Merits\nNormal Merits"]
[null,null,null,null,null,null,null,null,"Rejected\n","In Scope\nIncomplete application\nOther"]
[null,null,null,null,null,null,null,null,"Withdrawn","No further breakdown"]
[]
[null,null,null,null,null,"sub_cat1&2: ECF can be split by family and non-family types with a further breakdown to the full category of law; which is a thematic definition of areas of law",null,"sub_cat5: Reason for refusal/rejection.  This category should be used with caution, particularly for refusal, as there can be more than one reason.   For example if a case is refused for normal merits, this does not mean that it could not have also been refused on ECF merits. "]
[]
["Client diversity CSV: This is an annually released CSV which provides information on the protected characteristics of individuals who granted or received legal aid in the given financial year, dependent on the area of legal aid."]
[null,null,null,null,null,null,null,null,null,null,null,"return to top of page"]
[null,null,null,null,"Crime Lower, all categories: \ngender, disability and ethnicity data are extracted from a separate system to the age data and, as such, cannot be linked across. Data in the other categories will appear as \"not available\".",null,null,"Age_banded - \"unknown\": \nThis includes a number of instances in legal help where default DOB 1/1/1900 and 1/1/1901 were being incorrectly used to calculate the client age"]
[]
[null,"fin_yr","fin_qtr","scheme","gender","disability","ethnicity","age_banded","volume"]
[null,"2013-14 and \n2014-15","1 to 4","Civil representation","Female\nMale\nUnknown","Yes\nNo\nUnknown","Asian or Asian British Bangladeshi\nAsian or Asian British Indian\nAsian or Asian British Other\nAsian or Asian British Pakistani\nBlack or Black British African\nBlack or Black British Caribbean\nBlack or Black British Other\nChinese\nGypsy/Traveller\nMixed Other\nMixed White & Asian\nMixed White & Black African\nMixed White & Black African or Caribbean\nMixed White & Black Caribbean\nNot available\nOther\nUnknown\nWhite British\nWhite Irish\nWhite Other","18 and under\n\n19-25\n\n26-35\n\n36-45\n\n46-55\n\n56-65\n\nover 65\n\nUnknown"]
[null,null,null,"Crime higher","Female\nMale\nUnknown","Yes\nNo\nUnknown"]
[null,null,null,"Crime lower","Female \nMale\nNot available\nUnknown","Yes\nNo\nNot available\nUnknown"]
[null,null,null,"Legal help","Female\nMale\nUnknown","Yes\nNo\nUnknown"]
[null,null,null,"Mediation","Female\nMale\nUnknown","Not available",null,"Not available"]
[]
[]
[null,null,null,null,"Mediation, disability and age: \nDisability information is not currently available for mediation but with the new computer system in place from February 2015 this will be available in the future. Similarly, age data before was not comparable but will be comparable in the future.",null,null,"Age_banded:\nWhere possible this has been calculated using client DOB \nand the start date.","Volume:\nVolumes under 5 have been suppressed and replaced with :c to prevent client disclosure. The volumes relate just to those individuals who received legal aid, not all those who applied."]
[]
["Geographic CSV with Provider breakdown: Care should be taken when using the CSV on provider data as figures showing the number providers in each category or area of work will require the list of provider offices to be unique. Many offices cover work in multiple areas and in some instances should only be counted once."]
[null,null,null,null,null,null,null,null,null,null,"return to top of page"]
[null,null,"scheme: \nthe scheme covered\n",null,null,"type: \nEach scheme has one level of category provided for further detail of the work type involved",null,null,"Region and Sub_region: Each of the 12 regions covered by LAA and with a further breakdown from region to one of 135 sub-regions similar to local authority"]
[]
[null,"fin_yr","fin_qtr","title","scheme","Providercode","Type","Region","Sub_Region","ProviderType","ProviderArea","volume","value"]
[null,"2012-13\nonwards","1 to 4","Legal Aid Provider Statistics","Advocate Graduated Fee\n\nCivil Representation\n\nCrime Lower\n\nCrown High Cost Cases\n\nLegal Help\n\nLitigator Graduated Fee\n\nMediation","Provider code number\n\n10001 start number reference","e.g.\nHousing\nFinancial provision\nClinical negligence\nActions against the police etc.\n\nAll Issues Sole Mediation\nChild Sole Mediation\n\nPolice station: telephone advice\nPolice station: attendance\n\nCracked Trial\nGuilty Plea\n","East Midlands\n\nEastern\n\nLondon\n\nMerseyside\n\nNorth East\n\nNorth West\n\nSouth\n\nSouth East\n\nSouth West\n\nWales\n\nWest Midlands\n\nYorkshire and Humberside","Newham\n\nIslington\n\nEaling\n\nHackney & City of London\n\nCamden\n","Not for profit\n\n\n\n\nFor profit","Advocate\n\n\n\n\nLitigator",null,"In £'s"]
[]
[]
[]
[null,null,null,null,null,"provider code: \nan anonymous provider code for the 12,000 unique providers in 12-13 to 14-15",null,"Provider Information:\n Information about the type of provider if a not for profit organisation or solicitor firm, or an advocate or litigator code type"]

{"sheet":"PivotTable Help","index":1,"n_rows":29,"n_cols":23,"rows_kept":29,"cut":false,"hidden":false,"merged":[[30,10,30,15],[2,15,2,18],[28,12,28,15],[2,5,2,9],[1,20,1,22]]}
["PivotTables: For ease a PivotTable has been created to analyse and sum up the data. This table creates an interactive summary that can be manipulated based on the information that is required."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"return to Guide tables"]
[null,null,null,null,null,"PivotTable tab: You can access specific functionality related to the PivotTable you are working on while you are working on it by clicking on the tab. This goes away to display your original tab once you are done.",null,null,null,null,null,null,null,null,null,"PivotTable fields pane: Use the PivotTable fields pane to include or exclude fields from your PivotTable by selecting or clearing the box(es) next to the field name(s)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Scheme filters: Use the filter button to open up a drop down menu allowing you to select areas you are interested in",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Report filter: can be used to identify specific data. Drag the field(s) into the area filter. These are then shown above the PivotTables."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Column area fields: appear along the top of PivotTables"]
[]
[]
[null,"You can expand and collapse the row fields by selecting the box next to the field name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Row area fields: are shown along the left side of a PivotTable."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Value area fields: These appear as summarised values inside the PivotTable. Click on the triangle to access the Value Field Settings where you can select the type of calculation used to summarise your data."]