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_on_e7be5cc0 (
"summary_of_natwest_epc_travel_expenditure_for_period_jan19" 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_e82d20b8 (
"summary_of_natwest_epc_travel_expenditure_for_period_may_2019" 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
);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 -- Unnamed: 1
);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 -- Unnamed: 1
);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.