Parking Data
Rochdale Borough Council
@ukgov.parking_data
Rochdale Borough Council
@ukgov.parking_data
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
);
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
);
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
);
CREATE TABLE table_5 (
"parking_accounts_2021_2022" VARCHAR,
"actuals" VARCHAR
);
CREATE TABLE table_6 (
"unnamed_0" VARCHAR,
"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
);
Anyone who has the link will be able to view this.