47,628 rows sorted by ERA

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
160 piersda01 1876 1 CN1 NL 0 1 1 1 0 0 0 0 2 2 1 0 0       0   0 2 0 2      
522 coughed01 1884 1 BFN NL 0 0 1 0 0 0 0 0 3 3 0 0 0       2   0 5 0 4      
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      
1532 sundabi01 1890 1 PIT NL 0 0 1 0 0 0 0 0 2 2 0 0 0       0 0 0 2 0 2      
1923 bakerki01 1894 1 BLN NL 0 1 1 0 0 0 0 0 1 5 0 2 0       0 0 0 3 0 5      
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      
2065 childbi01 1895 1 LS3 NL 0 0 1 0 0 0 0 0 2 6 0 5 0       3 0 0 7 0 6      
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      
2278 woodjo01 1896 1 SLN NL 0 0 1 0 0 0 0 0 1 1 0 2 0       0 1 0 4 0 1      
2591 parkeja01 1899 1 PIT NL 0 0 1 1 0 0 0 0 0 2 0 2 0       0 1 0 3 0 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      
2733 dupeefr01 1901 1 CHA AL 0 1 1 1 0 0 0 0 0 3 0 3 0       0 0 0 3 0 3      
4750 griffcl01 1912 1 WS1 AL 0 0 1 0 0 0 0 0 1 1 1 0 0 1.0     0 0 0 1 0 1      
4804 mcgehpa01 1912 1 DET AL 0 0 1 1 0 0 0 0 1 0 0 1 0 1.0     0 0 0 2 0 0      
5105 scoggji01 1913 1 CHA AL 0 1 1 1 0 0 0 0 0 0 0 1 0 0.0     0 0 0 2 0 1      
5614 mayersa01 1915 1 WS1 AL 0 0 1 0 0 0 0 0 0 0 0 2 0 0.0     0 0 0 2 0 0      
6128 bauerlo01 1918 1 PHA AL 0 0 1 0 0 0 0 0 0 1 0 2 0 0.0     0 0 0 2 0 2      
6242 mcgrabo01 1918 1 NYA AL 0 1 1 1 0 0 0 0 0 0 0 4 0 0.0     0 0 0 4 0 4      
6331 altroni01 1919 1 WS1 AL 0 0 1 0 0 0 0 0 4 0 0 0 0 1.0     0 0 0 4 0 4      
6379 engeljo01 1919 1 CLE AL 0 0 1 0 0 0 0 0 0 0 0 3 0 0.0     0 0 0 3 0 3      
6429 koeniwi01 1919 1 SLN NL 0 0 1 0 0 0 0 0 2 2 0 1 0 1.0     0 0 0 3 0 2      
6489 reinhar01 1919 1 SLN NL 0 0 1 0 0 0 0 0 0 0 0 0 0 0.0     0 1 0 1 0 0      
6501 russere01 1919 1 CHA AL 0 0 1 0 0 0 0 0 1 0 0 1 0 1.0     0 0 0 2 0 0      
6991 bentosi01 1922 1 SLN NL 0 0 1 0 0 0 0 0 0 0 0 2 0 0.0     0 0 0 2 0 0      
7050 hamando01 1922 1 CLE AL 0 0 1 0 0 0 0 0 3 6 0 3 0 1.0     1 1 0 7 0 6      
7065 jeanete01 1922 1 CLE AL 0 0 1 0 0 0 0 0 0 0 0 1 0 0.0     0 0 0 1 0 0      
7259 gardiar01 1923 1 PHI NL 0 0 1 0 0 0 0 0 1 0 0 1 0 1.0     0 0 0 2 0 0      
7476 gearidi01 1924 2 BSN NL 0 1 1 1 0 0 0 0 3 5 0 2 0 1.0     0 0 0 5 0 5      
7508 kelleal01 1924 1 BOS AL 0 0 1 0 0 0 0 0 0 0 0 2 0 0.0     0 0 0 2 0 2      
7578 roettos01 1924 1 NYA AL 0 0 1 0 0 0 0 0 1 0 0 2 0 1.0     0 0 0 3 0 0      
7689 dibutpe01 1925 1 CIN NL 0 0 1 0 0 0 0 0 3 0 0 0 0 1.0     0 0 0 3 0 2      
7775 moorebi01 1925 1 DET AL 0 0 1 0 0 0 0 0 0 0 0 3 0 0.0     0 0 0 3 0 2      
8083 brownjo03 1927 1 CHA AL 0 0 1 1 0 0 0 0 2 0 0 1 0 1.0     0 0 0 3 0 3      
8482 walkema01 1928 1 PHI NL 0 1 1 1 0 0 0 0 2 0 0 3 0 1.0     0 0 0 6 0 4      
8852 moorecy01 1930 1 BRO NL 0 0 1 0 0 0 0 0 2 0 0 0 0 1.0     0 0 0 2 0 1      
9951 warddi01 1935 1 SLN NL 0 0 1 0 0 0 0 0 0 0 0 1 0 0.0     0 0 0 1 0 1      
10037 fordbi01 1936 1 BSN NL 0 0 1 0 0 0 0 0 0 2 0 3 0       0 0 0 3 0 2      
10224 burkebo01 1937 1 PHI NL 0 0 2 0 0 0 0 0 1 0 0 2 0 0.5     0 0 0 4 0 1      
10250 deanpa01 1937 1 SLN NL 0 0 1 0 0 0 0 0 1 0 0 2 0 1.0     0 0 0 3 0 3      
10813 palagmi01 1939 1 WS1 AL 0 0 1 0 0 0 0 0 0 3 0 3 0 0.0     0 1 0 4 0 3      
10841 schelji01 1939 1 PHA AL 0 0 1 0 0 0 0 0 1 3 0 3 0 1.0     0 1 0 5 0 3      
10849 smithda01 1939 1 PHA AL 0 0 1 0 0 0 0 0 1 0 0 2 0 1.0     0 0 0 3 0 0      
11107 uhlbo01 1940 1 DET AL 0 0 1 0 0 0 0 0 4 0 0 2 0 1.0     1 0 0 6 0 5      
12510 mclisca01 1946 1 BRO NL 0 0 1 0 0 0 0 0 1 0 0 0 0 1.0     0 0 0 2 0 2      
12516 milnaal01 1946 2 PHI NL 0 0 1 1 0 0 0 0 2 0 0 2 0 1.0     0 0 0 4 0 4      
12589 vaughpo01 1946 1 PHA AL 0 0 1 0 0 0 0 0 1 0 0 1 0 1.0     0 0 0 2 1 0      
12605 williac01 1946 1 BSN NL 0 0 1 0 0 0 0 0 1 0 0 1 0 1.0     0 0 0 2 0 0      
13152 coopemo01 1949 1 CHN NL 0 0 1 0 0 0 0 0 2 3 1 1 0 1.0     1 0 0 3 0 3      
14006 musiast01 1952 1 SLN NL 0 0 1 0 0 0 0 0 0 0 0 0 0 0.0     0 0 0 1 0 0      
14108 blakeed01 1953 1 CIN NL 0 0 1 0 0 0 0 0 1 0 0 1 0 1.0     0 0 0 2 0 2      
14314 stuffpa01 1953 1 PHI NL 0 0 2 0 0 0 0 0 0 0 0 4 0 0.0     0 0 0 4 0 4      
14718 kosloda01 1955 1 ML1 NL 0 1 1 0 0 0 0 0 1 1 1 0 0 1.0   0 0 0 0 1 1 1      
15057 paineph01 1956 1 ML1 NL 0 0 1 0 0 0 0 0 3 0 0 0 0 1.0   0 0 0 0 3 0 2      
15101 sundigo01 1956 1 BAL AL 0 0 1 0 0 0 0 0 0 1 0 2 0 0.0   0 0 0 0 2 0 1      
16231 bruckfr01 1961 1 MIN AL 0 0 1 0 0 0 0 0 3 3 0 1 0 1.0   0 0 0 0 4 0 3      
16243 cheneto01 1961 1 PIT NL 0 0 1 0 0 0 0 0 1 4 1 4 0 0.5   0 1 0 0 6 0 5      
16804 willste01 1962 1 BOS AL 0 0 1 0 0 0 0 0 2 0 0 1 0 1.0   0 0 0 0 3 0 1      
18000 navarju01 1966 1 DET AL 0 0 1 0 0 0 0 0 2 3 2 0 0 1.0   0 0 1 0 3 0 3      
18040 rayji01 1966 1 HOU NL 0 0 1 0 0 0 0 0 0 0 0 1 0 0.0   0 0 0 0 1 0 1      
18860 davalvi01 1969 2 SLN NL 0 0 2 0 0 0 0 0 2 1 0 2 0 1.0   0 0 0 0 4 0 1      
19949 yountla01 1971 1 HOU NL 0 0 1 0 0 0 0 0 0 0 0 0 0     0 0 0 0 0 0 0 0 0  
20163 medicdo01 1972 1 NYA AL 0 0 1 1 0 0 0 0 2 2 0 2 0 1.0   0 0 0 0 4 0 2 0 0  
20328 apodabo01 1973 1 NYN NL 0 0 1 0 0 0 0 0 0 1 0 2 0     0 0 0 0 2 0 1 0 0 0
21310 pitlosk01 1975 1 CHA AL 0 0 1 0 0 0 0 0 1 0 0 0 0 1.0   0 0 0 0 1 0 0 0 0 0
21342 scarcma01 1975 1 NYN NL 0 0 1 0 0 0 0 0 1 0 0 0 0 1.0   0 0 0 0 1 1 0 0 0 0
21873 farmeed01 1977 1 BAL AL 0 0 1 0 0 0 0 0 1 1 0 1 0 1.0   0 0 0 0 2 0 1 0 0 0
21967 kreugri01 1977 1 BOS AL 0 1 1 0 0 0 0 0 2 2 0 0 0 1.0   0 0 0 0 2 0 2 0 0 0
22749 kammebo01 1979 1 NYA AL 0 0 1 0 0 0 0 0 7 8 2 0 0 1.0   0 0 1 0 8 0 8 0 0 0
22791 luebbst01 1979 1 TOR AL 0 0 1 0 0 0 0 0 2 1 0 1 0 1.0   0 0 0 0 3 0 1 0 0 0
24436 owchibo01 1983 1 PIT NL 0 0 1 0 0 0 0 0 2 1 1 0 0 1.0   0 0 0 0 2 0 1 0 0 0
24563 worthri01 1983 1 OAK AL 0 0 1 0 0 0 0 0 3 1 0 1 0 1.0   0 0 0 0 4 0 1 0 0 0
25442 arroyfe01 1986 1 OAK AL 0 0 1 0 0 0 0 0 0 0 0 3 0     0 0 0 0 3 0 0 0 0 0
26819 alvarwi01 1989 1 TEX AL 0 1 1 1 0 0 0 0 3 3 2 2 0 1.0   0 0 0 0 5 0 3 0 0 0
30070 harvebr01 1995 1 FLO NL 0 0 1 0 0 0 0 0 2 3 1 1 0 1.0   0 0 0 0 3 0 3 0 0 0
32036 pennibr01 1998 1 TBA AL 0 0 1 0 0 0 0 0 1 1 0 3 0 1.0   0 0 0 0 4 0 1 0 0 0
33119 haltesh01 2000 1 DET AL 0 0 1 0 0 0 0 0 0 0 0 1 0     0 0 0 0 1 0 0 0 0 0
33364 radinsc01 2000 1 SLN NL 0 0 1 0 0 0 0 0 0 0 0 1 0     0 0 0 0 1 0 0 0 0 0
34746 sabeler01 2002 1 DET AL 0 0 1 0 0 0 0 0 2 2 1 0 0 1.0   0 0 0 0 2 0 2 0 0 0
35477 tankede01 2003 1 SDN NL 0 1 1 1 0 0 0 0 3 7 0 4 0 1.0   0 0 0 0 7 0 7 0 0 0
36173 urdanli01 2004 1 DET AL 0 0 1 0 0 0 0 0 5 6 0 1 0 1.0   0 0 0 0 6 0 6 0 0 0
36695 perisma01 2005 2 BOS AL 0 0 1 0 0 0 0 0 1 1 0 0 0 1.0   0 0 0 0 1 0 1 0 0 0
37719 choatra01 2007 1 ARI NL 0 0 2 0 0 0 0 0 3 0 0 0 0 1.0   0 0 0 0 3 0 0 0 0 0
41567 mccutda01 2012 1 PIT NL 0 1 1 0 0 0 0 0 1 2 1 1 0 1.0   0 0 0 0 2 1 2 0 0 0
42517 tollesh01 2013 1 LAN NL 0 0 1 0 0 0 0 0 0 0 0 2 0     0 0 0 0 2 0 0 0 0 0
42536 villabr02 2013 2 BOS AL 0 0 1 0 0 0 0 0 0 0 0 1 0     0 0 0 0 1 1 0 0 0 0
42891 hillri01 2014 1 LAA AL 0 0 2 0 0 0 0 0 1 1 0 3 0 1.0   0 1 0 0 4 0 1 0 0 0
42928 jonesna01 2014 1 CHA AL 0 0 2 0 0 0 0 0 2 4 0 3 0 1.0   0 0 0 0 5 0 4 0 0 0
43620 greenni02 2015 1 SLN NL 0 1 1 0 0 0 0 0 2 2 1 0 0 1.0   0 0 0 0 2 1 2 0 0 0
45176 eschja01 2017 1 SDN NL 0 0 1 0 0 0 0 0 0 0 0 2 0     0 0 0 0 2 0 0 0 0 0
45368 kochma01 2017 1 ARI NL 0 0 1 0 0 0 0 0 2 3 0 1 0 1.0   0 0 0 0 3 0 3 0 0 0
45909 brothre01 2018 1 ATL NL 0 0 1 0 0 0 0 0 0 1 0 2 0     0 0 0 0 2 0 1 0 0 0
46664 weissza01 2018 1 CIN NL 0 0 1 0 0 0 0 0 2 4 2 2 0 1.0   0 0 0 0 4 0 4 0 0 0
47306 parrage01 2019 2 WAS NL 0 0 1 0 0 0 0 0 1 5 0 4 0 1.0   0 1 0 0 5 0 5 0 0 0
47553 vasquan02 2019 1 MIN AL 0 0 1 0 0 0 0 0 0 3 0 2 0     0 0 1 0 3 0 3 0 0 0
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      

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