Animal Care And Control Adopted Animals

animal situation in Bloomington Animal Shelter from 2017-2020

@kaggle.jinbonnie_animal_data

Table List

1 table(369.66 KB)

Animal Data 1

@kaggle.jinbonnie_animal_data.animal_data_1

369.66 KB
10290 rows
23 columns

id Id	intakedate Intakedate	intakereason Intakereason	sheltercode Sheltercode	identichipnumber Identichipnumber	animalname Animalname	breedname Breedname	basecolour Basecolour	speciesname Speciesname	animalage Animalage	sexname Sexname	location Location	movementdate Movementdate	movementtype Movementtype	returndate Returndate	returnedreason Returnedreason	deceasedreason Deceasedreason
15801	Sat Nov 28 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Moving	C09115463	0A115D7358	Jadzia	Domestic Short Hair	Tortie	Cat	9 years 2 months.	Female	Adoptable Cat Glass Colony	Sat May 13 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Adoption		Stray	Died in care
15932	Tue Dec 08 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Moving	D09125594	0A11675477	Gonzo	German Shepherd Dog/Mix	Tan	Dog	9 years 1 month.	Male	Adoptable Dogs	Mon Apr 24 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Adoption		Stray	Died in care
28859	Fri Aug 10 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Abandoned	D12082309	0A13253C7B	Maggie	Shep Mix/Siberian Husky	Various	Dog	6 years 8 months.	Female	Adoptable Dogs	Sat Apr 15 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Adoption		Stray	Died in care
30812	Fri Jan 11 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Abandoned	C1301091	0A13403D4D	Pretty Girl	Domestic Short Hair	Dilute tortoiseshell	Cat	8 years 11 months.	Female	Stray Cats	Tue Apr 18 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Foster	Tue May 29 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Stray	Died in care
30812	Fri Jan 11 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Abandoned	C1301091	0A13403D4D	Pretty Girl	Domestic Short Hair	Dilute tortoiseshell	Cat	8 years 11 months.	Female	Stray Cats	Tue May 29 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Adoption		Stray	Died in care
31469	Tue Mar 26 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Incompatible with owner lifestyle	D1303720	981020007006095	Bonnie	Basenji/Mix	Brown and White	Dog	5 years 11 months.	Female	Stray Dogs Beta	Sat Mar 30 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Adoption	Mon May 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Incompatible with owner lifestyle	Died in care
31469	Tue Mar 26 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Incompatible with owner lifestyle	D1303720	981020007006095	Bonnie	Basenji/Mix	Brown and White	Dog	5 years 11 months.	Female	Stray Dogs Beta	Tue May 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Adoption		Stray	Died in care
40705	Fri Jun 19 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Abandoned	R15061738	nan	Candy	American Sable/American	Brown	House Rabbit	4 years 6 months.	Female	Lobby	Wed Apr 12 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Transfer		Stray	Died in care
40706	Fri Jun 19 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Abandoned	R15061739	nan	Charlotte	American Sable/American	Brown	House Rabbit	4 years 6 months.	Female	Lobby	Wed Apr 12 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Transfer		Stray	Died in care
46238	Sun Oct 09 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Abandoned	D16103207	981020019070093	Tennessee	Heeler/Mix	Brown and Black	Dog	3 years 2 months.	Male	Special Care Dogs	Sat Nov 26 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Foster	Sun Jul 23 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Stray	Died in care


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
);