About this Dataset

Government Procurement Card Spend Over £500

A list of all Government Procurement Card financial transactions spending over £500 made by the Foreign and Commonwealth Office (FCO), as part of the Government's commitment to transparency in expenditure. FCO merged with the Department for International Development on 1 September 2020. This data continues to be published on the Foreign, Commonwealth and Development Office's publication page.
Publisher name: Foreign and Commonwealth Office
Last updated: 2024-09-14T12:23:19Z

Tables

April 2019 FCO Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.april_2019_fco_spending_over_500

40.7 KB
1117 rows
7 columns


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

April 2020 GPC Card Spend Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.april_2020_gpc_card_spend_over_500

32.36 KB
928 rows
7 columns


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

August 2019 FCO Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.august_2019_fco_spending_over_500

52.52 KB
1598 rows
7 columns


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

August 2020 FCO GPC Card Spend Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.august_2020_fco_gpc_card_spend_over_500

38.23 KB
1025 rows
7 columns


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

December 2018 FCO Spend Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.december_2018_fco_spend_over_500

50.14 KB
1478 rows
9 columns


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

December 2019 FCO Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.december_2019_fco_spending_over_500

56.53 KB
1778 rows
7 columns


CREATE TABLE december_2019_fco_spending_over_500 (
  "n" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "n__amount" DOUBLE,
  "supplier" VARCHAR
);

February 2019 FCO Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.february_2019_fco_spending_over_500

60 KB
1921 rows
7 columns


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

February 2020 GPC Card Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.february_2020_gpc_card_spending_over_500

59.13 KB
1926 rows
7 columns


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

Government Procurement Card Spend Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.government_procurement_card_spend_over_500

25.74 KB
972 rows
8 columns


CREATE TABLE government_procurement_card_spend_over_500 (
  "unique_reference_number" VARCHAR,
  "date" VARCHAR,
  "merchant_category_code" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR,
  "comment" VARCHAR
);

January 2019 FCO Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.january_2019_fco_spending_over_500

53.39 KB
1609 rows
7 columns


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

January 2020 GPC Card Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.january_2020_gpc_card_spending_over_500

59.13 KB
1926 rows
7 columns


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

July 2019 FCO Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.july_2019_fco_spending_over_500

55.6 KB
1741 rows
9 columns


CREATE TABLE july_2019_fco_spending_over_500 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "n__amount" DOUBLE,
  "supplier" VARCHAR
);

July 2020 FCO GPC Card Spend Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.july_2020_fco_gpc_card_spend_over_500

43.29 KB
1224 rows
7 columns


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

June 2019 FCO Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.june_2019_fco_spending_over_500

51.01 KB
1536 rows
7 columns


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

June 2020 FCO GPC Card Spend Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.june_2020_fco_gpc_card_spend_over_500

36.2 KB
1000 rows
7 columns


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

March 2019 FCO Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.march_2019_fco_spending_over_500

84.17 KB
2897 rows
7 columns


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

March 2020 GPC Card Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.march_2020_gpc_card_spending_over_500

32.36 KB
928 rows
7 columns


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

May 2020 FCO GPC Card Spend Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.may_2020_fco_gpc_card_spend_over_500

31.57 KB
873 rows
7 columns


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

November 2018 FCO Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.november_2018_fco_spending_over_500

56.39 KB
1778 rows
7 columns


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

November 2019 FCO Spend Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.november_2019_fco_spend_over_500

59.24 KB
1844 rows
7 columns


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

October 2018 FCO Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.october_2018_fco_spending_over_500

55.73 KB
1742 rows
7 columns


CREATE TABLE october_2018_fco_spending_over_500 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "n__merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "n__amount" DOUBLE,
  "supplier" VARCHAR
);

October 2019 FCO Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.october_2019_fco_spending_over_500

61.08 KB
1963 rows
7 columns


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

September 2018 FCO Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.september_2018_fco_spending_over_500

47.08 KB
1403 rows
7 columns


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