APR-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.apr_22

10.5 kB
156 rows
8 columns

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

APR-23

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.apr_23

17.28 kB
219 rows
12 columns

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  -- Unnamed: 11
);

AUG-21

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.aug_21

9.34 kB
102 rows
8 columns

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.79 kB
194 rows
8 columns

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

DEC-21

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.dec_21

121.68 kB
96 rows
210 columns

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: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "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,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "unnamed_56" VARCHAR  -- Unnamed: 56,
  "unnamed_57" VARCHAR  -- Unnamed: 57,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "unnamed_60" VARCHAR  -- Unnamed: 60,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "unnamed_62" VARCHAR  -- Unnamed: 62,
  "unnamed_63" VARCHAR  -- Unnamed: 63,
  "unnamed_64" VARCHAR  -- Unnamed: 64,
  "unnamed_65" VARCHAR  -- Unnamed: 65,
  "unnamed_66" VARCHAR  -- Unnamed: 66,
  "unnamed_67" VARCHAR  -- Unnamed: 67,
  "unnamed_68" VARCHAR  -- Unnamed: 68,
  "unnamed_69" VARCHAR  -- Unnamed: 69,
  "unnamed_70" VARCHAR  -- Unnamed: 70,
  "unnamed_71" VARCHAR  -- Unnamed: 71,
  "unnamed_72" VARCHAR  -- Unnamed: 72,
  "unnamed_73" VARCHAR  -- Unnamed: 73,
  "unnamed_74" VARCHAR  -- Unnamed: 74,
  "unnamed_75" VARCHAR  -- Unnamed: 75,
  "unnamed_76" VARCHAR  -- Unnamed: 76,
  "unnamed_77" VARCHAR  -- Unnamed: 77,
  "unnamed_78" VARCHAR  -- Unnamed: 78,
  "unnamed_79" VARCHAR  -- Unnamed: 79,
  "unnamed_80" VARCHAR  -- Unnamed: 80,
  "unnamed_81" VARCHAR  -- Unnamed: 81,
  "unnamed_82" VARCHAR  -- Unnamed: 82,
  "unnamed_83" VARCHAR  -- Unnamed: 83,
  "unnamed_84" VARCHAR  -- Unnamed: 84,
  "unnamed_85" VARCHAR  -- Unnamed: 85,
  "unnamed_86" VARCHAR  -- Unnamed: 86,
  "unnamed_87" VARCHAR  -- Unnamed: 87,
  "unnamed_88" VARCHAR  -- Unnamed: 88,
  "unnamed_89" VARCHAR  -- Unnamed: 89,
  "unnamed_90" VARCHAR  -- Unnamed: 90,
  "unnamed_91" VARCHAR  -- Unnamed: 91,
  "unnamed_92" VARCHAR  -- Unnamed: 92,
  "unnamed_93" VARCHAR  -- Unnamed: 93,
  "unnamed_94" VARCHAR  -- Unnamed: 94,
  "unnamed_95" VARCHAR  -- Unnamed: 95,
  "unnamed_96" VARCHAR  -- Unnamed: 96,
  "unnamed_97" VARCHAR  -- Unnamed: 97,
  "unnamed_98" VARCHAR  -- Unnamed: 98,
  "unnamed_99" VARCHAR  -- Unnamed: 99
);

DEC-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.dec_22

16.65 kB
636 rows
9 columns

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  -- Unnamed: 8
);

FEB-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.feb_22

9.22 kB
96 rows
8 columns

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

15.07 kB
539 rows
8 columns

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.48 kB
181 rows
8 columns

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.59 kB
86 rows
8 columns

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.78 kB
128 rows
8 columns

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

Jun-21

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.jun_21

14.03 kB
289 rows
9 columns

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  -- Unnamed: 8
);

JUN-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.jun_22

13.42 kB
302 rows
8 columns

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

JUN-23

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.jun_23

20.07 kB
674 rows
11 columns

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.75 kB
552 rows
14 columns

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: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13
);

May-21

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.may_21

11.73 kB
128 rows
10 columns

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: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

MAY-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.may_22

10.83 kB
159 rows
8 columns

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

16.27 kB
212 rows
11 columns

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.24 kB
131 rows
8 columns

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

NOV-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.nov_22

10.46 kB
141 rows
9 columns

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  -- AP Amount,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

OCT-22

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.oct_22

12.29 kB
698 rows
8 columns

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

SEP-21

@ukgov.spend_over_25000_in_st_helens_and_knowsley_hospitals_nhs_trust.sep_21

9.34 kB
83 rows
8 columns

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

13.04 kB
775 rows
8 columns

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

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

About this Dataset