{ "id" : "h6b9-abc5", "name" : "Redington Frognal extension 2010-2016", "assetType" : "filter", "attribution" : "London Borough of Camden", "attributionLink" : "http://www.camden.gov.uk", "averageRating" : 0, "category" : "Environment", "createdAt" : 1458304824, "description" : "This dataset contains planning applications in the London Borough of Camden dating back to 01/01/2010. Planning application extents are captured against the OS MasterMap product, due to licensing restrictions with this product, this dataset is represented as point geometry, located to the nearest postcode (derived from the OS Code-Point Open product). Attribution includes application number, development address, development description, registered date, decision date and case officer.", "diciBackend" : false, "displayType" : "table", "downloadCount" : 1913, "hideFromCatalog" : false, "hideFromDataJson" : false, "licenseId" : "UK_OGLV3.0", "locked" : false, "modifyingViewUid" : "2eiu-s2cw", "newBackend" : true, "numberOfComments" : 0, "oid" : 3078047, "provenance" : "official", "publicationAppendEnabled" : true, "publicationDate" : 1497255515, "publicationGroup" : 19355, "publicationStage" : "published", "queryString" : "SELECT `pk`, `application_number`, `development_address`, `development_description`, `decision_type`, `registered_date`, `registered_in_last_7_working_days`, `registered_in_last_28_working_days`, `earliest_decision_date`, `decision_date`, `decison_level`, `system_status`, `system_status_change_date`, `applicant_name`, `ward`, `conservation_areas`, `case_officer`, `case_officer_team`, `responsibility_type`, `comment`, `full_application`, `application_type`, `easting`, `northing`, `longitude`, `latitude`, `spatial_accuracy`, `last_uploaded`, `location`, `socrata_id` ORDER BY `case_officer` DESC NULL LAST SEARCH 'redington frognal extension'", "rowsUpdatedAt" : 1780623146, "rowsUpdatedBy" : "6jeh-p2ix", "tableId" : 2068717, "totalTimesRated" : 0, "viewCount" : 7916, "viewLastModified" : 1738625325, "viewType" : "tabular", "approvals" : [ { "reviewedAt" : 1458304824, "reviewedAutomatically" : true, "state" : "approved", "submissionId" : 1534258, "submissionObject" : "public_audience_request", "submissionOutcome" : "change_audience", "submittedAt" : 1458304824, "targetAudience" : "public", "workflowId" : 157, "submissionDetails" : { "permissionType" : "READ" }, "submissionOutcomeApplication" : { "failureCount" : 0, "status" : "success" }, "submitter" : { "id" : "h62x-z4hv", "displayName" : "Michael Webb" } } ], "clientContext" : { "clientContextVariables" : [ ], "inheritedVariables" : { } }, "columns" : [ { "id" : 27121695, "name" : "ID", "dataTypeName" : "number", "description" : "", "fieldName" : "pk", "position" : 1, "renderTypeName" : "number", "tableColumnId" : 200930, "width" : 50, "cachedContents" : { "non_null" : "736", "largest" : "667122", "null" : "0", "top" : [ { "item" : "415277", "count" : "2" }, { "item" : "375138", "count" : "2" }, { "item" : "211314", "count" : "1" }, { "item" : "212441", "count" : "1" }, { "item" : "213034", "count" : "1" }, { "item" : "213374", "count" : "1" }, { "item" : "213734", "count" : "1" }, { "item" : "220234", "count" : "1" }, { "item" : "214409", "count" : "1" }, { "item" : "215834", "count" : "1" }, { "item" : "216579", "count" : "1" }, { "item" : "216655", "count" : "1" }, { "item" : "217434", "count" : "1" }, { "item" : "217454", "count" : "1" }, { "item" : "218114", "count" : "1" }, { "item" : "213594", "count" : "1" }, { "item" : "220414", "count" : "1" }, { "item" : "223254", "count" : "1" }, { "item" : "225614", "count" : "1" }, { "item" : "211514", "count" : "1" } ], "smallest" : "210454", "count" : "736", "cardinality" : "736" }, "format" : { "precisionStyle" : "standard", "noCommas" : "false", "align" : "right" } }, { "id" : 27121696, "name" : "Application Number", "dataTypeName" : "text", "description" : "", "fieldName" : "application_number", "position" : 2, "renderTypeName" : "text", "tableColumnId" : 200913, "width" : 316, "cachedContents" : { "non_null" : "736", "largest" : "2025/4788/P", "null" : "0", "top" : [ { "item" : "2015/5085/P", "count" : "2" }, { "item" : "2013/7989/P", "count" : "2" }, { "item" : "2010/0542/P", "count" : "1" }, { "item" : "2010/0725/P", "count" : "1" }, { "item" : "2010/0834/P", "count" : "1" }, { "item" : "2010/0878/P", "count" : "1" }, { "item" : "2010/0915/P", "count" : "1" }, { "item" : "2010/1657/P", "count" : "1" }, { "item" : "2010/1012/P", "count" : "1" }, { "item" : "2010/1224/P", "count" : "1" }, { "item" : "2010/1338/P", "count" : "1" }, { "item" : "2010/1346/P", "count" : "1" }, { "item" : "2010/1407/P", "count" : "1" }, { "item" : "2010/1408/L", "count" : "1" }, { "item" : "2010/1508/P", "count" : "1" }, { "item" : "2010/0898/P", "count" : "1" }, { "item" : "2010/1677/P", "count" : "1" }, { "item" : "2010/1960/P", "count" : "1" }, { "item" : "2010/2198/P", "count" : "1" }, { "item" : "2010/0557/P", "count" : "1" } ], "smallest" : "2010/0479/P", "count" : "736", "cardinality" : "736" }, "format" : { "align" : "left" } }, { "id" : 27121697, "name" : "Development Address", "dataTypeName" : "text", "description" : "", "fieldName" : "development_address", "position" : 3, "renderTypeName" : "text", "tableColumnId" : 200914, "width" : 328, "cachedContents" : { "non_null" : "736", "largest" : "Upper Maisonette 51 Hollycroft Avenue London NW3 7QJ", "null" : "0", "top" : [ { "item" : "24 Heath Drive London NW3 7SB", "count" : "16" }, { "item" : "14 Templewood Avenue London NW3 7XA", "count" : "16" }, { "item" : "41 Frognal London NW3 6YD", "count" : "9" }, { "item" : "8 Frognal Lane London NW3 7DU", "count" : "8" }, { "item" : "14 Greenaway Gardens London NW3 7DH", "count" : "7" }, { "item" : "25 Oakhill Avenue London NW3 7RD", "count" : "6" }, { "item" : "4 Templewood Avenue London NW3 7XA", "count" : "5" }, { "item" : "Ground and basement flat 9 Templewood Avenue London NW3 7UY", "count" : "5" }, { "item" : "38 Frognal Lane London NW3 6PP", "count" : "5" }, { "item" : "University College School Frognal London NW3 6XH", "count" : "5" }, { "item" : "21 Rosecroft Avenue London NW3 7QA", "count" : "5" }, { "item" : "5 Templewood Avenue London NW3 7UY", "count" : "4" }, { "item" : "66 Redington Road London NW3 7RS", "count" : "4" }, { "item" : "61 Redington Road London NW3 7RP", "count" : "4" }, { "item" : "28 Redington Road London NW3 7RB", "count" : "4" }, { "item" : "25B Frognal London NW3 6AR", "count" : "4" }, { "item" : "41 Frognal London NW3 6YD", "count" : "4" }, { "item" : "36 Heath Drive London NW3 7SD", "count" : "4" }, { "item" : "2 Templewood Avenue London NW3 7XA", "count" : "4" }, { "item" : "11 Templewood Avenue London NW3 7UY", "count" : "4" } ], "smallest" : "10 A Heath Drive London NW3 7SN", "count" : "736", "cardinality" : "736" }, "format" : { "align" : "left" } }, { "id" : 27121698, "name" : "Development Description", "dataTypeName" : "text", "description" : "", "fieldName" : "development_description", "position" : 4, "renderTypeName" : "text", "tableColumnId" : 200915, "width" : 376, "cachedContents" : { "non_null" : "736", "largest" : "Works to the basement including the installation of new windows to the side and rear, a rear extension, excavation of an additional basement area and a lightwell to the front in association with the change of use from three to two self-contained flats", "null" : "0", "top" : [ { "item" : "Excavation of a new basement floor beneath the existing garage/plant rooms to the east side of the building, and subterranean extension beneath the rear garden with light-well with metal grille to the rear.", "count" : "4" }, { "item" : "Removal of existing curved roof form and open metal canopy to eastern wing. Erection of extension at first floor level to eastern wing. Installation of plant and ASHP within existing sunken garden area. Refurbishment and works to retained Listed swimming pool to enable re-use as swimming pool. Associated landscaping including reinstatement of earth mound around retained swimming pool building.", "count" : "2" }, { "item" : "Amalgamation of two self-contained flats into single dwelling, basement excavation and demolition of existing rear extension to provide a new two-storey extension over lower ground and ground floor levels, and associated internal alterations.", "count" : "2" }, { "item" : "Erection of single storey glazed extension to swimming pool at rear of existing single dwelling (Class C3).", "count" : "2" }, { "item" : "Excavation of (part) basement and erection of single storey ground floor level rear extension with glazed roof following demolition of existing single storey rear ground floor level extension with glazed roof of existing single family dwelling (Class C3).", "count" : "2" }, { "item" : "Installation of new windows, rooflight and an external door within existing rear ground floor extension.", "count" : "2" }, { "item" : "Construction of First floor rear extension and single storey rear extension with flat roof terrace. Alterations to fenestration on all elevations. Alterations to internal layout.", "count" : "2" }, { "item" : "Demolition of 2 storey side garage and utility room; lowering of the ground levels of the existing basement and new basement extension; erection of single storey garage replacement; part double, part single storey side extension to north east elevation; erection of 1 x side dormer and roof lights; and internal alterations.", "count" : "2" }, { "item" : "Erection of external balconies on the rear elevation at ground and first floor levels. Erection of a single storey rear extension with raised timber deck terrace to the lower ground floor flat (Class C3).", "count" : "2" }, { "item" : "Erection of lower ground floor rear extension.", "count" : "2" }, { "item" : "Alteration and extension to The Lodge building (Use Class D1) including landscape works.", "count" : "2" }, { "item" : "Excavation of new basement level; erection of 2 storey extension to south east corner of the site to join the south and east wings; erection of new lift/stairwell to the eastern elevation of the south wing up to third floor level, extension of south wing 3rd floor level; installation of car lift to east elevation; refurbishment of listed swimming pool and associated landscaping.", "count" : "2" }, { "item" : "Extension at first floor level above garage and to the rear, extension to provide a rear ground floor level conservatory, alterations to roof of ground floor level extension, raising height of roof of dwelling house (Class C3).", "count" : "2" }, { "item" : "First floor extension to 'Kent building' to provide additional floorspace for Sixth Form Centre (Class D1)", "count" : "2" }, { "item" : "Erection of a roof extension", "count" : "2" }, { "item" : "Alterations and extensions including excavation of basement floor and installation of 3 light wells; extensions to the roof, front, side and rear elevations at lower ground, ground, first and second floor levels, alterations to fenestration and installation of rooflights and new dormers at second floor level of existing dwelling house (Class C3)", "count" : "2" }, { "item" : "Creation of a rear extension following the removal of the non-original bay window.", "count" : "2" }, { "item" : "Demolition and relocation of the Grade II listed swimming pool to the north west of the garden, associated excavation of the garden level and ground floor/basement infill extension to the house.", "count" : "2" }, { "item" : "Erection of extension over existing roof terrace.", "count" : "2" }, { "item" : "Single storey rear extension to lower ground floor flat.", "count" : "2" } ], "smallest" : "Additions and alterations including enlargement of front (West) ground floor extension, addition of new single storey extension to East elevation and alterations to windows and doors throughout, to residential dwelling (Class C3).", "count" : "736", "cardinality" : "736" }, "format" : { "align" : "left" } }, { "id" : 27121699, "name" : "Decision Type", "dataTypeName" : "text", "description" : "", "fieldName" : "decision_type", "position" : 5, "renderTypeName" : "text", "tableColumnId" : 200916, "width" : 256, "cachedContents" : { "non_null" : "726", "largest" : "Withdrawn Decision", "null" : "10", "top" : [ { "item" : "Granted", "count" : "537" }, { "item" : "Granted Subject to a Section 106 Legal Agreement", "count" : "78" }, { "item" : "Withdrawn Decision", "count" : "58" }, { "item" : "Refused", "count" : "45" }, { "item" : "Refused and Warning of Enforcement Action to be Taken", "count" : "4" }, { "item" : "Part Granted/Refused", "count" : "2" }, { "item" : "Deemed Consent - No Objection", "count" : "1" }, { "item" : "No Objection to Works to Tree(s) in CA", "count" : "1" } ], "smallest" : "Deemed Consent - No Objection", "count" : "736", "cardinality" : "736" }, "format" : { "align" : "left" } }, { "id" : 27121700, "name" : "Registered Date", "dataTypeName" : "calendar_date", "description" : "", "fieldName" : "registered_date", "position" : 6, "rdfProperties" : "", "renderTypeName" : "calendar_date", "tableColumnId" : 200917, "width" : 280, "cachedContents" : { "non_null" : "736", "largest" : "2025-10-28T00:00:00.000", "null" : "0", "top" : [ { "item" : "2015-07-22T00:00:00.000", "count" : "5" }, { "item" : "2024-01-05T00:00:00.000", "count" : "4" }, { "item" : "2011-03-30T00:00:00.000", "count" : "4" }, { "item" : "2016-07-21T00:00:00.000", "count" : "3" }, { "item" : "2020-10-13T00:00:00.000", "count" : "3" }, { "item" : "2022-02-11T00:00:00.000", "count" : "3" }, { "item" : "2019-04-01T00:00:00.000", "count" : "3" }, { "item" : "2016-09-05T00:00:00.000", "count" : "3" }, { "item" : "2010-03-10T00:00:00.000", "count" : "3" }, { "item" : "2018-03-12T00:00:00.000", "count" : "3" }, { "item" : "2019-04-15T00:00:00.000", "count" : "3" }, { "item" : "2020-04-27T00:00:00.000", "count" : "3" }, { "item" : "2013-08-09T00:00:00.000", "count" : "3" }, { "item" : "2018-01-31T00:00:00.000", "count" : "3" }, { "item" : "2019-04-12T00:00:00.000", "count" : "3" }, { "item" : "2014-09-08T00:00:00.000", "count" : "3" }, { "item" : "2016-05-25T00:00:00.000", "count" : "3" }, { "item" : "2012-11-13T00:00:00.000", "count" : "2" }, { "item" : "2012-09-28T00:00:00.000", "count" : "2" }, { "item" : "2012-12-27T00:00:00.000", "count" : "2" } ], "smallest" : "2010-02-05T00:00:00.000", "count" : "736", "cardinality" : "736" }, "format" : { "view" : "date_dmy", "rdf" : "", "align" : "left" } }, { "id" : 27121701, "name" : "Registered In Last 7 Working Days", "dataTypeName" : "text", "description" : "", "fieldName" : "registered_in_last_7_working_days", "position" : 7, "renderTypeName" : "text", "tableColumnId" : 217097, "width" : 100, "cachedContents" : { "non_null" : "736", "largest" : "No", "null" : "0", "top" : [ { "item" : "No", "count" : "736" } ], "smallest" : "No", "count" : "736", "cardinality" : "736" }, "format" : { } }, { "id" : 27121702, "name" : "Registered In Last 28 Working Days", "dataTypeName" : "text", "description" : "", "fieldName" : "registered_in_last_28_working_days", "position" : 8, "renderTypeName" : "text", "tableColumnId" : 291124, "width" : 100, "cachedContents" : { "non_null" : "736", "largest" : "Yes", "null" : "0", "top" : [ { "item" : "No", "count" : "735" }, { "item" : "Yes", "count" : "1" } ], "smallest" : "No", "count" : "736", "cardinality" : "736" }, "format" : { } }, { "id" : 27121703, "name" : "Earliest Decision Date", "dataTypeName" : "calendar_date", "description" : "", "fieldName" : "earliest_decision_date", "position" : 9, "renderTypeName" : "calendar_date", "tableColumnId" : 200919, "width" : 364, "cachedContents" : { "non_null" : "696", "largest" : "2025-11-23T00:00:00.000", "null" : "40", "top" : [ { "item" : "2011-04-28T00:00:00.000", "count" : "6" }, { "item" : "2015-08-20T00:00:00.000", "count" : "5" }, { "item" : "2012-10-25T00:00:00.000", "count" : "4" }, { "item" : "2023-12-20T00:00:00.000", "count" : "4" }, { "item" : "2015-08-06T00:00:00.000", "count" : "3" }, { "item" : "2010-04-09T00:00:00.000", "count" : "3" }, { "item" : "2021-12-05T00:00:00.000", "count" : "3" }, { "item" : "2011-02-17T00:00:00.000", "count" : "3" }, { "item" : "2016-07-19T00:00:00.000", "count" : "3" }, { "item" : "2019-05-12T00:00:00.000", "count" : "3" }, { "item" : "2014-12-18T00:00:00.000", "count" : "3" }, { "item" : "2015-11-17T00:00:00.000", "count" : "3" }, { "item" : "2022-03-13T00:00:00.000", "count" : "3" }, { "item" : "2012-09-20T00:00:00.000", "count" : "3" }, { "item" : "2013-08-30T00:00:00.000", "count" : "3" }, { "item" : "2013-12-12T00:00:00.000", "count" : "3" }, { "item" : "2012-06-14T00:00:00.000", "count" : "2" }, { "item" : "2012-05-03T00:00:00.000", "count" : "2" }, { "item" : "2010-04-08T00:00:00.000", "count" : "2" }, { "item" : "2012-06-07T00:00:00.000", "count" : "2" } ], "smallest" : "2010-03-09T00:00:00.000", "count" : "736", "cardinality" : "736" }, "format" : { "view" : "date_dmy", "align" : "left" } }, { "id" : 27121704, "name" : "Decision Date", "dataTypeName" : "calendar_date", "description" : "", "fieldName" : "decision_date", "position" : 10, "renderTypeName" : "calendar_date", "tableColumnId" : 200918, "width" : 256, "cachedContents" : { "non_null" : "726", "largest" : "2025-11-13T00:00:00.000", "null" : "10", "top" : [ { "item" : "2013-09-25T00:00:00.000", "count" : "5" }, { "item" : "2016-04-06T00:00:00.000", "count" : "4" }, { "item" : "2018-10-11T00:00:00.000", "count" : "4" }, { "item" : "2014-06-02T00:00:00.000", "count" : "4" }, { "item" : "2015-03-17T00:00:00.000", "count" : "3" }, { "item" : "2010-04-20T00:00:00.000", "count" : "3" }, { "item" : "2023-07-12T00:00:00.000", "count" : "3" }, { "item" : "2016-02-04T00:00:00.000", "count" : "3" }, { "item" : "2011-05-17T00:00:00.000", "count" : "3" }, { "item" : "2012-10-05T00:00:00.000", "count" : "3" }, { "item" : "2014-01-13T00:00:00.000", "count" : "3" }, { "item" : "2024-01-30T00:00:00.000", "count" : "3" }, { "item" : "2012-05-14T00:00:00.000", "count" : "2" }, { "item" : "2010-04-27T00:00:00.000", "count" : "2" }, { "item" : "2012-07-13T00:00:00.000", "count" : "2" }, { "item" : "2011-11-22T00:00:00.000", "count" : "2" }, { "item" : "2011-05-27T00:00:00.000", "count" : "2" }, { "item" : "2012-04-18T00:00:00.000", "count" : "2" }, { "item" : "2012-09-24T00:00:00.000", "count" : "2" }, { "item" : "2011-03-21T00:00:00.000", "count" : "2" } ], "smallest" : "2010-03-23T00:00:00.000", "count" : "736", "cardinality" : "736" }, "format" : { "view" : "date_dmy", "align" : "left" } }, { "id" : 27121705, "name" : "Decision Level", "dataTypeName" : "text", "description" : "", "fieldName" : "decison_level", "position" : 11, "renderTypeName" : "text", "tableColumnId" : 200920, "width" : 256, "cachedContents" : { "non_null" : "726", "largest" : "Withdrawn-Council", "null" : "10", "top" : [ { "item" : "Delegated", "count" : "502" }, { "item" : "Members Briefing", "count" : "148" }, { "item" : "Withdrawn", "count" : "42" }, { "item" : "Development Control Committee", "count" : "19" }, { "item" : "Withdrawn-Council", "count" : "11" }, { "item" : "Awaiting Legal Agreement", "count" : "3" }, { "item" : "Government Office for London", "count" : "1" } ], "smallest" : "Awaiting Legal Agreement", "count" : "736", "cardinality" : "736" }, "format" : { "align" : "left" } }, { "id" : 27121706, "name" : "System Status", "dataTypeName" : "text", "description" : "", "fieldName" : "system_status", "position" : 12, "renderTypeName" : "text", "tableColumnId" : 200921, "width" : 256, "cachedContents" : { "non_null" : "736", "largest" : "Withdrawn", "null" : "0", "top" : [ { "item" : "Final Decision", "count" : "643" }, { "item" : "Withdrawn", "count" : "58" }, { "item" : "Appeal Decided", "count" : "25" }, { "item" : "Registered", "count" : "10" } ], "smallest" : "Appeal Decided", "count" : "736", "cardinality" : "736" }, "format" : { "align" : "left" } }, { "id" : 27121707, "name" : "System Status Change Date", "dataTypeName" : "calendar_date", "description" : "", "fieldName" : "system_status_change_date", "position" : 13, "renderTypeName" : "calendar_date", "tableColumnId" : 257996, "width" : 100, "cachedContents" : { "non_null" : "736", "largest" : "2025-11-13T00:00:00.000", "null" : "0", "top" : [ { "item" : "2013-09-25T00:00:00.000", "count" : "5" }, { "item" : "2018-10-11T00:00:00.000", "count" : "4" }, { "item" : "2014-06-02T00:00:00.000", "count" : "4" }, { "item" : "2016-04-06T00:00:00.000", "count" : "4" }, { "item" : "2025-04-24T00:00:00.000", "count" : "3" }, { "item" : "2012-10-05T00:00:00.000", "count" : "3" }, { "item" : "2024-01-30T00:00:00.000", "count" : "3" }, { "item" : "2011-05-17T00:00:00.000", "count" : "3" }, { "item" : "2016-02-04T00:00:00.000", "count" : "3" }, { "item" : "2015-03-09T00:00:00.000", "count" : "3" }, { "item" : "2010-04-20T00:00:00.000", "count" : "3" }, { "item" : "2015-03-17T00:00:00.000", "count" : "3" }, { "item" : "2023-07-12T00:00:00.000", "count" : "3" }, { "item" : "2014-01-13T00:00:00.000", "count" : "3" }, { "item" : "2012-04-18T00:00:00.000", "count" : "2" }, { "item" : "2010-04-30T00:00:00.000", "count" : "2" }, { "item" : "2012-05-14T00:00:00.000", "count" : "2" }, { "item" : "2010-04-19T00:00:00.000", "count" : "2" }, { "item" : "2010-04-27T00:00:00.000", "count" : "2" }, { "item" : "2011-12-20T00:00:00.000", "count" : "2" } ], "smallest" : "2010-03-23T00:00:00.000", "count" : "736", "cardinality" : "736" }, "format" : { "view" : "date_dmy", "align" : "left" } }, { "id" : 27121708, "name" : "Applicant Name", "dataTypeName" : "text", "description" : "", "fieldName" : "applicant_name", "position" : 14, "renderTypeName" : "text", "tableColumnId" : 200922, "width" : 268, "cachedContents" : { "non_null" : "736", "largest" : "Worship Construction Ltd", "null" : "0", "top" : [ { "item" : "Mr Marco Liberace", "count" : "10" }, { "item" : "Mr Danylo Knysh", "count" : "9" }, { "item" : ".", "count" : "9" }, { "item" : "Mr & Mrs Natsis", "count" : "8" }, { "item" : "Mr ABHAY RUPARELL", "count" : "6" }, { "item" : "Mr & Mrs Theo Duchen", "count" : "6" }, { "item" : "Mr Benjamin Khalili", "count" : "5" }, { "item" : "Renough Limited", "count" : "5" }, { "item" : "C/O Agent", "count" : "5" }, { "item" : "Mr and Mrs Sassoon", "count" : "5" }, { "item" : "Mr Andrew Kirk", "count" : "5" }, { "item" : "Mr Simon Sterling", "count" : "5" }, { "item" : "Mr Bryan Coyne", "count" : "4" }, { "item" : "Lauren Shahmoon", "count" : "4" }, { "item" : "Mr Clive Truman", "count" : "4" }, { "item" : "Mr Manoj Bharwani", "count" : "4" }, { "item" : "Mr Mener Tsitsis", "count" : "4" }, { "item" : "Mr and Mrs Anthony Fobel", "count" : "4" }, { "item" : "Mr Jeremy Sokel", "count" : "4" }, { "item" : "Mr Daniel Shaw", "count" : "4" } ], "smallest" : "-", "count" : "736", "cardinality" : "736" }, "format" : { "align" : "left" } }, { "id" : 27121709, "name" : "Ward", "dataTypeName" : "text", "description" : "", "fieldName" : "ward", "position" : 15, "renderTypeName" : "text", "tableColumnId" : 200923, "width" : 148, "cachedContents" : { "non_null" : "736", "largest" : "Frognal & Fitzjohns (Pre May 2022);Hampstead Town (Pre May 2022)", "null" : "0", "top" : [ { "item" : "Frognal & Fitzjohns (Pre May 2022)", "count" : "596" }, { "item" : "Frognal", "count" : "138" }, { "item" : "Belsize;Frognal;Frognal & Fitzjohns (Pre May 2022)", "count" : "1" }, { "item" : "Frognal & Fitzjohns (Pre May 2022);Hampstead Town (Pre May 2022)", "count" : "1" } ], "smallest" : "Belsize;Frognal;Frognal & Fitzjohns (Pre May 2022)", "count" : "736", "cardinality" : "736" }, "format" : { "align" : "left" } }, { "id" : 27121710, "name" : "Conservation Areas", "dataTypeName" : "text", "description" : "", "fieldName" : "conservation_areas", "position" : 16, "renderTypeName" : "text", "tableColumnId" : 257997, "width" : 100, "cachedContents" : { "non_null" : "730", "largest" : "Redington Frognal;Redington Frognal;Redington Frognal", "null" : "6", "top" : [ { "item" : "Redington Frognal", "count" : "689" }, { "item" : "Redington Frognal;Redington Frognal", "count" : "24" }, { "item" : "Redington Frognal;Redington/Frognal", "count" : "5" }, { "item" : "Hampstead;Redington Frognal", "count" : "5" }, { "item" : "Redington Frognal;Redington Frognal;Redington Frognal", "count" : "3" }, { "item" : "Hampstead", "count" : "2" }, { "item" : "Fitzjohns Netherhall;Redington Frognal;Redington Frognal", "count" : "1" }, { "item" : "Fitzjohns Netherhall;Redington Frognal", "count" : "1" } ], "smallest" : "Fitzjohns Netherhall;Redington Frognal", "count" : "736", "cardinality" : "736" }, "format" : { } }, { "id" : 27121711, "name" : "Case Officer", "dataTypeName" : "text", "description" : "", "fieldName" : "case_officer", "position" : 17, "renderTypeName" : "text", "tableColumnId" : 200926, "width" : 244, "cachedContents" : { "non_null" : "736", "largest" : "Zenab Haji-Ismail", "null" : "0", "top" : [ { "item" : "Obote Hope", "count" : "51" }, { "item" : "Laura Dorbeck", "count" : "28" }, { "item" : "Aysegul Olcar-Chamberlin", "count" : "20" }, { "item" : "Josh Lawlor", "count" : "18" }, { "item" : "Seonaid Carr", "count" : "18" }, { "item" : "David Peres Da Costa", "count" : "17" }, { "item" : "Sam Fowler", "count" : "16" }, { "item" : "Nicola Tulley", "count" : "15" }, { "item" : "Raymond Yeung", "count" : "14" }, { "item" : "Tessa Craig", "count" : "14" }, { "item" : "Alyce Keen", "count" : "14" }, { "item" : "Ewan Campbell", "count" : "13" }, { "item" : "Rob Tulloch", "count" : "13" }, { "item" : "Lauren Ford", "count" : "12" }, { "item" : "Adam Greenhalgh", "count" : "12" }, { "item" : "Daren Zuk", "count" : "12" }, { "item" : "Rachael Parry", "count" : "11" }, { "item" : "Joshua Ogunleye", "count" : "11" }, { "item" : "Brendan Versluys", "count" : "11" }, { "item" : "Elaine Quigley", "count" : "11" } ], "smallest" : "Adam Afford", "count" : "736", "cardinality" : "736" }, "format" : { "align" : "left" } }, { "id" : 27121712, "name" : "Case Officer Team", "dataTypeName" : "text", "description" : "", "fieldName" : "case_officer_team", "position" : 18, "renderTypeName" : "text", "tableColumnId" : 200927, "width" : 304, "cachedContents" : { "non_null" : "736", "largest" : "West Area Team", "null" : "0", "top" : [ { "item" : "Planning Solutions Team", "count" : "465" }, { "item" : "West Area Team", "count" : "190" }, { "item" : "Validation and Fast Track Team", "count" : "38" }, { "item" : "Appeals and Enforcement Team", "count" : "12" }, { "item" : "Advice and Consultation Team", "count" : "10" }, { "item" : "East Area Team", "count" : "9" }, { "item" : "Urban Design & Renewal.", "count" : "8" }, { "item" : "Backlog Action Plan", "count" : "3" }, { "item" : "DM Legacy Team", "count" : "1" } ], "smallest" : "Advice and Consultation Team", "count" : "736", "cardinality" : "736" }, "format" : { "align" : "left" } }, { "id" : 27121713, "name" : "Responsibility Type", "dataTypeName" : "text", "description" : "", "fieldName" : "responsibility_type", "position" : 19, "renderTypeName" : "text", "tableColumnId" : 200928, "width" : 316, "cachedContents" : { "non_null" : "736", "largest" : "PlanningApplication", "null" : "0", "top" : [ { "item" : "PlanningApplication", "count" : "736" } ], "smallest" : "PlanningApplication", "count" : "736", "cardinality" : "736" }, "format" : { "align" : "left" } }, { "id" : 27121714, "name" : "Comment", "dataTypeName" : "text", "description" : "", "fieldName" : "comment", "position" : 20, "renderTypeName" : "text", "tableColumnId" : 200934, "width" : 184, "cachedContents" : { "non_null" : "736", "largest" : "https://planningrecords.camden.gov.uk/Northgate/PlanningExplorer/PLComments.aspx?pk=667122", "null" : "0", "top" : [ { "item" : "Comments Closed", "count" : "726" }, { "item" : "https://planningrecords.camden.gov.uk/Northgate/PlanningExplorer/PLComments.aspx?pk=632694", "count" : "1" }, { "item" : "https://planningrecords.camden.gov.uk/Northgate/PlanningExplorer/PLComments.aspx?pk=644627", "count" : "1" }, { "item" : "https://planningrecords.camden.gov.uk/Northgate/PlanningExplorer/PLComments.aspx?pk=652265", "count" : "1" }, { "item" : "https://planningrecords.camden.gov.uk/Northgate/PlanningExplorer/PLComments.aspx?pk=656025", "count" : "1" }, { "item" : "https://planningrecords.camden.gov.uk/Northgate/PlanningExplorer/PLComments.aspx?pk=656984", "count" : "1" }, { "item" : "https://planningrecords.camden.gov.uk/Northgate/PlanningExplorer/PLComments.aspx?pk=657007", "count" : "1" }, { "item" : "https://planningrecords.camden.gov.uk/Northgate/PlanningExplorer/PLComments.aspx?pk=657161", "count" : "1" }, { "item" : "https://planningrecords.camden.gov.uk/Northgate/PlanningExplorer/PLComments.aspx?pk=662009", "count" : "1" }, { "item" : "https://planningrecords.camden.gov.uk/Northgate/PlanningExplorer/PLComments.aspx?pk=665146", "count" : "1" }, { "item" : "https://planningrecords.camden.gov.uk/Northgate/PlanningExplorer/PLComments.aspx?pk=667122", "count" : "1" } ], "smallest" : "Comments Closed", "count" : "736", "cardinality" : "736" }, "format" : { "align" : "left" } }, { "id" : 27121715, "name" : "Full Application", "dataTypeName" : "url", "description" : "", "fieldName" : "full_application", "position" : 21, "renderTypeName" : "url", "tableColumnId" : 200931, "width" : 316, "format" : { "align" : "left" }, "subColumnTypes" : [ "url", "description" ] }, { "id" : 27121716, "name" : "Application Type", "dataTypeName" : "text", "description" : "", "fieldName" : "application_type", "position" : 22, "renderTypeName" : "text", "tableColumnId" : 200932, "width" : 148, "cachedContents" : { "non_null" : "736", "largest" : "Variation or Removal of Condition(s)", "null" : "0", "top" : [ { "item" : "Full Planning Permission", "count" : "231" }, { "item" : "Householder Application", "count" : "208" }, { "item" : "Approval of Details", "count" : "132" }, { "item" : "Variation or Removal of Condition(s)", "count" : "50" }, { "item" : "Listed Building Consent", "count" : "40" }, { "item" : "Non Material Amendments", "count" : "30" }, { "item" : "Certificate of Lawfulness (Proposed)", "count" : "20" }, { "item" : "Approval of Details (Listed Building)", "count" : "11" }, { "item" : "Approval of Reserved Matters", "count" : "5" }, { "item" : "Certificate of Lawfulness (Existing)", "count" : "4" }, { "item" : "Renewal of Full Planning Permission", "count" : "2" }, { "item" : "Notification of Intended Works to Tree(s) in a Conservation Area", "count" : "1" }, { "item" : "Listed Building Consent (Demolition)", "count" : "1" }, { "item" : "Request for Observations to Adjoining Borough", "count" : "1" } ], "smallest" : "Approval of Details", "count" : "736", "cardinality" : "736" }, "format" : { "align" : "left" } }, { "id" : 27121717, "name" : "Easting", "dataTypeName" : "number", "description" : "", "fieldName" : "easting", "position" : 23, "renderTypeName" : "number", "tableColumnId" : 200924, "width" : 196, "cachedContents" : { "non_null" : "736", "largest" : "526395", "null" : "0", "top" : [ { "item" : "525347", "count" : "19" }, { "item" : "525834", "count" : "17" }, { "item" : "525661", "count" : "17" }, { "item" : "526123", "count" : "14" }, { "item" : "526202", "count" : "11" }, { "item" : "525805", "count" : "10" }, { "item" : "525802", "count" : "10" }, { "item" : "525422", "count" : "10" }, { "item" : "525692", "count" : "9" }, { "item" : "525736", "count" : "9" }, { "item" : "526078", "count" : "8" }, { "item" : "525315", "count" : "7" }, { "item" : "525815", "count" : "7" }, { "item" : "525559", "count" : "7" }, { "item" : "525738", "count" : "7" }, { "item" : "525484", "count" : "7" }, { "item" : "525771", "count" : "7" }, { "item" : "526007", "count" : "7" }, { "item" : "525561", "count" : "6" }, { "item" : "525628", "count" : "6" } ], "smallest" : "525083", "count" : "736", "cardinality" : "736" }, "format" : { "precisionStyle" : "standard", "noCommas" : "false", "align" : "right" } }, { "id" : 27121718, "name" : "Northing", "dataTypeName" : "number", "description" : "", "fieldName" : "northing", "position" : 24, "renderTypeName" : "number", "tableColumnId" : 200925, "width" : 208, "cachedContents" : { "non_null" : "736", "largest" : "186380", "null" : "0", "top" : [ { "item" : "185846", "count" : "21" }, { "item" : "185813", "count" : "18" }, { "item" : "186166", "count" : "17" }, { "item" : "185365", "count" : "14" }, { "item" : "185414", "count" : "12" }, { "item" : "185377", "count" : "10" }, { "item" : "186220", "count" : "10" }, { "item" : "186028", "count" : "9" }, { "item" : "185597", "count" : "9" }, { "item" : "185624", "count" : "9" }, { "item" : "186121", "count" : "8" }, { "item" : "186358", "count" : "8" }, { "item" : "185388", "count" : "8" }, { "item" : "185464", "count" : "7" }, { "item" : "186157", "count" : "7" }, { "item" : "185752", "count" : "7" }, { "item" : "185546", "count" : "7" }, { "item" : "185762", "count" : "7" }, { "item" : "185875", "count" : "7" }, { "item" : "186366", "count" : "7" } ], "smallest" : "184162", "count" : "736", "cardinality" : "736" }, "format" : { "precisionStyle" : "standard", "noCommas" : "false", "align" : "right" } }, { "id" : 27121719, "name" : "Longitude", "dataTypeName" : "number", "description" : "", "fieldName" : "longitude", "position" : 25, "renderTypeName" : "number", "tableColumnId" : 217095, "width" : 100, "cachedContents" : { "non_null" : "736", "largest" : "-0.178336", "null" : "0", "top" : [ { "item" : "-0.193254", "count" : "19" }, { "item" : "-0.188738", "count" : "17" }, { "item" : "-0.186118", "count" : "17" }, { "item" : "-0.182238", "count" : "14" }, { "item" : "-0.181082", "count" : "11" }, { "item" : "-0.186818", "count" : "10" }, { "item" : "-0.192039", "count" : "10" }, { "item" : "-0.18758", "count" : "9" }, { "item" : "-0.186783", "count" : "9" }, { "item" : "-0.182879", "count" : "8" }, { "item" : "-0.188097", "count" : "8" }, { "item" : "-0.191308", "count" : "7" }, { "item" : "-0.18632", "count" : "7" }, { "item" : "-0.18765", "count" : "7" }, { "item" : "-0.190304", "count" : "7" }, { "item" : "-0.183875", "count" : "7" }, { "item" : "-0.18703", "count" : "6" }, { "item" : "-0.187015", "count" : "6" }, { "item" : "-0.188892", "count" : "6" }, { "item" : "-0.193629", "count" : "5" } ], "smallest" : "-0.196987", "count" : "736", "cardinality" : "736" }, "format" : { } }, { "id" : 27121720, "name" : "Latitude", "dataTypeName" : "number", "description" : "", "fieldName" : "latitude", "position" : 26, "renderTypeName" : "number", "tableColumnId" : 217096, "width" : 100, "cachedContents" : { "non_null" : "736", "largest" : "51.562319", "null" : "0", "top" : [ { "item" : "51.557582", "count" : "19" }, { "item" : "51.560349", "count" : "17" }, { "item" : "51.557215", "count" : "17" }, { "item" : "51.553086", "count" : "14" }, { "item" : "51.55665", "count" : "11" }, { "item" : "51.559131", "count" : "11" }, { "item" : "51.553509", "count" : "11" }, { "item" : "51.560926", "count" : "10" }, { "item" : "51.553265", "count" : "10" }, { "item" : "51.555243", "count" : "9" }, { "item" : "51.562106", "count" : "8" }, { "item" : "51.553303", "count" : "8" }, { "item" : "51.554838", "count" : "7" }, { "item" : "51.556796", "count" : "7" }, { "item" : "51.554002", "count" : "7" }, { "item" : "51.554887", "count" : "7" }, { "item" : "51.559045", "count" : "7" }, { "item" : "51.562151", "count" : "7" }, { "item" : "51.560282", "count" : "6" }, { "item" : "51.555518", "count" : "6" } ], "smallest" : "51.542338", "count" : "736", "cardinality" : "736" }, "format" : { } }, { "id" : 27121721, "name" : "Spatial Accuracy", "dataTypeName" : "text", "description" : "", "fieldName" : "spatial_accuracy", "position" : 27, "renderTypeName" : "text", "tableColumnId" : 217088, "width" : 100, "cachedContents" : { "non_null" : "736", "largest" : "Plotted by Camden Officer", "null" : "0", "top" : [ { "item" : "Plotted by Camden Officer", "count" : "736" } ], "smallest" : "Plotted by Camden Officer", "count" : "736", "cardinality" : "736" }, "format" : { } }, { "id" : 27121722, "name" : "Last Uploaded", "dataTypeName" : "calendar_date", "description" : "", "fieldName" : "last_uploaded", "position" : 28, "renderTypeName" : "calendar_date", "tableColumnId" : 217089, "width" : 100, "cachedContents" : { "non_null" : "736", "largest" : "2025-11-24T16:50:31.000", "null" : "0", "top" : [ { "item" : "2025-11-24T16:50:25.000", "count" : "98" }, { "item" : "2025-11-24T16:50:27.000", "count" : "92" }, { "item" : "2025-11-24T16:50:22.000", "count" : "88" }, { "item" : "2025-11-24T16:50:29.000", "count" : "78" }, { "item" : "2025-11-24T16:50:26.000", "count" : "78" }, { "item" : "2025-11-24T16:50:28.000", "count" : "78" }, { "item" : "2025-11-24T16:50:24.000", "count" : "72" }, { "item" : "2025-11-24T16:50:30.000", "count" : "69" }, { "item" : "2025-11-24T16:50:23.000", "count" : "67" }, { "item" : "2025-11-24T16:50:31.000", "count" : "12" }, { "item" : "2025-11-24T16:50:21.000", "count" : "4" } ], "smallest" : "2025-11-24T16:50:21.000", "count" : "736", "cardinality" : "736" }, "format" : { "view" : "date_dmy", "align" : "left" } }, { "id" : 27121724, "name" : "Socrata ID", "dataTypeName" : "number", "description" : "", "fieldName" : "socrata_id", "position" : 30, "renderTypeName" : "number", "tableColumnId" : 217090, "width" : 100, "cachedContents" : { "non_null" : "736", "largest" : "78638", "null" : "0", "top" : [ { "item" : "13", "count" : "1" }, { "item" : "34", "count" : "1" }, { "item" : "93", "count" : "1" }, { "item" : "342", "count" : "1" }, { "item" : "343", "count" : "1" }, { "item" : "345", "count" : "1" }, { "item" : "585", "count" : "1" }, { "item" : "593", "count" : "1" }, { "item" : "694", "count" : "1" }, { "item" : "736", "count" : "1" }, { "item" : "849", "count" : "1" }, { "item" : "881", "count" : "1" }, { "item" : "921", "count" : "1" }, { "item" : "978", "count" : "1" }, { "item" : "1097", "count" : "1" }, { "item" : "1249", "count" : "1" }, { "item" : "1291", "count" : "1" }, { "item" : "1306", "count" : "1" }, { "item" : "1403", "count" : "1" }, { "item" : "12", "count" : "1" } ], "smallest" : "12", "count" : "736", "cardinality" : "736" }, "format" : { } } ], "grants" : [ { "inherited" : false, "type" : "viewer", "flags" : [ "public" ] } ], "license" : { "name" : "UK Open Government Licence v3", "logoUrl" : "images/licenses/ogl.png", "termsLink" : "http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/" }, "metadata" : { "rdfSubject" : "0", "richRendererConfigs" : { "page" : { "columns" : [ { "styles" : { "width" : "100%" }, "rows" : [ { "fields" : [ { "tableColumnId" : 200913, "type" : "columnLabel" }, { "tableColumnId" : 200913, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200914, "type" : "columnLabel" }, { "tableColumnId" : 200914, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200915, "type" : "columnLabel" }, { "tableColumnId" : 200915, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200916, "type" : "columnLabel" }, { "tableColumnId" : 200916, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200917, "type" : "columnLabel" }, { "tableColumnId" : 200917, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200918, "type" : "columnLabel" }, { "tableColumnId" : 200918, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200919, "type" : "columnLabel" }, { "tableColumnId" : 200919, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200920, "type" : "columnLabel" }, { "tableColumnId" : 200920, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200921, "type" : "columnLabel" }, { "tableColumnId" : 200921, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200922, "type" : "columnLabel" }, { "tableColumnId" : 200922, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200923, "type" : "columnLabel" }, { "tableColumnId" : 200923, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200924, "type" : "columnLabel" }, { "tableColumnId" : 200924, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200925, "type" : "columnLabel" }, { "tableColumnId" : 200925, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200926, "type" : "columnLabel" }, { "tableColumnId" : 200926, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200927, "type" : "columnLabel" }, { "tableColumnId" : 200927, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200928, "type" : "columnLabel" }, { "tableColumnId" : 200928, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200929, "type" : "columnLabel" }, { "tableColumnId" : 200929, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200930, "type" : "columnLabel" }, { "tableColumnId" : 200930, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200931, "type" : "columnLabel" }, { "tableColumnId" : 200931, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200932, "type" : "columnLabel" }, { "tableColumnId" : 200932, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200933, "type" : "columnLabel" }, { "tableColumnId" : 200933, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200934, "type" : "columnLabel" }, { "tableColumnId" : 200934, "type" : "columnData" } ] }, { "fields" : [ { "tableColumnId" : 200935, "type" : "columnLabel" }, { "tableColumnId" : 200935, "type" : "columnData" } ] } ] } ] } }, "custom_fields" : { "Point of Contact" : { "Address" : "The Crowndale Centre, 218 Eversholt Street", "Telephone" : "020 7974 4444", "Role Name" : "Open Data Administrator", "Organisation Name" : "London Borough of Camden", "City/Town" : "London", "Postcode" : "NW1 1BD", "Directorate" : "Culture and Environment" }, "OS Licence Detail" : { "Licence Type" : "OS OpenData", "Licence Information" : "Data derived from OS products which is free to use under the Open Government Licence. The following statement MUST be included when using this data: Contains OS data © Crown copyright and database right [year]", "Licence URL" : "http://www.ordnancesurvey.co.uk/business-and-government/licensing/using-creating-data-with-os-products/os-opendata.html" }, "Publication" : { "Dataset Language" : "English", "Spatial Reference System" : "EPSG:27700", "Frequency of Update" : "Daily" } }, "availableDisplayTypes" : [ "table", "fatrow", "page" ], "rowLabel" : "Row", "renderTypeConfig" : { "visible" : { "table" : true } } }, "owner" : { "id" : "h62x-z4hv", "displayName" : "Michael Webb", "screenName" : "Michael Webb", "type" : "interactive", "flags" : [ "mayBeStoriesCoOwner" ] }, "query" : { }, "rights" : [ "read" ], "tableAuthor" : { "id" : "6jeh-p2ix", "displayName" : "Open Data Camden", "screenName" : "Open Data Camden", "type" : "interactive", "flags" : [ "acceptedEula", "mayBeStoriesCoOwner" ] }, "tags" : [ "planning", "applications" ], "flags" : [ "calculatedView", "ownerMayBeContacted", "restorable", "restorePossibleForType", "soqlBasedView" ] }