Baselight

Defra Government Procurement Card Spend - Transactions Over £500

Department for Environment, Food and Rural Affairs

@ukgov.defra_gpc_spend_over_500_pounds

Loading...
Loading...

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 Government Procurement Card Spend - Transactions Over £500

@ukgov.defra_gpc_spend_over_500_pounds.defra_government_procurement_card_spend_transactions_over_500
  • 50.95 KB
  • 673 rows
  • 5 columns
Loading...

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

Defra GPC Spend Over £500 - August 2018 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_august_2018_revised
  • 56.34 KB
  • 733 rows
  • 5 columns
Loading...

CREATE TABLE defra_gpc_spend_over_500_august_2018_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "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
Loading...

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 - August 2020 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_august_2020_revised
  • 31.13 KB
  • 350 rows
  • 5 columns
Loading...

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

Defra GPC Spend Over £500 - December 2017 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_december_2017_revised
  • 51.59 KB
  • 702 rows
  • 5 columns
Loading...

CREATE TABLE defra_gpc_spend_over_500_december_2017_revised (
  "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
Loading...

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 - February 2017

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_february_2017
  • 15.14 KB
  • 167 rows
  • 5 columns
Loading...

CREATE TABLE defra_gpc_spend_over_500_february_2017 (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "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
Loading...

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 - 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
Loading...

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 - 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
Loading...

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 - May 2017

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_may_2017
  • 76.46 KB
  • 1052 rows
  • 5 columns
Loading...

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 - December 2018 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_december_2018_revised
  • 61.38 KB
  • 780 rows
  • 5 columns
Loading...

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

Defra GPC Spend Over £500 - April 2018 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_april_2018_revised
  • 56.78 KB
  • 722 rows
  • 5 columns
Loading...

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

Defra GPC Spend Over £500 - August 2019 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_august_2019_revised
  • 50.69 KB
  • 718 rows
  • 5 columns
Loading...

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

Defra GPC Spend Over £500 - February 2019 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_february_2019_revised
  • 47.36 KB
  • 585 rows
  • 7 columns
Loading...

CREATE TABLE defra_gpc_spend_over_500_february_2019_revised (
  "jncc_25_02_2019_themanagementcentr_3835_2_accommodatio_f3842f27" VARCHAR,
  "n__dinner_at_bangor_university_dinner_for_9_jncc_staff" VARCHAR,
  "n__5_officials" VARCHAR,
  "n__8_committee_members" VARCHAR,
  "n__and_2_guests_accommodation_x_11_jncc_staff" VARCHAR,
  "n__4_committee_members" VARCHAR,
  "n__2_audit_risk_accounting_committee_members_and_1_guest" 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
Loading...

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 - August 2017 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_august_2017_revised
  • 58.53 KB
  • 727 rows
  • 5 columns
Loading...

CREATE TABLE defra_gpc_spend_over_500_august_2017_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "description" 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
Loading...

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 - April 2017

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_april_2017
  • 19.18 KB
  • 203 rows
  • 5 columns
Loading...

CREATE TABLE defra_gpc_spend_over_500_april_2017 (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "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
Loading...

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
Loading...

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 - April 2020 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_april_2020_revised
  • 16.62 KB
  • 160 rows
  • 5 columns
Loading...

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

Defra GPC Spend Over £500 - February 2018 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_february_2018_revised
  • 53.32 KB
  • 765 rows
  • 5 columns
Loading...

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

Defra GPC Spend Over £500 - July 2018 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_july_2018_revised
  • 69.41 KB
  • 826 rows
  • 5 columns
Loading...

CREATE TABLE defra_gpc_spend_over_500_july_2018_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
Loading...

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
Loading...

CREATE TABLE september_2017_return_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "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
Loading...

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 2018 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_november_2018_revised
  • 53.06 KB
  • 700 rows
  • 6 columns
Loading...

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 - 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
Loading...

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 - 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
Loading...

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 - June 2017

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_june_2017
  • 56.19 KB
  • 739 rows
  • 5 columns
Loading...

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 - 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
Loading...

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 - December 2019 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_december_2019_revised
  • 49.17 KB
  • 663 rows
  • 5 columns
Loading...

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

Defra GPC Spend Over £500 - July 2020 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_july_2020_revised
  • 33.02 KB
  • 398 rows
  • 5 columns
Loading...

CREATE TABLE defra_gpc_spend_over_500_july_2020_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
Loading...

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 - 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
Loading...

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 - January 2020 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_january_2020_revised
  • 46.82 KB
  • 647 rows
  • 5 columns
Loading...

CREATE TABLE defra_gpc_spend_over_500_january_2020_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "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
Loading...

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 - January 2018 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_january_2018_revised
  • 50.78 KB
  • 702 rows
  • 5 columns
Loading...

CREATE TABLE defra_gpc_spend_over_500_january_2018_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "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
Loading...

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 - April 2019 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_april_2019_revised
  • 68.66 KB
  • 760 rows
  • 11 columns
Loading...

CREATE TABLE defra_gpc_spend_over_500_april_2019_revised (
  "jncc_26_04_2019_park_avenue_hotel_belfast_4_555_50_one_ca3b5745" VARCHAR,
  "n__dinner_at_park4_avenue_hotel_for_10_jncc_staff" VARCHAR,
  "n__9_official_attendees" VARCHAR,
  "n__11_committee_members_accommodation_x_9_jncc_staff_8_57571042" VARCHAR,
  "n__1_x_1_night" VARCHAR,
  "n__4_committee_members_x_2_nights" VARCHAR,
  "n__x_1_night_x_2_official_attendees" VARCHAR,
  "n__meeting_refreshments_x_2_days_for_10_jncc_staff" VARCHAR,
  "n__11_committee_members" VARCHAR,
  "n__10_guests" VARCHAR,
  "n__9_official_attendees_d685ce" VARCHAR
);

Defra GPC Spend Over £500 - July 2017

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_july_2017
  • 55.29 KB
  • 697 rows
  • 5 columns
Loading...

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

Defra GPC Spend Over £500 - February 2020 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_february_2020_revised
  • 48.12 KB
  • 673 rows
  • 5 columns
Loading...

CREATE TABLE defra_gpc_spend_over_500_february_2020_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" DOUBLE,
  "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
Loading...

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 - January 2017

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_january_2017
  • 13.4 KB
  • 123 rows
  • 5 columns
Loading...

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

Defra GPC Spend Over £500 - July 2019 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_july_2019_revised
  • 54.96 KB
  • 776 rows
  • 5 columns
Loading...

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

Defra GPC Spend Over £500 - December 2016

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_december_2016
  • 13.06 KB
  • 106 rows
  • 5 columns
Loading...

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

Defra GPC Spend Over £500 - January 2019 Revised

@ukgov.defra_gpc_spend_over_500_pounds.defra_gpc_spend_over_500_january_2019_revised
  • 50.67 KB
  • 712 rows
  • 5 columns
Loading...

CREATE TABLE defra_gpc_spend_over_500_january_2019_revised (
  "entity" VARCHAR,
  "gl_date" TIMESTAMP,
  "merchant_name" VARCHAR,
  "amount" VARCHAR,
  "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
Loading...

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

Share link

Anyone who has the link will be able to view this.