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 68

@ukgov.council_spending_over_500.table_68

71.47 KB
4258 rows
8 columns


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

Table 69

@ukgov.council_spending_over_500.table_69

100.07 KB
6903 rows
8 columns


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

Table 7

@ukgov.council_spending_over_500.table_7

200.04 KB
25014 rows
8 columns


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

Table 70

@ukgov.council_spending_over_500.table_70

206.81 KB
19159 rows
8 columns


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

Table 71

@ukgov.council_spending_over_500.table_71

205.85 KB
22152 rows
8 columns


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

Table 72

@ukgov.council_spending_over_500.table_72

88.34 KB
5342 rows
8 columns


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

Table 73

@ukgov.council_spending_over_500.table_73

23.15 KB
744 rows
6 columns


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

Table 74

@ukgov.council_spending_over_500.table_74

72.94 KB
4461 rows
8 columns


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

Table 75

@ukgov.council_spending_over_500.table_75

24.79 KB
814 rows
6 columns


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

Table 76

@ukgov.council_spending_over_500.table_76

206.86 KB
21327 rows
8 columns


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

Table 77

@ukgov.council_spending_over_500.table_77

199.43 KB
18973 rows
8 columns


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

Table 78

@ukgov.council_spending_over_500.table_78

76.88 KB
4500 rows
8 columns


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

Table 79

@ukgov.council_spending_over_500.table_79

74.77 KB
24401 rows
8 columns


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

Table 8

@ukgov.council_spending_over_500.table_8

70.11 KB
3969 rows
8 columns


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

Table 80

@ukgov.council_spending_over_500.table_80

73.26 KB
4003 rows
8 columns


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

Table 81

@ukgov.council_spending_over_500.table_81

181.36 KB
19321 rows
8 columns


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

Table 82

@ukgov.council_spending_over_500.table_82

269.74 KB
36246 rows
8 columns


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

Table 83

@ukgov.council_spending_over_500.table_83

24.93 KB
800 rows
6 columns


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

Table 84

@ukgov.council_spending_over_500.table_84

41.67 KB
1644 rows
7 columns


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

Table 85

@ukgov.council_spending_over_500.table_85

170.25 KB
15601 rows
8 columns


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

Table 86

@ukgov.council_spending_over_500.table_86

65.6 KB
3906 rows
8 columns


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

Table 87

@ukgov.council_spending_over_500.table_87

29.29 KB
1162 rows
6 columns


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

Table 88

@ukgov.council_spending_over_500.table_88

180.77 KB
16277 rows
8 columns


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

Table 89

@ukgov.council_spending_over_500.table_89

82.86 KB
4648 rows
8 columns


CREATE TABLE table_89 (
  "organisation_name" VARCHAR,
  "effectivedate" TIMESTAMP,
  "service" VARCHAR,
  "supplier_name" VARCHAR,
  "paiddate" TIMESTAMP,
  "net_amount" DOUBLE,
  "purpose" VARCHAR,
  "transaction_number" VARCHAR
);

Table 9

@ukgov.council_spending_over_500.table_9

199.81 KB
22215 rows
8 columns


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