143,046 rows sorted by G

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
1 abercda01 1871 1 TRO   SS 1 1 24 1 3 2 0          
7 ansonca01 1871 1 RC1   1B 1 0 15 7 0 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          
30 bellast01 1871 1 TRO   SS 1 1 21 1 4 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  
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          
55 cuthbne01 1871 1 PH1   C 1 1 15 2 1 1 0 1   0 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          
67 fergubo01 1871 1 NY2   P 1 0 3 0 0 0 0          
69 fishech01 1871 1 RC1   2B 1 0 12 1 1 1 0          
73 fleetfr01 1871 1 NY2   P 1 1 27 0 5 0 0          
74 flowedi01 1871 1 TRO   2B 1 1 27 1 4 2 0          
75 flowedi01 1871 1 TRO   P 1 0 3 0 0 0 0          
78 flynncl01 1871 1 TRO   2B 1 1 27 2 3 2 0          
79 flynncl01 1871 1 TRO   3B 1 1 36 2 4 2 0          
81 foleyto01 1871 1 CH1   3B 1 0 18 2 1 1 0          
86 forceda01 1871 1 WS3   3B 1 1 21 2 2 1 0          
88 fulmech01 1871 1 RC1   1B 1 1 18 9 0 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          
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  
116 hodesch01 1871 1 CH1   SS 1 1 9 1 1 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          
127 kingma01 1871 1 CH1   3B 1 0 12 1 1 0 0          
133 kohlehe01 1871 1 FW1   3B 1 1 24 4 0 1 0          
136 lennobi01 1871 1 FW1   OF 1 0 12 0 0 1 0          
140 leonaan01 1871 1 WS3   SS 1 1 24 2 3 2 0          
142 mackde01 1871 1 RC1   OF 1 0 12 1 0 0 0          
144 mackde01 1871 1 RC1   SS 1 1 18 1 2 1 0          
153 mcmuljo01 1871 1 TRO   SS 1 0 6 0 1 0 1          
154 mcveyca01 1871 1 BS1   3B 1 0 6 0 0 0 0          
158 meyerle01 1871 1 PH1   P 1 0 3 0 1 0 0          
159 millsch01 1871 1 NY2   3B 1 0 6 1 0 0 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          
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          
203 suttoez01 1871 1 CL1   C 1 0 6 0 0 1 0 7   0 0  
209 whitede01 1871 1 CL1   2B 1 1 9 2 0 0 0          
210 whitede01 1871 1 CL1   3B 1 0 6 0 1 0 0          
212 whitede01 1871 1 CL1   OF 1 0 6 0 0 0 0          
216 whitewa01 1871 1 WS3   2B 1 1 18 1 1 0 0          
217 woltery01 1871 1 NY2   3B 1 0 12 0 2 1 0          
220 wrighge01 1871 1 BS1   1B 1 1 24 9 1 0 1          
224 wrighha01 1871 1 BS1   SS 1 1 18 0 3 2 0          
232 allisan01 1872 1 BR1   OF 1 0 30 0 0 2 0          
235 allisbi01 1872 1 BR1   2B 1 1 36 1 4 2 0          
238 allisdo01 1872 1 TRO   SS 1 1 18 1 2 0 0          
242 barloto01 1872 1 BR2   3B 1 0 6 0 0 0 0          
247 barrebi01 1872 1 WS3   C 1 0 27 2 0 3 0 4   0 0  
253 beaveed01 1872 1 BR2   OF 1 0 12 0 0 1 0          
254 beaveed01 1872 1 BR2   SS 1 0 21 1 2 2 0          
255 bechtge01 1872 1 NY2   1B 1 1 30 6 0 3 0          
263 besti01 1872 1 BR1   SS 1 0 9 1 1 0 0          
269 boothed01 1872 2 BR2   2B 1 1 36 2 5 1 1          
271 boydbi01 1872 1 NY2   2B 1 0 24 3 2 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          
287 careyto01 1872 1 BL1   1B 1 1 21 5 0 1 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          
303 clintji01 1872 1 BR1   P 1 0 27 0 4 1 0          
305 coughde01 1872 1 WS4   1B 1 1 12 2 0 1 0          
306 coughde01 1872 1 WS4   2B 1 1 27 0 4 2 0          
308 coughde01 1872 1 WS4   SS 1 1 33 2 3 3 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  
325 fieldge01 1872 1 MID   SS 1 1 33 2 4 1 0          
341 galvijo01 1872 1 BR2   2B 1 1 24 1 0 4 0          
345 glennjo01 1872 2 WS4   OF 1 1 27 2 0 1 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          
359 hatfijo01 1872 1 NY2   1B 1 0 33 10 0 0 0          
364 higby01 1872 1 BR2   OF 1 1 36 2 0 1 0          
365 highadi01 1872 1 BL1   1B 1 1 42 9 0 3 0          
372 hinespa01 1872 1 WS4   C 1 0 21 2 1 1 0 0   0 0  
373 hodesch01 1872 1 TRO   3B 1 1 30 3 1 1 0          
383 jackssa01 1872 1 BR2   2B 1 0 6 0 0 1 0          
384 jackssa01 1872 1 BR2   3B 1 0 9 0 1 3 0          
393 lennobi01 1872 1 WS4   1B 1 0 24 7 0 1 0          
398 leonaan01 1872 1 BS1   SS 1 0 6 0 0 0 0          
421 mcdonja01 1872 2 BR1   SS 1 1 27 0 2 4 0          
424 mcgeami01 1872 1 PH1   OF 1 1 36 2 1 0 0          
428 mcveyca01 1872 1 BS1   3B 1 0 12 0 2 0 0          
431 meyerle01 1872 1 PH1   3B 1 1 27 3 2 0 1          

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
);