About this Dataset

Animal Shelter Animals

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.
Organization: City of Bloomington
Last updated: 2023-05-20T03:39:56.534254

Tables

Table 1

@usgov.city_of_bloomington_animal_shelter_animals_aa3c3.table_1

1.19 MB
39,078 rows
23 columns

CREATE TABLE table_1 (
  "id" BIGINT,
  "intakedate" VARCHAR,
  "intakereason" VARCHAR,
  "istransfer" BOOLEAN,
  "sheltercode" VARCHAR,
  "identichipnumber" VARCHAR,
  "animalname" VARCHAR,
  "breedname" VARCHAR,
  "basecolour" VARCHAR,
  "speciesname" VARCHAR,
  "animalage" VARCHAR,
  "sexname" VARCHAR,
  "location" VARCHAR,
  "movementdate" VARCHAR,
  "movementtype" VARCHAR,
  "istrial" BOOLEAN,
  "returndate" VARCHAR,
  "returnedreason" VARCHAR,
  "deceaseddate" VARCHAR,
  "deceasedreason" VARCHAR,
  "diedoffshelter" BOOLEAN,
  "puttosleep" BOOLEAN,
  "isdoa" BOOLEAN
);