107,429 rows sorted by H

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
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
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
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
101 stearbi01 1871 1 WS3   2 9 1 0 0 0 0 1 0 0 2 2         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
185 higby01 1872 1 BR2   1 4 0 0 0 0 0 0 0 0 0 0         0
193 hurledi01 1872 1 WS3   2 7 0 0 0 0 0 0 0 0 0 1         0
197 kennejo01 1872 1 BR2   5 19 0 0 0 0 0 1 0 0 0 1         0
198 kingma01 1872 1 TRO   3 11 0 0 0 0 0 1 0 0 0 1         0
216 mcdonja01 1872 2 BR1   1 4 0 0 0 0 0 0 0 0 0 0         1
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
250 spenc01 1872 1 WS4   1 4 1 0 0 0 0 0 0 0 0 0         0
269 yeatmbi01 1872 1 WS4   1 4 0 0 0 0 0 0 0 0 0 1         0
279 atkined01 1873 1 WS5   2 8 2 0 0 0 0 0 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
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
373 sheppjo01 1873 1 BL4   3 11 1 0 0 0 0 0 0 0 0 1         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
414 brown01 1874 1 BL1   2 9 0 0 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
459 kohlehe01 1874 1 BL1   2 4 0 0 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
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
500 smilebi01 1874 1 BL1   2 7 0 0 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
528 arundha01 1875 1 BR2   1 4 0 0 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
550 bradyst01 1875 2 HR1   1 4 0 0 0 0 0 0 0 0 0 1         0
552 brownol01 1875 1 BR2   3 10 0 0 0 0 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
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
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
726 walkeos01 1875 1 BR2   1 2 0 0 0 0 0 0 0 0 1 0         1
732 withech01 1875 1 WS6   1 1 0 0 0 0 0 0 0 0 0 0         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          
779 fieldsa01 1876 1 CN1 NL 4 14 2 0 0 0 0 0     1 3          
784 forceda01 1876 2 NY3 NL 1 3 0 0 0 0 0 0     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          
822 mullejo01 1876 1 PHN NL 1 3 0 0 0 0 0 0     0 0          
825 nichotr01 1876 1 BSN NL 1 4 0 0 0 0 0 0     0 0          
827 parksbi01 1876 1 BSN NL 1 4 0 0 0 0 0 0     0 0          
830 pearcfr01 1876 1 LS1 NL 1 2 0 0 0 0 0 0     0 0          
832 phelpne01 1876 1 NY3 NL 1 3 0 0 0 0 0 0     0 1          
833 phelpne01 1876 2 PHN NL 1 4 0 0 0 0 0 0     0 0          
840 sewarge01 1876 1 NY3 NL 1 3 0 0 0 0 0 0     0 0          
850 treacpe01 1876 1 NY3 NL 2 5 1 0 0 0 0 0     1 0          
851 valenbo01 1876 1 NY3 NL 1 3 0 0 0 0 0 0     0 0          
853 warnefr01 1876 1 PHN NL 1 3 0 0 0 0 0 0     0 0          
854 westbi01 1876 1 NY3 NL 1 4 0 0 0 0 0 0     0 0          
859 wrighha01 1876 1 BSN NL 1 3 0 0 0 0 0 0     0 1          
874 buncejo01 1877 1 HAR NL 1 4 0 0 0 0 0 0     0 0          
890 fishech01 1877 1 CHN NL 1 4 0 0 0 0 0 0     0 2          
898 haldejo01 1877 1 LS1 NL 1 4 0 0 0 0 0 0     0 0          
917 littlha01 1877 2 LS1 NL 1 3 0 0 0 0 0 0     1 1          
931 newelte01 1877 1 SL3 NL 1 3 0 0 0 0 0 0     0 0          
959 wrighha01 1877 1 BSN NL 1 4 0 0 0 0 0 0     0 1          
978 fishech01 1878 1 PRO NL 1 3 0 0 0 0 0 0     0 0          
995 jennial01 1878 1 ML2 NL 1 2 0 0 0 0 0 0     1 0          
1044 allisdo01 1879 1 PRO NL 1 5 0 0 0 0 0 0     0 1          
1066 dolanto01 1879 1 CHN NL 1 4 0 0 0 0 0 0     0 2          
1089 gunklfr01 1879 1 CL2 NL 1 3 1 0 0 0 0 0     0 1          
1097 hoffmhi01 1879 1 CL2 NL 2 6 0 0 0 0 0 0     0 3          
1111 libbyst01 1879 1 BFN NL 1 2 0 0 0 0 0 0     0 1          
1113 magnejo01 1879 1 CN1 NL 1 4 0 0 0 0 0 1     0 1          
1132 osterch01 1879 1 SR1 NL 2 8 0 0 0 0 0 0     0 0          
1151 stockle01 1879 1 CL2 NL 2 6 0 0 0 0 0 0     0 2          
1160 wheelha01 1879 1 CN1 NL 1 3 0 0 0 0 0 0     0 2          
1174 bootham01 1880 1 CN1 NL 1 2 0 0 0 0 0 0     0 0          
1176 briodfa01 1880 1 TRN NL 1 4 0 0 0 0 0 0     0 0          
1213 geerbi01 1880 1 WOR NL 2 6 0 0 0 0 0 0     0 0          
1221 haleyfr01 1880 1 TRN NL 2 7 0 0 0 0 0 0     1 2          
1235 kearnto01 1880 1 BFN NL 2 7 0 0 0 0 0 0     0 0          
1244 learyja01 1880 1 BSN NL 1 3 1 0 0 0 0 0     1 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
);