14,750 rows sorted by BB

View and edit SQL

Suggested facets: round, lgID, G, R, H, 2B, 3B, HR, RBI, SB, CS, BB, SO, IBB, HBP, SH, SF, GIDP

Link rowid yearID round playerID teamID lgID G AB R H 2B 3B HR RBI SB CS BB ▼ SO IBB HBP SH SF GIDP
1 1884 WS becanbu01 NY4 AA 1 2 0 1 0 0 0 0 0   0 0 0        
2 1884 WS bradyst01 NY4 AA 3 10 1 0 0 0 0 0 0   0 1 0        
4 1884 WS dennyje01 PRO NL 3 9 3 4 0 1 1 2 0   0 3 0        
5 1884 WS esterdu01 NY4 AA 3 10 0 3 1 0 0 0 1   0 3 0        
6 1884 WS farreja02 PRO NL 3 9 3 4 2 0 0 0 1   0 0 0        
7 1884 WS forstto01 NY4 AA 1 3 0 0 0 0 0 0 0   0 1 0        
8 1884 WS gilliba01 PRO NL 3 9 3 4 2 0 0 2 0   0 1 0        
10 1884 WS irwinar01 PRO NL 3 9 3 2 0 1 0 2 0   0 2 0        
11 1884 WS keefeti01 NY4 AA 2 5 0 1 0 0 0 0 0   0 4 0        
12 1884 WS kenneed01 NY4 AA 3 7 0 0 0 0 0 0 0   0 2 0        
13 1884 WS nelsoca01 NY4 AA 3 10 0 1 0 0 0 0 0   0 1 0        
14 1884 WS orrda01 NY4 AA 3 9 0 1 0 0 0 0 0   0 0 0        
16 1884 WS radfopa01 PRO NL 3 7 1 0 0 0 0 1 0   0 1 0        
17 1884 WS reipsch01 NY4 AA 2 5 1 0 0 0 0 0 0   0 1 0        
18 1884 WS rosemch01 NY4 AA 3 9 1 3 0 0 0 1 0   0 1 0        
19 1884 WS startjo01 PRO NL 3 10 0 1 0 0 0 1 0   0 2 0        
20 1884 WS troyda01 NY4 AA 2 5 0 1 0 0 0 1 0   0 1 0        
23 1885 WS burnsto01 CHN NL 7 25 3 2 0 1 0 0 0   0 0 0        
24 1885 WS bushodo01 SL4 AA 4 13 1 2 0 0 0 0 0   0 0 0        
26 1885 WS clarkjo01 CHN NL 4 13 1 2 1 0 0 0 0   0 0 0        
27 1885 WS comisch01 SL4 AA 7 24 6 7 0 0 0 0 0   0 0 0        
29 1885 WS flintsi01 CHN NL 4 14 0 2 0 0 0 0 0   0 0 0        
30 1885 WS foutzda01 SL4 AA 4 12 1 2 0 0 0 0 0   0 0 0        
33 1885 WS hollibu01 CHN NL 1 4 0 0 0 0 0 0 0   0 0 0        
36 1885 WS mccorji01 CHN NL 5 17 1 3 0 0 0 0 0   0 0 0        
37 1885 WS nicolhu01 SL4 AA 1 2 0 0 0 0 0 0 0   0 0 0        
38 1885 WS oneilti01 SL4 AA 7 24 4 5 0 0 0 0 0   0 0 0        
39 1885 WS pfefffr01 CHN NL 7 27 5 11 2 0 1 0 0   0 0 0        
42 1885 WS welchcu01 SL4 AA 7 27 5 4 1 1 0 0 0   0 0 0        
45 1886 WS burnsto01 CHN NL 6 21 2 6 2 1 0 1 0   0 2 0        
48 1886 WS clarkjo01 CHN NL 4 15 0 1 0 0 0 1 1   0 2 0        
49 1886 WS comisch01 SL4 AA 6 24 2 7 1 0 0 2 0   0 4 0        
50 1886 WS dalryab01 CHN NL 6 21 2 4 1 1 0 2 1   0 5 0        
51 1886 WS flintsi01 CHN NL 1 3 0 0 0 0 0 1 0   0 1 0        
52 1886 WS foutzda01 SL4 AA 4 15 2 3 1 1 0 3 0   0 3 0        
58 1886 WS mccorji01 CHN NL 1 3 0 0 0 0 0 0 0   0 0 0        
62 1886 WS ryanji01 CHN NL 6 20 4 5 1 0 0 2 1   0 1 0        
67 1887 WS boyleja01 SL4 AA 6 24 1 5 0 0 0 2 0   0 4 0        
68 1887 WS broutda01 DTN NL 1 3 0 2 0 0 0 0 0   0 0 0        
72 1887 WS conwape01 DTN NL 4 12 0 0 0 0 0 0 0   0 2 0        
73 1887 WS dunlafr01 DTN NL 11 40 5 6 0 1 0 1 4   0 4 0        
79 1887 WS kingsi01 SL4 AA 4 14 0 1 0 0 0 1 0   0 3 0        
82 1887 WS oneilti01 SL4 AA 15 65 7 13 2 1 1 9 0   0 2 0        
88 1887 WS twitcla01 DTN NL 6 20 5 5 1 0 1 3 1   0 1 0        
89 1887 WS welchcu01 SL4 AA 15 58 6 12 3 1 1 8 1   0 2 0        
92 1888 WS brownwi01 NY1 NL 2 8 1 3 1 0 0 0 0   0 0 0        
96 1888 WS craneed01 NY1 NL 2 7 1 1 0 0 0 2 0   0 1 0        
97 1888 WS devliji02 SL4 AA 1 3 0 0 0 0 0 0 0   0 0 0        
99 1888 WS georgbi01 NY1 NL 2 9 2 3 1 0 1 4 0   0 2 0        
102 1888 WS herred01 SL4 AA 3 11 2 1 0 0 0 0 1   0 5 0        
107 1888 WS mccarto01 SL4 AA 10 41 10 10 1 0 1 9 6   0 0 0        
109 1888 WS murphpa01 NY1 NL 3 10 1 1 0 0 0 1 0   0 0 0        
114 1888 WS slattmi01 NY1 NL 10 39 6 8 2 0 0 5 6   0 5 0        
116 1888 WS titcoca01 NY1 NL 1 4 1 2 1 0 0 1 0   0 0 0        
118 1888 WS welchmi01 NY1 NL 2 7 2 2 0 0 0 1 0   0 0 0        
121 1889 WS brownwi01 NY1 NL 1 5 3 3 0 0 1 2 0   0 0 0        
130 1889 WS davisju01 BR3 AA 1 4 0 0 0 0 0 0 0   0 0 0        
136 1889 WS lovetto01 BR3 AA 1 1 0 0 0 0 0 0 0   0 0 0        
148 1889 WS welchmi01 NY1 NL 1 3 0 1 1 0 0 0 0   0 1 0        
150 1890 WS blighne01 LS2 AA 2 3 0 0 0 0 0 0 0   0 1 0        
152 1890 WS bushodo01 BRO NL 2 6 0 0 0 0 0 0 0   0 1 0        
154 1890 WS clarkbo01 BRO NL 1 3 2 2 0 1 0 1 0   0 0 0        
157 1890 WS dalyto01 BRO NL 6 22 1 4 2 0 0 3 2   0 4 0        
159 1890 WS ehretre01 LS2 AA 3 7 1 3 0 1 0 0 0   0 0 0        
160 1890 WS foutzda01 BRO NL 7 30 6 9 2 1 0 4 1   0 1 0        
161 1890 WS hambuch01 LS2 AA 7 26 3 7 1 0 0 2 0   0 3 0        
162 1890 WS lovetto01 BRO NL 5 15 0 1 0 0 0 0 0   0 4 0        
163 1890 WS meakige01 LS2 AA 1 2 0 1 0 0 0 0 0   0 0 0        
167 1890 WS ryanja01 LS2 AA 6 19 0 1 0 0 0 2 1   0 1 0        
169 1890 WS smithge01 BRO NL 7 29 3 8 0 2 0 7 1   0 3 0        
175 1890 WS weckbpe01 LS2 AA 1 4 0 0 0 0 0 0 0   0 1 0        
177 1892 CS bennech01 BSN NL 2 7 2 2 0 0 1 1 1   0 2 0        
178 1892 CS burkeje01 CL4 NL 6 25 3 8 1 0 0 1 4   0 2 0        
180 1892 CS clarkjo01 CL4 NL 2 8 1 2 0 0 1 3 0   0 1 0        
181 1892 CS cuppyni01 CL4 NL 1 3 0 0 0 0 0 0 0   0 2 0        
182 1892 CS davisge01 CL4 NL 3 6 0 1 0 0 0 0 0   0 1 0        
185 1892 CS kellyki01 BSN NL 2 8 0 0 0 0 0 0 1   0 2 0        
186 1892 CS longhe01 BSN NL 6 27 4 6 0 0 0 1 2   0 0 0        
192 1892 CS nichoki01 BSN NL 2 7 1 2 0 0 0 2 1   0 1 0        
195 1892 CS staleha01 BSN NL 1 4 0 0 0 0 0 0 0   0 3 0        
196 1892 CS stiveja01 BSN NL 3 12 3 3 1 1 0 1 0   0 2 0        
197 1892 CS tebeapa01 CL4 NL 5 18 1 0 0 0 0 0 1   0 2 0        
198 1892 CS tucketo01 BSN NL 6 23 2 6 0 0 1 2 0   0 1 0        
200 1892 CS youngcy01 CL4 NL 3 11 1 1 0 0 0 0 0   0 5 0        
201 1892 CS zimmech01 CL4 NL 6 23 2 6 1 1 0 2 0   0 3 0        
209 1903 WS farredu01 BOS AL 2 2 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0
210 1903 WS ferriho01 BOS AL 8 31 3 9 0 1 0 5 0 0 0 6 0 1 1 0 0
212 1903 WS hugheto01 BOS AL 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
213 1903 WS kennebr01 PIT NL 1 2 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0
216 1903 WS leevesa01 PIT NL 2 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
217 1903 WS obrieja02 BOS AL 2 2 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
220 1903 WS phillde01 PIT NL 5 18 1 4 0 0 0 1 0 0 0 3 0 0 0 0 0
223 1903 WS smithha03 PIT NL 1 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
225 1903 WS thompgu01 PIT NL 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
226 1903 WS veilbu01 PIT NL 1 2 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0
228 1903 WS youngcy01 BOS AL 4 15 1 1 0 1 0 3 0 0 0 3 0 0 0 0 1
229 1905 WS amesre01 NY1 NL 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
230 1905 WS bendech01 PHA AL 2 5 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0
232 1905 WS brownge01 NY1 NL 5 22 2 5 0 0 0 1 2 0 0 2 0 0 0 0 0
233 1905 WS coaklan01 PHA AL 1 2 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "BattingPost" (
"yearID" INTEGER,
  "round" TEXT,
  "playerID" TEXT,
  "teamID" TEXT,
  "lgID" TEXT,
  "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
);