47,628 rows sorted by W

View and edit SQL

Link rowid playerID yearID stint teamID lgID W ▼ L G GS CG SHO SV IPouts H ER HR BB SO BAOpp ERA IBB WP HBP BK BFP GF R SH SF GIDP
3 fergubo01 1871 1 NY2   0 0 1 0 0 0 0 3 8 3 0 0 0   27.0   2   0 14 0 9      
5 fleetfr01 1871 1 NY2   0 1 1 1 1 0 0 27 20 10 0 3 0   10.0   0   0 57 0 21      
6 flowedi01 1871 1 TRO   0 0 1 0 0 0 0 3 1 0 0 0 0   0.0   0   0 3 1 0      
7 mackde01 1871 1 RC1   0 1 3 1 1 0 0 39 20 5 0 3 1   3.46   1   0 70 1 30      
11 meyerle01 1871 1 PH1   0 0 1 0 0 0 0 3 1 1 0 2 0   9.0   1   0 6 1 1      
12 paborch01 1871 1 CL1   0 2 7 1 1 0 0 88 50 22 4 6 0   6.75   2   0 160 5 53      
22 brainas01 1872 2 MID   0 2 2 2 1 0 0 24 13 5 1 0 0   5.63   0   0 50 0 17      
25 clintji01 1872 1 BR1   0 1 1 1 1 0 0 27 25 7 1 1 1   7.0   0   0 68 0 36      
28 malonma01 1872 1 BR1   0 2 2 2 2 0 0 54 51 21 1 4 0   10.5   0   0 119 0 50      
33 mcderjo01 1872 1 BR1   0 7 7 7 7 0 0 189 143 57 3 14 1   8.14   17   0 394 0 144      
35 orour01 1872 1 BR1   0 1 1 1 1 0 0 27 16 8 0 2 0   8.0   1   0 51 0 15      
39 stearbi01 1872 1 WS4   0 11 11 11 11 0 0 297 193 68 2 3 2   6.18   2   0 572 0 190      
44 bechtge01 1873 1 PH2   0 2 3 2 1 0 0 48 27 8 0 2 0   4.5   0   0 87 1 24      
49 fergubo01 1873 1 BR2   0 1 4 1 1 0 0 58 41 12 2 2 0   5.59   0   0 109 3 30      
51 fleetfr01 1873 1 ELI   0 3 3 3 2 0 0 72 57 14 0 0 1   5.25   0   0 141 0 47      
53 frencbi01 1873 1 BL4   0 1 1 1 1 0 0 27 30 12 0 0 0   12.0   0   0 65 0 27      
54 fulmech01 1873 1 PH2   0 0 2 0 0 0 0 15 7 2 0 1 0   3.6   0   0 24 2 4      
56 lovetle01 1873 1 ELI   0 1 1 1 1 0 0 27 22 7 0 1 1   7.0   0   0 56 0 16      
57 martiph01 1873 1 NY2   0 1 6 1 1 0 0 102 50 13 0 6 1   3.44   1   0 177 5 37      
60 mcdoo01 1873 1 BL4   0 1 1 1 1 0 0 27 18 3 0 0 0   3.0   0   0 59 0 24      
62 selmafr01 1873 1 BL4   0 1 1 1 1 0 0 27 21 8 0 0 0   8.0   0   0 60 0 26      
65 strated01 1873 1 BL4   0 3 3 3 3 0 0 81 75 25 1 1 0   8.33   0   0 183 0 75      
66 woltery01 1873 1 ELI   0 1 1 1 1 0 0 27 13 0 0 1 1   0.0   0   0 60 0 23      
74 fergubo01 1874 1 BR2   0 1 1 1 1 0 0 27 12 4 0 3 0   4.0   0   0 47 0 10      
76 forceda01 1874 1 CH2   0 0 1 0 0 0 0 21 22 12 4 0 0   15.43   0   0 51 1 24      
77 hatfijo01 1874 1 NY2   0 1 3 0 0 0 0 24 11 2 0 0 0   2.25   0   0 35 3 6      
81 ryanjo01 1874 1 BL1   0 0 1 0 0 0 0 10 13 6 0 0 0   16.2   1   0 23 0 8      
84 wrighha01 1874 1 BS1   0 2 6 2 0 0 3 50 24 4 0 4 0   2.16   0   0 78 4 13      
86 arundha01 1875 1 BR2   0 1 1 1 0 0 0 7 6 2 0 0 0   7.71   0   0 15 0 6      
92 boydbi01 1875 1 BR2   0 0 1 0 0 0 0 5 4 0 0 0 0   0.0   1   0 9 1 3      
98 edwar01 1875 1 BR2   0 1 1 1 0 0 0 6 4 1 0 0 0   4.5   1   0 13 0 6      
99 fergubo01 1875 1 HR1   0 0 1 0 0 0 0 6 9 5 1 0 0   22.5   1   0 15 0 7      
102 fleetfr01 1875 2 BR2   0 1 2 1 1 0 0 46 26 8 0 0 0   4.7   1   0 78 0 20      
107 heifefr01 1875 1 BS1   0 0 2 0 0 0 1 7 6 4 0 0 0   15.43   0   0 13 1 4      
112 masonch01 1875 2 WS6   0 0 1 0 0 0 0 6 3 1 0 1 0   4.5   0   0 11 1 2      
115 mcmuljo01 1875 1 PH2   0 0 4 0 0 0 0 34 32 10 0 1 0   7.94   3   0 70 3 23      
119 oneilj01 1875 1 BR2   0 4 5 4 3 0 0 102 59 19 3 0 0   5.03   2   0 172 1 45      
120 paborch01 1875 1 BR2   0 1 1 1 0 0 0 12 11 4 0 1 0   9.0   0   0 28 0 12      
122 parksbi01 1875 2 PH2   0 0 2 0 0 0 0 16 13 5 0 1 0   8.44   1   0 32 1 11      
123 pearcdi01 1875 1 SL2   0 0 2 0 0 0 0 16 10 2 0 0 0   3.38   0   0 30 1 11      
127 suttoez01 1875 1 PH1   0 0 2 0 0 0 0 18 14 7 0 0 0   10.5   1   0 34 2 13      
129 withech01 1875 1 WS6   0 1 1 1 0 0 0 3 4 2 0 0 0   18.0   0   0 9 0 5      
130 wrighge01 1875 1 BS1   0 1 2 0 0 0 0 12 5 3 0 0 0   6.75   0   0 17 1 3      
133 barnero01 1876 1 CHN NL 0 0 1 0 0 0 0 4 7 3 0 0 0   20.25   0   0 13 0 8      
134 blongjo01 1876 1 SL3 NL 0 0 1 0 0 0 0 12 2 0 0 1 0   0.0   0   0 14 1 0      
136 bootham01 1876 1 CN1 NL 0 1 3 1 0 0 0 29 22 10 0 0 0   9.31   0   0 51 1 18      
137 boothed01 1876 1 NY3 NL 0 0 1 0 0 0 0 15 16 6 0 0 0   10.8   0   0 34 1 10      
141 clackbo01 1876 1 CN1 NL 0 0 1 0 0 0 0 6 2 1 0 0 0   4.5   0   0 8 1 1      
142 clintji01 1876 1 LS1 NL 0 1 1 1 1 0 0 27 12 6 0 0 1   6.0   2   0 43 0 11      
143 coonwi01 1876 1 PHN NL 0 0 2 0 0 0 0 21 9 4 0 0 0   5.14   0   0 35 2 8      
148 gouldch01 1876 1 CN1 NL 0 0 2 0 0 0 0 13 10 0 0 0 0   0.0   0   0 25 1 9      
150 laffefl01 1876 1 PHN NL 0 1 1 1 1 0 0 27 5 0 0 0 0   0.0   0   0 33 0 3      
151 larkite01 1876 1 NY3 NL 0 1 1 1 1 0 0 27 9 3 0 0 0   3.0   0   0 39 0 7      
154 mcbridi01 1876 1 BSN NL 0 4 4 4 3 0 0 99 53 10 1 5 2   2.73   1   0 155 0 35      
156 meyerle01 1876 1 PHN NL 0 2 2 2 2 0 0 54 28 10 0 1 0   5.0   6   0 84 0 23      
158 pearcfr01 1876 1 LS1 NL 0 0 1 0 0 0 0 12 5 2 0 1 1   4.5   2   0 20 1 4      
159 peterjo01 1876 1 CHN NL 0 0 1 0 0 0 1 3 1 0 0 1 0   0.0   0   0 5 1 1      
160 piersda01 1876 1 CN1 NL 0 1 1 1 0 0 0 0 2 2 1 0 0       0   0 2 0 2      
161 ryanjo01 1876 1 LS1 NL 0 0 1 0 0 0 0 24 22 5 0 0 1   5.63   7   0 49 1 20      
163 whitede01 1876 1 CHN NL 0 0 1 0 0 0 1 6 1 0 0 0 3   0.0   0   0 7 1 0      
165 wrighge01 1876 1 BSN NL 0 0 1 0 0 0 0 3 1 0 0 0 1   0.0   1   0 4 1 0      
167 battijo01 1877 1 SL3 NL 0 0 1 0 0 0 0 11 3 2 0 1 1   4.91   1   0 16 1 2      
177 mannija01 1877 1 CN1 NL 0 4 10 4 2 0 1 132 83 34 1 7 6   6.95   11   0 226 6 65      
183 roweda01 1877 1 CHN NL 0 1 1 1 0 0 0 3 3 2 0 2 0   18.0   0   0 7 0 2      
186 allisdo01 1878 1 PRO NL 0 0 1 0 0 0 0 15 11 1 0 1 0   1.8   0   0 26 1 5      
188 brownle01 1878 1 PRO NL 0 0 1 0 0 0 0 3 0 2 0 4 0   18.0   2   0 8 0 4      
190 ellicjo01 1878 1 ML2 NL 0 1 1 0 0 0 0 9 1 1 0 1 0   3.0   1   0 11 1 1      
191 fishech01 1878 1 PRO NL 0 1 1 1 1 0 0 27 14 4 0 0 2   4.0   1   0 46 0 12      
193 hankifr01 1878 1 CHN NL 0 1 1 1 1 0 0 27 11 6 0 0 4   6.0   1   0 39 0 9      
194 healeto01 1878 1 PRO NL 0 3 3 3 3 0 0 72 27 8 1 7 2   3.0   6   0 104 0 17      
199 mckelru01 1878 1 IN1 NL 0 2 4 1 1 0 0 75 38 6 1 3 3   2.16   3   0 121 3 23      
210 broutda01 1879 1 TRN NL 0 2 3 2 2 0 0 63 35 13 0 8 6   5.57   4   0 110 1 30      
211 dorgami01 1879 1 SR1 NL 0 0 2 0 0 0 0 36 13 3 0 2 8   2.25   2   0 52 0 6      
214 gardngi01 1879 1 TRN NL 0 2 2 2 2 0 0 42 27 9 0 0 3   5.79   7   0 74 0 21      
222 mcmanpa01 1879 1 TRN NL 0 2 2 2 2 0 0 63 24 7 1 1 6   3.0   2   0 94 0 21      
223 mcveyca01 1879 1 CN1 NL 0 2 3 1 1 0 0 42 34 13 1 2 7   8.36   3   0 77 1 23      
225 neaglja01 1879 1 CN1 NL 0 1 2 2 1 0 0 39 13 5 0 5 4   3.46   1   0 59 0 12      
227 purcebl01 1879 2 CN1 NL 0 2 2 2 2 0 0 54 27 8 0 2 3   4.0   3   0 78 0 15      
232 wheelha01 1879 1 CN1 NL 0 1 1 1 0 0 0 3 6 9 0 4 0   81.0   1   0 13 0 10      
236 burnsto01 1880 1 CHN NL 0 0 1 0 0 0 0 4 2 0 0 2 1   0.0   0   0 10 0 4      
239 dorgami01 1880 1 PRO NL 0 0 1 0 0 0 0 24 4 1 0 0 2   1.13   0   0 29 1 3      
241 evansja01 1880 1 TRN NL 0 0 1 0 0 0 0 12 11 6 0 0 0   13.5   0   0 21 1 8      
248 hornujo01 1880 1 BFN NL 0 0 1 0 0 0 0 9 2 2 0 1 0   6.0   1   0 13 1 2      
250 kellyki01 1880 1 CHN NL 0 0 1 0 0 0 0 9 3 0 0 1 1   0.0   0   0 13 1 2      
251 larkite01 1880 1 TRN NL 0 5 5 5 3 0 0 114 83 37 1 10 5   8.76   9   0 207 0 65      
252 learyja01 1880 1 BSN NL 0 1 1 1 0 0 0 9 8 5 0 0 1   15.0   0   0 11 0 5      
255 morrijo01 1880 1 BSN NL 0 0 3 0 0 0 0 32 9 1 0 1 0   0.84   0   0 34 2 3      
257 nichotr01 1880 1 WOR NL 0 2 2 2 2 0 0 53 29 8 0 4 4   4.08   1   0 85 0 16      
262 stoveha01 1880 1 WOR NL 0 0 2 0 0 0 0 18 8 3 0 3 3   4.5   0   0 29 2 4      
266 wiedmst01 1880 1 BFN NL 0 9 17 13 9 0 0 341 141 43 1 9 25   3.4   9   0 493 4 77      
267 bondto01 1881 1 BSN NL 0 3 3 3 2 0 0 76 40 12 3 2 2   4.26   3   0 113 1 17      
277 learyja01 1881 1 DTN NL 0 2 2 2 1 0 0 39 13 6 0 2 2   4.15   0   0 53 0 6      
283 morrijo01 1881 1 BSN NL 0 1 3 0 0 0 1 17 9 4 0 1 0   6.35   0   0 28 2 8      
290 taylobi01 1881 1 WOR NL 0 1 1 1 1 0 0 24 15 7 0 6 0   7.88   2   0 47 0 13      
291 taylobi01 1881 3 CL2 NL 0 0 1 0 0 0 0 9 0 0 0 1 2   0.0   0   0 10 1 0      
294 whitewi01 1881 1 DTN NL 0 2 2 2 2 0 0 54 24 10 0 2 5   5.0   1   0 83 0 18      
300 bondto01 1882 1 WOR NL 0 1 2 2 0 0 0 37 12 6 0 7 2   4.38   1   0 62 0 13      
302 browned01 1882 1 SL4 AA 0 0 1 0 0 0 0 6 2 0 0 0 1   0.0   0   0 8 1 1      
303 brownto01 1882 1 BL2 AA 0 0 2 0 0 0 0 25 13 1 0 6 2   1.08   4   0 45 2 7      
305 burkeja01 1882 1 BFN NL 0 1 1 1 0 0 0 12 10 5 0 0 0   11.25   0   0 23 0 9      

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Pitching" (
"playerID" TEXT,
  "yearID" INTEGER,
  "stint" INTEGER,
  "teamID" TEXT,
  "lgID" REAL,
  "W" INTEGER,
  "L" INTEGER,
  "G" INTEGER,
  "GS" INTEGER,
  "CG" INTEGER,
  "SHO" INTEGER,
  "SV" INTEGER,
  "IPouts" INTEGER,
  "H" INTEGER,
  "ER" INTEGER,
  "HR" INTEGER,
  "BB" INTEGER,
  "SO" INTEGER,
  "BAOpp" REAL,
  "ERA" REAL,
  "IBB" INTEGER,
  "WP" INTEGER,
  "HBP" INTEGER,
  "BK" INTEGER,
  "BFP" INTEGER,
  "GF" INTEGER,
  "R" INTEGER,
  "SH" INTEGER,
  "SF" INTEGER,
  "GIDP" INTEGER
);