Table 20

@ukgov.council_spending_over_500.table_20

201.31 kB
21,781 rows
8 columns

CREATE TABLE table_20 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION No.
);

Table 21

@ukgov.council_spending_over_500.table_21

207.32 kB
20,463 rows
8 columns

CREATE TABLE table_21 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION No.
);

Table 22

@ukgov.council_spending_over_500.table_22

211.8 kB
21,161 rows
8 columns

CREATE TABLE table_22 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION No.
);

Table 23

@ukgov.council_spending_over_500.table_23

74.6 kB
4,057 rows
11 columns

CREATE TABLE table_23 (
  "organisation_id" VARCHAR,
  "effective_date" TIMESTAMP,
  "service" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "net_amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_id" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10
);

Table 24

@ukgov.council_spending_over_500.table_24

41.01 kB
1,194 rows
8 columns

CREATE TABLE table_24 (
  "organisation_name" VARCHAR,
  "invoice_id" VARCHAR,
  "invoice_date" TIMESTAMP,
  "supplier_name" VARCHAR,
  "proclass_category" VARCHAR,
  "service_area" VARCHAR,
  "cost_centre_name" VARCHAR,
  "invoiced" DOUBLE  -- Invoiced (Ł)
);

Table 25

@ukgov.council_spending_over_500.table_25

217.02 kB
25,817 rows
8 columns

CREATE TABLE table_25 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION No.
);

Table 26

@ukgov.council_spending_over_500.table_26

94.22 kB
5,780 rows
8 columns

CREATE TABLE table_26 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT Ł,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);

Table 27

@ukgov.council_spending_over_500.table_27

79.28 kB
4,231 rows
8 columns

CREATE TABLE table_27 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "service" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "net_amount" DOUBLE  -- Net Amount (£),
  "purpose" VARCHAR,
  "transaction_number" VARCHAR
);

Table 28

@ukgov.council_spending_over_500.table_28

77.81 kB
4,601 rows
8 columns

CREATE TABLE table_28 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.
);

Table 29

@ukgov.council_spending_over_500.table_29

34.46 kB
1,382 rows
7 columns

CREATE TABLE table_29 (
  "organisation" VARCHAR,
  "invoice_date" TIMESTAMP,
  "supplier_name" VARCHAR,
  "proclass_category" VARCHAR,
  "service_area" VARCHAR,
  "cost_centre_name" VARCHAR,
  "invoiced" DOUBLE  -- Invoiced (£)
);

Table 30

@ukgov.council_spending_over_500.table_30

70.99 kB
4,016 rows
8 columns

CREATE TABLE table_30 (
  "organisation_name" VARCHAR,
  "effective_date" VARCHAR,
  "service" VARCHAR,
  "supplier_name" VARCHAR,
  "paid_date" VARCHAR,
  "amount" DOUBLE  -- AMOUNT (£),
  "purpose" VARCHAR,
  "transaction_id" VARCHAR
);

Table 31

@ukgov.council_spending_over_500.table_31

89.32 kB
5,950 rows
8 columns

CREATE TABLE table_31 (
  "organisation_id" VARCHAR,
  "effective_date" TIMESTAMP,
  "service" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "net_amount" DOUBLE  -- Net Amount (Ł),
  "purpose" VARCHAR,
  "transaction_id" VARCHAR
);

Table 32

@ukgov.council_spending_over_500.table_32

73.18 kB
4,187 rows
8 columns

CREATE TABLE table_32 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "service" VARCHAR,
  "supplier_name" VARCHAR,
  "paid_date" TIMESTAMP,
  "net_amount" DOUBLE  -- Net Amount (Ł),
  "purpose" VARCHAR,
  "transaction_number" VARCHAR
);

Table 33

@ukgov.council_spending_over_500.table_33

45.67 kB
2,000 rows
7 columns

CREATE TABLE table_33 (
  "body" VARCHAR,
  "invoice_date" TIMESTAMP,
  "supplier_name" VARCHAR,
  "proclass_category" VARCHAR,
  "service_area" VARCHAR,
  "cost_centre_name" VARCHAR,
  "invoiced" VARCHAR
);

Table 34

