The History Of Baseball
A complete history of major league baseball stats from 1871 to 2015
@kaggle.seanlahman_the_history_of_baseball
Table List
- 26 tables(8.18 MB)
- All Star
- Appearances
- Batting
- Batting Postseason
- College
- Fielding
- Fielding Outfield
- Fielding Postseason
- Hall Of Fame
- Home Game
- Manager
- Manager Award
- Manager Award Vote
- Manager Half
- Park
- Pitching
- Pitching Postseason
- Player
- Player Award
- Player Award Vote
- Player College
- Postseason
- Salary
- Team
- Team Franchise
- Team Half
Pitching Postseason
@kaggle.seanlahman_the_history_of_baseball.pitching_postseason
- 102.75 KB
- 5109 rows
- 30 columns
player_idPlayer Id | yearYear | roundRound | team_idTeam Id | league_idLeague Id | wW | lL | gG | gsGs | cgCg | shoSho | svSv | ipoutsIpouts | hH | erEr | hrHr | bbBb | soSo | baoppBaopp | eraEra | ibbIbb | wpWp | hbpHbp | bkBk | bfpBfp | gfGf | rR | shSh | sfSf | g_idpG Idp |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| becanbu01 | 1884 | WS | NY4 | AA | 1 | 1 | 1 | 1 | 18 | 9 | 7 | 2 | 1 | nan | 10.5 | 12 | |||||||||||||
| keefeti01 | 1884 | WS | NY4 | AA | 2 | 2 | 2 | 2 | 45 | 10 | 6 | 1 | 3 | 12 | nan | 3.6 | 9 | ||||||||||||
| radboch01 | 1884 | WS | PRO | NL | 3 | 3 | 3 | 3 | 1 | 66 | 11 | 17 | nan | 3 | |||||||||||||||
| clarkjo01 | 1885 | WS | CHN | NL | 1 | 2 | 2 | 2 | 48 | 15 | 2 | 1 | 15 | nan | 1.13 | 14 | |||||||||||||
| mccorji01 | 1885 | WS | CHN | NL | 3 | 2 | 5 | 5 | 5 | 108 | 27 | 8 | 6 | 19 | nan | 2 | 22 | ||||||||||||
| carutbo01 | 1885 | WS | SL4 | AA | 1 | 1 | 3 | 3 | 3 | 78 | 25 | 7 | 1 | 4 | 16 | nan | 2.42 | 18 | |||||||||||
| foutzda01 | 1885 | WS | SL4 | AA | 2 | 2 | 4 | 4 | 4 | 87 | 30 | 2 | 1 | 9 | 14 | nan | 0.62 | 20 | |||||||||||
| clarkjo01 | 1886 | WS | CHN | NL | 2 | 2 | 4 | 4 | 3 | 1 | 93 | 25 | 7 | 12 | 28 | nan | 2.03 | 15 | |||||||||||
| mccorji01 | 1886 | WS | CHN | NL | 1 | 1 | 1 | 1 | 24 | 13 | 6 | 1 | 2 | 4 | nan | 6.75 | 12 | ||||||||||||
| ryanji01 | 1886 | WS | CHN | NL | 1 | 1 | 15 | 8 | 5 | 4 | 4 | nan | 9 | 1 | 8 |
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
);