{"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":11,"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":147,"n_cols":13,"rows_kept":147,"cut":false,"hidden":false,"merged":[[105,12,115,12],[6,10,6,12],[36,10,36,12],[63,10,63,12],[73,10,73,12],[89,10,89,12],[101,10,101,12],[120,10,120,12],[100,0,100,13],[119,0,119,13],[106,4,108,4],[106,7,108,8],[109,4,115,4],[109,5,111,5],[109,6,111,6],[112,5,113,5],[112,6,113,6],[114,5,115,5],[77,11,84,11],[37,1,37,3],[93,1,96,1],[102,4,102,5],[105,10,115,10],[105,9,108,9],[5,0,5,13],[35,0,35,13],[72,0,72,13],[88,0,88,13],[93,8,94,10],[90,5,90,6],[90,9,90,10],[90,7,90,8],[7,5,7,6],[40,1,58,1],[40,2,58,2],[40,3,58,3],[60,2,60,3],[93,11,96,11],[93,12,96,12],[95,4,96,4],[95,7,96,7],[95,8,96,8],[95,9,96,9],[95,10,96,10],[93,2,96,2],[93,3,96,3],[93,4,94,4],[90,1,90,3],[135,12,144,12],[140,7,144,7],[128,3,128,4],[121,2,121,4],[121,7,121,8],[128,5,128,6],[128,8,128,9],[124,2,126,2],[124,3,126,3],[124,7,124,8],[124,9,126,10],[130,0,130,13],[131,10,131,12],[124,11,126,11],[124,12,126,12],[135,1,144,1],[135,2,144,2],[135,3,144,3],[135,7,139,7],[135,4,144,4],[138,6,144,6],[138,5,144,5],[135,5,137,5],[124,1,126,1],[98,5,98,7],[86,3,86,4],[135,10,144,10],[135,6,137,6],[128,1,128,2],[117,1,117,4],[117,5,117,6],[125,4,126,4],[125,7,126,7],[125,8,126,8],[105,1,115,1],[105,2,115,2],[105,3,115,3],[105,6,105,8],[86,1,86,2],[98,9,98,11],[135,11,144,11],[105,11,115,11],[102,8,102,9],[86,6,86,7],[109,9,115,9],[0,0,0,13],[10,1,31,1],[10,2,31,2],[10,3,31,3],[47,4,52,4],[47,7,58,7],[53,4,58,4],[77,12,84,12],[79,4,80,4],[79,7,80,7],[79,8,80,8],[81,4,82,4],[81,6,82,8],[43,6,45,6],[40,8,58,10],[83,7,84,7],[83,8,84,8],[77,1,84,1],[77,2,84,2],[77,3,84,3],[77,4,78,4],[77,7,78,7],[1,0,1,13],[2,5,2,13],[146,5,146,6],[132,2,132,3],[132,8,132,9],[146,7,146,8],[62,0,62,13],[64,3,64,4],[64,5,64,6],[64,7,64,8],[67,1,68,1],[67,2,68,2],[67,3,68,3],[67,4,68,4],[67,7,68,10],[67,11,68,11],[67,12,68,12],[70,3,70,4],[114,6,115,6],[117,8,117,9],[93,7,94,7],[70,7,70,8],[86,10,86,11],[102,6,102,7],[102,1,102,3],[98,2,98,4],[10,11,31,11],[74,5,74,6],[77,8,78,8],[77,9,84,10],[60,4,60,5],[83,4,84,4],[10,12,31,12],[23,4,25,4],[26,4,29,4],[30,4,31,4],[40,4,44,4],[40,5,42,5],[10,4,22,4],[10,7,31,10],[40,11,58,11],[40,12,58,12],[43,7,46,7],[74,8,74,9],[74,3,74,4],[70,5,70,6]]}
["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\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, APP = appeals, ECF = expectional case funding, CL = crime lower and CH = crime higher\n\nEach area has a monetary or time based 'value' field with one exception 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.\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","\n\n\n\n\n\nNo 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)"]
[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"]
[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"]
[null,null,null,null,"Representation at magistrates' court","Court duty solicitor (sessions)","Court duty solicitor (sessions)"]
[null,null,null,null,null,"Representation order required","Higher standard fees\nLower standard fees\nNon-standard fees and exempt cases\nSecond claims for deferred sentencing"]
[]
[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","Proceeds of crime and escapes from GFS"]
[null,null,null,null,"Higher Courts","Court of appeal and supreme court","N/A\nCourt of Appeal\nSenior Court costs office\nSupreme Court"]
[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","1 to 4","Crime Apps and Grants","Applications\n\n\n\nGrants","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,"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 also for partial agreement, whether this 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,"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: Providers who are unhappy with decisions in relation to their contract can ask for an internal review and/or for the matter to be referred to the Contract Review Body. If they are still unhappy their ultimate remedy is to go to arbitration."]
[null,null,null,null,null,null,null,null,null,null,"return to top of page"]
[null,null,"Appeals against representation provided: Upon granting public funding, opponents or third parties may appeal against the grant or continuation of funding.  ",null,null,"sub_cat1 (Appeals against representation provided): Describes the outcome of the investigation for appeals against representation provided.",null,"sub_cat2 (Appeals against representation provided): For appeals against representation, appeals can be made concerning the legal merits of the case, the financial means of the applicant or both. For civil representation appeals, it refers to the category of law the case falls into."]
[]
[null,"fin_yr","fin_qtr","scheme","category","sub_cat1","sub_cat2","sub_cat3","sub_cat4","sub_cat5","sub_cat6","volume","value"]
[null,"2005-06\nonwards","1 to 4","Appeals","Appeals against representation provided\n","Application refused\nCertificate amended\nCertificate discharged\nCertificate revoked\nNo change\nNumber received","Means\n\nMerits\n\nMerits and means","No further breakdown",null,"No further breakdown",null,null,"In £'s"]
[null,null,null,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 only available from 2010-11",null,"Civil Representation Appeals: These are appeals against legal aid decisions, specifically within civil representation. ",null,"sub_cat1&2 (Civil Representation Appeals): The 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_cat3 (Civil Representation Appeals): Appeals against civil representation decisions may be made on either financial means or legal merits grounds.\n","sub_cat4 (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. "]

{"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."]