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 Outcomes

@kaggle.jackdaoud_animal_shelter_analytics.austin_animal_center_outcomes

4.41 MB
124491 rows
12 columns

animal_id Animal ID	name Name	datetime DateTime	monthyear MonthYear	date_of_birth Date Of Birth	outcome_type Outcome Type	outcome_subtype Outcome Subtype	animal_type Animal Type	sex_upon_outcome Sex Upon Outcome	age_upon_outcome Age Upon Outcome	breed Breed	color Color
A794011	Chunk	05/08/2019 06:20:00 PM	05/08/2019 06:20:00 PM	Tue May 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Rto-Adopt	nan	Cat	Neutered Male	2 years	Domestic Shorthair Mix	Brown Tabby/White
A776359	Gizmo	07/18/2018 04:02:00 PM	07/18/2018 04:02:00 PM	Wed Jul 12 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Adoption	nan	Dog	Neutered Male	1 year	Chihuahua Shorthair Mix	White/Brown
A821648	nan	08/16/2020 11:38:00 AM	08/16/2020 11:38:00 AM	Fri Aug 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Euthanasia	nan	Other	Unknown	1 year	Raccoon	Gray
A720371	Moose	02/13/2016 05:59:00 PM	02/13/2016 05:59:00 PM	Thu Oct 08 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Adoption	nan	Dog	Neutered Male	4 months	Anatol Shepherd/Labrador Retriever	Buff
A674754	nan	03/18/2014 11:47:00 AM	03/18/2014 11:47:00 AM	Wed Mar 12 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Transfer	Partner	Cat	Intact Male	6 days	Domestic Shorthair Mix	Orange Tabby
A659412	Princess	10/05/2020 02:37:00 PM	10/05/2020 02:37:00 PM	Sun Mar 24 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Adoption	nan	Dog	Spayed Female	7 years	Chihuahua Shorthair Mix	Brown
A814515	Quentin	05/06/2020 07:59:00 AM	05/06/2020 07:59:00 AM	Thu Mar 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Adoption	Foster	Dog	Neutered Male	2 years	American Foxhound/Labrador Retriever	White/Brown
A689724	*Donatello	10/18/2014 06:52:00 PM	10/18/2014 06:52:00 PM	Fri Aug 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Adoption	nan	Cat	Neutered Male	2 months	Domestic Shorthair Mix	Black
A680969	*Zeus	08/05/2014 04:59:00 PM	08/05/2014 04:59:00 PM	Tue Jun 03 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Adoption	nan	Cat	Neutered Male	2 months	Domestic Shorthair Mix	White/Orange Tabby
A684617	nan	07/27/2014 09:00:00 AM	07/27/2014 09:00:00 AM	Thu Jul 26 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Transfer	SCRP	Cat	Intact Female	2 years	Domestic Shorthair Mix	Black


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