47,628 rows sorted by R

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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
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      
3092 hookebu01 1903 1 CIN NL 0 0 1 0 0 0 0 7 2 0 0 2 0   0.0   0 0 0 10 1 0      
3164 tayloed01 1903 1 SLN NL 0 0 1 0 0 0 0 9 0 0 0 0 1   0.0   0 0 0 12 1 0      
3224 doughto01 1904 1 CHA AL 1 0 1 0 0 0 0 6 0 0 0 0 0   0.0   0 0 0 6 1 0      
3424 moorege01 1905 1 PIT NL 0 0 1 0 0 0 0 9 2 0 0 0 1   0.0   0 0 0 10 1 0      
3462 vanzaik01 1905 1 SLA AL 0 0 1 0 0 0 0 20 2 0 0 2 3   0.0   0 1 0 24 1 0      
3494 camerja01 1906 1 BSN NL 0 0 2 1 0 0 0 18 4 0 0 6 2   0.0   0 0 0 25 1 0      
3537 harpeja01 1906 2 CHN NL 0 0 1 1 0 0 0 3 0 0 0 0 0   0.0   0 0 0 3 0 0      
3549 isbelfr01 1906 1 CHA AL 0 0 1 0 0 0 0 6 1 0 0 0 2   0.0   1 0 0 7 1 0      
3558 krohru01 1906 1 BOS AL 1 0 1 1 1 1 0 27 2 0 0 4 5   0.0   0 0 0 31 0 0      
3627 tiemeed01 1906 1 CIN NL 0 0 1 0 0 0 0 3 1 0 0 1 1   0.0   0 0 0 3 1 0      
3719 isbelfr01 1907 1 CHA AL 0 0 1 0 0 0 1 1 0 0 0 0 0   0.0   0 0 0 1 1 0      
3749 mathehe01 1907 1 NY1 NL 0 0 1 0 0 0 1 3 1 0 0 0 0   0.0   1 0 0 4 1 0      
3831 bradyki01 1908 1 BOS AL 1 0 1 1 1 1 0 27 8 0 0 0 3   0.0   0 0 0 33 0 0      
3842 chaseha01 1908 1 NYA AL 0 0 1 0 0 0 0 1 0 0 0 0 0   0.0   0 0 0 1 0 0      
3884 hilleho01 1908 1 PIT NL 0 0 1 0 0 0 0 3 1 0 0 0 1   0.0   0 0 0 3 1 0      
4016 bernajo01 1909 1 SLN NL 0 0 1 0 0 0 0 3 1 0 0 2 2   0.0   1 0 0 6 1 0      
4043 coleki01 1909 1 CHN NL 1 0 1 1 1 1 0 27 6 0 0 3 1   0.0   0 0 0 34 0 0      
4044 collior01 1909 1 WS1 AL 0 0 1 0 0 0 0 3 0 0 0 0 1   0.0   0 0 0 3 1 0      
4242 burnsbi01 1910 1 CHA AL 0 0 1 0 0 0 0 1 0 0 0 1 0   0.0   0 0 0 2 0 0      
4345 merceja01 1910 1 PIT NL 0 0 1 0 0 0 0 3 0 0 0 2 1   0.0   0 0 0 4 1 0      
4358 oharabi01 1910 1 SLN NL 0 0 1 0 0 0 0 3 0 0 0 0 0   0.0   0 0 0 3 0 0      
4386 russele01 1910 1 PHA AL 1 0 1 1 1 1 0 27 8 0 0 2 5   0.0   0 0 0 33 0 0      
4461 camniha01 1911 1 SLN NL 1 0 2 0 0 0 0 6 0 0 0 1 2 0.0 0.0   0 0 0 7 2 0      
4466 chenela01 1911 1 CHN NL 1 0 3 1 0 0 0 30 8 0 0 3 11 0.22 0.0   0 0 0 38 2 0      
4616 smithja01 1911 1 PHI NL 0 0 2 0 0 0 0 15 3 0 0 2 1 0.17 0.0   0 0 0 19 2 0      
4680 bradybi01 1912 1 BSN NL 0 0 1 0 0 0 0 3 2 0 0 0 0 0.5 0.0   0 0 0 4 1 0      
4733 ewingbo01 1912 1 SLN NL 0 0 1 1 0 0 0 4 2 0 0 1 0 0.33 0.0   0 0 0 7 0 0      
4742 gallibe01 1912 1 WS1 AL 0 0 2 0 0 0 0 6 0 0 0 3 0 0.0 0.0   0 0 0 9 1 0      
4758 harresl01 1912 1 PHA AL 0 0 1 0 0 0 0 9 4 0 0 0 1 0.36 0.0   0 0 0 11 1 0      
4761 herrihe01 1912 1 WS1 AL 0 0 1 0 0 0 0 3 1 0 0 1 0 0.25 0.0   0 0 0 5 1 0      
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      
4819 neherji01 1912 1 CLE AL 0 0 1 0 0 0 0 3 0 0 0 0 0 0.0 0.0   0 0 0 3 1 0      
4852 schaege01 1912 1 WS1 AL 0 0 1 0 0 0 0 2 1 0 0 0 0 0.33 0.0   0 0 0 3 0 0      
4887 walkemy01 1912 1 CLE AL 0 0 1 0 0 0 0 3 0 0 0 1 0 0.0 0.0   1 0 0 5 1 0      
4888 walkero01 1912 1 CLE AL 0 0 1 0 0 0 0 6 0 0 0 2 1 0.0 0.0   0 0 0 8 1 0      
4923 bentlja01 1913 1 WS1 AL 1 0 3 1 0 0 1 33 5 0 0 2 5 0.14 0.0   1 1 0 31 1 0      
4966 dawsore01 1913 1 WS1 AL 0 0 1 0 0 0 0 3 1 0 0 0 1 0.25 0.0   0 0 0 4 0 0      
4985 gedeojo01 1913 1 WS1 AL 0 0 1 0 0 0 1 1 0 0 0 0 0 0.0 0.0   0 0 0 1 1 0      
4991 griffcl01 1913 1 WS1 AL 0 0 1 0 0 0 0 3 1 0 0 0 0 0.25 0.0   0 0 0 4 0 0      
5008 hedgpha01 1913 1 WS1 AL 0 0 1 0 0 0 1 3 1 0 0 0 0 0.25 0.0   0 0 0 4 1 0      
5012 hoffch01 1913 1 NYA AL 0 0 2 0 0 0 0 9 0 0 0 1 2 0.0 0.0   0 0 0 9 1 0      
5013 hoopeha01 1913 1 BOS AL 0 0 1 0 0 0 0 6 2 0 0 1 0 0.33 0.0   0 0 0 7 0 0      
5030 koneted01 1913 1 SLN NL 1 0 1 0 0 0 0 14 1 0 0 4 3 0.07 0.0   0 0 0 18 1 0      
5145 zabelzi01 1913 1 CHN NL 1 0 1 1 0 0 0 15 3 0 0 1 0 0.16 0.0   0 1 0 19 0 0      
5156 altroni01 1914 1 WS1 AL 0 0 1 0 0 0 0 3 3 0 0 0 0 0.75 0.0   0 0 0 5 1 0      
5163 barrofr02 1914 1 WS1 AL 0 0 1 0 0 0 0 3 1 0 0 0 1 0.33 0.0   0 0 0 3 1 0      
5166 beckge01 1914 1 CLE AL 0 0 1 0 0 0 0 3 1 0 0 0 0 0.25 0.0   0 1 0 5 1 0      
5169 bennhe01 1914 1 CLE AL 0 0 1 0 0 0 0 3 0 0 0 0 1 0.0 0.0   0 0 0 3 1 0      
5246 griffcl01 1914 1 WS1 AL 0 0 1 0 0 0 1 3 1 0 0 0 1 0.25 0.0   0 0 0 4 1 0      

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