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
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.