Baselight
Sign In

Council Printers

Leeds City Council

@ukgov.council_printers

19/12/2016
@ukgov.council_printers.n_19_12_2016

Leeds city council printers

  • 51.81 KB
  • 65441 rows
  • 20 columns
contract_number

Contract Number

model

Model

serial_num

Serial Num

installation_date

Installation Date

account_number

Account Number

account_name

Account Name

address1

Address1

address2

Address2

address3

Address3

postal_code

Postal Code

location

Location

cust_ref

Cust Ref

inv_amt_excl_vat

Inv Amt Excl VAT

inv_amt_incl_vat

Inv Amt Incl VAT

trx_type

Trx Type

unnamed_15

Unnamed: 15

unnamed_16

Unnamed: 16

unnamed_17

Unnamed: 17

unnamed_18

Unnamed: 18

unnamed_19

Unnamed: 19

GB-1016744-OKLiR ADV C5235iWGR17272Thu Apr 14 2016 00:00:00 GMT+0000 (Coordinated Universal Time)4530695GB LEEDS CITY COUNCIL MPSLEEDS CITY COUNCILCHILDRENS CENTRE,GND FLR ANN,ONE STOP CENTREDEWSBURY ROADLS11 6PF268.25321.9RENT
GB-1016748-OKLiR ADV C5235iWGR17133Wed Apr 13 2016 00:00:00 GMT+0000 (Coordinated Universal Time)4530695GB LEEDS CITY COUNCIL MPSLEEDS CITY COUNCILABBEY HOUSE MUSEUM,SECOND FLOORAbbey WalkLS5 3EH268.25321.9RENT
GB-1016751-OKLiR ADV C5235iWGR17279Wed Apr 13 2016 00:00:00 GMT+0000 (Coordinated Universal Time)4530695GB LEEDS CITY COUNCIL MPSLEEDS CITY COUNCILLEEDS LIGHTS - LIMEWOOD,GROUND FLOORLIMEWOOD APPROACHLS14 1LU268.25321.9RENT
GB-1016752-OKLiR ADV C5235iWGR17180Thu Apr 14 2016 00:00:00 GMT+0000 (Coordinated Universal Time)4530695GB LEEDS CITY COUNCIL MPSLEEDS CITY COUNCILRICHMOND HOUSE - JCMT,GROUND FLOORRICHMOND ROADLS28 5ST268.25321.9RENT
GB-1016754-OKLiR ADV C5235iWGR17371Thu Apr 14 2016 00:00:00 GMT+0000 (Coordinated Universal Time)4530695GB LEEDS CITY COUNCIL MPSLEEDS CITY COUNCIL MPSKENTMERE COMMUNITY CENTREKENTMERE AVENUELS14 1BW268.25321.9RENT
GB-1016779-OKLiR ADV C5235iWGR17369Wed Apr 13 2016 00:00:00 GMT+0000 (Coordinated Universal Time)4530695GB LEEDS CITY COUNCIL MPSLEEDS CITY COUNCILKENTMERE COMMUNITY CENTRE,ROOM 10KENTMERE AVENUELS14 1BW268.25321.9RENT
GB-1016782-OKLiR ADV C5235iWGR17079Mon Apr 18 2016 00:00:00 GMT+0000 (Coordinated Universal Time)4530695GB LEEDS CITY COUNCIL MPSLEEDS CITY ACADEMYART FORMSBEDFORD FIELD, WOODHOUSE CLIFFLS6 2LG268.25321.9RENT
GB-1016786-OKLiR ADV C5235iWGR17126Wed Apr 13 2016 00:00:00 GMT+0000 (Coordinated Universal Time)4530695GB LEEDS CITY COUNCIL MPSLEEDS CITY COUNCILLITTLE LONDON CHILDREN'S CENTREGROUND FLOOR, 169A MEANWOOD ROADLS7 1SR268.25321.9RENT
GB-1016787-OKLiR ADV C5235iWGR17275Wed Apr 13 2016 00:00:00 GMT+0000 (Coordinated Universal Time)4530695GB LEEDS CITY COUNCIL MPSLEEDS CITY COUNCILAPEX CENTRE - STOCK,LV ROOM GROUNDApex WayLS11 5LN268.25321.9RENT
GB-1016792-OKLiR ADV 400iQLC25984Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)4530695GB LEEDS CITY COUNCIL MPSLEEDS CITY COUNCILEBOR GARDENS COMMUNITY CENTRE,GROUND FLOORHAZELWOOD DRIVELS9 7PF156.87188.244RENT

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_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR
);

Share link

Anyone who has the link will be able to view this.