Dataset: Austin Animal Center Shelter Intakes And Outcomes

About this Dataset

Austin Animal Center Shelter Intakes And Outcomes

Context

The Austin Animal Center is the largest no-kill animal shelter in the United States that provides care and shelter to over 18,000 animals each year. As part of the AAC's efforts to help and care for animals in need, the organization makes available its accumulated data and statistics as part of the city of Austin's Open Data Initiative.

Content

The data contains intakes and outcomes of animals entering the Austin Animal Center from the beginning of October 2013 to the present day. The datasets are also freely available on the Socrata Open Data Access API and are updated daily.

The following are links to the datasets hosted on Socrata's Open Data:

The data contained in this dataset is the outcomes and intakes data as noted above, as well as a combined dataset. The merging of the outcomes and intakes data was done on a unique key that is a combination of the given Animal ID and the intake number. Several of the animals in the dataset have been taken into the shelter multiple times, which creates duplicate Animal IDs that causes problems when merging the two datasets.

Copied from the description of the Shelter Outcomes dataset, here are some definitions of the outcome types:

Adoption
- the animal was adopted to a home
Barn Adoption
- the animal was adopted to live in a barn
Offsite Missing
- the animal went missing for unknown reasons at an offsite partner location
In-Foster Missing
- the animal is missing after being placed in a foster home
In-Kennel Missing
- the animal is missing after being transferred to a kennel facility
Possible Theft
- Although not confirmed, the animal went missing as a result of theft from the facility
Barn Transfer
- The animal was transferred to a facility for adoption into a barn environment
SNR
- SNR refers to the city of Austin's Shelter-Neuter-Release program. I believe the outcome is representative of the animal being released.

Acknowledgements

The data presented here is only possible through the hard work and dedication of the Austin Animal Center in saving and caring for animal lives.

Inspiration

Following from the first dataset I posted to Kaggle, Austin Animal Shelter Outcomes, which was initially filtered for just cats as part of an analysis I was performing, I wanted to post the complete outcome and complementing intake datasets. My hope is the great users of Kaggle will find this data interesting and want to explore shelter animal statistics further and perhaps get more involved in the animal welfare community. The analysis of this data and other shelter animal provided datasets helps uncover useful insights that have the potential to save lives directly.

Tables

Aac Intakes

@kaggle.aaronschlegel_austin_animal_center_shelter_intakes_and_outcomes.aac_intakes

3.23 MB
80187 rows
12 columns


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

Aac Outcomes

@kaggle.aaronschlegel_austin_animal_center_shelter_intakes_and_outcomes.aac_outcomes

2.71 MB
80681 rows
12 columns


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

Aac Intakes Outcomes

@kaggle.aaronschlegel_austin_animal_center_shelter_intakes_and_outcomes.aac_intakes_outcomes

5 MB
79672 rows
41 columns


CREATE TABLE aac_intakes_outcomes (
  "age_upon_outcome" VARCHAR,
  "animal_id_outcome" VARCHAR,
  "date_of_birth" TIMESTAMP,
  "outcome_subtype" VARCHAR,
  "outcome_type" VARCHAR,
  "sex_upon_outcome" VARCHAR,
  "age_upon_outcome_days" BIGINT,
  "age_upon_outcome_years" DOUBLE,
  "age_upon_outcome_age_group" VARCHAR,
  "outcome_datetime" TIMESTAMP,
  "outcome_month" BIGINT,
  "outcome_year" BIGINT,
  "outcome_monthyear" TIMESTAMP,
  "outcome_weekday" VARCHAR,
  "outcome_hour" BIGINT,
  "outcome_number" DOUBLE,
  "dob_year" BIGINT,
  "dob_month" BIGINT,
  "dob_monthyear" TIMESTAMP,
  "age_upon_intake" VARCHAR,
  "animal_id_intake" VARCHAR,
  "animal_type" VARCHAR,
  "breed" VARCHAR,
  "color" VARCHAR,
  "found_location" VARCHAR,
  "intake_condition" VARCHAR,
  "intake_type" VARCHAR,
  "sex_upon_intake" VARCHAR,
  "count" BIGINT,
  "age_upon_intake_days" BIGINT,
  "age_upon_intake_years" DOUBLE,
  "age_upon_intake_age_group" VARCHAR,
  "intake_datetime" TIMESTAMP,
  "intake_month" BIGINT,
  "intake_year" BIGINT,
  "intake_monthyear" TIMESTAMP,
  "intake_weekday" VARCHAR,
  "intake_hour" BIGINT,
  "intake_number" DOUBLE,
  "time_in_shelter" VARCHAR,
  "time_in_shelter_days" DOUBLE
);