FCDO (FCO) GPC Transactions January 2021

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_fco_gpc_transactions_january_2021

43.63 KB
1193 rows
7 columns


CREATE TABLE fcdo_fco_gpc_transactions_january_2021 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

FCDO (FCO) GPC Transactions January 2022

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_fco_gpc_transactions_january_2022

53.84 KB
1580 rows
7 columns


CREATE TABLE fcdo_fco_gpc_transactions_january_2022 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

FCDO (FCO) GPC Transactions July 2021

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_fco_gpc_transactions_july_2021

45.69 KB
1270 rows
7 columns


CREATE TABLE fcdo_fco_gpc_transactions_july_2021 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

FCDO (FCO) GPC Transactions June 2021

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_fco_gpc_transactions_june_2021

46.88 KB
1278 rows
7 columns


CREATE TABLE fcdo_fco_gpc_transactions_june_2021 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

FCDO (FCO) GPC Transactions March 2021

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_fco_gpc_transactions_march_2021

83.71 KB
2771 rows
7 columns


CREATE TABLE fcdo_fco_gpc_transactions_march_2021 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

FCDO (FCO) GPC Transactions March 2022

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_fco_gpc_transactions_march_2022

99.17 KB
3470 rows
7 columns


CREATE TABLE fcdo_fco_gpc_transactions_march_2022 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

FCDO (FCO) GPC Transactions May 2021

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_fco_gpc_transactions_may_2021

38.34 KB
1021 rows
7 columns


CREATE TABLE fcdo_fco_gpc_transactions_may_2021 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

FCDO (FCO) GPC Transactions November 2020

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_fco_gpc_transactions_november_2020

51.09 KB
1485 rows
7 columns


CREATE TABLE fcdo_fco_gpc_transactions_november_2020 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

FCDO (FCO) GPC Transactions November 2021

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_fco_gpc_transactions_november_2021

62.47 KB
1909 rows
7 columns


CREATE TABLE fcdo_fco_gpc_transactions_november_2021 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

FCDO (FCO) GPC Transactions October 2020

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_fco_gpc_transactions_october_2020

49.75 KB
1438 rows
7 columns


CREATE TABLE fcdo_fco_gpc_transactions_october_2020 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

FCDO (FCO) GPC Transactions September 2020

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_fco_gpc_transactions_september_2020

47.2 KB
1368 rows
7 columns


CREATE TABLE fcdo_fco_gpc_transactions_september_2020 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "unnamed_6" VARCHAR
);

FCDO (FCO) GPC Transactions September 2021

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_fco_gpc_transactions_september_2021

54.26 KB
1630 rows
7 columns


CREATE TABLE fcdo_fco_gpc_transactions_september_2021 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

FCDO Government Procurement Card Spend Over £500, April 2022

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_government_procurement_card_spend_over_500_april_2022

45.71 KB
1327 rows
7 columns


CREATE TABLE fcdo_government_procurement_card_spend_over_500_april_2022 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

FCDO Government Procurement Card Spend Over £500, April 2023

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_government_procurement_card_spend_over_500_april_2023

95.76 KB
4867 rows
7 columns


CREATE TABLE fcdo_government_procurement_card_spend_over_500_april_2023 (
  "transaction_id" BIGINT,
  "transaction_date" TIMESTAMP,
  "merchant_category_code" BIGINT,
  "supplier" VARCHAR,
  "location" VARCHAR,
  "description" VARCHAR,
  "amount" DOUBLE
);

FCDO Government Procurement Card Spend Over £500, April 2024

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_government_procurement_card_spend_over_500_april_2024

99.31 KB
5119 rows
7 columns


CREATE TABLE fcdo_government_procurement_card_spend_over_500_april_2024 (
  "transaction_id" BIGINT,
  "transaction_date" TIMESTAMP,
  "merchant_category_code" BIGINT,
  "supplier" VARCHAR,
  "location" VARCHAR,
  "description" VARCHAR,
  "amount" DOUBLE
);

FCDO Government Procurement Card Spend Over £500, August 2022

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_government_procurement_card_spend_over_500_august_2022

64.88 KB
2049 rows
7 columns


CREATE TABLE fcdo_government_procurement_card_spend_over_500_august_2022 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

FCDO Government Procurement Card Spend Over £500, August 2023

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_government_procurement_card_spend_over_500_august_2023

