Name: The History Of Baseball
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

The History Of Baseball

Baffled why your team traded for that 34-year-old pitcher? Convinced you can create a new and improved version of WAR? Wondering what made the 1907 Cubs great and if can they do it again?

The History of Baseball is a reformatted version of the famous Lahman’s Baseball Database. It contains Major League Baseball’s complete batting and pitching statistics from 1871 to 2015, plus fielding statistics, standings, team stats, park stats, player demographics, managerial records, awards, post-season data, and more.

Scripts, Kaggle’s free, in-browser analytics tool, makes it easy to share detailed sabermetrics, predict the next hall of fame inductee, illustrate how speed scores runs, or publish a definitive analysis on why the Los Angeles Dodgers will never win another World Series.

We have more ideas for analysis than games in a season, but here are a few we’d really love to see:

Is there a most error-prone position?
When do players at different positions peak?
Are the best performers selected for all-star game?
How many walks does it take for a starting pitcher to get pulled?
Do players with a high ground into double play (GIDP) have a lower batting average?
Which players are the most likely to choke during the post-season?
Why should or shouldn’t the National League adopt the designated hitter rule?

See the full SQLite schema.

Tables

All Star

@kaggle.seanlahman_the_history_of_baseball.all_star

33.79 kB
5,069 rows
8 columns

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
);

Appearances

@kaggle.seanlahman_the_history_of_baseball.appearances

1.25 MB
100,951 rows
21 columns

CREATE TABLE appearances (
  "year" BIGINT,
  "team_id" VARCHAR,
  "league_id" VARCHAR,
  "player_id" VARCHAR,
  "g_all" DOUBLE,
  "gs" DOUBLE,
  "g_batting" BIGINT,
  "g_defense" DOUBLE,
  "g_p" BIGINT,
  "g_c" BIGINT,
  "g_1b" BIGINT,
  "g_2b" BIGINT,
  "g_3b" BIGINT,
  "g_ss" BIGINT,
  "g_lf" BIGINT,
  "g_cf" BIGINT,
  "g_rf" BIGINT,
  "g_of" BIGINT,
  "g_dh" DOUBLE,
  "g_ph" DOUBLE,
  "g_pr" DOUBLE
);

Batting

@kaggle.seanlahman_the_history_of_baseball.batting

1.76 MB
101,332 rows
22 columns

CREATE TABLE batting (
  "player_id" VARCHAR,
  "year" BIGINT,
  "stint" BIGINT,
  "team_id" VARCHAR,
  "league_id" VARCHAR,
  "g" BIGINT,
  "ab" DOUBLE,
  "r" DOUBLE,
  "h" DOUBLE,
  "double" DOUBLE,
  "triple" DOUBLE,
  "hr" DOUBLE,
  "rbi" DOUBLE,
  "sb" DOUBLE,
  "cs" DOUBLE,
  "bb" DOUBLE,
  "so" DOUBLE,
  "ibb" DOUBLE,
  "hbp" DOUBLE,
  "sh" DOUBLE,
  "sf" DOUBLE,
  "g_idp" DOUBLE
);

Batting Postseason

@kaggle.seanlahman_the_history_of_baseball.batting_postseason

135.15 kB
11,690 rows
22 columns

CREATE TABLE batting_postseason (
  "year" BIGINT,
  "round" VARCHAR,
  "player_id" VARCHAR,
  "team_id" VARCHAR,
  "league_id" VARCHAR,
  "g" BIGINT,
  "ab" BIGINT,
  "r" BIGINT,
  "h" BIGINT,
  "double" BIGINT,
  "triple" BIGINT,
  "hr" BIGINT,
  "rbi" BIGINT,
  "sb" BIGINT,
  "cs" DOUBLE,
  "bb" BIGINT,
  "so" BIGINT,
  "ibb" DOUBLE,
  "hbp" DOUBLE,
  "sh" DOUBLE,
  "sf" DOUBLE,
  "g_idp" DOUBLE
);

College

