107,429 rows sorted by G

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
1 abercda01 1871 1 TRO   1 4 0 0 0 0 0 0 0 0 0 0         0
7 barkeal01 1871 1 RC1   1 4 0 1 0 0 0 2 0 0 1 0         0
9 barrebi01 1871 1 FW1   1 5 1 1 1 0 0 1 0 0 0 0         0
12 battijo01 1871 1 CL1   1 3 0 0 0 0 0 0 0 0 1 0         0
17 berkena01 1871 1 PH1   1 4 0 0 0 0 0 0 0 0 0 3         0
18 berryto01 1871 1 PH1   1 4 0 1 0 0 0 0 0 0 0 0         0
20 biermch01 1871 1 FW1   1 2 0 0 0 0 0 0 0 0 1 0         0
36 ewellge01 1871 1 CL1   1 3 0 0 0 0 0 0 0 0 0 0         0
40 fleetfr01 1871 1 NY2   1 6 1 2 0 0 0 1 0 0 0 0         0
80 nortofr01 1871 1 WS3   1 1 0 0 0 0 0 0 0 0 0 1         0
84 phelpne01 1871 1 FW1   1 3 0 0 0 0 0 0 0 0 1 0         0
88 prattto01 1871 1 PH1   1 6 2 2 0 0 0 1 0 0 0 0         0
109 whitewa01 1871 1 WS3   1 4 0 0 0 0 0 0 0 0 0 0         0
127 barrebi01 1872 1 WS3   1 4 0 0 0 0 0 0 0 0 0 0         0
171 galvijo01 1872 1 BR2   1 4 0 0 0 0 0 0 0 0 0 0         0
175 glennjo01 1872 2 WS4   1 4 0 2 0 0 0 0 0 0 0 0         0
185 higby01 1872 1 BR2   1 4 0 0 0 0 0 0 0 0 0 0         0
216 mcdonja01 1872 2 BR1   1 4 0 0 0 0 0 0 0 0 0 0         1
222 millejo01 1872 1 WS4   1 4 0 1 0 0 0 0 0 0 0 0         0
226 mulle01 1872 1 CL1   1 4 1 0 0 0 0 0 0 0 0 0         0
230 orour01 1872 1 BR1   1 4 0 0 0 0 0 0 0 0 0 0         0
245 senseco01 1872 1 PH1   1 5 2 2 0 0 0 1 0 1 0 0         0
250 spenc01 1872 1 WS4   1 4 1 0 0 0 0 0 0 0 0 0         0
266 worthhe01 1872 1 BR2   1 5 1 1 1 0 0 1 0 0 0 0         0
269 yeatmbi01 1872 1 WS4   1 4 0 0 0 0 0 0 0 0 0 1         0
283 barrebi01 1873 1 BL1   1 4 0 1 0 0 0 0 0 1 0 0         0
284 battijo01 1873 1 PH1   1 5 4 3 0 0 0 2 0 0 1 0         0
301 cranefr01 1873 1 ELI   1 4 0 1 0 0 0 1 0 0 0 0         0
308 doschhe01 1873 1 BR2   1 6 1 1 0 0 0 1 0 0 0 0         0
310 eland01 1873 1 BL4   1 3 0 0 0 0 0 0 0 0 0 0         0
322 goldswa01 1873 1 BL4   1 4 0 0 0 0 0 0 0 0 0 0         0
333 johnsto01 1873 1 BL4   1 4 0 0 0 0 0 0 0 0 0 0         1
334 jones01 1873 1 BL4   1 4 0 3 0 0 0 1 0 0 0 0         0
336 kesslhe01 1873 1 BR2   1 5 0 1 0 0 0 1 0 0 0 0         0
341 lovetle01 1873 1 ELI   1 5 1 2 0 0 0 1 0 0 0 0         0
348 mcdoo01 1873 1 BL4   1 4 1 0 0 0 0 0 0 0 0 0         0
360 phelpne01 1873 1 NY2   1 6 0 0 0 0 0 0 0 0 0 0         0
362 popplge01 1873 1 BL4   1 4 0 0 0 0 0 0 0 0 0 0         0
365 reachbo01 1873 1 WS5   1 5 1 1 0 0 0 0 0 0 0 0         0
371 selmafr01 1873 1 BL4   1 3 1 1 0 0 0 0 0 0 0 0         0
384 sweasch01 1873 1 BS1   1 4 0 1 0 0 0 0 0 0 0 0         0
386 wallho01 1873 1 WS5   1 3 1 1 0 0 0 0 0 0 1 0         0
390 woltery01 1873 1 ELI   1 4 1 0 0 0 0 0 0 0 0 0         0
391 woodhre01 1873 1 BL4   1 5 1 0 0 0 0 0 0 0 0 0         0
408 boardfr01 1874 1 BL1   1 4 0 1 0 0 0 0 0 0 0 0         0
417 carlle01 1874 1 BL1   1 3 0 0 0 0 0 0 0 0 0 0         0
423 connete01 1874 1 CH2   1 4 0 0 0 0 0 0 0 0 0 0         0
440 gaver01 1874 1 BR2   1 4 1 0 0 0 0 0 0 0 0 0         0
460 ledwimi01 1874 1 BR2   1 4 1 1 0 0 0 1 0 0 0 0         0
465 mannija01 1874 2 HR1   1 5 1 1 0 0 0 0 0 0 0 0         0
471 mckenfr01 1874 1 PH2   1 4 0 0 0 0 0 0 0 0 0 1         0
479 oneal01 1874 1 HR1   1 3 0 0 0 0 0 0 0 0 0 1         0
482 patteda01 1874 1 NY2   1 5 1 2 0 0 0 2 0 0 0 0         0
487 quinl01 1874 1 PH2   1 4 0 1 0 0 0 1 0 0 0 0         0
490 reedhu01 1874 1 BL1   1 4 0 0 0 0 0 0 0 0 0 0         0
492 revilhe01 1874 1 BL1   1 4 0 0 0 0 0 0 0 0 0 0         0
499 shaffor01 1874 2 NY2   1 5 1 1 0 0 0 0 0 0 0 0         0
502 snowch01 1874 1 BR2   1 1 0 1 0 0 0 0 0 0 0 0         0
516 wood01 1874 1 BL1   1 5 0 0 0 0 0 0 0 0 0 1         0
522 abadijo01 1875 2 BR2   1 4 1 1 0 0 0 1 0 0 0 0         0
528 arundha01 1875 1 BR2   1 4 0 0 0 0 0 0 0 0 0 0         0
530 barloto01 1875 1 NH1   1 5 1 1 0 0 0 0 0 0 0 0         0
531 barloto01 1875 2 BR2   1 4 0 0 0 0 0 0 0 0 0 0         0
541 bolan01 1875 1 BR2   1 4 0 0 0 0 0 0 0 0 0 0         0
543 booth01 1875 1 NH1   1 2 0 0 0 0 0 0 0 0 0 1         0
548 brady01 1875 1 CH2   1 4 1 1 0 1 0 0 0 0 0 0         0
550 bradyst01 1875 2 HR1   1 4 0 0 0 0 0 0 0 0 0 1         0
554 bushodo01 1875 1 BR2   1 5 0 3 0 1 0 0 0 0 0 0         0
575 dillojo01 1875 1 SL1   1 1 0 0 0 0 0 0 0 0 0 0         0
577 dolele01 1875 1 NH1   1 4 1 2 0 0 0 0 0 0 0 0         0
579 edwar01 1875 1 BR2   1 5 1 1 0 0 0 0 0 0 0 0         0
582 evans01 1875 1 NH1   1 4 1 2 0 0 0 1 0 0 0 0         0
594 fulmewa01 1875 1 BR2   1 4 1 2 0 0 0 1 0 0 0 0         0
605 goldsfr01 1875 1 NH1   1 4 0 2 0 0 0 1 0 0 0 0         0
612 hallji01 1875 1 KEO   1 3 0 1 0 1 0 1 0 0 0 0         0
614 harriri01 1875 1 NH1   1 4 0 2 1 0 0 1 0 1 0 0         0
616 hatfijo01 1875 1 NY2   1 4 1 2 1 0 0 1 0 0 0 0         0
619 helli01 1875 1 BR2   1 4 0 1 0 0 0 0 0 0 0 0         0
627 jonesch01 1875 2 HR1   1 4 1 0 0 0 0 0 0 0 0 1         0
631 knighge01 1875 1 NH1   1 4 0 0 0 0 0 0 0 0 0 0         0
665 munnho01 1875 1 BR2   1 4 0 0 0 0 0 0 0 0 0 0         0
691 rextewi01 1875 1 BR2   1 4 0 0 0 0 0 0 0 0 0 0         0
698 selmafr01 1875 1 WS6   1 3 0 1 0 0 0 0 0 0 0 0         0
700 shaff01 1875 1 BR2   1 4 0 0 0 0 0 0 0 0 0 0         0
702 sheri01 1875 1 BR2   1 4 0 0 0 0 0 0 0 0 0 1         0
704 smithjo01 1875 1 NH1   1 3 0 0 0 0 0 0 0 0 1 0         0
712 stevero01 1875 1 WS6   1 4 0 1 0 0 0 0 0 0 0 0         0
718 thompfr01 1875 1 BR2   1 5 1 2 0 0 0 1 0 0 0 0         0
726 walkeos01 1875 1 BR2   1 2 0 0 0 0 0 0 0 0 1 0         1
729 weavesa01 1875 1 PH2   1 4 1 1 1 0 0 1 0 0 0 0         0
732 withech01 1875 1 WS6   1 1 0 0 0 0 0 0 0 0 0 0         0
734 wrighha01 1875 1 BS1   1 4 1 1 0 0 0 0 0 0 0 1         0
748 berghjo01 1876 1 PHN NL 1 4 0 0 0 0 0 0     0 2          
777 fairge01 1876 1 NY3 NL 1 4 0 0 0 0 0 0     0 0          
784 forceda01 1876 2 NY3 NL 1 3 0 0 0 0 0 0     0 0          
795 hatfijo01 1876 1 NY3 NL 1 4 0 1 0 0 0 1     0 0          
797 heubege01 1876 1 NY3 NL 1 4 0 0 0 0 0 0     0 0          
806 laffefl01 1876 1 PHN NL 1 3 0 0 0 0 0 0     0 0          
807 larkite01 1876 1 NY3 NL 1 4 0 0 0 0 0 0     0 0          
817 mcguijo01 1876 1 NY3 NL 1 4 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
);