Local Law 97 Of 2021 - Pets In Shelter Report
City of New York
@usgov.city_of_new_york_local_law_97_of_2021_pets_in_shelter_report
City of New York
@usgov.city_of_new_york_local_law_97_of_2021_pets_in_shelter_report
This quarterly report provides survey response data about the types of pets whose owners enter homeless shelters. Data is aggregated at the quarterly level (ie: 2024 Q3). The unit of analysis is a fiscal year quarter: Quarter 1 (Q1): July - September; Quarter 2 (Q2): October - December; Quarter 3 (Q3): January - March; Quarter 4 (Q4): April - June.
Organization: City of New York
Last updated: 2025-10-18T21:40:25.353374
Tags: dhs, homeless, local-law-97, pets
CREATE TABLE table_1 (
"date_year" BIGINT -- Date - Year,
"date_quarter" VARCHAR -- Date - Quarter,
"total_applicants" BIGINT,
"had_pet" BIGINT,
"client_borough_of_entry_bronx" BIGINT,
"client_borough_of_entry_manhattan" BIGINT,
"client_borough_of_entry_brooklyn" BIGINT,
"clients_who_would_have_entered_shelter_with_pet_if_allowed" BIGINT,
"clients_choosing_to_forego_shelter" BIGINT,
"chose_to_forego_shelter_for_how_many_days_avg" DOUBLE -- Chose To Forego Shelter For How Many Days (avg),
"clients_who_intend_to_regain_possession_upon_shelter_exit" BIGINT,
"number_of_dogs" BIGINT,
"number_of_cats" BIGINT,
"number_of_birds" BIGINT,
"number_of_small_mammals" BIGINT,
"number_of_reptiles_small_amphibians" BIGINT,
"number_of_fish" BIGINT,
"did_not_report_pet_type" BIGINT,
"pet_s_placed_with_foster_care_provider" BIGINT -- Pet(s) Placed With Foster Care Provider,
"pet_s_surrendered_to_animal_shelter" BIGINT -- Pet(s) Surrendered To Animal Shelter,
"pet_s_placed_with_family" BIGINT -- Pet(s) Placed With Family,
"pet_s_placed_with_friend" BIGINT -- Pet(s) Placed With Friend,
"pet_s_placed_with_other" BIGINT -- Pet(s) Placed With "Other",
"pet_s_placed_with_non_profit" BIGINT -- Pet(s) Placed With Non-profit
);Anyone who has the link will be able to view this.