@kaggle.seanlahman_the_history_of_baseball.college

42.04 kB
1,207 rows
5 columns

CREATE TABLE college (
  "college_id" VARCHAR,
  "name_full" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR
);

Fielding

@kaggle.seanlahman_the_history_of_baseball.fielding

1.99 MB
170,526 rows
18 columns

CREATE TABLE fielding (
  "player_id" VARCHAR,
  "year" BIGINT,
  "stint" BIGINT,
  "team_id" VARCHAR,
  "league_id" VARCHAR,
  "pos" VARCHAR,
  "g" BIGINT,
  "gs" DOUBLE,
  "inn_outs" DOUBLE,
  "po" DOUBLE,
  "a" DOUBLE,
  "e" DOUBLE,
  "dp" DOUBLE,
  "pb" DOUBLE,
  "wp" DOUBLE,
  "sb" DOUBLE,
  "cs" DOUBLE,
  "zr" DOUBLE
);

Fielding Outfield

@kaggle.seanlahman_the_history_of_baseball.fielding_outfield

83.25 kB
12,028 rows
6 columns

CREATE TABLE fielding_outfield (
  "player_id" VARCHAR,
  "year" BIGINT,
  "stint" BIGINT,
  "glf" DOUBLE,
  "gcf" DOUBLE,
  "grf" DOUBLE
);

Fielding Postseason

@kaggle.seanlahman_the_history_of_baseball.fielding_postseason

128.22 kB
12,311 rows
17 columns

CREATE TABLE fielding_postseason (
  "player_id" VARCHAR,
  "year" BIGINT,
  "team_id" VARCHAR,
  "league_id" VARCHAR,
  "round" VARCHAR,
  "pos" VARCHAR,
  "g" BIGINT,
  "gs" DOUBLE,
  "inn_outs" DOUBLE,
  "po" BIGINT,
  "a" BIGINT,
  "e" BIGINT,
  "dp" BIGINT,
  "tp" BIGINT,
  "pb" DOUBLE,
  "sb" DOUBLE,
  "cs" DOUBLE
);

Hall Of Fame

@kaggle.seanlahman_the_history_of_baseball.hall_of_fame

30.25 kB
4,120 rows
9 columns

CREATE TABLE hall_of_fame (
  "player_id" VARCHAR,
  "yearid" BIGINT,
  "votedby" VARCHAR,
  "ballots" DOUBLE,
  "needed" DOUBLE,
  "votes" DOUBLE,
  "inducted" VARCHAR,
  "category" VARCHAR,
  "needed_note" VARCHAR
);

Home Game

@kaggle.seanlahman_the_history_of_baseball.home_game

59.12 kB
2,944 rows
9 columns

CREATE TABLE home_game (
  "year" BIGINT,
  "league_id" VARCHAR,
  "team_id" VARCHAR,
  "park_id" VARCHAR,
  "span_first" TIMESTAMP,
  "span_last" TIMESTAMP,
  "games" BIGINT,
  "openings" BIGINT,
  "attendance" BIGINT
);

Manager

@kaggle.seanlahman_the_history_of_baseball.manager

34.28 kB
3,405 rows
10 columns

CREATE TABLE manager (
  "player_id" VARCHAR,
  "year" BIGINT,
  "team_id" VARCHAR,
  "league_id" VARCHAR,
  "inseason" BIGINT,
  "g" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "rank" DOUBLE,
  "plyr_mgr" VARCHAR
);

Manager Award

@kaggle.seanlahman_the_history_of_baseball.manager_award

5.93 kB
177 rows
6 columns

CREATE TABLE manager_award (
  "player_id" VARCHAR,
  "award_id" VARCHAR,
  "year" BIGINT,
  "league_id" VARCHAR,
  "tie" VARCHAR,
  "notes" VARCHAR
);

Manager Award Vote

@kaggle.seanlahman_the_history_of_baseball.manager_award_vote

8.4 kB
414 rows
7 columns

