47,628 rows sorted by playerID descending

View and edit SQL

stint

  • 1 43,937
  • 2 3,509
  • 3 174
  • 4 7
  • 5 1
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
44143 zychto01 2015 1 SEA AL 0 0 13 1 0 0 0 55 17 5 1 3 24 0.239 2.45 0 1 2 0 76 4 6 0 0 0
44967 zychto01 2016 1 SEA AL 1 0 12 0 0 0 0 41 10 5 0 10 21 0.20800000000000002 3.29 2 0 1 0 60 3 6 0 1 1
45806 zychto01 2017 1 SEA AL 6 3 45 0 0 0 1 122 30 12 2 21 35 0.20800000000000002 2.66 3 1 5 1 173 7 12 1 2 5
13836 zuverge01 1951 1 CLE AL 0 0 16 0 0 0 0 76 24 15 2 13 14 0.25 5.33   1 1 0 114 7 17      
14096 zuverge01 1952 1 CLE AL 0 0 1 0 0 0 0 4 1 0 0 0 1 0.2 0.0   0 0 0 5 1 0      
14577 zuverge01 1954 1 CIN NL 0 0 2 0 0 0 0 18 10 6 1 1 2 0.38 9.0   1 0 0 28 1 6      
14578 zuverge01 1954 2 DET AL 9 13 35 25 9 2 4 609 201 81 22 62 70 0.25 3.59   1 8 0 869 7 93      
14857 zuverge01 1955 1 DET AL 0 5 14 1 0 0 0 85 38 22 6 14 13 0.3 6.99 3 0 1 0 141 6 27      
14858 zuverge01 1955 2 BAL AL 4 3 28 5 0 0 4 259 80 21 5 17 31 0.26 2.19 1 2 4 0 333 16 28      
15128 zuverge01 1956 1 BAL AL 7 6 62 0 0 0 16 292 112 45 6 34 33 0.29 4.16 9 1 3 1 432 40 52      
15396 zuverge01 1957 1 BAL AL 10 6 56 0 0 0 9 338 105 31 9 39 36 0.25 2.48 13 1 4 0 475 37 37      
15677 zuverge01 1958 1 BAL AL 2 2 45 0 0 0 7 207 74 26 4 17 22 0.28 3.39 3 2 6 0 294 23 29      
15944 zuverge01 1959 1 BAL AL 0 1 6 0 0 0 0 39 15 6 1 6 1 0.3 4.15 0 1 0 0 55 1 7      
37602 zumayjo01 2006 1 DET AL 6 3 62 0 0 0 1 250 56 18 6 42 97 0.187 1.94 2 4 2 0 350 12 20 2 4 1
38320 zumayjo01 2007 1 DET AL 2 3 28 0 0 0 1 101 23 16 3 17 27 0.18899999999999997 4.28 2 3 1 0 142 7 16 1 1 2
39020 zumayjo01 2008 1 DET AL 0 2 21 0 0 0 1 70 24 9 3 22 22 0.264 3.47 4 6 0 0 114 5 13 0 1 1
39749 zumayjo01 2009 1 DET AL 3 3 29 0 0 0 1 93 34 17 5 22 30 0.27399999999999997 4.94 3 1 1 0 149 5 18 1 1 2
40433 zumayjo01 2010 1 DET AL 2 1 31 0 0 0 1 115 32 11 1 11 34 0.22899999999999998 2.58 0 2 0 0 156 6 13 2 3 4
10190 zuberbi01 1936 1 CLE AL 1 1 2 2 1 0 0 41 14 10 0 15 5 0.26 6.59   0 0 0 67 0 11      
10641 zuberbi01 1938 1 CLE AL 0 3 15 0 0 0 1 86 33 16 0 20 14 0.29 5.02   1 0 0 134 6 18      
10891 zuberbi01 1939 1 CLE AL 2 0 16 1 0 0 0 95 41 21 2 19 16 0.32 5.97   0 1 0 152 10 24      
11123 zuberbi01 1940 1 CLE AL 1 1 17 0 0 0 0 72 25 15 3 14 12 0.26 5.63   0 0 0 112 9 17      
11369 zuberbi01 1941 1 WS1 AL 6 4 36 7 1 0 2 289 110 58 5 61 51 0.29 5.42   5 2 0 446 19 63      
11598 zuberbi01 1942 1 WS1 AL 9 9 37 7 3 1 1 380 115 54 5 82 64 0.24 3.84   5 0 1 568 19 66      
11837 zuberbi01 1943 1 NYA AL 8 4 20 13 7 0 1 354 100 51 3 74 57 0.23 3.89   2 0 0 512 2 54      
12071 zuberbi01 1944 1 NYA AL 5 7 22 13 2 1 0 321 101 50 5 54 59 0.25 4.21   3 1 0 458 5 54      
12321 zuberbi01 1945 1 NYA AL 5 11 21 14 7 0 1 381 121 45 2 56 50 0.25 3.19   5 0 0 529 5 50      
12613 zuberbi01 1946 1 NYA AL 0 1 3 0 0 0 0 17 10 8 2 3 3 0.38 12.71   1 0 0 29 1 9      
12614 zuberbi01 1946 2 BOS AL 5 1 15 7 2 1 0 170 37 16 4 39 29 0.18 2.54   2 0 0 239 6 20      
12864 zuberbi01 1947 1 BOS AL 1 0 20 1 0 0 0 152 60 30 4 31 23 0.31 5.33   4 0 0 230 8 32      
12070 zoldasa01 1944 1 SLA AL 0 0 18 0 0 0 0 116 49 16 1 19 15 0.31 3.72   2 0 0 181 10 22      
12320 zoldasa01 1945 1 SLA AL 3 2 26 1 1 0 0 209 74 26 3 18 19 0.26 3.36   1 0 1 297 14 32      
12612 zoldasa01 1946 1 SLA AL 9 11 35 21 9 2 2 511 166 65 11 57 51 0.25 3.43   2 1 0 718 7 71      
12863 zoldasa01 1947 1 SLA AL 9 10 35 19 6 1 1 513 162 66 7 76 36 0.25 3.47   1 0 1 725 8 76      
13113 zoldasa01 1948 1 SLA AL 2 4 11 9 0 0 0 162 64 28 4 19 13 0.29 4.67   1 1 0 238 0 30      
13114 zoldasa01 1948 2 CLE AL 9 6 23 12 4 1 0 317 104 33 6 24 17 0.26 2.81   0 0 1 428 5 37      
13340 zoldasa01 1949 1 CLE AL 1 2 27 0 0 0 0 159 60 25 4 18 11 0.29 4.25   1 0 0 235 13 30      
13589 zoldasa01 1950 1 CLE AL 4 2 33 3 0 0 4 191 64 28 6 21 15 0.25 3.96   0 1 0 274 14 33      
13835 zoldasa01 1951 1 PHA AL 6 10 26 18 8 1 0 384 127 45 9 24 18 0.25 3.16   0 0 1 525 5 51      
14095 zoldasa01 1952 1 PHA AL 0 6 16 10 2 0 1 226 86 34 3 25 12 0.29 4.06   0 0 0 325 2 41      
47628 zobribe01 2019 1 CHN NL 0 0 1 0 0 0 0 3 0 0 0 2 1 0.0 0.0 0 0 0 0 5 1 0 0 0 0
4428 zmiched01 1910 1 SLN NL 0 5 9 6 2 0 0 108 38 25 0 29 19   6.25   4 3 1 157 3 27      
4655 zmiched01 1911 1 SLN NL 1 0 4 0 0 0 0 38 8 3 0 8 4 0.18 2.13   1 1 0 53 4 5      
33581 zitoba01 2000 1 OAK AL 7 4 14 14 1 1 0 278 64 28 6 45 78 0.195 2.72 2 2 2 0 376 0 30 1 0 9
34233 zitoba01 2001 1 OAK AL 17 8 35 35 3 2 0 643 184 83 18 80 205 0.23 3.49 0 6 13 1 902 0 92 5 4 10
34892 zitoba01 2002 1 OAK AL 23 5 35 35 1 0 0 688 182 70 24 78 182 0.218 2.75 2 2 9 1 939 0 79 9 7 16
35568 zitoba01 2003 1 OAK AL 14 12 35 35 4 1 0 695 186 85 19 88 146 0.21899999999999997 3.3 3 4 6 0 957 0 98 7 7 18
36248 zitoba01 2004 1 OAK AL 11 11 34 34 0 0 0 639 216 106 28 81 163 0.263 4.48 2 4 9 1 926 0 116 7 9 12
36902 zitoba01 2005 1 OAK AL 14 13 35 35 0 0 0 685 185 98 26 89 171 0.221 3.86 0 4 13 0 953 0 106 8 7 20
37601 zitoba01 2006 1 OAK AL 16 10 34 34 0 0 0 663 211 94 27 99 151 0.257 3.83 5 4 13 2 945 0 99 7 6 31
38319 zitoba01 2007 1 SFN NL 11 13 34 33 0 0 0 590 182 99 24 83 131 0.244 4.53 4 5 4 0 850 0 105 12 4 15
39019 zitoba01 2008 1 SFN NL 10 17 32 32 0 0 0 540 186 103 16 102 120 0.27 5.15 10 3 4 0 818 0 115 8 14 12
39748 zitoba01 2009 1 SFN NL 10 13 33 33 1 0 0 576 179 86 21 81 154 0.25 4.03 8 2 8 2 818 0 89 11 1 19
40432 zitoba01 2010 1 SFN NL 9 14 34 33 1 0 0 598 184 92 20 84 150 0.25 4.15 7 7 7 0 848 1 97 13 7 17
41140 zitoba01 2011 1 SFN NL 3 4 13 9 0 0 0 161 51 35 10 24 32 0.256 5.87 1 1 0 0 225 3 35 0 2 7
41862 zitoba01 2012 1 SFN NL 15 8 32 32 1 1 0 553 186 85 20 70 114 0.263 4.15 6 1 5 0 799 0 91 12 4 16
42588 zitoba01 2013 1 SFN NL 5 11 30 25 0 0 0 400 173 85 19 54 86 0.318 5.74 2 5 4 1 608 4 94 5 1 15
44142 zitoba01 2015 1 OAK AL 0 0 3 2 0 0 0 21 12 8 4 6 2 0.387 10.29 0 0 0 0 37 1 8 0 0 2
12069 zinsebi01 1944 1 WS1 AL 0 0 2 0 0 0 0 2 1 2 0 5 1 0.33 27.0   0 0 0 8 0 2      
6552 zinnji01 1919 1 PHA AL 1 3 5 3 2 0 0 77 38 18 1 10 9 0.36 6.31   2 1 0 115 2 20      
6766 zinnji01 1920 1 PIT NL 1 1 6 3 2 0 0 93 32 12 2 5 18 0.26 3.48   1 1 0 130 3 14      
6977 zinnji01 1921 1 PIT NL 7 6 32 9 5 1 4 382 159 52 3 30 49 0.31 3.68   2 2 0 559 16 63      
7189 zinnji01 1922 1 PIT NL 0 0 5 0 0 0 1 29 11 2 1 2 3 0.29 1.86   0 0 0 40 2 4      
8714 zinnji01 1929 1 CLE AL 4 6 18 11 6 1 2 316 150 59 8 33 29 0.34 5.04   0 3 0 488 7 75      
6976 zinkwa01 1921 1 NY1 NL 0 0 2 0 0 0 0 12 4 1 0 3 1 0.23 2.25   1 0 0 21 1 3      
39018 zinkch01 2008 1 BOS AL 0 0 1 1 0 0 0 13 11 8 0 1 1 0.45799999999999996 16.62 0 1 0 0 25 0 8 0 0 0
47627 zimmeky01 2019 1 KCA AL 0 1 15 0 0 0 0 55 28 22 2 19 18 0.337 10.8 0 2 0 0 102 3 22 0 0 1
39747 zimmejo02 2009 1 WAS NL 3 5 16 16 0 0 0 274 95 47 10 29 92 0.271 4.63 0 0 4 0 391 0 51 5 3 6
40431 zimmejo02 2010 1 WAS NL 1 2 7 7 0 0 0 93 31 17 8 10 27 0.256 4.94 1 0 2 0 135 0 20 1 1 1
41139 zimmejo02 2011 1 WAS NL 8 11 26 26 1 0 0 484 154 57 12 31 124 0.251 3.18 2 3 7 1 662 0 62 8 2 6
41861 zimmejo02 2012 1 WAS NL 12 8 32 32 0 0 0 587 186 64 18 43 153 0.251 2.94 2 3 8 0 805 0 69 8 4 18
42587 zimmejo02 2013 1 WAS NL 19 9 32 32 4 2 0 640 192 77 19 40 161 0.239 3.25 0 3 7 0 865 0 81 9 4 18
43334 zimmejo02 2014 1 WAS NL 14 5 32 32 3 2 0 599 185 59 13 29 182 0.244 2.66 0 4 6 0 800 0 67 5 3 11
44141 zimmejo02 2015 1 WAS NL 13 10 33 33 0 0 0 605 204 82 24 39 164 0.264 3.66 3 2 8 1 831 0 89 8 2 15
44966 zimmejo02 2016 1 DET AL 9 7 19 18 0 0 0 316 118 57 14 26 66 0.284 4.87 0 3 2 0 450 1 63 1 5 8
45805 zimmejo02 2017 1 DET AL 8 13 29 29 0 0 0 480 204 108 29 44 103 0.313 6.08 2 3 7 0 713 0 111 3 8 19
46699 zimmejo02 2018 1 DET AL 7 8 25 25 0 0 0 394 140 66 28 26 111 0.26899999999999996 4.52 0 1 2 0 556 0 76 2 5 4
47626 zimmejo02 2019 1 DET AL 1 13 23 23 0 0 0 336 145 86 19 25 82 0.311 6.91 2 3 6 0 504 0 89 3 4 5
32904 zimmejo01 1999 1 SEA AL 0 0 12 0 0 0 0 24 14 7 0 4 3 0.389 7.88 0 1 1 0 41 2 8 0 0 3
32903 zimmeje02 1999 1 TEX AL 9 3 65 0 0 0 3 263 50 23 9 23 67 0.166 2.36 1 2 2 0 336 14 24 3 6 5
33580 zimmeje02 2000 1 TEX AL 4 5 65 0 0 0 1 209 80 41 10 34 74 0.28600000000000003 5.3 3 3 2 3 323 17 45 2 5 3
34232 zimmeje02 2001 1 TEX AL 4 4 66 0 0 0 28 214 48 19 10 16 72 0.192 2.4 1 0 4 0 273 53 19 2 1 3
26344 ziemst01 1987 1 ATL NL 0 1 2 0 0 0 0 7 4 2 0 1 0 0.364 7.71 0 0 0 1 12 1 3 0 0 0
1556 zieglge01 1890 1 PIT NL 0 1 1 1 0 0 0 18 12 7 0 0 1   10.5   2 0 0 30 0 7      
39017 zieglbr01 2008 1 OAK AL 3 0 47 0 0 0 11 179 47 7 2 22 30 0.23600000000000002 1.06 3 0 1 0 229 21 8 4 3 20
39746 zieglbr01 2009 1 OAK AL 2 4 69 0 0 0 7 220 82 25 2 28 54 0.293 3.07 4 0 1 0 313 23 27 1 3 14
40430 zieglbr01 2010 1 OAK AL 3 7 64 0 0 0 0 182 54 22 4 28 41 0.24100000000000002 3.26 9 0 3 1 257 12 24 1 1 8
41137 zieglbr01 2011 1 OAK AL 3 2 43 0 0 0 1 113 38 10 0 13 29 0.264 2.39 3 1 1 0 160 12 14 1 1 7
41138 zieglbr01 2011 2 ARI NL 0 0 23 0 0 0 0 62 15 4 0 6 15 0.20800000000000002 1.74 0 0 0 0 79 4 7 0 1 3
41860 zieglbr01 2012 1 ARI NL 6 1 77 0 0 0 0 206 54 19 2 21 42 0.228 2.49 2 1 1 0 263 15 21 2 2 21
42586 zieglbr01 2013 1 ARI NL 8 1 78 0 0 0 13 219 61 18 3 22 44 0.228 2.22 6 0 3 0 297 33 20 2 2 8
43333 zieglbr01 2014 1 ARI NL 5 3 68 0 0 0 1 201 60 26 5 24 54 0.243 3.49 6 0 3 0 281 11 29 2 4 9
44140 zieglbr01 2015 1 ARI NL 0 3 66 0 0 0 30 204 48 14 3 17 36 0.198 1.85 3 2 1 0 263 46 17 1 0 8
44964 zieglbr01 2016 1 ARI NL 2 3 36 0 0 0 18 115 41 12 1 15 27 0.281 2.82 5 0 2 0 165 30 13 1 1 10
44965 zieglbr01 2016 2 BOS AL 2 4 33 0 0 0 4 89 26 5 1 11 31 0.23399999999999999 1.52 2 1 1 0 124 12 8 1 0 6
45804 zieglbr01 2017 1 MIA NL 1 4 53 0 0 0 10 141 57 25 1 16 26 0.306 4.79 6 1 6 0 211 21 29 3 0 10
46697 zieglbr01 2018 1 MIA NL 1 5 53 0 0 0 10 156 49 23 7 17 37 0.254 3.98 4 1 2 0 213 23 25 0 1 11
46698 zieglbr01 2018 2 ARI NL 1 1 29 0 0 0 0 65 22 9 1 8 13 0.265 3.74 2 0 0 0 92 1 9 0 1 3
14576 zickbo01 1954 1 CHN NL 0 0 8 0 0 0 0 49 23 15 1 7 9 0.34 8.27   0 0 0 75 5 15      
47625 zeuchtj01 2019 1 TOR AL 1 2 5 3 0 0 0 68 22 12 2 11 20 0.25 4.76 0 2 0 0 99 0 13 0 0 1

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