143,046 rows sorted by A

View and edit SQL

Suggested facets: ZR

These facets timed out: POS

Link rowid playerID yearID stint teamID lgID POS G GS InnOuts PO A ▼ E DP PB WP SB CS ZR
7 ansonca01 1871 1 RC1   1B 1 0 15 7 0 0 0          
10 ansonca01 1871 1 RC1   C 5 4 93 10 0 8 0 7   0 0  
11 ansonca01 1871 1 RC1   OF 1 1 6 0 0 0 0          
13 barkeal01 1871 1 RC1   OF 1 1 27 2 0 0 0          
16 barrebi01 1871 1 FW1   3B 1 1 6 1 0 0 0          
17 barrebi01 1871 1 FW1   C 1 0 33 8 0 0 0 0   0 0  
18 barrofr01 1871 1 BS1   2B 1 1 12 2 0 1 0          
20 bassjo01 1871 1 CL1   C 1 0 18 4 0 1 0 3   0 0  
22 battijo01 1871 1 CL1   OF 1 1 21 1 0 0 0          
31 berkena01 1871 1 PH1   OF 1 1 30 3 0 0 0          
32 berryto01 1871 1 PH1   OF 1 1 18 0 0 1 0          
34 berthha01 1871 1 WS3   C 1 0 6 0 0 1 0 1   0 0  
35 berthha01 1871 1 WS3   OF 12 12 345 29 0 7 0          
36 biermch01 1871 1 FW1   1B 1 1 27 9 0 2 0          
42 burrohe01 1871 1 WS3   2B 1 0 12 1 0 1 0          
53 cravebi01 1871 1 TRO   OF 1 1 6 0 0 0 0          
57 deaneha01 1871 1 FW1   OF 6 5 159 21 0 0 0          
59 donnepe01 1871 1 FW1   OF 9 8 117 5 0 2 0          
60 duffyed01 1871 1 CH1   3B 1 1 6 0 0 1 0          
63 ewellge01 1871 1 CL1   OF 1 1 18 1 0 0 0          
66 fergubo01 1871 1 NY2   C 5 3 111 19 0 4 0 7   0 0  
67 fergubo01 1871 1 NY2   P 1 0 3 0 0 0 0          
68 fishech01 1871 1 RC1   1B 2 1 27 12 0 1 0          
75 flowedi01 1871 1 TRO   P 1 0 3 0 0 0 0          
88 fulmech01 1871 1 RC1   1B 1 1 18 9 0 0 0          
92 goldswa01 1871 1 FW1   C 2 1 42 4 0 4 0 10   0 0  
95 gouldch01 1871 1 BS1   OF 1 1 45 2 0 1 0          
101 hastisc01 1871 1 RC1   1B 1 0 9 4 0 1 0          
104 hastisc01 1871 1 RC1   OF 2 2 15 1 0 0 0          
108 heubege01 1871 1 PH1   1B 1 1 18 6 0 0 0          
111 highadi01 1871 1 NY2   C 1 1 36 6 0 2 0 1   0 0  
112 highadi01 1871 1 NY2   OF 8 8 255 14 0 4 0          
115 hodesch01 1871 1 CH1   OF 4 2 33 2 0 0 0          
118 jackssa01 1871 1 BS1   OF 1 1 6 0 0 0 0          
119 jackssa01 1871 1 BS1   SS 1 0 6 0 0 1 0          
121 johnsca01 1871 1 CL1   OF 6 6 129 5 0 3 0          
129 kingma01 1871 1 CH1   OF 11 10 231 11 0 3 0          
132 kohlehe01 1871 1 FW1   1B 2 2 51 17 0 1 0          
133 kohlehe01 1871 1 FW1   3B 1 1 24 4 0 1 0          
134 kohlehe01 1871 1 FW1   C 2 0 6 0 0 0 0 1   0 0  
136 lennobi01 1871 1 FW1   OF 1 0 12 0 0 1 0          
142 mackde01 1871 1 RC1   OF 1 0 12 1 0 0 0          
154 mcveyca01 1871 1 BS1   3B 1 0 6 0 0 0 0          
156 mcveyca01 1871 1 BS1   OF 5 2 45 2 0 1 0          
159 millsch01 1871 1 NY2   3B 1 0 6 1 0 0 0          
161 millsch01 1871 1 NY2   OF 4 3 15 1 0 0 0          
163 minched01 1871 1 FW1   OF 9 9 222 23 0 4 0          
164 nortofr01 1871 1 WS3   3B 1 0 6 0 0 1 0          
165 nortofr01 1871 1 WS3   OF 1 0 6 0 0 0 0          
171 phelpne01 1871 1 FW1   1B 1 1 27 8 0 1 1          
172 pikeli01 1871 1 TRO   1B 4 4 111 44 0 5 3          
178 prattal01 1871 1 CL1   OF 7 1 60 3 0 1 0          
180 prattto01 1871 1 PH1   1B 1 1 36 11 0 3 0          
182 questjo01 1871 1 CL1   SS 1 1 12 1 0 1 0          
186 sagerpo01 1871 1 RC1   OF 4 3 84 4 0 2 0          
193 simmojo01 1871 1 CH1   1B 2 2 48 18 0 2 0          
197 spaldal01 1871 1 BS1   OF 9 0 42 3 0 0 0          
203 suttoez01 1871 1 CL1   C 1 0 6 0 0 1 0 7   0 0  
204 suttoez01 1871 1 CL1   OF 2 0 27 1 0 0 0          
209 whitede01 1871 1 CL1   2B 1 1 9 2 0 0 0          
212 whitede01 1871 1 CL1   OF 1 0 6 0 0 0 0          
226 zettlge01 1871 1 CH1   OF 3 0 27 1 0 1 0          
232 allisan01 1872 1 BR1   OF 1 0 30 0 0 2 0          
234 allisbi01 1872 1 BR1   1B 2 2 60 24 0 2 0          
236 allisbi01 1872 1 BR1   OF 2 2 60 2 0 2 0          
241 arnolbi01 1872 1 MID   OF 2 2 39 2 0 0 0          
242 barloto01 1872 1 BR2   3B 1 0 6 0 0 0 0          
246 barre01 1872 1 BR2   OF 8 7 243 21 0 5 0          
247 barrebi01 1872 1 WS3   C 1 0 27 2 0 3 0 4   0 0  
248 bassjo01 1872 1 BR2   OF 2 2 51 2 0 2 0          
250 bealsto01 1872 1 WS3   OF 2 2 36 0 0 2 0          
253 beaveed01 1872 1 BR2   OF 1 0 12 0 0 1 0          
255 bechtge01 1872 1 NY2   1B 1 1 30 6 0 3 0          
264 bielaos01 1872 1 WS4   OF 10 9 279 14 0 5 0          
266 birdsda01 1872 1 BS1   OF 7 5 105 5 0 1 0          
273 boydbi01 1872 1 NY2   OF 1 1 27 2 0 0 0          
276 brainas01 1872 2 MID   OF 1 0 6 0 0 0 0          
279 brownol01 1872 1 BR2   OF 4 4 111 8 0 1 0          
285 buttefr01 1872 1 MID   OF 8 6 177 5 0 4 0          
287 careyto01 1872 1 BL1   1B 1 1 21 5 0 1 0          
290 careyto01 1872 1 BL1   OF 3 1 102 4 0 3 0          
293 clappjo01 1872 1 MID   1B 1 0 15 6 0 1 2          
295 clappjo01 1872 1 MID   OF 1 0 12 1 0 0 0          
298 clarede01 1872 1 BR2   SS 1 0 21 1 0 4 0          
301 clintji01 1872 1 BR1   C 2 0 27 3 0 2 0 2   0 0  
305 coughde01 1872 1 WS4   1B 1 1 12 2 0 1 0          
312 cravebi01 1872 1 BL1   OF 4 4 21 0 0 1 0          
313 cummica01 1872 1 NY2   OF 2 0 24 0 0 2 0          
318 doylejo01 1872 1 WS4   2B 1 1 21 2 0 3 0          
322 fergubo01 1872 1 BR2   C 1 0 6 0 0 0 0 1   0 0  
324 fieldge01 1872 1 MID   OF 5 5 81 2 0 2 0          
332 fleetfr01 1872 1 BR1   OF 2 2 21 1 0 0 0          
333 fletcge01 1872 1 BR1   OF 2 1 63 3 0 2 0          
341 galvijo01 1872 1 BR2   2B 1 1 24 1 0 4 0          
342 gedneco01 1872 1 TRO   OF 9 9 228 14 0 1 0          
343 gedneco01 1872 2 BR1   OF 18 16 483 52 0 7 0          
345 glennjo01 1872 2 WS4   OF 1 1 27 2 0 1 0          
349 gouldch01 1872 1 BS1   OF 2 1 60 3 0 0 0          
350 hallge01 1872 1 BL1   1B 1 1 15 4 0 0 1          
358 hastisc01 1872 2 BL1   OF 1 1 6 0 0 0 0          

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Fielding" (
"playerID" TEXT,
  "yearID" INTEGER,
  "stint" INTEGER,
  "teamID" TEXT,
  "lgID" REAL,
  "POS" TEXT,
  "G" INTEGER,
  "GS" INTEGER,
  "InnOuts" INTEGER,
  "PO" INTEGER,
  "A" INTEGER,
  "E" INTEGER,
  "DP" INTEGER,
  "PB" INTEGER,
  "WP" INTEGER,
  "SB" INTEGER,
  "CS" INTEGER,
  "ZR" INTEGER
);