{"text_format":"1","workbook":"xlsx","n_sheets":39,"sheets":["Contents","About this data book","Figure 1","Figure 2","Figure 3","Figure 4","Figure 5","Figure 6","Figure 7","Figure 8","Figure 9","Figure 10","Figure 11","Figure 12","Figure 13","Figure 14","Figure 15","Figure 16","Figure 17","Figure 18","Figure 19","Figure 20","Figure 21","Figure 22","Figure 23","Figure 24","Figure 25","Figure 26","Figure 27","Figure 28","Figure 29","Figure 30","Figure 31","Figure 32","Figure 33","Figure 34","Figure 35","Figure 36","Figure 37"],"not_rendered":{"charts":0,"images":1,"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":"Contents","index":0,"n_rows":47,"n_cols":1,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
["Table of Contents"]
[]
["About this data book"]
["Figure 1. Year of origination, closed books and active books"]
["Figure 2. Proportion of mortgages with a current payment shortfall (any amount), closed books and active books "]
["Figure 3. Proportion of mortgages with current arrears (shortfall of two months’ payments or more), closed books and active books"]
["Figure 4. Proportion of mortgages by current interest rate, closed books and active books"]
["Figure 5. Closed book mortgages by interest rate – distribution across interest rate bands of mortgages with and without a current payment shortfall (of any amount) "]
["Figure 6. Closed book mortgages by interest rate – proportion of mortgages with and without a current payment shortfall (of any amount) in each interest rate band "]
["Figure 7. Median interest rates, closed books and active books, for mortgages with and without a current payment shortfall (of any amount) "]
["Figure 8. Proportion of mortgages on different interest rate types, closed books and active books"]
["Figure 9. Difference between current and initial interest rate, by proportion of closed book mortgages  "]
["Figure 10. Proportion of mortgages by repayment type, closed books and active books"]
["Figure 11. Proportion of closed book mortgages by repayment type by age of main borrower"]
["Figure 12. Proportion of closed book mortgages by repayment type and current payment shortfall (of any amount)"]
["Figure 13. Proportion of closed book mortgages by repayment type and current mortgage arrears (shortfall of two months’ payments or more)"]
["Figure 14. Proportion of interest-only mortgages past maturity, by time past maturity, closed books and active books"]
["Figure 15. Proportion of interest-only mortgages past maturity with a current payment shortfall (of any amount), by time past maturity, closed books and active books"]
["Figure 16. Proportion of interest-only mortgages past maturity with current mortgage arrears (shortfall of two months’ payments or more), by time past maturity, closed books and active books"]
["Figure 17. Proportion of mortgages by age of main borrower, closed books and active books"]
["Figure 18. Proportion of mortgages by current outstanding balance, closed books and active books"]
["Figure 19. Proportion of mortgages by current remaining term, closed books and active books"]
["Figure 20. Proportion of mortgages by LTV band, closed books and active books"]
["Figure 21. Proportion of mortgages in closed books with a current payment shortfall (of any amount), by LTV band"]
["Figure 22. Proportion of mortgages in closed books with current mortgage arrears (shortfall of two months’ payments or more), by LTV band"]
["Figure 23. Proportion of mortgages in closed books by repayment type and LTV band"]
["Figure 24. Proportion of mortgages by region, closed books and active books"]
["Figure 25. Proportion of mortgages by region and LTV band, closed books and active books"]
["Figure 26. Proportion of mortgages by region with a current payment shortfall (of any amount), closed books and active books"]
["Figure 27. Proportion of mortgages by region with current mortgage arrears (shortfall of two months’ or more), closed books and active books"]
["Figure 28. Proportion of mortgages by region and repayment type, closed books and active books"]
["Figure 29. Proportion of mortgages by region and current outstanding balance, closed books and active books"]
["Figure 30. Proportion of mortgages where income was not verified at origination, closed books and active books"]
["Figure 31. Proportion of mortgages advanced to consumers with an impaired credit status, closed books and active books"]
["Figure 32. Proportion of mortgages where the borrower was reported as being self-employed, closed books and active books"]
["Figure 33. Proportion of mortgages advanced for properties purchased under the Right to Buy scheme, closed books and active books"]
["Figure 34. Proportion of mortgages where income was not verified at origination, by repayment type, closed books and active books"]
["Figure 35. Proportion of mortgages advanced to consumers with an impaired credit status, by repayment type, closed books and active books"]
["Figure 36. Proportion of mortgages where the borrower was reported as being self-employed, by repayment type, closed books and active books"]
["Figure 37. Proportion of mortgages advanced for properties purchased under the Right to Buy scheme, by repayment type, closed books and active books"]

{"sheet":"About this data book","index":1,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["1. This data book contains the underlying data, i.e. numbers and proportions of mortgages, used in Annex 1 \"Summary of the characteristics of the population of closed book mortgages with inactive firms\"."]
["2. We explain our data and methodology in Section G of Annex 1: \"Technical note on data and methodology\". "]
["3. The figures in this data book are rounded. Therefore they do not always add up to the totals shown. Notably:\n- where the numbers of mortgages were estimated, they were rounded to the nearest integer; and\n- the proportions were rounded to one decimal point."]
["4. Data was extracted from our live data systems in the seven days commencing 23 October, except figures 26 to 29 which were extracted in the seven days commencing 6 November."]

{"sheet":"Figure 1","index":2,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Figure 1. Year of origination, closed books and active books"]
[]
["Number of Mortgages"]
["Year of Origination","Closed books","Active books","Grand Total"]
["2004 or earlier",13645,285525,299170]
[2005,28647,218816,247463]
[2006,61509,315564,377073]
[2007,73035,395236,468271]
[2008,12067,352131,364198]
[2009,1493,202278,203771]
[2010,231,203679,203910]
[2011,57,237741,237798]
[2012,86,257539,257625]
[2013,83,310976,311059]
[2014,66,364496,364562]
[2015,70,423232,423302]
[2016,164,551086,551250]
[2017,493,719420,719913]
[2018,1458,888590,890048]
[2019,1042,1027004,1028046]
[2020,142,949069,949211]
[2021,346,619180,619526]
["Not Known",null,2741,2741]
["Grand Total",194634,8324303,8518937]
[]
["Proportion of Mortgages"]
["Year of Origination","Closed books","Active books","Grand Total"]
["2004 or earlier",7.0000000000000007E-2,3.4000000000000002E-2,3.5000000000000003E-2]
[2005,0.14699999999999999,2.5999999999999999E-2,2.9000000000000001E-2]
[2006,0.316,3.7999999999999999E-2,4.3999999999999997E-2]
[2007,0.375,4.7E-2,5.5E-2]
[2008,6.2E-2,4.2000000000000003E-2,4.2999999999999997E-2]
[2009,8.0000000000000002E-3,2.4E-2,2.4E-2]
[2010,1E-3,2.4E-2,2.4E-2]
[2011,0,2.9000000000000001E-2,2.8000000000000001E-2]
[2012,0,3.1E-2,0.03]
[2013,0,3.6999999999999998E-2,3.6999999999999998E-2]
[2014,0,4.3999999999999997E-2,4.2999999999999997E-2]
[2015,0,5.0999999999999997E-2,0.05]
[2016,1E-3,6.6000000000000003E-2,6.5000000000000002E-2]
[2017,3.0000000000000001E-3,8.5999999999999993E-2,8.5000000000000006E-2]
[2018,7.0000000000000001E-3,0.107,0.104]
[2019,5.0000000000000001E-3,0.123,0.121]
[2020,1E-3,0.114,0.111]
[2021,2E-3,7.3999999999999996E-2,7.2999999999999995E-2]
["Not Known",null,0,0]
["Grand Total",1,1,1]

{"sheet":"Figure 2","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Figure 2. Proportion of mortgages with a current payment shortfall (any amount), closed books and active books "]
[]
["Number of Mortgages"]
["Payment Shortfall","Closed books","Active books","Grand Total"]
["Payment shortfall (of any amount)",33462,178288,211750]
["No payment shortfall",161172,8146015,8307187]
["Grand Total",194634,8324303,8518937]
[]
["Proportion of Mortgages"]
["Payment Shortfall","Closed books","Active books","Grand Total"]
["Payment shortfall (of any amount)",0.17199999999999999,2.1000000000000001E-2,2.5000000000000001E-2]
["No payment shortfall",0.82799999999999996,0.97899999999999998,0.97499999999999998]
["Grand Total",1,1,1]

{"sheet":"Figure 3","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Figure 3. Proportion of mortgages with current arrears (shortfall of two months’ payments or more), closed books and active books"]
[]
["Number of Mortgages"]
["Arrears","Closed books","Active books","Grand Total"]
["Arrears (of two months' payments or more)",18258,78799,97057]
["Other mortgages",176376,8245504,8421880]
["Grand Total",194634,8324303,8518937]
[]
["Proportion of Mortgages"]
["Arrears","Closed books","Active books","Grand Total"]
["Arrears (of two months' payments or more)",9.4E-2,8.9999999999999993E-3,1.0999999999999999E-2]
["Other mortgages",0.90600000000000003,0.99099999999999999,0.98899999999999999]
["Grand Total",1,1,1]

{"sheet":"Figure 4","index":5,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Figure 4. Proportion of mortgages by current interest rate, closed books and active books"]
[]
["Number of Mortgages"]
["Interest Rate Band (%)","Closed books","Active books","Grand Total"]
["<=1",10011,302232,312243]
[">1 - <=2",12380,3532437,3544817]
[">2 - <=3",74895,2989329,3064224]
[">3 - <=3.5",14007,394447,408454]
[">3.5 - <=4",8764,651119,659883]
[">4 - <=4.5",66746,297177,363923]
[">4.5 - <=5",1436,91706,93142]
[">5 - <=5.5",3046,38597,41643]
[">5.5 - <=6",588,10625,11213]
[">6 - <=6.5",607,5005,5612]
[">6.5 - <=7",1147,4282,5429]
[">7",1007,7347,8354]
["Grand Total",194634,8324303,8518937]
[]
["Proportion of Mortgages"]
["Interest Rate Band (%)","Closed books","Active books","Grand Total"]
["<=1",5.0999999999999997E-2,3.5999999999999997E-2,3.6999999999999998E-2]
[">1 - <=2",6.4000000000000001E-2,0.42399999999999999,0.41599999999999998]
[">2 - <=3",0.38500000000000001,0.35899999999999999,0.36]
[">3 - <=3.5",7.1999999999999995E-2,4.7E-2,4.8000000000000001E-2]
[">3.5 - <=4",4.4999999999999998E-2,7.8E-2,7.6999999999999999E-2]
[">4 - <=4.5",0.34300000000000003,3.5999999999999997E-2,4.2999999999999997E-2]
[">4.5 - <=5",7.0000000000000001E-3,1.0999999999999999E-2,1.0999999999999999E-2]
[">5 - <=5.5",1.6E-2,5.0000000000000001E-3,5.0000000000000001E-3]
[">5.5 - <=6",3.0000000000000001E-3,1E-3,1E-3]
[">6 - <=6.5",3.0000000000000001E-3,1E-3,1E-3]
[">6.5 - <=7",6.0000000000000001E-3,1E-3,1E-3]
[">7",5.0000000000000001E-3,1E-3,1E-3]
["Grand Total",1,1,1]

{"sheet":"Figure 5","index":6,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Figure 5. Closed book mortgages by interest rate – distribution across interest rate bands of mortgages with and without a current payment shortfall (of any amount) "]
[]
["Number of Mortgages"]
["Interest Rate Band (%)","Payment shortfall (of any amount)","No payment shortfall","Grand Total"]
[">=0 - <=1",492,9519,10011]
[">1 - <=2",1839,10541,12380]
[">2 - <=3",12676,62219,74895]
[">3 - <=3.5",3974,10033,14007]
[">3.5 - <=4",2757,6007,8764]
[">4 - <=4.5",10379,56367,66746]
[">4.5 - <=5",444,992,1436]
[">5 - <=5.5",558,2488,3046]
[">5.5 - <=6",96,492,588]
[">6 - <=6.5",63,544,607]
[">6.5 - <=7",23,1124,1147]
[">7",161,846,1007]
["Grand Total",33462,161172,194634]
[]
["Proportion of Mortgages"]
["Interest Rate Band (%)","Payment shortfall (of any amount)","No payment shortfall","Grand Total"]
[">=0 - <=1",1.4999999999999999E-2,5.8999999999999997E-2,5.0999999999999997E-2]
[">1 - <=2",5.5E-2,6.5000000000000002E-2,6.4000000000000001E-2]
[">2 - <=3",0.379,0.38600000000000001,0.38500000000000001]
[">3 - <=3.5",0.11899999999999999,6.2E-2,7.1999999999999995E-2]
[">3.5 - <=4",8.2000000000000003E-2,3.6999999999999998E-2,4.4999999999999998E-2]
[">4 - <=4.5",0.31,0.35,0.34300000000000003]
[">4.5 - <=5",1.2999999999999999E-2,6.0000000000000001E-3,7.0000000000000001E-3]
[">5 - <=5.5",1.7000000000000001E-2,1.4999999999999999E-2,1.6E-2]
[">5.5 - <=6",3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3]
[">6 - <=6.5",2E-3,3.0000000000000001E-3,3.0000000000000001E-3]
[">6.5 - <=7",1E-3,7.0000000000000001E-3,6.0000000000000001E-3]
[">7",5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3]
["Grand Total",1,1,1]

{"sheet":"Figure 6","index":7,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Figure 6. Closed book mortgages by interest rate – proportion of mortgages with and without a current payment shortfall (of any amount) in each interest rate band "]
[]
["Number of Mortgages"]
["Interest Rate Band (%)","Payment shortfall (of any amount)","No payment shortfall","Grand Total"]
[">=0 - <=1",492,9519,10011]
[">1 - <=2",1839,10541,12380]
[">2 - <=3",12676,62219,74895]
[">3 - <=3.5",3974,10033,14007]
[">3.5 - <=4",2757,6007,8764]
[">4 - <=4.5",10379,56367,66746]
[">4.5 - <=5",444,992,1436]
[">5 - <=5.5",558,2488,3046]
[">5.5 - <=6",96,492,588]
[">6 - <=6.5",63,544,607]
[">6.5 - <=7",23,1124,1147]
[">7",161,846,1007]
["Grand Total",33462,161172,194634]
[]
["Proportion of Mortgages"]
["Interest Rate Band (%)","Payment shortfall (of any amount)","No payment shortfall","Grand Total"]
[">=0 - <=1",4.9000000000000002E-2,0.95099999999999996,1]
[">1 - <=2",0.14899999999999999,0.85099999999999998,1]
[">2 - <=3",0.16900000000000001,0.83099999999999996,1]
[">3 - <=3.5",0.28399999999999997,0.71599999999999997,1]
[">3.5 - <=4",0.315,0.68500000000000005,1]
[">4 - <=4.5",0.155,0.84499999999999997,1]
[">4.5 - <=5",0.309,0.69099999999999995,1]
[">5 - <=5.5",0.183,0.81699999999999995,1]
[">5.5 - <=6",0.16300000000000001,0.83699999999999997,1]
[">6 - <=6.5",0.104,0.89600000000000002,1]
[">6.5 - <=7",0.02,0.98,1]
[">7",0.16,0.84,1]
["Grand Total",0.17199999999999999,0.82799999999999996,1]

{"sheet":"Figure 7","index":8,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Figure 7. Median interest rates, closed books and active books, for mortgages with and without a current payment shortfall (of any amount) "]
[]
["Book Type","Payment shortfall (of any amount)","No payment shortfall","Grand Total"]
["Closed books",3.2000000000000001E-2,2.9000000000000001E-2,0.03]
["Active books",2.9000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2]
["Grand Total",0.03,2.1000000000000001E-2,2.1000000000000001E-2]

{"sheet":"Figure 8","index":9,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Figure 8. Proportion of mortgages on different interest rate types, closed books and active books"]
[]
["Number of Mortgages"]
["Interest Rate Type ","Closed books","Active books","Grand Total"]
["Fixed Rate",5204,6104065,6109269]
["Standard Variable Rate",70506,1095341,1165847]
["BoE Base Rate Tracker",58193,796528,854721]
["LIBOR Tracker",52967,19444,72411]
["Other Tracker",5,31369,31374]
["Capped Rate",215,788,1003]
["Discounted Variable Rate",957,67372,68329]
["Other",6587,209396,215983]
["Total",194634,8324303,8518937]
[]
["Proportion of Mortgages"]
["Interest Rate Type ","Closed books","Active books","Grand Total"]
["Fixed Rate",2.7E-2,0.73299999999999998,0.71699999999999997]
["Standard Variable Rate",0.36199999999999999,0.13200000000000001,0.13700000000000001]
["BoE Base Rate Tracker",0.29899999999999999,9.6000000000000002E-2,0.1]
["LIBOR Tracker",0.27200000000000002,2E-3,8.9999999999999993E-3]
["Other Tracker",0,4.0000000000000001E-3,4.0000000000000001E-3]
["Capped Rate",1E-3,0,0]
["Discounted Variable Rate",5.0000000000000001E-3,8.0000000000000002E-3,8.0000000000000002E-3]
["Other",3.4000000000000002E-2,2.5000000000000001E-2,2.5000000000000001E-2]
["Total",1,1,1]

{"sheet":"Figure 9","index":10,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,0,14,0]]}
["Figure 9. Difference between current and initial interest rate, by proportion of closed book mortgages  "]
[]
[null,"Difference between current and initial interest rate","Number of Mortgages (estimated)","Proportion of Mortgages (estimated)"]
["Current rate higher than or equal to initial rate",">=0%",6066.990117099911,4.9456462062149993E-2]
["Current rate lower than initial rate","-0.5% - <0%",2166.0124574370907,1.765674755682442E-2]
[null,"-1.0% - <-0.5%",9039.8691553857698,7.3690567695179537E-2]
[null,"-1.5% - <-1.0%",10564.69882069596,8.6120566597123083E-2]
[null,"-2.0% - <-1.5%",23783.032306286863,0.1938728450642363]
[null,"-2.5% - <-2.0%",8342.1114110123781,6.8002635335456238E-2]
[null,"-3.0% - <-2.5%",6996.4357611494088,5.7033051498847034E-2]
[null,"-3.5% - <-3.0%",16005.323395066862,0.13047106621280333]
[null,"-4.0% - <-3.5%",20546.136824184046,0.16748654880860875]
[null,"-4.5% - <-4.0%",11158.735819284117,9.0962995497968588E-2]
[null,"-5.0% - <-4.5%",4563.7128145502884,3.7202152190622596E-2]
[null,"<-5.0%",3440.2959056556779,2.804436148018008E-2]
[null,"Grand Total",122673.35478780838,1]
[]
["Note 1: a positive or zero value (>=0%) represents cases where the current rate is higher than or equal to the initial rate. Negative values (remaining values) represent cases where the current rate is lower than the initial rate."]
["Note 2: data excludes an estimated 71,961 mortgages where no data for initial rate of interest is available."]

{"sheet":"Figure 10","index":11,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Figure 10. Proportion of mortgages by repayment type, closed books and active books"]
[]
["Number of Mortgages"]
["Repayment Type ","Closed books","Active books","Grand Total"]
["Capital and Interest",88099,7285737,7373836]
["Interest-Only",104079,764569,868648]
["Mix of Capital and Interest, and Interest-Only",2456,273997,276453]
["Grand Total",194634,8324303,8518937]
[]
["Proportion of Mortgages"]
["Repayment Type ","Closed books","Active books","Grand Total"]
["Capital and Interest",0.45300000000000001,0.875,0.86599999999999999]
["Interest-Only",0.53500000000000003,9.1999999999999998E-2,0.10199999999999999]
["Mix of Capital and Interest, and Interest-Only",1.2999999999999999E-2,3.3000000000000002E-2,3.2000000000000001E-2]
["Grand Total",1,1,1]

{"sheet":"Figure 11","index":12,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,1,3,3],[20,1,20,3]]}
["Figure 11. Proportion of closed book mortgages by repayment type by age of main borrower"]
[]
["Number of Mortgages"]
[null,"Repayment Type"]
["Age of Main Borrower","Capital and Interest","Interest-Only","Mix of Capital and Interest, and Interest-Only","Grand Total"]
["18 - 25",26,null,null,26]
["26 - 30",154,null,null,154]
["31 - 35",1322,908,8,2238]
["36 - 40",10546,8633,83,19262]
["41 - 45",14854,14926,188,29968]
["46 - 50",16710,18886,371,35967]
["51 - 55",17321,20759,529,38609]
["56 - 60",14123,18120,566,32809]
["61 - 65",7988,11573,404,19965]
["66 - 70",2902,4828,204,7934]
["71 - 75",1127,2407,81,3615]
["76+",1026,3039,22,4087]
["Grand Total",88099,104079,2456,194634]
[]
["Proportion of Mortgages"]
[null,"Repayment Type"]
["Age of Main Borrower","Capital and Interest","Interest-Only","Mix of Capital and Interest, and Interest-Only","Grand Total"]
["18 - 25",1,null,null,1]
["26 - 30",1,null,null,1]
["31 - 35",0.59099999999999997,0.40600000000000003,4.0000000000000001E-3,1]
["36 - 40",0.54800000000000004,0.44800000000000001,4.0000000000000001E-3,1]
["41 - 45",0.496,0.498,6.0000000000000001E-3,1]
["46 - 50",0.46500000000000002,0.52500000000000002,0.01,1]
["51 - 55",0.44900000000000001,0.53800000000000003,1.4E-2,1]
["56 - 60",0.43,0.55200000000000005,1.7000000000000001E-2,1]
["61 - 65",0.4,0.57999999999999996,0.02,1]
["66 - 70",0.36599999999999999,0.60899999999999999,2.5999999999999999E-2,1]
["71 - 75",0.312,0.66600000000000004,2.1999999999999999E-2,1]
["76+",0.251,0.74399999999999999,5.0000000000000001E-3,1]

{"sheet":"Figure 12","index":13,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Figure 12. Proportion of closed book mortgages by repayment type and current payment shortfall (of any amount)"]
[]
["Number of Mortgages"]
["Repayment Type","Payment shortfall (of any amount)","No payment shortfall","Grand Total"]
["Capital and Interest",15168,72931,88099]
["Interest-Only",17576,86503,104079]
["Mix of Capital and Interest, and Interest-Only",718,1738,2456]
["Grand Total",33462,161172,194634]
[]
["Proportion of Mortgages"]
["Repayment Type","Payment shortfall (of any amount)","No payment shortfall","Grand Total"]
["Capital and Interest",0.17199999999999999,0.82799999999999996,1]
["Interest-Only",0.16900000000000001,0.83099999999999996,1]
["Mix of Capital and Interest, and Interest-Only",0.29199999999999998,0.70799999999999996,1]
["Grand Total",0.17199999999999999,0.82799999999999996,1]

{"sheet":"Figure 13","index":14,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Figure 13. Proportion of closed book mortgages by repayment type and current mortgage arrears (shortfall of two months’ payments or more)"]
[]
["Number of Mortgages"]
["Repayment Type","Arrears (of two months' payments or more)","Other mortgages","Grand Total"]
["Capital and Interest",7823,80276,88099]
["Interest-Only",10020,94059,104079]
["Mix of Capital and Interest, and Interest-Only",415,2041,2456]
["Grand Total",18258,176376,194634]
[]
["Proportion of Mortgages"]
["Repayment Type","Arrears (of two months' payments or more)","Other mortgages","Grand Total"]
["Capital and Interest",8.8999999999999996E-2,0.91100000000000003,1]
["Interest-Only",9.6000000000000002E-2,0.90400000000000003,1]
["Mix of Capital and Interest, and Interest-Only",0.16900000000000001,0.83099999999999996,1]
["Grand Total",9.4E-2,0.90600000000000003,1]

{"sheet":"Figure 14","index":15,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Figure 14. Proportion of interest-only mortgages past maturity, by time past maturity, closed books and active books"]
[]
["Number of Mortgages"]
["Maturity status","Closed books","Active books","Grand Total"]
["<=1y past maturity",1078,7275,8353]
[">1y - <=2y past maturity",444,3657,4101]
[">2y - <=3y past maturity",231,2116,2347]
[">3y - <=5y past maturity",319,2631,2950]
[">5y past maturity",156,5520,5676]
["Total past maturity",2228,21199,23427]
["Not matured",101851,743370,845221]
["Grand Total",104079,764569,868648]
[]
["Proportion of Mortgages"]
["Maturity status","Closed books","Active books","Grand Total"]
["<=1y past maturity",1.04E-2,9.4999999999999998E-3,9.5999999999999992E-3]
[">1y - <=2y past maturity",4.3E-3,4.7999999999999996E-3,4.7000000000000002E-3]
[">2y - <=3y past maturity",2.2000000000000001E-3,2.8E-3,2.7000000000000001E-3]
[">3y - <=5y past maturity",3.0999999999999999E-3,3.3999999999999998E-3,3.3999999999999998E-3]
[">5y past maturity",1.5E-3,7.1999999999999998E-3,6.4999999999999997E-3]
["Total past maturity",2.1399999999999999E-2,2.7699999999999999E-2,2.7E-2]
["Not matured",0.97860000000000003,0.97230000000000005,0.97299999999999998]
["Grand Total",1,1,1]

{"sheet":"Figure 15","index":16,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,1,3,3],[3,4,3,6],[15,1,15,3],[15,4,15,6]]}
["Figure 15. Proportion of interest-only mortgages past maturity with a current payment shortfall (of any amount), by time past maturity, closed books and active books"]
[]
["Number of Mortgages"]
[null,"Closed books",null,null,"Active books",null,null,"Grand Total"]
["Past maturity band (years)","Payment shortfall (of any amount)","No payment shortfall","Total","Payment shortfall (of any amount)","No payment shortfall","Total"]
["<=1y past maturity",271,807,1078,1042,6233,7275,8353]
[">1y - <=2y past maturity",117,327,444,582,3075,3657,4101]
[">2y - <=3y past maturity",76,155,231,381,1735,2116,2347]
[">3y - <=5y past maturity",105,214,319,481,2150,2631,2950]
[">5y past maturity",21,135,156,360,5160,5520,5676]
["Total past maturity",590,1638,2228,2846,18353,21199,23427]
["Not matured",16986,84865,101851,30122,713248,743370,845221]
["Grand Total",17576,86503,104079,32968,731601,764569,868648]
[]
["Proportion of Mortgages"]
[null,"Closed books",null,null,"Active books"]
["Past maturity band (years)","Payment shortfall (of any amount)","No payment shortfall","Total","Payment shortfall (of any amount)","No payment shortfall","Total"]
["<=1y past maturity",0.251,0.749,1,0.14299999999999999,0.85699999999999998,1]
[">1y - <=2y past maturity",0.26400000000000001,0.73599999999999999,1,0.159,0.84099999999999997,1]
[">2y - <=3y past maturity",0.32900000000000001,0.67100000000000004,1,0.18,0.82,1]
[">3y - <=5y past maturity",0.32900000000000001,0.67100000000000004,1,0.183,0.81699999999999995,1]
[">5y past maturity",0.13500000000000001,0.86499999999999999,1,6.5000000000000002E-2,0.93500000000000005,1]
["Total past maturity",0.26500000000000001,0.73499999999999999,1,0.13400000000000001,0.86599999999999999,1]
["Not matured",0.16700000000000001,0.83299999999999996,1,4.1000000000000002E-2,0.95899999999999996,1]
["Grand Total",0.16900000000000001,0.83099999999999996,1,4.2999999999999997E-2,0.95699999999999996,1]

{"sheet":"Figure 16","index":17,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,1,3,3],[3,4,3,6],[15,1,15,3],[15,4,15,6]]}
["Figure 16. Proportion of interest-only mortgages past maturity with current mortgage arrears (shortfall of two months’ payments or more), by time past maturity, closed books and active books"]
[]
["Number of Mortgages"]
[null,"Closed books",null,null,"Active books",null,null,"Grand Total"]
["Past maturity band (years)","Arrears (of two months' payments or more)","Other mortgages","Total","Arrears (of two months' payments or more)","Other mortgages","Total"]
["<=1y past maturity",230,848,1078,811,6464,7275,8353]
[">1y - <=2y past maturity",98,346,444,428,3229,3657,4101]
[">2y - <=3y past maturity",66,165,231,310,1806,2116,2347]
[">3y - <=5y past maturity",94,225,319,377,2254,2631,2950]
[">5y past maturity",21,135,156,263,5257,5520,5676]
["Total past maturity",509,1719,2228,2189,19010,21199,23427]
["Not matured",9511,92340,101851,15657,727713,743370,845221]
["Grand Total",10020,94059,104079,17846,746723,764569,868648]
[]
["Proportion of Mortgages"]
[null,"Closed books",null,null,"Active books"]
["Past maturity band (years)","Arrears (of two months' payments or more)","Other mortgages","Total","Arrears (of two months' payments or more)","Other mortgages","Total"]
["<=1y past maturity",0.21299999999999999,0.78700000000000003,1,0.111,0.88900000000000001,1]
[">1y - <=2y past maturity",0.221,0.77900000000000003,1,0.11700000000000001,0.88300000000000001,1]
[">2y - <=3y past maturity",0.28599999999999998,0.71399999999999997,1,0.14699999999999999,0.85299999999999998,1]
[">3y - <=5y past maturity",0.29499999999999998,0.70499999999999996,1,0.14299999999999999,0.85699999999999998,1]
[">5y past maturity",0.13500000000000001,0.86499999999999999,1,4.8000000000000001E-2,0.95199999999999996,1]
["Total past maturity",0.22800000000000001,0.77200000000000002,1,0.10299999999999999,0.89700000000000002,1]
["Not matured",9.2999999999999999E-2,0.90700000000000003,1,2.1000000000000001E-2,0.97899999999999998,1]
["Grand Total",9.6000000000000002E-2,0.90400000000000003,1,2.3E-2,0.97699999999999998,1]

{"sheet":"Figure 17","index":18,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Figure 17. Proportion of mortgages by age of main borrower, closed books and active books"]
[]
["Number of Mortgages"]
["Age Bands","Closed books","Active books","Grand Total"]
["18 - 25",26,148115,148141]
["26 - 30",154,659997,660151]
["31 - 35",2238,1048374,1050612]
["36 - 40",19262,1235366,1254628]
["41 - 45",29968,1261555,1291523]
["46 - 50",35967,1292214,1328181]
["51 - 55",38609,1187339,1225948]
["56 - 60",32809,843682,876491]
["61 - 65",19965,395388,415353]
["66 - 70",7934,134126,142060]
["71 - 75",3615,64224,67839]
["76+",4087,53889,57976]
["Not Known",null,34,34]
["Grand Total",194634,8324303,8518937]
[]
["Proportion of Mortgages"]
["Age Bands","Closed books","Active books","Grand Total"]
["18 - 25",0,1.7999999999999999E-2,1.7000000000000001E-2]
["26 - 30",1E-3,7.9000000000000001E-2,7.6999999999999999E-2]
["31 - 35",1.0999999999999999E-2,0.126,0.123]
["36 - 40",9.9000000000000005E-2,0.14799999999999999,0.14699999999999999]
["41 - 45",0.154,0.152,0.152]
["46 - 50",0.185,0.155,0.156]
["51 - 55",0.19800000000000001,0.14299999999999999,0.14399999999999999]
["56 - 60",0.16900000000000001,0.10100000000000001,0.10299999999999999]
["61 - 65",0.10299999999999999,4.7E-2,4.9000000000000002E-2]
["66 - 70",4.1000000000000002E-2,1.6E-2,1.7000000000000001E-2]
["71 - 75",1.9E-2,8.0000000000000002E-3,8.0000000000000002E-3]
["76+",2.1000000000000001E-2,6.0000000000000001E-3,7.0000000000000001E-3]
["Not Known",null,0,0]
["Grand Total",1,1,1]

{"sheet":"Figure 18","index":19,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Figure 18. Proportion of mortgages by current outstanding balance, closed books and active books"]
[]
["Number of Mortgages"]
["Outstanding Balance Bands","Closed books","Active books","Grand Total"]
["<=£50,000",48954,1645735,1694689]
[">£50,000 - <=£100,000",61131,2062981,2124112]
[">£100,000 - <=£150,000",40692,1679053,1719745]
[">£150,000 - <=£200,000",22209,1084216,1106425]
[">£200,000 - <=£250,000",11492,673339,684831]
[">£250,000 - <=£300,000",4774,412873,417647]
[">£300,000",5382,766106,771488]
["Grand Total",194634,8324303,8518937]
[]
["Proportion of Mortgages"]
["Outstanding Balance Bands","Closed books","Active books","Grand Total"]
["<=£50,000",0.252,0.19800000000000001,0.19900000000000001]
[">£50,000 - <=£100,000",0.314,0.248,0.249]
[">£100,000 - <=£150,000",0.20899999999999999,0.20200000000000001,0.20200000000000001]
[">£150,000 - <=£200,000",0.114,0.13,0.13]
[">£200,000 - <=£250,000",5.8999999999999997E-2,8.1000000000000003E-2,0.08]
[">£250,000 - <=£300,000",2.5000000000000001E-2,0.05,4.9000000000000002E-2]
[">£300,000",2.8000000000000001E-2,9.1999999999999998E-2,9.0999999999999998E-2]
["Grand Total",1,1,1]

{"sheet":"Figure 19","index":20,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Figure 19. Proportion of mortgages by current remaining term, closed books and active books"]
[]
["Number of Mortgages"]
["Remaining Term Of Mortgage Bands","Closed books","Active books","Grand Total"]
["0-1 yrs (0-12 mths)",13181,117368,130549]
[">1-5 yrs (13-60 mths)",21076,635576,656652]
[">5-10 yrs (61-120 mths)",65498,1352841,1418339]
[">10-15 yrs (121-180 mths)",62601,1446544,1509145]
[">15-20 yrs (181-240 mths)",19777,1351715,1371492]
[">20-25 yrs (241-300 mths)",9544,1400122,1409666]
[">25-30 yrs (301-360 mths)",829,1068458,1069287]
[">30-35 yrs (361-420 mths)",461,826801,827262]
[">35-40 yrs (421-480 mths)",10,115329,115339]
[">40 yrs (>480 mths)",1657,9548,11205]
["Not Known",null,1,1]
["Grand Total",194634,8324303,8518937]
[]
["Proportion of Mortgages"]
["Remaining Term Of Mortgage Bands","Closed books","Active books","Grand Total"]
["0-1 yrs (0-12 mths)",6.8000000000000005E-2,1.4E-2,1.4999999999999999E-2]
[">1-5 yrs (13-60 mths)",0.108,7.5999999999999998E-2,7.6999999999999999E-2]
[">5-10 yrs (61-120 mths)",0.33700000000000002,0.16300000000000001,0.16600000000000001]
[">10-15 yrs (121-180 mths)",0.32200000000000001,0.17399999999999999,0.17699999999999999]
[">15-20 yrs (181-240 mths)",0.10199999999999999,0.16200000000000001,0.161]
[">20-25 yrs (241-300 mths)",4.9000000000000002E-2,0.16800000000000001,0.16500000000000001]
[">25-30 yrs (301-360 mths)",4.0000000000000001E-3,0.128,0.126]
[">30-35 yrs (361-420 mths)",2E-3,9.9000000000000005E-2,9.7000000000000003E-2]
[">35-40 yrs (421-480 mths)",0,1.4E-2,1.4E-2]
[">40 yrs (>480 mths)",8.9999999999999993E-3,1E-3,1E-3]
["Not Known",null,0,0]
["Grand Total",1,1,1]

{"sheet":"Figure 20","index":21,"n_rows":53,"n_cols":4,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Figure 20. Proportion of mortgages by LTV band, closed books and active books"]
[]
["Number of Mortgages (estimated)"]
["LTV Current Estimated Bands (%)","Closed books","Active books","Grand Total"]
["<5",4703,253030,257733]
[">=5 - <10",3891,274323,278213]
[">=10 - <15",4923,335527,340450]
[">=15 - <20",6556,384106,390662]
[">=20 - <25",8213,426497,434710]
[">=25 - <30",9743,465000,474744]
[">=30 - <35",11101,503706,514806]
[">=35 - <40",12164,538585,550749]
[">=40 - <45",12090,574727,586816]
[">=45 - <50",11463,587458,598921]
[">=50 - <55",12127,605074,617201]
[">=55 - <60",14679,612164,626842]
[">=60 - <65",18180,626357,644537]
[">=65 - <70",22994,620571,643564]
[">=70 - <75",21684,580966,602649]
[">=75 - <80",11719,497226,508945]
[">=80 - <85",4822,290358,295180]
[">=85 - <90",1848,102690,104538]
[">=90 - <95",1012,29469,30481]
[">=95 - <=100",435,4614,5049]
[">100",288,5582,5871]
["Not Known",null,6274,6274]
["Grand Total",194634,8324303,8518937]
[]
["Proportion of Mortgages (estimated)"]
["LTV Current Estimated Bands (%)","Closed books","Active books","Grand Total"]
["<5",2.4199999999999999E-2,3.04E-2,3.0300000000000001E-2]
[">=5 - <10",0.02,3.3000000000000002E-2,3.27E-2]
[">=10 - <15",2.53E-2,4.0300000000000002E-2,0.04]
[">=15 - <20",3.3700000000000001E-2,4.6100000000000002E-2,4.5900000000000003E-2]
[">=20 - <25",4.2200000000000001E-2,5.1200000000000002E-2,5.0999999999999997E-2]
[">=25 - <30",5.0099999999999999E-2,5.5899999999999998E-2,5.57E-2]
[">=30 - <35",5.7000000000000002E-2,6.0499999999999998E-2,6.0400000000000002E-2]
[">=35 - <40",6.25E-2,6.4699999999999994E-2,6.4699999999999994E-2]
[">=40 - <45",6.2100000000000002E-2,6.9000000000000006E-2,6.8900000000000003E-2]
[">=45 - <50",5.8900000000000001E-2,7.0599999999999996E-2,7.0300000000000001E-2]
[">=50 - <55",6.2300000000000001E-2,7.2700000000000001E-2,7.2499999999999995E-2]
[">=55 - <60",7.5399999999999995E-2,7.3499999999999996E-2,7.3599999999999999E-2]
[">=60 - <65",9.3399999999999997E-2,7.5200000000000003E-2,7.5700000000000003E-2]
[">=65 - <70",0.1181,7.4499999999999997E-2,7.5499999999999998E-2]
[">=70 - <75",0.1114,6.9800000000000001E-2,7.0699999999999999E-2]
[">=75 - <80",6.0199999999999997E-2,5.9700000000000003E-2,5.9700000000000003E-2]
[">=80 - <85",2.4799999999999999E-2,3.49E-2,3.4599999999999999E-2]
[">=85 - <90",9.4999999999999998E-3,1.23E-2,1.23E-2]
[">=90 - <95",5.1999999999999998E-3,3.5000000000000001E-3,3.5999999999999999E-3]
[">=95 - <=100",2.2000000000000001E-3,5.9999999999999995E-4,5.9999999999999995E-4]
[">100",1.5E-3,6.9999999999999999E-4,6.9999999999999999E-4]
["Not Known",null,8.0000000000000004E-4,6.9999999999999999E-4]
["Grand Total",1,1,1]

{"sheet":"Figure 21","index":22,"n_rows":49,"n_cols":2,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Figure 21. Proportion of mortgages in closed books with a current payment shortfall (of any amount), by LTV band"]
[]
["Number of Mortgages (estimated)"]
["LTV Current Estimated Bands (%)","Payment shortfall (of any amount)"]
["<5",310]
[">=5 - <10",341]
[">=10 - <15",461]
[">=15 - <20",795]
[">=20 - <25",973]
[">=25 - <30",1418]
[">=30 - <35",1670]
[">=35 - <40",2042]
[">=40 - <45",2108]
[">=45 - <50",1980]
[">=50 - <55",2062]
[">=55 - <60",2288]
[">=60 - <65",2924]
[">=65 - <70",3761]
[">=70 - <75",3941]
[">=75 - <80",2814]
[">=80 - <85",1633]
[">=85 - <90",682]
[">=90 - <95",305]
[">=95 - <=100",181]
[">100",171]
[]
["Proportion of Mortgages (estimated)"]
["LTV Current Estimated Bands (%)","Payment shortfall (of any amount)"]
["<5",6.6000000000000003E-2]
[">=5 - <10",8.7999999999999995E-2]
[">=10 - <15",9.4E-2]
[">=15 - <20",0.121]
[">=20 - <25",0.11799999999999999]
[">=25 - <30",0.14599999999999999]
[">=30 - <35",0.15]
[">=35 - <40",0.16800000000000001]
[">=40 - <45",0.17399999999999999]
[">=45 - <50",0.17299999999999999]
[">=50 - <55",0.17]
[">=55 - <60",0.156]
[">=60 - <65",0.161]
[">=65 - <70",0.16400000000000001]
[">=70 - <75",0.182]
[">=75 - <80",0.24]
[">=80 - <85",0.33900000000000002]
[">=85 - <90",0.36899999999999999]
[">=90 - <95",0.30099999999999999]
[">=95 - <=100",0.41499999999999998]
[">100",0.59299999999999997]

{"sheet":"Figure 22","index":23,"n_rows":49,"n_cols":2,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Figure 22. Proportion of mortgages in closed books with current mortgage arrears (shortfall of two months’ payments or more), by LTV band"]
[]
["Number of Mortgages (estimated)"]
["LTV Current Estimated Bands (%)","Arrears (of two months' payments or more)"]
["<5",148]
[">=5 - <10",164]
[">=10 - <15",217]
[">=15 - <20",341]
[">=20 - <25",456]
[">=25 - <30",655]
[">=30 - <35",782]
[">=35 - <40",1020]
[">=40 - <45",1100]
[">=45 - <50",1075]
[">=50 - <55",1108]
[">=55 - <60",1181]
[">=60 - <65",1520]
[">=65 - <70",1955]
[">=70 - <75",2195]
[">=75 - <80",1724]
[">=80 - <85",1094]
[">=85 - <90",508]
[">=90 - <95",229]
[">=95 - <=100",129]
[">100",128]
[]
["Proportion of Mortgages (estimated)"]
["LTV Current Estimated Bands (%)","Arrears (of two months' payments or more)"]
["<5",3.2000000000000001E-2]
[">=5 - <10",4.2000000000000003E-2]
[">=10 - <15",4.3999999999999997E-2]
[">=15 - <20",5.1999999999999998E-2]
[">=20 - <25",5.5E-2]
[">=25 - <30",6.7000000000000004E-2]
[">=30 - <35",7.0000000000000007E-2]
[">=35 - <40",8.4000000000000005E-2]
[">=40 - <45",9.0999999999999998E-2]
[">=45 - <50",9.4E-2]
[">=50 - <55",9.0999999999999998E-2]
[">=55 - <60",0.08]
[">=60 - <65",8.4000000000000005E-2]
[">=65 - <70",8.5000000000000006E-2]
[">=70 - <75",0.10100000000000001]
[">=75 - <80",0.14699999999999999]
[">=80 - <85",0.22700000000000001]
[">=85 - <90",0.27500000000000002]
[">=90 - <95",0.22600000000000001]
[">=95 - <=100",0.29699999999999999]
[">100",0.44400000000000001]

{"sheet":"Figure 23","index":24,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[[3,1,3,3],[28,1,28,3]]}
["Figure 23. Proportion of mortgages in closed books by repayment type and LTV band"]
[]
["Number of Mortgages (estimated)"]
[null,"Repayment Type"]
["LTV Current Estimated Bands (%)","Capital and Interest","Interest-Only","Mix of Capital and Interest, and Interest-Only","Grand Total"]
["<5",3612,1074,18,4703]
[">=5 - <10",3175,681,35,3891]
[">=10 - <15",4036,850,36,4923]
[">=15 - <20",5420,1043,93,6556]
[">=20 - <25",6830,1295,88,8213]
[">=25 - <30",8101,1509,133,9743]
[">=30 - <35",9140,1811,150,11101]
[">=35 - <40",9652,2342,170,12164]
[">=40 - <45",8660,3242,187,12090]
[">=45 - <50",7303,3950,210,11463]
[">=50 - <55",6440,5502,185,12127]
[">=55 - <60",5593,8911,175,14679]
[">=60 - <65",4399,13595,186,18180]
[">=65 - <70",2675,20118,201,22994]
[">=70 - <75",1641,19868,174,21684]
[">=75 - <80",662,10938,120,11719]
[">=80 - <85",229,4548,44,4822]
[">=85 - <90",70,1759,19,1848]
[">=90 - <95",27,976,9,1012]
[">=95 - <=100",20,411,4,435]
[">100",12,276,null,288]
[]
["Proportion of Mortgages (estimated)"]
[null,"Repayment Type"]
["LTV Current Estimated Bands (%)","Capital and Interest","Interest-Only","Mix of Capital and Interest, and Interest-Only","Grand Total"]
["<5",0.76800000000000002,0.22800000000000001,4.0000000000000001E-3,1]
[">=5 - <10",0.81599999999999995,0.17499999999999999,8.9999999999999993E-3,1]
[">=10 - <15",0.82,0.17299999999999999,7.0000000000000001E-3,1]
[">=15 - <20",0.82699999999999996,0.159,1.4E-2,1]
[">=20 - <25",0.83199999999999996,0.158,1.0999999999999999E-2,1]
[">=25 - <30",0.83099999999999996,0.155,1.4E-2,1]
[">=30 - <35",0.82299999999999995,0.16300000000000001,1.2999999999999999E-2,1]
[">=35 - <40",0.79300000000000004,0.193,1.4E-2,1]
[">=40 - <45",0.71599999999999997,0.26800000000000002,1.4999999999999999E-2,1]
[">=45 - <50",0.63700000000000001,0.34499999999999997,1.7999999999999999E-2,1]
[">=50 - <55",0.53100000000000003,0.45400000000000001,1.4999999999999999E-2,1]
[">=55 - <60",0.38100000000000001,0.60699999999999998,1.2E-2,1]
[">=60 - <65",0.24199999999999999,0.748,0.01,1]
[">=65 - <70",0.11600000000000001,0.875,8.9999999999999993E-3,1]
[">=70 - <75",7.5999999999999998E-2,0.91600000000000004,8.0000000000000002E-3,1]
[">=75 - <80",5.6000000000000001E-2,0.93300000000000005,0.01,1]
[">=80 - <85",4.8000000000000001E-2,0.94299999999999995,8.9999999999999993E-3,1]
[">=85 - <90",3.7999999999999999E-2,0.95199999999999996,0.01,1]
[">=90 - <95",2.7E-2,0.96399999999999997,8.9999999999999993E-3,1]
[">=95 - <=100",4.5999999999999999E-2,0.94399999999999995,8.9999999999999993E-3,1]
[">100",4.2000000000000003E-2,0.95799999999999996,null,1]

{"sheet":"Figure 24","index":25,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Figure 24. Proportion of mortgages by region, closed books and active books"]
[]
["Number of Mortgages"]
["Postcode Region","Closed books","Active books","Grand Total"]
["Central & Greater London",20266,1008078,1028344]
["East Midlands",14805,644856,659661]
["Eastern",12335,788811,801146]
["North East",15027,337256,352283]
["North West",30886,955716,986602]
["South East",13286,818455,831741]
["South West",15751,1000469,1016220]
["West Midlands",19265,695963,715228]
["Yorkshire and The Humber",20579,718484,739063]
["Wales",11460,348318,359778]
["Scotland",16483,733547,750030]
["Northern Ireland",4108,243255,247363]
["Unknown Region",383,31095,31478]
["Grand Total",194634,8324303,8518937]
[]
["Proportion of Mortgages"]
["Postcode Region","Closed books","Active books","Grand Total"]
["Central & Greater London",0.104,0.121,0.121]
["East Midlands",7.5999999999999998E-2,7.6999999999999999E-2,7.6999999999999999E-2]
["Eastern",6.3E-2,9.5000000000000001E-2,9.4E-2]
["North East",7.6999999999999999E-2,4.1000000000000002E-2,4.1000000000000002E-2]
["North West",0.159,0.115,0.11600000000000001]
["South East",6.8000000000000005E-2,9.8000000000000004E-2,9.8000000000000004E-2]
["South West",8.1000000000000003E-2,0.12,0.11899999999999999]
["West Midlands",9.9000000000000005E-2,8.4000000000000005E-2,8.4000000000000005E-2]
["Yorkshire and The Humber",0.106,8.5999999999999993E-2,8.6999999999999994E-2]
["Wales",5.8999999999999997E-2,4.2000000000000003E-2,4.2000000000000003E-2]
["Scotland",8.5000000000000006E-2,8.7999999999999995E-2,8.7999999999999995E-2]
["Northern Ireland",2.1000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2]
["Unknown Region",2E-3,4.0000000000000001E-3,4.0000000000000001E-3]
["Grand Total",1,1,1]

{"sheet":"Figure 25","index":26,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[3,2,3,11],[33,2,33,11]]}
["Figure 25. Proportion of mortgages by region and LTV band, closed books and active books"]
[]
["Number of Mortgages (estimated)"]
[null,null,"LTV Current Estimated Bands (%)"]
["Postcode Region","Book Type","<50",">=50 - <60",">=60 - <75",">=75 - <80",">=80 - <85",">=85 - <90",">=90 - <95",">=95 - <=100",">100","Not Known"]
["Central & Greater London","Closed books",6059,2463,9211,1443,446,160,81,40,51]
["Central & Greater London","Active books",605655,140320,183375,43742,23675,8312,2434,410,692,507]
["East Midlands","Closed books",6878,2183,4501,865,271,63,23,7,5]
["East Midlands","Active books",326052,98219,151715,40330,24414,8696,2503,343,393,444]
["Eastern","Closed books",4678,1645,4721,774,291,59,34,12,11]
["Eastern","Active books",435887,114667,164759,43234,25167,9012,2611,348,402,440]
["North East","Closed books",5657,1662,3384,1120,1108,899,628,275,108]
["North East","Active books",137239,48277,89488,29712,18986,6977,2272,464,450,325]
["North West","Closed books",14715,4528,9098,1768,689,170,65,36,23]
["North West","Active books",462589,143575,227289,63408,39256,14047,3899,606,770,677]
["South East","Closed books",4601,1747,5494,964,292,75,26,16,12]
["South East","Active books",459957,119363,167083,42165,24273,8633,2515,380,366,417]
["South West","Closed books",6101,2179,6254,949,321,71,43,5,8]
["South West","Active books",553599,148291,210871,54958,30702,10544,3019,425,447,696]
["West Midlands","Closed books",9324,2648,6105,1075,350,80,27,9,9]
["West Midlands","Active books",356447,104592,159005,42538,25184,8739,2424,336,560,536]
["Yorkshire and The Humber","Closed books",10361,3097,5686,1019,400,85,18,7,12]
["Yorkshire and The Humber","Active books",345900,106348,169029,48433,29551,10463,2949,374,533,521]
["Wales","Closed books",5519,1751,3664,760,236,54,16,8,13]
["Wales","Active books",167671,51998,80782,23254,14062,5315,1540,221,302,203]
["Scotland","Closed books",8628,2361,3808,885,369,97,34,12,18]
["Scotland","Active books",367070,108674,175048,50637,26402,8915,2549,530,363,1276]
["Northern Ireland","Closed books",2186,497,833,82,42,34,18,7,18]
["Northern Ireland","Active books",117828,31097,46765,14155,8308,2929,733,170,285,227]
["Unknown Region","Closed books",140,44,97,15,7,null,1]
["Unknown Region","Active books",7065,1817,2686,660,379,108,21,5,20,6]
[]
["Proportion of Mortgages (estimated)"]
[null,null,"LTV Current Estimated Bands (%)"]
["Postcode Region","Book Type","<50",">=50 - <60",">=60 - <75",">=75 - <80",">=80 - <85",">=85 - <90",">=90 - <95",">=95 - <=100",">100","Not Known"]
["Central & Greater London","Closed books",0.30399999999999999,0.123,0.46200000000000002,7.1999999999999995E-2,2.1999999999999999E-2,8.0000000000000002E-3,4.0000000000000001E-3,2E-3,3.0000000000000001E-3]
["Central & Greater London","Active books",0.6,0.13900000000000001,0.182,4.2999999999999997E-2,2.3E-2,8.0000000000000002E-3,2E-3,0,1E-3,1E-3]
["East Midlands","Closed books",0.46500000000000002,0.14799999999999999,0.30399999999999999,5.8000000000000003E-2,1.7999999999999999E-2,4.0000000000000001E-3,2E-3,0,0]
["East Midlands","Active books",0.499,0.15,0.23200000000000001,6.2E-2,3.6999999999999998E-2,1.2999999999999999E-2,4.0000000000000001E-3,1E-3,1E-3,1E-3]
["Eastern","Closed books",0.38300000000000001,0.13500000000000001,0.38600000000000001,6.3E-2,2.4E-2,5.0000000000000001E-3,3.0000000000000001E-3,1E-3,1E-3]
["Eastern","Active books",0.54700000000000004,0.14399999999999999,0.20699999999999999,5.3999999999999999E-2,3.2000000000000001E-2,1.0999999999999999E-2,3.0000000000000001E-3,0,1E-3,1E-3]
["North East","Closed books",0.38100000000000001,0.112,0.22800000000000001,7.4999999999999997E-2,7.4999999999999997E-2,6.0999999999999999E-2,4.2000000000000003E-2,1.9E-2,7.0000000000000001E-3]
["North East","Active books",0.41099999999999998,0.14399999999999999,0.26800000000000002,8.8999999999999996E-2,5.7000000000000002E-2,2.1000000000000001E-2,7.0000000000000001E-3,1E-3,1E-3,1E-3]
["North West","Closed books",0.47299999999999998,0.14599999999999999,0.29299999999999998,5.7000000000000002E-2,2.1999999999999999E-2,5.0000000000000001E-3,2E-3,1E-3,1E-3]
["North West","Active books",0.48399999999999999,0.15,0.23799999999999999,6.6000000000000003E-2,4.1000000000000002E-2,1.4999999999999999E-2,4.0000000000000001E-3,1E-3,1E-3,1E-3]
["South East","Closed books",0.34799999999999998,0.13200000000000001,0.41499999999999998,7.2999999999999995E-2,2.1999999999999999E-2,6.0000000000000001E-3,2E-3,1E-3,1E-3]
["South East","Active books",0.55700000000000005,0.14499999999999999,0.20200000000000001,5.0999999999999997E-2,2.9000000000000001E-2,0.01,3.0000000000000001E-3,0,0,1E-3]
["South West","Closed books",0.38300000000000001,0.13700000000000001,0.39300000000000002,0.06,0.02,4.0000000000000001E-3,3.0000000000000001E-3,0,1E-3]
["South West","Active books",0.54600000000000004,0.14599999999999999,0.20799999999999999,5.3999999999999999E-2,0.03,0.01,3.0000000000000001E-3,0,0,1E-3]
["West Midlands","Closed books",0.47499999999999998,0.13500000000000001,0.311,5.5E-2,1.7999999999999999E-2,4.0000000000000001E-3,1E-3,0,0]
["West Midlands","Active books",0.50900000000000001,0.14899999999999999,0.22700000000000001,6.0999999999999999E-2,3.5999999999999997E-2,1.2E-2,3.0000000000000001E-3,0,1E-3,1E-3]
["Yorkshire and The Humber","Closed books",0.501,0.15,0.27500000000000002,4.9000000000000002E-2,1.9E-2,4.0000000000000001E-3,1E-3,0,1E-3]
["Yorkshire and The Humber","Active books",0.48399999999999999,0.14899999999999999,0.23699999999999999,6.8000000000000005E-2,4.1000000000000002E-2,1.4999999999999999E-2,4.0000000000000001E-3,1E-3,1E-3,1E-3]
["Wales","Closed books",0.45900000000000002,0.14599999999999999,0.30499999999999999,6.3E-2,0.02,4.0000000000000001E-3,1E-3,1E-3,1E-3]
["Wales","Active books",0.48599999999999999,0.151,0.23400000000000001,6.7000000000000004E-2,4.1000000000000002E-2,1.4999999999999999E-2,4.0000000000000001E-3,1E-3,1E-3,1E-3]
["Scotland","Closed books",0.53200000000000003,0.14599999999999999,0.23499999999999999,5.5E-2,2.3E-2,6.0000000000000001E-3,2E-3,1E-3,1E-3]
["Scotland","Active books",0.495,0.14699999999999999,0.23599999999999999,6.8000000000000005E-2,3.5999999999999997E-2,1.2E-2,3.0000000000000001E-3,1E-3,0,2E-3]
["Northern Ireland","Closed books",0.58799999999999997,0.13400000000000001,0.224,2.1999999999999999E-2,1.0999999999999999E-2,8.9999999999999993E-3,5.0000000000000001E-3,2E-3,5.0000000000000001E-3]
["Northern Ireland","Active books",0.53,0.14000000000000001,0.21,6.4000000000000001E-2,3.6999999999999998E-2,1.2999999999999999E-2,3.0000000000000001E-3,1E-3,1E-3,1E-3]
["Unknown Region","Closed books",0.46,0.14599999999999999,0.31900000000000001,4.9000000000000002E-2,2.1999999999999999E-2,null,4.0000000000000001E-3]
["Unknown Region","Active books",0.55300000000000005,0.14199999999999999,0.21,5.1999999999999998E-2,0.03,8.0000000000000002E-3,2E-3,0,2E-3,0]

{"sheet":"Figure 26","index":27,"n_rows":60,"n_cols":4,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Figure 26. Proportion of mortgages by region with a current payment shortfall (of any amount), closed books and active books"]
[]
["Number of Mortgages"]
["Postcode Region","Book Type","Payment shortfall (of any amount)","No payment shortfall"]
["Central & Greater London","Closed books",3280,16994]
["Central & Greater London","Active books",20791,987279]
["East Midlands","Closed books",2446,12383]
["East Midlands","Active books",12692,632140]
["Eastern","Closed books",1989,10307]
["Eastern","Active books",13842,775008]
["North East","Closed books",2513,12518]
["North East","Active books",9012,328240]
["North West","Closed books",5746,25135]
["North West","Active books",25189,930532]
["South East","Closed books",2052,11258]
["South East","Active books",14393,804038]
["South West","Closed books",2373,13392]
["South West","Active books",15320,985135]
["West Midlands","Closed books",3391,15869]
["West Midlands","Active books",15974,679994]
["Yorkshire and The Humber","Closed books",3705,16907]
["Yorkshire and The Humber","Active books",17052,701399]
["Scotland","Closed books",2768,13706]
["Scotland","Active books",16050,717506]
["Wales","Closed books",2014,9448]
["Wales","Active books",8878,339438]
["Northern Ireland","Closed books",1147,2916]
["Northern Ireland","Active books",8523,234777]
["Unknown Region","Closed books",50,333]
["Unknown Region","Active books",560,30535]
[]
[]
["Proportion of Mortgages"]
["Postcode Region","Book Type","Payment shortfall (of any amount)","No payment shortfall"]
["Central & Greater London","Closed books",0.16200000000000001,0.83799999999999997]
["Central & Greater London","Active books",2.1000000000000001E-2,0.97899999999999998]
["East Midlands","Closed books",0.16500000000000001,0.83499999999999996]
["East Midlands","Active books",0.02,0.98]
["Eastern","Closed books",0.16200000000000001,0.83799999999999997]
["Eastern","Active books",1.7999999999999999E-2,0.98199999999999998]
["North East","Closed books",0.16700000000000001,0.83299999999999996]
["North East","Active books",2.7E-2,0.97299999999999998]
["North West","Closed books",0.186,0.81399999999999995]
["North West","Active books",2.5999999999999999E-2,0.97399999999999998]
["South East","Closed books",0.154,0.84599999999999997]
["South East","Active books",1.7999999999999999E-2,0.98199999999999998]
["South West","Closed books",0.151,0.84899999999999998]
["South West","Active books",1.4999999999999999E-2,0.98499999999999999]
["West Midlands","Closed books",0.17599999999999999,0.82399999999999995]
["West Midlands","Active books",2.3E-2,0.97699999999999998]
["Yorkshire and The Humber","Closed books",0.18,0.82]
["Yorkshire and The Humber","Active books",2.4E-2,0.97599999999999998]
["Scotland","Closed books",0.16800000000000001,0.83199999999999996]
["Scotland","Active books",2.1999999999999999E-2,0.97799999999999998]
["Wales","Closed books",0.17599999999999999,0.82399999999999995]
["Wales","Active books",2.5000000000000001E-2,0.97499999999999998]
["Northern Ireland","Closed books",0.28199999999999997,0.71799999999999997]
["Northern Ireland","Active books",3.5000000000000003E-2,0.96499999999999997]
["Unknown Region","Closed books",0.13100000000000001,0.86899999999999999]
["Unknown Region","Active books",1.7999999999999999E-2,0.98199999999999998]

{"sheet":"Figure 27","index":28,"n_rows":60,"n_cols":4,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Figure 27. Proportion of mortgages by region with current mortgage arrears (shortfall of two months’ or more), closed books and active books"]
[]
["Number of Mortgages"]
["Postcode Region","Book Type","Arrears (of two months' payments or more)","Other mortgages"]
["Central & Greater London","Closed books",1882,18392]
["Central & Greater London","Active books",8864,999206]
["East Midlands","Closed books",1291,13538]
["East Midlands","Active books",5309,639523]
["Eastern","Closed books",1047,11249]
["Eastern","Active books",5628,783222]
["North East","Closed books",1369,13662]
["North East","Active books",4142,333110]
["North West","Closed books",3150,27731]
["North West","Active books",11319,944402]
["South East","Closed books",1079,12231]
["South East","Active books",5900,812531]
["South West","Closed books",1250,14515]
["South West","Active books",6156,994299]
["West Midlands","Closed books",1767,17493]
["West Midlands","Active books",6958,689010]
["Yorkshire and The Humber","Closed books",1997,18615]
["Yorkshire and The Humber","Active books",7640,710811]
["Scotland","Closed books",1549,14925]
["Scotland","Active books",7872,725684]
["Wales","Closed books",1058,10404]
["Wales","Active books",3871,344445]
["Northern Ireland","Closed books",819,3244]
["Northern Ireland","Active books",4850,238450]
["Unknown Region","Closed books",30,353]
["Unknown Region","Active books",260,30835]
[]
[]
["Proportion of Mortgages"]
["Postcode Region","Book Type","Arrears (of two months' payments or more)","Other mortgages"]
["Central & Greater London","Closed books",9.2999999999999999E-2,0.90700000000000003]
["Central & Greater London","Active books",8.9999999999999993E-3,0.99099999999999999]
["East Midlands","Closed books",8.6999999999999994E-2,0.91300000000000003]
["East Midlands","Active books",8.0000000000000002E-3,0.99199999999999999]
["Eastern","Closed books",8.5000000000000006E-2,0.91500000000000004]
["Eastern","Active books",7.0000000000000001E-3,0.99299999999999999]
["North East","Closed books",9.0999999999999998E-2,0.90900000000000003]
["North East","Active books",1.2E-2,0.98799999999999999]
["North West","Closed books",0.10199999999999999,0.89800000000000002]
["North West","Active books",1.2E-2,0.98799999999999999]
["South East","Closed books",8.1000000000000003E-2,0.91900000000000004]
["South East","Active books",7.0000000000000001E-3,0.99299999999999999]
["South West","Closed books",7.9000000000000001E-2,0.92100000000000004]
["South West","Active books",6.0000000000000001E-3,0.99399999999999999]
["West Midlands","Closed books",9.1999999999999998E-2,0.90800000000000003]
["West Midlands","Active books",0.01,0.99]
["Yorkshire and The Humber","Closed books",9.7000000000000003E-2,0.90300000000000002]
["Yorkshire and The Humber","Active books",1.0999999999999999E-2,0.98899999999999999]
["Scotland","Closed books",9.4E-2,0.90600000000000003]
["Scotland","Active books",1.0999999999999999E-2,0.98899999999999999]
["Wales","Closed books",9.1999999999999998E-2,0.90800000000000003]
["Wales","Active books",1.0999999999999999E-2,0.98899999999999999]
["Northern Ireland","Closed books",0.20200000000000001,0.79800000000000004]
["Northern Ireland","Active books",0.02,0.98]
["Unknown Region","Closed books",7.8E-2,0.92200000000000004]
["Unknown Region","Active books",8.0000000000000002E-3,0.99199999999999999]

{"sheet":"Figure 28","index":29,"n_rows":61,"n_cols":5,"rows_kept":61,"cut":false,"hidden":false,"merged":[[33,2,33,4],[3,2,3,4]]}
["Figure 28. Proportion of mortgages by region and repayment type, closed books and active books"]
[]
["Number of Mortgages"]
[null,null,"Repayment Type"]
["Postcode Region","Book Type","Capital and Interest","Interest-Only","Mix of Capital and Interest, and Interest-Only"]
["Central & Greater London","Closed books",4193,15859,222]
["Central & Greater London","Active books",797610,157400,53060]
["East Midlands","Closed books",7234,7381,214]
["East Midlands","Active books",587587,41943,15302]
["Eastern","Closed books",4170,7937,189]
["Eastern","Active books",685670,74933,28247]
["North East","Closed books",9367,5532,132]
["North East","Active books",306316,23097,7839]
["North West","Closed books",15829,14649,403]
["North West","Active books",860748,70925,24048]
["South East","Closed books",3660,9484,166]
["South East","Active books",690244,92905,35282]
["South West","Closed books",5072,10470,223]
["South West","Active books",860644,104223,35588]
["West Midlands","Closed books",9215,9780,265]
["West Midlands","Active books",625943,52474,17551]
["Yorkshire and The Humber","Closed books",11693,8657,262]
["Yorkshire and The Humber","Active books",653801,48346,16304]
["Scotland","Closed books",10086,6226,162]
["Scotland","Active books",668709,45637,19210]
["Wales","Closed books",5487,5825,150]
["Wales","Active books",310285,28693,9338]
["Northern Ireland","Closed books",1893,2104,66]
["Northern Ireland","Active books",212824,20134,10342]
["Unknown Region","Closed books",153,229,1]
["Unknown Region","Active books",25403,3805,1887]
[]
["Proportion of Mortgages"]
[null,null,"Repayment Type"]
["Postcode Region","Book Type","Capital and Interest","Interest-Only","Mix of Capital and Interest, and Interest-Only"]
["Central & Greater London","Closed books",0.20699999999999999,0.78200000000000003,1.0999999999999999E-2]
["Central & Greater London","Active books",0.79100000000000004,0.156,5.2999999999999999E-2]
["East Midlands","Closed books",0.48799999999999999,0.498,1.4E-2]
["East Midlands","Active books",0.91100000000000003,6.5000000000000002E-2,2.4E-2]
["Eastern","Closed books",0.33900000000000002,0.64500000000000002,1.4999999999999999E-2]
["Eastern","Active books",0.86899999999999999,9.5000000000000001E-2,3.5999999999999997E-2]
["North East","Closed books",0.623,0.36799999999999999,8.9999999999999993E-3]
["North East","Active books",0.90800000000000003,6.8000000000000005E-2,2.3E-2]
["North West","Closed books",0.51300000000000001,0.47399999999999998,1.2999999999999999E-2]
["North West","Active books",0.90100000000000002,7.3999999999999996E-2,2.5000000000000001E-2]
["South East","Closed books",0.27500000000000002,0.71299999999999997,1.2E-2]
["South East","Active books",0.84299999999999997,0.114,4.2999999999999997E-2]
["South West","Closed books",0.32200000000000001,0.66400000000000003,1.4E-2]
["South West","Active books",0.86,0.104,3.5999999999999997E-2]
["West Midlands","Closed books",0.47799999999999998,0.50800000000000001,1.4E-2]
["West Midlands","Active books",0.89900000000000002,7.4999999999999997E-2,2.5000000000000001E-2]
["Yorkshire and The Humber","Closed books",0.56699999999999995,0.42,1.2999999999999999E-2]
["Yorkshire and The Humber","Active books",0.91,6.7000000000000004E-2,2.3E-2]
["Scotland","Closed books",0.61199999999999999,0.378,0.01]
["Scotland","Active books",0.91200000000000003,6.2E-2,2.5999999999999999E-2]
["Wales","Closed books",0.47899999999999998,0.50800000000000001,1.2999999999999999E-2]
["Wales","Active books",0.89100000000000001,8.2000000000000003E-2,2.7E-2]
["Northern Ireland","Closed books",0.46600000000000003,0.51800000000000002,1.6E-2]
["Northern Ireland","Active books",0.875,8.3000000000000004E-2,4.2999999999999997E-2]
["Unknown Region","Closed books",0.39900000000000002,0.59799999999999998,3.0000000000000001E-3]
["Unknown Region","Active books",0.81699999999999995,0.122,6.0999999999999999E-2]

{"sheet":"Figure 29","index":30,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[[33,2,33,8],[3,2,3,8]]}
["Figure 29. Proportion of mortgages by region and current outstanding balance, closed books and active books"]
[]
["Number of Mortgages"]
[null,null,"Outstanding Balance Bands"]
["Postcode Region","Book Type","<=£50,000",">£50,000 - <=£100,000",">£100,000 - <=£150,000",">£150,000 - <=£200,000",">£200,000 - <=£250,000",">£250,000 - <=£300,000",">£300,000"]
["Central & Greater London","Closed books",1476,2413,3760,5138,4012,1667,1808]
["Central & Greater London","Active books",100150,122124,135364,131023,117459,99750,302200]
["East Midlands","Closed books",3832,5270,3560,1281,462,198,226]
["East Midlands","Active books",136888,176083,153106,91436,43474,20683,23162]
["Eastern","Closed books",1590,2723,3334,2388,1185,477,599]
["Eastern","Active books",113815,138940,143899,125376,96108,62939,107773]
["North East","Closed books",5728,6250,2062,602,203,90,96]
["North East","Active books",97890,116937,69499,28857,12308,5583,6178]
["North West","Closed books",9302,11762,6292,2122,740,289,374]
["North West","Active books",234781,297730,212948,104515,49296,24507,31944]
["South East","Closed books",1308,2241,3337,3063,1803,762,796]
["South East","Active books",104564,128637,136982,129543,106400,75858,136447]
["South West","Closed books",2208,3645,4676,2967,1214,504,551]
["South West","Active books",161706,208960,215011,173002,107515,56697,77564]
["West Midlands","Closed books",4924,7053,4617,1552,566,235,313]
["West Midlands","Active books",151488,194939,162084,91053,44982,22575,28847]
["Yorkshire and The Humber","Closed books",6900,8250,3546,1087,431,174,224]
["Yorkshire and The Humber","Active books",184126,233099,156256,73287,34570,16730,20383]
["Scotland","Closed books",7010,5828,2126,826,354,158,172]
["Scotland","Active books",195693,238055,152946,77304,36247,16176,17135]
["Wales","Closed books",3388,4334,2466,734,308,113,119]
["Wales","Active books",88631,115074,78665,35637,15601,7093,7615]
["Northern Ireland","Closed books",1155,1227,898,423,180,92,88]
["Northern Ireland","Active books",70578,85860,55372,19001,6788,2734,2967]
["Unknown Region","Closed books",92,105,80,57,31,8,10]
["Unknown Region","Active books",5466,6573,6859,4151,2594,1555,3897]
[]
["Proportion of Mortgages"]
[null,null,"Outstanding Balance Bands"]
["Postcode Region","Book Type","<=£50,000",">£50,000 - <=£100,000",">£100,000 - <=£150,000",">£150,000 - <=£200,000",">£200,000 - <=£250,000",">£250,000 - <=£300,000",">£300,000"]
["Central & Greater London","Closed books",7.2999999999999995E-2,0.11899999999999999,0.185,0.253,0.19800000000000001,8.2000000000000003E-2,8.8999999999999996E-2]
["Central & Greater London","Active books",9.9000000000000005E-2,0.121,0.13400000000000001,0.13,0.11700000000000001,9.9000000000000005E-2,0.3]
["East Midlands","Closed books",0.25800000000000001,0.35499999999999998,0.24,8.5999999999999993E-2,3.1E-2,1.2999999999999999E-2,1.4999999999999999E-2]
["East Midlands","Active books",0.21199999999999999,0.27300000000000002,0.23699999999999999,0.14199999999999999,6.7000000000000004E-2,3.2000000000000001E-2,3.5999999999999997E-2]
["Eastern","Closed books",0.129,0.221,0.27100000000000002,0.19400000000000001,9.6000000000000002E-2,3.9E-2,4.9000000000000002E-2]
["Eastern","Active books",0.14399999999999999,0.17599999999999999,0.182,0.159,0.122,0.08,0.13700000000000001]
["North East","Closed books",0.38100000000000001,0.41599999999999998,0.13700000000000001,0.04,1.4E-2,6.0000000000000001E-3,6.0000000000000001E-3]
["North East","Active books",0.28999999999999998,0.34699999999999998,0.20599999999999999,8.5999999999999993E-2,3.5999999999999997E-2,1.7000000000000001E-2,1.7999999999999999E-2]
["North West","Closed books",0.30099999999999999,0.38100000000000001,0.20399999999999999,6.9000000000000006E-2,2.4E-2,8.9999999999999993E-3,1.2E-2]
["North West","Active books",0.246,0.312,0.223,0.109,5.1999999999999998E-2,2.5999999999999999E-2,3.3000000000000002E-2]
["South East","Closed books",9.8000000000000004E-2,0.16800000000000001,0.251,0.23,0.13500000000000001,5.7000000000000002E-2,0.06]
["South East","Active books",0.128,0.157,0.16700000000000001,0.158,0.13,9.2999999999999999E-2,0.16700000000000001]
["South West","Closed books",0.14000000000000001,0.23100000000000001,0.29699999999999999,0.188,7.6999999999999999E-2,3.2000000000000001E-2,3.5000000000000003E-2]
["South West","Active books",0.16200000000000001,0.20899999999999999,0.215,0.17299999999999999,0.107,5.7000000000000002E-2,7.8E-2]
["West Midlands","Closed books",0.25600000000000001,0.36599999999999999,0.24,8.1000000000000003E-2,2.9000000000000001E-2,1.2E-2,1.6E-2]
["West Midlands","Active books",0.218,0.28000000000000003,0.23300000000000001,0.13100000000000001,6.5000000000000002E-2,3.2000000000000001E-2,4.1000000000000002E-2]
["Yorkshire and The Humber","Closed books",0.33500000000000002,0.4,0.17199999999999999,5.2999999999999999E-2,2.1000000000000001E-2,8.0000000000000002E-3,1.0999999999999999E-2]
["Yorkshire and The Humber","Active books",0.25600000000000001,0.32400000000000001,0.217,0.10199999999999999,4.8000000000000001E-2,2.3E-2,2.8000000000000001E-2]
["Scotland","Closed books",0.42599999999999999,0.35399999999999998,0.129,0.05,2.1000000000000001E-2,0.01,0.01]
["Scotland","Active books",0.26700000000000002,0.32500000000000001,0.20799999999999999,0.105,4.9000000000000002E-2,2.1999999999999999E-2,2.3E-2]
["Wales","Closed books",0.29599999999999999,0.378,0.215,6.4000000000000001E-2,2.7E-2,0.01,0.01]
["Wales","Active books",0.254,0.33,0.22600000000000001,0.10199999999999999,4.4999999999999998E-2,0.02,2.1999999999999999E-2]
["Northern Ireland","Closed books",0.28399999999999997,0.30199999999999999,0.221,0.104,4.3999999999999997E-2,2.3E-2,2.1999999999999999E-2]
["Northern Ireland","Active books",0.28999999999999998,0.35299999999999998,0.22800000000000001,7.8E-2,2.8000000000000001E-2,1.0999999999999999E-2,1.2E-2]
["Unknown Region","Closed books",0.24,0.27400000000000002,0.20899999999999999,0.14899999999999999,8.1000000000000003E-2,2.1000000000000001E-2,2.5999999999999999E-2]
["Unknown Region","Active books",0.17599999999999999,0.21099999999999999,0.221,0.13300000000000001,8.3000000000000004E-2,0.05,0.125]

{"sheet":"Figure 30","index":31,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Figure 30. Proportion of mortgages where income was not verified at origination, closed books and active books"]
[]
["Number of Mortgages (estimated)"]
["Income Verification at Origination ","Closed books","Active books","Grand Total"]
["Income not verified",90135,921695,1011830]
["Income verified",103668,7382162,7485830]
["Not Known",831,20446,21277]
["Grand Total",194634,8324303,8518937]
[]
["Proportion of Mortgages (estimated)"]
["Income Verification at Origination ","Closed books","Active books","Grand Total"]
["Income not verified",0.46300000000000002,0.111,0.11899999999999999]
["Income verified",0.53300000000000003,0.88700000000000001,0.879]
["Not Known",4.0000000000000001E-3,2E-3,2E-3]
["Grand Total",1,1,1]

{"sheet":"Figure 31","index":32,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Figure 31. Proportion of mortgages advanced to consumers with an impaired credit status, closed books and active books"]
[]
["Number of Mortgages (estimated)"]
["Impaired Credit Status at Origination","Closed books","Active books","Grand Total"]
["Impaired",38389,67607,105996]
["Not Impaired",156245,8256696,8412941]
["Grand Total",194634,8324303,8518937]
[]
["Proportion of Mortgages (estimated)"]
["Impaired Credit Status at Origination","Closed books","Active books","Grand Total"]
["Impaired",0.19700000000000001,8.0000000000000002E-3,1.2E-2]
["Not Impaired",0.80300000000000005,0.99199999999999999,0.98799999999999999]
["Grand Total",1,1,1]

{"sheet":"Figure 32","index":33,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Figure 32. Proportion of mortgages where the borrower was reported as being self-employed, closed books and active books"]
[]
["Number of Mortgages (estimated)"]
["Self-employed at Origination","Closed books","Active books","Grand Total"]
["Self-employed",54927,1032702,1087630]
["Other employment status",139707,7291601,7431307]
["Grand Total",194634,8324303,8518937]
[]
["Proportion of Mortgages (estimated)"]
["Self-employed at Origination","Closed books","Active books","Grand Total"]
["Self-employed",0.28199999999999997,0.124,0.128]
["Other employment status",0.71799999999999997,0.876,0.872]
["Grand Total",1,1,1]

{"sheet":"Figure 33","index":34,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Figure 33. Proportion of mortgages advanced for properties purchased under the Right to Buy scheme, closed books and active books"]
[]
["Number of Mortgages (estimated)"]
["Right-to-buy at Origination","Closed books","Active books","Grand Total"]
["Right-to-buy",6791,94893,101684]
["Other borrower type",187843,8229410,8417253]
["Grand Total",194634,8324303,8518937]
[]
["Proportion of Mortgages (estimated)"]
["Right-to-buy at Origination","Closed books","Active books","Grand Total"]
["Right-to-buy",3.5000000000000003E-2,1.0999999999999999E-2,1.2E-2]
["Other borrower type",0.96499999999999997,0.98899999999999999,0.98799999999999999]
["Grand Total",1,1,1]

{"sheet":"Figure 34","index":35,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Figure 34. Proportion of mortgages where income was not verified at origination, by repayment type, closed books and active books"]
[]
["Number of Mortgages (estimated)"]
["Repayment Type","Closed books","Active books"]
["Capital and Interest",30620,603929]
["Interest-Only",58317,240438]
["Mix of Capital and Interest, and Interest-Only",1198,77328]
[]
[]
["Proportion of Mortgages (estimated)"]
["Repayment Type","Closed books","Active books"]
["Capital and Interest",0.34,0.65500000000000003]
["Interest-Only",0.64700000000000002,0.26100000000000001]
["Mix of Capital and Interest, and Interest-Only",1.2999999999999999E-2,8.4000000000000005E-2]
["Grand Total",1,1]

{"sheet":"Figure 35","index":36,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Figure 35. Proportion of mortgages advanced to consumers with an impaired credit status, by repayment type, closed books and active books"]
[]
["Number of Mortgages (estimated)"]
["Repayment Type","Closed books","Active books"]
["Capital and Interest",17087,49875]
["Interest-Only",20766,15126]
["Mix of Capital and Interest, and Interest-Only",536,2606]
[]
["Proportion of Mortgages (estimated)"]
["Repayment Type","Closed books","Active books"]
["Capital and Interest",0.44500000000000001,0.73799999999999999]
["Interest-Only",0.54100000000000004,0.224]
["Mix of Capital and Interest, and Interest-Only",1.4E-2,3.9E-2]
["Total",1,1]

{"sheet":"Figure 36","index":37,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Figure 36. Proportion of mortgages where the borrower was reported as being self-employed, by repayment type, closed books and active books"]
[]
["Number of Mortgages (estimated)"]
["Repayment Type","Closed books","Active books"]
["Capital and Interest",17418,797355]
["Interest-Only",36727,182309]
["Mix of Capital and Interest, and Interest-Only",782,53039]
[]
["Proportion of Mortgages (estimated)"]
["Repayment Type","Closed books","Active books"]
["Capital and Interest",0.317,0.77200000000000002]
["Interest-Only",0.66900000000000004,0.17699999999999999]
["Mix of Capital and Interest, and Interest-Only",1.4E-2,5.0999999999999997E-2]
["Total",1,1]

{"sheet":"Figure 37","index":38,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Figure 37. Proportion of mortgages advanced for properties purchased under the Right to Buy scheme, by repayment type, closed books and active books"]
[]
["Number of Mortgages (estimated)"]
["Repayment Type","Closed books","Active books"]
["Capital and Interest",4060,91371]
["Interest-Only",2705,2789]
["Mix of Capital and Interest, and Interest-Only",26,733]
[]
["Proportion of Mortgages (estimated)"]
["Repayment Type","Closed books","Active books"]
["Capital and Interest",0.59799999999999998,0.96299999999999997]
["Interest-Only",0.39800000000000002,2.9000000000000001E-2]
["Mix of Capital and Interest, and Interest-Only",4.0000000000000001E-3,8.0000000000000002E-3]
["Total",1,1]