{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Contents","Timeseries data","Completions","Approvals","Starts","Pipeline","Density","Accessible dwellings","MHCLG data","CIL","Planning Decisions"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
["Table of Contents"]
[]
["Timeseries data"]
["Completions"]
["Approvals"]
["Starts"]
["Pipeline"]
["Density"]
["Accessible dwellings"]
["MHCLG data"]
["CIL"]
["Planning Decisions"]
[]
[]
["All data © The London Development Database (LDD) except where stated."]

{"sheet":"Timeseries data","index":1,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Table 3.2 Net Housing Supply in London"]
[]
[null,"2004/05","2005/06","2006/07","2007/08","2008/09","2009/10","2010/11","2011/12","2012/03","2013/14","2014/15","2015/16","2016/17","Average"]
["Conventional",24680,25549,26647,27736,29527,25093,19792,23777,24648,26728,30179,35080,41371,{"$f":"AVERAGE(B4:N4)","v":27754.384615384617}]
["Non-self-contained",5314,792,3028,1407,2764,1561,2021,1282,2939,4416,3976,4448,4526,2959.5384615384614]
["Vacants",2519,-61,3608,287,-398,2223,4882,5670,2018,1057,-120,1070,-392,{"$f":"AVERAGE(B6:N6)","v":1720.2307692307693}]
["Total",32513,26280,33283,29430,31893,28877,26812,30475,28911,31905,{"$f":"SUM(L4:L6)","v":34035},{"$f":"SUM(M4:M6)","v":40598},{"$f":"SUM(N4:N6)","v":45505},{"$f":"AVERAGE(B7:N7)","v":32347.461538461539}]
["* All long term vacants returning to use from the GOV.UK Housing Live Table 615."]
[]
["Table 3.3 Net Conventional Housing Approvals"]
[]
[null,"2004/05","2005/06","2006/07","2007/08","2008/09","2009/10","2010/11","2011/12","2012/03","2013/14","2014/15","2015/16","2016/17","Average"]
["Central Activities Zone",4877,4281,7611,4813,4208,2739,4309,15698,10783,8651,18480,7087,7203,{"$f":"ROUND(AVERAGE(B13:N13),0)","v":7749}]
["Inner",26709,23647,26722,40705,24092,28269,22108,45026,21735,32743,45314,39856,27028,{"$f":"ROUND(AVERAGE(B14:N14),0)","v":31073}]
["Outer",23881,25387,23610,35000,19273,15029,31945,26033,13110,26749,26117,30134,35450,25517]
["London Total:",{"$f":"SUM(B13:B15)","v":55467},53315,57943,80518,47573,46037,58362,86757,45628,68143,89911,77077,69681,64339]
[]
["Table 3.4 Net Conventional Housing Pipeline in London as at End of Financial Year"]
[]
[null,"2004/05","2005/06","2006/07","2007/08","2008/09","2009/10","2010/11","2011/12","2012/03","2013/14","2014/15","2015/16","2016/17","Average"]
["Central Activities Zone",9468,9923,13180,15225,16209,15416,14589,24131,29488,33445,39158,39541,36692,{"$f":"ROUND(AVERAGE(B21:N21),0)","v":22805}]
["Inner",58648,63589,73303,87836,87433,91942,83791,100541,106378,121240,132626,137955,136872,98627]
["Outer",43563,52862,57936,71067,70199,67192,79795,86547,82952,87920,93438,100876,108707,77158]
["London Total:",{"$f":"SUM(B21:B23)","v":111679},126374,144419,174128,173841,174550,178175,211219,218818,242605,265222,278372,282271,{"$f":"ROUND(AVERAGE(B24:N24),0)","v":198590}]
[]
["Table 3.5 Net Conventional Housing Completions"]
[]
[null,"2004/05","2005/06","2006/07","2007/08","2008/09","2009/10","2010/11","2011/12","2012/03","2013/14","2014/15","2015/16","2016/17","Average"]
["Central Activities Zone",2311,2567,2391,1526,1930,1911,2317,1629,1564,2131,2568,3638,4337,{"$f":"AVERAGE(B29:N29)","v":2370.7692307692309}]
["Inner",10672,11817,11854,12342,14464,13766,9640,11284,11614,12612,13737,14926,18566,{"$f":"AVERAGE(B30:N30)","v":12868.76923076923}]
["Outer",11697,11165,12402,13868,13133,9416,7835,10864,11470,11985,13874,16516,18468,12514.846153846154]
["All boroughs",{"$f":"SUM(B29:B31)","v":24680},25549,26647,27736,29527,25093,19792,23777,24648,26728,30179,35080,41371,{"$f":"AVERAGE(B32:N32)","v":27754.384615384617}]

{"sheet":"Completions","index":2,"n_rows":410,"n_cols":14,"rows_kept":410,"cut":false,"hidden":false,"merged":[[174,10,174,12],[174,1,174,3],[174,4,174,6],[174,7,174,9],[213,1,213,4],[213,5,213,8],[213,9,213,12],[213,13,214,13],[213,0,214,0],[252,0,253,0],[252,1,252,4],[252,5,252,8],[252,9,252,12],[252,13,253,13],[294,13,295,13],[333,1,333,3],[333,4,333,6],[333,7,334,7],[333,0,334,0],[294,0,295,0],[294,1,294,3],[294,4,294,6],[294,7,294,9],[294,10,294,12]]}
["Table 3.6 Total Net Completions Against London Plan Benchmark 2016/17"]
[]
["Borough Name","Net conventional completions","Net non-conventional rooms","Long term vacants returning to use","Total","London Plan benchmark","% of target"]
["Barking and Dagenham",595,-24,-5,{"$f":"B4+C4+D4","v":566},1236,{"$f":"ROUND(E4/F4*100,0)&\"%\"","v":"46%"}]
["Barnet",2228,-11,52,{"$f":"B5+C5+D5","v":2269},2349,{"$f":"ROUND(E5/F5*100,0)&\"%\"","v":"97%"}]
["Bexley",816,0,-88,728,446,"163%"]
["Brent",1364,1494,99,2957,1525,"194%"]
["Bromley",914,50,16,980,641,"153%"]
["Camden",1206,199,-28,1377,889,"155%"]
["City of London",7,0,-110,-103,141,"-73%"]
["Croydon",2820,82,-48,2854,1435,"199%"]
["Ealing",1170,332,-106,1396,1297,"108%"]
["Enfield",903,106,168,1177,798,"147%"]
["Greenwich",2442,7,-137,2312,2685,"86%"]
["Hackney",1180,0,121,1301,1599,"81%"]
["Hammersmith and Fulham",984,8,52,1044,1031,"101%"]
["Haringey",737,-31,78,784,1502,"52%"]
["Harrow",655,35,-22,668,593,"113%"]
["Havering",602,-12,-65,525,1170,"45%"]
["Hillingdon",850,27,-89,788,559,"141%"]
["Hounslow",1150,0,62,1212,822,"147%"]
["Islington",680,900,-145,1435,1264,"114%"]
["Kensington and Chelsea",194,-44,169,319,733,"44%"]
["Kingston upon Thames",274,40,-87,227,643,"35%"]
["Lambeth",1125,-12,22,1135,1559,"73%"]
["Lewisham",1579,611,-127,2063,1385,"149%"]
["London Legacy DC",222,0,0,222,1471,"15%"]
["Merton",451,14,-93,372,411,"91%"]
["Newham",2347,19,-116,2250,1994,"113%"]
["Redbridge",780,9,-188,601,1123,"54%"]
["Richmond upon Thames",474,-35,-12,427,315,"136%"]
["Southwark",2421,271,-202,2490,2736,"91%"]
["Sutton",652,83,96,831,363,"229%"]
["Tower Hamlets",4865,57,108,5030,3931,"128%"]
["Waltham Forest",1033,-17,-36,980,862,"114%"]
["Wandsworth",2309,370,88,2767,1812,"153%"]
["Westminster",1342,-2,181,1521,1068,"142%"]
["London",{"$f":"SUM(B4:B37)","v":41371},4526,{"$f":"SUM(D4:D37)","v":-392},{"$f":"SUM(E4:E37)","v":45505},{"$f":"SUM(F4:F37)","v":42388},"107%"]
[]
["Table 3.7 Total net completions against London Plan benchmark for the three year period 2014/15 to 2016/17"]
[]
["Borough Name","Total net completions","Total expected by benchmark","Delivery compared to benchmark"]
["Barking and Dagenham",1896,3537,54]
["Barnet",5444,6953,78]
["Bexley",1732,1227,141]
["Brent",4017,4115,98]
["Bromley",2108,1782,118]
["Camden",2666,2443,109]
["City of London",310,392,79]
["Croydon",6384,4200,152]
["Ealing",3073,3484,88]
["Enfield",1981,2156,92]
["Greenwich",6378,7965,80]
["Hackney",3958,4358,91]
["Hammersmith and Fulham",2268,2677,85]
["Haringey",1979,3824,52]
["Harrow",1975,1536,129]
["Havering",3030,3310,92]
["Hillingdon",2485,1543,161]
["Hounslow",3032,2114,143]
["Islington",2613,3698,71]
["Kensington and Chelsea",1341,2051,65]
["Kingston upon Thames",1107,1661,67]
["Lambeth",3875,4313,90]
["Lewisham",4565,3875,118]
["Merton",1539,1142,135]
["Newham",5787,6488,89]
["Redbridge",1471,3006,49]
["Richmond upon Thames",1408,875,161]
["Southwark",5014,7477,67]
["Sutton",1497,936,160]
["Tower Hamlets",9635,10747,90]
["Waltham Forest",2700,2484,109]
["Wandsworth",6135,4769,129]
["Westminster",2978,2906,102]
["London",106381,114044,93]
[]
["Notes"]
["The three year total is calcultated as one year at the 32k target from the 2011 London Plan and two years at the 42k target introduced in the 2015 Plan"]
["A separate target for the LLDC was introduced in the 2015 Plan so it has not been included in this table. Completions in the LLDC have been excluded from the completions totals for  the boroughs with which it overlaps"]
[]
["Table 3.8 Gross conventional housing completions by tenure and number of bedrooms 2016/17"]
[]
["Unit Tenure","1 bed","2 beds","3 beds","4 beds or more","Total"]
["Social Rented",1018,1120,814,283,3235]
["Intermediate",1151,1373,409,40,2973]
["Affordable Rent",586,840,481,213,2120]
["Market",16162,14446,4937,1879,37424]
["All tenures",18917,17779,6641,2415,45752]
["Unit Tenure","1 bed","2 beds","3 beds","4 beds or more","% 3 or more"]
["Social Rented",0.31468315301391037,0.34621329211746521,0.25162287480680062,8.7480680061823801E-2,{"$f":"D91+E91","v":0.33910355486862442}]
["Intermediate",0.38715102589976452,0.46182307433568787,0.13757147662293978,1.3454423141607804E-2,{"$f":"D92+E92","v":0.15102589976454758}]
["Affordable Rent",0.27641509433962264,0.39622641509433965,0.22688679245283019,0.10047169811320755,{"$f":"D93+E93","v":0.32735849056603772}]
["Market",0.43186190679777681,0.38600897819581015,0.13192069260367678,5.0208422402736215E-2,{"$f":"D94+E94","v":0.18212911500641299}]
["All tenures",0.41346826368246198,0.38859503409687007,0.14515212449728973,5.2784577723378211E-2,{"$f":"D95+E95","v":0.19793670222066795}]
[]
["Table 3.9 Gross conventional housing completions by number of bedrooms 2016/17"]
[]
["Borough","1","2","3","4 or more","Total","% 3 or more"]
["Barking and Dagenham",139,241,168,53,601,0.36772046589018303]
["Barnet",704,1145,436,99,2384,0.22441275167785235]
["Bexley",159,355,151,176,841,0.38882282996432815]
["Brent",654,653,148,23,1478,0.11569688768606225]
["Bromley",428,391,133,83,1035,0.20869565217391306]
["Camden",601,534,134,38,1307,0.13159908186687069]
["City of London",5,7,0,0,12,0]
["Croydon",1627,878,408,66,2979,0.15911379657603222]
["Ealing",652,645,205,64,1566,0.17177522349936145]
["Enfield",462,289,175,96,1022,0.26516634050880628]
["Greenwich",1444,765,297,30,2536,0.12894321766561515]
["Hackney",494,505,282,89,1370,0.27080291970802917]
["Hammersmith and Fulham",531,480,158,161,1330,0.23984962406015037]
["Haringey",468,330,103,48,949,0.15911485774499473]
["Harrow",259,314,94,59,726,0.21074380165289258]
["Havering",157,206,190,124,677,0.46381093057607087]
["Hillingdon",396,318,65,118,897,0.20401337792642138]
["Hounslow",696,362,114,10,1182,0.10490693739424703]
["Islington",335,301,79,40,755,0.15761589403973511]
["Kensington and Chelsea",156,85,77,77,395,0.38987341772151901]
["Kingston upon Thames",133,107,31,34,305,0.21311475409836067]
["Lambeth",790,571,198,58,1617,0.15831787260358687]
["Lewisham",604,794,216,42,1656,0.15579710144927536]
["Merton",246,176,49,60,531,0.20527306967984935]
["Newham",1095,1058,387,54,2594,0.1700077101002313]
["Redbridge",403,277,81,60,821,0.17174177831912302]
["Richmond upon Thames",203,240,46,48,537,0.1750465549348231]
["Southwark",901,1136,396,96,2529,0.19454329774614471]
["Sutton",379,299,25,20,723,6.2240663900414939E-2]
["Tower Hamlets",2159,1962,832,171,5124,0.19574551131928183]
["Waltham Forest",377,476,186,69,1108,0.23014440433212996]
["Wandsworth",755,1282,301,123,2461,0.17228768793173505]
["Westminster",505,597,476,126,1704,0.35328638497652581]
["London",{"$f":"SUM(B100:B132)","v":18917},{"$f":"SUM(C100:C132)","v":17779},{"$f":"SUM(D100:D132)","v":6641},{"$f":"SUM(E100:E132)","v":2415},{"$f":"SUM(B133:E133)","v":45752},0.19793670222066795]
[]
["Table 3.10 Gross conventional affordable housing completions by number of bedrooms 2016/17"]
[]
["Borough","1","2","3","4+","Total","% 3 or more"]
["Barking and Dagenham",45,55,48,27,{"$f":"SUM(B138:E138)","v":175},0.4285714285714286]
["Barnet",140,186,131,13,470,0.30638297872340425]
["Bexley",34,112,22,12,180,0.18888888888888888]
["Brent",111,122,45,3,281,0.1708185053380783]
["Bromley",35,43,10,5,93,0.16129032258064516]
["Camden",52,55,36,7,150,0.28666666666666668]
["City of London",0,0,0,0,0,0]
["Croydon",80,167,84,3,334,0.26047904191616766]
["Ealing",179,168,78,31,456,0.23903508771929827]
["Enfield",56,125,65,56,302,0.40066225165562913]
["Greenwich",144,211,88,5,448,0.2075892857142857]
["Hackney",91,122,43,25,281,0.24199288256227758]
["Hammersmith and Fulham",54,50,8,0,112,7.1428571428571425E-2]
["Haringey",116,38,18,16,188,0.18085106382978722]
["Harrow",2,2,0,0,4,0]
["Havering",9,58,36,0,103,0.34951456310679613]
["Hillingdon",14,36,9,0,59,0.15254237288135594]
["Hounslow",148,110,25,0,283,8.8339222614840993E-2]
["Islington",36,29,23,23,111,0.4144144144144144]
["Kensington and Chelsea",2,11,4,6,23,0.43478260869565216]
["Kingston upon Thames",7,5,3,0,15,0.2]
["Lambeth",293,132,99,15,539,0.21150278293135438]
["Lewisham",67,133,80,23,303,0.33993399339933994]
["Merton",23,29,21,1,74,0.29729729729729726]
["Newham",92,157,96,20,365,0.31780821917808216]
["Redbridge",25,48,3,2,78,6.4102564102564097E-2]
["Richmond upon Thames",21,18,2,0,41,4.878048780487805E-2]
["Southwark",183,223,141,46,593,0.31534569983136596]
["Sutton",22,1,0,0,23,0]
["Tower Hamlets",402,489,358,154,1403,0.36493228795438348]
["Waltham Forest",46,152,72,37,307,0.35504885993485341]
["Wandsworth",179,179,18,2,378,5.2910052910052907E-2]
["Westminster",47,67,38,4,156,0.26923076923076922]
["London",{"$f":"SUM(B138:B170)","v":2755},{"$f":"SUM(C138:C170)","v":3333},1704,536,{"$f":"SUM(F138:F170)","v":8328},0.26897214217098941]
[]
["Table 3.11 Net Conventional Completions by Development Type 2016/17"]
[]
[null,"New build",null,null,"Conversion",null,null,"Change of use",null,null,"Total"]
["Borough","Lost","Gained","Net","Lost","Gained","Net","Lost","Gained","Net","Total losses","Total Gross Completions","Total Net Completions"]
["Barking and Dagenham",0,556,556,6,15,9,0,30,30,6,601,595]
["Barnet",69,1861,1792,87,195,108,0,328,328,156,2384,2228]
["Bexley",13,796,783,11,17,6,1,28,27,25,841,816]
["Brent",2,1040,1038,111,141,30,1,297,296,114,1478,1364]
["Bromley",95,498,403,24,50,26,2,487,485,121,1035,914]
["Camden",19,623,604,80,97,17,2,587,585,101,1307,1206]
["City of London",0,0,0,1,2,1,4,10,6,5,12,7]
["Croydon",45,1456,1411,110,319,209,4,1204,1200,159,2979,2820]
["Ealing",228,1033,805,159,332,173,9,201,192,396,1566,1170]
["Enfield",55,534,479,52,109,57,12,379,367,119,1022,903]
["Greenwich",59,2321,2262,34,45,11,1,170,169,94,2536,2442]
["Hackney",77,1091,1014,96,160,64,4,119,115,177,1370,1193]
["Hammersmith and Fulham",9,377,368,336,476,140,1,477,476,346,1330,984]
["Haringey",69,511,442,139,211,72,4,227,223,212,949,737]
["Harrow",20,392,372,46,90,44,5,244,239,71,726,655]
["Havering",64,493,429,10,21,11,1,163,162,75,677,602]
["Hillingdon",25,555,530,21,37,16,1,305,304,47,897,850]
["Hounslow",27,638,611,5,35,30,0,509,509,32,1182,1150]
["Islington",17,376,359,57,88,31,1,291,290,75,755,680]
["Kensington and Chelsea",31,165,134,151,141,-10,19,89,70,201,395,194]
["Kingston upon Thames",18,126,108,12,35,23,1,144,143,31,305,274]
["Lambeth",388,1087,699,103,152,49,1,378,377,492,1617,1125]
["Lewisham",32,1351,1319,45,77,32,0,228,228,77,1656,1579]
["Merton",34,259,225,44,64,20,2,208,206,80,531,451]
["Newham",3,2360,2357,61,128,67,3,106,103,67,2594,2527]
["Redbridge",7,474,467,33,79,46,1,268,267,41,821,780]
["Richmond upon Thames",17,286,269,46,41,-5,0,210,210,63,537,474]
["Southwark",70,2356,2286,37,93,56,1,80,79,108,2529,2421]
["Sutton",17,199,182,49,68,19,5,456,451,71,723,652]
["Tower Hamlets",205,4628,4423,25,43,18,0,453,453,230,5124,4894]
["Waltham Forest",3,785,782,51,126,75,21,197,176,75,1108,1033]
["Wandsworth",48,2067,2019,104,158,54,0,236,236,152,2461,2309]
["Westminster",129,1015,886,220,135,-85,13,554,541,362,1704,1342]
["London",{"$f":"SUM(B177:B209)","v":1895},32309,30414,2366,3780,1414,120,9663,9543,4381,45752,41371]
[]
["Table 3.12 Conventional Completions by Tenure FY2016/17"]
[]
["Borough","Existing units",null,null,null,"Proposed units",null,null,null,"Net units",null,null,null,"Net affordable %"]
[null,"Market","Social Rented","Intermediate","Affordable Rent","Market","Social Rented","Intermediate","Affordable Rent","Market","Social Rented","Intermediate","Affordable Rent"]
["Barking and Dagenham",6,0,0,0,426,96,25,54,420,96,25,54,29]
["Barnet",156,0,0,0,1914,48,137,285,1758,48,137,285,21]
["Bexley",25,0,0,0,661,54,75,51,636,54,75,51,22]
["Brent",114,0,0,0,1197,193,30,58,1083,193,30,58,21]
["Bromley",75,0,46,0,942,30,41,22,867,30,-5,22,5]
["Camden",92,9,0,0,1157,56,58,36,1065,47,58,36,12]
["City of London",5,0,0,0,12,0,0,0,7,0,0,0,0]
["Croydon",156,3,0,0,2645,45,119,170,2489,42,119,170,12]
["Ealing",227,169,0,0,1110,327,111,18,883,158,111,18,25]
["Enfield",119,0,0,0,720,47,127,128,601,47,127,128,33]
["Greenwich",49,45,0,0,2088,277,151,20,2039,232,151,20,17]
["Hackney",128,49,0,0,1089,69,149,63,961,20,149,63,19]
["Hammersmith and Fulham",343,3,0,0,1218,8,55,49,875,5,55,49,11]
["Haringey",172,40,0,0,761,136,15,37,589,96,15,37,20]
["Harrow",70,1,0,0,722,2,1,1,652,1,1,1,0]
["Havering",39,36,0,0,574,39,49,15,535,3,49,15,11]
["Hillingdon",47,0,0,0,838,4,40,15,791,4,40,15,7]
["Hounslow",7,25,0,0,899,195,64,24,892,170,64,24,22]
["Islington",63,12,0,0,644,102,9,0,581,90,9,0,15]
["Kensington and Chelsea",201,0,0,0,372,11,5,7,171,11,5,7,12]
["Kingston upon Thames",31,0,0,0,290,13,2,0,259,13,2,0,5]
["Lambeth",145,347,0,0,1078,173,285,81,933,-174,285,81,17]
["Lewisham",77,0,0,0,1353,110,119,74,1276,110,119,74,19]
["Merton",80,0,0,0,457,7,55,12,377,7,55,12,16]
["Newham",67,0,0,0,2229,70,213,82,2162,70,213,82,14]
["Redbridge",40,0,1,0,743,14,2,62,703,14,1,62,10]
["Richmond upon Thames",63,0,0,0,496,24,11,6,433,24,11,6,9]
["Southwark",67,41,0,0,1936,412,159,22,1869,371,159,22,23]
["Sutton",58,13,0,0,700,23,0,0,642,10,0,0,2]
["Tower Hamlets",89,124,0,17,3721,548,368,487,3632,424,368,470,26]
["Waltham Forest",75,0,0,0,801,0,145,162,726,0,145,162,30]
["Wandsworth",152,0,0,0,2083,33,283,62,1931,33,283,62,16]
["Westminster",362,0,0,0,1548,69,70,17,1186,69,70,17,12]
["Grand Total",3400,917,47,17,37424,3235,2973,2120,34024,2318,2926,2103,18]
[]
["Table 3.13 Conventional Completions in Major Planning Permissions by Tenure FY2016/17"]
[]
["Borough","Existing units",null,null,null,"Proposed units",null,null,null,"Net units",null,null,null,"Net affordable %"]
[null,"Market","Social Rented","Intermediate","Affordable Rent","Market","Social Rented","Intermediate","Affordable Rent","Market","Social Rented","Intermediate","Affordable Rent"]
["Barking and Dagenham",0,0,0,0,359,96,25,54,359,96,25,54,33]
["Barnet",12,0,0,0,1214,26,137,285,1202,26,137,285,27]
["Bexley",6,0,0,0,546,54,75,42,540,54,75,42,24]
["Brent",0,0,0,0,713,187,30,49,713,187,30,49,27]
["Bromley",2,0,46,0,246,30,41,22,244,30,-5,22,16]
["Camden",11,0,0,0,438,39,58,36,427,39,58,36,24]
["City of London",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Croydon",13,0,0,0,827,34,111,159,814,34,111,159,27]
["Ealing",72,167,0,0,502,322,111,18,430,155,111,18,40]
["Enfield",31,0,0,0,222,47,127,128,191,47,127,128,61]
["Greenwich",6,45,0,0,1892,265,151,17,1886,220,151,17,17]
["Hackney",4,45,0,0,677,66,147,63,673,21,147,63,26]
["Hammersmith and Fulham",19,0,0,0,194,3,53,49,175,3,53,49,38]
["Haringey",3,40,0,0,184,136,15,37,181,96,15,37,45]
["Harrow",5,0,0,0,303,0,1,1,298,0,1,1,1]
["Havering",0,36,0,0,273,39,48,0,273,3,48,0,16]
["Hillingdon",5,0,0,0,391,4,40,15,386,4,40,15,13]
["Hounslow",0,25,0,0,280,185,61,24,280,160,61,24,47]
["Islington",0,10,0,0,165,95,9,0,165,85,9,0,36]
["Kensington and Chelsea",3,0,0,0,110,0,5,7,107,0,5,7,10]
["Kingston upon Thames",0,0,0,0,37,13,2,0,37,13,2,0,29]
["Lambeth",59,345,0,0,449,165,285,72,390,-180,285,72,31]
["Lewisham",0,0,0,0,981,106,119,71,981,106,119,71,23]
["Merton",0,0,0,0,12,4,55,12,12,4,55,12,86]
["Newham",0,0,0,0,1894,57,207,82,1894,57,207,82,15]
["Redbridge",0,0,0,0,325,10,0,62,325,10,0,62,18]
["Richmond upon Thames",7,0,0,0,162,18,11,6,155,18,11,6,18]
["Southwark",20,41,0,0,1671,411,159,22,1651,370,159,22,25]
["Sutton",7,4,0,0,150,12,0,0,143,8,0,0,5]
["Tower Hamlets",33,124,0,17,3116,545,358,487,3083,421,358,470,29]
["Waltham Forest",1,0,0,0,432,0,137,162,431,0,137,162,41]
["Wandsworth",24,0,0,0,1422,30,282,57,1398,30,282,57,21]
["Westminster",101,0,0,0,1020,66,63,15,919,66,63,15,14]
["London",444,882,46,17,21207,3065,2923,2054,20763,2183,2877,2037,25]
[]
["‘Major’ schemes are those proposing 10 residential units or more."]
["‘In referring to ‘planning permissions’ this table excludes certificates of Proposed Lawful Development and all types of prior approval, as well of Certificates of Existing Lawful Use."]
[]
["Table 3.14 Net conventional affordable housing completions by tenure 2014/15 to 2016/17 "]
[]
["Borough","2014/15",null,null,"2015/16",null,null,"2016/17",null,null,"Total",null,null,"All tenures total"]
[null,"Social Rented","Intermediate","Affordable Rent","Social Rented","Intermediate","Affordable Rent","Social Rented","Intermediate","Affordable Rent","Social Rented","Intermediate","Affordable Rent"]
["Barking and Dagenham",-101,115,0,19,83,223,96,25,54,{"$f":"B297+E297+H297","v":14},223,277,{"$f":"SUM(K297:M297)","v":514}]
["Barnet",245,49,50,138,67,0,48,137,285,431,253,335,1019]
["Bexley",74,156,35,-402,80,174,54,75,51,-274,311,260,297]
["Brent",294,274,138,7,14,31,193,30,58,494,318,227,1039]
["Bromley",-100,23,15,-8,13,5,30,-5,22,-78,31,42,-5]
["Camden",35,27,0,48,131,3,47,58,36,130,216,39,385]
["City of London",0,0,0,0,0,0,0,0,0,{"$f":"B303+E303+H303","v":0},0,{"$f":"D303+G303+J303","v":0},0]
["Croydon",296,91,251,23,92,268,42,119,170,361,{"$f":"C304+F304+I304","v":302},689,1352]
["Ealing",101,-36,10,51,145,40,158,111,18,310,220,68,598]
["Enfield",34,35,33,-37,74,15,47,127,128,44,236,176,456]
["Greenwich",207,88,3,422,268,130,232,151,20,861,507,153,1521]
["Hackney",-185,221,196,94,107,45,20,149,63,-71,477,304,710]
["Hammersmith and Fulham",2,171,0,14,21,0,5,55,49,21,247,49,317]
["Haringey",41,181,139,4,35,23,96,15,37,141,231,199,571]
["Harrow",41,55,0,-213,59,60,1,1,1,-171,115,61,5]
["Havering",20,22,352,372,95,134,3,49,15,395,166,501,1062]
["Hillingdon",59,27,0,55,0,63,4,40,15,118,67,78,263]
["Hounslow",184,202,63,30,86,56,170,64,24,384,352,143,879]
["Islington",196,27,0,110,112,0,90,9,0,396,148,0,544]
["Kensington and Chelsea",-8,61,0,43,24,0,11,5,7,46,90,7,143]
["Kingston upon Thames",37,19,76,-7,0,0,13,2,0,43,21,76,140]
["Lambeth",148,143,67,-17,53,102,-174,285,81,-43,481,250,688]
["Lewisham",241,164,13,157,75,5,110,119,74,508,358,92,958]
["Merton",34,31,26,30,47,0,7,55,12,71,133,38,242]
["Newham",320,246,59,190,132,101,70,213,82,580,591,242,1413]
["Redbridge",-29,8,1,35,16,47,14,1,62,20,25,110,155]
["Richmond upon Thames",5,0,0,95,4,0,24,11,6,124,15,6,145]
["Southwark",-121,169,61,-166,154,132,371,159,22,84,482,215,781]
["Sutton",157,0,23,-35,32,12,10,0,0,132,32,35,199]
["Tower Hamlets",477,191,55,303,318,265,424,368,470,1204,877,790,2871]
["Waltham Forest",24,110,147,0,214,456,0,145,162,24,469,765,1258]
["Wandsworth",65,56,23,140,278,101,33,283,62,238,617,186,1041]
["Westminster",25,23,0,82,98,0,69,70,17,176,191,17,384]
["London",{"$f":"SUM(B297:B329)","v":2818},2949,1836,1577,2927,2491,2318,2926,2103,6713,8802,6430,21945]
[]
["Table 3.15 Affordable housing completions as a proportion of total net conventional supply 2014/15 to 2016/17"]
[]
["Borough","Total net conventional affordable completions",null,null,"Affordable as % of net conventional supply",null,null,"Average over 3 year cycle"]
[null,"2014/15","2015/16","2016/17","2014/15","2015/16","2016/17"]
["Barking and Dagenham",14,325,175,2.734375E-2,0.41191381495564006,0.29411764705882354,0.27109704641350213]
["Barnet",344,205,470,0.23658872077028886,0.11634506242905789,0.21095152603231598,0.18717854518736224]
["Bexley",265,-148,180,0.32837670384138784,-1.3577981651376148,0.22058823529411764,0.17147806004618937]
["Brent",706,52,281,0.43960149439601492,4.9665711556829036E-2,0.2060117302052786,0.25865073437888975]
["Bromley",-62,10,47,-0.14452214452214451,1.3071895424836602E-2,5.1422319474835887E-2,-2.3719165085388993E-3]
["Camden",62,182,141,0.12204724409448819,0.19117647058823528,0.11691542288557213,0.14441110277569391]
["City of London",0,0,0,0,0,0,0]
["Croydon",638,383,331,0.41973684210526313,0.18737769080234834,0.1173758865248227,0.21177944862155387]
["Ealing",75,236,287,8.8757396449704137E-2,0.22306238185255198,0.24529914529914529,0.19459811259355678]
["Enfield",102,52,302,0.2537313432835821,7.6923076923076927E-2,0.33444075304540422,0.23018677435638565]
["Greenwich",298,820,403,0.18417799752781211,0.35375323554788612,0.16502866502866503,0.23847601128880527]
["Hackney",232,246,232,0.17629179331306991,0.16826265389876882,0.1944677284157586,0.17879627297909848]
["Hammersmith and Fulham",173,35,109,0.1977142857142857,8.557457212713937E-2,0.11077235772357724,0.13977072310405644]
["Haringey",361,62,148,0.5676100628930818,0.10231023102310231,0.20081411126187246,0.28852956038403232]
["Harrow",96,-94,3,0.23414634146341465,-0.10329670329670329,4.5801526717557254E-3,2.5316455696202532E-3]
["Havering",394,601,67,0.53243243243243243,0.35604265402843605,0.11129568106312292,0.35049504950495047]
["Hillingdon",86,118,59,0.12146892655367232,0.12729234088457389,6.9411764705882353E-2,0.10583501006036217]
["Hounslow",449,172,258,0.41382488479262675,0.21580928481806774,0.22434782608695653,0.28990765171503957]
["Islington",223,222,99,0.25312145289443816,0.21102661596958175,0.14558823529411766,0.20818982013011864]
["Kensington and Chelsea",53,67,23,6.5756823821339946E-2,0.19648093841642228,0.11855670103092783,0.10663683818046234]
["Kingston upon Thames",132,-7,15,0.24812030075187969,-2.3255813953488372E-2,5.4744525547445258E-2,0.12646793134598014]
["Lambeth",358,138,192,0.25264643613267468,0.10352588147036759,0.17066666666666666,0.1775483870967742]
["Lewisham",418,237,303,0.28967428967428965,0.15359688917692807,0.19189360354654844,0.20985761226725083]
["Merton",91,77,74,0.19402985074626866,0.12439418416801293,0.16407982261640799,0.15724496426250811]
["Newham",625,423,365,0.3117206982543641,0.29354614850798055,0.1444400474871389,0.23656454043194375]
["Redbridge",-20,98,77,-0.11764705882352941,0.18809980806142035,9.8717948717948714E-2,0.1053704962610469]
["Richmond upon Thames",5,99,41,1.3227513227513227E-2,0.17805755395683454,8.6497890295358648E-2,0.10298295454545454]
["Southwark",109,120,552,8.9638157894736836E-2,8.714596949891068E-2,0.22800495662949194,0.15576386118867172]
["Sutton",180,9,10,0.379746835443038,2.4258760107816711E-2,1.5337423312883436E-2,0.13293253173012692]
["Tower Hamlets",723,886,1262,0.31244598098530685,0.35769075494549857,0.2578667756436453,0.29643779039752194]
["Waltham Forest",281,670,307,0.4031563845050215,0.69072164948453607,0.29719264278799612,0.46592592592592591]
["Wandsworth",144,519,378,0.15157894736842106,0.18045897079276774,0.16370723256821135,0.16968215158924205]
["Westminster",48,180,156,6.575342465753424E-2,0.19867549668874171,0.11624441132637854,0.12894560107454667]
["London",7603,6995,7347,0.25193015010437719,0.19940136830102623,0.17758816562326268,0.21]
[]
["Table 3.16 Density of Residential Completions by Borough (dwellings per hectare) 2008/09 to 2016/17 "]
["See density tab"]
[]
["Table 3.17 Net Conventional Housing Completions by Permission Type 2016/17"]
[]
["Borough","Full","Outline","Reserved matters","Amendments","Office to Residential Prior Approval (Class O - formerly J)","Other Prior Approvals","S191 Certificate of Existing Lawful Use","All permission types"]
["Barking and Dagenham",409,157,3,0,23,0,3,{"$f":"SUM(B377:H377)","v":595}]
["Barnet",1090,14,638,211,275,-1,1,{"$f":"SUM(B378:H378)","v":2228}]
["Bexley",514,249,34,0,9,8,2,816]
["Brent",905,144,24,7,243,1,40,1364]
["Bromley",496,34,0,0,378,5,1,914]
["Camden",596,0,129,0,412,2,67,1206]
["City of London",7,0,0,0,0,0,0,7]
["Croydon",1237,498,16,1,1055,13,0,2820]
["Ealing",827,1,111,0,131,0,100,1170]
["Enfield",609,0,0,0,239,8,47,903]
["Greenwich",671,1260,305,134,66,0,6,2442]
["Hackney",576,8,394,140,17,3,55,1193]
["Hammersmith and Fulham",646,0,0,-1,335,4,0,984]
["Haringey",401,0,135,0,152,7,42,737]
["Harrow",340,84,25,0,203,0,3,655]
["Havering",432,35,0,0,134,1,0,602]
["Hillingdon",370,76,83,47,269,4,1,850]
["Hounslow",544,0,118,15,472,1,0,1150]
["Islington",409,0,0,4,205,20,42,680]
["Kensington and Chelsea",186,0,0,0,0,-2,10,194]
["Kingston upon Thames",138,13,0,0,113,9,1,274]
["Lambeth",591,-38,0,262,267,7,36,1125]
["Lewisham",1075,1,411,0,51,9,32,1579]
["Merton",197,63,0,0,146,25,20,451]
["Newham",2021,0,369,0,67,5,65,2527]
["Redbridge",456,24,0,10,231,11,48,780]
["Richmond upon Thames",321,0,0,0,145,4,4,474]
["Southwark",2382,0,0,0,33,-3,9,2421]
["Sutton",254,0,0,0,396,2,0,652]
["Tower Hamlets",2739,0,337,1468,343,0,7,4894]
["Waltham Forest",845,0,0,0,103,17,68,1033]
["Wandsworth",1784,23,26,308,116,28,24,2309]
["Westminster",1281,0,32,0,10,1,18,1342]
["Total",{"$f":"SUM(B377:B409)","v":25349},{"$f":"SUM(C377:C409)","v":2646},3190,2606,6639,189,752,{"$f":"SUM(I377:I409)","v":41371}]

{"sheet":"Approvals","index":3,"n_rows":200,"n_cols":14,"rows_kept":200,"cut":false,"hidden":false,"merged":[[83,0,84,0],[83,1,83,5],[2,0,3,0],[41,0,42,0],[2,13,3,13],[2,1,2,4],[2,5,2,8],[2,9,2,12],[41,1,41,4],[41,5,41,8],[41,9,41,12],[41,13,42,13]]}
["Table 3.18 Conventional Approvals by Tenure FY2016/17"]
[]
["Borough","Existing units",null,null,null,"Proposed units",null,null,null,"Net units",null,null,null,"Net affordable %"]
[null,"Market","Social Rented","Intermediate","Affordable Rent","Market","Social Rented","Intermediate","Affordable Rent","Market","Social Rented","Intermediate","Affordable Rent"]
["Barking and Dagenham",9,0,0,0,{"$f":"SUM(B5:E5)","v":9},222,0,6,1213,222,0,6,16]
["Barnet",419,15,0,0,{"$f":"SUM(B6:E6)","v":434},107,100,118,3046,92,100,118,9]
["Bexley",71,201,6,0,278,0,332,519,1764,-201,326,519,27]
["Brent",258,41,0,0,299,412,288,128,3071,371,288,128,20]
["Bromley",150,0,0,0,150,0,35,50,1023,0,35,50,8]
["Camden",237,1,5,0,243,252,47,0,808,251,42,0,27]
["City of London",0,0,0,0,0,0,0,0,404,0,0,0,0]
["Croydon",239,8,2,0,249,30,176,139,1887,22,174,139,15]
["Ealing",402,151,1,0,554,184,506,307,3671,33,505,307,19]
["Enfield",124,2,0,0,126,62,35,0,650,60,35,0,13]
["Greenwich",50,0,0,0,50,249,138,31,1773,249,138,31,19]
["Hackney",311,10,7,0,328,60,186,33,1797,50,179,33,13]
["Hammersmith and Fulham",335,0,0,0,335,47,15,0,387,47,15,0,14]
["Haringey",143,0,0,0,143,21,60,95,1548,21,60,95,10]
["Harrow",93,0,0,0,93,1,121,135,1073,1,121,135,19]
["Havering",52,28,0,0,80,67,30,9,825,39,30,9,9]
["Hillingdon",100,2,1,0,103,10,7,31,997,8,6,31,4]
["Hounslow",90,34,14,0,138,5,354,362,2310,-29,340,362,23]
["Islington",64,0,0,0,64,111,23,0,391,111,23,0,26]
["Kensington and Chelsea",275,2,6,0,283,9,8,0,453,7,2,0,2]
["Kingston upon Thames",118,0,6,0,124,8,87,41,1284,8,81,41,9]
["Lambeth",125,78,0,0,203,297,256,145,2702,219,256,145,19]
["Lewisham",109,5,0,0,114,110,65,65,967,105,65,65,20]
["Merton",141,2,0,0,143,21,26,48,856,19,26,48,10]
["Newham",80,1,0,0,4980,144,676,730,4900,143,676,730,24]
["Redbridge",90,0,0,0,1047,45,49,145,957,45,49,145,20]
["Richmond upon Thames",86,0,0,0,649,42,5,17,563,42,5,17,10]
["Southwark",92,0,1,0,1218,279,109,0,1126,279,108,0,26]
["Sutton",90,11,0,0,1151,102,18,158,1061,91,18,158,20]
["Tower Hamlets",86,18,0,0,6624,550,469,760,6538,532,469,760,21]
["Waltham Forest",141,182,0,0,2064,228,184,147,1923,46,184,147,16]
["Wandsworth",555,94,24,0,2808,205,441,274,2253,111,417,274,26]
["Westminster",605,51,0,0,3238,184,408,26,2633,133,408,26,18]
["Total",{"$f":"SUM(B5:B37)","v":5740},937,73,0,28322,4064,5254,4519,56854,3127,5181,4519,18]
[]
["Table 3.19 Conventional Approvals in Major Planning Permissions by Tenure FY2016/17"]
[]
["Borough","Existing units",null,null,null,"Proposed units",null,null,null,"Net units",null,null,null,"Net affordable %"]
[null,"Market","Social Rented","Intermediate","Affordable Rent","Market","Social Rented","Intermediate","Affordable Rent","Market","Social Rented","Intermediate","Affordable Rent"]
["Barking and Dagenham",2,0,0,0,1104,216,0,6,1102,216,0,6,17]
["Barnet",108,0,0,0,2103,70,100,102,1995,70,100,102,12]
["Bexley",35,201,0,0,1493,0,321,519,1458,-201,321,519,30]
["Brent",63,40,0,0,2135,396,288,128,2072,356,288,128,27]
["Bromley",9,0,0,0,432,0,34,50,423,0,34,50,17]
["Camden",22,0,5,0,553,249,47,0,531,249,42,0,35]
["City of London",0,0,0,0,396,0,0,0,396,0,0,0,0]
["Croydon",53,0,0,0,713,25,169,139,660,25,169,139,34]
["Ealing",83,148,0,0,2792,181,504,305,2709,33,504,305,24]
["Enfield",7,0,0,0,230,48,32,0,223,48,32,0,26]
["Greenwich",2,0,0,0,1593,249,138,31,1591,249,138,31,21]
["Hackney",18,0,1,0,1567,45,181,33,1549,45,180,33,14]
["Hammersmith and Fulham",86,0,0,0,144,47,13,0,58,47,13,0,51]
["Haringey",5,0,0,0,1099,17,54,91,1094,17,54,91,13]
["Harrow",10,0,0,0,459,0,116,132,449,0,116,132,36]
["Havering",14,9,0,0,342,51,25,0,328,42,25,0,17]
["Hillingdon",0,0,0,0,564,0,5,31,564,0,5,31,6]
["Hounslow",9,34,14,0,1250,5,354,362,1241,-29,340,362,35]
["Islington",0,0,0,0,184,96,23,0,184,96,23,0,39]
["Kensington and Chelsea",96,0,0,0,420,0,0,0,324,0,0,0,0]
["Kingston upon Thames",56,0,6,0,1086,6,87,41,1030,6,81,41,11]
["Lambeth",21,76,0,0,2346,295,256,136,2325,219,256,136,21]
["Lewisham",25,1,0,0,737,96,65,65,712,95,65,65,24]
["Merton",2,0,0,0,434,12,25,48,432,12,25,48,16]
["Newham",6,0,0,0,4512,135,676,730,4506,135,676,730,25]
["Redbridge",8,0,0,0,582,24,49,136,574,24,49,136,27]
["Richmond upon Thames",0,0,0,0,361,37,5,15,361,37,5,15,14]
["Southwark",1,0,0,0,627,257,106,0,626,257,106,0,37]
["Sutton",42,11,0,0,798,102,18,158,756,91,18,158,26]
["Tower Hamlets",43,18,0,0,6156,545,469,760,6113,527,469,760,22]
["Waltham Forest",56,182,0,0,1530,210,184,147,1474,28,184,147,20]
["Wandsworth",327,94,24,0,1891,188,439,274,1564,94,415,274,33]
["Westminster",313,31,0,0,2646,173,399,18,2333,142,399,18,19]
["Grand Total",1522,845,50,0,43279,3775,5182,4457,41757,2930,5132,4457,23]
[]
["Major' schemes are those proposing 10 residential units or more"]
["In refering to 'planning permissions' this table excludes certificates of Proposed Lawful Development and all types of prior approval, as well of Certificates of Existing Lawful Use."]
[]
["Table 3.20 Gross Conventional Housing Approvals by Number of Bedrooms 2016/17"]
[]
["Borough","Number of Bedrooms"]
[null,1,2,3,"4+","Total","% 3+"]
["Barking and Dagenham",585,651,134,80,1450,15]
["Barnet",1484,1557,566,183,3790,20]
["Bexley",903,984,648,151,2686,30]
["Brent",2129,1498,462,68,4157,13]
["Bromley",467,492,130,169,1258,24]
["Camden",472,508,255,109,1344,27]
["City of London",172,182,47,3,404,12]
["Croydon",1233,920,242,76,2471,13]
["Ealing",2261,2130,546,133,5070,13]
["Enfield",300,290,206,75,871,32]
["Greenwich",892,937,334,78,2241,18]
["Hackney",905,922,501,59,2387,23]
["Hammersmith and Fulham",254,212,142,176,784,41]
["Haringey",816,786,227,38,1867,14]
["Harrow",771,508,121,23,1423,10]
["Havering",513,286,142,42,983,19]
["Hillingdon",479,431,151,84,1145,21]
["Hounslow",1727,1002,346,46,3121,13]
["Islington",183,325,66,15,589,14]
["Kensington and Chelsea",289,251,140,65,745,28]
["Kingston upon Thames",520,640,243,135,1538,25]
["Lambeth",1469,1527,462,67,3525,15]
["Lewisham",596,522,164,34,1316,15]
["Merton",429,413,149,101,1092,23]
["Newham",2124,2135,1826,445,6530,35]
["Redbridge",603,530,138,15,1286,12]
["Richmond upon Thames",212,307,134,60,713,27]
["Southwark",627,679,263,37,1606,19]
["Sutton",545,581,234,69,1429,21]
["Tower Hamlets",4219,2842,1148,194,8403,16]
["Waltham Forest",997,1147,396,83,2623,18]
["Wandsworth",1499,1592,492,145,3728,17]
["Westminster",1340,1385,839,292,3856,29]
["London",32015,29172,11894,3350,76431,20]
[]
["Table 3.21 Net Non-conventional Housing Approvals by Use 2016/17"]
[]
["Borough","Student hall bedrooms","Care home bedrooms","Hostel / HMO bedrooms","Total rooms"]
["Barking and Dagenham",0,0,0,0]
["Barnet",0,13,2,15]
["Bexley",18,80,0,98]
["Brent",1665,14,-10,1669]
["Bromley",0,-23,7,-16]
["Camden",-277,0,-64,-341]
["City of London",0,0,0,0]
["Croydon",0,-25,123,98]
["Ealing",459,-39,-68,352]
["Enfield",-347,-1,8,-340]
["Greenwich",0,0,0,0]
["Hackney",0,10,341,351]
["Hammersmith and Fulham",306,10,0,316]
["Haringey",0,-15,1,-14]
["Harrow",0,-8,65,57]
["Havering",0,42,-12,30]
["Hillingdon",0,0,123,123]
["Hounslow",0,-14,0,-14]
["Islington",0,-16,-4,-20]
["Kensington and Chelsea",0,50,-103,-53]
["Kingston upon Thames",17,0,-34,-17]
["Lambeth",466,0,-13,453]
["Lewisham",0,0,46,46]
["Merton",0,0,0,0]
["Newham",511,-4,6,513]
["Redbridge",0,45,0,45]
["Richmond upon Thames",0,5,0,5]
["Southwark",0,0,-9,-9]
["Sutton",0,17,40,57]
["Tower Hamlets",-8,0,19,11]
["Waltham Forest",0,0,31,31]
["Wandsworth",0,2,-9,-7]
["Westminster",-66,-10,13,-63]
["London",2744,133,499,3376]
[]
["Table 3.22 Density of Residential Approvals by Borough (dwellings per hectare) 2008/09 to 2016/17"]
["See density tab"]
[]
["Table 3.23 Net Conventional Housing Approvals by Permission Type 2016/17"]
[]
["Borough","Full","Outline","Reserved matters","Amendments","Office to Residential Prior Approval (Class O - formerly J)","Other prior approvals","S191 Certificate of Existing Lawful Use","All permission types"]
["Barking and Dagenham",976,36,405,0,20,1,3,1441]
["Barnet",1702,74,0,987,578,14,1,3356]
["Bexley",937,1223,139,0,104,3,2,2408]
["Brent",1782,590,701,25,697,23,40,3858]
["Bromley",868,15,0,0,210,14,1,1108]
["Camden",694,0,286,11,22,15,73,1101]
["City of London",173,0,0,231,0,0,0,404]
["Croydon",1856,84,0,0,213,69,0,2222]
["Ealing",2574,764,792,9,266,11,100,4516]
["Enfield",595,15,0,0,81,7,47,745]
["Greenwich",1848,0,0,294,37,6,6,2191]
["Hackney",1008,0,302,671,7,16,55,2059]
["Hammersmith and Fulham",359,0,0,0,88,2,0,449]
["Haringey",1440,144,0,0,65,33,42,1724]
["Harrow",880,0,0,0,446,1,3,1330]
["Havering",510,1,48,0,341,3,0,903]
["Hillingdon",535,9,85,185,226,1,1,1042]
["Hounslow",1898,0,157,0,919,9,0,2983]
["Islington",427,0,0,0,36,18,44,525]
["Kensington and Chelsea",450,0,0,0,0,2,10,462]
["Kingston upon Thames",1195,7,106,0,95,10,1,1414]
["Lambeth",1384,4,0,1823,51,24,36,3322]
["Lewisham",1053,0,0,53,59,5,32,1202]
["Merton",796,2,0,0,96,35,20,949]
["Newham",1849,3508,927,0,88,12,65,6449]
["Redbridge",612,2,0,363,161,10,48,1196]
["Richmond upon Thames",280,0,0,223,113,7,4,627]
["Southwark",1302,0,122,0,79,1,9,1513]
["Sutton",493,0,734,0,88,13,0,1328]
["Tower Hamlets",5394,36,1907,767,185,3,7,8299]
["Waltham Forest",2058,0,0,0,156,18,68,2300]
["Wandsworth",1316,431,0,1051,220,14,23,3055]
["Westminster",3047,0,105,0,29,0,19,3200]
["London",42291,6945,6816,6693,5776,400,760,69681]
[]
["Note: Amendments includes Minor Material Amendments and Variations to s106. Other prior approvals includes s192 Certificates of Proposed Lawful Development, but does not include office to residential prior approvals."]

{"sheet":"Starts","index":4,"n_rows":159,"n_cols":14,"rows_kept":159,"cut":false,"hidden":false,"merged":[[2,9,2,12],[2,13,3,13],[41,0,42,0],[41,1,41,4],[41,5,41,8],[41,9,41,12],[41,13,42,13],[123,0,124,0],[123,6,124,6],[123,1,123,5],[2,0,3,0],[2,1,2,4],[2,5,2,8]]}
["Table 3.24 Conventional Starts by Tenure 2016/17"]
[]
["Borough","Existing",null,null,null,"Proposed",null,null,null,"Net",null,null,null,"% Aff."]
[null,"Market","Soc.Rent","Int.","Aff. Rent","Market","Soc. Rent","Int.","Aff. Rent","Market","Soc. Rent","Int.","Aff. Rent"]
["Barking and Dagenham",21,0,0,0,575,20,49,2,554,20,49,2,11]
["Barnet",286,0,0,0,1856,195,198,69,1570,195,198,69,23]
["Bexley",58,192,0,0,356,0,159,196,298,-192,159,196,35]
["Brent",212,187,0,0,1199,238,200,44,987,51,200,44,23]
["Bromley",73,0,0,0,897,11,43,129,824,11,43,129,18]
["Camden",107,0,0,0,741,58,19,0,634,58,19,0,11]
["City of London",0,0,0,0,250,0,0,0,250,0,0,0,0]
["Croydon",153,34,0,0,2230,105,125,142,2077,71,125,142,14]
["Ealing",210,324,0,0,1543,292,98,18,1333,-32,98,18,6]
["Enfield",131,128,0,0,629,171,70,0,498,43,70,0,18]
["Greenwich",22,0,0,0,11346,172,957,2081,11324,172,957,2081,22]
["Hackney",208,189,1,0,2065,181,282,81,1857,-8,281,81,16]
["Hammersmith and Fulham",193,8,0,0,745,16,38,0,552,8,38,0,8]
["Haringey",167,0,0,0,2250,0,39,296,2083,0,39,296,14]
["Harrow",65,40,0,0,1110,1,133,154,1045,-39,133,154,19]
["Havering",18,36,0,0,262,9,19,15,244,-27,19,15,3]
["Hillingdon",36,31,0,0,421,23,18,4,385,-8,18,4,4]
["Hounslow",8,34,14,0,1419,57,431,273,1411,23,417,273,34]
["Islington",77,28,0,0,709,246,47,0,632,218,47,0,30]
["Kensington and Chelsea",269,2,0,0,540,11,0,0,271,9,0,0,3]
["Kingston upon Thames",39,0,0,0,287,23,25,9,248,23,25,9,19]
["Lambeth",104,76,0,0,3121,227,296,177,3017,151,296,177,17]
["Lewisham",72,0,30,0,1017,64,120,40,945,64,90,40,17]
["Merton",85,3,0,0,476,11,0,0,391,8,0,0,2]
["Newham",197,0,0,0,2632,12,217,223,2435,12,217,223,16]
["Redbridge",57,0,1,0,853,62,22,73,796,62,21,73,16]
["Richmond upon Thames",61,0,0,0,455,74,37,0,394,74,37,0,22]
["Southwark",57,51,0,0,1568,186,116,6,1511,135,116,6,15]
["Sutton",63,20,0,0,539,111,18,0,476,91,18,0,19]
["Tower Hamlets",78,18,0,0,5348,87,387,493,5270,69,387,493,15]
["Waltham Forest",72,20,0,0,569,106,93,11,497,86,93,11,28]
["Wandsworth",471,0,24,0,8286,320,754,330,7815,320,730,330,15]
["Westminster",348,91,0,0,2739,155,342,41,2391,64,342,41,16]
["London",4018,1512,70,0,59033,3244,5352,4907,55015,1732,5282,4907,18]
[]
["Table 3.25 Conventional Starts in Major Planning Permissions by Tenure 2016/17"]
[]
["Borough","Existing units",null,null,null,"Proposed units",null,null,null,"Net units",null,null,null,"Net affordable %"]
[null,"Market","Social Rented","Intermediate","Affordable Rent","Market","Social Rented","Intermediate","Affordable Rent","Market","Social Rented","Intermediate","Affordable Rent"]
["Barking and Dagenham",18,0,0,0,521,14,49,0,503,14,49,0,11]
["Barnet",149,0,0,0,1382,195,198,69,1233,195,198,69,27]
["Bexley",38,192,0,0,207,0,159,187,169,-192,159,187,48]
["Brent",86,187,0,0,849,238,197,44,763,51,197,44,28]
["Bromley",10,0,0,0,544,11,42,129,534,11,42,129,25]
["Camden",9,0,0,0,408,55,19,0,399,55,19,0,16]
["City of London",0,0,0,0,231,0,0,0,231,0,0,0,0]
["Croydon",20,33,0,0,757,96,120,137,737,63,120,137,30]
["Ealing",119,318,0,0,863,292,98,17,744,-26,98,17,11]
["Enfield",37,128,0,0,287,137,67,0,250,9,67,0,23]
["Greenwich",8,0,0,0,11219,171,957,2078,11211,171,957,2078,22]
["Hackney",47,180,1,0,1589,173,281,81,1542,-7,280,81,19]
["Hammersmith and Fulham",8,8,0,0,290,16,34,0,282,8,34,0,13]
["Haringey",6,0,0,0,1802,0,32,296,1796,0,32,296,15]
["Harrow",9,40,0,0,834,0,133,148,825,-40,133,148,23]
["Havering",0,36,0,0,9,9,14,0,9,-27,14,0,0]
["Hillingdon",0,0,0,0,255,23,18,4,255,23,18,4,15]
["Hounslow",6,34,14,0,1061,57,431,273,1055,23,417,273,40]
["Islington",7,28,0,0,385,239,47,0,378,211,47,0,41]
["Kensington and Chelsea",57,0,0,0,249,0,0,0,192,0,0,0,0]
["Kingston upon Thames",1,0,0,0,97,23,25,9,96,23,25,9,37]
["Lambeth",18,76,0,0,2626,226,296,168,2608,150,296,168,19]
["Lewisham",17,0,30,0,760,56,120,40,743,56,90,40,20]
["Merton",2,0,0,0,125,0,0,0,123,0,0,0,0]
["Newham",0,0,0,0,2349,3,217,223,2349,3,217,223,16]
["Redbridge",3,0,0,0,579,48,20,73,576,48,20,73,20]
["Richmond upon Thames",0,0,0,0,240,74,37,0,240,74,37,0,32]
["Southwark",9,51,0,0,1290,183,116,6,1281,132,116,6,17]
["Sutton",28,11,0,0,134,102,18,0,106,91,18,0,51]
["Tower Hamlets",30,18,0,0,5172,83,387,493,5142,65,387,493,16]
["Waltham Forest",8,20,0,0,146,60,93,11,138,40,93,11,51]
["Wandsworth",290,0,24,0,7796,320,752,326,7506,320,728,326,15]
["Westminster",174,91,0,0,2301,155,342,33,2127,64,342,33,17]
["London",1214,1451,69,0,47357,3059,5319,4845,46143,1608,5250,4845,20]
[]
["‘Major’ schemes are those proposing 10 residential units or more."]
["‘In referring to ‘planning permissions’ this table excludes certificates of Proposed Lawful Development and all types of prior approval, as well of Certificates of Existing Lawful Use."]
[]
["Table 3.26 Net Conventional Housing Starts by Permission Type 2016/17"]
[]
["Borough","Full","Outline","Reserved matters","Amendments","Office to Residential Prior Approval (Class O - formerly J)","Other prior approvals","S191 Certificate of Existing Lawful Use","All permission types"]
["Barking and Dagenham",593,0,0,0,29,0,3,625]
["Barnet",1333,149,436,12,91,10,1,2032]
["Bexley",410,25,0,0,20,4,2,461]
["Brent",817,0,361,0,62,2,40,1282]
["Bromley",881,0,0,0,119,6,1,1007]
["Camden",597,0,0,11,22,14,67,711]
["City of London",19,0,0,231,0,0,0,250]
["Croydon",1537,75,24,87,679,13,0,2415]
["Ealing",810,0,118,66,324,0,99,1417]
["Enfield",539,9,0,0,7,9,47,611]
["Greenwich",1570,12898,0,34,21,5,6,14534]
["Hackney",820,15,645,672,5,3,51,2211]
["Hammersmith and Fulham",519,0,0,0,73,6,0,598]
["Haringey",1275,1056,0,0,41,5,41,2418]
["Harrow",1176,30,0,0,83,1,3,1293]
["Havering",110,0,0,0,139,2,0,251]
["Hillingdon",255,0,121,0,20,2,1,399]
["Hounslow",1821,0,0,0,303,0,0,2124]
["Islington",768,0,0,1,69,18,41,897]
["Kensington and Chelsea",270,0,0,0,0,0,10,280]
["Kingston upon Thames",222,0,0,0,77,5,1,305]
["Lambeth",1563,0,0,1861,175,6,36,3641]
["Lewisham",1084,0,0,0,21,2,32,1139]
["Merton",305,11,0,0,36,27,20,399]
["Newham",1232,0,1565,1,16,8,65,2887]
["Redbridge",453,0,0,357,85,12,45,952]
["Richmond upon Thames",432,0,0,0,64,5,4,505]
["Southwark",930,800,0,0,31,-2,9,1768]
["Sutton",386,0,6,0,182,11,0,585]
["Tower Hamlets",3651,508,1269,764,19,1,7,6219]
["Waltham Forest",453,0,0,0,153,12,69,687]
["Wandsworth",5452,0,0,3676,36,6,25,9195]
["Westminster",2715,0,105,0,0,0,18,2838]
["London",34998,15576,4650,7773,3002,193,744,66936]
[]
["Note: Amendments includes Minor Material Amendments and Variations to s106. Other prior approvals includes s192 Certificates of Proposed Lawful Development, but does not include office to residential prior approvals."]
[]
["Table 3.27 Gross Conventional Housing Starts by Number of Bedrooms 2016/17"]
[]
["Borough","Number of Bedrooms",null,null,null,null,"% 3+"]
[null,1,2,3,"4+","Total"]
["Barking and Dagenham",185,366,5,90,646,15]
["Barnet",722,907,420,269,2318,30]
["Bexley",165,374,134,38,711,24]
["Brent",721,629,296,35,1681,20]
["Bromley",323,441,102,214,1080,29]
["Camden",289,293,169,67,818,29]
["City of London",112,109,29,0,250,12]
["Croydon",1472,807,226,97,2602,12]
["Ealing",845,765,285,56,1951,17]
["Enfield",329,313,171,57,870,26]
["Greenwich",7272,5121,2153,10,14556,15]
["Hackney",954,1105,425,125,2609,21]
["Hammersmith and Fulham",275,259,126,139,799,33]
["Haringey",1530,742,225,88,2585,12]
["Harrow",582,645,151,20,1398,12]
["Havering",129,96,46,34,305,26]
["Hillingdon",161,173,73,59,466,28]
["Hounslow",925,850,352,53,2180,19]
["Islington",310,530,123,39,1002,16]
["Kensington and Chelsea",215,151,117,68,551,34]
["Kingston upon Thames",133,124,53,34,344,25]
["Lambeth",1670,1614,442,95,3821,14]
["Lewisham",512,545,156,28,1241,15]
["Merton",186,191,62,48,487,23]
["Newham",1207,1012,743,122,3084,28]
["Redbridge",392,504,102,12,1010,11]
["Richmond upon Thames",138,210,106,112,566,39]
["Southwark",658,851,313,54,1876,20]
["Sutton",367,183,89,29,668,18]
["Tower Hamlets",3502,2183,571,59,6315,10]
["Waltham Forest",359,304,95,21,779,15]
["Wandsworth",2740,5015,1595,340,9690,20]
["Westminster",1120,1176,733,248,3277,30]
["London",27735,25768,10555,3063,67121,19]

{"sheet":"Pipeline","index":5,"n_rows":236,"n_cols":14,"rows_kept":236,"cut":false,"hidden":false,"merged":[[119,0,120,0],[119,1,119,4],[119,5,119,8],[119,9,119,12],[119,13,120,13],[80,13,81,13],[80,0,81,0],[80,1,80,4],[2,0,3,0],[2,1,2,7],[41,0,42,0],[41,1,41,3],[41,4,41,6],[41,7,41,9],[80,5,80,8],[80,9,80,12]]}
["Table 3.28 Gross Conventional Housing Pipeline by Number of Bedrooms as at 31/03/2017"]
[]
["Borough","Number of Bedrooms"]
[null,1,2,3,"4+","Not known","Total","% 3+"]
["Barking and Dagenham",2673,7054,3668,1625,0,15020,35]
["Barnet",8431,11145,3930,1359,18,24883,21]
["Bexley",1243,1501,817,225,1,3787,28]
["Brent",3961,4115,1717,304,0,10097,20]
["Bromley",1006,1341,294,399,2,3042,23]
["Camden",2530,2987,1332,434,0,7283,24]
["City of London",411,377,81,20,0,889,11]
["Croydon",3795,2778,684,382,0,7639,14]
["Ealing",5565,7209,2476,837,0,16087,21]
["Enfield",731,1086,617,262,0,2696,33]
["Greenwich",13542,11461,4493,403,770,30669,16]
["Hackney",4046,4180,2077,469,588,11360,22]
["Hammersmith and Fulham",6792,5043,2407,685,1472,16399,19]
["Haringey",2344,1822,666,245,12,5089,18]
["Harrow",2255,2223,410,247,0,5135,13]
["Havering",978,843,449,178,0,2448,26]
["Hillingdon",1842,1915,481,210,0,4448,16]
["Hounslow",3670,3177,1024,219,31,8121,15]
["Islington",1744,1933,578,150,0,4405,17]
["Kensington and Chelsea",1515,1496,934,406,0,4351,31]
["Kingston upon Thames",1052,1038,330,243,0,2663,22]
["Lambeth",3626,4491,1493,279,0,9889,18]
["Lewisham",3244,3662,908,283,3500,11597,10]
["Merton",771,947,253,203,0,2174,21]
["Newham",7132,7454,4378,775,4693,24432,21]
["Redbridge",1277,1140,301,136,1,2855,15]
["Richmond",572,787,294,184,1,1838,26]
["Southwark",5335,6861,2536,854,1,15587,22]
["Sutton",1254,1444,485,149,0,3332,19]
["Tower Hamlets",13356,10631,4529,706,650,29872,18]
["Waltham Forest",1463,1879,703,109,0,4154,20]
["Wandsworth",6179,9609,3628,918,1,20335,22]
["Westminster",3565,3799,2659,738,66,10827,31]
["London",117901,127430,51635,14636,11807,323409,20]
[]
["Table 3.29 Conventional Pipeline at 31/03/2017"]
[]
["Borough","Not Started",null,null,"Started",null,null,"Total Pipeline"]
[null,"Existing","Proposed","Net","Existing","Proposed","Net","Existing","Proposed","Net"]
["Barking and Dagenham",9,2713,2704,1597,12307,10710,1606,15020,13414]
["Barnet",739,12309,11570,2824,12574,9750,3563,24883,21320]
["Bexley",293,2862,2569,255,925,670,548,3787,3239]
["Brent",281,4023,3742,691,6074,5383,972,10097,9125]
["Bromley",160,1330,1170,113,1712,1599,273,3042,2769]
["Camden",366,2814,2448,1087,4469,3382,1453,7283,5830]
["City of London",3,41,38,13,848,835,16,889,873]
["Croydon",223,3368,3145,182,4271,4089,405,7639,7234]
["Ealing",1307,9223,7916,3806,6864,3058,5113,16087,10974]
["Enfield",97,1139,1042,516,1557,1041,613,2696,2083]
["Greenwich",479,2561,2082,2326,28108,25782,2805,30669,27864]
["Hackney",2240,6358,4118,2911,5002,2091,5151,11360,6209]
["Hammersmith and Fulham",1119,10750,9631,715,5649,4934,1834,16399,14565]
["Haringey",183,1693,1510,145,3396,3251,328,5089,4761]
["Harrow",134,2736,2602,181,2399,2218,315,5135,4820]
["Havering",165,1865,1700,382,583,201,547,2448,1901]
["Hillingdon",123,1582,1459,77,2866,2789,200,4448,4248]
["Hounslow",185,5002,4817,107,3119,3012,292,8121,7829]
["Islington",82,353,271,398,4052,3654,480,4405,3925]
["Kensington and Chelsea",669,1186,517,337,3165,2828,1006,4351,3345]
["Kingston upon Thames",144,1839,1695,60,824,764,204,2663,2459]
["Lambeth",133,1837,1704,1324,8052,6728,1457,9889,8432]
["Lewisham",87,8505,8418,354,3092,2738,441,11597,11156]
["Merton",147,1325,1178,133,849,716,280,2174,1894]
["Newham",28,16334,16306,412,8098,7686,440,24432,23992]
["Redbridge",101,1122,1021,78,1733,1655,179,2855,2676]
["Richmond upon Thames",120,816,696,104,1022,918,224,1838,1614]
["Southwark",2843,6085,3242,1572,9502,7930,4415,15587,11172]
["Sutton",62,1471,1409,732,1861,1129,794,3332,2538]
["Tower Hamlets",111,7558,7447,1095,22314,21219,1206,29872,28666]
["Waltham Forest",273,2681,2408,72,1473,1401,345,4154,3809]
["Wandsworth",798,4354,3556,1190,15981,14791,1988,20335,18347]
["Westminster",910,4050,3140,729,6777,6048,1639,10827,9188]
["London",14614,131885,117271,26518,191518,165000,41132,323403,282271]
[]
["Table 3.30 Conventional Pipeline by Tenure 2016/17"]
[]
["Borough","Existing",null,null,null,"Proposed",null,null,null,"Net",null,null,null,"% Aff."]
[null,"Market","Soc. Rent","Int.","Aff. Rent","Market","Soc. Rent","Int.","Aff. Rent","Market","Soc. Rent","Int.","Aff. Rent"]
["Barking and Dagenham",469,1137,0,0,9310,2640,2616,454,8841,1503,2616,454,34]
["Barnet",1559,2004,0,0,20875,2155,1331,522,19316,151,1331,522,9]
["Bexley",149,393,6,0,2714,0,417,656,2565,-393,411,656,21]
["Brent",459,513,0,0,7461,1325,1038,273,7002,812,1038,273,23]
["Bromley",273,0,0,0,2739,66,110,127,2466,66,110,127,11]
["Camden",812,601,40,0,5418,1358,442,65,4606,757,402,65,21]
["City of London",16,0,0,0,862,0,0,27,846,0,0,27,3]
["Croydon",314,88,2,1,6605,181,430,423,6291,93,428,422,13]
["Ealing",1440,3627,46,0,11062,2809,1870,346,9622,-818,1824,346,12]
["Enfield",257,356,0,0,2220,228,155,93,1963,-128,155,93,6]
["Greenwich",170,2332,0,303,24463,1651,2123,2432,24293,-681,2123,2129,13]
["Hackney",750,4124,276,1,7997,1585,1598,180,7247,-2539,1322,179,-17]
["Hammersmith and Fulham",1212,621,1,0,13488,1405,1399,107,12276,784,1398,107,16]
["Haringey",320,8,0,0,4418,104,225,342,4098,96,225,342,14]
["Harrow",210,105,0,0,4465,5,309,356,4255,-100,309,356,12]
["Havering",130,417,0,0,2282,92,58,16,2152,-325,58,16,-13]
["Hillingdon",166,33,1,0,4139,119,91,99,3973,86,90,99,6]
["Hounslow",210,68,14,0,6520,213,750,638,6310,145,736,638,19]
["Islington",202,278,0,0,3056,800,356,193,2854,522,356,193,27]
["Kensington and Chelsea",588,412,6,0,3418,721,207,5,2830,309,201,5,15]
["Kingston upon Thames",196,1,1,6,2424,24,168,47,2228,23,167,41,9]
["Lambeth",444,1013,0,0,7403,1138,750,598,6959,125,750,598,17]
["Lewisham",174,191,30,46,9277,580,802,938,9103,389,772,892,18]
["Merton",236,44,0,0,1924,92,88,70,1688,48,88,70,11]
["Newham",191,249,0,0,19289,1207,2405,1531,19098,958,2405,1531,20]
["Redbridge",175,4,0,0,2372,220,118,145,2197,216,118,145,18]
["Richmond upon Thames",224,0,0,0,1655,126,40,17,1431,126,40,17,11]
["Southwark",724,3690,1,0,11331,2497,1516,243,10607,-1193,1515,243,5]
["Sutton",130,637,27,0,2686,268,149,229,2556,-369,122,229,-1]
["Tower Hamlets",348,858,0,0,23744,2366,1696,2066,23396,1508,1696,2066,18]
["Waltham Forest",147,198,0,0,3275,267,350,262,3128,69,350,262,18]
["Wandsworth",1248,331,151,258,16907,817,1733,878,15659,486,1582,620,15]
["Westminster",1375,264,0,0,9001,738,945,143,7626,474,945,143,17]
["London",15318,24597,602,615,254800,27797,26285,14521,239482,3200,25683,13906,15]
[]
["Table 3.31 Conventional Pipeline in Major Planning Permissions by Tenure 2016/17"]
[]
["Borough","Existing",null,null,null,"Proposed",null,null,null,"Net",null,null,null,"% Aff."]
[null,"Market","Soc. Rent","Int.","Aff. Rent","Market","Soc. Rent","Int.","Aff. Rent","Market","Soc. Rent","Int.","Aff. Rent"]
["Barking and Dagenham",461,1137,0,0,9034,2620,2616,452,8573,1483,2616,452,35]
["Barnet",1008,1989,0,0,18189,2118,1331,506,17181,129,1331,506,10]
["Bexley",78,393,0,0,2002,0,406,656,1924,-393,406,656,26]
["Brent",130,512,0,0,5686,1295,1035,273,5556,783,1035,273,27]
["Bromley",33,0,0,0,1388,65,109,127,1355,65,109,127,18]
["Camden",327,597,39,0,3712,1344,442,65,3385,747,403,65,26]
["City of London",14,0,0,0,783,0,0,27,769,0,0,27,3]
["Croydon",64,81,0,1,3123,177,385,420,3059,96,385,419,23]
["Ealing",993,3619,45,0,8799,2806,1868,341,7806,-813,1823,341,15]
["Enfield",119,324,0,0,1444,176,150,93,1325,-148,150,93,7]
["Greenwich",95,2332,0,303,23919,1645,2117,2432,23824,-687,2117,2129,13]
["Hackney",336,4115,269,1,6740,1568,1592,180,6404,-2547,1323,179,-19]
["Hammersmith and Fulham",914,621,0,0,12429,1401,1397,107,11515,780,1397,107,17]
["Haringey",61,7,0,0,3371,84,206,336,3310,77,206,336,16]
["Harrow",32,105,0,0,2668,2,304,341,2636,-103,304,341,17]
["Havering",33,398,0,0,1396,68,53,6,1363,-330,53,6,-25]
["Hillingdon",10,31,0,0,3111,109,86,99,3101,78,86,99,8]
["Hounslow",69,68,14,0,4434,212,749,638,4365,144,735,638,26]
["Islington",61,274,0,0,2325,769,356,193,2264,495,356,193,32]
["Kensington and Chelsea",205,410,0,0,2850,719,192,5,2645,309,192,5,16]
["Kingston upon Thames",63,0,0,6,1601,22,168,47,1538,22,168,41,13]
["Lambeth",307,1010,0,0,6350,1136,750,598,6043,126,750,598,20]
["Lewisham",81,152,30,46,8381,570,802,936,8300,418,772,890,20]
["Merton",24,40,0,0,1088,72,87,70,1064,32,87,70,15]
["Newham",151,249,0,0,18747,1171,2396,1531,18596,922,2396,1531,21]
["Redbridge",53,0,0,0,1404,187,118,136,1351,187,118,136,25]
["Richmond upon Thames",21,0,0,0,790,111,40,15,769,111,40,15,18]
["Southwark",566,3688,0,0,10056,2463,1508,243,9490,-1225,1508,243,5]
["Sutton",69,637,27,0,1807,268,149,229,1738,-369,122,229,-1]
["Tower Hamlets",273,854,0,0,22116,2355,1696,2066,21843,1501,1696,2066,19]
["Waltham Forest",62,198,0,0,2481,210,350,262,2419,12,350,262,21]
["Wandsworth",852,331,151,258,15211,781,1731,866,14359,450,1580,608,16]
["Westminster",717,243,0,0,7189,717,931,135,6472,474,931,135,19]
["London",8282,24415,575,615,214624,27241,26120,14431,206342,2826,25545,13816,17]
[]
["‘Major’ schemes are those proposing 10 residential units or more."]
["‘In referring to ‘planning permissions’ this table excludes certificates of Proposed Lawful Development and all types of prior approval, as well of Certificates of Existing Lawful Use."]
[]
["Table 3.32 Net Conventional Housing Pipeline by Permission Type as at 31/03/2017"]
[]
["Borough","Full","Outline","Reserved matters","Amendments","Prior Approval (Class O - formerly J)","Other prior approvals","All permission types"]
["Barking and Dagenham",2332,10290,695,0,94,3,13414]
["Barnet",7243,10994,1211,768,1085,19,21320]
["Bexley",1509,1225,334,0,168,3,3239]
["Brent",3907,2757,1534,28,871,28,9125]
["Bromley",2078,211,2,0,464,14,2769]
["Camden",4386,576,484,11,361,12,5830]
["City of London",482,0,0,391,0,0,873]
["Croydon",4358,564,196,104,1947,65,7234]
["Ealing",4237,4669,1337,9,711,11,10974]
["Enfield",1422,516,0,0,125,20,2083]
["Greenwich",7212,19148,524,902,67,11,27864]
["Hackney",1641,2663,750,1076,40,39,6209]
["Hammersmith and Fulham",10459,2689,1076,-6,338,9,14565]
["Haringey",3292,1318,0,0,123,28,4761]
["Harrow",2202,1067,289,0,1256,6,4820]
["Havering",1539,168,-202,0,384,12,1901]
["Hillingdon",1583,1642,370,152,500,1,4248]
["Hounslow",4019,1393,893,0,1509,15,7829]
["Islington",2738,930,0,0,253,4,3925]
["Kensington and Chelsea",2220,344,779,0,0,2,3345]
["Kingston upon Thames",1952,14,106,-2,370,19,2459]
["Lambeth",4834,840,135,2384,212,27,8432]
["Lewisham",2772,7502,455,53,370,4,11156]
["Merton",1688,14,0,0,173,19,1894]
["Newham",8374,8465,7062,1,79,11,23992]
["Redbridge",1869,2,0,370,415,20,2676]
["Richmond upon Thames",987,2,0,223,395,7,1614]
["Southwark",7030,3345,615,0,181,1,11172]
["Sutton",1438,9,708,0,365,18,2538]
["Tower Hamlets",16216,4846,4556,2288,757,3,28666]
["Waltham Forest",3262,311,0,0,215,21,3809]
["Wandsworth",9945,3074,0,4821,490,17,18347]
["Westminster",8623,0,193,260,112,0,9188]
["London",137849,91588,24102,13833,14430,469,282271]
[]
["Note: Amendments includes Minor Material Amendments and Variations to s106. Other prior approvals includes s192 Certificates of Proposed Lawful Development, but does not include office to residential prior approvals."]
[]
["Table 3.33 Net Non-conventional Pipeline at 31/03/17"]
[]
["Borough","Not Started","Started","Total"]
["Barking and Dagenham",18,176,194]
["Barnet",120,-124,-4]
["Bexley",98,234,332]
["Brent",-8,2341,2333]
["Bromley",146,-89,57]
["Camden",-300,727,427]
["City of London",0,-202,-202]
["Croydon",0,4,4]
["Ealing",38,326,364]
["Enfield",18,-266,-248]
["Greenwich",-63,745,682]
["Hackney",270,313,583]
["Hammersmith and Fulham",111,-9,102]
["Haringey",-1,-21,-22]
["Harrow",185,32,217]
["Havering",-21,0,-21]
["Hillingdon",109,254,363]
["Hounslow",-11,32,21]
["Islington",-30,1081,1051]
["Kensington and Chelsea",107,-56,51]
["Kingston upon Thames",551,479,1030]
["Lambeth",1492,556,2048]
["Lewisham",100,923,1023]
["Merton",0,-78,-78]
["Newham",160,1128,1288]
["Redbridge",67,0,67]
["Richmond upon Thames",-24,0,-24]
["Southwark",-44,1000,956]
["Sutton",60,257,317]
["Tower Hamlets",44,568,612]
["Waltham Forest",-8,570,562]
["Wandsworth",294,-36,258]
["Westminster",-27,-473,-500]
["London",3451,10392,13843]

{"sheet":"Density","index":6,"n_rows":75,"n_cols":10,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["Table 3.16 Density of Residential Completions by Borough (dwellings per hectare) 2008/09 to 2016/17 "]
[]
["Borough","2008/09","2009/10","2010/11","2011/12","2012/03","2013/14","2014/15","2015/16","2016/17"]
["Barking and Dagenham",80.037190562894665,133.72008701957941,273.26018337592069,126.09897010801306,66.942061222328149,71.289145378935771,99.778909929827933,217.11092003439384,136.61202185792351]
["Barnet",109.99901390395426,102.10612941570901,99.646525898974801,69.739199976304363,92.93633985299617,93.14468877093806,80.598851517637442,112.30694086537649,107.76229741256752]
["Bexley",110.21870752502164,83.479789103690678,80.187379443372862,98.728743602443487,63.855165069222586,98.011363636363697,56.569996419620495,95.538215286114479,99.573679332715443]
["Brent",133.06539213556383,182.03712995484199,185.30494924997762,146.29268292682923,134.04558404558409,193.13204005006259,150.50755335304942,164.44667000500777,199.88462647822314]
["Bromley",36.08721871330183,48.672566371681405,52.420041554548867,35.530338502217226,40.384337523479275,30.625,40.381297698763113,58.025088452878769,50.731353507676182]
["Camden",136.26209977661961,139.79566409170209,139.01345291479831,180.96966554316842,188.80446282581522,132.72678619213261,187.99832144355872,165.63743653080846,111.54452651672337]
["City of London",329.15360501567397,235.48387096774189,456.73076923076911,507.177033492823,447.36842105263139,439.89769820971873,340.12539184952971,315.83710407239818,314.64174454828662]
["Croydon",130.9661056029513,96.573208722741413,140.57429240438722,153.99491656536651,120.92064582617661,164.32411106179418,102.30729941595783,138.9008158007729,101.52430255967795]
["Ealing",161.83251524616998,152.56757938937983,141.56098304826295,112.09270307480499,93.773134819445644,119.37262590368823,122.92209092729821,87.645275391611818,186.79656075869931]
["Enfield",64.896373056994847,71.633237822349571,61.336111472848039,61.318525519848791,90.785539548790425,74.990899162722968,73.303381414045944,119.05792709325489,59.694332122541304]
["Greenwich",210.65468549422337,145.30263815102387,336.84031902256942,239.45653820900051,233.27850877192986,253.83554559558701,282.53142059159569,201.08207838835148,183.01347488770932]
["Hackney",199.54712708746135,245.14661431554018,234.61195361284595,283.86955570146637,117.81474539206499,245.49176757557314,416.38715860086245,216.68459423927331,188.10086682427115]
["Hammersmith and Fulham",187.03855619360147,300.11792452830213,183.36535822124631,243.20622155450499,218.61471861471873,392.85333333333347,261.78610585069271,211.64099526066354,147.39612709155878]
["Haringey",142.2879908935686,107.02341137123749,116.50190114068458,200.33327161636737,146.32850883016877,108.75249961544392,144.33962264150952,138.12087105456351,153.25827923411956]
["Harrow",61.864837398374014,82.887934811180259,63.113604488078565,88.994565217391283,92.13675213675215,65.001806721002126,129.66175195143103,116.48605216531384,169.16310033285785]
["Havering",55.271959162119352,99.079126875852651,121.7179047367727,58.440801287283371,56.737588652482273,46.25430799927441,51.661056636909102,47.834153424215536,78.289264096846139]
["Hillingdon",91.236927515326414,38.734085995676203,57.027300303336695,71.637526362337553,53.125299128936561,59.801405779314955,86.72224481496545,82.533054975643751,68.378620483726436]
["Hounslow",157.79157138190138,61.61248679732428,74.879541606980084,103.45516277211908,77.754348972061209,137.64252317283248,130.3760718384984,168.3218526814014,145.63380281690135]
["Islington",243.55511907684772,271.31782945736444,292.94307329778024,285.3328883697651,193.47319347319373,235.74730354391394,359.99421463696876,166.97819314641751,223.35987864998123]
["Kensington and Chelsea",132.73195876288676,101.85185185185188,225.01699524133255,192.15624507796508,163.45156606513174,139.99460868002532,188.70204410432004,146.6113416320886,158.5106382978725]
["Kingston upon Thames",75.435005117707277,63.893653516295039,62.158273381294954,50.397501419647917,34.369396294082492,60.623556581986165,86.198624660163176,52.702810285805263,88.107241063244743]
["Lambeth",129.90692027519225,195.14640994785418,182.71714264629924,177.07811089942851,225.91864509299896,216.05858337113639,339.25422843335815,204.78398828411059,277.75631615545126]
["Lewisham",161.00609985691699,229.07676735389697,133.13973952833524,229.97850040311741,127.2522522522523,140.8385808631547,206.73635307781652,153.6758193091232,152.89880329963984]
["Merton",79.92665300399095,68.593570007330612,65.180586907449211,74.689453279531591,45.76760719840037,75.799721835883204,103.07307748860468,88.529107819497113,92.694566813509624]
["Newham",378.39454480201005,260.23913866796528,397.92231255645896,316.22207846569501,151.25210101912725,175.74229691876766,296.53824678950309,223.97403199629048,296.73771204871684]
["Redbridge",86.602516654330159,373.10606060606057,158.0297588506927,107.61383428713617,70.901364348020664,102.43076550973518,110.62930842784078,146.56269891788673,175.39552645935635]
["Richmond upon Thames",58.033161806746755,45.555247853780124,106.41464503646381,70.788043478260875,53.857791225416058,88.57744801685449,71.916940997720971,90.678824721377907,67.442300416193731]
["Southwark",334.25550834897734,229.50819672131161,224.31120530525743,211.422208081451,365.85778303880971,295.76485461441223,222.25699442949229,163.05959086866287,96.263419900437867]
["Sutton",101.03364410214839,57.770729497054795,57.160355210778818,106.28347288225095,57.486631016042772,149.40458320824578,119.45272759165057,112.60932944606425,112.46279956142648]
["Tower Hamlets",315.95689123106882,361.27138877835256,295.75424956170434,479.11877394636002,188.52918852918859,454.97416020671847,434.99859405754984,550.2636645182896,372.30837394771822]
["Waltham Forest",122.69221780789913,120.914415265445,110.5674006757544,143.97496087636932,128.27251592034776,141.57249721470643,141.99478666483756,107.04457897633471,157.1411454589024]
["Wandsworth",167.86447638603698,150.24180548092428,206.28773956419025,386.89103488036898,261.41416671885753,211.61934805467951,201.91472687607222,283.25393917185784,240.91407914272824]
["Westminster",155.46910070327723,198.66577718479013,205.85787984689665,218.03696276624586,194.8807446189648,193.02298033641341,164.04640572481858,185.61288272062728,213.0269045909069]
["London",139,151,137,165,135,151,171,158,153]
[]
["Table 3.22 Density of Residential Approvals by Borough (dwellings per hectare) 2008/09 to 2016/17"]
[]
["Borough","2008/09","2009/10","2010/11","2011/12","2012/03","2013/14","2014/15","2015/16","2016/17"]
["Barking and Dagenham",80,134,273,126,67,71,100,217,137]
["Barnet",110,102,100,70,93,93,81,112,108]
["Bexley",110,83,80,99,64,98,57,96,100]
["Brent",133,182,185,146,134,193,151,164,200]
["Bromley",36,49,52,36,40,31,40,58,51]
["Camden",136,140,139,181,189,133,188,166,112]
["City of London",329,235,457,507,447,440,340,316,315]
["Croydon",131,97,141,154,121,164,102,139,102]
["Ealing",162,153,142,112,94,119,123,88,187]
["Enfield",65,72,61,61,91,75,73,119,60]
["Greenwich",211,145,337,239,233,254,283,201,183]
["Hackney",200,245,235,284,118,245,416,217,188]
["Hammersmith and Fulham",187,300,183,243,219,393,262,212,147]
["Haringey",142,107,117,200,146,109,144,138,153]
["Harrow",62,83,63,89,92,65,130,116,169]
["Havering",55,99,122,58,57,46,52,48,78]
["Hillingdon",91,39,57,72,53,60,87,83,68]
["Hounslow",158,62,75,103,78,138,130,168,146]
["Islington",244,271,293,285,193,236,360,167,223]
["Kensington and Chelsea",133,102,225,192,163,140,189,147,159]
["Kingston upon Thames",75,64,62,50,34,61,86,53,88]
["Lambeth",130,195,183,177,226,216,339,205,278]
["Lewisham",161,229,133,230,127,141,207,154,153]
["Merton",80,69,65,75,46,76,103,89,93]
["Newham",378,260,398,316,151,176,297,224,297]
["Redbridge",87,373,158,108,71,102,111,147,175]
["Richmond upon Thames",58,46,106,71,54,89,72,91,67]
["Southwark",334,230,224,211,366,296,222,163,96]
["Sutton",101,58,57,106,57,149,119,113,112]
["Tower Hamlets",316,361,296,479,189,455,435,550,372]
["Waltham Forest",123,121,111,144,128,142,142,107,157]
["Wandsworth",168,150,206,387,261,212,202,283,241]
["Westminster",155,199,206,218,195,193,164,186,213]
["London",139,151,137,165,135,151,171,158,153]

{"sheet":"Accessible dwellings","index":7,"n_rows":79,"n_cols":4,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
["Table 3.37 New Build Homes Meeting Accessible Housing Standards M4(2) and M4(3) Approved 2016/17"]
[]
["Borough","% M4(2) Compliant","% M4(3) Compliant"]
["Barking and Dagenham",90,9]
["Barnet",90,3]
["Bexley",91,9]
["Brent",88,11]
["Bromley",20,2]
["Camden",84,9]
["City of London",59,39]
["Croydon",42,2]
["Ealing",88,10]
["Enfield",35,8]
["Greenwich",31,4]
["Hackney",77,10]
["Hammersmith and Fulham",64,13]
["Haringey",91,9]
["Harrow",83,17]
["Havering",45,5]
["Hillingdon",80,8]
["Hounslow",33,3]
["Islington",94,5]
["Kensington and Chelsea",49,11]
["Kingston upon Thames",77,8]
["Lambeth",82,11]
["Lewisham",77,15]
["Merton",92,3]
["Newham",74,9]
["Redbridge",43,8]
["Richmond upon Thames",87,7]
["Southwark",31,6]
["Sutton",84,10]
["Tower Hamlets",90,10]
["Waltham Forest",76,9]
["Wandsworth",78,10]
["Westminster",82,10]
["London",76,9]
[]
["Notes: Only schemes that are 100% New Build are included in the above table. Split schemes (some new build and some conversion of existing buildings) are not taken into account. M4(2) and M4(3) replaced Lifetime Homes and Wheelchair Accessible Homes standards in London on all approvals granted from 01/10/2015 onwards. Although homes may be designed to these standards, they are only counted if compliance with these standards is conditioned in the decision notice."]
[]
["Table 3.38 Net approvals of specialist housing 2016/17"]
[]
["Borough","Specialist housing for older people","Other sheltered accommodation (C3)","Non-self-contained rooms for older people"]
["Barking and Dagenham",0,1,0]
["Barnet",32,1,9]
["Bexley",74,0,80]
["Brent",0,-27,8]
["Bromley",0,-1,12]
["Camden",38,0,0]
["City of London",0,0,0]
["Croydon",75,-1,3]
["Ealing",0,0,-29]
["Enfield",0,11,7]
["Greenwich",0,38,0]
["Hackney",0,0,10]
["Hammersmith and Fulham",0,0,0]
["Haringey",0,5,-18]
["Harrow",58,0,-6]
["Havering",9,-19,0]
["Hillingdon",0,-1,0]
["Hounslow",94,0,0]
["Islington",0,0,0]
["Kensington and Chelsea",0,0,39]
["Kingston upon Thames",0,0,2]
["Lambeth",105,1,0]
["Lewisham",53,0,0]
["Merton",9,1,0]
["Newham",0,0,-6]
["Redbridge",0,0,0]
["Richmond upon Thames",0,4,0]
["Southwark",0,0,0]
["Sutton",0,0,74]
["Tower Hamlets",28,0,0]
["Waltham Forest",0,0,-4]
["Wandsworth",13,0,0]
["Westminster",36,0,0]
["London",624,13,181]
[]
["Note: Changes in non-self-contained accommodation are only recorded on LDD if they meet the criteria for submission, either by proposing a change of 7 rooms or more, or by meeting another criteria such as a loss or gain of residential units."]

{"sheet":"MHCLG data","index":8,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Table 3.34 Affordable Housing Delivery by Type",null,null,null,null,null,null,"Table 3.35 Affordable Delivery in London by Tenure 2016/17"]
[]
["Affordable Housing ","2012/13","2013/14","2014/15","2015/16","2016/17",null,"Borough ","Social rent","Affordable Rent","Intermediate","Total"]
["Social Rent",5060,3590,3160,1060,1150,null,"Barking and Dagenham",0,50,10,60]
["Affordable Rent",480,2400,9630,2810,3170,null,"Barnet",0,260,60,320]
["Intermediate Affordable Housing",3360,3390,5440,1920,2650,null,"Bexley",0,50,20,70]
["All Affordable",8910,9380,18230,5790,6960,null,"Brent",0,200,20,230]
[null,null,null,null,null,null,null,"Bromley",0,40,40,70]
["MHCLG live table 1000 and statistical release for full notes and definitions",null,null,null,null,null,null,"Camden",10,50,20,70]
[null,null,null,null,null,null,null,"City of London",0,0,0,0]
[null,null,null,null,null,null,null,"Croydon",20,80,90,190]
[null,null,null,null,null,null,null,"Ealing",0,10,20,30]
[null,null,null,null,null,null,null,"Enfield",20,130,220,370]
[null,null,null,null,null,null,null,"Greenwich",270,120,90,470]
[null,null,null,null,null,null,null,"Hackney",50,70,40,170]
[null,null,null,null,null,null,null,"Hammersmith and Fulham",0,0,50,50]
[null,null,null,null,null,null,null,"Haringey",0,170,20,190]
[null,null,null,null,null,null,null,"Harrow",0,70,10,80]
[null,null,null,null,null,null,null,"Havering",0,10,30,40]
[null,null,null,null,null,null,null,"Hillingdon",60,20,40,120]
[null,null,null,null,null,null,null,"Hounslow",140,120,40,290]
[null,null,null,null,null,null,null,"Islington",120,20,60,190]
[null,null,null,null,null,null,null,"Kensington and Chelsea",0,0,0,10]
[null,null,null,null,null,null,null,"Kingston upon Thames",0,110,0,110]
[null,null,null,null,null,null,null,"Lambeth",0,10,70,80]
[null,null,null,null,null,null,null,"Lewisham",10,160,120,290]
[null,null,null,null,null,null,null,"Merton",0,10,0,10]
[null,null,null,null,null,null,null,"Newham",110,290,440,840]
[null,null,null,null,null,null,null,"Redbridge",0,50,10,60]
[null,null,null,null,null,null,null,"Richmond upon Thames",0,40,20,60]
[null,null,null,null,null,null,null,"Southwark",200,50,140,390]
[null,null,null,null,null,null,null,"Sutton",10,50,40,100]
[null,null,null,null,null,null,null,"Tower Hamlets",70,660,350,1090]
[null,null,null,null,null,null,null,"Waltham Forest",10,40,70,110]
[null,null,null,null,null,null,null,"Wandsworth",0,90,240,330]
[null,null,null,null,null,null,null,"Westminster",60,150,100,300]
[null,null,null,null,null,null,null,"London",0,0,200,200]
[null,null,null,null,null,null,null,"Not recorded",0,10,50,50]
[]
[null,null,null,null,null,null,null,"Source: MHCLG. Figures rounded to the nearest 10."]

{"sheet":"CIL","index":9,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Table 3.39 Developer Contributions Towards Funding Crossrail (£M). Net of CIL Administration Costs"]
[]
["S106","Year","CIL"]
[0.24,"2010/11",0]
[1.43,"2011/12",0]
[17.2,"2012/13",6.09]
[13.31,"2013/14",46.69]
[13.69,"2014/15",73.19]
[30.24,"2015/16",118.64]
[24.9,"2016/17",136.86000000000001]
[5.88,"2017/18*",80.760000000000005]
[null,"2018/19"]
[null,"2019/20"]
[106.89,"Total",462.23]
[]
[]
["Table 3.39A Use of CIL Receipts"]
[]
["Category","£"]
["Total CIL Expenditure",462230922]
["amount used to repay borrowing",0]
["amount spent (2017/18) on administration by TfL/ GLA (up to 1%)","600,000#"]
["amount spent (2017/18) on administration by"]
["collecting authorities (up to 4%)","£3,570,498##"]
["amount of CIL ‘in-hand’",0]
[]
["Source TfL"]

{"sheet":"Planning Decisions","index":10,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Table 3.42 Planning Applications Referred to the Mayor"]
[]
[null,"2000-2007",2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,"2000-2017"]
["Total",1871,334,240,258,300,307,359,373,454,389,382,5267]
["Strategic Call-ins","-","-",2,1,2,1,2,1,5,3,4,21]
[]
["GLA Planning"]