MOD: Spending Over £25,000 And Over £500 On A Government Procurement Card
Ministry of Defence
@ukgov.mod_spending_over_25000
Ministry of Defence
@ukgov.mod_spending_over_25000
CREATE TABLE mod_s_government_procurement_card_spending_over_500_on_e7be5cc0 (
"summary_of_natwest_epc_travel_expenditure_for_period_jan19" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR
);
CREATE TABLE mod_s_government_procurement_card_spending_over_500_on_e82d20b8 (
"summary_of_natwest_epc_travel_expenditure_for_period_may_2019" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR
);
CREATE TABLE mod_spending_over_25_000_and_over_500_on_a_government__aef6f5c8 (
"contracts_where_the_gpc_is_the_payment_method" VARCHAR,
"unnamed_1" VARCHAR
);
CREATE TABLE mod_spending_over_25_000_for_february_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"payment_date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"supplier_site_post_code" VARCHAR,
"transaction_number" VARCHAR,
"payment_description" VARCHAR,
"total" VARCHAR
);
CREATE TABLE mod_spending_over_25_000_january_to_december_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"payment_date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"supplier_site_post_code" VARCHAR,
"transaction_number" VARCHAR,
"payment_description" VARCHAR,
"total" VARCHAR
);
CREATE TABLE mod_spending_over_25_000_january_to_december_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"payment_date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"supplier_site_post_code" VARCHAR,
"transaction_number" VARCHAR,
"payment_description" VARCHAR,
"total" VARCHAR
);
CREATE TABLE mod_spending_over_500_on_a_gpc_for_january_to_december_2019 (
"summary_of_natwest_epc_travel_expenditure_for_period_dec19" VARCHAR,
"unnamed_1" VARCHAR
);
CREATE TABLE mod_s_spending_over_25_000_for_august_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"payment_date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"supplier_site_post_code" VARCHAR,
"transaction_number" VARCHAR,
"payment_description" VARCHAR,
"total" VARCHAR
);
CREATE TABLE mod_s_spending_over_25_000_for_december_2018 (
"department" VARCHAR,
"entity" VARCHAR,
"payment_date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"supplier_site_post_code" VARCHAR,
"transaction_number" VARCHAR,
"payment_description" VARCHAR,
"total" VARCHAR
);
CREATE TABLE mod_s_spending_over_25_000_for_december_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"payment_date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"supplier_site_post_code" VARCHAR,
"transaction_number" VARCHAR,
"payment_description" VARCHAR,
"total" VARCHAR
);
CREATE TABLE mod_s_spending_over_25_000_for_february_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"payment_date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"supplier_site_post_code" VARCHAR,
"transaction_number" VARCHAR,
"payment_description" VARCHAR,
"total" VARCHAR
);
CREATE TABLE mod_s_spending_over_25_000_for_january_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"payment_date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"supplier_site_post_code" VARCHAR,
"transaction_number" VARCHAR,
"payment_description" VARCHAR,
"total" VARCHAR
);
CREATE TABLE mod_s_spending_over_25_000_for_july_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"payment_date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"supplier_site_post_code" VARCHAR,
"transaction_number" VARCHAR,
"payment_description" VARCHAR,
"total" VARCHAR
);
CREATE TABLE mod_s_spending_over_25_000_for_june_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"payment_date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"supplier_site_post_code" VARCHAR,
"transaction_number" VARCHAR,
"payment_description" VARCHAR,
"total" VARCHAR
);
CREATE TABLE mod_s_spending_over_25_000_for_march_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"payment_date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"supplier_site_post_code" VARCHAR,
"transaction_number" VARCHAR,
"payment_description" VARCHAR,
"total" VARCHAR
);
CREATE TABLE mod_s_spending_over_25_000_for_march_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"payment_date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"supplier_site_post_code" VARCHAR,
"transaction_number" VARCHAR,
"payment_description" VARCHAR,
"total" VARCHAR
);
CREATE TABLE mod_s_spending_over_25_000_for_may_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"payment_date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"supplier_site_post_code" VARCHAR,
"transaction_number" VARCHAR,
"payment_description" VARCHAR,
"total" VARCHAR
);
CREATE TABLE mod_s_spending_over_25_000_for_november_2018 (
"department" VARCHAR,
"entity" VARCHAR,
"payment_date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"supplier_site_post_code" VARCHAR,
"transaction_number" VARCHAR,
"payment_description" VARCHAR,
"total" VARCHAR
);
CREATE TABLE mod_s_spending_over_25_000_for_november_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"payment_date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"supplier_site_post_code" VARCHAR,
"transaction_number" VARCHAR,
"payment_description" VARCHAR,
"total" VARCHAR
);
CREATE TABLE mod_s_spending_over_25_000_for_october_2018 (
"department" VARCHAR,
"entity" VARCHAR,
"payment_date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"supplier_site_post_code" VARCHAR,
"transaction_number" VARCHAR,
"payment_description" VARCHAR,
"total" VARCHAR
);
CREATE TABLE mod_s_spending_over_25_000_for_september_2018 (
"department" VARCHAR,
"entity" VARCHAR,
"payment_date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"supplier_site_post_code" VARCHAR,
"transaction_number" VARCHAR,
"payment_description" VARCHAR,
"total" VARCHAR
);
Anyone who has the link will be able to view this.