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