11,067 rows where stint = 1 sorted by playerID

View and edit SQL

stint

  • 1 · 11,067
Link rowid playerID ▼ yearID stint Glf Gcf Grf
11738 aaronha01 1954 1 105 0 11
11875 aaronha01 1955 1 26 0 105
3909 abbated01 1898 1 0 0 1
4869 abbated01 1905 1 0 1 0
5447 abbated01 1909 1 0 1 0
3343 abbeych01 1893 1 31 0 0
3470 abbeych01 1894 1 54 74 0
3585 abbeych01 1895 1 3 98 31
3695 abbeych01 1896 1 2 11 65
3796 abbeych01 1897 1 2 1 77
5606 abbotod01 1910 1 0 21 0
10776 aberscl01 1947 1 40 0 0
10903 aberscl01 1948 1 8 0 0
11033 aberscl01 1949 1 0 0 1
11034 abramca01 1949 1 7 0 0
11173 abramca01 1950 1 9 1 5
11305 abramca01 1951 1 34 0 0
11456 abramca01 1952 1 1 0 0
11610 abramca01 1953 1 0 0 112
11739 abramca01 1954 1 5 3 5
11876 abramca01 1955 1 13 58 46
5010 abstebi01 1906 1 0 0 2
6052 acostme01 1913 1 5 1 1
6219 acostme01 1914 1 15 4 5
6458 acostme01 1915 1 22 2 29
6678 acostme01 1916 1 4 0 0
10628 adamsbo03 1946 1 0 0 2
11306 adamsbo03 1951 1 0 0 1
10222 adamsbu01 1943 1 0 6 0
10352 adamsbu01 1944 1 0 151 0
10488 adamsbu01 1945 1 13 0 0
10629 adamsbu01 1946 1 24 35 0
10777 adamsbu01 1947 1 6 1 44
10778 adamsdi01 1947 1 1 0 2
658 adamsge01 1879 1 0 2 0
10904 adamshe01 1948 1 0 2 2
11035 adamshe01 1949 1 14 33 1
11174 adamshe01 1950 1 0 33 0
7672 adamssp01 1923 1 0 0 1
8342 adamssp01 1928 1 0 0 1
8475 adamssp01 1929 1 2 0 0
11175 adcocjo01 1950 1 75 0 0
11307 adcocjo01 1951 1 107 0 0
11458 adcocjo01 1952 1 85 0 0
11176 addisbo01 1950 1 2 1 4
11308 addisbo01 1951 1 31 10 5
11459 addisbo01 1952 1 3 42 37
11611 addisbo01 1953 1 0 1 2
324 addybo01 1875 1 0 1 67
473 addybo01 1876 1 3 0 29
550 addybo01 1877 1 0 1 56
10353 aderhmo01 1944 1 11 0 2
10490 aderhmo01 1945 1 7 0 1
3586 adkinhe01 1895 1 1 0 0
6220 aglerjo01 1914 1 44 5 6
6459 aglerjo01 1915 1 6 3 11
5907 aitonge01 1912 1 4 2 0
1242 akejo01 1884 1 2 0 1
10224 alenoch01 1943 1 2 0 0
8728 alexada01 1931 1 4 0 0
9459 alexahu01 1937 1 1 0 3
1243 alexani01 1884 1 0 2 0
6221 alexape01 1914 1 1 0 0
3797 allenbo01 1897 1 0 1 0
7149 allenbo02 1919 1 0 6 0
8083 allenet01 1926 1 5 0 4
8212 allenet01 1927 1 14 72 13
8343 allenet01 1928 1 1 128 0
8476 allenet01 1929 1 24 134 10
8599 allenet01 1930 1 1 13 1
8729 allenet01 1931 1 40 23 14
8853 allenet01 1932 1 11 13 0
8976 allenet01 1933 1 0 46 21
9089 allenet01 1934 1 87 47 16
9214 allenet01 1935 1 19 136 1
9335 allenet01 1936 1 11 16 6
9460 allenet01 1937 1 12 54 14
9583 allenet01 1938 1 2 5 0
66 allenha01 1872 1 4 3 2
7150 allenho01 1919 1 1 1 0
659 allenja01 1879 1 0 0 3
2126 allenmy01 1887 1 73 1 41
2326 allenmy01 1888 1 33 2 0
67 allisan01 1872 1 0 0 1
1 allisar01 1871 1 0 29 0
68 allisar01 1872 1 0 17 2
166 allisar01 1873 1 8 9 4
325 allisar01 1875 1 0 1 2
474 allisar01 1876 1 0 0 23
69 allisbi01 1872 1 0 1 1
167 allisdo01 1873 1 0 1 2
244 allisdo01 1874 1 0 3 44
327 allisdo01 1875 1 0 0 2
475 allisdo01 1876 1 0 1 5
1049 allisdo01 1883 1 0 1 0
6053 allismi01 1913 1 0 1 0
6679 allismi01 1916 1 1 0 4
6843 allismi01 1917 1 4 5 2
8977 almadme01 1933 1 7 6 0
9090 almadme01 1934 1 0 16 7

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "FieldingOF" (
"playerID" TEXT,
  "yearID" INTEGER,
  "stint" INTEGER,
  "Glf" INTEGER,
  "Gcf" INTEGER,
  "Grf" INTEGER
);