Baselight

Spend Over £25,000 In St Helens And Knowsley Hospitals NHS Trust

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust

Loading...
Loading...

About this Dataset

Spend Over £25,000 In St Helens And Knowsley Hospitals NHS Trust

A monthly-updated list of all financial transactions spending over £25,000 made by St Helens and Knowsley Hospitals NHS Trust, as part of the Government's commitment to transparency in expenditure.
Last updated: 2023-07-11T19:51:42Z

Tables

APR-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.apr_22
  • 10.25 KB
  • 156 rows
  • 8 columns
Loading...

CREATE TABLE apr_22 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "n__ap_amount" DOUBLE
);

APR-23

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.apr_23
  • 16.88 KB
  • 219 rows
  • 12 columns
Loading...

CREATE TABLE apr_23 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE,
  "supplier_postcode" VARCHAR,
  "vat_registration_number" VARCHAR,
  "purchase_invoice_number" VARCHAR,
  "unnamed_11" VARCHAR
);

AUG-21

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.aug_21
  • 9.12 KB
  • 102 rows
  • 8 columns
Loading...

CREATE TABLE aug_21 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "ap_amount" DOUBLE
);

AUG-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.aug_22
  • 11.52 KB
  • 194 rows
  • 8 columns
Loading...

CREATE TABLE aug_22 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "n__total" DOUBLE
);

DEC-21

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.dec_21
  • 118.83 KB
  • 96 rows
  • 210 columns
Loading...

CREATE TABLE dec_21 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" 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,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" VARCHAR,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR,
  "unnamed_68" VARCHAR,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" VARCHAR,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" VARCHAR,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" VARCHAR,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR,
  "unnamed_83" VARCHAR,
  "unnamed_84" VARCHAR,
  "unnamed_85" VARCHAR,
  "unnamed_86" VARCHAR,
  "unnamed_87" VARCHAR,
  "unnamed_88" VARCHAR,
  "unnamed_89" VARCHAR,
  "unnamed_90" VARCHAR,
  "unnamed_91" VARCHAR,
  "unnamed_92" VARCHAR,
  "unnamed_93" VARCHAR,
  "unnamed_94" VARCHAR,
  "unnamed_95" VARCHAR,
  "unnamed_96" VARCHAR,
  "unnamed_97" VARCHAR,
  "unnamed_98" VARCHAR,
  "unnamed_99" VARCHAR
);

DEC-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.dec_22
  • 16.26 KB
  • 636 rows
  • 9 columns
Loading...

CREATE TABLE dec_22 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "ap_amount" DOUBLE,
  "unnamed_8" VARCHAR
);

FEB-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.feb_22
  • 9.01 KB
  • 96 rows
  • 8 columns
Loading...

CREATE TABLE feb_22 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "ap_amount" DOUBLE
);

JAN-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.jan_22
  • 14.72 KB
  • 539 rows
  • 8 columns
Loading...

CREATE TABLE jan_22 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

JAN-23

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.jan_23
  • 11.21 KB
  • 181 rows
  • 8 columns
Loading...

CREATE TABLE jan_23 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "ap_amount" DOUBLE
);

JUL-21

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.jul_21
  • 9.37 KB
  • 86 rows
  • 8 columns
Loading...

CREATE TABLE jul_21 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "ap_amount" DOUBLE
);

JUL-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.jul_22
  • 10.53 KB
  • 128 rows
  • 8 columns
Loading...

CREATE TABLE jul_22 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "n__total" DOUBLE
);

Jun-21

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.jun_21
  • 13.7 KB
  • 289 rows
  • 9 columns
Loading...

CREATE TABLE jun_21 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE,
  "unnamed_8" VARCHAR
);

JUN-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.jun_22
  • 13.11 KB
  • 302 rows
  • 8 columns
Loading...

CREATE TABLE jun_22 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_area" VARCHAR,
  "expense_type" VARCHAR,
  "transaction_number" DOUBLE,
  "supplier" VARCHAR,
  "n__total" DOUBLE
);

JUN-23

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.jun_23
  • 19.6 KB
  • 674 rows
  • 11 columns
Loading...

CREATE TABLE jun_23 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "ap_amount" DOUBLE,
  "supplier_postcode" VARCHAR,
  "vat_registration_number" VARCHAR,
  "purchase_invoice_number" VARCHAR
);

MAR-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.mar_22
  • 19.28 KB
  • 552 rows
  • 14 columns
Loading...

CREATE TABLE mar_22 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "ap_amount" DOUBLE,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR
);

May-21

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.may_21
  • 11.45 KB
  • 128 rows
  • 10 columns
Loading...

CREATE TABLE may_21 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

MAY-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.may_22
  • 10.58 KB
  • 159 rows
  • 8 columns
Loading...

CREATE TABLE may_22 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "ap_amount" DOUBLE
);

MAY-23

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.may_23
  • 15.89 KB
  • 212 rows
  • 11 columns
Loading...

CREATE TABLE may_23 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "ap_amount" DOUBLE,
  "supplier_postcode" VARCHAR,
  "vat_registration_number" VARCHAR,
  "purchase_invoice_number" VARCHAR
);

NOV-21

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.nov_21
  • 10 KB
  • 131 rows
  • 8 columns
Loading...

CREATE TABLE nov_21 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "n__ap_amount" DOUBLE
);

NOV-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.nov_22
  • 10.21 KB
  • 141 rows
  • 9 columns
Loading...

CREATE TABLE nov_22 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "n__ap_amount" DOUBLE,
  "unnamed_8" VARCHAR
);

OCT-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.oct_22
  • 12 KB
  • 698 rows
  • 8 columns
Loading...

CREATE TABLE oct_22 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "n__total" DOUBLE
);

SEP-21

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.sep_21
  • 9.12 KB
  • 83 rows
  • 8 columns
Loading...

CREATE TABLE sep_21 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "ap_amount" DOUBLE
);

SEP-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.sep_22
  • 12.74 KB
  • 775 rows
  • 8 columns
Loading...

CREATE TABLE sep_22 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "n__total" DOUBLE
);

Share link

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