143,046 rows sorted by playerID

View and edit SQL

Suggested facets: ZR

Link rowid playerID ▼ yearID stint teamID lgID POS G GS InnOuts PO A E DP PB WP SB CS ZR
113393 aardsda01 2004 1 SFN NL P 11 0 32 0 0 0 0          
116801 aardsda01 2006 1 CHN NL P 45 0 159 1 5 0 1          
118557 aardsda01 2007 1 CHA AL P 25 0 97 2 4 1 0          
120339 aardsda01 2008 1 BOS AL P 47 0 146 3 6 0 0          
122115 aardsda01 2009 1 SEA AL P 73 0 214 2 5 0 1          
123878 aardsda01 2010 1 SEA AL P 53 0 149 2 3 1 0          
127429 aardsda01 2012 1 NYA AL P 1 0 3 0 0 0 0          
129272 aardsda01 2013 1 NYN NL P 43 0 119 1 5 0 0          
132951 aardsda01 2015 1 ATL NL P 33 0 92 0 1 1 0          
51474 aaronha01 1954 1 ML1 NL OF 116 113 3093 223 5 7 0          
52171 aaronha01 1955 1 ML1 NL 2B 27 26 709 86 84 6 23          
52172 aaronha01 1955 1 ML1 NL OF 126 125 3329 254 9 9 2          
52972 aaronha01 1956 1 ML1 NL OF 152 152 4048 316 17 13 4          
53745 aaronha01 1957 1 ML1 NL OF 150 150 4069 346 9 6 0          
54522 aaronha01 1958 1 ML1 NL OF 153 153 4083 305 12 5 0          
55326 aaronha01 1959 1 ML1 NL 3B 5 5 126 2 10 0 0          
55327 aaronha01 1959 1 ML1 NL OF 152 149 3980 261 12 5 3          
56125 aaronha01 1960 1 ML1 NL 2B 2 0 6 1 0 0 0          
56126 aaronha01 1960 1 ML1 NL OF 153 153 4129 320 13 6 6          
56902 aaronha01 1961 1 ML1 NL 3B 2 0 27 2 2 0 0          
56903 aaronha01 1961 1 ML1 NL OF 154 154 4101 377 13 7 3          
57774 aaronha01 1962 1 ML1 NL 1B 1 0 3 1 0 0 0          
57775 aaronha01 1962 1 ML1 NL OF 153 153 4019 340 11 7 1          
58730 aaronha01 1963 1 ML1 NL OF 161 161 4338 267 10 6 1          
59695 aaronha01 1964 1 ML1 NL 2B 11 8 186 14 15 1 2          
59696 aaronha01 1964 1 ML1 NL OF 139 134 3514 270 13 5 5          
60661 aaronha01 1965 1 ML1 NL OF 148 148 3928 298 9 4 2          
61637 aaronha01 1966 1 ATL NL 2B 2 0 9 0 0 0 0          
61638 aaronha01 1966 1 ATL NL OF 158 157 4066 315 12 4 5          
62631 aaronha01 1967 1 ATL NL 2B 1 0 3 1 0 0 0          
62632 aaronha01 1967 1 ATL NL OF 152 152 4044 321 12 7 3          
63640 aaronha01 1968 1 ATL NL 1B 14 14 309 88 7 2 8          
63641 aaronha01 1968 1 ATL NL OF 151 143 3874 330 13 3 2          
64619 aaronha01 1969 1 ATL NL 1B 4 3 78 32 2 0 3          
64620 aaronha01 1969 1 ATL NL OF 144 142 3743 267 11 5 3          
65852 aaronha01 1970 1 ATL NL 1B 11 10 243 73 4 1 6          
65853 aaronha01 1970 1 ATL NL OF 125 125 3180 246 6 6 1          
67098 aaronha01 1971 1 ATL NL 1B 71 70 1845 629 38 3 56          
67099 aaronha01 1971 1 ATL NL OF 60 59 1548 104 2 2 0          
68287 aaronha01 1972 1 ATL NL 1B 109 106 2796 968 66 14 79          
68288 aaronha01 1972 1 ATL NL OF 15 15 354 28 4 3 0          
69478 aaronha01 1973 1 ATL NL OF 105 105 2573 206 5 5 0          
70645 aaronha01 1974 1 ATL NL OF 89 89 1992 142 3 2 0          
71842 aaronha01 1975 1 ML4 AL OF 3 3 63 2 0 0 0          
73018 aaronha01 1976 1 ML4 AL OF 1 0 6 1 0 0 0          
57776 aaronto01 1962 1 ML1 NL 1B 110 39 1507 507 45 6 55          
57777 aaronto01 1962 1 ML1 NL 2B 1 0 3 0 1 0 0          
57778 aaronto01 1962 1 ML1 NL 3B 1 0 3 0 1 0 1          
57779 aaronto01 1962 1 ML1 NL OF 42 35 880 65 1 4 0          
58731 aaronto01 1963 1 ML1 NL 1B 45 14 620 197 9 0 26          
58732 aaronto01 1963 1 ML1 NL 2B 6 3 93 12 8 0 2          
58733 aaronto01 1963 1 ML1 NL 3B 1 1 15 1 1 0 0          
58734 aaronto01 1963 1 ML1 NL OF 14 10 232 11 0 1 0          
60662 aaronto01 1965 1 ML1 NL 1B 6 4 117 45 4 2 3          
63642 aaronto01 1968 1 ATL NL 1B 28 19 575 209 17 0 12          
63643 aaronto01 1968 1 ATL NL 3B 1 0 3 0 0 0 0          
63644 aaronto01 1968 1 ATL NL OF 62 51 1376 78 3 5 1          
64621 aaronto01 1969 1 ATL NL 1B 16 2 162 48 2 0 5          
64622 aaronto01 1969 1 ATL NL OF 8 6 172 17 0 0 0          
65854 aaronto01 1970 1 ATL NL 1B 16 3 153 40 2 2 1          
65855 aaronto01 1970 1 ATL NL OF 12 9 213 13 0 0 0          
67100 aaronto01 1971 1 ATL NL 1B 11 6 219 70 6 2 16          
67101 aaronto01 1971 1 ATL NL 3B 7 4 129 4 13 0 2          
74196 aasedo01 1977 1 BOS AL P 13 13 277 5 13 1 0          
75486 aasedo01 1978 1 CAL AL P 29 29 536 16 26 3 2          
76718 aasedo01 1979 1 CAL AL P 37 28 556 8 17 2 3          
77956 aasedo01 1980 1 CAL AL P 40 21 525 10 22 4 2          
79218 aasedo01 1981 1 CAL AL P 39 0 196 2 10 1 1          
80418 aasedo01 1982 1 CAL AL P 24 0 156 3 5 0 0          
82976 aasedo01 1984 1 CAL AL P 23 0 117 1 5 1 0          
84279 aasedo01 1985 1 BAL AL P 54 0 264 8 10 0 0          
85552 aasedo01 1986 1 BAL AL P 66 0 245 5 12 1 1          
86908 aasedo01 1987 1 BAL AL P 7 0 24 0 1 0 0          
88303 aasedo01 1988 1 BAL AL P 35 0 140 2 3 0 1          
89692 aasedo01 1989 1 NYN NL P 49 0 178 6 8 0 0          
91124 aasedo01 1990 1 LAN NL P 32 0 114 1 3 0 0          
108259 abadan01 2001 1 OAK AL 1B 1 0 3 2 0 0 1          
111673 abadan01 2003 1 BOS AL 1B 7 3 114 35 1 1 2          
111674 abadan01 2003 1 BOS AL OF 1 1 21 0 0 0 0          
123879 abadfe01 2010 1 HOU NL P 22 0 57 0 3 0 0          
125629 abadfe01 2011 1 HOU NL P 29 0 59 1 2 2 0          
127430 abadfe01 2012 1 HOU NL P 37 6 138 3 6 0 0          
129273 abadfe01 2013 1 WAS NL P 39 0 113 1 4 0 0          
131090 abadfe01 2014 1 OAK AL P 69 0 172 0 8 0 0          
132952 abadfe01 2015 1 OAK AL P 62 0 143 2 4 0 0          
134883 abadfe01 2016 1 MIN AL P 39 0 102 0 3 0 1          
134884 abadfe01 2016 2 BOS AL P 18 0 38 0 1 0 0          
136836 abadfe01 2017 1 BOS AL P 48 0 131 0 6 0 1          
140922 abadfe01 2019 1 SFN NL P 21 0 39 0 0 0 0          
1047 abadijo01 1875 1 PH3   1B 11   291 122 3 12 1          
1048 abadijo01 1875 2 BR2   1B 1   21 7 0 1 0          
13136 abbated01 1897 1 PHI NL 2B 3   54 0 7 1 0          
13596 abbated01 1898 1 PHI NL 2B 4   81 9 6 2 0          
13597 abbated01 1898 1 PHI NL 3B 20   462 26 19 10 0          
13598 abbated01 1898 1 PHI NL OF 1   15 1 0 0 0          
16388 abbated01 1903 1 BSN NL 2B 116   3048 316 325 45 35          
16389 abbated01 1903 1 BSN NL SS 17   450 45 42 13 8          
17010 abbated01 1904 1 BSN NL SS 154 154 3978 367 473 78 47          
17628 abbated01 1905 1 BSN NL OF 1 1 12 1 0 0 0          
17629 abbated01 1905 1 BSN NL SS 152 152 4044 386 468 75 53          

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