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

April 2016 Return Revised

@ukgov.financial_transactions_data_defra.april_2016_return_revised
  • 58.97 kB
  • 627 rows
  • 15 columns
Loading... 
CREATE TABLE april_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
);

April 2017 Return - Revised

@ukgov.financial_transactions_data_defra.april_2017_return_revised
  • 63.71 kB
  • 674 rows
  • 15 columns
Loading... 
CREATE TABLE april_2017_return_revised (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "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
);

April 2018 Return Revised

@ukgov.financial_transactions_data_defra.april_2018_return_revised
  • 55.17 kB
  • 457 rows
  • 15 columns
Loading... 
CREATE TABLE april_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
);

April 2019 Return Revised

@ukgov.financial_transactions_data_defra.april_2019_return_revised
  • 74.69 kB
  • 858 rows
  • 15 columns
Loading... 
CREATE TABLE april_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
);

August 2016 Return - Revised

@ukgov.financial_transactions_data_defra.august_2016_return_revised
  • 45.67 kB
  • 500 rows
  • 15 columns
Loading... 
CREATE TABLE august_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
);

August 2017 Return Revised

@ukgov.financial_transactions_data_defra.august_2017_return_revised
  • 60.73 kB
  • 664 rows
  • 15 columns
Loading... 
CREATE TABLE august_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
);

August 2018 Return Revised

@ukgov.financial_transactions_data_defra.august_2018_return_revised
  • 65.8 kB
  • 808 rows
  • 15 columns
Loading... 
CREATE TABLE august_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
);

August 2019 Return Revised

@ukgov.financial_transactions_data_defra.august_2019_return_revised
  • 58.67 kB
  • 626 rows
  • 15 columns
Loading... 
CREATE TABLE august_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
);

December 2016 Return - Revised

@ukgov.financial_transactions_data_defra.december_2016_return_revised
  • 51.2 kB
  • 555 rows
  • 15 columns
Loading... 
CREATE TABLE december_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
);

December 2017 Return Revised

@ukgov.financial_transactions_data_defra.december_2017_return_revised
  • 57.17 kB
  • 673 rows
  • 15 columns
Loading... 
CREATE TABLE december_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
);

December 2018 Return Revised

@ukgov.financial_transactions_data_defra.december_2018_return_revised
  • 68.59 kB
  • 875 rows
  • 15 columns
Loading... 
CREATE TABLE december_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
);

December 2019 Return Revised

@ukgov.financial_transactions_data_defra.december_2019_return_revised
  • 68.18 kB
  • 769 rows
  • 15 columns
Loading... 
CREATE TABLE december_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
);

February 2017 Return - Revised

@ukgov.financial_transactions_data_defra.february_2017_return_revised
  • 55.12 kB
  • 579 rows
  • 15 columns
Loading... 
CREATE TABLE february_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
);

February 2018 Return Revised

@ukgov.financial_transactions_data_defra.february_2018_return_revised
  • 63.58 kB
  • 784 rows
  • 15 columns
Loading... 
CREATE TABLE february_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
);

February 2019 Return Revised

@ukgov.financial_transactions_data_defra.february_2019_return_revised
  • 47.45 kB
  • 360 rows
  • 15 columns
Loading... 
CREATE TABLE february_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
);

February 2020 Revised

@ukgov.financial_transactions_data_defra.february_2020_revised
  • 48.46 kB
  • 368 rows
  • 15 columns
Loading... 
CREATE TABLE february_2020_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
);

January 2016 Return Revised

@ukgov.financial_transactions_data_defra.january_2016_return_revised
  • 49.88 kB
  • 482 rows
  • 15 columns
Loading... 
CREATE TABLE january_2016_return_revised (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "n__amount" DOUBLE  -- Amount,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "contract_number" VARCHAR,
  "project_code" VARCHAR,
  "expenditure_type" VARCHAR,
  "vat_registration_num" VARCHAR
);

January 2017 Return - Revised

@ukgov.financial_transactions_data_defra.january_2017_return_revised
  • 48.79 kB
  • 503 rows
  • 15 columns
Loading... 
CREATE TABLE january_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
);

January 2018 Return Revised

@ukgov.financial_transactions_data_defra.january_2018_return_revised
  • 55.75 kB
  • 673 rows
  • 15 columns
Loading... 
CREATE TABLE january_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
);

January 2019 Return Revised

@ukgov.financial_transactions_data_defra.january_2019_return_revised
  • 63.02 kB
  • 764 rows
  • 15 columns
Loading... 
CREATE TABLE january_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
);

January 2020 Return Revised

@ukgov.financial_transactions_data_defra.january_2020_return_revised
  • 64.97 kB
  • 726 rows
  • 15 columns
Loading... 
CREATE TABLE january_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
);

July 2016 Return

@ukgov.financial_transactions_data_defra.july_2016_return
  • 52.19 kB
  • 512 rows
  • 15 columns
Loading... 
CREATE TABLE july_2016_return (
  "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
);

July 2017 Return Revised

@ukgov.financial_transactions_data_defra.july_2017_return_revised
  • 54.27 kB
  • 584 rows
  • 15 columns
Loading... 
CREATE TABLE july_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
);

July 2018 Return Revised

@ukgov.financial_transactions_data_defra.july_2018_return_revised
  • 61.82 kB
  • 698 rows
  • 15 columns
Loading... 
CREATE TABLE july_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
);

July 2019 Return - Revised

@ukgov.financial_transactions_data_defra.july_2019_return_revised
  • 67.52 kB
  • 777 rows
  • 15 columns
Loading... 
CREATE TABLE july_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.