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

233.31 KB
23191 rows
8 columns


CREATE TABLE table_1 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);

Table 10

@ukgov.council_spending_over_500.table_10

77.23 KB
4411 rows
16 columns


CREATE TABLE table_10 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "service" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" DOUBLE
);

Table 100

@ukgov.council_spending_over_500.table_100

23.92 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

89.31 KB
4793 rows
8 columns


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

Table 102

@ukgov.council_spending_over_500.table_102

250.78 KB
27557 rows
8 columns


CREATE TABLE table_102 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);

Table 103

@ukgov.council_spending_over_500.table_103

214.1 KB
27239 rows
8 columns


CREATE TABLE table_103 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);

Table 104

@ukgov.council_spending_over_500.table_104

23.04 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

64.57 KB
3713 rows
9 columns


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

Table 106

@ukgov.council_spending_over_500.table_106

218.46 KB
25695 rows
8 columns


CREATE TABLE table_106 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);

Table 107

@ukgov.council_spending_over_500.table_107

198.66 KB
20646 rows
8 columns


CREATE TABLE table_107 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);

Table 108

@ukgov.council_spending_over_500.table_108

72.48 KB
3959 rows
8 columns


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

Table 109

@ukgov.council_spending_over_500.table_109

75.02 KB
4505 rows
8 columns


CREATE TABLE table_109 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "service" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);

Table 11

@ukgov.council_spending_over_500.table_11

199.97 KB
17722 rows
8 columns


CREATE TABLE table_11 (
  "organisation_name" VARCHAR,
  "efefctive_date" VARCHAR,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" VARCHAR,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);

Table 110

@ukgov.council_spending_over_500.table_110

78.6 KB
4767 rows
8 columns


CREATE TABLE table_110 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);

Table 111

@ukgov.council_spending_over_500.table_111

200.42 KB
23432 rows
8 columns


CREATE TABLE table_111 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);

Table 112

@ukgov.council_spending_over_500.table_112

207.8 KB
22319 rows
8 columns


CREATE TABLE table_112 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);

Table 113

@ukgov.council_spending_over_500.table_113

256.18 KB
26664 rows
17 columns


CREATE TABLE table_113 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR
);

Table 114

@ukgov.council_spending_over_500.table_114

172.98 KB
16636 rows
8 columns


CREATE TABLE table_114 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);

Table 115

@ukgov.council_spending_over_500.table_115

178.47 KB
18458 rows
8 columns


CREATE TABLE table_115 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);

Table 116

@ukgov.council_spending_over_500.table_116

80.38 KB
12634 rows
8 columns


CREATE TABLE table_116 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "service" VARCHAR,
  "supplier_name" VARCHAR,
  "paid_date" TIMESTAMP,
  "net_amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);

Table 118

@ukgov.council_spending_over_500.table_118

31.57 KB
1173 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

205.14 KB
22375 rows
8 columns


CREATE TABLE table_119 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);

Table 12

@ukgov.council_spending_over_500.table_12

220.21 KB
25690 rows
8 columns


CREATE TABLE table_12 (
  "organisation_name" VARCHAR,
  "efefctive_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);

Table 120

@ukgov.council_spending_over_500.table_120

199.77 KB
23728 rows
8 columns


CREATE TABLE table_120 (
  "organisation_name" VARCHAR,
  "effective_date" TIMESTAMP,
  "directorate" VARCHAR,
  "supplier_name" VARCHAR,
  "date_paid" TIMESTAMP,
  "amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_no" VARCHAR
);

Table 121

@ukgov.council_spending_over_500.table_121

68.11 KB
12786 rows
8 columns


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