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

215.38 KB
23074 rows
8 columns


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

Table 45

@ukgov.council_spending_over_500.table_45

34.11 KB
1242 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

103.78 KB
6776 rows
8 columns


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

Table 47

@ukgov.council_spending_over_500.table_47

211.35 KB
26158 rows
8 columns


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

Table 48

@ukgov.council_spending_over_500.table_48

73.12 KB
3932 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,
  "gl_code_desc" VARCHAR
);

Table 49

@ukgov.council_spending_over_500.table_49

213.9 KB
25350 rows
8 columns


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

Table 5

@ukgov.council_spending_over_500.table_5

82.63 KB
12396 rows
8 columns


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

Table 50

@ukgov.council_spending_over_500.table_50

213.65 KB
25466 rows
8 columns


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

Table 51

@ukgov.council_spending_over_500.table_51

201.42 KB
18215 rows
8 columns


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

Table 52

@ukgov.council_spending_over_500.table_52

171.15 KB
18012 rows
8 columns


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

Table 53

@ukgov.council_spending_over_500.table_53

168.09 KB
15444 rows
8 columns


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

Table 55

@ukgov.council_spending_over_500.table_55

242.76 KB
30896 rows
8 columns


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

Table 56

@ukgov.council_spending_over_500.table_56

184.81 KB
20313 rows
8 columns


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

Table 57

@ukgov.council_spending_over_500.table_57

33.62 KB
1204 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

211 KB
23585 rows
8 columns


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

Table 59

@ukgov.council_spending_over_500.table_59

213.16 KB
23059 rows
8 columns


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

Table 6

@ukgov.council_spending_over_500.table_6

87.24 KB
5515 rows
8 columns


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

Table 60

@ukgov.council_spending_over_500.table_60

84.31 KB
12396 rows
8 columns


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

Table 61

@ukgov.council_spending_over_500.table_61

79.52 KB
4361 rows
8 columns


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

Table 62

@ukgov.council_spending_over_500.table_62

36.29 KB
1424 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

232.09 KB
23989 rows
8 columns


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

Table 64

@ukgov.council_spending_over_500.table_64

90.86 KB
5979 rows
8 columns


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

Table 65

@ukgov.council_spending_over_500.table_65

82.41 KB
4976 rows
8 columns


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

Table 66

@ukgov.council_spending_over_500.table_66

26.85 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

73.87 KB
4485 rows
8 columns


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