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 Intakes

@kaggle.jackdaoud_animal_shelter_analytics.austin_animal_center_intakes

5.54 MB
124120 rows
12 columns

animal_id Animal ID	name Name	datetime DateTime	monthyear MonthYear	found_location Found Location	intake_type Intake Type	intake_condition Intake Condition	animal_type Animal Type	sex_upon_intake Sex Upon Intake	age_upon_intake Age Upon Intake	breed Breed	color Color
A786884	*Brock	01/03/2019 04:19:00 PM	01/03/2019 04:19:00 PM	2501 Magin Meadow Dr in Austin (TX)	Stray	Normal	Dog	Neutered Male	2 years	Beagle Mix	Tricolor
A706918	Belle	07/05/2015 12:59:00 PM	07/05/2015 12:59:00 PM	9409 Bluegrass Dr in Austin (TX)	Stray	Normal	Dog	Spayed Female	8 years	English Springer Spaniel	White/Liver
A724273	Runster	04/14/2016 06:43:00 PM	04/14/2016 06:43:00 PM	2818 Palomino Trail in Austin (TX)	Stray	Normal	Dog	Intact Male	11 months	Basenji Mix	Sable/White
A665644	nan	10/21/2013 07:59:00 AM	10/21/2013 07:59:00 AM	Austin (TX)	Stray	Sick	Cat	Intact Female	4 weeks	Domestic Shorthair Mix	Calico
A682524	Rio	06/29/2014 10:38:00 AM	06/29/2014 10:38:00 AM	800 Grove Blvd in Austin (TX)	Stray	Normal	Dog	Neutered Male	4 years	Doberman Pinsch/Australian Cattle Dog	Tan/Gray
A743852	Odin	02/18/2017 12:46:00 PM	02/18/2017 12:46:00 PM	Austin (TX)	Owner Surrender	Normal	Dog	Neutered Male	2 years	Labrador Retriever Mix	Chocolate
A635072	Beowulf	04/16/2019 09:53:00 AM	04/16/2019 09:53:00 AM	415 East Mary Street in Austin (TX)	Public Assist	Normal	Dog	Neutered Male	6 years	Great Dane Mix	Black
A708452	Mumble	07/30/2015 02:37:00 PM	07/30/2015 02:37:00 PM	Austin (TX)	Public Assist	Normal	Dog	Intact Male	2 years	Labrador Retriever Mix	Black/White
A818975	nan	06/18/2020 02:53:00 PM	06/18/2020 02:53:00 PM	Braker Lane And Metric in Travis (TX)	Stray	Normal	Cat	Intact Male	4 weeks	Domestic Shorthair	Cream Tabby
A774147	nan	06/11/2018 07:45:00 AM	06/11/2018 07:45:00 AM	6600 Elm Creek in Austin (TX)	Stray	Injured	Cat	Intact Female	4 weeks	Domestic Shorthair Mix	Black/White


CREATE TABLE austin_animal_center_intakes (
  "animal_id" VARCHAR,
  "name" VARCHAR,
  "datetime" VARCHAR,
  "monthyear" VARCHAR,
  "found_location" VARCHAR,
  "intake_type" VARCHAR,
  "intake_condition" VARCHAR,
  "animal_type" VARCHAR,
  "sex_upon_intake" VARCHAR,
  "age_upon_intake" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR
);