A dataset containing details on the results for every castaway and season
castawaysThis data frame contains the following columns:
versionCountry code for the version of the show
version_seasonVersion season key
seasonSeason 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).
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
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
placePlace as a number e.g. Sole Survivor is 1, runner-up 2, etc
jury_statusJury status
original_tribeOriginal tribe name
finalistLogical. TRUE if the castaway was a finalists
juryLogical. TRUE if the castaway was a jury member
winnerLogical. TRUE if the castaway was the winner
acknowledgeDid the contestant acknowledge their teammates in one of these specific ways after snuffing — or just walk away?
ack_gesturefor any physical gestures towards the tribe after torch snuffing. Types: wave, nod, wink, bow or prayer sign with hands
ack_lookFor making eye contact with one or more members of the tribe after torch snuffing
ack_smileFor smiling at the tribe after torch snuffing
ack_speakFor any verbal communication directed at the tribe after torch snuffing
ack_quoteWhat, if anything, the contestant said. Direct quotes only.
ack_scoreThe 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