Council Printers

Leeds City Council

@ukgov.council_printers

Table List

4 tables(194.16 KB)

03/04/2019

@ukgov.council_printers.n_03_04_2019

50.79 KB
935 rows
22 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	inv_amt_excl_vat Inv Amt Excl VAT	inv_amt_incl_vat Inv Amt Incl VAT	from_date From Date	to_date To Date	trx_type Trx Type
GB-1016744-OKL	iR ADV C5235i	WGR17272	Thu Apr 14 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	4530695	GB MPS LEEDS CITY COUNCIL	LEEDS CITY COUNCIL	CHILDRENS CENTRE,GND FLR ANN,ONE STOP CENTRE	DEWSBURY ROAD	LS11 6PF	268.25	321.9	Wed Jan 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	RENT
GB-1016748-OKL	iR ADV C5235i	WGR17133	Wed Apr 13 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	4530695	GB MPS LEEDS CITY COUNCIL	LEEDS CITY COUNCIL	ABBEY HOUSE MUSEUM,SECOND FLOOR	Abbey Walk	LS5 3EH	268.25	321.9	Wed Jan 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	RENT
GB-1016751-OKL	iR ADV C5235i	WGR17279	Wed Apr 13 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	4530695	GB MPS LEEDS CITY COUNCIL	LEEDS CITY COUNCIL	LEEDS LIGHTS - LIMEWOOD,GROUND FLOOR	LIMEWOOD APPROACH	LS14 1LU	268.25	321.9	Wed Jan 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	RENT
GB-1016752-OKL	iR ADV C5235i	WGR17180	Fri Apr 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	4530695	GB MPS LEEDS CITY COUNCIL	LEEDS CITY COUNCIL	CIVIC HALL	CALVERLEY STREET	LS1 1UR	268.25	321.9	Wed Jan 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	RENT
GB-1016754-OKL	iR ADV C5235i	WGR17371	Fri Apr 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	4530695	GB MPS LEEDS CITY COUNCIL	LEEDS CITY COUNCIL	Merrion House	Merrion Way	LS2 8BB	268.25	321.9	Wed Jan 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	RENT
GB-1016779-OKL	iR ADV C5235i	WGR17369	Fri Apr 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	4530695	GB MPS LEEDS CITY COUNCIL	LEEDS CITY COUNCIL	Merrion House	Merrion Way	LS2 8BB	268.25	321.9	Wed Jan 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	RENT
GB-1016782-OKL	iR ADV C5235i	WGR17079	Fri Apr 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	4530695	GB MPS LEEDS CITY COUNCIL	LEEDS CITY COUNCIL MPS	DAWSONS CORNER SHELTERED HOUSING	GROUND FLOOR, DAWSONS CORNER	LS28 5TA	268.25	321.9	Wed Jan 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	RENT
GB-1016786-OKL	iR ADV C5235i	WGR17126	Wed Apr 13 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	4530695	GB MPS LEEDS CITY COUNCIL	LEEDS CITY COUNCIL	LITTLE LONDON CHILDREN'S CENTRE	GROUND FLOOR, 169A MEANWOOD ROAD	LS7 1SR	268.25	321.9	Wed Jan 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	RENT
GB-1016787-OKL	iR ADV C5235i	WGR17275	Wed Apr 13 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	4530695	GB MPS LEEDS CITY COUNCIL	LEEDS CITY COUNCIL	One Adoption, Princess Building	Princess Street	HX1 1TP	268.25	321.9	Wed Jan 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	RENT
GB-1016792-OKL	iR ADV 400i	QLC25984	Tue Apr 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	4530695	GB MPS LEEDS CITY COUNCIL	LEEDS CITY COUNCIL	EBOR GARDENS COMMUNITY CENTRE,GROUND FLOOR	HAZELWOOD DRIVE	LS9 7PF	156.87	188.244	Wed Jan 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	RENT


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_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);