Austin Animal Center Shelter Intakes And Outcomes

80,000 Shelter Animal Intakes and Resulting Outcomes

@kaggle.aaronschlegel_austin_animal_center_shelter_intakes_and_outcomes

Table List

3 tables(10.93 MB)

Aac Intakes

Aac Outcomes

Aac Intakes Outcomes

Aac Outcomes

@kaggle.aaronschlegel_austin_animal_center_shelter_intakes_and_outcomes.aac_outcomes

2.71 MB
80681 rows
12 columns

age_upon_outcome Age Upon Outcome	animal_id Animal Id	animal_type Animal Type	breed Breed	color Color	date_of_birth Date Of Birth	datetime Datetime	monthyear Monthyear	name Name	outcome_subtype Outcome Subtype	outcome_type Outcome Type	sex_upon_outcome Sex Upon Outcome
2 weeks	A684346	Cat	Domestic Shorthair Mix	Orange Tabby	Mon Jul 07 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 22 2014 16:04:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 22 2014 16:04:00 GMT+0000 (Coordinated Universal Time)	nan	Partner	Transfer	Intact Male
1 year	A666430	Dog	Beagle Mix	White/Brown	Tue Nov 06 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Nov 07 2013 11:47:00 GMT+0000 (Coordinated Universal Time)	Thu Nov 07 2013 11:47:00 GMT+0000 (Coordinated Universal Time)	Lucy	Partner	Transfer	Spayed Female
1 year	A675708	Dog	Pit Bull	Blue/White	Sun Mar 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 03 2014 14:20:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 03 2014 14:20:00 GMT+0000 (Coordinated Universal Time)	*Johnny	nan	Adoption	Neutered Male
9 years	A680386	Dog	Miniature Schnauzer Mix	White	Thu Jun 02 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 15 2014 15:50:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 15 2014 15:50:00 GMT+0000 (Coordinated Universal Time)	Monday	Partner	Transfer	Neutered Male
5 months	A683115	Other	Bat Mix	Brown	Tue Jan 07 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jul 07 2014 14:04:00 GMT+0000 (Coordinated Universal Time)	Mon Jul 07 2014 14:04:00 GMT+0000 (Coordinated Universal Time)	nan	Rabies Risk	Euthanasia	Unknown
4 months	A664462	Dog	Leonberger Mix	Brown/White	Mon Jun 03 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 07 2013 13:06:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 07 2013 13:06:00 GMT+0000 (Coordinated Universal Time)	*Edgar	Partner	Transfer	Intact Male
1 month	A685067	Cat	Domestic Shorthair Mix	Blue Tabby/White	Mon Jun 16 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Aug 14 2014 18:45:00 GMT+0000 (Coordinated Universal Time)	Thu Aug 14 2014 18:45:00 GMT+0000 (Coordinated Universal Time)	Lucy	nan	Adoption	Intact Female
3 months	A678580	Cat	Domestic Shorthair Mix	White/Black	Wed Mar 26 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 29 2014 17:45:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 29 2014 17:45:00 GMT+0000 (Coordinated Universal Time)	*Frida	Offsite	Adoption	Spayed Female
1 year	A675405	Cat	Domestic Medium Hair Mix	Black/White	Wed Mar 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 28 2014 14:55:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 28 2014 14:55:00 GMT+0000 (Coordinated Universal Time)	Stella Luna	nan	Return to Owner	Spayed Female
2 years	A673652	Dog	Papillon/Border Collie	Black/White	Tue Feb 28 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 28 2014 14:39:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 28 2014 14:39:00 GMT+0000 (Coordinated Universal Time)	Fancy	Partner	Transfer	Neutered Male


CREATE TABLE aac_outcomes (
  "age_upon_outcome" VARCHAR,
  "animal_id" VARCHAR,
  "animal_type" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "date_of_birth" TIMESTAMP,
  "datetime" TIMESTAMP,
  "monthyear" TIMESTAMP,
  "name" VARCHAR,
  "outcome_subtype" VARCHAR,
  "outcome_type" VARCHAR,
  "sex_upon_outcome" VARCHAR
);