Austin Animal Center Shelter Outcomes
30,000 shelter animals
@kaggle.aaronschlegel_austin_animal_center_shelter_outcomes_and
30,000 shelter animals
@kaggle.aaronschlegel_austin_animal_center_shelter_outcomes_and
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 and is involved in a range of county, city, and state-wide initiatives for the protection and care of abandoned, at-risk, and surrendered animals.
As part of the City of Austin Open Data Initiative, the Austin Animal Center makes available its collected dataset that contains statistics and outcomes of animals entering the Austin Animal Services system.
The dataset contains shelter outcomes of several types of animals and breeds from 10/1/2013 to the present with a hourly time frequency. The data is updated daily.
The Austin Animal Center's original dataset includes columns for name, date of birth, outcome, animal type, sex and age at time of outcome, breed, and color. Outcomes range widely and include things like adoptions and transfers to other shelters.
From a thread in the discussion, here are definitions of some of the outcome types and subtypes:
The dataset is provided by the wonderful folks at the Austin Animal Center, the largest no-kill animal shelter in the United States. The AAC makes available the data on the Austin Open Data Portal. More information on the dataset can be found one the Shelter Outcomes page.
A simple script to programmatically extract the Austin Animal Center's shelter outcome dataset through the Socrata Open Data Access (SODA) API can be found as a Github Gist here. The shelter outcomes endpoint is https://data.austintexas.gov/resource/hcup-htgu.json.
The dataset was explored in a series of Jupyter Notebooks that end with a pipeline prediction model written in scikit-learn. The series of notebooks can be viewed here:
The inspiration for sharing this dataset and the associated notebooks is to spread awareness and provide another set of data to help support and care for the animals who need it most. By increasing the amount of data and knowledge around best practices and data analysis, those in the animal welfare community can more effectively respond and identify animals that need more support to avoid unwanted outcomes.
CREATE TABLE aac_shelter_cat_outcome_eng (
"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,
"count" BIGINT,
"sex" VARCHAR,
"spay_neuter" VARCHAR,
"periods" BIGINT,
"period_range" BIGINT,
"outcome_age_days" BIGINT -- Outcome Age (days),
"outcome_age_years" DOUBLE -- Outcome Age (years),
"cat_kitten_outcome" VARCHAR -- Cat/Kitten (outcome),
"sex_age_outcome" VARCHAR,
"age_group" VARCHAR,
"dob_year" BIGINT,
"dob_month" BIGINT,
"dob_monthyear" TIMESTAMP,
"outcome_month" BIGINT,
"outcome_year" BIGINT,
"outcome_weekday" VARCHAR,
"outcome_hour" BIGINT,
"breed1" VARCHAR,
"breed2" VARCHAR,
"cfa_breed" BOOLEAN,
"domestic_breed" BOOLEAN,
"coat_pattern" VARCHAR,
"color1" VARCHAR,
"color2" VARCHAR,
"coat" VARCHAR
);CREATE TABLE aac_shelter_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
);Anyone who has the link will be able to view this.