Bring Sites

Leeds City Council

@ukgov.bring_sites

Table List

4 tables(635.38 KB)

01/04/2019 - 31/03/2020

01/04/2020 - 31/03/2021

01/04/2016 - 31/03/2019

01/04/2021 - 31/03/2022

01/04/2016 - 31/03/2019

@ukgov.bring_sites.n_01_04_2016_31_03_2019

130.25 KB
404 rows
60 columns

site_name Site Name	address Address	post_code Post Code	location_type Location Type	ward Ward	sticker Sticker	postcode_area Postcode Area	site_number Site Number	uprn UPRN	latitude Latitude	longitude Longitude	y Y	x X	recyclables_mixed_glass Recyclables-Mixed Glass	recyclables_paper Recyclables-Paper	recyclables_textiles Recyclables-Textiles	type Type	tally_of_sites Tally Of Sites	no_of_glass_banks No Of Glass Banks	apr_16_glass_tonnages_kg Apr 16 Glass Tonnages Kg	may_16_glass_tonnages_kg May 16 Glass Tonnages Kg	jun_16_glass_tonnages_kg Jun 16 Glass Tonnages Kg	jul_16_glass_tonnages_kg Jul 16 Glass Tonnages Kg	aug_16_glass_tonnages_kg Aug 16 Glass Tonnages Kg	sep_16_glass_tonnages_kg Sep 16 Glass Tonnages Kg	oct_16_glass_tonnages_kg Oct 16 Glass Tonnages Kg	nov_16_glass_tonnages_kg Nov 16 Glass Tonnages Kg	dec_16_glass_tonnages_kg Dec 16 Glass Tonnages Kg	jan_17_glass_tonnages_kg Jan 17 Glass Tonnages Kg	feb_17_glass_tonnages_kg Feb 17 Glass Tonnages Kg	mar_17_glass_tonnages_kg Mar 17 Glass Tonnages Kg	apr_17_glass_tonnages_kg Apr 17 Glass Tonnages Kg	may_17_glass_tonnages_kg May 17 Glass Tonnages Kg	jun_17_glass_tonnages_kg Jun 17 Glass Tonnages Kg	jul_17_glass_tonnages_kg Jul 17 Glass Tonnages Kg	aug_17_glass_tonnages_kg Aug 17 Glass Tonnages Kg	sep_17_glass_tonnages_kg Sep 17 Glass Tonnages Kg	oct_17_glass_tonnages_kg Oct 17 Glass Tonnages Kg	nov_17_glass_tonnages_kg Nov 17 Glass Tonnages Kg	dec_17_glass_tonnages_kg Dec 17 Glass Tonnages Kg	jan_18_glass_tonnages_kg Jan 18 Glass Tonnages Kg	feb_18_glass_tonnages_kg Feb 18 Glass Tonnages Kg	mar_18_glass_tonnages_kg Mar 18 Glass Tonnages Kg	n_04_18_glass_tonnages_kg 04/18 Glass Tonnages Kg	n_05_18_glass_tonnages_kg 05/18 Glass Tonnages Kg	n_06_18_glass_tonnages_kg 06/18 Glass Tonnages Kg	n_07_18_glass_tonnages_kg 07/18 Glass Tonnages Kg	n_08_18_glass_tonnages_kg 08/18 Glass Tonnages Kg	n_09_18_glass_tonnages_kg 09/18 Glass Tonnages Kg	n_10_18_glass_tonnages_kg 10/18 Glass Tonnages Kg	n_11_18_glass_tonnages_kg 11/18 Glass Tonnages Kg	n_12_18_glass_tonnages_kg 12/18 Glass Tonnages Kg	n_01_19_glass_tonnages_kg 01/19 Glass Tonnages Kg	n_02_19_glass_tonnages_kg 02/19 Glass Tonnages Kg	n_03_19_glass_tonnages_kg 03/19 Glass Tonnages Kg	total_from_apr_19 Total From Apr 19	n_12_month_average 12 Month Average
Armley Conservative Club - Leeds Jazz Club	Armley Ridge Road	LS12 3NU	Social Club	Armley		LS12	21910	72662636	53.798438	-1.59674	433646	426659	Y			Glass	1	1						1652		760	572		597	260	359		699		118	382	117	253	323	189			531	531	621	816	741		903			651			4794	685
Abbey Inn	Pollard Lane	LS13 1EQ	Pub	Bramley and Stanningley	Y	LS13	22312	72158661	53.826684	-1.637747	436774	423942	Y			Glass	1	1	267		665	807	484	407		660	330	816	527	823	181	560	433	300	709			617	105	758	3391	2020	3,488		435	478	812			509	325	1,618	342	170	8176	908
Acorn Public House	Leeds Bradford Road, Bramley	LS13 1NS	Pub	Bramley and Stanningley	Y	LS13	22313	72118188	53.819699	-1.634268	435998	424175	Y			Glass	1	1		198	698	579	274		376		390			364		244	325	187		1227	209	577	209	95	210	467		534	385	213		1,109		218	163	164	256		3042	380
Adel War Memorial Association	Church Lane	LS16 8DG	Social Club	Adel and Wharfedale	Y	LS16	22314	72564100	53.855966	-1.587172	440050	427252	Y			Glass	1	1	1014	420	593		71	653		751	731	513	527	177	331	660	194	443	475	1076	826	1863	379	388		346	666		0	480	290	239	0	286	164		210	866	3201	320
Adrian Social Club	Belle Vue Avenue	LS8 2NN	Social Club	Roundhay	Y	LS8	21900	72019451	53.824459	-1.48834	436587	433778	Y	Y		Glass, Paper	1	3	1448	1785	2208	2539		1561	2189	1537	2781	1860	2097		2975	990	3111	1875	1724	1063	1899	2415	2694	1704	3213	2360	842	3,107	2,166	1,040	2,488	1,412	717	2,345	2,778	3,833	754	594	22076	1,840
Adwalton Cricket Club	Moorside Vale, Dridlington	BD11 1HG	Sports Club	Kippax and Methley		BD11	21901	72547359	53.751773	-1.654953	428434	422850	Y			Glass	1	1	854	348			317			268			337	2,043	200			692	71					310			3,247	529	0			671			306		165		4919	820
Aireborough Guisley Sport Centre	St Oswalds Terrace, Guiseley	LS20 9BT	Leisure Centre	Guiseley and Rawdon	Y	LS20	21902	72292763	53.873091	-1.707248	441916	419346	Y	Y	Y	Glass, Paper, Textile	1	1	1499	1148	1241	2060	2059	1307	1585	1713	2813	1731	1870	1,298	2169	3199	2584	3276	3473	1471	1610	577	2724	2072	2861	2726	3,216	2,630	3,571	3,800	3,231	2,075	3,235		5,247	4,305	3,274	3,866	38450	3,495
Allied Glass	Haigh Park Road	LS10 1NQ	Business	City and Hunslet		LS10	22333	72187971	53.786766	-1.528641	432375	431153	Y			Glass												1064							792					1233				2,630						0			156		2786	929
Alwoodley Community Centre	The Avenue, Alwoodley	LS17 7NZ	Social Club	Alwoodley	Y	LS17	21962	72523636	53.858701	-1.555171	440367	429355	Y			Glass	1	1	980	1192	1628	1151	511	553	1064	1221	2651	1829	956	1,197	1501	1571	1372	1421	1489				1160	1818	1034	1228	1,845	1,737	1,112	1,904	1,304		1,443	1,395	1,726	1,796	1,769	1,633	17664	1,606
Anchor Inn	Victoria Street, Castleford	WF10 2DF	Pub	Kippax and Methley	Y	WF10	21906	72527193	53.743386	-1.367903	427631	441786	Y			Glass	1	3		1527	1262				1622	1622		1596		1,345	1116	829	2236	825	1344				1238	205		2579	1,824	1,845	739	3,599	2,698	500	738	2,111	926	2,384	545	1,974	19882	1,657


