About this Dataset

DFID Government E-payments Framework Transactions

All DFID GPC transactions made in the United Kingdom above £500 as from October 2011, backdated to April 2011. The transactions for the quarter April-June 2011 are now available and will be followed by the quarter July 2011 - September 2011, thereafter on a monthly basis
Publisher name: Department for International Development
Last updated: 2022-07-01T04:02:43Z

Tables

April 2019 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.april_2019_gpc_transactions

3.88 kB
13 rows
3 columns

CREATE TABLE april_2019_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

April 2020 Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.april_2020_transactions

3.67 kB
8 rows
3 columns

CREATE TABLE april_2020_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

August 2019 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.august_2019_gpc_transactions

3.74 kB
10 rows
3 columns

CREATE TABLE august_2019_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

August 2020 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.august_2020_gpc_transactions

3.53 kB
7 rows
3 columns

CREATE TABLE august_2020_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

December 2019 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.december_2019_gpc_transactions

3.96 kB
18 rows
3 columns

CREATE TABLE december_2019_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

DFID Government E-payments Framework Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.dfid_government_e_payments_framework_transactions

10.13 kB
1,048,138 rows
3 columns

CREATE TABLE dfid_government_e_payments_framework_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

February 2019 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.february_2019_gpc_transactions

4.14 kB
26 rows
3 columns

CREATE TABLE february_2019_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

February 2020 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.february_2020_gpc_transactions

4.07 kB
27 rows
3 columns

CREATE TABLE february_2020_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

January 2019 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.january_2019_gpc_transactions

4.05 kB
23 rows
3 columns

CREATE TABLE january_2019_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

January 2020 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.january_2020_gpc_transactions

4.03 kB
22 rows
3 columns

CREATE TABLE january_2020_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

July 2019 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.july_2019_gpc_transactions

3.93 kB
18 rows
3 columns

CREATE TABLE july_2019_gpc_transactions (
  "n" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

July 2020 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.july_2020_gpc_transactions

3.77 kB
15 rows
3 columns

CREATE TABLE july_2020_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

June 2019 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.june_2019_gpc_transactions

4.93 kB
18 rows
5 columns

CREATE TABLE june_2019_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

June 2020 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.june_2020_gpc_transactions

3.73 kB
14 rows
3 columns

CREATE TABLE june_2020_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

March 2020 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.march_2020_gpc_transactions

4.42 kB
42 rows
3 columns

CREATE TABLE march_2020_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

May 2019 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.may_2019_gpc_transactions

3.83 kB
15 rows
3 columns

CREATE TABLE may_2019_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

May 2020 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.may_2020_gpc_transactions

3.49 kB
6 rows
3 columns

CREATE TABLE may_2020_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

November 2019 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.november_2019_gpc_transactions

3.83 kB
12 rows
3 columns

CREATE TABLE november_2019_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

October 2019 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.october_2019_gpc_transactions

4.06 kB
22 rows
3 columns

CREATE TABLE october_2019_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

October 2020 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.october_2020_gpc_transactions

3.77 kB
15 rows
3 columns

CREATE TABLE october_2020_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

September 2019 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.september_2019_gpc_transactions

4.03 kB
23 rows
3 columns

CREATE TABLE september_2019_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

September 2020 GPC Transactions

@ukgov.dfid_gpc_transactions_over_500_quarterly.september_2020_gpc_transactions

3.79 kB
19 rows
3 columns

CREATE TABLE september_2020_gpc_transactions (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);