About this Dataset

Skips Waste

Data showing skips usage across services in the council. Information includes type of waste disposed of, quantity and weight (in tonnes). Please note ----------- * This information is supplied by the contractor and in some cases may be incomplete. * The 2008/9 dataset is incomplete and only covers April to December. * Due to a change in supplier no data exists between April 2015 to August 2015
Publisher name: Leeds City Council
Last updated: 2024-09-11T00:00:53Z

Tables

2008/9

@ukgov.skips_waste.n_2008_9

31.54 KB
2399 rows
8 columns


CREATE TABLE n_2008_9 (
  "date" TIMESTAMP,
  "ticket_no" BIGINT,
  "product" VARCHAR,
  "unit" VARCHAR,
  "type" VARCHAR,
  "account_name" VARCHAR,
  "weight" DOUBLE,
  "qty" DOUBLE
);

2010/11

@ukgov.skips_waste.n_2010_11

34.88 KB
2749 rows
8 columns


CREATE TABLE n_2010_11 (
  "date" VARCHAR,
  "ticket_no" BIGINT,
  "product" VARCHAR,
  "unit" VARCHAR,
  "type" VARCHAR,
  "account_name" VARCHAR,
  "weight" DOUBLE,
  "qty" DOUBLE
);

2011/12

@ukgov.skips_waste.n_2011_12

40.51 KB
3512 rows
8 columns


CREATE TABLE n_2011_12 (
  "date" TIMESTAMP,
  "ticket_no" BIGINT,
  "product" VARCHAR,
  "unit" VARCHAR,
  "type" VARCHAR,
  "account_name" VARCHAR,
  "weight" DOUBLE,
  "qty" DOUBLE
);

2012/13

@ukgov.skips_waste.n_2012_13

62.47 KB
5065 rows
8 columns


CREATE TABLE n_2012_13 (
  "date" TIMESTAMP,
  "ticket_no" BIGINT,
  "product" VARCHAR,
  "unit" VARCHAR,
  "type" VARCHAR,
  "account_name" VARCHAR,
  "weight" DOUBLE,
  "qty" DOUBLE
);

2014/15

@ukgov.skips_waste.n_2014_15

33.88 KB
790 rows
16 columns


CREATE TABLE n_2014_15 (
  "address_name" VARCHAR,
  "postcode" VARCHAR,
  "product" VARCHAR,
  "apr_14" DOUBLE,
  "may_14" DOUBLE,
  "jun_14" DOUBLE,
  "jul_14" DOUBLE,
  "aug_14" DOUBLE,
  "sep_14" DOUBLE,
  "oct_14" DOUBLE,
  "nov_14" DOUBLE,
  "dec_14" DOUBLE,
  "jan_15" DOUBLE,
  "feb_15" DOUBLE,
  "mar_15" DOUBLE,
  "grand_total_tonnage" DOUBLE
);

2015/16

@ukgov.skips_waste.n_2015_16

63.18 KB
5870 rows
8 columns


CREATE TABLE n_2015_16 (
  "date" TIMESTAMP,
  "ticket_no" BIGINT,
  "product" VARCHAR,
  "unit" VARCHAR,
  "tipping_product" VARCHAR,
  "account_name" VARCHAR,
  "weight" DOUBLE,
  "qty" DOUBLE
);

Unit And Product Guidance

@ukgov.skips_waste.unit_and_product_guidance

2.71 KB
23 rows
2 columns


CREATE TABLE unit_and_product_guidance (
  "unit" VARCHAR,
  "unnamed_1" VARCHAR
);