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

@ukgov.bring_sites.n_01_04_2020_31_03_2021

227.54 KB
1048556 rows
68 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_20_glass_tonnage_kg Apr 20 Glass Tonnage Kg	may_20_glass_tonnage_kg May 20 Glass Tonnage Kg	jun_20_glass_tonnage_kg Jun 20 Glass Tonnage Kg	jul_20_glass_tonnage_kg Jul 20 Glass Tonnage Kg	aug_20_glass_tonnage_kg Aug 20 Glass Tonnage Kg	sep_20_glass_tonnage_kg Sep 20 Glass Tonnage Kg	oct_20_glass_tonnage_kg Oct 20 Glass Tonnage Kg	nov_20_glass_tonnage_kg Nov 20 Glass Tonnage Kg	dec_20_glass_tonnage_kg Dec 20 Glass Tonnage Kg	jan_21_glass_tonnage_kg Jan 21 Glass Tonnage Kg	feb_21_glass_tonnage_kg Feb 21 Glass Tonnage Kg	mar_21_glass_tonnage_kg Mar 21 Glass Tonnage 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	562		489	778.04		405.94	442.65		430.59		989.31
Midway	111 Queensway, Yeadon	LS19 7PL	Pub	Otley and Yeadon	Y	LS19	22106	72293978	53.871096	-1.693331	441698	420262	Y			Glass	1	1	2181	2621	3731	10313	1977.09	1273.16	998.81	2327.88	3091.5	2722.03	2582.48	3181.46
Abbey Inn	Pollard Lane	LS13 1EQ	Pub	Bramley and Stanningley	Y	LS13	22312	72158661	53.826684	-1.637747	436774	423942	Y			Glass	1	1	1048	527	629	784.49	556.4	221.02		445.39	604.86	583.19	507.4	777.74
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		392	457		549.43	221.02		89.08	259.23			602.59
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	531	272	833	439.05	399.26	405.08	389	428.67	1157.44	592.31	558.87	658.55
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	3682	3131	4616	5391.28	4255.76	4845.05	4212.31	3300.23	5780.39	4032.15	4311.96	5131.45
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			709			329.81					324.65
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	4112	10757	9223	10574.9	11079.14	8904.55	11094.71	10874.57	13220.92	8074.66	9010.96	9341.91
Allied Glass	Haigh Park Road	LS10 1NQ	Business	City and Hunslet		LS10	22333	72187971	53.786766	-1.528641	432375	431153	Y			Glass				917					577.71				840
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	2941	2387	2688	2265.7	3143.63	1820.4	2107.96	3184.52	2395.03	3694.37	2186.75	2582.55


CREATE TABLE n_01_04_2020_31_03_2021 (
  "site_name" VARCHAR,
  "address" VARCHAR,
  "post_code" VARCHAR,
  "location_type" VARCHAR,
  "ward" VARCHAR,
  "sticker" VARCHAR,
  "postcode_area" VARCHAR,
  "site_number" DOUBLE,
  "uprn" VARCHAR,
  "latitude" VARCHAR,
  "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_20_glass_tonnage_kg" DOUBLE,
  "may_20_glass_tonnage_kg" DOUBLE,
  "jun_20_glass_tonnage_kg" DOUBLE,
  "jul_20_glass_tonnage_kg" DOUBLE,
  "aug_20_glass_tonnage_kg" DOUBLE,
  "sep_20_glass_tonnage_kg" DOUBLE,
  "oct_20_glass_tonnage_kg" DOUBLE,
  "nov_20_glass_tonnage_kg" DOUBLE,
  "dec_20_glass_tonnage_kg" DOUBLE,
  "jan_21_glass_tonnage_kg" DOUBLE,
  "feb_21_glass_tonnage_kg" DOUBLE,
  "mar_21_glass_tonnage_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,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" VARCHAR,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR
);