Baselight

Payments To Suppliers With A Value Over £250 From Transport For London

Transport for London

@ukgov.tfl_spend_over_500

TFL Spend 2223 Period 1
@ukgov.tfl_spend_over_500.tfl_spend_2223_period_1

  • 251.43 KB
  • 14179 rows
  • 7 columns
entity

Entity

vendor_name

Vendor Name

expenditure_account

Expenditure Account

document_number

Document Number

clearing_date

Clearing Date

amount

Amount (Ł)

merchant_category

Merchant Category

TRANSPORT TRADING LTDRAIL SETTLEMENT PLANRail Settlement Plan - PAYG Creditor1004\190168413014 Apr 202256,779,099.98
DOCKLANDS LIGHT RAILWAYCONST. Y AUX. DE FERROCARRILES S.AVehicle Purchases1012\511008613801 Apr 202221,828,437.59
RAIL FOR LONDON LIMITEDMTR CROSSRAILFranchise/Concession Fixed Fee1020\511010215129 Apr 202220,571,900.88
RAIL FOR LONDON LIMITEDARRIVA RAIL LONDONFranchise/Concession Fixed Fee1020\511010282429 Apr 202217,220,710.10
LONDON BUS SERVICES LTDMETROLINE TRAVEL LTDBus Contract Payments1006\190004712614 Apr 202215,188,898.25
LONDON BUS SERVICES LTDARRIVA LONDON NORTH LTDBus Contract Payments1006\190004711414 Apr 202213,304,326.67
LONDON BUS SERVICES LTDLONDON GENERAL TRANSPORT SERVICESBus Contract Payments1006\190004712114 Apr 202212,092,824.19
LONDON BUS SERVICES LTDLONDON UNITED BUSWAYSBus Contract Payments1006\190004712414 Apr 202210,827,674.89
LONDON BUS SERVICES LTDLONDON CENTRAL BUS COMPANY LTD Bus Contract Payments1006\190004712014 Apr 202210,347,575.19
LONDON BUS SERVICES LTDEAST LONDON BUS & COACH COMPANY LTDBus Contract Payments1006\190004711814 Apr 20229,133,006.04

CREATE TABLE tfl_spend_2223_period_1 (
  "entity" VARCHAR,
  "vendor_name" VARCHAR,
  "expenditure_account" VARCHAR,
  "document_number" VARCHAR,
  "clearing_date" VARCHAR,
  "amount" VARCHAR,
  "merchant_category" DOUBLE
);