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 1

@ukgov.council_spending_over_500.table_1

238.91 kB
23,191 rows
8 columns

CREATE TABLE table_1 (
  "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 10

@ukgov.council_spending_over_500.table_10

79.08 kB
4,411 rows
16 columns

CREATE TABLE table_10 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "service" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.,
  "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" DOUBLE  -- Unnamed: 15
);

Table 100

@ukgov.council_spending_over_500.table_100

24.49 kB
723 rows
6 columns

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

Table 101

@ukgov.council_spending_over_500.table_101

91.46 kB
4,793 rows
8 columns

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

Table 102

@ukgov.council_spending_over_500.table_102

256.8 kB
27,557 rows
8 columns

CREATE TABLE table_102 (
  "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 103

@ukgov.council_spending_over_500.table_103

219.23 kB
27,239 rows
8 columns

CREATE TABLE table_103 (
  "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 104

@ukgov.council_spending_over_500.table_104

23.59 kB
722 rows
6 columns

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

Table 105

@ukgov.council_spending_over_500.table_105

66.12 kB
3,713 rows
9 columns

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

Table 106

@ukgov.council_spending_over_500.table_106

223.7 kB
25,695 rows
8 columns

CREATE TABLE table_106 (
  "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 107

@ukgov.council_spending_over_500.table_107

203.43 kB
20,646 rows
8 columns

CREATE TABLE table_107 (
  "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 108

@ukgov.council_spending_over_500.table_108

74.22 kB
3,959 rows
8 columns

CREATE TABLE table_108 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "service" VARCHAR,
  "supplier_name" VARCHAR,
  "payment_date" TIMESTAMP,
  "net_amount" DOUBLE  -- Net Amount (Ż),
  "purpose" VARCHAR,
  "transaction_number" VARCHAR
);

Table 109

@ukgov.council_spending_over_500.table_109

76.82 kB
4,505 rows
8 columns

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

Table 11

@ukgov.council_spending_over_500.table_11

204.77 kB
17,722 rows
8 columns

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

Table 110

@ukgov.council_spending_over_500.table_110

80.49 kB
4,767 rows
8 columns

CREATE TABLE table_110 (
  "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 111

@ukgov.council_spending_over_500.table_111

205.23 kB
23,432 rows
8 columns

CREATE TABLE table_111 (
  "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 112

@ukgov.council_spending_over_500.table_112

212.79 kB
22,319 rows
8 columns

CREATE TABLE table_112 (
  "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 113

@ukgov.council_spending_over_500.table_113

262.32 kB
26,664 rows
17 columns

CREATE TABLE table_113 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE  -- AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION No.,
  "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
);

Table 114

@ukgov.council_spending_over_500.table_114

177.13 kB
16,636 rows
8 columns

CREATE TABLE table_114 (
  "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 115

@ukgov.council_spending_over_500.table_115

182.76 kB
18,458 rows
8 columns

CREATE TABLE table_115 (
  "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 116

@ukgov.council_spending_over_500.table_116

82.31 kB
12,634 rows
8 columns

CREATE TABLE table_116 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "service" VARCHAR,
  "supplier_name" VARCHAR,
  "paid_date" TIMESTAMP,
  "net_amount" DOUBLE  -- NET AMOUNT (Ł),
  "purpose" VARCHAR,
  "transaction_no" VARCHAR  -- TRANSACTION NO.
);

Table 118

@ukgov.council_spending_over_500.table_118

32.33 kB
1,173 rows
6 columns

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

Table 119

@ukgov.council_spending_over_500.table_119

210.06 kB
22,375 rows
8 columns

CREATE TABLE table_119 (
  "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 12

@ukgov.council_spending_over_500.table_12

225.49 kB
25,690 rows
8 columns

CREATE TABLE table_12 (
  "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 120

@ukgov.council_spending_over_500.table_120

204.56 kB
23,728 rows
8 columns

CREATE TABLE table_120 (
  "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 121

@ukgov.council_spending_over_500.table_121

69.74 kB
12,786 rows
8 columns

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