About this Dataset

Contract Register

The data lists the contracts awarded by the Council with tender/contract values over £5,000. Data has been excluded or redacted from the publication in line with guidance issued by the Local Government Association. There are occasions when data items have been removed (redacted) for the following reasons: - REDACTED PERSONAL DATA where the data would identify an individual in the context of their private life. - REDACTED COMMERCIAL CONFIDENTIALITY where the release of information could prejudice the conduct of business or was provided in confidence. - REDACTED OTHER where revealing information would compromise security, health & safety or crime prevention. The Council manage 4 distinct processes – 1. Tendering. 2. Awarding a Contract. 3. Ordering Goods and Services via a Purchase Order as required. 4. Paying an Invoice or awarding a Grant. This means that the same or similar information may be duplicated over datasets published by the Council. An example of this process would be a contract being advertised via an Invitation to Tender, awarded to a stationery supplier, a purchase order will then be raised to order 200 pens, the goods will be delivered and then an invoice submitted to the Council for payment. This information will be contained in the Invitation to Tender declaration, the Contract Register, Purchase Order Information and the Spend Data. It is likely that the values contained in the Invitation to Tender, Contract Register, Purchase Order data and Spend Data will not reconcile. This is because the timeframe whereby each item of data is captured will be different and actual spend varies over time. For example, the Invitation to Tender will be the estimated maximum value for the full contract term at the point the contract is advertised, the Contract Register will be the estimated maximum contract value over the full term, Purchase Orders may reflect requirements over a much shorter time or a single “call off” and the spend declaration reflects when we pay for the goods and services. Definitions: - Contracts: documents evidencing a legally binding agreement between two or more parties. Purchase Orders may be raised against these Contracts. - Framework agreements: are legally compliant routes to pre selecting suppliers who are able to supply goods and services. Contracts are awarded to bidders when the work is allocated. Such contracts will be listed on the contract register if they are over £5,000 and are classified as “frameworks”. - Invitations to tender: are open advertisements to the market which represent opportunities for interested parties to express an interest in participating in a competitive procurement process for the supply of goods, services or works. If you have queries with any of the payments listed in the data, please email foi@rochdale.gov.uk specifying the name of the file you are referring to, the transaction reference or invoice or contract number, the amount and what additional information you require.
Publisher name: Rochdale Borough Council
Last updated: 2025-04-26T04:03:04Z

Tables

Table 1

@ukgov.contract_register.table_1

28.18 kB
131 rows
17 columns

CREATE TABLE table_1 (
  "uid" VARCHAR,
  "council" VARCHAR,
  "contract_status" VARCHAR,
  "classification" VARCHAR,
  "name" VARCHAR,
  "route_to_market" VARCHAR,
  "contract_type_detail" VARCHAR,
  "start_date" VARCHAR,
  "end_date" VARCHAR,
  "maximum_extension_date" VARCHAR,
  "annual_contract_value_average" VARCHAR  -- Annual Contract Value (average),
  "value" VARCHAR,
  "supplier_name" VARCHAR,
  "company_registration_number" VARCHAR,
  "postal_code" VARCHAR,
  "supplier_type" VARCHAR,
  "customer_name" VARCHAR
);

Table 10

@ukgov.contract_register.table_10

29.24 kB
161 rows
15 columns

CREATE TABLE table_10 (
  "supplier_name" VARCHAR,
  "company_registration_number" VARCHAR,
  "supplier_postcode" VARCHAR,
  "uid" VARCHAR,
  "council" VARCHAR,
  "contract_status" VARCHAR,
  "classification" VARCHAR,
  "name" VARCHAR,
  "route_to_market" VARCHAR,
  "contract_type_detail" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "annual_contract_value_average" VARCHAR  -- Annual Contract Value (average),
  "value" VARCHAR,
  "customer_name" VARCHAR
);

Table 11

@ukgov.contract_register.table_11

38.87 kB
246 rows
17 columns

