143,046 rows sorted by PO

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
11 ansonca01 1871 1 RC1   OF 1 1 6 0 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  
53 cravebi01 1871 1 TRO   OF 1 1 6 0 0 0 0          
60 duffyed01 1871 1 CH1   3B 1 1 6 0 0 1 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          
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          
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          
149 mcderjo01 1871 1 FW1   OF 2 2 39 0 1 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          
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          
177 pinkhed01 1871 1 CH1   P 3 0 30 0 2 1 0          
200 stearbi01 1871 1 WS3   P 2 2 54 0 5 1 0          
203 suttoez01 1871 1 CL1   C 1 0 6 0 0 1 0 7   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          
213 whitede01 1871 1 CL1   SS 2 1 27 0 3 2 0          
217 woltery01 1871 1 NY2   3B 1 0 12 0 2 1 0          
224 wrighha01 1871 1 BS1   SS 1 1 18 0 3 2 0          
228 allenha01 1872 1 MID   3B 5 0 12 0 3 0 0          
232 allisan01 1872 1 BR1   OF 1 0 30 0 0 2 0          
242 barloto01 1872 1 BR2   3B 1 0 6 0 0 0 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          
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          
297 clarede01 1872 1 BR2   2B 2 2 30 0 6 1 0          
303 clintji01 1872 1 BR1   P 1 0 27 0 4 1 0          
306 coughde01 1872 1 WS4   2B 1 1 27 0 4 2 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          
322 fergubo01 1872 1 BR2   C 1 0 6 0 0 0 0 1   0 0  
358 hastisc01 1872 2 BL1   OF 1 1 6 0 0 0 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          
398 leonaan01 1872 1 BS1   SS 1 0 6 0 0 0 0          
407 malonma01 1872 1 BR1   P 2 2 54 0 1 2 0          
421 mcdonja01 1872 2 BR1   SS 1 1 27 0 2 4 0          
428 mcveyca01 1872 1 BS1   3B 1 0 12 0 2 0 0          
445 orour01 1872 1 BR1   P 1 1 27 0 0 1 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          
485 spenc01 1872 1 WS4   SS 1 1 24 0 3 4 0          
516 yeatmbi01 1872 1 WS4   OF 1 1 21 0 0 1 0          
530 allisdo01 1873 2 NY2   OF 1   6 0 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          
551 bellast01 1873 1 NY2   2B 3   6 0 1 0 0          
560 brainas01 1873 1 BL1   2B 1   15 0 2 1 0          
561 brainas01 1873 1 BL1   OF 2   6 0 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          
576 careyto01 1873 1 BL1   SS 3   57 0 11 2 0          
577 clappjo01 1873 1 PH1   2B 1   18 0 2 2 0          
579 clappjo01 1873 1 PH1   OF 1   6 0 0 0 0          
590 dehlmhe01 1873 1 BR2   SS 1   6 0 1 0 0          
596 donnejo01 1873 1 WS5   3B 1   6 0 0 0 0          
600 eggleda01 1873 1 NY2   3B 1   6 0 0 1 0          
606 farrojo01 1873 1 ELI   SS 1   21 0 2 2 0          
608 fergubo01 1873 1 BR2   P 4   57 0 4 1 0          
621 forceda01 1873 1 BL1   P 3   54 0 2 2 0          
626 frencbi01 1873 1 BL4   P 1   27 0 0 0 0          
628 fulmech01 1873 1 PH2   C 1   6 0 0 0 0 2   0 0  
642 hatfijo01 1873 1 NY2   OF 1   6 0 0 0 0          
655 johnsto01 1873 1 BL4   OF 1   24 0 0 1 0          
663 kohlehe01 1873 1 BL4   OF 1   6 0 0 0 0          
672 lovetle01 1873 1 ELI   P 1   27 0 1 1 0          
682 martiph01 1873 1 NY2   P 6   102 0 3 3 0          
687 mcdoo01 1873 1 BL4   P 1   27 0 4 1 0          
688 mcgeami01 1873 1 PH1   3B 1   6 0 0 0 0          
692 mcmuljo01 1873 1 PH1   P 1   24 0 3 1 0          
700 meyerle01 1873 1 PH2   SS 1   6 0 0 0 0          
711 nevinal01 1873 1 ELI   2B 1   6 0 1 0 0          
719 pearcdi01 1873 1 BR2   2B 1   6 0 0 1 0          
722 phelpne01 1873 1 NY2   OF 1   6 0 0 0 0          
725 popplge01 1873 1 BL4   3B 1   9 0 1 1 0          
741 selmafr01 1873 1 BL4   P 1   27 0 0 1 0          
758 startjo01 1873 1 NY2   OF 2   6 0 0 0 0          
760 strated01 1873 1 BL4   OF 1   6 0 0 0 0          
761 strated01 1873 1 BL4   P 3   81 0 3 3 0          
768 wallho01 1873 1 WS5   SS 1   15 0 0 1 0          
776 woltery01 1873 1 ELI   P 1   27 0 2 0 0          
789 addybo01 1874 1 HR1   SS 1 1 12 0 1 2 0          
795 ansonca01 1874 1 PH1   C 1 0 3 0 0 0 0 0   0 0  
803 barnibi01 1874 1 HR1   SS 1 1 6 0 0 2 0          
813 boardfr01 1874 1 BL1   OF 1 1 3 0 0 0 0          
821 bradyst01 1874 1 HR1   SS 1 0 6 0 0 1 0          
837 clappjo01 1874 1 PH1   SS 1 0 6 0 1 0 0          
839 clintji01 1874 1 BR2   OF 1 1 6 0 0 0 0          
841 collida01 1874 1 CH2   P 2 2 33 0 5 0 0          
847 cummica01 1874 1 PH2   OF 1 0 3 0 0 0 0          
853 deaneha01 1874 1 BL1   SS 1 0 18 0 1 1 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
);