Baselight
Sign In

The History Of Baseball

A complete history of major league baseball stats from 1871 to 2015

@kaggle.seanlahman_the_history_of_baseball

All Star
@kaggle.seanlahman_the_history_of_baseball.all_star

  • 33 KB
  • 5069 rows
  • 8 columns
player_id

Player Id

year

Year

game_num

Game Num

game_id

Game Id

team_id

Team Id

league_id

League Id

gp

Gp

starting_pos

Starting Pos

gomezle011933ALS193307060NYAAL11
ferreri011933ALS193307060BOSAL12
gehrilo011933ALS193307060NYAAL13
gehrich011933ALS193307060DETAL14
dykesji011933ALS193307060CHAAL15
cronijo011933ALS193307060WS1AL16
chapmbe011933ALS193307060NYAAL17
simmoal011933ALS193307060CHAAL18
ruthba011933ALS193307060NYAAL19
averiea011933ALS193307060CLEAL1

CREATE TABLE all_star (
  "player_id" VARCHAR,
  "year" BIGINT,
  "game_num" BIGINT,
  "game_id" VARCHAR,
  "team_id" VARCHAR,
  "league_id" VARCHAR,
  "gp" DOUBLE,
  "starting_pos" DOUBLE
);