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
A monthly submission of payments over £25,000 made by the Ministry of Defence and its family members, as part of the Government's commitment to transparency in expenditure. These datasets are also available on GOV.UK visit: https://www.gov.uk/government/collections/mod-finance-transparency-dataset
Publisher name: Ministry of Defence
Publisher URL: http://data.europa.eu/88u/.well-known/genid/d8b374eef3a09e8d94f5dc8ba8995052
Last updated: 2024-09-11T01:17:19Z
CREATE TABLE mod_s_government_procurement_card_spending_over_500_fo_17e6e1cf (
"summary_of_natwest_epc_travel_expenditure_for_period_dec19" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_fo_2018b723 (
"examples_of_epc_expenditure" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_fo_5dcb39f0 (
"examples_of_epc_expenditure" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_fo_5f7fe89c (
"examples_of_epc_expenditure" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_fo_7588a292 (
"examples_of_epc_expenditure" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_fo_9601a31a (
"examples_of_epc_expenditure" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"unnamed_10" VARCHAR -- Unnamed: 10,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_fo_a41ed8ab (
"unique_ref" VARCHAR,
"transaction_date" TIMESTAMP,
"amount" VARCHAR,
"merchant_category" VARCHAR,
"supplier_merchant_category_code_description" VARCHAR -- Supplier - Merchant Category Code Description
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_fo_a4ecaae3 (
"uniqueref" VARCHAR,
"transactiondate" VARCHAR,
"merchantcategory" VARCHAR,
"mcc_description" VARCHAR,
"amount" VARCHAR,
"sortfunction" BIGINT,
"month" VARCHAR
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_fo_b5f7a466 (
"uniqueref" VARCHAR,
"transactiondate" VARCHAR,
"merchantcategory" VARCHAR,
"mcc_description" VARCHAR,
"amount" VARCHAR
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_fo_c5ccb007 (
"summary_of_natwest_epc_travel_expenditure_for_period_dec19" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_fo_e369b492 (
"uniqueref" VARCHAR,
"transactiondate" VARCHAR,
"merchantcategory" VARCHAR,
"mcc_description" VARCHAR,
"amount" VARCHAR,
"sortfunction" BIGINT,
"month" VARCHAR
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_fo_eb12e4e4 (
"uniqueref" VARCHAR,
"transactiondate" VARCHAR,
"merchantcategory" VARCHAR,
"mcc_description" VARCHAR,
"amount" VARCHAR,
"sortfunction" BIGINT,
"month" VARCHAR
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_fo_fad7a131 (
"examples_of_epc_expenditure" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_on_0208aa1e (
"summary_of_natwest_epc_travel_expenditure_for_period_0_4550ebb2" VARCHAR -- Summary Of Natwest EPC Travel Expenditure For Period 08.06.19 - 05.07.19,
"unnamed_1" VARCHAR -- Unnamed: 1
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_on_09297910 (
"summary_of_natwest_epc_travel_expenditure_for_period_nov_18" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_on_12106e90 (
"summary_of_natwest_epc_travel_expenditure_for_period_dec19" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_on_45589fca (
"summary_of_natwest_epc_travel_expenditure_for_period_dec19" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_on_45d7e865 (
"summary_of_natwest_epc_travel_expenditure_for_period_dec19" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_on_4a4764f8 (
"summary_of_natwest_epc_travel_expenditure_for_period_sep_18" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_on_73359694 (
"summary_of_natwest_epc_travel_expenditure_for_period_april_19" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_on_7f25c77e (
"summary_of_natwest_epc_travel_expenditure_for_period_f_74c718e3" VARCHAR -- Summary Of Natwest EPC Travel Expenditure For Period February 2020,
"unnamed_1" VARCHAR -- Unnamed: 1
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_on_bf34bc94 (
"summary_of_natwest_epc_travel_expenditure_for_period" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_on_c092df6e (
"summary_of_natwest_epc_travel_expenditure_for_period_dec_18" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_on_e5a204f2 (
"summary_of_natwest_epc_travel_expenditure_for_period_july_19" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1
);CREATE TABLE mod_s_government_procurement_card_spending_over_500_on_e6529d06 (
"summary_of_natwest_epc_travel_expenditure_for_period_oct_18" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1
);Anyone who has the link will be able to view this.