Foreign, Commonwealth And Development Office: Government Procurement Card Spending Over £500
Foreign, Commonwealth and Development Office (FCDO)
@ukgov.fcdo_government_procurement_card_spending_over_f500
Foreign, Commonwealth and Development Office (FCDO)
@ukgov.fcdo_government_procurement_card_spending_over_f500
All data on Foreign, Development & Commonwealth Office spending over £500 with a government procurement card (GPC) and equivalent e-payment solution (ePCS).
Publisher name: Foreign, Commonwealth and Development Office (FCDO)
Last updated: 2024-12-11T07:58:25Z
CREATE TABLE fcdo_government_procurement_card_spend_over_500_july_2024 (
"transaction_id" BIGINT,
"transaction_date" TIMESTAMP,
"merchant_category_code" BIGINT,
"supplier" VARCHAR,
"location" VARCHAR,
"description" VARCHAR,
"amount" DOUBLE
);CREATE TABLE fcdo_government_procurement_card_spend_over_500_june_2022 (
"unique_reference_number" VARCHAR,
"transaction_date" TIMESTAMP,
"merchant_category_code_description2" VARCHAR,
"location" VARCHAR,
"merchant_category_group_description3" VARCHAR,
"amount" DOUBLE,
"supplier" VARCHAR
);CREATE TABLE fcdo_government_procurement_card_spend_over_500_june_2023 (
"transaction_id" BIGINT,
"transaction_date" TIMESTAMP,
"merchant_category_code" BIGINT,
"supplier" VARCHAR,
"location" VARCHAR,
"description" VARCHAR,
"amount" DOUBLE
);CREATE TABLE fcdo_government_procurement_card_spend_over_500_june_2024 (
"transaction_id" BIGINT,
"transaction_date" TIMESTAMP,
"merchant_category_code" BIGINT,
"supplier" VARCHAR,
"location" VARCHAR,
"description" VARCHAR,
"amount" DOUBLE
);CREATE TABLE fcdo_government_procurement_card_spend_over_500_march_2023 (
"transaction_id" BIGINT,
"transaction_date" TIMESTAMP,
"merchant_category_code" BIGINT,
"supplier" VARCHAR,
"location" VARCHAR,
"description" VARCHAR,
"amount" DOUBLE
);CREATE TABLE fcdo_government_procurement_card_spend_over_500_march_2024 (
"transaction_id" BIGINT,
"transaction_date" TIMESTAMP,
"merchant_category_code" BIGINT,
"supplier" VARCHAR,
"location" VARCHAR,
"description" VARCHAR,
"amount" DOUBLE
);CREATE TABLE fcdo_government_procurement_card_spend_over_500_may_2022 (
"unique_reference_number" VARCHAR,
"transaction_date" TIMESTAMP,
"merchant_category_code_description2" VARCHAR,
"location" VARCHAR,
"merchant_category_group_description3" VARCHAR,
"amount" DOUBLE,
"supplier" VARCHAR
);CREATE TABLE fcdo_government_procurement_card_spend_over_500_may_2023 (
"transaction_id" BIGINT,
"transaction_date" TIMESTAMP,
"merchant_category_code" BIGINT,
"supplier" VARCHAR,
"location" VARCHAR,
"description" VARCHAR,
"amount" DOUBLE
);CREATE TABLE fcdo_government_procurement_card_spend_over_500_may_2024 (
"transaction_id" BIGINT,
"transaction_date" TIMESTAMP,
"merchant_category_code" BIGINT,
"supplier" VARCHAR,
"location" VARCHAR,
"description" VARCHAR,
"amount" DOUBLE
);CREATE TABLE fcdo_government_procurement_card_spend_over_500_november_2022 (
"transaction_id" BIGINT,
"transaction_date" TIMESTAMP,
"merchant_category_code" BIGINT,
"supplier" VARCHAR,
"location" VARCHAR,
"description" VARCHAR,
"amount" DOUBLE
);CREATE TABLE fcdo_government_procurement_card_spend_over_500_november_2023 (
"transaction_id" BIGINT,
"transaction_date" TIMESTAMP,
"merchant_category_code" BIGINT,
"supplier" VARCHAR,
"location" VARCHAR,
"description" VARCHAR,
"amount" DOUBLE
);CREATE TABLE fcdo_government_procurement_card_spend_over_500_october_2022 (
"unique_reference_number" VARCHAR,
"transaction_date" TIMESTAMP,
"merchant_category_code_description2" VARCHAR,
"location" VARCHAR,
"merchant_category_group_description3" VARCHAR,
"amount" DOUBLE,
"supplier" VARCHAR
);CREATE TABLE fcdo_government_procurement_card_spend_over_500_october_2024 (
"transaction_id" BIGINT,
"transaction_date" TIMESTAMP,
"merchant_category_code" BIGINT,
"supplier" VARCHAR,
"location" VARCHAR,
"description" VARCHAR,
"amount" DOUBLE
);CREATE TABLE fcdo_government_procurement_card_spend_over_500_september_2022 (
"unique_reference_number" VARCHAR,
"transaction_date" TIMESTAMP,
"merchant_category_code_description2" VARCHAR,
"location" VARCHAR,
"merchant_category_group_description3" VARCHAR,
"amount" DOUBLE,
"supplier" VARCHAR
);CREATE TABLE fcdo_government_procurement_card_spend_over_500_september_2023 (
"transaction_id" BIGINT,
"transaction_date" TIMESTAMP,
"merchant_category_code" BIGINT,
"supplier" VARCHAR,
"location" VARCHAR,
"description" VARCHAR,
"amount" DOUBLE
);CREATE TABLE fcdo_government_procurement_card_spend_over_500_september_2024 (
"transaction_id" BIGINT,
"transaction_date" TIMESTAMP,
"merchant_category_code" BIGINT,
"supplier" VARCHAR,
"location" VARCHAR,
"description" VARCHAR,
"amount" DOUBLE
);Anyone who has the link will be able to view this.