boot_mapping: Boot mapping

Description

A mapping table for easily filtering to the set of castaways that are still in the game after a specified number of boots.

Usage

boot_mapping

Arguments

Format

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
order: The number of boots that there have been in the game e.g. if order == 2 there have been 2 boots in the game so far and there are N-2 castaways left in the game
final_n: The final number of castaways e.g. you can filter to the final 4 by filter(boot_mapping, final_n == 4). There are missing values where players have returned to the game. This means there are multiple stages of the game where there is a different make up of the final 8, for example. This field just takes the last set so that you can filter for final_n and it will return a single set of castaways.
n_boots: Similar to final_n but the number of boots in the game. This is different to order where order counts if someone has been booted twice. n_boots is simply the number of people in the season minus the final_n.
sog_id: Stage of game ID for joining to vote_history and challenge_results
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.
castaway: Name of the castaway
tribe: Name of the tribe the castaway was on
tribe_status: The status of the tribe e.g. original, swapped, merged, etc. See details for more
game_status: Logical flag to identify if the castaway is currently in the game. If FALSE the castaway is on Redemption Island or Edge of Extinction.