Baselight

Los Angeles Dodgers Roster Data (1958-2020)

This dataset shows all Los Angeles Dodgers rosters from 1958 to 2020

@kaggle.dasanson_los_angeles_dodgers_roster_data_1958_2020

Loading...
Loading...

About this Dataset

Los Angeles Dodgers Roster Data (1958-2020)

This dataset shows all rosters of the Los Angeles Dodgers baseball team, from its founding in 1958 to 2020. The team was actually born in 1884 as the Brooklyn Atlantics, and after several changes, became Los Angeles Dodgers in 1958.

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

Los Angeles Dodgers Roster Data

@kaggle.dasanson_los_angeles_dodgers_roster_data_1958_2020.los_angeles_dodgers_roster_data
  • 91.04 KB
  • 2588 rows
  • 31 columns
Loading...

CREATE TABLE los_angeles_dodgers_roster_data (
  "season" BIGINT,
  "name" VARCHAR,
  "age" BIGINT,
  "born" VARCHAR,
  "flag" VARCHAR,
  "b" VARCHAR,
  "t" VARCHAR,
  "ht" VARCHAR,
  "wt" BIGINT,
  "dob" TIMESTAMP,
  "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" DOUBLE,
  "all_star" VARCHAR,
  "hof" VARCHAR
);

Share link

Anyone who has the link will be able to view this.