3,666 rows where SF = 3

View and edit SQL

Suggested facets: stint, lgID, 3B, CS

SF

  • 3 · 3,666
Link rowid ▼ playerID yearID stint teamID lgID G AB R H 2B 3B HR RBI SB CS BB SO IBB HBP SH SF GIDP
36896 alliega01 1954 1 PIT NL 121 418 38 83 8 6 3 30 1 1 56 84   2 3 3 3
36903 atwelto01 1954 1 PIT NL 96 287 36 83 8 4 3 26 2 3 43 21   3 4 3 11
36913 bauerha01 1954 1 NYA AL 114 377 73 111 16 5 12 54 4 4 40 42   0 3 3 5
36917 belarwa01 1954 2 DET AL 88 250 27 58 7 1 11 24 1 0 33 34   5 3 3 6
36930 bollifr01 1954 1 DET AL 117 368 46 87 15 2 6 38 3 5 36 51   0 6 3 5
36931 bollimi01 1954 1 BOS AL 113 370 42 92 20 3 6 36 2 4 47 55   4 13 3 3
36934 borkobo01 1954 1 CIN NL 73 162 13 43 12 1 1 19 0 2 8 18   1 1 3 9
36983 courtcl01 1954 1 BAL AL 122 397 25 107 18 3 4 37 2 1 30 7   3 4 3 10
36996 dierich01 1954 1 BAL AL 128 418 35 108 14 1 2 29 3 7 56 57   4 10 3 13
37023 finigji01 1954 1 PHA AL 136 487 57 147 25 6 7 51 2 8 64 66   0 6 3 17
37024 fitzged01 1954 1 WS1 AL 115 360 33 104 13 5 4 40 0 1 33 22   2 3 3 12
37036 furilca01 1954 1 BRO NL 150 547 56 161 23 1 19 96 2 4 49 35   5 3 3 17
37064 grothjo01 1954 1 CHA AL 125 422 41 116 20 0 7 60 3 9 42 37   2 8 3 19
37136 kinerra01 1954 1 CHN NL 147 557 88 159 36 5 22 73 2 0 76 90   2 5 3 17
37179 limmelo01 1954 1 PHA AL 115 316 41 73 10 3 14 32 2 3 35 37   0 2 3 6
37216 mcdougi01 1954 1 NYA AL 126 394 66 102 22 2 12 48 3 4 62 64   5 9 3 5
37222 merrill01 1954 1 CIN NL 73 112 12 30 8 1 0 16 3 0 23 10   3 0 3 1
37223 metkoca01 1954 1 ML1 NL 68 123 7 34 5 1 1 15 0 0 15 15   1 0 3 6
37233 minnepa01 1954 1 CHN NL 33 76 7 13 3 0 2 14 0 0 8 19   0 1 3 1
37259 niemabo01 1954 1 DET AL 91 251 24 66 14 1 8 35 0 2 22 32   0 3 3 10
37267 olsonka01 1954 1 BOS AL 101 227 25 59 12 2 1 20 2 1 12 23   0 3 3 11
37321 robercu01 1954 1 PIT NL 134 496 47 115 18 7 1 36 6 3 55 49   2 9 3 6
37342 sawatca01 1954 1 CHA AL 43 109 6 20 3 3 1 12 0 0 15 20   0 0 3 3
37346 schelda01 1954 1 PHI NL 92 272 25 77 14 3 7 33 0 3 17 31   2 2 3 12
37411 tuttlbi01 1954 1 DET AL 147 530 64 141 20 11 7 58 5 8 62 60   2 5 3 15
37416 valoel01 1954 1 PHA AL 95 224 28 48 11 6 1 33 2 1 51 18   0 3 3 2
37422 waitked01 1954 1 BAL AL 95 311 35 88 17 4 2 33 0 1 28 25   1 6 3 8
37443 willite01 1954 1 BOS AL 117 386 93 133 23 1 29 89 0 0 136 32   1 0 3 10
37450 woodlge01 1954 1 NYA AL 97 304 33 76 12 5 3 40 3 4 53 35   0 0 3 3
37458 youngbo01 1954 1 BAL AL 130 432 43 106 13 6 4 24 4 4 54 42   1 9 3 8
37460 zernigu01 1954 1 PHA AL 97 336 42 84 8 2 14 62 0 0 30 60   4 0 3 8
37468 abramca01 1955 1 BAL AL 118 309 56 75 12 3 6 32 2 8 89 69 2 3 3 3 6
37490 bakerge02 1955 1 CHN NL 154 609 82 163 29 7 11 52 9 7 49 57 1 2 18 3 14
37491 bankser01 1955 1 CHN NL 154 596 98 176 29 9 44 117 9 3 45 72 6 2 0 3 16
37494 bauerha01 1955 1 NYA AL 139 492 97 137 20 5 20 53 8 4 56 65 1 8 4 3 4
37514 blaylma01 1955 1 PHI NL 113 259 30 54 7 7 3 24 6 1 31 43 2 1 3 3 4
37562 clemero01 1955 1 PIT NL 124 474 48 121 23 11 5 47 2 5 18 60 3 2 4 3 14
37574 collijo01 1955 1 NYA AL 105 278 40 65 9 1 13 45 0 2 44 32 2 2 3 3 7
37583 courtcl01 1955 2 WS1 AL 75 238 26 71 8 4 2 30 0 0 19 9 4 1 3 3 4
37656 garvene01 1955 1 DET AL 33 76 11 17 1 0 1 13 1 0 9 5 0 0 3 3 5
37669 gordosi01 1955 2 NY1 NL 66 144 19 35 6 1 7 25 0 0 25 15 2 0 3 3 0
37681 greenji02 1955 2 PHI NL 94 323 43 88 20 2 12 37 0 2 33 43 2 1 1 3 10
37761 kingji01 1955 1 CHN NL 113 301 43 77 12 3 11 45 2 1 24 39 1 2 3 3 3
37803 lockmwh01 1955 1 NY1 NL 147 576 76 157 19 0 15 49 3 3 39 34 2 3 6 3 7
37810 lopatst01 1955 1 PHI NL 99 303 49 82 9 3 22 58 4 1 58 62 6 2 0 3 11
37824 mantlmi01 1955 1 NYA AL 147 517 121 158 25 11 37 99 8 1 113 97 6 3 2 3 4
37843 mcmilro01 1955 1 CIN NL 151 470 50 126 21 2 1 37 4 4 66 33 7 7 10 3 11
37859 miranwi01 1955 1 BAL AL 153 487 42 124 12 6 1 38 4 3 42 58 4 1 3 3 9
37866 morgabo01 1955 1 PHI NL 136 483 61 112 20 2 10 49 6 4 73 72 0 0 6 3 13
37891 oconnda02 1955 1 ML1 NL 124 453 47 102 15 4 6 40 2 2 28 43 2 5 2 3 7
37896 pafkoan01 1955 1 ML1 NL 86 252 29 67 3 5 5 34 1 2 7 23 1 4 1 3 8
37930 postwa01 1955 1 CIN NL 154 601 116 186 33 3 40 109 7 4 60 102 5 2 2 3 15
37950 riverji01 1955 1 CHA AL 147 454 71 120 24 4 10 52 25 16 62 59 6 1 10 3 5
37958 robinja02 1955 1 BRO NL 105 317 51 81 6 2 8 36 12 3 61 18 5 3 6 3 8
38000 simpsha01 1955 2 KC1 AL 112 396 42 119 16 7 5 52 3 5 34 61 4 2 1 3 10
38026 stephge01 1955 1 BOS AL 109 157 25 46 9 4 3 18 0 0 20 34 0 2 1 3 1
38042 tannech01 1955 1 ML1 NL 97 243 27 60 9 3 6 27 0 0 27 32 3 0 2 3 11
38063 triangu01 1955 1 BAL AL 140 481 47 133 17 3 12 65 0 0 40 55 4 2 3 3 9
38070 valdijo01 1955 1 WS1 AL 94 294 32 65 12 5 2 28 1 2 21 38 1 3 4 3 6
38091 westrwe01 1955 1 NY1 NL 69 137 11 29 1 0 4 18 0 1 24 18 3 1 1 3 8
38096 whitesa02 1955 1 BOS AL 143 544 65 142 30 4 11 64 1 2 44 58 4 7 5 3 23
38106 woodlge01 1955 1 BAL AL 47 145 22 32 6 2 3 18 1 1 24 18 4 1 0 3 2
38112 yosted01 1955 1 WS1 AL 122 375 64 91 17 5 7 48 4 3 95 54 0 11 6 3 7
38143 bankser01 1956 1 CHN NL 139 538 82 160 25 8 28 85 6 9 52 62 18 0 0 3 7
38148 baumhfr01 1956 1 PHI NL 76 100 13 27 0 0 0 9 0 2 6 6 0 1 2 3 3
38152 bellgu01 1956 1 CIN NL 150 603 82 176 31 4 29 84 6 2 50 66 4 3 7 3 10
38171 boyerke01 1956 1 SLN NL 150 595 91 182 30 2 26 98 8 3 38 65 7 1 2 3 18
38203 carrach01 1956 1 CLE AL 141 474 60 115 15 1 7 48 0 4 52 61 0 6 9 3 9
38216 colavro01 1956 1 CLE AL 101 322 55 89 11 4 21 65 0 1 49 46 0 2 4 3 4
38220 collijo01 1956 1 NYA AL 100 262 38 59 5 3 7 43 3 1 34 33 2 1 1 3 5
38228 courtcl01 1956 1 WS1 AL 101 283 31 85 20 3 5 44 0 5 20 10 4 9 1 3 9
38250 demaejo01 1956 1 KC1 AL 133 434 41 101 16 1 6 39 3 3 25 73 2 3 3 3 8
38272 ennisde01 1956 1 PHI NL 153 630 80 164 23 3 26 95 7 3 33 62 8 3 3 3 15
38298 francti01 1956 1 BAL AL 139 445 62 115 16 4 9 57 11 5 51 60 4 1 0 3 6
38326 groatdi01 1956 1 PIT NL 142 520 40 142 19 3 0 37 0 3 35 25 3 0 17 3 14
38365 housefr03 1956 1 DET AL 94 321 44 77 6 2 10 44 1 1 21 19 0 3 0 3 15
38395 kazante01 1956 1 PHI NL 117 379 35 80 11 1 4 34 0 2 20 41 6 1 3 3 8
38413 klausbi01 1956 1 BOS AL 135 520 91 141 29 5 7 59 1 0 90 43 0 1 6 3 7
38426 landrho01 1956 1 CHN NL 111 312 22 69 10 3 4 32 0 2 39 38 15 1 7 3 2
38480 mayswi01 1956 1 NY1 NL 152 578 101 171 27 8 36 84 40 10 68 65 20 1 0 3 16
38536 niemabo01 1956 2 BAL AL 114 388 60 125 20 6 12 64 1 5 86 59 3 0 1 3 10
38615 sarnibi01 1956 2 NY1 NL 78 238 16 55 9 3 5 23 0 1 20 31 2 1 3 3 4
38638 skizalo01 1956 2 KC1 AL 83 297 39 94 11 3 11 39 3 1 15 17 1 0 2 3 13
38648 smithha08 1956 2 KC1 AL 37 142 15 39 9 2 2 24 1 1 3 12 0 0 0 3 2
38653 spencda01 1956 1 NY1 NL 146 489 46 108 13 2 14 42 1 3 35 65 2 3 4 3 10
38685 torgeea01 1956 1 DET AL 117 318 61 84 9 3 12 42 6 4 78 47 0 0 1 3 5
38692 tuttlbi01 1956 1 DET AL 140 546 61 138 22 4 9 65 5 4 38 48 1 1 4 3 18
38713 whisepe01 1956 1 CHN NL 103 314 37 75 16 3 11 46 8 2 24 53 1 1 5 3 6
38730 woodlge01 1956 1 CLE AL 100 317 56 83 17 0 8 38 2 6 69 29 2 3 7 3 6
38741 aaronha01 1957 1 ML1 NL 151 615 118 198 27 6 44 132 1 1 57 58 15 0 0 3 13
38788 bollimi01 1957 2 WS1 AL 91 277 29 63 12 1 4 19 2 2 18 59 0 2 4 3 12
38791 bouched01 1957 1 PHI NL 154 574 78 168 35 8 17 76 1 0 84 91 6 14 0 3 15
38792 bowmabo02 1957 1 PHI NL 99 237 31 63 8 2 6 23 0 0 27 50 1 6 5 3 4
38804 browndi01 1957 1 CLE AL 34 114 10 30 4 0 4 22 1 1 4 23 1 0 0 3 1
38811 burgesm01 1957 1 CIN NL 90 205 29 58 14 1 14 39 0 0 24 16 5 0 0 3 4
38827 cervbo01 1957 1 KC1 AL 124 345 35 94 14 2 11 44 1 1 20 57 1 1 2 3 13
38877 dobyla01 1957 1 CHA AL 119 416 57 120 27 2 14 79 2 3 56 79 3 2 0 3 13
38903 foileha01 1957 1 PIT NL 109 281 32 76 10 4 9 36 1 3 37 53 5 0 1 3 5
38910 foxne01 1957 1 CHA AL 155 619 110 196 27 8 6 61 5 6 75 13 2 16 5 3 7
38921 gernedi01 1957 1 BOS AL 99 316 45 75 13 3 14 58 1 1 39 62 3 3 1 3 8

Next page

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