FCDO (DFID): Spending Over £25,000, April 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_april_2021

18.67 kB
402 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_april_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "n__posted_date" TIMESTAMP  -- Posted Date,
  "internal_voucher_number" VARCHAR,
  "n__invoice_line_amount_gbp" VARCHAR  -- Invoice Line Amount GBP,
  "n__supplier_name" VARCHAR  -- Supplier Name,
  "n__account_code" VARCHAR  -- Account Code
);

FCDO (DFID): Spending Over £25,000, April 2022

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_april_2022

17.31 kB
324 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_april_2022 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "invoice_line_amount_gbp" VARCHAR,
  "n__supplier_name" VARCHAR  -- Supplier Name,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, August 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_august_2021

19.54 kB
440 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_august_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "invoice_line_amount_gbp" VARCHAR,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, December 2020

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_december_2020

28.96 kB
881 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_december_2020 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "invoice_line_amount_gbp" VARCHAR,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, December 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_december_2021

20.56 kB
513 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_december_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "invoice_line_amount_gbp" VARCHAR,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, February 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_february_2021

20.89 kB
513 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_february_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "n__invoice_line_amount_gbp" VARCHAR  -- Invoice Line Amount GBP,
  "n__supplier_name" VARCHAR  -- Supplier Name,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, February 2022

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_february_2022

20.63 kB
469 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_february_2022 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "invoice_line_amount_gbp" VARCHAR,
  "n__supplier_name" VARCHAR  -- Supplier Name,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, January 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_january_2021

18.82 kB
409 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_january_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "invoice_line_amount_gbp" VARCHAR,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, January 2022

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_january_2022

17.32 kB
346 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_january_2022 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "invoice_line_amount_gbp" VARCHAR,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, July 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_july_2021

19.18 kB
435 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_july_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "invoice_line_amount_gbp" VARCHAR,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, June 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_june_2021

18.7 kB
451 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_june_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "invoice_line_amount_gbp" VARCHAR,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, March 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_march_2021

26.92 kB
762 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_march_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "n__posted_date" TIMESTAMP  -- Posted Date,
  "internal_voucher_number" VARCHAR,
  "n__invoice_line_amount_gbp" VARCHAR  -- Invoice Line Amount GBP,
  "n__supplier_name" VARCHAR  -- Supplier Name,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, March 2022

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_march_2022

23.45 kB
611 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_march_2022 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "invoice_line_amount_gbp" VARCHAR,
  "n__supplier_name" VARCHAR  -- Supplier Name,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, May 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_may_2021

18.07 kB
377 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_may_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "n__posted_date" TIMESTAMP  -- Posted Date,
  "internal_voucher_number" VARCHAR,
  "invoice_line_amount_gbp" VARCHAR,
  "n__supplier_name" VARCHAR  -- Supplier Name,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, May 2022

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_may_2022

17.88 kB
377 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_may_2022 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "invoice_line_amount_gbp" VARCHAR  -- Invoice Line Amount (GBP),
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, November 2020

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_november_2020

24.1 kB
654 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_november_2020 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "invoice_line_amount_gbp" VARCHAR,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, November 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_november_2021

21.83 kB
533 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_november_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "invoice_line_amount_gbp" VARCHAR,
  "n__supplier_name" VARCHAR  -- Supplier Name,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, October 2020

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_october_2020

24.75 kB
655 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_october_2020 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "invoice_line_amount_gbp" VARCHAR,
  "n__supplier_name" VARCHAR  -- Supplier Name,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, October 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_october_2021

18.61 kB
407 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_october_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "invoice_line_amount_gbp" VARCHAR,
  "n__supplier_name" VARCHAR  -- Supplier Name,
  "n__expense_type" VARCHAR  -- Expense Type
);

FCDO (DFID): Spending Over £25,000, September 2020

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_september_2020

21.11 kB
514 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_september_2020 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "n__invoice_line_amount_gbp" VARCHAR  -- Invoice Line Amount GBP,
  "n__supplier_name" VARCHAR  -- Supplier Name,
  "account_code" VARCHAR
);

FCDO (DFID): Spending Over £25,000, September 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_dfid_spending_over_25_000_september_2021

19.24 kB
454 rows
7 columns

CREATE TABLE fcdo_dfid_spending_over_25_000_september_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" VARCHAR,
  "invoice_line_amount_gbp" VARCHAR,
  "n__supplier_name" VARCHAR  -- Supplier Name,
  "n__account_code" VARCHAR  -- Account Code
);

FCDO (FCO): Spending Over £25,000, April 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_april_2021

28.34 kB
935 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_april_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, April 2022

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_april_2022

27.82 kB
868 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_april_2022 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, August 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_august_2021

24.72 kB
742 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_august_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "internal_voucher_number" BIGINT,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, December 2020

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_december_2020

30.12 kB
1,004 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_december_2020 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, December 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_december_2021

32.17 kB
1,094 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_december_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, February 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_february_2021

29.64 kB
936 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_february_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, February 2022

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_february_2022

30.1 kB
996 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_february_2022 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, January 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_january_2021

27.71 kB
885 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_january_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "intrenal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, January 2022

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_january_2022

29.04 kB
905 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_january_2022 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, July 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_july_2021

26.74 kB
844 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_july_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, March 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_march_2021

41.06 kB
1,479 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_march_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, March 2022

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_march_2022

