47,628 rows sorted by rowid descending

View and edit SQL

stint

  • 1 43,845
  • 2 3,501
  • 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
47528 tatedi01 2019 1 BAL AL 0 2 16 0 0 0 0 63 18 15 3 9 20 0.231 6.43 0 2 5 0 93 5 15 0 1 2
47527 tarplst01 2019 1 NYA AL 1 0 21 1 0 0 2 74 34 19 6 15 34 0.33 6.93 1 5 2 1 120 3 20 0 0 1
47526 tanakma01 2019 1 NYA AL 11 9 32 31 1 1 0 546 186 90 28 40 149 0.261 4.45 0 7 2 0 759 0 95 0 4 15
47525 taillja01 2019 1 PIT NL 2 3 7 7 1 0 0 112 34 17 4 8 30 0.231 4.1 1 1 2 0 158 0 24 0 1 2
47524 syndeno01 2019 1 NYN NL 10 8 32 32 1 1 0 593 194 94 24 50 202 0.256 4.28 2 4 6 0 825 0 101 3 8 14
47523 swarzan01 2019 2 ATL NL 1 2 44 0 0 0 1 119 38 19 6 19 35 0.252 4.31 2 1 0 0 170 1 19 0 0 5
47522 swarzan01 2019 1 SEA AL 2 2 15 0 0 0 3 41 14 8 6 8 17 0.25 5.27 1 1 0 0 64 7 11 0 0 0
47521 swanser01 2019 1 SEA AL 1 5 27 8 0 0 2 174 56 37 17 12 52 0.243 5.74 1 2 2 0 245 7 41 0 1 3
47520 suterbr01 2019 1 MIL NL 4 0 9 0 0 0 0 55 10 1 1 1 15 0.156 0.49 0 0 0 0 65 0 1 0 0 1
47519 sulseco01 2019 1 TBA AL 0 0 7 0 0 0 0 22 5 0 0 3 9 0.192 0.0 0 0 0 0 29 4 0 0 0 0
47518 suerowa01 2019 1 WAS NL 6 9 78 0 0 0 1 214 64 36 5 26 81 0.242 4.54 3 2 3 1 296 10 36 0 3 5
47517 sucreje01 2019 1 BAL AL 0 0 1 0 0 0 0 3 0 0 0 0 0 0.0 0.0 0 0 0 0 3 1 0 0 0 0
47516 suarera01 2019 1 PHI NL 6 1 37 0 0 0 0 146 52 17 6 12 42 0.278 3.14 2 1 1 1 205 8 18 3 2 6
47515 suarejo01 2019 1 LAA AL 2 6 19 15 0 0 0 243 100 64 23 33 72 0.304 7.11 1 5 10 1 375 0 67 1 2 8
47514 suarean01 2019 1 SFN NL 0 2 21 2 0 0 0 98 39 21 7 14 25 0.302 5.79 2 2 1 0 148 4 23 0 4 4
47513 stumpda01 2019 1 DET AL 1 1 48 0 0 0 0 87 35 14 5 15 28 0.302 4.34 1 0 0 0 135 5 18 1 3 1
47512 stroppe01 2019 1 CHN NL 2 5 50 0 0 0 10 125 33 23 6 20 49 0.217 4.97 1 4 5 0 178 27 24 0 1 4
47511 stromma01 2019 2 NYN NL 4 2 11 11 0 0 0 179 65 25 8 23 60 0.27699999999999997 3.77 1 3 1 0 261 0 27 1 1 5
47510 stromma01 2019 1 TOR AL 6 11 21 21 0 0 0 374 118 41 10 35 99 0.248 2.96 0 4 0 0 513 0 50 0 1 12
47509 stripro01 2019 1 LAN NL 4 4 32 15 0 0 0 272 84 35 11 20 93 0.244 3.47 0 4 2 0 370 4 40 0 4 5
47508 strichu01 2019 2 WAS NL 2 0 24 0 0 0 0 63 20 12 5 8 15 0.247 5.14 0 1 2 0 92 1 12 0 1 2
47507 strichu01 2019 1 SEA AL 0 1 4 0 0 0 2 10 2 3 1 0 3 0.16699999999999998 8.1 0 0 1 0 13 2 3 0 0 0
47506 stratch01 2019 2 PIT NL 1 1 28 0 0 0 0 140 50 19 7 15 47 0.27 3.66 1 1 0 0 200 7 22 0 0 4
47505 stratch01 2019 1 LAA AL 0 2 7 5 0 0 0 88 43 28 6 18 22 0.344 8.59 0 1 0 0 144 0 28 0 1 3
47504 strasst01 2019 1 WAS NL 18 6 33 33 0 0 0 627 161 77 24 56 251 0.21 3.32 4 8 10 0 841 0 79 3 4 14
47503 straida01 2019 1 BAL AL 2 4 14 8 0 0 0 143 73 52 22 22 33 0.349 9.82 0 3 2 0 236 2 53 0 3 3
47502 strahma01 2019 1 SDN NL 6 11 46 16 0 0 0 344 121 60 22 22 118 0.267 4.71 4 3 7 1 487 4 61 4 1 7
47501 stockro01 2019 1 SDN NL 1 0 10 0 0 0 0 32 14 12 2 8 15 0.298 10.13 0 4 1 0 56 4 14 0 0 0
47500 stjohlo01 2019 1 TEX AL 0 0 7 0 0 0 0 20 7 4 0 4 5 0.24100000000000002 5.4 0 0 0 0 33 4 4 0 0 0
47499 stewako01 2019 1 MIN AL 2 2 9 2 0 0 0 76 29 18 5 8 10 0.29 6.39 0 6 1 0 109 5 18 0 0 5
47498 stewabr01 2019 2 TOR AL 4 0 10 0 0 0 0 65 28 20 9 6 16 0.304 8.31 0 1 3 0 103 0 21 0 2 1
47497 stewabr01 2019 1 LAN NL 0 0 3 0 0 0 0 12 9 8 2 2 3 0.529 18.0 0 1 0 0 21 1 8 0 2 1
47496 stephro01 2019 1 CIN NL 3 2 57 0 0 0 0 194 43 27 9 24 81 0.182 3.76 4 3 0 0 262 16 30 0 1 2
47495 steckdr01 2019 1 MIA NL 0 2 15 0 0 0 0 43 9 10 6 5 14 0.17300000000000001 6.28 0 0 1 0 58 4 10 0 0 0
47494 staumjo01 2019 1 KCA AL 0 0 16 0 0 0 0 58 21 8 4 10 15 0.273 3.72 1 0 1 0 88 7 13 0 0 1
47493 stassma01 2019 1 HOU AL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
47492 stashco01 2019 1 MIN AL 0 1 18 1 0 0 0 75 29 9 3 1 25 0.287 3.24 0 0 1 0 104 4 9 0 1 2
47491 stanery01 2019 2 MIA NL 0 2 22 0 0 0 1 64 17 13 4 19 28 0.215 5.48 2 3 0 0 99 9 15 0 1 0
47490 stanery01 2019 1 TBA AL 0 2 41 27 0 0 0 167 44 21 7 20 61 0.214 3.4 1 2 0 0 228 3 24 0 2 2
47489 stammcr01 2019 1 SDN NL 8 7 76 0 0 0 4 246 80 30 13 15 73 0.251 3.29 2 0 2 0 339 12 36 0 3 5
47488 stallja01 2019 1 PIT NL 0 0 1 0 0 0 0 3 0 0 0 0 0 0.0 0.0 0 0 0 0 3 1 0 0 0 0
47487 sprinje01 2019 1 TEX AL 4 1 25 0 0 0 0 97 38 23 4 23 32 0.295 6.4 0 0 0 0 155 7 23 0 2 3
47486 speiega01 2019 1 KCA AL 0 0 9 0 0 0 0 22 5 6 2 6 10 0.185 7.36 0 1 0 0 33 1 6 0 0 0
47485 sparkgl01 2019 1 KCA AL 4 11 31 23 1 1 0 408 164 91 30 41 81 0.29600000000000004 6.02 1 6 6 2 606 2 96 1 4 8
47484 sotogr01 2019 1 DET AL 0 5 33 7 0 0 0 173 74 37 9 33 45 0.308 5.77 1 5 0 0 276 9 39 0 3 7
47483 sorokmi01 2019 1 ATL NL 13 4 29 29 0 0 0 524 153 52 14 41 142 0.23600000000000002 2.68 1 3 7 0 701 0 56 3 2 23
47482 soriajo01 2019 1 OAK AL 2 4 71 1 0 0 1 207 51 33 9 20 79 0.20199999999999999 4.3 1 5 3 1 278 21 33 1 2 5
47481 sobotch01 2019 1 ATL NL 0 0 32 0 0 0 0 87 28 20 6 19 38 0.25 6.21 0 3 3 1 134 5 22 0 0 6
47480 snellbl01 2019 1 TBA AL 6 8 23 23 0 0 0 321 96 51 14 40 147 0.24100000000000002 4.29 1 11 1 1 441 0 53 0 1 4
47479 sneedcy01 2019 1 HOU AL 0 1 8 0 0 0 0 64 26 13 5 5 23 0.299 5.48 0 0 0 0 93 4 13 1 0 1
47478 smylydr01 2019 2 PHI NL 3 2 12 12 0 0 0 188 62 31 13 21 68 0.259 4.45 0 2 1 0 263 0 34 2 0 4
47477 smylydr01 2019 1 TEX AL 1 5 13 9 0 0 1 154 64 48 19 34 52 0.299 8.42 0 5 1 0 251 1 49 0 2 1
47476 smithwi04 2019 1 SFN NL 6 0 63 0 0 0 34 196 46 20 10 21 96 0.196 2.76 2 3 0 0 257 52 20 0 1 7
47475 smithjo08 2019 2 MIA NL 0 0 6 0 0 0 0 13 3 4 0 3 2 0.188 8.31 1 0 1 0 21 3 4 0 1 0
47474 smithjo08 2019 1 CLE AL 0 0 8 0 0 0 0 25 8 5 0 8 12 0.242 5.4 1 0 2 0 43 3 5 0 0 0
47473 smithjo07 2019 1 BOS AL 0 3 18 2 0 0 1 93 36 20 10 8 29 0.281 5.81 1 0 3 0 139 13 22 0 0 0
47472 smithjo05 2019 1 HOU AL 1 0 28 0 0 0 0 75 19 5 2 5 22 0.209 1.8 0 0 0 0 96 4 6 0 0 3
47471 smithca03 2019 1 MIA NL 10 11 28 28 0 0 0 460 128 77 33 60 168 0.223 4.52 2 6 6 1 646 0 82 2 5 5
47470 smithbu03 2019 2 SFN NL 0 0 10 0 0 0 0 26 10 2 0 4 6 0.278 2.08 0 0 0 0 41 2 3 1 0 1
47469 smithbu03 2019 1 MIL NL 0 1 7 0 0 0 0 38 16 11 3 10 14 0.29600000000000004 7.82 2 1 1 0 65 4 11 0 0 0
47468 smeltde01 2019 1 MIN AL 2 2 11 6 0 0 1 147 50 21 8 12 38 0.265 3.86 0 1 1 1 202 2 23 0 0 4
47467 slegeaa01 2019 1 TBA AL 0 0 1 0 0 0 1 9 3 1 1 0 0 0.273 3.0 0 0 1 0 12 1 1 0 0 1
47466 skogler01 2019 1 KCA AL 0 3 6 4 0 0 0 63 30 21 5 9 4 0.337 9.0 0 0 1 0 101 0 21 0 2 2
47465 skaggty01 2019 1 LAA AL 7 7 15 15 0 0 0 239 73 38 9 28 78 0.242 4.29 0 2 2 2 335 0 41 1 2 6
47464 sippto01 2019 1 WAS NL 1 2 36 0 0 0 0 63 19 11 1 9 18 0.24100000000000002 4.71 0 1 1 0 92 7 12 0 3 0
47463 simslu01 2019 1 CIN NL 2 1 24 4 0 0 0 129 31 22 8 19 57 0.201 4.6 0 1 2 0 177 2 22 1 1 1
47462 shuckja01 2019 1 PIT NL 0 0 1 0 0 0 0 3 1 0 0 1 0 0.25 0.0 0 0 0 0 5 1 0 0 0 0
47461 shrevch01 2019 1 SLN NL 1 0 3 0 0 0 0 6 2 2 0 1 2 0.25 9.0 0 0 1 0 10 0 2 0 0 0
47460 shoemma01 2019 1 TOR AL 3 0 5 5 0 0 0 86 16 5 3 9 24 0.163 1.57 0 1 1 0 108 0 7 0 0 2
47459 sherfji01 2019 1 ARI NL 1 0 17 0 0 0 1 55 23 12 4 5 22 0.303 5.89 0 0 1 1 83 4 12 1 0 0
47458 shephch01 2019 1 BAL AL 0 0 5 3 0 0 0 57 23 14 5 6 17 0.303 6.63 0 2 2 0 84 1 15 0 0 1
47457 sheffju01 2019 1 SEA AL 0 1 8 7 0 0 0 108 44 22 5 18 37 0.303 5.5 0 3 3 0 168 0 22 1 0 5
47456 shawbr01 2019 1 COL NL 3 2 70 0 0 0 1 216 69 43 12 29 58 0.251 5.38 1 1 5 0 311 18 44 1 1 6
47455 shawami01 2019 1 BOS AL 0 0 14 0 0 0 0 61 26 22 5 13 29 0.31 9.74 0 1 5 0 103 4 22 0 1 1
47454 shafeju01 2019 1 TOR AL 2 1 34 0 0 0 1 119 41 17 6 25 39 0.265 3.86 4 1 1 0 182 11 19 1 0 3
47453 sewalpa01 2019 1 NYN NL 1 1 17 0 0 0 1 59 18 10 3 3 22 0.243 4.58 0 0 1 0 80 6 10 1 1 1
47452 severlu01 2019 1 NYA AL 1 1 3 3 0 0 0 36 6 2 0 6 17 0.146 1.5 0 0 1 0 48 0 2 0 0 1
47451 senzaan01 2019 1 COL NL 11 11 25 25 0 0 0 374 161 93 19 57 76 0.313 6.71 5 1 4 3 582 0 99 4 3 16
47450 selmasa01 2019 1 SFN NL 0 0 10 0 0 0 0 31 6 5 2 6 10 0.171 4.35 0 0 2 0 44 3 5 1 0 1
47449 scottta02 2019 2 BAL AL 0 0 8 0 0 0 0 26 20 18 5 5 7 0.444 18.69 0 2 2 0 52 5 18 0 0 1
47448 scottta02 2019 1 SEA AL 0 0 5 2 0 0 0 23 11 8 1 6 7 0.33299999999999996 9.39 0 0 2 0 41 1 10 0 0 2
47447 scottta01 2019 1 BAL AL 1 1 28 0 0 0 0 79 28 14 4 19 37 0.27699999999999997 4.78 2 2 2 0 122 5 17 0 0 4
47446 scottro02 2019 1 ARI NL 1 0 11 0 0 0 0 22 8 4 1 7 9 0.276 4.91 0 0 0 0 37 1 4 1 0 0
47445 schulja02 2019 1 LAN NL 0 0 4 0 0 0 0 15 6 4 1 3 3 0.316 7.2 0 0 0 0 22 3 4 0 0 2
47444 schrejo01 2019 1 DET AL 2 0 13 0 0 0 0 39 16 9 3 4 19 0.29600000000000004 6.23 0 1 1 0 59 3 9 0 0 1
47443 schlibr01 2019 1 OAK AL 0 0 6 0 0 0 0 29 12 4 0 4 6 0.324 3.72 0 1 0 0 41 3 4 0 0 4
47442 scherma01 2019 1 WAS NL 11 7 27 27 0 0 0 517 144 56 18 33 243 0.222 2.92 2 0 7 0 693 0 59 0 2 7
47441 sborzjo01 2019 1 LAN NL 0 1 7 0 0 0 0 27 10 8 2 4 7 0.28600000000000003 8.0 0 0 0 0 40 6 8 0 1 1
47440 santihe01 2019 2 CHA AL 0 1 11 2 0 0 0 77 32 19 7 17 34 0.299 6.66 0 0 0 0 125 5 20 0 1 2
47439 santihe01 2019 1 NYN NL 1 0 8 0 0 0 0 24 10 6 1 5 6 0.303 6.75 0 0 0 0 38 6 6 0 0 0
47438 santaer01 2019 1 CHA AL 0 2 3 3 0 0 0 40 19 14 6 6 5 0.33899999999999997 9.45 0 1 0 0 64 0 14 0 2 1
47437 santade01 2019 1 LAN NL 0 0 3 0 0 0 0 15 6 4 1 4 6 0.3 7.2 0 1 2 0 27 1 4 0 1 0
47436 sandopa02 2019 1 LAA AL 0 4 10 9 0 0 0 118 35 22 6 19 42 0.24 5.03 0 4 1 1 169 0 22 2 1 4
47435 sandopa01 2019 1 SFN NL 0 0 1 0 0 0 0 3 0 0 0 0 0 0.0 0.0 0 0 1 0 3 1 0 0 0 1
47434 sanchan01 2019 1 WAS NL 11 8 30 30 0 0 0 498 153 71 22 58 134 0.23600000000000002 3.85 10 1 4 3 712 0 77 1 2 7
47433 sanchaa01 2019 2 HOU AL 2 0 4 4 0 0 0 56 14 10 5 9 16 0.2 4.82 0 0 1 0 81 0 10 0 1 1
47432 sanchaa01 2019 1 TOR AL 3 14 23 23 0 0 0 338 131 76 15 59 99 0.29 6.07 2 7 10 0 524 0 82 0 3 8
47431 sampsad01 2019 1 TEX AL 6 8 35 15 1 0 0 376 156 82 29 36 101 0.302 5.89 1 4 9 1 563 4 86 0 2 12
47430 samarje01 2019 1 SFN NL 11 12 32 32 0 0 0 544 152 71 28 49 140 0.225 3.52 4 5 6 0 740 0 78 4 4 11
47429 salech01 2019 1 BOS AL 6 11 25 25 1 1 0 442 123 72 24 37 218 0.221 4.4 0 2 13 0 612 0 80 2 4 7

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