Baselight
Sign In

Spend Over £25,000 In The Department For Environment, Food And Rural Affairs

Department for Environment, Food and Rural Affairs

@ukgov.financial_transactions_data_defra

Loading...
Loading...

About this Dataset

Spend Over £25,000 In The Department For Environment, Food And Rural Affairs

A monthly-updated list of all financial transactions spending over £25,000 made by the Department for Environment, Food and Rural Affairs, as part of the Government's commitment to transparency in expenditure. From April 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

June 2016 Return - Revised

@ukgov.financial_transactions_data_defra.june_2016_return_revised
  • 49.88 KB
  • 545 rows
  • 15 columns
Loading... 

CREATE TABLE june_2016_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

June 2017 Return Revised

@ukgov.financial_transactions_data_defra.june_2017_return_revised
  • 54.61 KB
  • 621 rows
  • 15 columns
Loading... 

CREATE TABLE june_2017_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

June 2018 Return Revised

@ukgov.financial_transactions_data_defra.june_2018_return_revised
  • 60.32 KB
  • 683 rows
  • 15 columns
Loading... 

CREATE TABLE june_2018_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

June 2019 Return Revised

@ukgov.financial_transactions_data_defra.june_2019_return_revised
  • 64.97 KB
  • 772 rows
  • 15 columns
Loading... 

CREATE TABLE june_2019_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

March 2017 Return - Revised

@ukgov.financial_transactions_data_defra.march_2017_return_revised
  • 75.85 KB
  • 938 rows
  • 15 columns
Loading... 

CREATE TABLE march_2017_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

March 2018 Return Revised

@ukgov.financial_transactions_data_defra.march_2018_return_revised
  • 94.94 KB
  • 1370 rows
  • 15 columns
Loading... 

CREATE TABLE march_2018_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

March 2019 Return Revised

@ukgov.financial_transactions_data_defra.march_2019_return_revised
  • 95.66 KB
  • 1420 rows
  • 15 columns
Loading... 

CREATE TABLE march_2019_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

March 2020 Return Revised

@ukgov.financial_transactions_data_defra.march_2020_return_revised
  • 103.7 KB
  • 2435 rows
  • 15 columns
Loading... 

CREATE TABLE march_2020_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

May 2016 Return - Revised

@ukgov.financial_transactions_data_defra.may_2016_return_revised
  • 38.16 KB
  • 335 rows
  • 15 columns
Loading... 

CREATE TABLE may_2016_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

May 2017 Return - Revised

@ukgov.financial_transactions_data_defra.may_2017_return_revised
  • 55.36 KB
  • 550 rows
  • 15 columns
Loading... 

CREATE TABLE may_2017_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

May 2018 Return Revised

@ukgov.financial_transactions_data_defra.may_2018_return_revised
  • 60.24 KB
  • 699 rows
  • 15 columns
Loading... 

CREATE TABLE may_2018_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

May 2019 Return Revised

@ukgov.financial_transactions_data_defra.may_2019_return_revised
  • 66.12 KB
  • 804 rows
  • 15 columns
Loading... 

CREATE TABLE may_2019_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

November 2017 Return Revised

@ukgov.financial_transactions_data_defra.november_2017_return_revised
  • 58.67 KB
  • 687 rows
  • 15 columns
Loading... 

CREATE TABLE november_2017_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

November 2018 Return Revised

@ukgov.financial_transactions_data_defra.november_2018_return_revised
  • 86.2 KB
  • 621 rows
  • 23 columns
Loading... 

CREATE TABLE november_2018_return_revised (
  "defra_defra_01_11_2018_exp_grant_in_aid_to_arms_length_f9201259" VARCHAR,
  "n__grant_in_aid_fundig" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "n__bs1_5ah_supplier_0_expense_662_4901_34_defra_defra__f64cbd8d" VARCHAR,
  "n__grant_in_aid_fundig_2e1d30" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "n__pe1_1jy_ndpb_0_expense_854529109_defra_defra_01_11__1f4a3757" VARCHAR
);

November 2019 Return Revised

@ukgov.financial_transactions_data_defra.november_2019_return_revised
  • 65.4 KB
  • 718 rows
  • 17 columns
Loading... 

CREATE TABLE november_2019_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR
);

Novermber 2016 Return - Revised

@ukgov.financial_transactions_data_defra.novermber_2016_return_revised
  • 48.28 KB
  • 538 rows
  • 15 columns
Loading... 

CREATE TABLE novermber_2016_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

October 2016 Return - Revised

@ukgov.financial_transactions_data_defra.october_2016_return_revised
  • 50.51 KB
  • 551 rows
  • 15 columns
Loading... 

CREATE TABLE october_2016_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

October 2017 Return Revised

@ukgov.financial_transactions_data_defra.october_2017_return_revised
  • 63.48 KB
  • 735 rows
  • 15 columns
Loading... 

CREATE TABLE october_2017_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

October 2018 Return Revised

@ukgov.financial_transactions_data_defra.october_2018_return_revised
  • 70.46 KB
  • 825 rows
  • 15 columns
Loading... 

CREATE TABLE october_2018_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

October 2019 Return Revised

@ukgov.financial_transactions_data_defra.october_2019_return_revised
  • 67.14 KB
  • 769 rows
  • 15 columns
Loading... 

CREATE TABLE october_2019_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

September 2016 Return - Revised

@ukgov.financial_transactions_data_defra.september_2016_return_revised
  • 51.67 KB
  • 553 rows
  • 15 columns
Loading... 

CREATE TABLE september_2016_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

September 2017 Return Revised

@ukgov.financial_transactions_data_defra.september_2017_return_revised
  • 49.69 KB
  • 602 rows
  • 15 columns
Loading... 

CREATE TABLE september_2017_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

September 2018 Return Revised

@ukgov.financial_transactions_data_defra.september_2018_return_revised
  • 55.99 KB
  • 642 rows
  • 15 columns
Loading... 

CREATE TABLE september_2018_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

September 2019 Return Revised

@ukgov.financial_transactions_data_defra.september_2019_return_revised
  • 62.93 KB
  • 723 rows
  • 15 columns
Loading... 

CREATE TABLE september_2019_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

Share link

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