A dataset containing details on the results for every castaway and season
castaways
This data frame contains the following columns:
version
Country code for the version of the show
version_season
Version season key
season
Season number
season_name
Season name
full_name
Full name of the castaway
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
age
Age of the castaway during the season they played
city
City of residence during the season they played
state
State of residence during the season they played
episode
Episode number
day
Number of days the castaway survived. A missing value indicates they later returned to the game that season
order
Boot order. Order in which castaway was voted out e.g. 5 is the 5th person voted of the island
result
Final result
place
Place as a number e.g. Sole Survivor is 1, runner-up 2, etc
jury_status
Jury status
original_tribe
Original tribe name
finalist
Logical. TRUE
if the castaway was a finalists
jury
Logical. TRUE
if the castaway was a jury member
winner
Logical. TRUE
if the castaway was the winner
acknowledge
Did the contestant acknowledge their teammates in one of these specific ways after snuffing — or just walk away?
ack_gesture
for any physical gestures towards the tribe after torch snuffing. Types: wave, nod, wink, bow or prayer sign with hands
ack_look
For making eye contact with one or more members of the tribe after torch snuffing
ack_smile
For smiling at the tribe after torch snuffing
ack_speak
For any verbal communication directed at the tribe after torch snuffing
ack_quote
What, if anything, the contestant said. Direct quotes only.
ack_score
The score is derived from the four subcategories of acknowledgment: words, look, gesture, and smile. Each true value in these categories adds 1 to the score.
Note that in the seasons where castaways returned to the game e.g. Redemption Island, a castaway may appear twice.
library(dplyr)
castaways %>%
filter(season == 40)
Run the code above in your browser using DataLab