Parking Data
Rochdale Borough Council
@ukgov.parking_data
Rochdale Borough Council
@ukgov.parking_data
This information relates to the parking account and parking spaces number in the Council area. It shows a breakdown of income and expenditure on the authority’s parking account and the number of marked out controlled on and off-street parking spaces. This data set is provided under the terms of the Open Government Licence. You will see that this licence encourages you to download and re-use our data.
Publisher name: Rochdale Borough Council
Last updated: 2024-09-14T08:43:32Z
CREATE TABLE table_1 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"pcn_income" VARCHAR,
"on_street_parkingincome" VARCHAR,
"off_street_parking_income_type" VARCHAR,
"other_income" VARCHAR,
"total_income" VARCHAR,
"expenditure" VARCHAR,
"surplus_amount" VARCHAR
);CREATE TABLE table_10 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"on_street_parking_income_type" VARCHAR,
"on_street_parking_income_amount" DOUBLE,
"off_street_parking_income_type" VARCHAR,
"off_street_parking_income_amount" DOUBLE,
"expenditure_type" VARCHAR,
"expenditure_amount_by_type" DOUBLE,
"surplus_amount" DOUBLE,
"parking_spaces_number_on_off_street" DOUBLE -- Parking Spaces Number (On & Off Street)
);CREATE TABLE table_2 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"on_street_parking_income_type" VARCHAR,
"on_street_parking_income_amount" DOUBLE,
"off_street_parking_income_type" VARCHAR,
"off_street_parking_income_amount" DOUBLE,
"expenditure_type" VARCHAR,
"expenditure_amount_by_type" VARCHAR,
"surplus_amount" DOUBLE,
"parking_spaces_number_on_off_street" DOUBLE -- Parking Spaces Number (On & Off Street)
);CREATE TABLE table_3 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"on_street_parking_income_type" VARCHAR,
"on_street_parking_income_amount" DOUBLE,
"off_street_parking_income_type" VARCHAR,
"off_street_parking_income_amount" DOUBLE,
"expenditure_type" VARCHAR,
"expenditure_amount_by_type" VARCHAR,
"surplus_amount" DOUBLE,
"parking_spaces_number_on_off_street" DOUBLE -- Parking Spaces Number (On & Off Street)
);CREATE TABLE table_5 (
"parking_accounts_2021_2022" VARCHAR,
"actuals" VARCHAR
);CREATE TABLE table_6 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"actuals" VARCHAR
);CREATE TABLE table_7 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"pcn_income" VARCHAR,
"on_street_parkingincome" VARCHAR,
"off_street_parking_income_type" VARCHAR,
"other_income" VARCHAR,
"total_income" VARCHAR,
"expenditure" VARCHAR,
"surplus_amount" VARCHAR
);CREATE TABLE table_8 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"pcn_income" VARCHAR,
"on_street_parkingincome" VARCHAR,
"off_street_parking_income_type" VARCHAR,
"other_income" VARCHAR,
"total_income" VARCHAR,
"expenditure" VARCHAR,
"surplus_amount" VARCHAR
);CREATE TABLE table_9 (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"on_street_parking_income_type" VARCHAR,
"on_street_parking_income_amount" DOUBLE,
"off_street_parking_income_type" VARCHAR,
"off_street_parking_income_amount" DOUBLE,
"expenditure_type" VARCHAR,
"expenditure_amount_by_type" DOUBLE,
"surplus_amount" DOUBLE,
"parking_spaces_number_on_off_street" DOUBLE -- Parking Spaces Number (On & Off Street)
);Anyone who has the link will be able to view this.