About this Dataset

Spend Over £25,000 In Norfolk And Suffolk NHS Foundation Trust

A monthly-updated list of all financial transactions spending over £25,000 made by Norfolk and Suffolk NHS Foundation Trust., as part of the Government's commitment to transparency in expenditure. Norfolk and Waveney Mental Health NHS Foundation Trust and Suffolk Mental Health Partnership NHS Trust merged as of 3 January 2012
Publisher name: Norfolk and Suffolk NHS Foundation Trust
Last updated: 2023-04-25T04:05:12Z

Tables

April 2019

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.april_2019

9.76 kB
50 rows
8 columns

CREATE TABLE april_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

April 2022

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.april_2022

9.76 kB
50 rows
8 columns

CREATE TABLE april_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

August 2020

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.august_2020

9.76 kB
50 rows
8 columns

CREATE TABLE august_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

August 2021

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.august_2021

9.76 kB
50 rows
8 columns

CREATE TABLE august_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

August 2022

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.august_2022

9.76 kB
50 rows
8 columns

CREATE TABLE august_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

December 2020

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.december_2020

9.76 kB
50 rows
8 columns

CREATE TABLE december_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

February 2019

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.february_2019

9.76 kB
50 rows
8 columns

CREATE TABLE february_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

February 2022

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.february_2022

9.76 kB
50 rows
8 columns

CREATE TABLE february_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

January 2019

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.january_2019

9.76 kB
50 rows
8 columns

CREATE TABLE january_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

January 2021

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.january_2021

9.76 kB
50 rows
8 columns

CREATE TABLE january_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

January 2022

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.january_2022

9.76 kB
50 rows
8 columns

CREATE TABLE january_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

July 2019

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.july_2019

9.76 kB
50 rows
8 columns

CREATE TABLE july_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

July 2021

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.july_2021

9.76 kB
50 rows
8 columns

CREATE TABLE july_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

July 2022

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.july_2022

9.76 kB
50 rows
8 columns

CREATE TABLE july_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

June 2019

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.june_2019

9.76 kB
50 rows
8 columns

CREATE TABLE june_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

June 2021

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.june_2021

9.76 kB
50 rows
8 columns

CREATE TABLE june_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

June 2022

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.june_2022

9.76 kB
50 rows
8 columns

CREATE TABLE june_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

March 2019

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.march_2019

9.76 kB
50 rows
8 columns

CREATE TABLE march_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

March 2021

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.march_2021

9.76 kB
50 rows
8 columns

CREATE TABLE march_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

March 2022

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.march_2022

9.76 kB
50 rows
8 columns

CREATE TABLE march_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

May 2019

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.may_2019

9.76 kB
50 rows
8 columns

CREATE TABLE may_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

May 2021

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.may_2021

9.76 kB
50 rows
8 columns

CREATE TABLE may_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

May 2022

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.may_2022

9.76 kB
50 rows
8 columns

CREATE TABLE may_2022 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

November 2020

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.november_2020

9.76 kB
50 rows
8 columns

CREATE TABLE november_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);

November 2021

@ukgov.https_www_nsft_nhs_uk_spending_over_25k.november_2021

9.76 kB
50 rows
8 columns

CREATE TABLE november_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "n__amount" VARCHAR  -- Amount,
  "date_paid" TIMESTAMP
);