Animal Care And Control Adopted Animals
animal situation in Bloomington Animal Shelter from 2017-2020
@kaggle.jinbonnie_animal_data
animal situation in Bloomington Animal Shelter from 2017-2020
@kaggle.jinbonnie_animal_data
Street animals is always makes people concern, not only because they will cause some problem, is more about people worry about the animals living on the street by themself. Luckily we got so many shelters helping them, I have adopted a cat before, he was nice and cool.
In early 2017, the Bloomington Animal Shelter migrated management software from AnimalShelterNet to Shelter Manager. We attempted to preserve as much information as possible from the old system. The outcome fields in animal shelter are scattered in multiple fields not just one, for example Dead on arrival, Put to sleep, Movement Type and others are all considered as part of outcome.
Source: https://data.bloomington.in.gov/dataset/adopted-animals
Last updated at https://data.bloomington.in.gov/dataset : 2020-09-25
CREATE TABLE animal_data_1 (
"id" BIGINT,
"intakedate" TIMESTAMP,
"intakereason" VARCHAR,
"istransfer" BIGINT,
"sheltercode" VARCHAR,
"identichipnumber" VARCHAR,
"animalname" VARCHAR,
"breedname" VARCHAR,
"basecolour" VARCHAR,
"speciesname" VARCHAR,
"animalage" VARCHAR,
"sexname" VARCHAR,
"location" VARCHAR,
"movementdate" TIMESTAMP,
"movementtype" VARCHAR,
"istrial" DOUBLE,
"returndate" TIMESTAMP,
"returnedreason" VARCHAR,
"deceaseddate" TIMESTAMP,
"deceasedreason" VARCHAR,
"diedoffshelter" BIGINT,
"puttosleep" BIGINT,
"isdoa" BIGINT
);
Anyone who has the link will be able to view this.