107,429 rows sorted by rowid descending

View and edit SQL

Link rowid ▲ playerID yearID stint teamID lgID G AB R H 2B 3B HR RBI SB CS BB SO IBB HBP SH SF GIDP
107429 zuninmi01 2019 1 TBA AL 90 266 30 44 10 1 9 32 0 0 20 98 0 3 0 0 4
107428 zobribe01 2019 1 CHN NL 47 150 24 39 5 0 1 17 0 0 23 24 0 1 0 2 6
107427 zimmery01 2019 1 WAS NL 52 171 20 44 9 0 6 27 0 0 17 39 0 0 0 2 4
107426 zimmeky01 2019 1 KCA AL 15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107425 zimmejo02 2019 1 DET AL 23 2 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0
107424 zimmebr01 2019 1 CLE AL 9 13 1 0 0 0 0 0 0 0 1 7 0 0 0 0 0
107423 zeuchtj01 2019 1 TOR AL 5 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
107422 zavalse01 2019 1 CHA AL 5 12 1 1 0 0 0 0 0 0 0 9 0 0 0 0 0
107421 zamorda01 2019 1 NYN NL 17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107420 zagunma01 2019 1 CHN NL 30 36 2 9 3 0 0 5 0 0 4 16 0 0 0 0 1
107419 youngal01 2019 1 ARI NL 17 25 1 1 0 0 0 0 0 0 0 18 0 0 0 0 0
107418 ynoahu01 2019 1 ATL NL 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107417 ynoaga01 2019 1 BAL AL 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107416 yelicch01 2019 1 MIL NL 130 489 100 161 29 3 44 97 30 2 80 118 16 8 0 3 8
107415 yateski01 2019 1 SDN NL 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107414 yastrmi01 2019 1 SFN NL 107 371 64 101 22 3 21 55 2 4 32 107 1 4 1 3 4
107413 yardler01 2019 1 SDN NL 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107412 yarbrry01 2019 1 TBA AL 28 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107411 yamamjo01 2019 1 MIA NL 16 21 0 1 0 0 0 1 0 0 1 9 0 0 4 0 1
107410 yacabji01 2019 1 BAL AL 29 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107409 wynnsau01 2019 1 BAL AL 28 70 8 15 1 0 1 5 0 0 3 14 0 0 1 0 2
107408 wrighst01 2019 1 BOS AL 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107407 wrighmi01 2019 2 SEA AL 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107406 wrighmi01 2019 1 BAL AL 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107405 wrighky01 2019 1 ATL NL 7 6 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0
107404 wothema01 2019 1 BAL AL 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107403 workmbr01 2019 1 BOS AL 73 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107402 woodrbr01 2019 1 MIL NL 27 45 1 12 4 0 0 4 0 0 1 20 0 0 3 0 0
107401 woodhu01 2019 2 CLE AL 17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107400 woodhu01 2019 1 TBA AL 19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107399 woodal02 2019 1 CIN NL 7 9 0 2 0 0 0 0 0 0 0 5 0 0 3 0 0
107398 wongko01 2019 1 SLN NL 148 478 61 136 25 4 11 59 24 4 47 83 5 13 6 5 2
107397 wongke01 2019 2 LAA AL 1 4 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0
107396 wongke01 2019 1 TBA AL 6 14 1 3 0 0 0 0 0 1 0 5 0 0 0 0 0
107395 wolteto01 2019 1 COL NL 121 359 42 94 17 2 1 42 0 1 36 68 5 8 2 6 9
107394 wojcias01 2019 1 BAL AL 17 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
107393 wittgni01 2019 1 CLE AL 55 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107392 wislema01 2019 2 SEA AL 23 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107391 wislema01 2019 1 SDN NL 21 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107390 wisdopa01 2019 1 TEX AL 9 26 1 4 1 0 0 1 0 0 1 15 0 0 1 0 0
107389 winklda01 2019 1 ATL NL 27 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0
107388 winkeje01 2019 1 CIN NL 113 338 51 91 17 2 16 38 0 2 38 60 2 8 0 0 10
107387 wingetr01 2019 1 SDN NL 51 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107386 wilsoju10 2019 1 NYN NL 45 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107385 wilsobr02 2019 1 ATL NL 6 9 0 2 0 0 0 0 0 0 0 6 0 0 0 0 0
107384 wilsobo02 2019 1 DET AL 15 44 2 4 1 0 0 2 0 0 2 11 0 0 1 0 1
107383 wilsoal01 2019 1 MIL NL 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107382 willitr01 2019 1 PIT NL 26 36 2 6 0 0 0 4 0 0 2 17 0 0 6 0 0
107381 willita01 2019 1 MIL NL 12 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
107380 willini01 2019 1 PHI NL 67 106 9 16 4 0 2 5 0 0 4 43 0 2 0 0 1
107379 willima08 2019 2 SEA AL 25 77 10 14 0 0 3 10 0 1 9 26 0 1 0 0 1
107378 willima08 2019 1 SFN NL 15 51 3 6 1 0 1 7 2 0 5 18 0 1 0 0 2
107377 willima07 2019 1 BAL AL 11 30 4 8 1 0 0 2 1 0 3 6 0 0 0 1 0
107376 willide03 2019 1 MIL NL 13 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
107375 williau01 2019 1 WAS NL 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107374 wilkest01 2019 1 BAL AL 119 329 41 74 18 2 10 35 3 3 22 108 0 7 1 2 5
107373 wilkeaa01 2019 1 MIL NL 8 3 1 1 0 0 1 2 0 0 0 1 0 0 0 0 0
107372 wietema01 2019 1 SLN NL 67 168 15 36 4 0 11 27 1 1 12 47 0 1 0 2 3
107371 wieckbr01 2019 2 CHN NL 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107370 wieckbr01 2019 1 SDN NL 30 2 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
107369 wickro01 2019 1 CHN NL 31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107368 whitety01 2019 2 LAN NL 12 22 2 1 0 0 0 2 0 0 4 4 0 0 0 0 0
107367 whitety01 2019 1 HOU AL 71 218 16 49 14 0 3 21 0 0 32 74 0 0 0 3 7
107366 wheelza01 2019 1 NYN NL 31 57 5 12 2 0 1 6 0 0 2 19 0 2 3 0 0
107365 wendljo01 2019 1 TBA AL 75 238 32 55 13 2 3 19 8 3 14 47 0 8 0 3 4
107364 wendejb01 2019 1 OAK AL 27 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107363 webstal01 2019 1 CHN NL 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107362 weberry01 2019 1 BOS AL 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107361 webbty01 2019 1 SLN NL 65 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107360 webblo01 2019 1 SFN NL 9 9 0 1 0 0 0 0 0 0 1 2 0 0 1 0 1
107359 webbja01 2019 1 ATL NL 36 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
107358 weavelu01 2019 1 ARI NL 13 19 2 2 0 0 1 4 0 0 0 11 0 0 1 1 0
107357 watsoto01 2019 1 SFN NL 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107356 warrear01 2019 1 SEA AL 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107355 warread01 2019 1 SDN NL 25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107354 wardta01 2019 1 LAA AL 20 42 4 8 3 0 1 2 0 0 6 23 0 0 0 0 1
107353 wangwe01 2019 2 PIT NL 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107352 wangwe01 2019 1 OAK AL 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107351 waltodo01 2019 1 SEA AL 7 16 2 3 0 0 0 2 0 1 3 5 0 0 0 0 0
107350 walshja01 2019 1 LAA AL 34 79 6 16 5 1 1 5 0 0 6 35 1 2 0 0 0
107349 wallach01 2019 1 MIA NL 19 48 4 12 3 0 1 3 0 0 6 12 0 0 0 0 0
107348 walketa01 2019 1 ARI NL 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107347 walkene01 2019 1 MIA NL 115 337 37 88 19 1 8 38 3 0 42 77 1 1 0 1 8
107346 walkeje02 2019 1 ATL NL 6 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107345 walkech02 2019 1 ARI NL 152 529 86 137 26 1 29 73 8 1 67 155 6 6 0 1 11
107344 waldimi01 2019 1 PHI NL 2 2 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0
107343 waldema01 2019 1 BOS AL 70 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
107342 wainwad01 2019 1 SLN NL 31 50 6 8 3 0 0 2 0 0 2 20 0 0 6 1 0
107341 wagueja01 2019 1 TOR AL 16 2 0 0 0 0 0 0 0 0 1 2 0 0 0 0 0
107340 wadety01 2019 1 NYA AL 43 94 16 23 3 1 2 11 7 0 11 28 0 1 2 0 0
107339 wadela01 2019 1 MIN AL 26 56 10 11 2 1 2 5 0 1 11 9 0 2 0 0 0
107338 wachami01 2019 1 SLN NL 29 36 3 6 1 0 0 3 0 0 0 21 0 0 3 0 0
107337 vottojo01 2019 1 CIN NL 142 525 79 137 32 1 15 47 5 0 76 123 2 4 0 3 14
107336 vothau01 2019 1 WAS NL 9 9 0 1 0 0 0 1 0 0 0 3 0 0 1 0 0
107335 volqued01 2019 1 TEX AL 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107334 voitlu01 2019 1 NYA AL 118 429 72 113 21 1 21 62 0 0 71 142 2 9 0 1 12
107333 vogtst01 2019 1 SFN NL 99 255 30 67 24 2 10 40 3 1 20 66 1 1 0 4 1
107332 vogelda01 2019 1 SEA AL 144 462 73 96 17 0 30 76 0 0 92 149 2 2 0 2 4
107331 vizcaar01 2019 1 ATL NL 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
107330 vinceni01 2019 2 PHI NL 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Batting" (
"playerID" TEXT,
  "yearID" INTEGER,
  "stint" INTEGER,
  "teamID" TEXT,
  "lgID" REAL,
  "G" INTEGER,
  "AB" INTEGER,
  "R" INTEGER,
  "H" INTEGER,
  "2B" INTEGER,
  "3B" INTEGER,
  "HR" INTEGER,
  "RBI" INTEGER,
  "SB" INTEGER,
  "CS" INTEGER,
  "BB" INTEGER,
  "SO" INTEGER,
  "IBB" INTEGER,
  "HBP" INTEGER,
  "SH" INTEGER,
  "SF" INTEGER,
  "GIDP" INTEGER
);