Baselight
Sign In

Spend In BSUH NHS Trust

Brighton and Sussex University Hospitals NHS Trust

@ukgov.financial_transactions_data_bsuh_nhs_trust

Loading...
Loading...

About this Dataset

Spend In BSUH NHS Trust

A monthly updated list of all financial transactions spending over £25K made by Brighton and Sussex University Hospitals NHS Trust, as part of the Governments commitment to transparency in expenditure.
Publisher name: Brighton and Sussex University Hospitals NHS Trust
Last updated: 2022-07-01T04:02:36Z

Tables

2019 April Data

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2019_april_data
  • 155.22 kB
  • 54,351 rows
  • 8 columns
Loading... 
CREATE TABLE n_2019_april_data (
  "hm_treasury_start_date_01_apr_2019_end_date_30_apr_2019" VARCHAR  -- HM Treasury Data Start Date: '01-APR-2019', End Date: '30-APR-2019',
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "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
);

2019 August Return

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2019_august_return
  • 93.79 kB
  • 31,159 rows
  • 8 columns
Loading... 
CREATE TABLE n_2019_august_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE
);

2019 December Return

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2019_december_return
  • 142.1 kB
  • 54,213 rows
  • 8 columns
Loading... 
CREATE TABLE n_2019_december_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE
);

2019 February Return

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2019_february_return
  • 122.59 kB
  • 43,172 rows
  • 8 columns
Loading... 
CREATE TABLE n_2019_february_return (
  "hm_treasury_start_date_01_feb_2019_end_date_28_feb_2019" VARCHAR  -- HM Treasury Data Start Date: '01-FEB-2019', End Date: '28-FEB-2019',
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "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
);

2019 July Data

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2019_july_data
  • 141.25 kB
  • 53,502 rows
  • 8 columns
Loading... 
CREATE TABLE n_2019_july_data (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE
);

2019 March Return

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2019_march_return
  • 128.24 kB
  • 45,134 rows
  • 8 columns
Loading... 
CREATE TABLE n_2019_march_return (
  "hm_treasury_start_date_01_mar_2019_end_date_31_mar_2019" VARCHAR  -- HM Treasury Data Start Date: '01-MAR-2019', End Date: '31-MAR-2019',
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "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
);

2019 May Data

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2019_may_data
  • 123.64 kB
  • 44,289 rows
  • 8 columns
Loading... 
CREATE TABLE n_2019_may_data (
  "hm_treasury_start_date_01_may_2019_end_date_31_may_2019" VARCHAR  -- HM Treasury Data Start Date: '01-MAY-2019', End Date: '31-MAY-2019',
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "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
);

2020 April Return

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2020_april_return
  • 117.33 kB
  • 38,776 rows
  • 8 columns
Loading... 
CREATE TABLE n_2020_april_return (
  "hm_treasury_start_date_01_apr_2020_end_date_30_apr_2020" VARCHAR  -- HM Treasury Data Start Date: '01-APR-2020', End Date: '30-APR-2020',
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "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
);

2020 August Return

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2020_august_return
  • 202.14 kB
  • 72,881 rows
  • 8 columns
Loading... 
CREATE TABLE n_2020_august_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE
);

2020 December Return

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2020_december_return
  • 109.62 kB
  • 36,085 rows
  • 8 columns
Loading... 
CREATE TABLE n_2020_december_return (
  "hm_treasury_start_date_01_12_2020_end_date_31_12_2020" VARCHAR  -- HM Treasury Data Start Date : '01/12/2020' , End Date : '31/12/2020',
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "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
);

2020 February Return

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2020_february_return
  • 122.69 kB
  • 43,437 rows
  • 8 columns
Loading... 
CREATE TABLE n_2020_february_return (
  "hm_treasury_start_date_01_feb_2020_end_date_29_feb_2020" VARCHAR  -- HM Treasury Data Start Date : '01-FEB-2020' , End Date : '29-FEB-2020',
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "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
);

2020 January Return

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2020_january_return
  • 116.75 kB
  • 41,143 rows
  • 8 columns
Loading... 
CREATE TABLE n_2020_january_return (
  "hm_treasury_start_date_01_jan_2020_end_date_31_jan_2020" VARCHAR  -- HM Treasury Data Start Date: '01-JAN-2020', End Date: '31-JAN-2020',
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "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
);

2020 June Return

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2020_june_return
  • 107.23 kB
  • 36,514 rows
  • 8 columns
Loading... 
CREATE TABLE n_2020_june_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE
);

2020 March Return

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2020_march_return
  • 150.66 kB
  • 56,120 rows
  • 8 columns
Loading... 
CREATE TABLE n_2020_march_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE
);

2020 May Return

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2020_may_return
  • 85.21 kB
  • 27,101 rows
  • 8 columns
Loading... 
CREATE TABLE n_2020_may_return (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE
);

2020 November Return

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2020_november_return
  • 107.72 kB
  • 36,434 rows
  • 8 columns
Loading... 
CREATE TABLE n_2020_november_return (
  "hm_treasury_start_date_01_11_2020_end_date_30_11_2020" VARCHAR  -- HM Treasury Data Start Date : '01/11/2020' , End Date : '30/11/2020',
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "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
);

2020 October Return

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2020_october_return
  • 102.96 kB
  • 34,747 rows
  • 8 columns
Loading... 
CREATE TABLE n_2020_october_return (
  "hm_treasury_start_date_01_10_2020_end_date_31_10_2020" VARCHAR  -- HM Treasury Data Start Date : '01/10/2020' , End Date : '31/10/2020',
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "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
);

2020 September Return

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2020_september_return
  • 210.59 kB
  • 75,608 rows
  • 8 columns
Loading... 
CREATE TABLE n_2020_september_return (
  "hm_treasury_start_date_01_sep_2020_end_date_30_nov_2020" VARCHAR  -- HM Treasury Data Start Date : '01-SEP-2020' , End Date : '30-NOV-2020',
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "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
);

2021 February Return

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2021_february_return
  • 102.57 kB
  • 33,329 rows
  • 8 columns
Loading... 
CREATE TABLE n_2021_february_return (
  "hm_treasury_start_date_01_02_2021_end_date_28_02_2021" VARCHAR  -- HM Treasury Data Start Date : '01/02/2021' , End Date : '28/02/2021',
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "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
);

2021 January Return

@ukgov.financial_transactions_data_bsuh_nhs_trust.n_2021_january_return
  • 96.88 kB
  • 31,889 rows
  • 8 columns
Loading... 
CREATE TABLE n_2021_january_return (
  "hm_treasury_start_date_01_jan_2021_end_date_31_jan_2021" VARCHAR  -- HM Treasury Data Start Date : '01-JAN-2021' , End Date : '31-JAN-2021',
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "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
);

Share link

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