47,628 rows sorted by L

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      
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      
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      
13 pinkhed01 1871 1 CH1   1 0 3 0 0 0 1 31 10 4 0 3 0   3.48   5   0 51 3 8      
16 stearbi01 1871 1 WS3   2 0 2 2 2 0 0 54 10 5 0 8 0   2.5   0   0 75 0 11      
18 wrighha01 1871 1 BS1   1 0 9 0 0 0 3 56 34 13 0 4 0   6.27   3   0 105 6 31      
34 mcmuljo01 1872 1 NY2   1 0 3 1 1 0 1 45 18 6 0 2 1   3.6   3   0 75 2 15      
41 wrighha01 1872 1 BS1   1 0 7 0 0 0 4 77 26 6 0 0 1   2.1   0   0 109 6 12      
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      
61 mcmuljo01 1873 1 PH1   1 0 1 1 1 0 0 24 10 2 0 1 2   2.25   0   0 34 0 5      
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      
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      
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      
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      
104 gedneco01 1875 1 NY2   1 0 2 1 1 0 0 33 7 1 0 1 2   0.82   2   0 43 1 4      
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      
108 knighge01 1875 1 NH1   1 0 1 1 1 0 0 27 12 3 0 0 0   3.0   0   0 41 0 6      
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      
116 mcveyca01 1875 1 BS1   1 0 3 2 0 0 1 33 15 6 0 1 1   4.91   2   0 52 1 9      
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      
128 weavesa01 1875 1 PH2   1 0 1 1 1 0 0 18 6 1 0 2 2   1.5   1   0 27 0 2      
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      
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      
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      
157 nichotr01 1876 1 BSN NL 1 0 1 1 1 0 0 27 7 1 0 0 0   1.0   0   0 35 0 5      
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      
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      
184 spaldal01 1877 1 CHN NL 1 0 4 1 0 0 1 33 17 4 0 0 2   3.27   0   0 53 2 12      
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      
197 mannija01 1878 1 BSN NL 1 0 3 1 1 0 0 34 24 18 1 5 2   14.29   4   0 66 1 19      
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      
228 richmle01 1879 1 BSN NL 1 0 1 1 1 0 0 27 4 2 0 1 11   2.0   1   0 36 0 6      
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      
246 guthch01 1880 1 CHN NL 1 0 1 1 1 0 0 27 12 5 0 1 7   5.0   4   0 42 0 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      
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      
259 poormto01 1880 2 CHN NL 2 0 2 1 0 0 0 45 12 4 0 8 0   2.4   0   0 67 1 5      
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      
280 mathebo01 1881 2 BSN NL 1 0 5 1 1 0 2 69 22 6 0 11 5   2.35   2   0 103 4 11      
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      
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      
310 critcmo01 1882 1 PT1 AA 1 0 1 1 1 1 0 27 7 0 0 1 3   0.0   0   0 36 0 0      
319 ewingbu01 1882 1 TRN NL 0 0 1 0 0 0 0 3 2 1 0 1 0   9.0   0   0 6 1 1      
320 foleycu01 1882 1 BFN NL 0 0 1 0 0 0 0 3 2 2 0 0 0   18.0   0   0 6 0 2      
331 learyja01 1882 1 PT1 AA 1 0 3 2 1 0 0 56 28 14 0 3 5   6.75   2   0 89 1 22      
338 morrijo01 1882 1 BSN NL 0 0 1 0 0 0 0 6 3 0 0 0 2   0.0   0   0 8 1 0      
350 robinya01 1882 1 DTN NL 0 0 1 0 0 0 0 6 0 0 0 1 0   0.0   0   0 8 1 0      
352 russjo01 1882 1 BL2 AA 0 0 1 0 0 0 0 9 3 1 0 1 0   3.0   0   0 13 1 1      
355 schenbi01 1882 1 LS2 AA 1 0 2 1 1 0 0 30 6 1 0 1 4   0.9   0   0 38 1 2      
357 snydege01 1882 1 PH4 AA 1 0 1 1 1 0 0 27 4 0 0 2 0   0.0   1   0 34 0 3      
358 striccu01 1882 1 PH4 AA 1 0 2 0 0 0 0 21 3 1 0 1 2   1.29   0   0 26 2 1      
369 willine01 1882 1 CHN NL 0 0 1 0 0 0 0 9 9 2 1 1 0   6.0   0   0 19 1 8      
371 wolfji01 1882 1 LS2 AA 0 0 1 0 0 0 0 18 11 6 0 3 1   9.0   2   0 33 1 11      
373 ansonca01 1883 1 CHN NL 0 0 2 0 0 0 1 9 1 0 0 1 0   0.0   0   0 12 2 1      
377 battijo01 1883 1 PT1 AA 0 0 2 0 0 0 0 12 9 1 0 1 0   2.25   0   0 22 1 4      
380 broutda01 1883 1 BFN NL 0 0 1 0 0 0 0 6 9 7 0 3 2   31.5   0   0 17 0 7      
383 burkeja01 1883 1 BFN NL 0 0 1 1 0 0 0 24 9 5 0 3 1   5.63   0   0 40 0 8      
394 dolanto01 1883 1 SL4 AA 0 0 1 0 0 0 0 12 4 2 0 0 0   4.5   0   0 16 1 3      
399 evansja01 1883 1 CL2 NL 0 0 1 0 0 0 0 9 0 0 0 0 1   0.0   0   0 9 1 0      
400 fergubo01 1883 1 PHI NL 0 0 1 0 0 0 0 3 2 1 0 0 0   9.0   0   0 7 1 2      
401 foleycu01 1883 1 BFN NL 1 0 1 0 0 0 0 3 0 0 0 4 0   0.0   0   0 6 1 0      
406 gardngi01 1883 1 BL2 AA 1 0 2 0 0 0 0 21 9 4 1 1 2   5.14   0   0 32 1 7      
415 huntele01 1883 1 CL2 NL 0 0 1 0 0 0 0 19 10 1 0 2 4   1.42   0   0 29 1 7      
419 kellyki01 1883 1 CHN NL 0 0 1 0 0 0 0 3 1 0 0 0 0   0.0   0   0 3 1 0      
422 manseto01 1883 1 DTN NL 0 0 1 0 0 0 0 20 21 12 2 5 3   16.2   1   0 43 1 18      
427 mcintfr01 1883 1 DTN NL 1 0 1 1 1 0 0 33 11 1 0 1 0   0.82   0   0 48 0 10      
429 mclaufr01 1883 1 PT1 AA 0 0 2 0 0 0 0 27 14 13 0 3 1   13.0   1   0 45 2 21      
430 morrijo01 1883 1 BSN NL 1 0 2 1 1 0 0 39 15 4 0 4 5   2.77   0   0 60 1 11      
439 orourji01 1883 1 BFN NL 0 0 2 0 0 0 1 21 10 5 0 1 1   6.43   1   0 29 1 9      
443 reccijo01 1883 1 LS2 AA 0 0 1 0 0 0 0 12 10 1 0 0 0   2.25   0   0 22 1 3      
445 roweda01 1883 1 BL2 AA 0 0 1 0 0 0 0 12 12 9 1 2 1   20.25   0   0 26 1 11      
449 smithpo01 1883 1 CL5 AA 0 0 3 0 0 0 0 17 10 4 0 0 0   6.35   0   0 28 3 7      
450 sommejo01 1883 1 CN2 AA 0 0 1 0 0 0 0 15 9 3 0 1 2   5.4   1   0 26 1 6      
451 stoveha01 1883 1 PH4 AA 0 0 1 0 0 0 0 9 5 3 0 0 4   9.0   2   0 14 1 3      
462 willine01 1883 1 CHN NL 0 0 1 0 0 0 0 3 1 1 0 1 1   9.0   0   0 7 0 2      
463 woodge01 1883 1 DTN NL 0 0 1 0 0 0 0 15 8 4 0 3 0   7.2   1   0 26 1 9      
464 andrufr01 1884 1 CHN NL 1 0 1 1 1 0 0 27 11 2 1 2 2   2.0   0   0 39 0 3      
466 arundha01 1884 1 PRO NL 1 0 1 1 1 0 0 27 8 1 0 4 4   1.0   1   0 36 0 2      
477 bastich01 1884 1 WIL UA 0 0 1 0 0 0 0 18 6 2 0 0 2   3.0   2   0 25 1 5      
479 becanbu01 1884 1 NY4 AA 1 0 1 1 1 0 0 18 2 1 0 2 2   1.5   0 0 0 24 0 2      
495 brownle01 1884 1 BSU UA 0 0 1 0 0 0 1 3 6 4 0 1 0   36.0   0   0 10 1 7      
501 burnsoy01 1884 2 BL2 AA 0 0 2 0 0 0 1 27 12 3 0 2 6   3.0   0 0 0 37 2 5      
503 cahiljo01 1884 1 CL5 AA 1 0 2 1 1 0 0 48 15 9 0 4 1   5.06   2 3 0 78 1 15      
506 cattajo01 1884 1 PRO NL 0 0 1 1 0 0 0 15 2 5 0 4 2   9.0   3   0 24 0 7      
512 comisch01 1884 1 SL4 AA 0 0 1 0 0 0 0 12 1 1 0 0 4   2.25   0 0 0 17 1 1      

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