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 Intakes

@kaggle.aaronschlegel_austin_animal_center_shelter_intakes_and_outcomes.aac_intakes

3.23 MB
80187 rows
12 columns

age_upon_intake Age Upon Intake	animal_id Animal Id	animal_type Animal Type	breed Breed	color Color	datetime Datetime	datetime2 Datetime2	found_location Found Location	intake_condition Intake Condition	intake_type Intake Type	name Name	sex_upon_intake Sex Upon Intake
8 years	A706918	Dog	English Springer Spaniel	White/Liver	Sun Jul 05 2015 12:59:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 05 2015 12:59:00 GMT+0000 (Coordinated Universal Time)	9409 Bluegrass Dr in Austin (TX)	Normal	Stray	Belle	Spayed Female
11 months	A724273	Dog	Basenji Mix	Sable/White	Thu Apr 14 2016 18:43:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 14 2016 18:43:00 GMT+0000 (Coordinated Universal Time)	2818 Palomino Trail in Austin (TX)	Normal	Stray	Runster	Intact Male
4 weeks	A665644	Cat	Domestic Shorthair Mix	Calico	Mon Oct 21 2013 07:59:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 21 2013 07:59:00 GMT+0000 (Coordinated Universal Time)	Austin (TX)	Sick	Stray	nan	Intact Female
4 years	A682524	Dog	Doberman Pinsch/Australian Cattle Dog	Tan/Gray	Sun Jun 29 2014 10:38:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 29 2014 10:38:00 GMT+0000 (Coordinated Universal Time)	800 Grove Blvd in Austin (TX)	Normal	Stray	Rio	Neutered Male
2 years	A743852	Dog	Labrador Retriever Mix	Chocolate	Sat Feb 18 2017 12:46:00 GMT+0000 (Coordinated Universal Time)	Sat Feb 18 2017 12:46:00 GMT+0000 (Coordinated Universal Time)	Austin (TX)	Normal	Owner Surrender	Odin	Neutered Male
2 years	A708452	Dog	Labrador Retriever Mix	Black/White	Thu Jul 30 2015 14:37:00 GMT+0000 (Coordinated Universal Time)	Thu Jul 30 2015 14:37:00 GMT+0000 (Coordinated Universal Time)	Austin (TX)	Normal	Public Assist	Mumble	Intact Male
5 months	A731435	Cat	Domestic Shorthair Mix	Cream Tabby	Mon Aug 08 2016 17:52:00 GMT+0000 (Coordinated Universal Time)	Mon Aug 08 2016 17:52:00 GMT+0000 (Coordinated Universal Time)	Austin (TX)	Normal	Owner Surrender	*Casey	Neutered Male
2 years	A760053	Dog	Chihuahua Shorthair	White/Tan	Wed Oct 11 2017 15:46:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 11 2017 15:46:00 GMT+0000 (Coordinated Universal Time)	8800 South First Street in Austin (TX)	Normal	Stray	nan	Intact Male
5 months	A707375	Dog	Pit Bull	Brown/White	Sat Jul 11 2015 18:19:00 GMT+0000 (Coordinated Universal Time)	Sat Jul 11 2015 18:19:00 GMT+0000 (Coordinated Universal Time)	Galilee Court And Damita Jo Dr in Manor (TX)	Normal	Stray	*Candy Cane	Intact Female
2 years	A696408	Dog	Chihuahua Shorthair	Tricolor	Wed Feb 04 2015 12:58:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 04 2015 12:58:00 GMT+0000 (Coordinated Universal Time)	9705 Thaxton in Austin (TX)	Normal	Stray	*Pearl	Intact Female


CREATE TABLE aac_intakes (
  "age_upon_intake" VARCHAR,
  "animal_id" VARCHAR,
  "animal_type" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "datetime" TIMESTAMP,
  "datetime2" TIMESTAMP,
  "found_location" VARCHAR,
  "intake_condition" VARCHAR,
  "intake_type" VARCHAR,
  "name" VARCHAR,
  "sex_upon_intake" VARCHAR
);