44.04 kB
1,569 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_march_2022 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" DOUBLE,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, May 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_may_2021

24.28 kB
745 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_may_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "invoice_line_amount_gbp" DOUBLE,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, May 2022

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_may_2022

28.44 kB
924 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_may_2022 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, November 2020

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_november_2020

27.35 kB
845 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_november_2020 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, November 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_november_2021

27.61 kB
862 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_november_2021 (
  "department" VARCHAR,
  "entiry" VARCHAR,
  "posted_date" TIMESTAMP,
  "interenal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, October 2020

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_october_2020

28.28 kB
898 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_october_2020 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, October 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_october_2021

29.15 kB
945 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_october_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, September 2020

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_september_2020

25.39 kB
769 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_september_2020 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO (FCO): Spending Over £25,000, September 2021

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_fco_spending_over_25_000_september_2021

26.93 kB
854 rows
7 columns

CREATE TABLE fcdo_fco_spending_over_25_000_september_2021 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "posted_date" TIMESTAMP,
  "internal_voucher_number" BIGINT,
  "n__invoice_line_amount_gbp" DOUBLE  -- Invoice Line Amount GBP,
  "supplier_name" VARCHAR,
  "account_code" VARCHAR
);

FCDO’s Spending Over £25,000 For April 2023

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_s_spending_over_25_000_for_april_2023

46.57 kB
2,194 rows
8 columns

CREATE TABLE fcdo_s_spending_over_25_000_for_april_2023 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "unique_identifier" BIGINT,
  "invoice_line_number" BIGINT,
  "supplier_name" VARCHAR,
  "invoice_gbp_line_amt" VARCHAR,
  "category" VARCHAR
);

FCDO’s Spending Over £25,000 For April 2024

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_s_spending_over_25_000_for_april_2024

55.25 kB
3,629 rows
8 columns

CREATE TABLE fcdo_s_spending_over_25_000_for_april_2024 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "unique_identifier" BIGINT,
  "invoice_line_number" BIGINT,
  "supplier_name" VARCHAR,
  "invoice_gbp_line_amt" DOUBLE,
  "category" VARCHAR
);

FCDO’s Spending Over £25,000 For August 2022

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_s_spending_over_25_000_for_august_2022

25.22 kB
999 rows
8 columns

CREATE TABLE fcdo_s_spending_over_25_000_for_august_2022 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "unique_identifier" BIGINT,
  "invoice_line_number" BIGINT,
  "supplier_name" VARCHAR,
  "invoice_gbp_line_amt" VARCHAR,
  "category" VARCHAR
);

FCDO’s Spending Over £25,000 For August 2023

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_s_spending_over_25_000_for_august_2023

47.98 kB
2,556 rows
8 columns

CREATE TABLE fcdo_s_spending_over_25_000_for_august_2023 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "unique_identifier" BIGINT,
  "invoice_line_number" BIGINT,
  "supplier_name" VARCHAR,
  "invoice_gbp_line_amt" VARCHAR,
  "category" VARCHAR
);

FCDO’s Spending Over £25,000 For August 2024

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_s_spending_over_25_000_for_august_2024

56.81 kB
4,217 rows
8 columns

CREATE TABLE fcdo_s_spending_over_25_000_for_august_2024 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "unique_identifier" BIGINT,
  "invoice_line_number" BIGINT,
  "supplier_name" VARCHAR,
  "invoice_gbp_line_amt" DOUBLE,
  "category" VARCHAR
);

FCDO’s Spending Over £25,000 For December 2022

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_s_spending_over_25_000_for_december_2022

45.04 kB
2,032 rows
8 columns

CREATE TABLE fcdo_s_spending_over_25_000_for_december_2022 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "unique_identifier" BIGINT,
  "invoice_line_number" BIGINT,
  "supplier_name" VARCHAR,
  "invoice_gbp_line_amt" VARCHAR,
  "category" VARCHAR
);

FCDO’s Spending Over £25,000 For December 2023

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_s_spending_over_25_000_for_december_2023

54.5 kB
2,983 rows
8 columns

CREATE TABLE fcdo_s_spending_over_25_000_for_december_2023 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "unique_identifier" BIGINT,
  "invoice_line_number" BIGINT,
  "supplier_name" VARCHAR,
  "invoice_gbp_line_amt" VARCHAR,
  "category" VARCHAR
);

FCDO’s Spending Over £25,000 For February 2023

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_s_spending_over_25_000_for_february_2023

54.56 kB
3,008 rows
8 columns

CREATE TABLE fcdo_s_spending_over_25_000_for_february_2023 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "unique_identifier" BIGINT,
  "invoice_line_number" BIGINT,
  "supplier_name" VARCHAR,
  "invoice_gbp_line_amt" VARCHAR,
  "category" VARCHAR
);

FCDO’s Spending Over £25,000 For February 2024

@ukgov.foreign_commonwealth_and_development_office_spending_o_7f977faf.fcdo_s_spending_over_25_000_for_february_2024

65.27 kB
5,448 rows
8 columns

CREATE TABLE fcdo_s_spending_over_25_000_for_february_2024 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "unique_identifier" BIGINT,
  "invoice_line_number" BIGINT,
  "supplier_name" VARCHAR,
  "invoice_gbp_line_amt" DOUBLE,
  "category" VARCHAR
);

Tables