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

56.19 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

56.23 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

50.67 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

31.74 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.57 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

83.48 KB
1192 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

78.37 KB
1152 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

83.72 KB
1026 rows
7 columns


CREATE TABLE defra_gpc_spend_over_500_march_2020_revised (
  "jncc_09_03_2020_amznmktplace_957_23_wireless_headset" VARCHAR,
  "surface_pro_keyboard" VARCHAR,
  "isopropyl_alcohol_cleaning_spray" VARCHAR,
  "server_kvm_adaptors" VARCHAR,
  "hard_drive_enclosures_neoprene_sleeves_x6" VARCHAR,
  "replacement_iphone_headphone_adaptor" VARCHAR,
  "wireless_headsets_keyboards_iphone_headset_adaptors_la_18f5958d" VARCHAR
);

Defra GPC Spend Over £500 - May 2017

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_may_2017

76.46 KB
1052 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

75.07 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

52.39 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

42.79 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.33 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

59.66 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

53.06 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

48.69 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

58.1 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

56.96 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

51.3 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

37.31 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

52.67 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

47.82 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

32.51 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

55.94 KB
655 rows
5 columns


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