About this Dataset

Defra Government Procurement Card Spend - Transactions Over £500

Defra has published all Government Procurement Card (GPC) spend for Departmental GPC’s. The data published includes transactions that have a single transaction value of £500 or above. From May 2013, the releases contain data from core Defra and its Arms Length Bodies.
Publisher name: Department for Environment, Food and Rural Affairs
Last updated: 2025-05-02T04:00:25Z

Tables

Defra GPC Spend Over £500 - June 2017

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_june_2017

57.54 kB
739 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_june_2017 (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - June 2018 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_june_2018_revised

57.58 kB
701 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_june_2018_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - June 2019 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_june_2019_revised

51.89 kB
694 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_june_2019_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - June 2020 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_june_2020_revised

32.5 kB
375 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_june_2020_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - March 2017

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_march_2017

17.99 kB
190 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_march_2017 (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - March 2018 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_march_2018_revised

85.48 kB
1,192 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_march_2018_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - March 2019 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_march_2019_revised

80.25 kB
1,152 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_march_2019_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - March 2020 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_march_2020_revised

85.73 kB
1,026 rows
7 columns

CREATE TABLE defra_gpc_spend_over_500_march_2020_revised (
  "jncc_09_03_2020_amznmktplace_957_23_wireless_headset" VARCHAR  -- JNCC,09/03/2020,AMZNMKTPLACE,Ł957.23,"Wireless Headset,
  "surface_pro_keyboard" VARCHAR,
  "isopropyl_alcohol_cleaning_spray" VARCHAR,
  "server_kvm_adaptors" VARCHAR,
  "hard_drive_enclosures_neoprene_sleeves_x6" VARCHAR  -- Hard Drive Enclosures + Neoprene Sleeves (x6),
  "replacement_iphone_headphone_adaptor" VARCHAR,
  "wireless_headsets_keyboards_iphone_headset_adaptors_la_18f5958d" VARCHAR  -- Wireless Headsets, Keyboards, IPhone Headset Adaptors, Laptop Sleeves, Kensington Laptop Locks, Disposable Gloves."
);

Defra GPC Spend Over £500 - May 2017

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_may_2017

78.3 kB
1,052 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_may_2017 (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - May 2018 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_may_2018_revised

76.88 kB
859 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_may_2018_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - May 2019 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_may_2019_revised

53.65 kB
712 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_may_2019_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - May 2020 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_may_2020_revised

43.82 kB
612 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_may_2020_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - November 2016

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_november_2016

13.65 kB
117 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_november_2016 (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - November 2017 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_november_2017_revised

61.09 kB
755 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_november_2017_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - November 2018 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_november_2018_revised

54.33 kB
700 rows
6 columns

CREATE TABLE defra_gpc_spend_over_500_november_2018_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "ta" VARCHAR,
  "notes" VARCHAR
);

Defra GPC Spend Over £500 - November 2019 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_november_2019_revised

49.86 kB
639 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_november_2019_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - October 2017 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_october_2017_revised

59.49 kB
763 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_october_2017_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - October 2018 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_october_2018_revised

58.32 kB
796 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_october_2018_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - October 2019 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_october_2019_revised

52.53 kB
684 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_october_2019_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - October 2020 - Revised 2

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_october_2020_revised_2

38.21 kB
440 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_october_2020_revised_2 (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - September 2018 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_september_2018_revised

53.94 kB
606 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_september_2018_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - September 2019 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_september_2019_revised

48.97 kB
621 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_september_2019_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);

Defra GPC Spend Over £500 - September 2020 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_september_2020_revised

33.29 kB
358 rows
5 columns

CREATE TABLE defra_gpc_spend_over_500_september_2020_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR
);

September 2017 - Return Revised

@ukgov.defra_gpc_spend_over_500_pounds.september_2017_return_revised

57.28 kB
655 rows
5 columns

CREATE TABLE september_2017_return_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" VARCHAR
);