Dataset: Boston Red Sox Roster Data (1908-2020)

About this Dataset

Boston Red Sox Roster Data (1908-2020)

This dataset shows all rosters of the Boston Red Sox baseball team, from its founding in 1908 to 2020. The team was actually born in 1901 as the Boston Americans, until 1907, after which they were renamed to Boston Red Sox.

The Excel file includes filters for each column.

Column Description

Season: Year of the season
Name: Name of the player
Age: Age of the player
Born: Country in which the player was born
Flag: Flag of the country
B: Batting side
T: Throwing hand
Ht: Height in feet and inches
Wt: Weight in pounds
DoB: Date of birth
Yrs: Years of experience, i.e. years the player was or has been in the major leagues, players in their first season are shown as “1st”
GP: Games played
GS: Games started
Batting: Games appeared in the batting order (may have not batted)
Defense: Games in lineup at a defensive position
P: Game in lineup or announced as a pitcher
C: Games in lineup as a catcher
1B: Games in lineup as a first baseman
2B: Games in lineup as a second baseman
3B: Games in lineup as a third baseman
SS: Games in lineup as a shortstop
LF: Games in lineup as a left fielder
CF: Games in lineup as a center fielder
RF: Games in lineup as a right fielder
OF: Games in lineup as an outfielder
DH: Games in lineup as a designated hitter
PH: Games in lineup as a pinch hitter (may have played another position as well)
PR: Games in lineup as a pinch runner (may have played another position as well)
WAR: Wins Above Replacement, i.e. number of wins the player added to the team above what a replacement player would add
All-Star: Was the player an all-star in the season?
HOF: Is or was the player a Hall of Famer?

Tables

Boston Red Sox Roster Data

@kaggle.dasanson_boston_red_sox_roster_data_1908_2020.boston_red_sox_roster_data

133.84 KB
4334 rows
31 columns


CREATE TABLE boston_red_sox_roster_data (
  "season" BIGINT,
  "name" VARCHAR,
  "age" BIGINT,
  "born" VARCHAR,
  "flag" VARCHAR,
  "b" VARCHAR,
  "t" VARCHAR,
  "ht" VARCHAR,
  "wt" DOUBLE,
  "dob" VARCHAR,
  "yrs" VARCHAR,
  "gp" BIGINT,
  "gs" BIGINT,
  "batting" BIGINT,
  "defense" BIGINT,
  "p" BIGINT,
  "c" BIGINT,
  "n_1b" BIGINT,
  "n_2b" BIGINT,
  "n_3b" BIGINT,
  "ss" BIGINT,
  "lf" BIGINT,
  "cf" BIGINT,
  "rf" BIGINT,
  "of" BIGINT,
  "dh" VARCHAR,
  "ph" BIGINT,
  "pr" BIGINT,
  "war" VARCHAR,
  "all_star" VARCHAR,
  "hof" VARCHAR
);