2 rows where SF = 17

View and edit SQL

SF

Link rowid ▼ playerID yearID stint teamID lgID G AB R H 2B 3B HR RBI SB CS BB SO IBB HBP SH SF GIDP
49952 whitero01 1971 1 NYA AL 147 524 86 153 22 7 19 84 14 7 86 66 7 7 0 17 10
74275 bonilbo01 1996 1 BAL AL 159 595 107 171 27 5 28 116 1 3 75 85 7 5 0 17 13

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Batting" (
"playerID" TEXT,
  "yearID" INTEGER,
  "stint" INTEGER,
  "teamID" TEXT,
  "lgID" REAL,
  "G" INTEGER,
  "AB" INTEGER,
  "R" INTEGER,
  "H" INTEGER,
  "2B" INTEGER,
  "3B" INTEGER,
  "HR" INTEGER,
  "RBI" INTEGER,
  "SB" INTEGER,
  "CS" INTEGER,
  "BB" INTEGER,
  "SO" INTEGER,
  "IBB" INTEGER,
  "HBP" INTEGER,
  "SH" INTEGER,
  "SF" INTEGER,
  "GIDP" INTEGER
);