Animal Shelter Analytics

Practice Exploratory Data Analysis with Animal Shelter Data

@kaggle.jackdaoud_animal_shelter_analytics

Table List

3 tables(9.95 MB)

Austin Animal Center Intakes

Austin Animal Center Outcomes

Austin Animal Center Stray Map

Austin Animal Center Stray Map

@kaggle.jackdaoud_animal_shelter_analytics.austin_animal_center_stray_map

8.69 KB
16 rows
10 columns

animal_id Animal ID	found_location Found Location	at_aac At AAC	intake_date Intake Date	type Type	looks_like Looks Like	color Color	sex Sex	age Age	image_link Image Link
A814119	11800 GREEN GROVE DRIVE AUSTIN 78725 (30.221901, -97.632008)	Yes (come to the shelter)	Fri Feb 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Dog	Pit Bull	Brown Brindle	Neutered Male	3 years	http://www.petharbor.com/pet.asp?uaid=ASTN.A814119
A829667	9807 MARLBOROUGH DRIVE AUSTIN 78753 (30.357344, -97.674667)	Yes (come to the shelter)	Sat Feb 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Dog	Anatolian Shepherd Mix	Yellow	Intact Male	2 years	http://www.petharbor.com/pet.asp?uaid=ASTN.A829667
A829669	12501 TECH RIDGE BOULEVARD AUSTIN 78753 (30.398698, -97.661704)	Yes (come to the shelter)	Sat Feb 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Dog	Labrador Retriever Mix	Tan/White	Spayed Female	2 years	http://www.petharbor.com/pet.asp?uaid=ASTN.A829669
A829713	10605 OLD LOCKHART ROAD AUSTIN 78747 (30.128945, -97.755855)	Yes (come to the shelter)	Sun Feb 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Dog	Doberman Pinsch	Black/Tan	Intact Female	6 months	http://www.petharbor.com/pet.asp?uaid=ASTN.A829713
A829659	14204 JACOBSON ROAD AUSTIN 78617 (30.137238, -97.618754)	Yes (come to the shelter)	Fri Feb 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Dog	Labrador Retriever	Black/White	Intact Female	5 months	http://www.petharbor.com/pet.asp?uaid=ASTN.A829659
A829660	14204 JACOBSON ROAD AUSTIN 78617 (30.137238, -97.618754)	Yes (come to the shelter)	Fri Feb 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Dog	Carolina Dog	Yellow Brindle/White	Intact Female	5 months	http://www.petharbor.com/pet.asp?uaid=ASTN.A829660
A829661	9604 CARSON CREEK AUSTIN 78617 (30.224098, -97.666406)	Yes (come to the shelter)	Fri Feb 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Cat	Domestic Shorthair	Orange Tabby	Intact Male	1 year	http://www.petharbor.com/pet.asp?uaid=ASTN.A829661
A829664	DEL VALLE AUSTIN 78719 (30.143087, -97.673385)	Yes (come to the shelter)	Sat Feb 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Dog	Labrador Retriever	Brown/Black	Intact Male	2 years	http://www.petharbor.com/pet.asp?uaid=ASTN.A829664
A829672	AUSTIN 78744 (30.186349, -97.738673)	Yes (come to the shelter)	Sat Feb 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Dog	Doberman Pinsch	Black/Tan	Intact Female	6 months	http://www.petharbor.com/pet.asp?uaid=ASTN.A829672
A716730	4434 FRONTIER TRAIL AUSTIN 78745 (30.23124, -97.795476)	Yes (come to the shelter)	Mon Feb 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Cat	Domestic Shorthair Mix	Brown Tabby	Spayed Female	5 years	http://www.petharbor.com/pet.asp?uaid=ASTN.A716730


CREATE TABLE austin_animal_center_stray_map (
  "animal_id" VARCHAR,
  "found_location" VARCHAR,
  "at_aac" VARCHAR,
  "intake_date" TIMESTAMP,
  "type" VARCHAR,
  "looks_like" VARCHAR,
  "color" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "image_link" VARCHAR
);