Stray Dog Information
Rochdale Borough Council
@ukgov.stray_dog_information
Rochdale Borough Council
@ukgov.stray_dog_information
CREATE TABLE table_1 (
"n_2021" VARCHAR,
"number_of_stray_dogs" VARCHAR,
"number_of_stray_dogs_kennelled" DOUBLE,
"number_of_dogs_returned_to_owner_by" VARCHAR,
"number_of_dogs_retained_by_the_finder" DOUBLE,
"number_of_dogs_returned_to_owner_by_kennel_provider" DOUBLE,
"number_of_dogs_euthanised_during_the_7_day_statutory_h_2bf6f08c" DOUBLE
);
CREATE TABLE table_2 (
"n_2022" VARCHAR,
"number_of_stray_dogs" VARCHAR,
"number_of_stray_dogs_kennelled" DOUBLE,
"number_of_dogs_returned_to_owner_by" VARCHAR,
"patrolled_areas" VARCHAR,
"animal_warden" VARCHAR,
"number_of_dogs_retained_by_the_finder" DOUBLE,
"number_of_dogs_returned_to_owner_by_kennel_provider" DOUBLE,
"number_of_dogs_euthanized_during_the_7_day_statutory_h_d241c424" DOUBLE
);
CREATE TABLE table_3 (
"n_2018" VARCHAR,
"number_of_stray_dogs_seized" DOUBLE,
"number_of_stray_dogs_kennelled" DOUBLE,
"number_of_dogs_returned_to_owner_by_wardens" DOUBLE,
"number_of_dogs_retained_by_the_finder" DOUBLE,
"number_of_dogs_returned_to_owner_by_kennel_provider" DOUBLE,
"number_of_dogs_euthanised_during_the_7_day_statutory_h_2bf6f08c" DOUBLE
);
CREATE TABLE table_4 (
"n_2024" VARCHAR,
"number_of_stray_dogs_seized" VARCHAR,
"number_of_stray_dogs_kennelled" DOUBLE,
"number_of_dogs_returned_to_owner_by_wardens" DOUBLE,
"patrolled_areas_no_dog_found_on_arrival" VARCHAR,
"acorn_kennels_advised_owners" DOUBLE,
"number_of_dogs_retained_by_the_finder" DOUBLE,
"number_of_dogs_returned_to_owner_by_kennel_provider" DOUBLE,
"number_of_dogs_euthanized_during_the_7_day_statutory_h_d241c424" DOUBLE
);
CREATE TABLE table_5 (
"n_2019" VARCHAR,
"number_of_stray_dogs" VARCHAR,
"number_of_stray_dogs_kennelled" DOUBLE,
"number_of_dogs_returned_to_owner_by" VARCHAR,
"number_of_dogs_retained_by_the_finder" DOUBLE,
"number_of_dogs_returned_to_owner_by_kennel_provider" DOUBLE,
"number_of_dogs_euthanised_during_the_7_day_statutory_h_2bf6f08c" DOUBLE
);
CREATE TABLE table_6 (
"n_2023" VARCHAR,
"number_of_stray_dogs" VARCHAR,
"number_of_stray_dogs_kennelled" DOUBLE,
"number_of_dogs_returned_to_owner_by" VARCHAR,
"patrolled_areas" VARCHAR,
"animal_warden" VARCHAR,
"number_of_dogs_retained_by_the_finder" DOUBLE,
"number_of_dogs_returned_to_owner_by_kennel_provider" DOUBLE,
"number_of_dogs_euthanized_during_the_7_day_statutory_h_d241c424" DOUBLE
);
CREATE TABLE table_7 (
"n_2016" VARCHAR,
"number_of_stray_dogs_seized" DOUBLE,
"number_of_stray_dogs_kennelled" DOUBLE,
"number_of_dogs_returned_to_owner_by_wardens" DOUBLE,
"number_of_dogs_retained_by_the_finder" DOUBLE,
"number_of_dogs_returned_to_owner_by_kennel_provider" VARCHAR,
"number_of_dogs_euthanised_during_the_7_day_statutory_h_2bf6f08c" DOUBLE
);
CREATE TABLE table_8 (
"n_2017" VARCHAR,
"number_of_stray_dogs_seized" DOUBLE,
"number_of_stray_dogs_kennelled" DOUBLE,
"number_of_dogs_returned_to_owner_by_wardens" DOUBLE,
"number_of_dogs_retained_by_the_finder" DOUBLE,
"number_of_dogs_returned_to_owner_by_kennel_provider" DOUBLE,
"number_of_dogs_euthanised_during_the_7_day_statutory_h_2bf6f08c" DOUBLE
);
CREATE TABLE table_9 (
"n_2020" VARCHAR,
"number_of_stray_dogs" VARCHAR,
"number_of_stray_dogs_kennelled" DOUBLE,
"number_of_dogs_returned_to_owner_by" VARCHAR,
"number_of_dogs_retained_by_the_finder" DOUBLE,
"number_of_dogs_returned_to_owner_by_kennel_provider" DOUBLE,
"number_of_dogs_euthanised_during_the_7_day_statutory_h_2bf6f08c" DOUBLE
);
Anyone who has the link will be able to view this.