47,628 rows sorted by playerID

View and edit SQL

Link rowid playerID ▼ yearID stint teamID lgID W L G GS CG SHO SV IPouts H ER HR BB SO BAOpp ERA IBB WP HBP BK BFP GF R SH SF GIDP
35569 aardsda01 2004 1 SFN NL 1 0 11 0 0 0 0 32 20 8 1 10 5 0.41700000000000004 6.75 0 0 2 0 61 5 8 0 1 1
36903 aardsda01 2006 1 CHN NL 3 0 45 0 0 0 0 159 41 24 9 28 49 0.214 4.08 0 1 1 0 225 9 25 1 3 2
37603 aardsda01 2007 1 CHA AL 2 1 25 0 0 0 0 97 39 23 4 17 36 0.3 6.4 3 2 1 0 151 7 24 2 1 1
38321 aardsda01 2008 1 BOS AL 4 2 47 0 0 0 0 146 49 30 4 35 49 0.268 5.55 2 3 5 0 228 7 32 3 2 4
39021 aardsda01 2009 1 SEA AL 3 6 73 0 0 0 38 214 49 20 4 34 80 0.19 2.52 3 2 0 0 296 53 23 2 1 2
39750 aardsda01 2010 1 SEA AL 0 6 53 0 0 0 31 149 33 19 5 25 49 0.198 3.44 5 2 2 0 202 43 19 7 1 5
41141 aardsda01 2012 1 NYA AL 0 0 1 0 0 0 0 3 1 1 1 1 1 0.25 9.0 0 0 0 0 5 1 1 0 0 0
41863 aardsda01 2013 1 NYN NL 2 2 43 0 0 0 0 119 39 19 7 19 36 0.257 4.31 6 1 4 1 178 7 20 2 1 2
43335 aardsda01 2015 1 ATL NL 1 1 33 0 0 0 0 92 25 16 6 14 35 0.223 4.7 3 1 1 0 129 9 17 0 1 4
21763 aasedo01 1977 1 BOS AL 6 2 13 13 4 2 0 277 85 32 6 19 49 0.244 3.12 1 0 1 0 373 0 36 2 3 7
22178 aasedo01 1978 1 CAL AL 11 8 29 29 6 1 0 536 185 80 14 80 93 0.27 4.03 4 3 2 0 773 0 88 5 1 12
22569 aasedo01 1979 1 CAL AL 9 10 37 28 7 1 2 556 200 99 19 77 96 0.27699999999999997 4.81 7 5 1 0 817 4 104 8 8 20
22987 aasedo01 1980 1 CAL AL 8 13 40 21 5 1 2 525 193 79 13 66 74 0.287 4.06 3 2 1 1 761 6 83 12 9 20
23379 aasedo01 1981 1 CAL AL 4 4 39 0 0 0 11 196 56 17 4 24 38 0.23399999999999999 2.34 2 2 0 0 265 32 17 1 1 5
23753 aasedo01 1982 1 CAL AL 3 3 24 0 0 0 4 156 45 20 5 23 40 0.243 3.46 2 2 0 0 212 18 20 4 0 5
24570 aasedo01 1984 1 CAL AL 4 1 23 0 0 0 8 117 30 7 1 19 28 0.221 1.62 5 0 0 0 160 17 7 3 2 5
24985 aasedo01 1985 1 BAL AL 10 6 54 0 0 0 14 264 83 37 6 35 67 0.258 3.78 7 0 1 1 366 43 44 5 3 13
25423 aasedo01 1986 1 BAL AL 6 7 66 0 0 0 34 245 71 27 6 28 67 0.23399999999999999 2.98 2 4 0 0 337 58 29 3 2 7
25876 aasedo01 1987 1 BAL AL 1 0 7 0 0 0 2 24 8 2 1 4 3 0.276 2.25 0 0 0 0 33 6 2 0 0 2
26345 aasedo01 1988 1 BAL AL 0 0 35 0 0 0 0 140 40 21 4 37 28 0.24 4.05 5 1 0 0 209 16 22 3 2 5
26806 aasedo01 1989 1 NYN NL 1 5 49 0 0 0 2 178 56 26 5 26 34 0.245 3.94 3 0 1 1 261 22 27 2 3 3
27295 aasedo01 1990 1 LAN NL 3 1 32 0 0 0 3 114 33 21 5 19 24 0.23199999999999998 4.97 4 3 0 0 163 13 24 2 0 2
39751 abadfe01 2010 1 HOU NL 0 1 22 0 0 0 0 57 14 6 3 5 12 0.2 2.84 0 0 0 0 76 6 6 0 1 0
40434 abadfe01 2011 1 HOU NL 1 4 29 0 0 0 0 59 28 16 5 9 15 0.326 7.32 0 0 1 0 99 1 18 1 2 0
41142 abadfe01 2012 1 HOU NL 0 6 37 6 0 0 0 138 57 26 6 19 38 0.311 5.09 1 4 3 0 208 8 27 2 1 4
41864 abadfe01 2013 1 WAS NL 0 3 39 0 0 0 0 113 42 14 3 10 32 0.271 3.35 0 0 1 0 166 17 14 0 0 0
42589 abadfe01 2014 1 OAK AL 2 4 69 0 0 0 0 172 34 10 4 15 51 0.175 1.57 3 0 4 0 216 17 11 1 2 6
43336 abadfe01 2015 1 OAK AL 2 2 62 0 0 0 0 143 45 22 11 19 45 0.251 4.15 3 4 1 0 205 17 23 3 3 1
44144 abadfe01 2016 1 MIN AL 1 4 39 0 0 0 1 102 27 10 2 14 29 0.22 2.65 2 0 0 1 138 8 11 0 1 6
44145 abadfe01 2016 2 BOS AL 0 2 18 0 0 0 0 38 13 9 2 8 12 0.255 6.39 0 1 1 0 60 7 9 0 0 1
44968 abadfe01 2017 1 BOS AL 2 1 48 0 0 0 1 131 40 16 4 14 37 0.242 3.3 1 0 1 1 182 15 18 0 2 4
46700 abadfe01 2019 1 SFN NL 0 2 21 0 0 0 0 39 9 6 2 3 9 0.196 4.15 0 1 0 0 49 1 6 0 0 3
1701 abbeybe01 1892 1 WAS NL 5 18 27 22 19 0 1 587 207 75 7 76 77   3.45   11 6 0 876 5 139      
1811 abbeybe01 1893 1 CHN NL 2 4 7 7 5 0 0 168 74 34 1 20 6   5.46   2 4 0 264 0 52      
1921 abbeybe01 1894 1 CHN NL 2 7 11 11 10 0 0 276 119 53 3 37 24   5.18   0 3 0 424 0 74      
2051 abbeybe01 1895 1 CHN NL 0 1 1 1 1 0 0 24 10 4 0 2 3   4.5   0 1 0 36 0 8      
2052 abbeybe01 1895 2 BRO NL 5 2 8 6 5 0 0 156 66 25 0 9 14   4.33   2 3 0 229 2 34      
2166 abbeybe01 1896 1 BRO NL 8 8 25 18 12 0 0 493 210 94 7 48 37   5.15   3 9 0 739 7 135      
2167 abbeych01 1896 1 WAS NL 0 0 1 0 0 0 0 6 6 1 0 0 0   4.5   1 0 0 12 1 3      
1346 abbotda01 1890 1 TL2 AA 0 2 3 1 1 0 1 39 19 9 0 8 1   6.23   3 1 0 67 2 14      
20319 abbotgl01 1973 1 OAK AL 1 0 5 3 1 0 0 56 16 8 3 7 6 0.225 3.86 0 0 0 1 79 1 8 0 1 0
20681 abbotgl01 1974 1 OAK AL 5 7 19 17 3 0 0 288 89 32 4 34 38 0.247 3.0 3 3 3 0 401 0 38 2 1 6
21046 abbotgl01 1975 1 OAK AL 5 5 30 15 3 1 0 343 109 54 12 50 51 0.253 4.25 7 2 2 1 495 4 61 7 5 10
21414 abbotgl01 1976 1 OAK AL 2 4 19 10 0 0 0 187 87 38 6 16 27 0.33299999999999996 5.49 0 3 1 0 283 4 41 3 2 0
21764 abbotgl01 1977 1 SEA AL 12 13 36 34 7 0 0 613 212 101 32 56 100 0.27 4.45 2 3 12 0 864 0 111 7 4 17
22179 abbotgl01 1978 1 SEA AL 7 15 29 28 8 1 0 466 191 91 22 44 67 0.303 5.27 5 1 2 0 689 0 99 9 3 11
22570 abbotgl01 1979 1 SEA AL 4 10 23 19 3 0 0 350 138 67 19 38 25 0.301 5.17 2 1 3 0 518 1 78 8 10 14
22988 abbotgl01 1980 1 SEA AL 12 12 31 31 7 2 0 645 228 98 27 49 78 0.272 4.1 4 1 3 1 903 0 110 10 4 24
23380 abbotgl01 1981 1 SEA AL 4 9 22 20 1 0 0 391 127 57 14 28 35 0.258 3.94 1 1 0 0 530 1 64 6 4 13
24155 abbotgl01 1983 1 SEA AL 5 3 14 14 2 0 0 247 103 42 9 15 38 0.311 4.59 2 0 4 2 355 0 46 3 2 8
24156 abbotgl01 1983 2 DET AL 2 1 7 7 1 1 0 140 43 10 5 7 11 0.244 1.93 1 2 0 0 186 0 12 2 1 3
24571 abbotgl01 1984 1 DET AL 3 4 13 8 1 0 0 132 62 29 9 8 8 0.326 5.93 1 1 2 0 205 2 39 3 2 5
26807 abbotji01 1989 1 CAL AL 12 12 29 29 4 2 0 544 190 79 13 74 115 0.27399999999999997 3.92 3 8 4 2 788 0 95 11 5 23
27296 abbotji01 1990 1 CAL AL 10 14 33 33 4 1 0 635 246 106 16 72 105 0.295 4.51 6 4 5 3 925 0 116 9 6 27
27815 abbotji01 1991 1 CAL AL 18 11 34 34 5 1 0 729 222 78 14 73 158 0.244 2.89 6 1 5 4 1002 0 85 7 7 22
28314 abbotji01 1992 1 CAL AL 7 15 29 29 7 0 0 633 208 65 12 68 130 0.263 2.77 3 2 4 0 874 0 73 8 4 22
28788 abbotji01 1993 1 NYA AL 11 14 32 32 4 1 0 642 221 104 22 73 95 0.271 4.37 4 9 3 0 906 0 115 12 4 29
29343 abbotji01 1994 1 NYA AL 9 8 24 24 2 0 0 481 167 81 24 64 90 0.273 4.55 1 8 2 1 692 0 88 9 5 19
29835 abbotji01 1995 1 CHA AL 6 4 17 17 3 0 0 337 116 42 10 35 45 0.26899999999999996 3.36 1 0 1 0 474 0 50 5 1 13
29836 abbotji01 1995 2 CAL AL 5 4 13 13 1 1 0 254 93 39 4 29 41 0.28 4.15 0 1 1 0 368 0 43 3 3 12
30454 abbotji01 1996 1 CAL AL 2 18 27 23 1 0 0 426 171 118 23 78 58 0.306 7.48 3 13 4 1 654 2 128 4 10 17
31640 abbotji01 1998 1 CHA AL 5 0 5 5 0 0 0 95 35 16 2 12 14 0.292 4.55 0 0 1 0 134 0 16 0 1 7
32264 abbotji01 1999 1 MIL NL 2 8 20 15 0 0 0 246 110 63 14 42 37 0.317 6.91 3 7 2 0 394 3 71 2 1 9
27816 abbotky01 1991 1 CAL AL 1 2 5 3 0 0 0 59 22 10 2 13 12 0.301 4.58 0 1 1 1 90 0 11 3 0 3
28315 abbotky01 1992 1 PHI NL 1 14 31 19 0 0 0 400 147 76 20 45 88 0.28300000000000003 5.13 0 9 1 1 577 0 80 6 5 11
29837 abbotky01 1995 1 PHI NL 2 0 18 0 0 0 0 85 28 12 3 16 21 0.267 3.81 0 2 0 1 122 3 12 0 1 4
30455 abbotky01 1996 1 CAL AL 0 1 3 0 0 0 0 12 10 9 1 5 3 0.5 20.25 0 1 0 0 26 1 9 1 0 0
27297 abbotpa01 1990 1 MIN AL 0 5 7 7 0 0 0 104 37 23 0 28 25 0.282 5.97 0 1 1 0 162 0 24 1 1 4
27817 abbotpa01 1991 1 MIN AL 3 1 15 3 0 0 0 142 38 25 5 36 43 0.23199999999999998 4.75 1 5 0 0 210 1 27 7 3 5
28316 abbotpa01 1992 1 MIN AL 0 0 6 0 0 0 0 33 12 4 1 5 13 0.27899999999999997 3.27 0 1 1 0 50 5 4 0 1 0
28789 abbotpa01 1993 1 CLE AL 0 1 5 5 0 0 0 55 19 13 5 11 7 0.26 6.38 1 1 0 0 84 0 15 0 0 1
31641 abbotpa01 1998 1 SEA AL 3 1 4 4 0 0 0 74 24 11 2 10 22 0.255 4.01 0 3 0 0 105 0 11 0 1 3
32265 abbotpa01 1999 1 SEA AL 6 2 25 7 0 0 0 218 50 25 9 32 68 0.193 3.1 3 2 0 0 298 8 31 3 4 3
32905 abbotpa01 2000 1 SEA AL 9 7 35 27 0 0 0 537 164 84 23 80 100 0.243 4.22 4 3 5 0 766 2 89 1 4 20
33582 abbotpa01 2001 1 SEA AL 17 4 28 27 1 0 0 489 145 77 21 87 118 0.23800000000000002 4.25 5 11 7 0 710 0 79 3 5 11
34234 abbotpa01 2002 1 SEA AL 1 3 7 5 0 0 0 79 40 35 5 20 22 0.35100000000000003 11.96 0 2 1 0 137 1 36 1 1 0
34893 abbotpa01 2003 1 KCA AL 1 2 10 8 0 0 0 143 47 28 8 26 32 0.257 5.29 2 2 2 0 214 0 29 2 1 1
35570 abbotpa01 2004 1 TBA AL 2 5 10 9 0 0 0 141 49 35 8 27 25 0.257 6.7 0 3 3 0 222 0 39 0 1 0
35571 abbotpa01 2004 2 PHI NL 1 6 10 10 0 0 0 147 57 34 14 31 21 0.29100000000000004 6.24 1 3 1 0 229 0 37 1 0 3
13341 aberal01 1950 1 CLE AL 1 0 1 1 1 0 0 27 5 2 0 4 4 0.16 2.0   0 0 0 34 0 2      
14097 aberal01 1953 1 CLE AL 1 1 6 0 0 0 0 18 6 5 0 9 4 0.24 7.5   0 0 0 35 2 6      
14098 aberal01 1953 2 DET AL 4 3 17 10 2 0 0 200 63 33 3 41 34 0.26 4.46   4 0 0 290 5 35      
14338 aberal01 1954 1 DET AL 5 11 32 18 4 0 3 374 121 55 8 40 54 0.25 3.97   0 3 0 528 6 63      
14579 aberal01 1955 1 DET AL 6 3 39 1 0 0 3 240 86 30 9 28 37 0.27 3.38 1 1 0 0 346 22 32      
14859 aberal01 1956 1 DET AL 4 4 42 0 0 0 7 189 65 24 1 25 21 0.27 3.43 6 2 2 0 281 28 30      
15129 aberal01 1957 1 DET AL 3 3 28 0 0 0 1 111 46 28 6 11 15 0.31 6.81 3 0 1 0 167 13 33      
15130 aberal01 1957 2 KC1 AL 0 0 3 0 0 0 0 9 6 4 2 2 0 0.4 12.0 0 1 0 0 17 0 4      
13837 abernbi01 1952 1 CLE AL 0 0 1 0 0 0 1 6 4 3 1 1 0 0.44 13.5   0 0 0 10 1 3      
11370 abernte01 1942 1 PHA AL 0 0 1 0 0 0 0 8 2 3 0 3 1 0.22 10.13   1 0 0 12 0 3      
11599 abernte01 1943 1 PHA AL 0 3 5 2 1 0 0 44 24 21 0 13 10 0.35 12.89   0 0 0 82 2 22      
11838 abernte01 1944 1 PHA AL 0 0 1 0 0 0 0 9 5 1 0 1 2 0.41 3.0   0 0 0 13 1 1      
14580 abernte02 1955 1 WS1 AL 5 9 40 14 3 2 0 358 136 79 9 67 79 0.29 5.96 1 2 7 0 553 12 87      
14860 abernte02 1956 1 WS1 AL 1 3 5 4 2 0 0 91 35 14 2 10 18 0.29 4.15 0 0 1 0 132 0 16      
15131 abernte02 1957 1 WS1 AL 2 10 26 16 2 0 0 255 100 64 9 65 50 0.31 6.78 1 1 4 2 398 4 65      
15945 abernte02 1960 1 WS1 AL 0 0 2 0 0 0 0 9 4 4 0 4 1 0.3 12.0 0 0 0 0 17 0 4      
16814 abernte02 1963 1 CLE AL 7 2 43 0 0 0 12 178 54 19 3 29 47 0.25 2.88 6 4 0 0 249 33 25      
17133 abernte02 1964 1 CLE AL 2 6 53 0 0 0 11 218 66 35 5 46 57 0.24 4.33 5 1 2 0 321 27 40      
17470 abernte02 1965 1 CHN NL 4 6 84 0 0 0 31 409 113 39 7 56 104 0.22 2.57 13 6 5 0 572 62 49      
17790 abernte02 1966 1 CHN NL 1 3 20 0 0 0 4 83 26 19 4 17 18 0.25 6.18 1 2 2 0 124 11 19      
17791 abernte02 1966 2 ATL NL 4 4 38 0 0 0 4 196 58 28 5 36 42 0.24 3.86 10 7 0 0 281 25 34      

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Pitching" (
"playerID" TEXT,
  "yearID" INTEGER,
  "stint" INTEGER,
  "teamID" TEXT,
  "lgID" REAL,
  "W" INTEGER,
  "L" INTEGER,
  "G" INTEGER,
  "GS" INTEGER,
  "CG" INTEGER,
  "SHO" INTEGER,
  "SV" INTEGER,
  "IPouts" INTEGER,
  "H" INTEGER,
  "ER" INTEGER,
  "HR" INTEGER,
  "BB" INTEGER,
  "SO" INTEGER,
  "BAOpp" REAL,
  "ERA" REAL,
  "IBB" INTEGER,
  "WP" INTEGER,
  "HBP" INTEGER,
  "BK" INTEGER,
  "BFP" INTEGER,
  "GF" INTEGER,
  "R" INTEGER,
  "SH" INTEGER,
  "SF" INTEGER,
  "GIDP" INTEGER
);