CREATE TABLE manager_award_vote (
  "award_id" VARCHAR,
  "year" BIGINT,
  "league_id" VARCHAR,
  "player_id" VARCHAR,
  "points_won" BIGINT,
  "points_max" BIGINT,
  "votes_first" BIGINT
);

Manager Half

@kaggle.seanlahman_the_history_of_baseball.manager_half

8.67 kB
93 rows
10 columns

CREATE TABLE manager_half (
  "player_id" VARCHAR,
  "year" BIGINT,
  "team_id" VARCHAR,
  "league_id" VARCHAR,
  "inseason" BIGINT,
  "half" BIGINT,
  "g" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "rank" BIGINT
);

Park

@kaggle.seanlahman_the_history_of_baseball.park

11.51 kB
250 rows
6 columns

CREATE TABLE park (
  "park_id" VARCHAR,
  "park_name" VARCHAR,
  "park_alias" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR
);

Pitching

@kaggle.seanlahman_the_history_of_baseball.pitching

1.12 MB
44,139 rows
30 columns

CREATE TABLE pitching (
  "player_id" VARCHAR,
  "year" BIGINT,
  "stint" BIGINT,
  "team_id" VARCHAR,
  "league_id" VARCHAR,
  "w" BIGINT,
  "l" BIGINT,
  "g" BIGINT,
  "gs" BIGINT,
  "cg" BIGINT,
  "sho" BIGINT,
  "sv" BIGINT,
  "ipouts" DOUBLE,
  "h" BIGINT,
  "er" BIGINT,
  "hr" BIGINT,
  "bb" BIGINT,
  "so" BIGINT,
  "baopp" DOUBLE,
  "era" DOUBLE,
  "ibb" DOUBLE,
  "wp" DOUBLE,
  "hbp" DOUBLE,
  "bk" BIGINT,
  "bfp" DOUBLE,
  "gf" DOUBLE,
  "r" BIGINT,
  "sh" DOUBLE,
  "sf" DOUBLE,
  "g_idp" DOUBLE
);

Pitching Postseason

@kaggle.seanlahman_the_history_of_baseball.pitching_postseason

105.22 kB
5,109 rows
30 columns

CREATE TABLE pitching_postseason (
  "player_id" VARCHAR,
  "year" BIGINT,
  "round" VARCHAR,
  "team_id" VARCHAR,
  "league_id" VARCHAR,
  "w" BIGINT,
  "l" BIGINT,
  "g" BIGINT,
  "gs" BIGINT,
  "cg" BIGINT,
  "sho" BIGINT,
  "sv" BIGINT,
  "ipouts" BIGINT,
  "h" BIGINT,
  "er" BIGINT,
  "hr" BIGINT,
  "bb" BIGINT,
  "so" BIGINT,
  "baopp" VARCHAR,
  "era" DOUBLE,
  "ibb" DOUBLE,
  "wp" DOUBLE,
  "hbp" DOUBLE,
  "bk" DOUBLE,
  "bfp" DOUBLE,
  "gf" BIGINT,
  "r" BIGINT,
  "sh" DOUBLE,
  "sf" DOUBLE,
  "g_idp" DOUBLE
);

Player

@kaggle.seanlahman_the_history_of_baseball.player

1.21 MB
18,846 rows
24 columns

CREATE TABLE player (
  "player_id" VARCHAR,
  "birth_year" DOUBLE,
  "birth_month" DOUBLE,
  "birth_day" DOUBLE,
  "birth_country" VARCHAR,
  "birth_state" VARCHAR,
  "birth_city" VARCHAR,
  "death_year" DOUBLE,
  "death_month" DOUBLE,
  "death_day" DOUBLE,
  "death_country" VARCHAR,
  "death_state" VARCHAR,
  "death_city" VARCHAR,
  "name_first" VARCHAR,
  "name_last" VARCHAR,
  "name_given" VARCHAR,
  "weight" DOUBLE,
  "height" DOUBLE,
  "bats" VARCHAR,
  "throws" VARCHAR,
  "debut" TIMESTAMP,
  "final_game" TIMESTAMP,
  "retro_id" VARCHAR,
  "bbref_id" VARCHAR
);

