47,628 rows sorted by H

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
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      
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      
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      
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      
707 brownto01 1885 1 PT1 AA 0 0 2 0 0 0 0 18 0 2 0 3 2   3.0   2 3 0 29 2 3      
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      
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      
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      
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      
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      
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      
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      
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      
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      
2037 thomato01 1894 1 CL4 NL 0 0 1 0 0 0 1 1 0 1 0 2 0   27.0   0 0 0 3 1 1      
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      
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      
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      
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      
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      
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      
3699 fritzch01 1907 1 PHA AL 0 0 1 1 0 0 0 9 0 1 0 3 1   3.0   0 1 0 12 0 1      
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      
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      
3868 finlape01 1908 1 BRO NL 0 1 1 0 0 0 0 1 0 5 0 4 0   135.0   0 0 0 5 0 5      
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      
4393 slaglwa01 1910 1 CIN NL 0 0 1 0 0 0 0 3 0 1 0 3 0   9.0   0 1 0 7 0 1      
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      
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      
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      
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      
4963 dashnle01 1913 1 CLE AL 0 0 1 0 0 0 0 5 0 1 0 0 2 0.0 5.4   1 0 0 5 1 1      
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      
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      
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      
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      
5324 mcgrajo02 1914 1 BRF FL 0 0 1 0 0 0 0 6 0 0 0 0 2 9.99 0.0   0 1 0 0 0 0      
5379 shermda01 1914 1 CHF FL 0 1 1 1 0 0 0 1 0 0 0 2 0 9.99 0.0   0 0 0 0 0 2      
5395 swandu01 1914 1 KCF FL 0 0 1 0 0 0 0 3 0 0 0 1 1 9.99 0.0   0 0 0 0 1 0      
5466 braital01 1915 1 PTF FL 0 0 2 0 0 0 0 9 0 0 0 0 2 9.99 0.0   0 0 0 0 1 0      
5499 coopegu01 1915 1 BOS AL 0 0 1 0 0 0 0 6 0 0 0 2 0 0.0 0.0   0 0 0 7 1 0      
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      
5727 whitegi01 1915 1 NEW FL 0 0 1 0 0 0 0 3 0 0 0 1 0 9.99 0.0   0 0 0 0 1 0      
5728 wilheka01 1915 1 BLF FL 0 0 1 0 0 0 0 3 0 0 0 0 0 9.99 0.0   0 0 0 0 0 0      
5752 bentlja01 1916 1 WS1 AL 0 0 2 0 0 0 0 4 0 0 0 1 1 0.0 0.0   0 0 0 4 0 0      
5766 cantwmi01 1916 1 NYA AL 0 0 1 0 0 0 0 6 0 0 0 2 0 0.0 0.0   0 0 0 6 0 2      
5810 gunkere01 1916 1 CLE AL 0 0 1 0 0 0 0 3 0 0 0 1 1 0.0 0.0   0 1 0 4 0 2      
5844 lowdegr01 1916 1 DET AL 0 0 1 0 0 0 0 1 0 0 0 3 0 0.0 0.0   0 0 0 4 0 0      
5978 dickege01 1917 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      
5982 durniri01 1917 1 BRO NL 0 0 1 0 0 0 0 3 0 0 0 0 0 0.0 0.0   0 0 0 3 1 0      
6041 murchti01 1917 1 SLN NL 0 0 1 0 0 0 0 3 0 0 0 2 2 0.0 0.0   0 0 0 5 1 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      
6131 bernhwa01 1918 1 NYA AL 0 0 1 0 0 0 0 2 0 0 0 0 1 0.0 0.0   0 0 0 2 1 0      
6170 dyerbe01 1918 1 DET AL 0 0 2 0 0 0 0 5 0 0 0 0 0 0.0 0.0   0 0 0 5 2 0      
6196 hehlja01 1918 1 BRO NL 0 0 1 0 0 0 0 3 0 0 0 0 0 0.0 0.0   0 1 0 4 1 0      
6199 herrmma01 1918 1 BRO NL 0 0 1 0 0 0 0 3 0 0 0 1 0 0.0 0.0   0 0 0 4 1 0      
6206 howarea01 1918 1 SLN NL 0 0 1 0 0 0 0 6 0 0 0 2 0 0.0 0.0   0 0 0 7 1 0      
6207 hoytwa01 1918 1 NY1 NL 0 0 1 0 0 0 0 3 0 0 0 0 2 0.0 0.0   0 0 0 3 1 0      
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      
6320 wilkiro01 1918 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      
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      
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      
6546 woodjo02 1919 1 CLE AL 0 0 1 0 0 0 1 2 0 0 0 0 0 0.0 0.0   0 0 0 3 1 0      
6610 ellisge01 1920 1 CLE AL 0 0 1 0 0 0 0 3 0 0 0 2 1 0.0 0.0   0 0 0 7 1 0      
6611 engeljo01 1920 1 WS1 AL 0 0 1 0 0 0 0 5 0 4 0 4 0 0.0 21.6   3 1 0 9 0 4      
6735 sislege01 1920 1 SLA AL 0 0 1 0 0 0 1 3 0 0 0 0 2 0.0 0.0   0 0 0 4 1 0      
6753 veddelo01 1920 1 DET AL 0 0 1 0 0 0 0 6 0 0 0 0 1 0.0 0.0   0 0 0 6 1 0      
6754 watsomu01 1920 1 BSN NL 0 0 1 0 0 0 0 9 0 0 0 0 0 0.0 0.0   0 0 0 9 1 0      
6785 blackch01 1921 1 CHA AL 0 0 1 0 0 0 0 3 0 0 0 1 0 0.0 0.0   0 0 0 3 1 0      
6878 millera04 1921 1 WS1 AL 0 0 1 0 0 0 0 3 0 0 0 0 0 0.0 0.0   0 0 0 3 1 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      
7037 fournja01 1922 1 SLN NL 0 0 1 0 0 0 0 3 0 0 0 0 0 0.0 0.0   0 0 0   1 0      
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      
7351 roecl01 1923 1 WS1 AL 0 1 1 1 0 0 0 5 0 0 0 6 2 0.0 0.0   3 0 0 12 0 4      
7396 wingfte01 1923 1 WS1 AL 0 0 1 0 0 0 0 3 0 0 0 0 1 0.0 0.0   0 0 0 3 1 0      
7397 winnge01 1923 1 CLE AL 0 0 1 0 0 0 0 6 0 0 0 1 0 0.0 0.0   0 0 0 7 1 0      
7412 barnhed01 1924 1 SLA AL 0 0 1 0 0 0 0 3 0 0 0 2 0 0.0 0.0   0 0 0 5 0 0      
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      
7624 woodsjo01 1924 1 BOS AL 0 0 1 0 0 0 0 3 0 0 0 3 0 0.0 0.0   0 0 0 6 1 0      
7669 cobbty01 1925 1 DET AL 0 0 1 0 0 0 1 3 0 0 0 0 0 0.0 0.0   0 0 0 3 1 0      
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      
7863 bentlja01 1926 2 NY1 NL 0 0 1 0 0 0 0 6 0 0 0 2 1 0.0 0.0   0 0 0 8 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
);