CREATE TABLE n_01_04_2016_31_03_2019 (
  "site_name" VARCHAR,
  "address" VARCHAR,
  "post_code" VARCHAR,
  "location_type" VARCHAR,
  "ward" VARCHAR,
  "sticker" VARCHAR,
  "postcode_area" VARCHAR,
  "site_number" VARCHAR,
  "uprn" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "y" DOUBLE,
  "x" DOUBLE,
  "recyclables_mixed_glass" VARCHAR,
  "recyclables_paper" VARCHAR,
  "recyclables_textiles" VARCHAR,
  "recyclables_small_electrical" VARCHAR,
  "non_lcc_banks" VARCHAR,
  "type" VARCHAR,
  "tally_of_sites" DOUBLE,
  "cleaning" VARCHAR,
  "no_of_glass_banks" DOUBLE,
  "apr_16_glass_tonnages_kg" DOUBLE,
  "may_16_glass_tonnages_kg" DOUBLE,
  "jun_16_glass_tonnages_kg" DOUBLE,
  "jul_16_glass_tonnages_kg" DOUBLE,
  "aug_16_glass_tonnages_kg" DOUBLE,
  "sep_16_glass_tonnages_kg" DOUBLE,
  "oct_16_glass_tonnages_kg" DOUBLE,
  "nov_16_glass_tonnages_kg" DOUBLE,
  "dec_16_glass_tonnages_kg" DOUBLE,
  "jan_17_glass_tonnages_kg" DOUBLE,
  "feb_17_glass_tonnages_kg" DOUBLE,
  "mar_17_glass_tonnages_kg" VARCHAR,
  "apr_17_glass_tonnages_kg" DOUBLE,
  "may_17_glass_tonnages_kg" DOUBLE,
  "jun_17_glass_tonnages_kg" DOUBLE,
  "jul_17_glass_tonnages_kg" DOUBLE,
  "aug_17_glass_tonnages_kg" DOUBLE,
  "sep_17_glass_tonnages_kg" DOUBLE,
  "oct_17_glass_tonnages_kg" DOUBLE,
  "nov_17_glass_tonnages_kg" DOUBLE,
  "dec_17_glass_tonnages_kg" DOUBLE,
  "jan_18_glass_tonnages_kg" DOUBLE,
  "feb_18_glass_tonnages_kg" DOUBLE,
  "mar_18_glass_tonnages_kg" DOUBLE,
  "n_04_18_glass_tonnages_kg" VARCHAR,
  "n_05_18_glass_tonnages_kg" VARCHAR,
  "n_06_18_glass_tonnages_kg" VARCHAR,
  "n_07_18_glass_tonnages_kg" VARCHAR,
  "n_08_18_glass_tonnages_kg" VARCHAR,
  "n_09_18_glass_tonnages_kg" VARCHAR,
  "n_10_18_glass_tonnages_kg" VARCHAR,
  "n_11_18_glass_tonnages_kg" VARCHAR,
  "n_12_18_glass_tonnages_kg" VARCHAR,
  "n_01_19_glass_tonnages_kg" VARCHAR,
  "n_02_19_glass_tonnages_kg" VARCHAR,
  "n_03_19_glass_tonnages_kg" VARCHAR,
  "total_from_apr_19" DOUBLE,
  "n_12_month_average" VARCHAR
);