CREATE TABLE table_11 (
  "uid" BIGINT,
  "council" VARCHAR,
  "contract_status" VARCHAR,
  "classification" VARCHAR,
  "name" VARCHAR,
  "route_to_market" VARCHAR,
  "contract_type_detail" VARCHAR,
  "start_date" DOUBLE,
  "end_date" DOUBLE,
  "maximum_extension_date" TIMESTAMP,
  "n__annual_contract_value_average" VARCHAR  -- Annual Contract Value (average),
  "n__value" VARCHAR  -- Value,
  "supplier_name" VARCHAR,
  "company_registration_number" VARCHAR,
  "postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "customer_name" VARCHAR
);

Table 12

@ukgov.contract_register.table_12

61.42 kB
649 rows
21 columns

CREATE TABLE table_12 (
  "uid" VARCHAR,
  "client" VARCHAR,
  "status" VARCHAR,
  "pro_class" VARCHAR,
  "contract_title" VARCHAR,
  "route_to_market" VARCHAR,
  "agreement_type" VARCHAR,
  "contract_start_date" VARCHAR,
  "contract_term_months" DOUBLE  -- Contract Term (Months),
  "maximum_duration_of_contract_months" DOUBLE  -- Maximum Duration Of Contract (Months),
  "contract_end_date" VARCHAR,
  "ext_applied_to_contract" VARCHAR  -- Ext. Applied To Contract,
  "maximum_extend_date" VARCHAR,
  "review_date" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "estimated_total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_type" VARCHAR,
  "registered_number" VARCHAR,
  "postcode" VARCHAR,
  "council_directorate" VARCHAR
);

Table 13

@ukgov.contract_register.table_13

49.46 kB
498 rows
19 columns

CREATE TABLE table_13 (
  "uid" BIGINT,
  "client" VARCHAR,
  "pro_class" VARCHAR,
  "contract_title" VARCHAR,
  "route_to_market" VARCHAR,
  "agreement_type" VARCHAR,
  "contract_start_date" VARCHAR,
  "contract_term_months" VARCHAR  -- Contract Term (Months),
  "maximum_duration_of_contract_months" VARCHAR  -- Maximum Duration Of Contract (Months),
  "contract_end_date" VARCHAR,
  "ext_applied_to_contract" VARCHAR  -- Ext. Applied To Contract,
  "maximum_extend_date" VARCHAR,
  "review_date" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "estimated_total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_type" VARCHAR,
  "registered_number" VARCHAR,
  "council_directorate" VARCHAR
);

Table 14

@ukgov.contract_register.table_14

29.05 kB
147 rows
17 columns

CREATE TABLE table_14 (
  "uid" VARCHAR,
  "council" VARCHAR,
  "contract_status" VARCHAR,
  "classification" VARCHAR,
  "name" VARCHAR,
  "route_to_market" VARCHAR,
  "contract_type_detail" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" VARCHAR,
  "maximum_extension_date" VARCHAR,
  "annual_contract_value_average" VARCHAR  -- Annual Contract Value (average),
  "value" VARCHAR,
  "supplier_name" VARCHAR,
  "company_registration_number" VARCHAR,
  "post_code" VARCHAR,
  "supplier_type" VARCHAR,
  "customer_name" VARCHAR
);

Table 15

@ukgov.contract_register.table_15

42.05 kB
269 rows
17 columns

CREATE TABLE table_15 (
  "uid" BIGINT,
  "council" VARCHAR,
  "contract_status" VARCHAR,
  "classification" VARCHAR,
  "name" VARCHAR,
  "route_to_market" VARCHAR,
  "contract_type_detail" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "maximum_extension_date" VARCHAR,
  "annual_contract_value_average" VARCHAR  -- Annual Contract Value (average),
  "value" VARCHAR,
  "supplier_name" VARCHAR,
  "company_registration_number" VARCHAR,
  "postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "customer_name" VARCHAR
);

Table 16

@ukgov.contract_register.table_16

48.31 kB
547 rows
17 columns

