Name: Houston Astros Roster Data (1965-2020)
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Houston Astros Roster Data (1965-2020)

This dataset shows all rosters of the Houston Astros baseball team, from its founding in 1965 to 2020. The team was actually born in 1962 as the Houston Colt .45s, until 1964, after which they were renamed to Houston Astros.

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

Houston Astros Roster Data

@kaggle.dasanson_boston_red_sox_roster_data_1965_2020.houston_astros_roster_data

85.32 kB
2,279 rows
31 columns

CREATE TABLE houston_astros_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  -- 1B,
  "n_2b" BIGINT  -- 2B,
  "n_3b" BIGINT  -- 3B,
  "ss" BIGINT,
  "lf" BIGINT,
  "cf" BIGINT,
  "rf" BIGINT,
  "of" BIGINT,
  "dh" VARCHAR,
  "ph" BIGINT,
  "pr" VARCHAR,
  "war" VARCHAR,
  "all_star" VARCHAR,
  "hof" VARCHAR
);