Payments To Suppliers With A Value Over £250 From Transport For London
Transport for London
@ukgov.tfl_spend_over_500
Transport for London
@ukgov.tfl_spend_over_500
CREATE TABLE tfl_spend_2122_period_1 (
"report_of_all_payments_made_by_tfl_for_value_equal_to__b2469341" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR
);
CREATE TABLE tfl_spend_2122_period_10 (
"entity" VARCHAR,
"vendor_name" VARCHAR,
"expenditure_account" VARCHAR,
"document_number" VARCHAR,
"clearing_date" VARCHAR,
"amount" DOUBLE,
"merchant_category" DOUBLE
);
CREATE TABLE tfl_spend_2122_period_11 (
"report_of_all_payments_made_by_tfl_for_value_equal_to__b2469341" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR
);
CREATE TABLE tfl_spend_2122_period_12 (
"report_of_all_payments_made_by_tfl_for_value_equal_to__b2469341" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR
);
CREATE TABLE tfl_spend_2122_period_13 (
"report_of_all_payments_made_by_tfl_for_value_equal_to__b2469341" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR
);
CREATE TABLE tfl_spend_2122_period_2 (
"report_of_all_payments_made_by_tfl_for_value_equal_to__b2469341" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR
);
CREATE TABLE tfl_spend_2122_period_3 (
"report_of_all_payments_made_by_tfl_for_value_equal_to__b2469341" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR
);
CREATE TABLE tfl_spend_2122_period_4 (
"report_of_all_payments_made_by_tfl_for_value_equal_to__b2469341" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR
);
CREATE TABLE tfl_spend_2122_period_5 (
"report_of_all_payments_made_by_tfl_for_value_equal_to__b2469341" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR
);
CREATE TABLE tfl_spend_2122_period_6 (
"report_of_all_payments_made_by_tfl_for_value_equal_to__b2469341" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR
);
CREATE TABLE tfl_spend_2122_period_7 (
"report_of_all_payments_made_by_tfl_for_value_equal_to__b2469341" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR
);
CREATE TABLE tfl_spend_2122_period_8 (
"report_of_all_payments_made_by_tfl_for_value_equal_to__b2469341" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR
);
CREATE TABLE tfl_spend_2122_period_9 (
"report_of_all_payments_made_by_tfl_for_value_equal_to__b2469341" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR
);
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
);
CREATE TABLE tfl_spend_2223_period_2 (
"entity" VARCHAR,
"vendor_name" VARCHAR,
"expenditure_account" VARCHAR,
"document_number" VARCHAR,
"clearing_date" VARCHAR,
"amount" VARCHAR,
"merchant_category" DOUBLE
);
CREATE TABLE tfl_spend_2223_period_3 (
"entity" VARCHAR,
"vendor_name" VARCHAR,
"expenditure_account" VARCHAR,
"document_number" VARCHAR,
"clearing_date" VARCHAR,
"amount" DOUBLE,
"merchant_category" DOUBLE
);
CREATE TABLE tfl_spend_2223_period_4 (
"entity" VARCHAR,
"vendor_name" VARCHAR,
"expenditure_account" VARCHAR,
"document_number" VARCHAR,
"clearing_date" VARCHAR,
"amount" VARCHAR,
"merchant_category" DOUBLE
);
CREATE TABLE tfl_spend_2223_period_5 (
"entity" VARCHAR,
"vendor_name" VARCHAR,
"expenditure_account" VARCHAR,
"document_number" VARCHAR,
"clearing_date" VARCHAR,
"amount" VARCHAR,
"merchant_category" DOUBLE
);
CREATE TABLE tfl_spend_2223_period_6 (
"entity" VARCHAR,
"vendor_name" VARCHAR,
"expenditure_account" VARCHAR,
"document_number" VARCHAR,
"clearing_date" VARCHAR,
"amount" VARCHAR,
"merchant_category" DOUBLE
);
Anyone who has the link will be able to view this.