CREATE TABLE table_16 (
  "uid" VARCHAR,
  "client" VARCHAR,
  "pro_class" VARCHAR,
  "contract_title" VARCHAR,
  "route_to_market" VARCHAR,
  "contract_type" VARCHAR,
  "contract_start_date" TIMESTAMP,
  "contract_end_date" TIMESTAMP,
  "ext_applied_to_contract" VARCHAR  -- Ext. Applied To Contract,
  "maximum_extend_date" TIMESTAMP,
  "review_date" TIMESTAMP,
  "estimated_annual_value" VARCHAR,
  "estimated_total_value" VARCHAR,
  "supplier" VARCHAR,
  "supplier_type" VARCHAR,
  "registered_number" VARCHAR,
  "council_directorate" VARCHAR
);

Table 17

@ukgov.contract_register.table_17

53.91 kB
533 rows
19 columns

CREATE TABLE table_17 (
  "uid" BIGINT,
  "client" VARCHAR,
  "pro_class" VARCHAR,
  "contract_title" VARCHAR,
  "route_to_market" VARCHAR,
  "agreement_type" VARCHAR,
  "contract_start_date" VARCHAR,
  "contract_term_months" VARCHAR  -- Contract Term (Months),
  "maximum_duration_of_contract_months" VARCHAR  -- Maximum Duration Of Contract (Months),
  "contract_end_date" VARCHAR,
  "ext_applied_to_contract" VARCHAR  -- Ext. Applied To Contract,
  "maximum_extend_date" VARCHAR,
  "review_date" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "estimated_total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_type" VARCHAR,
  "registered_number" VARCHAR,
  "council_directorate" VARCHAR
);

Table 18

@ukgov.contract_register.table_18

12.7 kB
53 rows
10 columns

CREATE TABLE table_18 (
  "record_uid" BIGINT,
  "organisation_name" VARCHAR,
  "contract_ref_no" VARCHAR,
  "title_of_agreement_description_of_goods_or_services" VARCHAR  -- Title Of Agreement / Description Of Goods Or Services,
  "directorate_service_responsible" VARCHAR  -- Directorate/ Service Responsible,
  "start_date" VARCHAR,
  "end_date_includes_ext_date" VARCHAR  -- End Date (Includes Ext Date),
  "review_date" VARCHAR,
  "estimated_maximum_annual_value" VARCHAR,
  "supplier_name" VARCHAR
);

Table 2

@ukgov.contract_register.table_2

39.24 kB
205 rows
22 columns

CREATE TABLE table_2 (
  "uid" VARCHAR,
  "client" VARCHAR,
  "status" VARCHAR,
  "pro_class" VARCHAR,
  "contract_title" VARCHAR,
  "contract_trigger" VARCHAR,
  "route_to_market" VARCHAR,
  "agreement_type" VARCHAR,
  "contract_start_date" VARCHAR,
  "contract_term_months" VARCHAR  -- Contract Term (Months),
  "maximum_duration_of_contract_months" VARCHAR  -- Maximum Duration Of Contract (Months),
  "contract_end_date" VARCHAR,
  "ext_applied_to_contract" VARCHAR  -- Ext. Applied To Contract,
  "maximum_extend_date" VARCHAR,
  "review_date" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "estimated_total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_type" VARCHAR,
  "registered_number" VARCHAR,
  "postcode" VARCHAR,
  "council_directorate" VARCHAR
);

Table 20

@ukgov.contract_register.table_20

14.93 kB
30 rows
15 columns

CREATE TABLE table_20 (
  "uid" BIGINT,
  "client" VARCHAR,
  "pro_class" VARCHAR,
  "contract_title" VARCHAR,
  "route_to_market" VARCHAR,
  "contract_start_date" TIMESTAMP,
  "contract_end_date" TIMESTAMP,
  "maximum_extended_date" VARCHAR,
  "review_date" TIMESTAMP,
  "estimated_annual_value" BIGINT,
  "supplier" VARCHAR,
  "supplier_type" VARCHAR,
  "registered_number_what_is_it" VARCHAR  -- Registered Number (WHAT IS IT?),
  "council_directorate" VARCHAR,
  "area" VARCHAR
);

