FCDO (FCO) GPC Transactions January 2021

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_fco_gpc_transactions_january_2021

44.68 kB
1,193 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

55.13 kB
1,580 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

46.79 kB
1,270 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

48.01 kB
1,278 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

85.72 kB
2,771 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

101.55 kB
3,470 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

39.26 kB
1,021 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

52.32 kB
1,485 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

63.97 kB
1,909 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

50.95 kB
1,438 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

48.33 kB
1,368 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  -- Unnamed: 6
);

FCDO (FCO) GPC Transactions September 2021

@ukgov.fcdo_government_procurement_card_spending_over_f500.fcdo_fco_gpc_transactions_september_2021

55.56 kB
1,630 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

46.81 kB
1,327 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

98.06 kB
4,867 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

101.69 kB
5,119 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

66.44 kB
2,049 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

108.04 kB
5,409 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

99.25 kB
5,024 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

89.25 kB
4,305 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

130.1 kB
6,688 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

138.63 kB
7,298 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

107.55 kB
5,296 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

121.38 kB
6,297 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

65.36 kB
2,025 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

97.96 kB
4,807 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