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

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
);

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
);

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
);

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
);

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
);

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
);

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
);

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
);

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
);

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
);

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
);

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
);

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
);

CREATE TABLE november_2018_return_revised (
  "defra_defra_01_11_2018_exp_grant_in_aid_to_arms_length_f9201259" VARCHAR  -- DEFRA,DEFRA,01/11/2018,EXP - GRANT-IN-AID TO ARMS LENGTH BODIES,CORPORATE FINANCE,ENVIRONMENT AGENCY,30000276,45000000,"EA01112018GIA,
  "n__grant_in_aid_fundig" VARCHAR  -- - Grant In Aid Fundig,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "n__bs1_5ah_supplier_0_expense_662_4901_34_defra_defra__f64cbd8d" VARCHAR  -- ,BS1–5AH,SUPPLIER,,0,Expense,662–4901 34 DEFRA,DEFRA,01/11/2018,EXP - GRANT-IN-AID TO ARMS LENGTH BODIES,CORPORATE FINANCE,NATURAL ENGLAND,30000278,9469000,NE01112018GIA - Grant In Aid Fundig ,YO1–7PX,SUPPLIER,,0,Expense,551065074 DEFRA,DEFRA,01/11/2018,EXP - GRANT-IN-AID TO ARMS LENGTH BODIES,CORPORATE FINANCE,JOINT NATURE CONSERVATION COMMITTEE,30001046,1100000,JNCC01112018GIA,
  "n__grant_in_aid_fundig_2e1d30" VARCHAR  -- - Grant In Aid Fundig,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "n__pe1_1jy_ndpb_0_expense_854529109_defra_defra_01_11__1f4a3757" VARCHAR  -- ,PE1–1JY,NDPB,,0,Expense,854529109 DEFRA,DEFRA,01/11/2018,EXP - GRANT-IN-AID TO ARMS LENGTH BODIES,CORPORATE FINANCE,ROYAL BOTANIC GARDENS KEW,30001047,3305833.33,RBG-KEW01112018GIA - Grant In Aid Fundig ,TW9–3AB,NDPB,,0,Expense, DEFRA,DEFRA,01/11/2018,EXP - PURCHASE OF GOODS/SERVICES - ICT OUTSOURCING & MAINT/SUPPORT,Group Infrastructure & Operations,AUTOMATION LOGIC LTD,1003059541,64000.18,DDTS Transition Design Devops & Webops Delivery (CSU),SE1–8TG,SUPPLIER,52318,DEAPANCX,Expense,985044595 DEFRA,DEFRA,01/11/2018,EXP - CAPITAL GRANTS TO LOCAL GOVERNMENT,AIR QUALITY & INDUSTRIAL EMISSIONS,BARNSLEY METROPOLITAN BOROUGH COUNCIL,1003059542,125000,Air Quality Grant 2017-18 Barnsley Metropolitan Borough Council,S70–2TA,SUPPLIER,ecm 51901,0,Expense,182–2141 85 DEFRA,DEFRA,01/11/2018,EXP - CURRENT GRANTS TO PRIVATE SECTOR - NON PROFIT INSTITUTIONS SERVING H'HOLD,FLS - OFFICIAL DEVELOPMENT ASSISTANCE,ROYAL BOTANIC GARDENS KEW,1003059547,25416.5,DPLUS080 Securing South Georgia’s Native Habitats Following Invasive Species Control 1/4/18 - 31/3/21,TW9–3AB,NDPB,GIA,DEA10153,Expense, DEFRA,DEFRA,01/11/2018,EXP - CURRENT GRANTS TO LOCAL GOVERNMENT,AIR QUALITY & INDUSTRIAL EMISSIONS,CITY OF YORK COUNCIL,1003059550,216008,This LA Was Awarded The Funds Through The Air Quality Grant Scheme 2017-18,YO1–6GA,SUPPLIER,GIA,0,Expense,GB647365022 DEFRA,DEFRA,02/11/2018,EXP - PURCHASE OF GOODS/SERVICES - CONTRACTORS - MANAGEMENT COVER,PROJECT MANAGEMENT OFFICE,REED PROFESSIONAL SERVICES LLP,1003059588,61500,Provision Of Interim Staff For Defra Group PMO,SW20–0BA,Consultancy,ECM 51131,0,Expense,GB 918488774 DEFRA,DEFRA,02/11/2018,Exp - Purchase Of Goods/Services - Consultancy,PROJECT MANAGEMENT OFFICE,REED PROFESSIONAL SERVICES LLP,1003059588,52482,Interim Resources For EU Exit DEFWP013,SW20–0BA,Consultancy,ecm 51131.,0,Expense,GB 918488774 DEFRA,DEFRA,02/11/2018,Exp - Purchase Of Goods/Services - Consultancy,GREAT BRITISH FOOD UNIT,REED PROFESSIONAL SERVICES LLP,1003059588,58906,DEFWP104 Agri-Food Chain PPM Support For Staff For The Period 4/6/18-31/8/18,SW20–0BA,Consultancy,51131,0,Expense,GB 918488774 DEFRA,DEFRA,02/11/2018,EXP - PURCHASE OF GOODS/SERVICES - RESEARCH & DEVELOPMENT - OTHER OUTSOURCED,PLANT HEALTH,FERA SCIENCE LIMITED,1003059654,84181.62,PH0469 (CCN05) - Future Proofing Plant Health - FY18/19 - Fera Science,YO41–1LZ,SUPPLIER(1),18228,0,Expense,207199894 DEFRA,DEFRA,02/11/2018,EXP - PURCHASE OF GOODS/SERVICES - CONTRACTORS - MANAGEMENT COVER,FINANCIAL TRANSACTIONS,HAYS SPECIALIST RECRUITMENT LTD,1003059655,706131.19,CONSOLIDATED CONTRACTOR FEES. ,KT3–4QF,CIS SUPPLIER,,0,Expense,GB773695871 DEFRA,DEFRA,02/11/2018,EXP - PURCHASE OF GOODS/SERVICES - OTHER PROFESSIONAL SERVICES,SHARED SERVICE CONNECTED LIMITED (SSCL),SHARED SERVICES CONNECTED LTD,1003059659,29963.57,Cost Of Delivering 39189 - Strategic Reachback For Defra - Monthly Ongoing To End Of March 2018,HP2–7AH,SUPPLIER,ecm 4524,0,Expense,171798078 DEFRA,DEFRA,02/11/2018,EXP - PURCHASE OF GOODS/SERVICES - OFFICE RELATED - PUBLICATIONS,KNOWLEDGE AND INFORMATION MANAGEMENT,CAMBRIDGE INFORMATION LTD,1003059660,34850,New Subscription For DEFRA – Nature.com Complete – Access Only,IP14–2EN,SUPPLIER,"SUBS""",DEFLIBEU,Expense,
);

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: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16
);

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
);

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
);

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
);

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
);

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
);

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
);

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
);

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
);

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
);