Assets Of Community Value

Leicester City Council

@ukgov.assets_of_community_value5

Table List

1 table(14.76 KB)

Table 1

@ukgov.assets_of_community_value5.table_1

Assets of Community Value (csv)

14.76 KB
11 rows
19 columns

site_uprn Site Uprn	uprn Uprn	site_name Site Name	primary_address Primary Address	city City	postcode Postcode	tenure Tenure	site_type Site Type	operational_status Operational Status	site_main_function_2 Site Main Function 2	site_main_function_3 Site Main Function 3	easting Easting	northing Northing	occupied_by_lcc Occupied By Lcc	diocese Diocese	group Group	ward Ward	date_transferred Date Transferred	lat_long Lat Long
112800000	1128	Newfoundpool Community Centre	Pool Road	Leicester	LE3 9GH	Freehold	Building	Operational	Community Buildings	Community Use	457266	304924	Yes	Operational	Operational Estate	Fosse	Mon Jan 11 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	52.63904820339341, -1.1551816091469183
209100000	2091	Cort Crescent (former Community Centre)	Cort Crescent	Leicester	LE3 1QJ	Freehold	Building	Operational	Community Buildings	Community Use	455411	303475	Yes	Operational	Operational Estate	Braunstone Park & Rowley Fields	Mon Jan 11 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	52.62621561526672, -1.182833567551211
254300000	2543	Braunstone Grove Youth Centre	Cort Crescent	Leicester	LE3 1HZ	Freehold	Building	Operational	Community Buildings	Youth Centre	455486	303813	Yes	Operational	Operational Estate	Braunstone Park & Rowley Fields	Fri Jun 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	52.62924619047079, -1.181669040481667
170900000	1709	African Caribbean Centre	Maidstone Road	Leicester	LE2 0UA	Freehold	Building	Operational	Community Buildings	Community Use	459651	304159		Operational	Operational Estate	Wycliffe	Mon Jan 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	52.6319154535591, -1.1200794409197319
179500000	1795	Home Farm Neighbourhood Centre	Home Farm Close	Leicester	LE4 0SU	Freehold	Land & Building	Operational	Community Buildings	Community Use	457412	307434	Yes	Operational	Operational Estate	Beaumont Leys	Fri Jun 23 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	52.66159448031224, -1.1525883949707325
225600000	2256	Mayfield (Former Children Young People and Family Centres)	Mayfield Road	Leicester	LE2 1LR	Freehold	Land & Building	Operational	Community Buildings	Community Use	460108	303257	Yes	Operational	Operational Estate	Stoneygate	Thu Nov 08 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	52.62375736794801, -1.113491869232231
268600000	2686	Coleman Lodge Community Centre	The Wayne Way	Leicester	LE5 4PP	Freehold	Land & Building	Operational	Community Buildings	Community Centre	461639	304699	Yes	Operational	Operational Estate	North Evington	Mon Dec 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	52.63654759743946, -1.090609705555155
270200000	2702	New Parks (former Community Centre)	St Oswalds Road	Leicester	LE3 6RJ	Freehold	Building	Operational	Community Buildings	Community Use	455524	305434	Yes	Operational	Operational Estate	Western	Thu Sep 21 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	52.6438131574051, -1.1808356388558108
28200000	282	Northfields Neighbourhood Centre	Brighton Road	Leicester	LE5 0HD	Freehold	Building	Operational	Community Buildings	Community Use	460986	305822	Yes	Operational	Operational Estate	North Evington	Thu Dec 20 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	52.646715432795915, -1.1000505255599737
95900000	959	Manor House (former Community Centre)	Haddenham Road	Leicester	LE3 2BG	Freehold	Building	Operational	Community Buildings	Community Use	457355	302710	Yes	Operational	Operational Estate	Braunstone Park & Rowley Fields	Sat Apr 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	52.619137730868495, -1.1542502303142128


CREATE TABLE table_1 (
  "site_uprn" BIGINT,
  "uprn" BIGINT,
  "site_name" VARCHAR,
  "primary_address" VARCHAR,
  "city" VARCHAR,
  "postcode" VARCHAR,
  "tenure" VARCHAR,
  "site_type" VARCHAR,
  "operational_status" VARCHAR,
  "site_main_function_2" VARCHAR,
  "site_main_function_3" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "occupied_by_lcc" VARCHAR,
  "diocese" VARCHAR,
  "group" VARCHAR,
  "ward" VARCHAR,
  "date_transferred" TIMESTAMP,
  "lat_long" VARCHAR
);