A dataset detailing the challenges played including reward and immunity challenges.
challenge_results
This data frame contains the following columns
version
Country code for the version of the show
version_season
Version season key
season_name
The season name
season
The season number
episode
Episode number
n_boots
The number of boots that there have been in the game e.g. if n_boots == 2
there have been 2
boots in the game so far and there are N-2 castaways left in the game
castaway_id
ID 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).
castaway
Name 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
outcome_type
Whether the challenge is individual or tribal. Some individual reward challenges may involve multiple castaways as the winner gets to choose who they bring along
tribe
Current tribe the castaway is on
tribe_status
The status of the tribe e.g. original, swapped, merged, etc. See details for more
challenge_type
The challenge type e.g. immunity, reward, etc
challenge_id
Primary key to the challenge_description
data set which contains features of the challenge
result
Result of challenge
result_notes
Additional notes about the result of the challenge
order_of_finish
Order of finish for tribal challenges. Useful when there are 3 or more tribes to see who actually came first, second and who lost the challenge.
chosen_for_reward
If after the reward challenge the castaway was chosen to participate in the reward
sit_out
TRUE
if they sat out of the challenge or FALSE
if they participate
team
Team allocation when they are split into teams
sog_id
Stage of game ID for joining to boot_mapping
and vote_history
library(dplyr)
library(tidyr)
challenge_results %>%
filter(season == 40)
Run the code above in your browser using DataLab