Name: Council Printers
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Council Printers

A list of Canon printers used at Leeds City Council.
Publisher name: Leeds City Council
Last updated: 2022-07-01T04:02:18Z

Tables

01/03/2018

@ukgov.council_printers.n_01_03_2018

52.06 kB
972 rows
15 columns

CREATE TABLE n_01_03_2018 (
  "contract_number" VARCHAR,
  "model" VARCHAR,
  "serial_num" VARCHAR,
  "installation_date" TIMESTAMP,
  "account_number" DOUBLE,
  "account_name" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "address3" VARCHAR,
  "postal_code" VARCHAR,
  "location" VARCHAR,
  "cust_ref" VARCHAR,
  "inv_amt_excl_vat" DOUBLE,
  "inv_amt_incl_vat" DOUBLE,
  "trx_type" VARCHAR
);

03/04/2019

@ukgov.council_printers.n_03_04_2019

52.01 kB
935 rows
22 columns

CREATE TABLE n_03_04_2019 (
  "contract_number" VARCHAR,
  "model" VARCHAR,
  "serial_num" VARCHAR,
  "installation_date" TIMESTAMP,
  "account_number" DOUBLE,
  "account_name" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "address3" VARCHAR,
  "postal_code" VARCHAR,
  "location" VARCHAR,
  "cust_ref" VARCHAR,
  "inv_amt_excl_vat" DOUBLE,
  "inv_amt_incl_vat" DOUBLE,
  "from_date" TIMESTAMP,
  "to_date" TIMESTAMP,
  "trx_type" VARCHAR,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

19/12/2016

@ukgov.council_printers.n_19_12_2016

53.06 kB
65,441 rows
20 columns

CREATE TABLE n_19_12_2016 (
  "contract_number" VARCHAR,
  "model" VARCHAR,
  "serial_num" VARCHAR,
  "installation_date" TIMESTAMP,
  "account_number" DOUBLE,
  "account_name" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "address3" VARCHAR,
  "postal_code" VARCHAR,
  "location" VARCHAR,
  "cust_ref" VARCHAR,
  "inv_amt_excl_vat" DOUBLE,
  "inv_amt_incl_vat" DOUBLE,
  "trx_type" VARCHAR,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19
);

24/11/2015

@ukgov.council_printers.n_24_11_2015

41.7 kB
909 rows
16 columns

CREATE TABLE n_24_11_2015 (
  "serial_num" VARCHAR,
  "model" VARCHAR,
  "account_number" DOUBLE,
  "address2" VARCHAR,
  "address3" VARCHAR,
  "postal_code" VARCHAR,
  "location" VARCHAR,
  "quarterly_invoice_amount_excluding_vat" DOUBLE,
  "quarterly_invoice_amount_including_vat" DOUBLE,
  "rental" VARCHAR,
  "add_on_1" VARCHAR,
  "add_on_2" VARCHAR,
  "add_on_3" VARCHAR,
  "add_on_4" VARCHAR,
  "installed" TIMESTAMP,
  "quarters" DOUBLE
);