Table 22

@ukgov.contract_register.table_22

49.86 kB
316 rows
22 columns

CREATE TABLE table_22 (
  "uid" VARCHAR,
  "client" VARCHAR,
  "status" VARCHAR,
  "pro_class" VARCHAR,
  "contract_title" VARCHAR,
  "contract_trigger" VARCHAR,
  "route_to_market" VARCHAR,
  "agreement_type" VARCHAR,
  "contract_start_date" VARCHAR,
  "contract_term_months" VARCHAR  -- Contract Term (Months),
  "maximum_duration_of_contract_months" VARCHAR  -- Maximum Duration Of Contract (Months),
  "contract_end_date" VARCHAR,
  "ext_applied_to_contract" VARCHAR  -- Ext. Applied To Contract,
  "maximum_extend_date" VARCHAR,
  "review_date" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "estimated_total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_type" VARCHAR,
  "registered_number" VARCHAR,
  "postcode" VARCHAR,
  "council_directorate" VARCHAR
);

Table 23

@ukgov.contract_register.table_23

15.02 kB
30 rows
15 columns

CREATE TABLE table_23 (
  "uid" BIGINT,
  "client" VARCHAR,
  "pro_class" VARCHAR,
  "contract_title" VARCHAR,
  "route_to_market" VARCHAR,
  "contract_start_date" TIMESTAMP,
  "contract_end_date" TIMESTAMP,
  "maximum_extended_date" VARCHAR,
  "review_date" TIMESTAMP,
  "estimated_annual_value" BIGINT,
  "supplier" VARCHAR,
  "supplier_type" VARCHAR,
  "registered_number" VARCHAR,
  "council_directorate" VARCHAR,
  "area" VARCHAR
);

Table 24

@ukgov.contract_register.table_24

43.24 kB
289 rows
17 columns

CREATE TABLE table_24 (
  "uid" VARCHAR,
  "council" VARCHAR,
  "contract_status" VARCHAR,
  "classification" VARCHAR,
  "name" VARCHAR,
  "route_to_market" VARCHAR,
  "contract_type_detail" VARCHAR,
  "start_date" VARCHAR,
  "end_date" TIMESTAMP,
  "maximum_extension_date" VARCHAR,
  "n__annual_contract_value_average" VARCHAR  -- Annual Contract Value (average),
  "n__value" VARCHAR  -- Value,
  "supplier_name" VARCHAR,
  "company_registration_number" VARCHAR,
  "postal_code" VARCHAR,
  "supplier_type" VARCHAR,
  "customer_name" VARCHAR
);

Table 25

@ukgov.contract_register.table_25

66.78 kB
885 rows
22 columns

CREATE TABLE table_25 (
  "uid" BIGINT,
  "client" VARCHAR,
  "category" VARCHAR,
  "status" VARCHAR,
  "pro_class" VARCHAR,
  "contract_title" VARCHAR,
  "route_to_market" VARCHAR,
  "agreement_type" VARCHAR,
  "contract_start_date" VARCHAR,
  "contract_term_months" VARCHAR  -- Contract Term (Months),
  "maximum_duration_of_contract_months" VARCHAR  -- Maximum Duration Of Contract (Months),
  "contract_end_date" VARCHAR,
  "ext_applied_to_contract" VARCHAR  -- Ext. Applied To Contract,
  "maximum_extend_date" VARCHAR,
  "review_date" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "estimated_total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_type" VARCHAR,
  "registered_number" VARCHAR,
  "postcode" VARCHAR,
  "council_directorate" VARCHAR
);

Table 26

@ukgov.contract_register.table_26

39.63 kB
251 rows
17 columns

