7 rows where stint = 4

View and edit SQL

Suggested facets: lgID, W, L, G, GS, CG, SV, ER, HR, BB, IBB, WP, HBP, BK, R, SH, SF, GIDP

GF

stint

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
10998 hudliwi01 1940 4 NY1 NL 0 1 1 1 0 0 0 15 9 6 1 1 1 0.4 10.8   0 0 0 23 0 6      
14671 grayte01 1955 4 BAL AL 1 2 9 1 0 0 0 46 21 14 3 11 8 0.34 8.22 1 1 0 0 77 5 19      
20117 kilkemi01 1972 4 CLE AL 4 1 22 7 1 0 1 174 51 22 5 39 44 0.237 3.41 4 3 0 0 255 6 23 0 1  
33150 holmeda01 2000 4 ARI NL 0 0 4 0 0 0 0 12 7 3 1 0 3 0.389 6.75 0 0 1 0 19 2 3 0 0 1
35270 micelda01 2003 4 HOU NL 1 1 23 0 0 0 0 90 22 7 3 7 20 0.20800000000000002 2.1 1 2 1 1 116 8 7 2 0 3
37918 kimby01 2007 4 FLO NL 4 2 9 6 0 0 0 102 49 31 8 9 34 0.34299999999999997 8.21 0 3 6 0 162 2 33 2 2 3
46018 drakeol01 2018 4 TOR AL 0 0 2 0 0 0 0 5 4 3 0 0 2 0.444 16.2 0 1 0 0 9 2 3 0 0 0

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