143,046 rows sorted by E

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
39253 fordbi01 1936 1 BSN NL P 1     0 0   0          
4 allisar01 1871 1 CL1   2B 2 0 18 1 4 0 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  
22 battijo01 1871 1 CL1   OF 1 1 21 1 0 0 0          
23 bealsto01 1871 1 WS3   2B 2 2 57 9 7 0 1          
28 bechtge01 1871 1 PH1   P 3 3 78 1 7 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          
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          
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          
73 fleetfr01 1871 1 NY2   P 1 1 27 0 5 0 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          
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          
115 hodesch01 1871 1 CH1   OF 4 2 33 2 0 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          
127 kingma01 1871 1 CH1   3B 1 0 12 1 1 0 0          
134 kohlehe01 1871 1 FW1   C 2 0 6 0 0 0 0 1   0 0  
142 mackde01 1871 1 RC1   OF 1 0 12 1 0 0 0          
143 mackde01 1871 1 RC1   P 3 1 39 1 2 0 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          
161 millsch01 1871 1 NY2   OF 4 3 15 1 0 0 0          
165 nortofr01 1871 1 WS3   OF 1 0 6 0 0 0 0          
168 patteda01 1871 1 NY2   2B 2 1 27 1 5 0 1          
190 selmafr01 1871 1 FW1   C 5 1 60 9 2 0 0 5   0 0  
197 spaldal01 1871 1 BS1   OF 9 0 42 3 0 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          
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          
220 wrighge01 1871 1 BS1   1B 1 1 24 9 1 0 1          
228 allenha01 1872 1 MID   3B 5 0 12 0 3 0 0          
238 allisdo01 1872 1 TRO   SS 1 1 18 1 2 0 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          
263 besti01 1872 1 BR1   SS 1 0 9 1 1 0 0          
268 boothed01 1872 1 MID   OF 4 4 87 5 1 0 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          
277 brainas01 1872 2 MID   P 2 2 24 0 2 0 0          
280 burdoja01 1872 1 BR2   2B 2 0 27 3 3 0 0          
295 clappjo01 1872 1 MID   OF 1 0 12 1 0 0 0          
322 fergubo01 1872 1 BR2   C 1 0 6 0 0 0 0 1   0 0  
332 fleetfr01 1872 1 BR1   OF 2 2 21 1 0 0 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          
359 hatfijo01 1872 1 NY2   1B 1 0 33 10 0 0 0          
388 kavan01 1872 1 BR1   OF 2 2 18 1 0 0 0          
398 leonaan01 1872 1 BS1   SS 1 0 6 0 0 0 0          
414 mathebo01 1872 1 BL1   OF 8 2 18 1 0 0 0          
424 mcgeami01 1872 1 PH1   OF 1 1 36 2 1 0 0          
427 mcmuljo01 1872 1 NY2   P 3 1 45 1 4 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          
440 nelsoca01 1872 1 TRO   OF 3 3 90 7 0 0 0          
454 pearcdi01 1872 1 NY2   OF 2 2 24 2 0 0 0          
459 prattal01 1872 1 CL1   OF 8 4 21 1 0 0 0          
461 radcljo01 1872 1 BL1   2B 1 0 9 1 1 0 0          
476 senseco01 1872 1 PH1   OF 1 1 3 0 0 0 0          
478 simmojo01 1872 1 CL1   OF 3 3 9 0 0 0 0          
480 snydeji01 1872 1 BR1   OF 1 1 15 1 0 0 0          
483 spaldal01 1872 1 BS1   OF 7 0 18 1 0 0 0          
490 swandma01 1872 1 BR1   1B 1 1 30 13 1 0 0          
491 swandma01 1872 1 BR1   2B 2 1 21 4 1 0 0          
495 sweasch01 1872 1 CL1   OF 1 1 57 5 0 0 0          
496 thakeal01 1872 1 BR2   2B 1 0 12 3 0 0 0          
512 worthhe01 1872 1 BR2   OF 1 1 24 1 0 0 0          
520 zettlge01 1872 2 BR1   OF 1 0 30 1 1 0 1          
525 allisar01 1873 1 ELI   C 1   24 4 2 0 1 5   0 0  
528 allisdo01 1873 1 ELI   OF 4   21 1 0 0 0          
530 allisdo01 1873 2 NY2   OF 1   6 0 0 0 0          
536 atkined01 1873 1 WS5   OF 2   30 1 0 0 0          
538 barloto01 1873 1 BR2   2B 1   6 0 0 0 0          
543 barrebi01 1873 1 BL1   OF 1   6 0 0 0 0          
548 bealsto01 1873 1 WS5   OF 1   12 1 0 0 0          
551 bellast01 1873 1 NY2   2B 3   6 0 1 0 0          
561 brainas01 1873 1 BL1   OF 2   6 0 0 0 0          
563 brittji01 1873 1 BR2   OF 3   48 3 0 0 0          
566 burdoja01 1873 1 BR2   C 2   6 0 0 0 0 0   0 0  
568 campbhu01 1873 1 ELI   OF 1   6 0 0 0 0          
570 campbhu01 1873 1 ELI   SS 1   9 0 2 0 0          
572 campbmi02 1873 1 ELI   OF 1   45 4 0 0 0          
579 clappjo01 1873 1 PH1   OF 1   6 0 0 0 0          
585 cravebi01 1873 1 BL1   OF 7   105 10 0 0 0          
590 dehlmhe01 1873 1 BR2   SS 1   6 0 1 0 0          
593 devliji01 1873 1 PH2   OF 2   27 1 1 0 0          
596 donnejo01 1873 1 WS5   3B 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
);