@ukgov.council_spending_over_500.table_34

38.56 kB
1,591 rows
8 columns

CREATE TABLE table_34 (
  "organisation" VARCHAR,
  "invoice_date" TIMESTAMP,
  "supplier_name" VARCHAR,
  "proclass_category" VARCHAR,
  "service_area" VARCHAR,
  "cost_centre_name" VARCHAR,
  "invoiced" DOUBLE  -- Invoiced Ś,
  "unnamed_7" VARCHAR  -- Unnamed: 7
);

Table 35

@ukgov.council_spending_over_500.table_35

201.09 kB
20,583 rows
8 columns

CREATE TABLE table_35 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.
);

Table 36

@ukgov.council_spending_over_500.table_36

273.87 kB
28,989 rows
8 columns

CREATE TABLE table_36 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION No.
);

Table 37

@ukgov.council_spending_over_500.table_37

40.92 kB
1,241 rows
8 columns

CREATE TABLE table_37 (
  "organisation" VARCHAR,
  "invoice_id" VARCHAR,
  "invoice_date" TIMESTAMP,
  "supplier_name" VARCHAR,
  "proclass_category" VARCHAR,
  "service_area" VARCHAR,
  "cost_centre_name" VARCHAR,
  "invoiced" DOUBLE  -- Invoiced (Ł)
);

Table 38

@ukgov.council_spending_over_500.table_38

233.98 kB
21,266 rows
8 columns

CREATE TABLE table_38 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.
);

Table 39

@ukgov.council_spending_over_500.table_39

105.35 kB
6,555 rows
8 columns

CREATE TABLE table_39 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" VARCHAR  -- AMOUNT (£),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.
);

Table 4

@ukgov.council_spending_over_500.table_4

88.8 kB
5,216 rows
8 columns

CREATE TABLE table_4 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" VARCHAR  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.
);

Table 40

@ukgov.council_spending_over_500.table_40

39.23 kB
1,185 rows
8 columns

CREATE TABLE table_40 (
  "organisation" VARCHAR,
  "invoice_id" VARCHAR,
  "invoice_date" TIMESTAMP,
  "supplier_name" VARCHAR,
  "proclass_category" VARCHAR,
  "service_area" VARCHAR,
  "cost_centre_name" VARCHAR,
  "invoiced" DOUBLE
);

Table 41

@ukgov.council_spending_over_500.table_41

88.43 kB
5,229 rows
8 columns

CREATE TABLE table_41 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" VARCHAR  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.
);

Table 42

@ukgov.council_spending_over_500.table_42

254.89 kB
27,446 rows
8 columns

CREATE TABLE table_42 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION No.
);

Table 43

@ukgov.council_spending_over_500.table_43

197.47 kB
18,608 rows
8 columns

CREATE TABLE table_43 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION No.
);

Table 44

@ukgov.council_spending_over_500.table_44

220.55 kB
23,074 rows
8 columns

CREATE TABLE table_44 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION No.
);

Table 45

@ukgov.council_spending_over_500.table_45

34.92 kB
1,242 rows
7 columns

CREATE TABLE table_45 (
  "organisation" VARCHAR,
  "invoice_date" TIMESTAMP,
  "supplier_name" VARCHAR,
  "proclass_category" VARCHAR,
  "service_area" VARCHAR,
  "cost_centre_name" VARCHAR,
  "invoiced" VARCHAR
);

Table 46

@ukgov.council_spending_over_500.table_46

106.27 kB
6,776 rows
8 columns

CREATE TABLE table_46 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" VARCHAR  -- AMOUNT (È),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.
);

Table 47

@ukgov.council_spending_over_500.table_47

216.43 kB
26,158 rows
8 columns

CREATE TABLE table_47 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.
);

Table 48

@ukgov.council_spending_over_500.table_48

74.87 kB
3,932 rows
8 columns

CREATE TABLE table_48 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "service" VARCHAR,
  "supplier_name" VARCHAR,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "net_amount" DOUBLE  -- Net Amount (Ł),
  "gl_code_desc" VARCHAR
);

Table 49

@ukgov.council_spending_over_500.table_49

219.03 kB
25,350 rows
8 columns

