About this Dataset

Bring Sites

A dataset providing the locations of all bring sites in Leeds. This dataset also shows the amount of glass collected at each site each month from April 2016. Bring sites are smaller recycling sites which you'll find in supermarkets or pub car parks. Depending on the site, you can recycle a variety of things including paper, glass, clothing, food/drink cans and plastic bottles. Further information ------------------- * Please telephone or text 07891 277 226 to report an untidy site or overflowing bank. Please include the street name that the bring site is closest to. * To find out more about bring sites and recycling click here http://www.leeds.gov.uk/residents/Pages/Recyclingsites.aspx Updates ------- * Updates of this dataset will take place as required when sites are added or removed. * This dataset will be reviewed on an annual basis to check accuracy.
Publisher name: Leeds City Council
Last updated: 2024-09-14T10:05:53Z

Tables

01/04/2016 - 31/03/2019

@ukgov.bring_sites.n_01_04_2016_31_03_2019

133.38 kB
404 rows
60 columns

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  -- 04/18 Glass Tonnages Kg,
  "n_05_18_glass_tonnages_kg" VARCHAR  -- 05/18 Glass Tonnages Kg,
  "n_06_18_glass_tonnages_kg" VARCHAR  -- 06/18 Glass Tonnages Kg,
  "n_07_18_glass_tonnages_kg" VARCHAR  -- 07/18 Glass Tonnages Kg,
  "n_08_18_glass_tonnages_kg" VARCHAR  -- 08/18 Glass Tonnages Kg,
  "n_09_18_glass_tonnages_kg" VARCHAR  -- 09/18 Glass Tonnages Kg,
  "n_10_18_glass_tonnages_kg" VARCHAR  -- 10/18 Glass Tonnages Kg,
  "n_11_18_glass_tonnages_kg" VARCHAR  -- 11/18 Glass Tonnages Kg,
  "n_12_18_glass_tonnages_kg" VARCHAR  -- 12/18 Glass Tonnages Kg,
  "n_01_19_glass_tonnages_kg" VARCHAR  -- 01/19 Glass Tonnages Kg,
  "n_02_19_glass_tonnages_kg" VARCHAR  -- 02/19 Glass Tonnages Kg,
  "n_03_19_glass_tonnages_kg" VARCHAR  -- 03/19 Glass Tonnages Kg,
  "total_from_apr_19" DOUBLE,
  "n_12_month_average" VARCHAR  -- 12 Month Average
);

01/04/2020 - 31/03/2021

@ukgov.bring_sites.n_01_04_2020_31_03_2021

233 kB
1,048,556 rows
68 columns

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: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "unnamed_56" VARCHAR  -- Unnamed: 56,
  "unnamed_57" VARCHAR  -- Unnamed: 57,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "unnamed_60" VARCHAR  -- Unnamed: 60,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "unnamed_62" VARCHAR  -- Unnamed: 62,
  "unnamed_63" VARCHAR  -- Unnamed: 63,
  "unnamed_64" VARCHAR  -- Unnamed: 64,
  "unnamed_65" VARCHAR  -- Unnamed: 65,
  "unnamed_66" VARCHAR  -- Unnamed: 66,
  "unnamed_67" VARCHAR  -- Unnamed: 67
);

01/04/2021 - 31/03/2022

@ukgov.bring_sites.n_01_04_2021_31_03_2022

195.28 kB
1,048,556 rows
60 columns

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: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "unnamed_56" VARCHAR  -- Unnamed: 56,
  "unnamed_57" VARCHAR  -- Unnamed: 57,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59
);