CREATE TABLE table_26 (
  "uid" VARCHAR,
  "council" VARCHAR,
  "contract_status" VARCHAR,
  "name" VARCHAR,
  "classification" VARCHAR,
  "route_to_market" VARCHAR,
  "contract_type_detail" VARCHAR,
  "start_date" VARCHAR,
  "end_date" TIMESTAMP,
  "maximum_extension_date" VARCHAR,
  "annual_contract_value_average" VARCHAR  -- Annual Contract Value (average),
  "value" VARCHAR,
  "supplier_name" VARCHAR,
  "company_registration_number" VARCHAR,
  "postal_code" VARCHAR,
  "supplier_type" VARCHAR,
  "customer_name" VARCHAR
);

Table 27

@ukgov.contract_register.table_27

55.52 kB
627 rows
20 columns

CREATE TABLE table_27 (
  "uid" DOUBLE,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "client" VARCHAR,
  "pro_class" VARCHAR,
  "contract_title" VARCHAR,
  "route_to_market" VARCHAR,
  "agreement_type" VARCHAR,
  "contract_start_date" VARCHAR,
  "contract_term_months" DOUBLE  -- Contract Term (Months),
  "maximum_duration_of_contract_months" DOUBLE  -- Maximum Duration Of Contract (Months),
  "contract_end_date" VARCHAR,
  "ext_applied_to_contract" VARCHAR  -- Ext. Applied To Contract,
  "maximum_extend_date" VARCHAR,
  "review_date" VARCHAR,
  "n__estimated_annual_value" VARCHAR  -- Estimated Annual Value,
  "n__estimated_total_value" VARCHAR  -- Estimated Total Value,
  "supplier_name" VARCHAR,
  "supplier_type" VARCHAR,
  "registered_number" VARCHAR,
  "council_directorate" VARCHAR
);

Table 29

@ukgov.contract_register.table_29

38.37 kB
240 rows
17 columns

CREATE TABLE table_29 (
  "uid" BIGINT,
  "council" VARCHAR,
  "contract_status" VARCHAR,
  "classification" VARCHAR,
  "name" VARCHAR,
  "route_to_market" VARCHAR,
  "contract_type_detail" VARCHAR,
  "start_date" VARCHAR,
  "end_date" VARCHAR,
  "maximum_extension_date" VARCHAR,
  "n__annual_contract_value_average" VARCHAR  -- Annual Contract Value (average),
  "n__value" VARCHAR  -- Value,
  "supplier_name" VARCHAR,
  "company_registration_number" VARCHAR,
  "postcode" VARCHAR,
  "supplier_type" VARCHAR,
  "customer_name" VARCHAR
);

Table 3

@ukgov.contract_register.table_3

43.92 kB
248 rows
20 columns

CREATE TABLE table_3 (
  "uid" BIGINT,
  "client" VARCHAR,
  "pro_class" VARCHAR,
  "contract_title" VARCHAR,
  "route_to_market" VARCHAR,
  "agreement_type" VARCHAR,
  "contract_start_date" VARCHAR,
  "contract_term_months" VARCHAR  -- Contract Term (Months),
  "maximum_duration_of_contract_months" VARCHAR  -- Maximum Duration Of Contract (Months),
  "contract_end_date" VARCHAR,
  "ext_applied_to_contract" VARCHAR  -- Ext. Applied To Contract,
  "maximum_extend_date" VARCHAR,
  "review_date" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "estimated_total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_type" VARCHAR,
  "registered_number" VARCHAR,
  "postcode" VARCHAR,
  "council_directorate" VARCHAR
);

Table 31

@ukgov.contract_register.table_31

52.18 kB
569 rows
19 columns

CREATE TABLE table_31 (
  "uid" BIGINT,
  "client" VARCHAR,
  "pro_class" VARCHAR,
  "contract_title" VARCHAR,
  "route_to_market" VARCHAR,
  "agreement_type" VARCHAR,
  "contract_start_date" VARCHAR,
  "contract_term_months" VARCHAR  -- Contract Term (Months),
  "maximum_duration_of_contract_months" VARCHAR  -- Maximum Duration Of Contract (Months),
  "contract_end_date" VARCHAR,
  "ext_applied_to_contract" VARCHAR  -- Ext. Applied To Contract,
  "maximum_extend_date" VARCHAR,
  "review_date" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "estimated_total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_type" VARCHAR,
  "registered_number" VARCHAR,
  "council_directorate" VARCHAR
);

