Skip to content
Branch: master
Find file History
Latest commit 7ef787b Dec 17, 2019
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
dog_descriptions.csv add week 51 Dec 14, 2019
dog_moves.csv add week 51 Dec 14, 2019
dog_travel.csv add week 51 Dec 14, 2019
readme.md No fancy quotes in code Dec 17, 2019

readme.md

Adoptable dogs

This week’s data is from The Pudding. The data was cleaned, collected and story written by Amber Thomas, with design by Sacha Maxim.

Their article Finding Forever Homes examines data on all adoptable dogs from Petfinder.com in the USA on 2019-09-20.

There are a number of datasets, where the dog_travel and dog_descriptions datasets can be joined via the common id column.

The premise of the story in Amber's own words:

"If you’re looking to add a new furry friend to your family, you may be encouraged to “adopt not shop”. That is, to find a new dog at a local shelter or rescue organization rather than a pet store or breeder.

But where do adoptable dogs come from?"

# Get the Data

dog_moves <- readr::read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2019/2019-12-17/dog_moves.csv')
dog_travel <- readr::read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2019/2019-12-17/dog_travel.csv')
dog_descriptions <- readr::read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2019/2019-12-17/dog_descriptions.csv')

# Or read in with tidytuesdayR package (https://github.com/thebioengineer/tidytuesdayR)

# Either ISO-8601 date or year/week works!

# Install via devtools::install_github("thebioengineer/tidytuesdayR")

tuesdata <- tidytuesdayR::tt_load('2019-12-17') 
tuesdata <- tidytuesdayR::tt_load(2019, week = 51)


dog_moves <- tuesdata$dog_moves

Dictionary

dog_moves.csv

variable class description
location character The full name of the US state or country
exported double The number of adoptable dogs available in the US that originated in this location but were available for adoption in another location
imported double The number of adoptable dogs available in this state that originated in a different location
total double The total number of adoptable dogs availabe in a given state.
inUS logical Whether or not a location is in the US or not. Here, US territories will return FALSE

dog_travel.csv

variable class description
id double The unique PetFinder identification number for each animal
contact_city character The rescue/shelter's listed city
contact_state character The rescue/shelter's listed State
description character The full description of each animal as entered by the rescue/shelter
found character Where the animal was found.
manual character .
remove logical Animal removed from location
still_there logical TRUE/FALSE - Whether the animal is still located in their origin location and will be transported to their final destination after adoption.

dog_descriptions.csv

variable class description
id double The unique PetFinder identification number for each animal.
org_id character The unique identification number for each shelter or rescue.
url character The URL for each animal's listing.
species character Species of animal.
breed_primary character The primary (assumed) breed assigned by the shelter or rescue.
breed_secondary character The secondary (assumed) breed assigned by the shelter or rescue.
breed_mixed logical Whether or not an animal is presumed to be mixed breed.
breed_unknown logical Whether or not the animal's breed is completely unknown.
color_primary character The most prevalent color of an animal.
color_secondary character The second most prevalent color of an animal.
color_tertiary character The third most prevalent color of an animal.
age character The assumed age class of an animal (Baby, Young, Adult, or Senior).
sex character The sex of an animal (Female, Male, or Unknown).
size character The general size class of an animal (Small, Medium, Large, Extra Large).
coat character Coat Length for each animal (Curly, Hairless, Long, Medium, Short, Wire).
fixed logical Whether or not an animal has been spayed/neutered.
house_trained logical Whether or not an animal is trained to not go to the bathroom in the house.
declawed logical Whether or not the animal has had its dewclaws removed.
special_needs logical Whether or not the animal is considered to have special needs (this can be a long-term medical condition or particular temperament that requires extra care).
shots_current logical Whether or not the animal is up to date on all of their vaccines and other shots.
env_children logical Whether or not the animal is recommended for a home with children.
env_dogs logical Whether or not the animal is recommended for a home with other dogs.
env_cats logical Whether or not the animal is recommended for a home with cats.
name character The animal’s name (as given by the shelter/rescue).
tags character Any tags given to the dog by the shelter rescue (pipe | separated).
photo character The URL to the animal’s primary photo.
status character Whether the animal is adoptable or not.
posted character The date that this animal was first listed on PetFinder .
contact_city character The rescue/shelter’s listed city.
contact_state character The rescue/shelter’s listed state.
contact_zip character The rescue/shelter’s listed zip code.
contact_country character The rescue/shelter’s listed country.
stateQ character The state abbreviation queried in the API to return this result .
accessed double The date that this data was acquired from the PetFinder API.
type character The type of animal.
description character The full description of an animal, as entered by the rescue or shelter. This is the only field returned by the V1 API.

Cleaning

All the code/cleaning can be found on The Pudding Github.

You can’t perform that action at this time.