Castaways
A dataset containing details on the results for every castaway and season
castaways
This data frame contains the following columns:
seasonSesaon number
season_nameSeason name
full_nameFull name of the castaway
castaway_idID of the castaway (primary key). Consistent across seasons and name changes e.g. Amber Brkich / Amber Mariano. The first two letters reference the country of the version played e.g. US, AU (TBA). To recreate the old ID simply extract the digits (See details)
castawayName of castaway. Generally this is the name they were most commonly referred to or nickname e.g. no one called Coach, Benjamin. He was simply Coach
ageAge of the castaway during the season they played
cityCity of residence during the season they played
stateState of residence during the season they played
personality_typeThe Myer-Briggs personality type of the castaway. This will be removed from this table and maintained on castaway_details in later releases
episodeEpisode number
dayNumber of days the castaway survived. A missing value indicates they later returned to the game that season
orderBoot order. Order in which castaway was voted out e.g. 5 is the 5th person voted of the island
resultFinal result
jury_statusJury status
original_tribeOriginal tribe name
swapped_tribeSwapped tribe name
swapped_tribe_2Second swapped tribe in the event of a second tribe swap or other tribe restructure such as absorbed tribe, outcasts, etc
merged_tribeMerged tribe name
total_votes_receivedTotal number of tribal votes received during the main game for a given season (not overall for those who have played more than once). This includes votes from ties
immunity_idols_wonThe number of immunity idols won by a castaway for the given season
If the original castaway_id is desired simply extract the digits from the ID e.g.
castaway_id = as.numeric(str_extract(castaway_id, '[:digit:]+')) in a mutate step.
library(dplyr) castaways %>% filter(season == 40)
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.