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

32.3 kB
2,399 rows
8 columns

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

2010/11

@ukgov.skips_waste.n_2010_11

35.71 kB
2,749 rows
8 columns

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

2011/12

@ukgov.skips_waste.n_2011_12

41.48 kB
3,512 rows
8 columns

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

2012/13

@ukgov.skips_waste.n_2012_13

63.97 kB
5,065 rows
8 columns

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

2014/15

@ukgov.skips_waste.n_2014_15

34.7 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  -- Grand Total (Tonnage)
);

2015/16

@ukgov.skips_waste.n_2015_16

64.7 kB
5,870 rows
8 columns

CREATE TABLE n_2015_16 (
  "date" TIMESTAMP,
  "ticket_no" BIGINT  -- Ticket No.,
  "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.77 kB
23 rows
2 columns

CREATE TABLE unit_and_product_guidance (
  "unit" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1
);