Name: Animal Shelter Analytics
Creator: Kaggle
License: https://www.usa.gov/government-works

About this Dataset

Animal Shelter Analytics

Context

I was reading Every Nose Counts: Using Metrics in Animal Shelters when I got inspired to conduct an EDA on animal shelter data. I looked online for data and found this dataset which is curated by Austin Animal Center. The data can be found on https://data.austintexas.gov.

This data can be utilized for EDA practice. So go ahead and help animal shelters with your EDA powers by completing this task!

Content

The data set contains three CSVs:

More TBD!

Acknowledgement

Thank you Austin Animal Center for all the animal protection you provide to stray & owned animals. Also, thank you for making your data accessible to the public.

Tables

Austin Animal Center Intakes

@kaggle.jackdaoud_animal_shelter_analytics.austin_animal_center_intakes

5.54 MB
124120 rows
12 columns


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
);

Austin Animal Center Outcomes

@kaggle.jackdaoud_animal_shelter_analytics.austin_animal_center_outcomes

4.41 MB
124491 rows
12 columns


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
);

Austin Animal Center Stray Map

@kaggle.jackdaoud_animal_shelter_analytics.austin_animal_center_stray_map

8.69 KB
16 rows
10 columns


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
);