About this Dataset

Council Spending

Transparency is at the heart of this government. As part of our ongoing commitment to increase openness and transparency we publish details of spend made to our suppliers. From 1 October 2018 this is all spend, and prior to this we have published where spend is equal to or over £500. Please note, if we make payments to individuals or sole traders, we remove the supplier names to comply with the Data Protection Act, replacing with ‘Redacted – Personal Data’.
Publisher name: Rochdale Borough Council
Last updated: 2025-04-03T04:00:37Z

Tables

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