47,628 rows sorted by BFP

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
30410 wagnebi02 1995 1 HOU NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 0 0 0 0 0
30952 spradje01 1996 1 CIN NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 1 0 0 1 1 0 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
33438 sheldsc01 2000 1 TEX AL 0 0 1 0 0 0 0 1 0 0 0 0 1 0.0 0.0 0 0 0 0 1 0 0 0 0 0
33717 donnech01 2001 1 LAN NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
34358 dawlejo01 2002 1 ATL NL 0 0 1 0 0 0 0 1 0 0 0 0 1 0.0 0.0 0 0 0 0 1 1 0 0 0 0
34734 rodrine01 2002 1 CLE AL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
35745 durritr01 2004 1 MIL NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
36012 nunezab01 2004 1 PIT NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
36314 brookfr01 2005 1 ATL NL 0 0 1 0 0 0 0 1 1 0 0 0 0 1.0 0.0 0 0 0 0 1 1 0 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
38117 rapadcl01 2007 1 CHN NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 0 0 0 0 0
40754 kellydo01 2011 1 DET AL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
40966 richmsc01 2011 1 TOR AL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
42087 fuldsa01 2013 1 TBA AL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
42109 gonzaal03 2013 2 NYA AL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
42145 harrijo05 2013 1 PIT NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
42194 johnsro07 2013 1 SLN NL 0 0 1 0 0 0 0 1 0 0 0 0 1 0.0 0.0 0 0 0 0 1 1 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
42755 descada01 2014 1 SLN NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
43089 overbly01 2014 1 MIL NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
43351 amarial01 2015 1 SDN NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
43514 denorch01 2015 1 CHN NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
43857 nathajo01 2015 1 DET AL 0 0 1 0 0 0 1 1 0 0 0 0 1 0.0 0.0 0 0 0 0 1 1 0 0 0 0
43952 reyesjo03 2015 1 LAA AL 1 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 0 0 0 0 0
44159 amarial01 2016 1 SDN NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
45788 woodhu01 2017 1 TBA AL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
46036 ervinph01 2018 1 CIN NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
46468 reynoma01 2018 1 WAS NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
46475 rizzoan01 2018 1 CHN NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
46633 valenda01 2018 1 BAL AL 0 0 1 0 0 0 0 1 0 0 0 0 1 0.0 0.0 0 0 0 0 1 1 0 0 0 0
47045 gyorkje01 2019 1 SLN NL 0 0 1 0 0 0 0 1 0 0 0 0 1 0.0 0.0 0 0 0 0 1 1 0 0 0 0
47086 holadbr01 2019 1 MIA NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
47493 stassma01 2019 1 HOU AL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 1 1 0 0 0 0
160 piersda01 1876 1 CN1 NL 0 1 1 1 0 0 0 0 2 2 1 0 0       0   0 2 0 2      
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      
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      
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      
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      
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      
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      
5620 mckayre01 1915 1 SLA AL 0 0 1 0 0 0 0 3 1 1 0 0 0 0.5 9.0   0 0 0 2 0 1      
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      
6263 paulege01 1918 1 SLN NL 0 0 1 0 0 0 0 1 1 0 0 0 0 0.5 0.0   0 0 0 2 1 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      
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      
7278 holkewa01 1923 1 PHI NL 0 0 1 0 0 0 0 1 1 0 0 0 0 0.5 0.0   0 0 0 2 1 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      
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      
8857 mosolji01 1930 1 PIT NL 0 0 1 0 0 0 0 1 1 1 0 0 1 0.5 27.0   0 0 0 2 1 1      
9536 barneju01 1934 1 CIN NL 0 0 2 0 0 0 0 1 0 0 0 1 0 0.0 0.0   0 0 0 2 2 0      
11892 eisenja01 1944 1 CIN NL 0 0 1 0 0 0 0 1 0 0 0 1 0 0.0 0.0   0 0 0 2 1 0      
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      
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      
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      
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      
15241 jayjo01 1957 1 ML1 NL 0 0 1 0 0 0 1 2 0 0 0 0 0 0.0 0.0 0 0 0 0 2 1 0      
18177 buzhajo01 1967 3 HOU NL 0 0 1 0 0 0 0 2 0 0 0 0 0 0.0 0.0 0 0 0 0 2 0 0      
18413 schwado01 1967 1 ATL NL 0 0 1 0 0 0 0 2 0 0 0 1 0 0.0 0.0 1 0 0 0 2 1 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
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
22888 rineeje01 1979 1 BAL AL 0 0 1 0 0 0 0 3 0 0 0 0 0 0.0 0.0 0 0 0 0 2 0 0 0 0 1
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
26015 garcimi02 1987 2 PIT NL 0 0 1 0 0 0 0 2 0 0 0 0 0 0.0 0.0 0 0 0 0 2 1 0 0 0 0
26945 foleyto02 1989 1 MON NL 0 0 1 0 0 0 0 1 1 1 1 0 0 0.5 27.0 0 0 0 0 2 1 1 0 0 0
27640 noboaju01 1990 1 MON NL 0 0 1 0 0 0 0 2 0 0 0 1 0 0.0 0.0 0 0 0 0 2 1 0 0 0 1
27691 richaje02 1990 1 CAL AL 0 0 1 0 0 0 0 1 1 0 0 0 0 0.5 0.0 0 0 0 0 2 1 0 0 0 0
27952 espinal01 1991 1 NYA AL 0 0 1 0 0 0 0 2 0 0 0 0 0 0.0 0.0 0 0 0 0 2 1 0 0 0 0
28930 fajarhe01 1993 1 TEX AL 0 0 1 0 0 0 0 2 0 0 0 0 1 0.0 0.0 0 0 0 0 2 1 0 0 0 0
29685 patteke01 1994 1 CAL AL 0 0 1 0 0 0 0 2 0 0 0 0 1 0.0 0.0 0 0 0 0 2 0 0 0 0 0
30638 grundke01 1996 1 BOS AL 0 0 1 0 0 0 0 1 1 1 0 0 0 0.5 27.0 0 0 0 0 2 0 1 0 0 0
34669 perezto03 2002 1 PHI NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 0 0 2 1 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
36929 barziph01 2006 1 HOU NL 0 0 1 0 0 0 0 1 1 0 0 0 0 0.5 0.0 0 0 0 0 2 0 0 0 0 0
37018 colomje01 2006 1 TBA AL 0 0 1 0 0 0 0 1 0 1 0 1 0 0.0 27.0 0 0 0 0 2 0 1 0 0 0
37105 fulchje01 2006 1 FLO NL 0 0 1 0 0 0 0 1 0 0 0 1 0 0.0 0.0 0 0 0 0 2 0 0 0 0 0
39385 loretma01 2009 1 LAN NL 0 0 1 0 0 0 0 1 0 0 0 0 0 0.0 0.0 0 0 1 0 2 1 0 0 0 0
40652 garrist01 2011 1 NYA AL 0 0 1 0 0 0 0 2 0 0 0 0 0 0.0 0.0 0 0 0 0 2 1 0 0 0 0
41338 egberja01 2012 1 NYN NL 0 0 1 0 0 0 0 2 0 0 0 0 0 0.0 0.0 0 0 0 0 2 1 0 0 0 0
41557 mathejo02 2012 1 CHN NL 0 0 1 0 0 0 0 1 1 0 0 0 0 0.5 0.0 0 0 0 0 2 1 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
41848 wisede01 2012 1 NYA AL 0 0 1 0 0 0 0 2 0 0 0 0 0 0.0 0.0 0 0 0 0 2 1 0 0 0 0
42207 kensilo01 2013 1 COL NL 0 0 1 0 0 0 0 2 0 0 0 1 1 0.0 0.0 0 0 0 0 2 1 0 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
42775 dunnija01 2014 1 SFN NL 0 0 1 0 0 0 0 2 0 0 0 1 0   0.0 0 2 0 0 2 0 0 0 1 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
44655 motteta01 2016 1 TBA AL 0 0 1 0 0 0 0 1 1 0 0 0 0 0.5 0.0 0 0 0 0 2 1 0 0 0 0
44726 phegljo01 2016 1 OAK AL 0 0 1 0 0 0 0 2 0 0 0 0 1 0.0 0.0 0 0 0 0 2 1 0 0 0 0
45019 beatope01 2017 1 PHI NL 0 0 1 0 0 0 0 2 0 0 0 0 1 0.0 0.0 0 0 0 0 2 0 0 0 0 0
45037 blancan01 2017 1 PHI NL 0 0 1 0 0 0 0 1 1 1 1 0 0 0.5 27.0 0 0 0 0 2 1 1 0 0 0
45173 eliasro01 2017 1 BOS AL 0 0 1 0 0 0 0 1 0 0 0 1 1 0.0 0.0 0 0 0 0 2 1 0 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
45617 rosscza01 2017 1 CHN NL 0 0 1 0 0 0 0 2 0 0 0 0 0 0.0 0.0 0 0 0 0 2 0 0 0 0 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
);