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

73.19 kB
4,258 rows
8 columns

CREATE TABLE table_68 (
  "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 69

@ukgov.council_spending_over_500.table_69

102.47 kB
6,903 rows
8 columns

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

Table 7

@ukgov.council_spending_over_500.table_7

204.84 kB
25,014 rows
8 columns

CREATE TABLE table_7 (
  "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 70

@ukgov.council_spending_over_500.table_70

211.78 kB
19,159 rows
8 columns

CREATE TABLE table_70 (
  "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 71

@ukgov.council_spending_over_500.table_71

210.79 kB
22,152 rows
8 columns

CREATE TABLE table_71 (
  "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 72

@ukgov.council_spending_over_500.table_72

90.46 kB
5,342 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  -- TRANSACTION NO.
);

Table 73

@ukgov.council_spending_over_500.table_73

23.71 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

74.69 kB
4,461 rows
8 columns

CREATE TABLE table_74 (
  "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 75

@ukgov.council_spending_over_500.table_75

25.39 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

211.82 kB
21,327 rows
8 columns

CREATE TABLE table_76 (
  "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 77

@ukgov.council_spending_over_500.table_77

204.22 kB
18,973 rows
8 columns

CREATE TABLE table_77 (
  "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 78

@ukgov.council_spending_over_500.table_78

78.73 kB
4,500 rows
8 columns

CREATE TABLE table_78 (
  "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 79

@ukgov.council_spending_over_500.table_79

76.56 kB
24,401 rows
8 columns

CREATE TABLE table_79 (
  "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 8

@ukgov.council_spending_over_500.table_8

71.79 kB
3,969 rows
8 columns

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

Table 80

@ukgov.council_spending_over_500.table_80

75.02 kB
4,003 rows
8 columns

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

Table 81

@ukgov.council_spending_over_500.table_81

185.71 kB
19,321 rows
8 columns

CREATE TABLE table_81 (
  "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 82

@ukgov.council_spending_over_500.table_82

276.22 kB
36,246 rows
8 columns

CREATE TABLE table_82 (
  "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 83

@ukgov.council_spending_over_500.table_83

25.53 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

42.67 kB
1,644 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

174.33 kB
15,601 rows
8 columns

CREATE TABLE table_85 (
  "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 86

@ukgov.council_spending_over_500.table_86

67.18 kB
3,906 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.99 kB
1,162 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

185.1 kB
16,277 rows
8 columns

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

Table 89

@ukgov.council_spending_over_500.table_89

84.85 kB
4,648 rows
8 columns

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

Table 9

@ukgov.council_spending_over_500.table_9

204.6 kB
22,215 rows
8 columns

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