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

@ukgov.bring_sites.n_01_04_2021_31_03_2022

190.7 KB
1048556 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	april_21_glass_tonnages_kg April 21 Glass Tonnages Kg	may_21_glass_tonnages_kg May 21 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	355.83	329.45
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	1375.53	860.49
33 Town St formerly The New Inn	33 Town Street, Farsley	LS28 5HX	Pub	Calverley and Farsley	Y	LS28	22131	72276206	53.812347	-1.671723	435168	421713	Y			Glass	1	1	906.28	540.63
Abbey Inn	Pollard Lane	LS13 1EQ	Pub	Bramley and Stanningley	Y	LS13	22312	72158661	53.826684	-1.637747	436774	423942	Y			Glass	1	1	1109.59	617.11
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		371.39
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	993	508.76
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	4370.54	3764.2
Adwalton Cricket Club	Moorside Vale, Drighlington	BD11 1HG	Sports Club	Kippax and Methley		BD11	21901	72547359	53.751773	-1.654953	428434	422850	Y			Glass	1	1
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	2	11599.39	10212.93
Allied Glass	Haigh Park Road	LS10 1NQ	Business	City and Hunslet		LS10	22333	72187971	53.786766	-1.528641	432375	431153	Y			Glass


CREATE TABLE n_01_04_2021_31_03_2022 (
  "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,
  "april_21_glass_tonnages_kg" DOUBLE,
  "may_21_glass_tonnages_kg" DOUBLE,
  "june_21_glass_tonnages_kg" VARCHAR,
  "july_21_glass_tonnages_kg" VARCHAR,
  "aug_21_glass_tonnages_kg" VARCHAR,
  "july_21_glass_tonnages_kg_1" VARCHAR,
  "aug_21_glass_tonnages_kg_1" VARCHAR,
  "sep_21_glass_tonnages_kg" VARCHAR,
  "oct_21_glass_tonnages_kg" VARCHAR,
  "nov_21_glass_tonnages_kg" VARCHAR,
  "dec_21_glass_tonnages_kg" VARCHAR,
  "jan_22_glass_tonnages_kg" VARCHAR,
  "feb_22_glass_tonnages_kg" VARCHAR,
  "mar_22_glass_tonnages_kg" 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
);