105.5 KB
5409 rows
7 columns


CREATE TABLE fcdo_government_procurement_card_spend_over_500_august_2023 (
  "transaction_id" BIGINT,
  "transaction_date" TIMESTAMP,
  "merchant_category_code" BIGINT,
  "supplier" VARCHAR,
  "location" VARCHAR,
  "description" VARCHAR,
  "amount" DOUBLE
);

FCDO Government Procurement Card Spend Over £500, August 2024

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_government_procurement_card_spend_over_500_august_2024

96.92 KB
5024 rows
7 columns


CREATE TABLE fcdo_government_procurement_card_spend_over_500_august_2024 (
  "transaction_id" BIGINT,
  "transaction_date" TIMESTAMP,
  "merchant_category_code" BIGINT,
  "supplier" VARCHAR,
  "location" VARCHAR,
  "description" VARCHAR,
  "amount" DOUBLE
);

FCDO Government Procurement Card Spend Over £500, December 2023

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_government_procurement_card_spend_over_500_december_2023

87.16 KB
4305 rows
7 columns


CREATE TABLE fcdo_government_procurement_card_spend_over_500_december_2023 (
  "transaction_id" BIGINT,
  "transaction_date" TIMESTAMP,
  "merchant_category_code" BIGINT,
  "supplier" VARCHAR,
  "location" VARCHAR,
  "description" VARCHAR,
  "amount" DOUBLE
);

FCDO Government Procurement Card Spend Over £500, February 2023

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_government_procurement_card_spend_over_500_february_2023

127.05 KB
6688 rows
7 columns


CREATE TABLE fcdo_government_procurement_card_spend_over_500_february_2023 (
  "transaction_id" BIGINT,
  "transaction_date" TIMESTAMP,
  "merchant_category_code" BIGINT,
  "supplier" VARCHAR,
  "location" VARCHAR,
  "description" VARCHAR,
  "amount" DOUBLE
);

FCDO Government Procurement Card Spend Over £500, February 2024

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_government_procurement_card_spend_over_500_february_2024

135.39 KB
7298 rows
7 columns


CREATE TABLE fcdo_government_procurement_card_spend_over_500_february_2024 (
  "transaction_id" BIGINT,
  "transaction_date" TIMESTAMP,
  "merchant_category_code" BIGINT,
  "supplier" VARCHAR,
  "location" VARCHAR,
  "description" VARCHAR,
  "amount" DOUBLE
);

FCDO Government Procurement Card Spend Over £500, January 2023

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_government_procurement_card_spend_over_500_january_2023

105.03 KB
5296 rows
7 columns


CREATE TABLE fcdo_government_procurement_card_spend_over_500_january_2023 (
  "transaction_id" BIGINT,
  "transaction_date" TIMESTAMP,
  "merchant_category_code" BIGINT,
  "supplier" VARCHAR,
  "location" VARCHAR,
  "description" VARCHAR,
  "amount" DOUBLE
);

FCDO Government Procurement Card Spend Over £500, January 2024

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_government_procurement_card_spend_over_500_january_2024

118.53 KB
6297 rows
7 columns


CREATE TABLE fcdo_government_procurement_card_spend_over_500_january_2024 (
  "transaction_id" BIGINT,
  "transaction_date" TIMESTAMP,
  "merchant_category_code" BIGINT,
  "supplier" VARCHAR,
  "location" VARCHAR,
  "description" VARCHAR,
  "amount" DOUBLE
);

FCDO Government Procurement Card Spend Over £500, July 2022

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_government_procurement_card_spend_over_500_july_2022

63.82 KB
2025 rows
7 columns


CREATE TABLE fcdo_government_procurement_card_spend_over_500_july_2022 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

FCDO Government Procurement Card Spend Over £500, July 2023

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_government_procurement_card_spend_over_500_july_2023

95.66 KB
4807 rows
7 columns


CREATE TABLE fcdo_government_procurement_card_spend_over_500_july_2023 (
  "transaction_id" BIGINT,
  "transaction_date" TIMESTAMP,
  "merchant_category_code" BIGINT,
  "supplier" VARCHAR,
  "location" VARCHAR,
  "description" VARCHAR,
  "amount" DOUBLE
);

Foreign, Commonwealth And Development Office: Government Procurement Card Spending Over £500

About this Dataset