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

196.59 KB
21781 rows
8 columns


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

Table 21

@ukgov.council_spending_over_500.table_21

202.46 KB
20463 rows
8 columns


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

Table 22

@ukgov.council_spending_over_500.table_22

206.83 KB
21161 rows
8 columns


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

Table 23

@ukgov.council_spending_over_500.table_23

72.85 KB
4057 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_9" VARCHAR,
  "unnamed_10" VARCHAR
);

Table 24

@ukgov.council_spending_over_500.table_24

40.05 KB
1194 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
);

Table 25

@ukgov.council_spending_over_500.table_25

211.93 KB
25817 rows
8 columns


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

Table 26

@ukgov.council_spending_over_500.table_26

92.01 KB
5780 rows
8 columns


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

Table 27

@ukgov.council_spending_over_500.table_27

77.42 KB
4231 rows
8 columns


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

Table 28

@ukgov.council_spending_over_500.table_28

75.99 KB
4601 rows
8 columns


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

Table 29

@ukgov.council_spending_over_500.table_29

33.65 KB
1382 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
);

Table 30

@ukgov.council_spending_over_500.table_30

69.33 KB
4016 rows
8 columns


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

Table 31

@ukgov.council_spending_over_500.table_31

87.23 KB
5950 rows
8 columns


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

Table 32

@ukgov.council_spending_over_500.table_32

71.46 KB
4187 rows
8 columns


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

Table 33

@ukgov.council_spending_over_500.table_33

44.6 KB
2000 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

37.66 KB
1591 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,
  "unnamed_7" VARCHAR
);

Table 35

@ukgov.council_spending_over_500.table_35

196.37 KB
20583 rows
8 columns


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

Table 36

@ukgov.council_spending_over_500.table_36

267.46 KB
28989 rows
8 columns


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

Table 37

@ukgov.council_spending_over_500.table_37

39.96 KB
1241 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
);

Table 38

@ukgov.council_spending_over_500.table_38

228.5 KB
21266 rows
8 columns


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

Table 39

@ukgov.council_spending_over_500.table_39

102.88 KB
6555 rows
8 columns


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

Table 4

@ukgov.council_spending_over_500.table_4

86.72 KB
5216 rows
8 columns


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

Table 40

@ukgov.council_spending_over_500.table_40

38.31 KB
1185 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

86.36 KB
5229 rows
8 columns


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

Table 42

@ukgov.council_spending_over_500.table_42

248.92 KB
27446 rows
8 columns


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

Table 43

@ukgov.council_spending_over_500.table_43

192.84 KB
18608 rows
8 columns


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