CREATE TABLE table_49 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.
);

Table 5

@ukgov.council_spending_over_500.table_5

84.61 kB
12,396 rows
8 columns

CREATE TABLE table_5 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" VARCHAR  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.
);

Table 50

@ukgov.council_spending_over_500.table_50

218.78 kB
25,466 rows
8 columns

CREATE TABLE table_50 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" BIGINT,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION No.
);

Table 51

@ukgov.council_spending_over_500.table_51

206.26 kB
18,215 rows
8 columns

CREATE TABLE table_51 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION No.
);

Table 52

@ukgov.council_spending_over_500.table_52

175.26 kB
18,012 rows
8 columns

CREATE TABLE table_52 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION No.
);

Table 53

@ukgov.council_spending_over_500.table_53

172.13 kB
15,444 rows
8 columns

CREATE TABLE table_53 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION No.
);

Table 55

@ukgov.council_spending_over_500.table_55

248.58 kB
30,896 rows
8 columns

CREATE TABLE table_55 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION No.
);

Table 56

@ukgov.council_spending_over_500.table_56

189.24 kB
20,313 rows
8 columns

CREATE TABLE table_56 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION No.
);

Table 57

@ukgov.council_spending_over_500.table_57

34.43 kB
1,204 rows
7 columns

CREATE TABLE table_57 (
  "body" VARCHAR,
  "invoice_date" TIMESTAMP,
  "supplier_name" VARCHAR,
  "proclass_category" VARCHAR,
  "service_area" VARCHAR,
  "cost_centre_name" VARCHAR,
  "invoiced" VARCHAR
);

Table 58

@ukgov.council_spending_over_500.table_58

216.07 kB
23,585 rows
8 columns

CREATE TABLE table_58 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION No.
);

Table 59

@ukgov.council_spending_over_500.table_59

218.28 kB
23,059 rows
8 columns

CREATE TABLE table_59 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.
);

Table 6

@ukgov.council_spending_over_500.table_6

89.33 kB
5,515 rows
8 columns

CREATE TABLE table_6 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.
);

Table 60

@ukgov.council_spending_over_500.table_60

86.34 kB
12,396 rows
8 columns

CREATE TABLE table_60 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" VARCHAR  -- AMOUNT (£),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.
);

Table 61

@ukgov.council_spending_over_500.table_61

81.42 kB
4,361 rows
8 columns

CREATE TABLE table_61 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "service" VARCHAR,
  "supplier_name" VARCHAR,
  "paiddate" TIMESTAMP,
  "net_amount" VARCHAR  -- Net Amount (Ł),
  "purpose" VARCHAR,
  "transaction_number" VARCHAR
);

Table 62

@ukgov.council_spending_over_500.table_62

37.16 kB
1,424 rows
7 columns

CREATE TABLE table_62 (
  "organisation" VARCHAR,
  "invoice_date" TIMESTAMP,
  "supplier_name" VARCHAR,
  "proclass_category" VARCHAR,
  "service_area" VARCHAR,
  "cost_centre_name" VARCHAR,
  "invoiced" VARCHAR
);

Table 63

@ukgov.council_spending_over_500.table_63

237.66 kB
23,989 rows
8 columns

CREATE TABLE table_63 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION No.
);

Table 64

@ukgov.council_spending_over_500.table_64

93.04 kB
5,979 rows
8 columns

CREATE TABLE table_64 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.
);

Table 65

@ukgov.council_spending_over_500.table_65

84.39 kB
4,976 rows
8 columns

CREATE TABLE table_65 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" VARCHAR  -- AMOUNT (£),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.
);

Table 66

@ukgov.council_spending_over_500.table_66

27.5 kB
913 rows
6 columns

CREATE TABLE table_66 (
  "invoice_date" TIMESTAMP,
  "supplier_name" VARCHAR,
  "proclass_category" VARCHAR,
  "service_area" VARCHAR,
  "cost_centre_name" VARCHAR,
  "invoiced" VARCHAR
);

Table 67

@ukgov.council_spending_over_500.table_67

75.64 kB
4,485 rows
8 columns

CREATE TABLE table_67 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "service" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.
);

Tables