Table 32

@ukgov.contract_register.table_32

44.01 kB
296 rows
20 columns

CREATE TABLE table_32 (
  "uid" BIGINT,
  "client" VARCHAR,
  "pro_class" VARCHAR,
  "contract_title" VARCHAR,
  "route_to_market" VARCHAR,
  "agreement_type" VARCHAR,
  "contract_start_date" VARCHAR,
  "contract_term_months" VARCHAR  -- Contract Term (Months),
  "maximum_duration_of_contract_months" VARCHAR  -- Maximum Duration Of Contract (Months),
  "contract_end_date" VARCHAR,
  "ext_applied_to_contract" VARCHAR  -- Ext. Applied To Contract,
  "maximum_extend_date" VARCHAR,
  "review_date" VARCHAR,
  "estimated_annual_value" VARCHAR,
  "estimated_total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_type" VARCHAR,
  "registered_number" VARCHAR,
  "postcode" VARCHAR,
  "council_directorate" VARCHAR
);

Table 33

@ukgov.contract_register.table_33

14.93 kB
30 rows
15 columns

CREATE TABLE table_33 (
  "uid" BIGINT,
  "client" VARCHAR,
  "pro_class" VARCHAR,
  "contract_title" VARCHAR,
  "route_to_market" VARCHAR,
  "contract_start_date" TIMESTAMP,
  "contract_end_date" TIMESTAMP,
  "maximum_extended_date" VARCHAR,
  "review_date" TIMESTAMP,
  "estimated_annual_value" BIGINT,
  "supplier" VARCHAR,
  "supplier_type" VARCHAR,
  "registered_number_what_is_it" VARCHAR  -- Registered Number (WHAT IS IT?),
  "council_directorate" VARCHAR,
  "area" VARCHAR
);

Table 34

@ukgov.contract_register.table_34

41.62 kB
352 rows
16 columns

CREATE TABLE table_34 (
  "uid" BIGINT,
  "client" VARCHAR,
  "pro_class" VARCHAR,
  "contract_title" VARCHAR,
  "route_to_market" VARCHAR,
  "contract_type" VARCHAR,
  "contract_start_date" TIMESTAMP,
  "contract_end_date" TIMESTAMP,
  "maximum_extend_date" TIMESTAMP,
  "review_date" TIMESTAMP,
  "estimated_annual_value" VARCHAR,
  "estimated_total_value" VARCHAR,
  "supplier" VARCHAR,
  "supplier_type" VARCHAR,
  "registered_company_charity_number" VARCHAR  -- Registered Company/ Charity Number,
  "council_directorate" VARCHAR
);

Table 35

@ukgov.contract_register.table_35

52.43 kB
531 rows
19 columns

CREATE TABLE table_35 (
  "uid" BIGINT,
  "client" VARCHAR,
  "pro_class" VARCHAR,
  "contract_title" VARCHAR,
  "route_to_market" VARCHAR,
  "agreement_type" VARCHAR,
  "contract_start_date" VARCHAR,
  "contract_term_months" VARCHAR  -- Contract Term (Months),
  "maximum_duration_of_contract_months" VARCHAR  -- Maximum Duration Of Contract (Months),
  "contract_end_date" VARCHAR,
  "ext_applied_to_contract" VARCHAR  -- Ext. Applied To Contract,
  "maximum_extend_date" VARCHAR,
  "review_date" TIMESTAMP,
  "estimated_annual_value" VARCHAR,
  "estimated_total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "supplier_type" VARCHAR,
  "registered_number" VARCHAR,
  "council_directorate" VARCHAR
);