47,628 rows sorted by ER

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
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
307 comisch01 1882 1 SL4 AA 0 1 2 1 1 0 0 24 12 0 0 3 2   0.0   1   0 40 0 8      
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      
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      
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      
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      
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      
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      
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      
518 corcoja01 1884 1 BR3 AA 0 0 1 0 0 0 0 3 0 0 0 1 0   0.0   0 0 0 5 1 0      
550 fogarji01 1884 1 PHI NL 0 0 1 0 0 0 0 3 2 0 0 0 1   0.0   1   0 6 1 2      
576 hinespa01 1884 1 PRO NL 0 0 1 0 0 0 0 3 3 0 0 0 0   0.0   1   0 6 0 1      
590 kreegfr01 1884 1 KCU UA 0 1 1 1 0 0 0 21 9 0 0 5 3   0.0   0   0 36 0 8      
761 maculji01 1885 1 BL2 AA 0 0 1 0 0 0 0 3 0 0 0 0 0   0.0   0 0 0 3 1 0      
793 sewared01 1885 1 PRO NL 0 0 1 0 0 0 0 18 2 0 0 0 1   0.0   2   0 20 1 0      
801 stemmbi01 1885 1 BSN NL 1 1 2 2 2 1 0 33 7 0 0 11 8   0.0   2   0 47 0 7      
813 willine01 1885 1 CHN NL 0 0 2 0 0 0 2 18 2 0 0 0 3   0.0   0   0 25 2 0      
816 woodge01 1885 1 DTN NL 0 0 1 0 0 0 0 12 5 0 0 1 1   0.0   2   0 16 1 2      
851 fogarji01 1886 1 PHI NL 0 1 1 0 0 0 0 18 7 0 0 0 4   0.0   1   0 28 1 6      
889 mccarto01 1886 1 PHI NL 0 0 1 0 0 0 0 3 0 0 0 1 1   0.0   0   0 4 1 0      
897 morrijo01 1886 1 BSN NL 0 0 1 0 0 0 0 12 5 0 0 0 2   0.0   1   0 16 1 1      
953 willine01 1886 1 CHN NL 0 0 2 0 0 0 1 9 2 0 0 0 1   0.0   0   0 14 2 2      
964 bierblo01 1887 1 PH4 AA 0 0 1 0 0 0 1 3 0 0 0 0 1   0.0   0 0 0 3 1 0      
992 fieldjo01 1887 1 PIT NL 0 0 1 0 0 0 0 3 0 0 0 2 0   0.0   1 0 0 7 0 3      
1002 glassja01 1887 1 IN3 NL 0 0 1 0 0 0 0 3 0 0 0 0 1   0.0   0 0 0 3 1 0      
1039 obrieda01 1887 1 NY4 AA 0 0 1 0 0 0 0 3 1 0 0 1 0   0.0   0 0 0 4 0 0      
1044 pettibo01 1887 1 CHN NL 0 0 1 0 0 0 1 3 3 0 1 2 0   0.0   3 0 0 10 1 8      
1053 richada01 1887 1 NY1 NL 0 0 1 0 0 0 0 0 0 0 0 1 0       0 0 0 1 0 0      
1101 bierblo01 1888 1 PH4 AA 0 0 1 0 0 0 0 9 5 0 0 0 3   0.0   1 0 0 14 1 1      
1183 schoeju01 1888 1 IN3 NL 0 0 2 0 0 0 0 13 5 0 0 1 1   0.0   1 0 0 23 2 4      
1188 shochge01 1888 1 WS8 NL 0 0 1 0 0 0 0 9 2 0 0 1 0   0.0   0 0 0 13 1 0      
1235 comisch01 1889 1 SL4 AA 0 0 1 0 0 0 0 1 0 0 0 0 0   0.0   0 0 0 1 1 0      
1263 glassja01 1889 1 IN3 NL 0 0 1 0 0 0 0 2 3 0 0 3 0   0.0   1 0 0 8 1 2      
1276 irwinar01 1889 2 WS8 NL 0 0 1 0 0 0 0 3 1 0 0 0 0   0.0   0 0 0 4 0 1      
1300 morrijo01 1889 1 WS8 NL 0 0 1 0 0 0 0 1 0 0 0 0 0   0.0   0 0 0 1 0 0      
1302 nashbi01 1889 1 BSN NL 0 0 1 0 0 0 0 3 0 0 0 1 0   0.0   0 0 0 4 1 0      
1335 twitcla01 1889 1 CL4 NL 0 0 1 0 0 0 0 3 0 0 0 1 0   0.0   0 0 0 4 0 0      
1388 demarfr01 1890 1 CHN NL 0 0 1 0 0 0 0 6 1 0 0 1 1   0.0   1 0 0 8 1 0      
1410 fordto01 1890 1 CL6 AA 0 0 1 0 0 0 0 6 0 0 0 3 0   0.0   0 0 0 9 1 0      
1420 gibsoro01 1890 1 CHN NL 1 0 1 1 1 0 0 27 6 0 0 2 1   0.0   1 0 0 35 0 1      
1428 grimjo01 1890 1 RC2 AA 0 0 1 0 0 0 0 10 3 0 0 4 3   0.0   1 0 0 17 1 3      
1491 nashbi01 1890 1 BSP PL 0 0 1 0 0 0 0 1 1 0 0 0 0   0.0   0 0 0 2 1 0      
1518 sommejo01 1890 1 CL4 NL 0 0 1 0 0 0 0 3 2 0 1 2 0   0.0   0 0 0 7 0 3      
1563 bellch01 1891 2 CN3 AA 1 0 1 1 1 0 0 27 2 0 0 3 1   0.0   0 1 0 33 0 2      
1627 keenaki01 1891 1 CN3 AA 0 1 1 1 1 0 0 24 6 0 0 4 5   0.0   0 1 0 35 0 9      
1663 radfopa01 1891 1 BS2 AA 0 0 1 0 0 0 0 3 0 0 0 0 0   0.0   0 0 0 3 0 0      
1667 ryancy01 1891 1 BSN NL 0 0 1 0 0 0 0 9 2 0 0 1 0   0.0   0 0 0 12 1 0      
1675 slagljo01 1891 1 CN3 AA 0 0 1 0 0 0 1 4 3 0 0 1 1   0.0   0 0 0 8 1 0      
1758 jonesbu01 1892 1 CIN NL 1 0 1 1 1 0 0 27 0 0 0 4 3   0.0   0 0 0 31 0 1      
1803 viaule01 1892 3 BSN NL 1 0 1 1 1 0 0 27 5 0 0 4 1   0.0   0 0 0 36 0 1      
1895 ryanji01 1893 1 CHN NL 0 0 1 0 0 0 0 14 3 0 0 0 1   0.0   0 0 0 17 1 0      
1924 bannoji01 1894 1 BSN NL 0 0 1 0 0 0 0 6 4 0 1 1 0   0.0   1 0 0 11 1 3      
1948 elybo01 1894 1 SLN NL 0 0 1 0 0 0 0 3 0 0 0 3 0   0.0   1 0 0 6 1 0      
2030 stultge01 1894 1 BSN NL 1 0 1 1 1 0 0 27 4 0 0 5 1   0.0   0 0 0 35 0 2      
2041 virtuja01 1894 1 CL4 NL 0 0 1 0 0 0 0 0 0 0 0 1 0       0 0 0 1 0 0      
2055 banksbi01 1895 1 BSN NL 1 0 1 1 1 0 0 21 7 0 0 4 4   0.0   0 0 0 31 0 2      
2108 klingbi01 1895 1 LS3 NL 0 0 1 0 0 0 0 3 0 0 0 1 0   0.0   0 0 0 4 1 0      
2206 gilrojo01 1896 1 WAS NL 0 0 1 0 0 0 0 6 0 0 0 1 0   0.0   0 0 0 7 1 0      
2220 hollibu01 1896 1 CIN NL 0 0 1 0 0 0 0 3 4 0 0 2 0   0.0   1 1 0 10 1 3      
2234 kostajo01 1896 1 LS3 NL 0 0 2 0 0 0 0 6 4 0 0 0 0   0.0   0 0 0 10 2 4      
2269 tebeapa01 1896 1 CL4 NL 0 0 1 0 0 0 0 0 1 0 0 0 0       0 0 0 1 1 0      
2368 stanljo02 1897 1 WAS NL 0 0 1 0 0 0 0 2 0 0 0 0 0   0.0   1 0 0 2 1 0      
2528 fauvecl01 1899 1 LS3 NL 1 0 1 1 1 0 0 27 11 0 0 2 1   0.0   0 0 0 39 0 4      
2547 herrile01 1899 1 WAS NL 0 0 2 0 0 0 0 6 0 0 0 2 0   0.0   0 0 0 8 1 0      
2556 johnsyo01 1899 1 NY1 NL 0 0 1 0 0 0 0 6 0 0 0 2 1   0.0   0 0 0 8 1 0      
2569 lochhha01 1899 1 CL4 NL 0 0 1 0 0 0 0 11 4 0 0 2 0   0.0   0 0 0 16 1 2      
2605 sechrdo01 1899 1 NY1 NL 0 0 1 0 0 0 0 0 0 0 0 2 0       0 0 0 2 0 0      
2653 harveza01 1900 1 CHN NL 0 0 1 0 0 0 0 12 3 0 0 1 0   0.0   0 0 0 15 1 0      
2692 vanhage01 1900 1 NY1 NL 0 0 1 0 0 0 0 9 1 0 0 3 0   0.0   0 0 0 13 1 0      
2694 wagneho01 1900 1 PIT NL 0 0 1 0 0 0 0 9 3 0 0 4 1   0.0   0 0 0 16 1 3      
2706 bradlbi01 1901 1 CLE AL 0 0 1 0 0 0 0 3 4 0 0 0 0   0.0   0 0 0 7 0 3      
2735 felixha01 1901 1 NY1 NL 0 0 1 0 0 0 0 6 3 0 0 0 0   0.0   0 0 0 9 1 0      
2736 ferguch02 1901 1 CHN NL 0 0 1 0 0 0 0 6 1 0 0 2 0   0.0   0 0 0 9 1 0      
2772 leitndu01 1901 1 PHA AL 0 0 1 0 0 0 0 6 1 0 0 1 1   0.0   0 0 0 8 1 0      
2782 mcaleji01 1901 1 CLE AL 0 0 1 0 0 0 0 1 2 0 0 3 0   0.0   3 0 0 6 1 3      
2844 wickebo01 1901 1 SLN NL 0 0 1 0 0 0 0 9 4 0 0 1 2   0.0   0 0 0 14 1 3      
2881 donlimi01 1902 1 CIN NL 0 0 1 0 0 0 0 3 1 0 0 0 0   0.0   0 0 0 4 1 0      
2897 fisheed01 1902 1 DET AL 0 0 1 0 0 0 0 12 4 0 0 1 0   0.0   0 0 0 16 1 0      
2914 heidrem01 1902 1 SLA AL 0 0 1 0 0 0 0 3 0 0 0 0 0   0.0   0 0 0 3 0 0      
2930 katolja01 1902 1 CHA AL 0 0 1 0 0 0 0 3 1 0 0 0 2   0.0   0 0 0 4 1 0      
2956 mcmacsa01 1902 1 CHA AL 0 0 1 0 0 0 0 9 1 0 0 0 2   0.0   0 0 0 10 1 1      
3005 sugdejo01 1902 1 SLA AL 0 0 1 0 0 0 0 3 1 0 0 0 0   0.0   0 0 0 4 1 0      
3021 wagneho01 1902 1 PIT NL 0 0 1 0 0 0 0 16 4 0 0 2 5   0.0   3 0 0 21 1 2      
3024 wallabo01 1902 1 SLA AL 0 0 1 1 0 0 0 6 3 0 0 0 1   0.0   0 0 0 9 0 2      
3034 winhala01 1902 1 BRO NL 0 0 1 0 0 0 0 9 4 0 0 2 1   0.0   0 0 0 15 1 2      
3045 bartlbi01 1903 1 NY1 NL 0 0 1 0 0 0 0 9 3 0 0 4 2   0.0   0 0 0 15 1 4      
3049 blissel01 1903 1 NYA AL 1 0 1 0 0 0 0 21 4 0 0 0 3   0.0   1 0 0 24 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
);