3 rows where SF = 15

View and edit SQL

Suggested facets: lgID, GS, SHO, BK

stint

  • 1 3

SF

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
21260 medicdo01 1975 1 NYA AL 16 16 38 37 15 2 0 817 271 106 25 72 132 0.264 3.5 5 6 1 0 1121 0 115 6 15 21
22783 lerchra01 1979 1 PHI NL 10 13 37 35 6 1 0 642 228 89 20 60 92 0.281 3.74 4 4 3 1 899 0 98 11 15 15
28257 stewada01 1991 1 OAK AL 11 11 35 35 2 1 0 678 245 130 24 105 144 0.278 5.18 1 13 9 0 1014 0 135 5 15 19

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