Baselight
Sign In

Government Procurement Card Spend Over £500

Foreign and Commonwealth Office

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5

Loading...
Loading...

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
  • 41.68 kB
  • 1,117 rows
  • 7 columns
Loading... 
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
  • 33.14 kB
  • 928 rows
  • 7 columns
Loading... 
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
  • 53.78 kB
  • 1,598 rows
  • 7 columns
Loading... 
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
  • 39.14 kB
  • 1,025 rows
  • 7 columns
Loading... 
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
  • 51.35 kB
  • 1,478 rows
  • 9 columns
Loading... 
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: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

December 2019 FCO Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.december_2019_fco_spending_over_500
  • 57.89 kB
  • 1,778 rows
  • 7 columns
Loading... 
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  -- AMOUNT,
  "supplier" VARCHAR
);

February 2019 FCO Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.february_2019_fco_spending_over_500
  • 61.44 kB
  • 1,921 rows
  • 7 columns
Loading... 
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
  • 60.55 kB
  • 1,926 rows
  • 7 columns
Loading... 
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  -- AMOUNT,
  "supplier" VARCHAR
);

Government Procurement Card Spend Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.government_procurement_card_spend_over_500
  • 26.36 kB
  • 972 rows
  • 8 columns
Loading... 
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
  • 54.67 kB
  • 1,609 rows
  • 7 columns
Loading... 
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
  • 60.55 kB
  • 1,926 rows
  • 7 columns
Loading... 
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  -- AMOUNT,
  "supplier" VARCHAR
);

July 2019 FCO Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.july_2019_fco_spending_over_500
  • 56.93 kB
  • 1,741 rows
  • 9 columns
Loading... 
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  -- AMOUNT,
  "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
  • 44.33 kB
  • 1,224 rows
  • 7 columns
Loading... 
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
  • 52.23 kB
  • 1,536 rows
  • 7 columns
Loading... 
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  -- AMOUNT,
  "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
  • 37.06 kB
  • 1,000 rows
  • 7 columns
Loading... 
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
  • 86.19 kB
  • 2,897 rows
  • 7 columns
Loading... 
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
  • 33.14 kB
  • 928 rows
  • 7 columns
Loading... 
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
  • 32.33 kB
  • 873 rows
  • 7 columns
Loading... 
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
  • 57.74 kB
  • 1,778 rows
  • 7 columns
Loading... 
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
  • 60.66 kB
  • 1,844 rows
  • 7 columns
Loading... 
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  -- AMOUNT,
  "supplier" VARCHAR
);

October 2018 FCO Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.october_2018_fco_spending_over_500
  • 57.07 kB
  • 1,742 rows
  • 7 columns
Loading... 
CREATE TABLE october_2018_fco_spending_over_500 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "n__merchant_category_code_description2" VARCHAR  -- MERCHANT CATEGORY CODE DESCRIPTION2,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "n__amount" DOUBLE  -- AMOUNT,
  "supplier" VARCHAR
);

October 2019 FCO Spending Over £500

@ukgov.https_www_gov_uk_government_collections_foreign_office_1c96f6d5.october_2019_fco_spending_over_500
  • 62.54 kB
  • 1,963 rows
  • 7 columns
Loading... 
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
  • 48.21 kB
  • 1,403 rows
  • 7 columns
Loading... 
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
);

Share link

Anyone who has the link will be able to view this.