Player Award

@kaggle.seanlahman_the_history_of_baseball.player_award

27.88 kB
6,078 rows
6 columns

CREATE TABLE player_award (
  "player_id" VARCHAR,
  "award_id" VARCHAR,
  "year" BIGINT,
  "league_id" VARCHAR,
  "tie" VARCHAR,
  "notes" VARCHAR
);

Player Award Vote

@kaggle.seanlahman_the_history_of_baseball.player_award_vote

48.13 kB
6,795 rows
7 columns

CREATE TABLE player_award_vote (
  "award_id" VARCHAR,
  "year" BIGINT,
  "league_id" VARCHAR,
  "player_id" VARCHAR,
  "points_won" DOUBLE,
  "points_max" BIGINT,
  "votes_first" DOUBLE
);

Player College

@kaggle.seanlahman_the_history_of_baseball.player_college

118.71 kB
17,350 rows
3 columns

CREATE TABLE player_college (
  "player_id" VARCHAR,
  "college_id" VARCHAR,
  "year" BIGINT
);

Postseason

@kaggle.seanlahman_the_history_of_baseball.postseason

8.69 kB
307 rows
9 columns

CREATE TABLE postseason (
  "year" BIGINT,
  "round" VARCHAR,
  "team_id_winner" VARCHAR,
  "league_id_winner" VARCHAR,
  "team_id_loser" VARCHAR,
  "league_id_loser" VARCHAR,
  "wins" BIGINT,
  "losses" BIGINT,
  "ties" BIGINT
);

Salary

@kaggle.seanlahman_the_history_of_baseball.salary

139.46 kB
25,575 rows
5 columns

CREATE TABLE salary (
  "year" BIGINT,
  "team_id" VARCHAR,
  "league_id" VARCHAR,
  "player_id" VARCHAR,
  "salary" BIGINT
);

Team

@kaggle.seanlahman_the_history_of_baseball.team

197.72 kB
2,805 rows
48 columns

CREATE TABLE team (
  "year" BIGINT,
  "league_id" VARCHAR,
  "team_id" VARCHAR,
  "franchise_id" VARCHAR,
  "div_id" VARCHAR,
  "rank" BIGINT,
  "g" BIGINT,
  "ghome" DOUBLE,
  "w" BIGINT,
  "l" BIGINT,
  "div_win" VARCHAR,
  "wc_win" VARCHAR,
  "lg_win" VARCHAR,
  "ws_win" VARCHAR,
  "r" BIGINT,
  "ab" BIGINT,
  "h" BIGINT,
  "double" BIGINT,
  "triple" BIGINT,
  "hr" BIGINT,
  "bb" BIGINT,
  "so" DOUBLE,
  "sb" DOUBLE,
  "cs" DOUBLE,
  "hbp" DOUBLE,
  "sf" DOUBLE,
  "ra" BIGINT,
  "er" BIGINT,
  "era" DOUBLE,
  "cg" BIGINT,
  "sho" BIGINT,
  "sv" BIGINT,
  "ipouts" BIGINT,
  "ha" BIGINT,
  "hra" BIGINT,
  "bba" BIGINT,
  "soa" BIGINT,
  "e" BIGINT,
  "dp" DOUBLE,
  "fp" DOUBLE,
  "name" VARCHAR,
  "park" VARCHAR,
  "attendance" DOUBLE,
  "bpf" BIGINT,
  "ppf" BIGINT,
  "team_id_br" VARCHAR,
  "team_id_lahman45" VARCHAR,
  "team_id_retro" VARCHAR
);

Team Franchise

@kaggle.seanlahman_the_history_of_baseball.team_franchise

5.68 kB
120 rows
4 columns

CREATE TABLE team_franchise (
  "franchise_id" VARCHAR,
  "franchise_name" VARCHAR,
  "active" VARCHAR,
  "na_assoc" VARCHAR
);