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/2019 - 31/03/2020

@ukgov.bring_sites.n_01_04_2019_31_03_2020

86.88 KB
400 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	n_04_19_glass_tonnages_kg 04/19 Glass Tonnages Kg	n_05_19_glass_tonnages_kg 05/19 Glass Tonnages Kg	n_06_19_glass_tonnages_kg 06/19 Glass Tonnages Kg	n_07_19_glass_tonnages_kg 07/19 Glass Tonnages Kg	n_08_19_glass_tonnages_kg 08/19 Glass Tonnages Kg	n_09_19_glass_tonnages_kg 09/19 Glass Tonnages Kg	n_10_19_glass_tonnages_kg 10/19 Glass Tonnages Kg	n_11_19_glass_tonnages_kg 11/19 Glass Tonnages Kg	n_12_19_glass_tonnages_kg 12/19 Glass Tonnages Kg	n_01_20_glass_tonnages_kg 01/20 Glass Tonnages Kg	n_02_20glass_tonnages_kg 02/20Glass Tonnages Kg	n_03_20_glass_tonnages_kg 03/20 Glass Tonnages Kg
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	310		727		685		730		1017	476		348.78
City Island Apartments / Waterside Apartments	Gotts Road	LS12 1AD	Road Side	City and Hunslet	Y	LS12	21955	72662515	53.795383	-1.563447	433319	428854	Y			Glass	1	3	2,055	344	1018	728	1850		325	1222	279	953	178.66	2068.15
Abbey Inn	Pollard Lane	LS13 1EQ	Pub	Bramley and Stanningley	Y	LS13	22312	72158661	53.826684	-1.637747	436774	423942	Y			Glass	1	1	508	426	667	937	340	434	508	417		4276	308.79	508
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	254		667	650	134	177	143	141		113	182.52	254
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		561	844	555	1301	684	377	377	321	1015	135.92	472.87
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	2,570	1677	1252	1483	1435	1464	4490	1361	5537	3022	1701.3	2522.7
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					711			501				675.7
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	3,294	4556	365	1144		1269	1865	1588	3083	3126	1911.6	485
Allied Glass	Haigh Park Road	LS10 1NQ	Business	City and Hunslet		LS10	22333	72187971	53.786766	-1.528641	432375	431153	Y			Glass				672								795	2387.3
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	1,617	871	1451	1577	1071	1357		536	2089	1172	1879.3	1617


CREATE TABLE n_01_04_2019_31_03_2020 (
  "site_name" VARCHAR,
  "address" VARCHAR,
  "post_code" VARCHAR,
  "location_type" VARCHAR,
  "ward" VARCHAR,
  "sticker" VARCHAR,
  "postcode_area" VARCHAR,
  "site_number" VARCHAR,
  "uprn" DOUBLE,
  "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,
  "n_04_19_glass_tonnages_kg" VARCHAR,
  "n_05_19_glass_tonnages_kg" DOUBLE,
  "n_06_19_glass_tonnages_kg" DOUBLE,
  "n_07_19_glass_tonnages_kg" DOUBLE,
  "n_08_19_glass_tonnages_kg" DOUBLE,
  "n_09_19_glass_tonnages_kg" DOUBLE,
  "n_10_19_glass_tonnages_kg" DOUBLE,
  "n_11_19_glass_tonnages_kg" DOUBLE,
  "n_12_19_glass_tonnages_kg" DOUBLE,
  "n_01_20_glass_tonnages_kg" DOUBLE,
  "n_02_20glass_tonnages_kg" DOUBLE,
  "n_03_20_glass_tonnages_kg" DOUBLE,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR
);