Batting
7,578 rows where stint = 2
This data as json, CSV (advanced)
Suggested facets: lgID, 3B, CS, IBB, HBP, SH, SF, GIDP
Link | rowid ▼ | playerID | yearID | stint | teamID | lgID | G | AB | R | H | 2B | 3B | HR | RBI | SB | CS | BB | SO | IBB | HBP | SH | SF | GIDP |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
121 | 121 | allisdo01 | 1872 | 2 | BR1 | 18 | 83 | 18 | 28 | 2 | 1 | 0 | 4 | 0 | 0 | 1 | 5 | 0 | |||||
138 | 138 | boothed01 | 1872 | 2 | BR2 | 15 | 62 | 10 | 19 | 4 | 0 | 0 | 7 | 0 | 2 | 0 | 0 | 1 | |||||
141 | 141 | brainas01 | 1872 | 2 | MID | 6 | 25 | 2 | 5 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | |||||
169 | 169 | forceda01 | 1872 | 2 | BL1 | 19 | 95 | 29 | 41 | 2 | 2 | 0 | 14 | 5 | 0 | 1 | 0 | 0 | |||||
173 | 173 | gedneco01 | 1872 | 2 | BR1 | 18 | 71 | 5 | 13 | 1 | 0 | 0 | 6 | 2 | 2 | 0 | 3 | 0 | |||||
175 | 175 | glennjo01 | 1872 | 2 | WS4 | 1 | 4 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
181 | 181 | hastisc01 | 1872 | 2 | BL1 | 13 | 62 | 16 | 19 | 3 | 1 | 0 | 4 | 0 | 1 | 1 | 2 | 0 | |||||
190 | 190 | holdsji01 | 1872 | 2 | BR1 | 3 | 11 | 1 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
209 | 209 | martiph01 | 1872 | 2 | BR1 | 18 | 78 | 13 | 15 | 1 | 1 | 0 | 9 | 3 | 2 | 2 | 3 | 0 | |||||
216 | 216 | mcdonja01 | 1872 | 2 | BR1 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | |||||
229 | 229 | nelsoca01 | 1872 | 2 | BR1 | 18 | 76 | 12 | 19 | 5 | 1 | 0 | 9 | 1 | 0 | 2 | 3 | 0 | |||||
265 | 265 | woodji01 | 1872 | 2 | BR1 | 7 | 31 | 10 | 6 | 1 | 1 | 0 | 0 | 1 | 0 | 4 | 1 | 0 | |||||
272 | 272 | zettlge01 | 1872 | 2 | BR1 | 9 | 34 | 1 | 3 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | |||||
274 | 274 | addybo01 | 1873 | 2 | BS1 | 31 | 152 | 37 | 54 | 6 | 3 | 1 | 32 | 6 | 5 | 2 | 1 | 0 | |||||
277 | 277 | allisdo01 | 1873 | 2 | NY2 | 11 | 48 | 6 | 10 | 0 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 1 | |||||
291 | 291 | boothed01 | 1873 | 2 | BR2 | 16 | 70 | 8 | 14 | 3 | 1 | 0 | 7 | 0 | 1 | 2 | 0 | 0 | |||||
465 | 465 | mannija01 | 1874 | 2 | HR1 | 1 | 5 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
499 | 499 | shaffor01 | 1874 | 2 | NY2 | 1 | 5 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
509 | 509 | sweasch01 | 1874 | 2 | BR2 | 10 | 44 | 4 | 5 | 1 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | |||||
522 | 522 | abadijo01 | 1875 | 2 | BR2 | 1 | 4 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | |||||
525 | 525 | allisar01 | 1875 | 2 | HR1 | 40 | 175 | 26 | 42 | 4 | 1 | 1 | 19 | 1 | 2 | 0 | 3 | 0 | |||||
531 | 531 | barloto01 | 1875 | 2 | BR2 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
534 | 534 | barnibi01 | 1875 | 2 | NY2 | 9 | 34 | 1 | 5 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | |||||
538 | 538 | bechtge01 | 1875 | 2 | PH1 | 35 | 164 | 33 | 46 | 6 | 2 | 0 | 20 | 2 | 0 | 1 | 3 | 1 | |||||
550 | 550 | bradyst01 | 1875 | 2 | HR1 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||
558 | 558 | cassijo01 | 1875 | 2 | NH1 | 6 | 22 | 3 | 3 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | |||||
566 | 566 | cravebi01 | 1875 | 2 | PH1 | 54 | 260 | 71 | 83 | 11 | 11 | 2 | 40 | 8 | 4 | 4 | 5 | 0 | |||||
572 | 572 | dailejo01 | 1875 | 2 | BR2 | 2 | 8 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||
585 | 585 | fieldsa01 | 1875 | 2 | WS6 | 5 | 16 | 0 | 5 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | |||||
589 | 589 | fleetfr01 | 1875 | 2 | BR2 | 26 | 111 | 13 | 25 | 2 | 0 | 0 | 9 | 0 | 0 | 1 | 1 | 1 | |||||
604 | 604 | goldemi01 | 1875 | 2 | CH2 | 39 | 155 | 16 | 40 | 3 | 0 | 0 | 14 | 3 | 2 | 2 | 10 | 0 | |||||
611 | 611 | halliji01 | 1875 | 2 | NY2 | 44 | 203 | 29 | 58 | 6 | 3 | 3 | 21 | 2 | 2 | 1 | 2 | 1 | |||||
622 | 622 | highadi01 | 1875 | 2 | NY2 | 15 | 64 | 12 | 25 | 5 | 0 | 0 | 10 | 0 | 0 | 0 | 1 | 0 | |||||
627 | 627 | jonesch01 | 1875 | 2 | HR1 | 1 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||
635 | 635 | lathaju01 | 1875 | 2 | NH1 | 20 | 76 | 6 | 15 | 1 | 0 | 0 | 5 | 6 | 0 | 0 | 4 | 0 | |||||
644 | 644 | masonch01 | 1875 | 2 | WS6 | 8 | 33 | 2 | 3 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 3 | 0 | |||||
650 | 650 | mcgeepa01 | 1875 | 2 | BR2 | 18 | 65 | 3 | 10 | 3 | 1 | 0 | 5 | 0 | 0 | 1 | 4 | 1 | |||||
652 | 652 | mcginti01 | 1875 | 2 | NH1 | 32 | 131 | 13 | 36 | 3 | 1 | 0 | 10 | 1 | 1 | 0 | 7 | 0 | |||||
660 | 660 | millejo01 | 1875 | 2 | CH2 | 15 | 54 | 1 | 8 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 7 | 0 | |||||
674 | 674 | paborch01 | 1875 | 2 | NH1 | 6 | 23 | 4 | 8 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 1 | 0 | |||||
676 | 676 | parksbi01 | 1875 | 2 | PH2 | 2 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||
684 | 684 | quinnpa02 | 1875 | 2 | HR1 | 5 | 13 | 1 | 3 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 3 | 0 | |||||
708 | 708 | somered01 | 1875 | 2 | NH1 | 33 | 136 | 14 | 29 | 5 | 0 | 0 | 7 | 1 | 2 | 1 | 3 | 0 | |||||
719 | 719 | thompfr01 | 1875 | 2 | WS6 | 11 | 41 | 3 | 4 | 0 | 1 | 0 | 3 | 0 | 0 | 0 | 1 | 0 | |||||
722 | 722 | treacfr01 | 1875 | 2 | PH2 | 43 | 179 | 23 | 38 | 3 | 3 | 0 | 15 | 6 | 3 | 1 | 3 | 3 | |||||
724 | 724 | trenwge01 | 1875 | 2 | NH1 | 6 | 25 | 1 | 6 | 2 | 0 | 0 | 3 | 0 | 0 | 0 | 1 | 0 | |||||
738 | 738 | zettlge01 | 1875 | 2 | PH2 | 21 | 83 | 10 | 15 | 0 | 0 | 0 | 6 | 1 | 0 | 0 | 7 | 2 | |||||
747 | 747 | bechtge01 | 1876 | 2 | NY3 | NL | 2 | 10 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
784 | 784 | forceda01 | 1876 | 2 | NY3 | NL | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
833 | 833 | phelpne01 | 1876 | 2 | PHN | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
901 | 901 | halliji01 | 1877 | 2 | CHN | NL | 19 | 89 | 17 | 25 | 4 | 1 | 0 | 11 | 4 | 2 | |||||||
908 | 908 | jonesch01 | 1877 | 2 | CHN | NL | 2 | 8 | 1 | 3 | 1 | 0 | 0 | 2 | 1 | 0 | |||||||
917 | 917 | littlha01 | 1877 | 2 | LS1 | NL | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||
948 | 948 | smithha01 | 1877 | 2 | CN1 | NL | 10 | 36 | 4 | 9 | 2 | 1 | 0 | 3 | 1 | 5 | |||||||
987 | 987 | halliji01 | 1878 | 2 | IN1 | NL | 3 | 12 | 0 | 3 | 2 | 0 | 0 | 1 | 0 | 2 | |||||||
991 | 991 | healeto01 | 1878 | 2 | IN1 | NL | 12 | 45 | 2 | 8 | 1 | 0 | 0 | 4 | 0 | 14 | |||||||
1016 | 1016 | pikeli01 | 1878 | 2 | PRO | NL | 5 | 22 | 4 | 5 | 0 | 1 | 0 | 4 | 1 | 1 | |||||||
1043 | 1043 | allenja01 | 1879 | 2 | CL2 | NL | 16 | 60 | 7 | 7 | 1 | 1 | 0 | 4 | 1 | 9 | |||||||
1051 | 1051 | brownle01 | 1879 | 2 | CHN | NL | 6 | 21 | 2 | 6 | 1 | 0 | 0 | 3 | 1 | 4 | |||||||
1069 | 1069 | doschhe01 | 1879 | 2 | CHN | NL | 3 | 11 | 1 | 2 | 0 | 0 | 0 | 1 | 0 | 3 | |||||||
1074 | 1074 | farreja02 | 1879 | 2 | PRO | NL | 12 | 51 | 5 | 13 | 2 | 0 | 0 | 5 | 0 | 0 | |||||||
1099 | 1099 | holbebi01 | 1879 | 2 | TRN | NL | 4 | 15 | 1 | 4 | 0 | 0 | 0 | 2 | 0 | 1 | |||||||
1107 | 1107 | kellyki02 | 1879 | 2 | TRN | NL | 6 | 22 | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 1 | |||||||
1116 | 1116 | manseto01 | 1879 | 2 | SR1 | NL | 1 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
1136 | 1136 | purcebl01 | 1879 | 2 | CN1 | NL | 12 | 50 | 10 | 11 | 0 | 0 | 0 | 4 | 0 | 3 | |||||||
1194 | 1194 | dickebu01 | 1880 | 2 | WOR | NL | 31 | 133 | 22 | 39 | 8 | 6 | 0 | 20 | 1 | 2 | |||||||
1196 | 1196 | dignast01 | 1880 | 2 | WOR | NL | 3 | 10 | 1 | 3 | 0 | 1 | 0 | 2 | 0 | 1 | |||||||
1232 | 1232 | houcksa01 | 1880 | 2 | PRO | NL | 49 | 184 | 27 | 37 | 7 | 7 | 1 | 22 | 3 | 6 | |||||||
1251 | 1251 | mcgeami01 | 1880 | 2 | CL2 | NL | 31 | 111 | 14 | 28 | 2 | 1 | 0 | 6 | 4 | 3 | |||||||
1253 | 1253 | mcgunbi01 | 1880 | 2 | WOR | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | |||||||
1264 | 1264 | poormto01 | 1880 | 2 | CHN | NL | 7 | 25 | 3 | 5 | 1 | 2 | 0 | 0 | 0 | 2 | |||||||
1287 | 1287 | tobinbi01 | 1880 | 2 | TRN | NL | 33 | 136 | 14 | 22 | 1 | 1 | 0 | 8 | 4 | 20 | |||||||
1293 | 1293 | wheelha01 | 1880 | 2 | CN1 | NL | 17 | 65 | 1 | 6 | 2 | 0 | 0 | 2 | 0 | 15 | |||||||
1308 | 1308 | bradlge01 | 1881 | 2 | CL2 | NL | 60 | 241 | 21 | 60 | 10 | 1 | 2 | 18 | 4 | 25 | |||||||
1311 | 1311 | brownle01 | 1881 | 2 | PRO | NL | 18 | 75 | 9 | 18 | 3 | 1 | 0 | 10 | 4 | 13 | |||||||
1330 | 1330 | dorgami01 | 1881 | 2 | DTN | NL | 8 | 34 | 5 | 8 | 1 | 0 | 0 | 5 | 1 | 0 | |||||||
1369 | 1369 | mathebo01 | 1881 | 2 | BSN | NL | 19 | 71 | 2 | 12 | 2 | 0 | 0 | 4 | 0 | 5 | |||||||
1378 | 1378 | moynami01 | 1881 | 2 | DTN | NL | 1 | 4 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | |||||||
1393 | 1393 | purcebl01 | 1881 | 2 | BFN | NL | 30 | 113 | 15 | 33 | 7 | 2 | 0 | 17 | 8 | 8 | |||||||
1396 | 1396 | quinnjo01 | 1881 | 2 | WOR | NL | 2 | 7 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||
1399 | 1399 | reillch01 | 1881 | 2 | WOR | NL | 2 | 8 | 2 | 3 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||
1407 | 1407 | smithpo01 | 1881 | 2 | BFN | NL | 3 | 11 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 5 | |||||||
1418 | 1418 | taylobi01 | 1881 | 2 | DTN | NL | 1 | 4 | 0 | 2 | 2 | 0 | 0 | 1 | 0 | 0 | |||||||
1445 | 1445 | bootham01 | 1882 | 2 | LS2 | AA | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||
1472 | 1472 | critcmo01 | 1882 | 2 | SL4 | AA | 4 | 14 | 0 | 3 | 0 | 0 | 0 | 0 | |||||||||
1474 | 1474 | crottjo01 | 1882 | 2 | SL4 | AA | 8 | 28 | 2 | 4 | 1 | 0 | 0 | 3 | |||||||||
1541 | 1541 | kemmlru01 | 1882 | 2 | PT1 | AA | 24 | 97 | 8 | 23 | 4 | 0 | 0 | 1 | |||||||||
1547 | 1547 | landido01 | 1882 | 2 | BL2 | AA | 50 | 175 | 10 | 30 | 1 | 0 | 0 | 3 | |||||||||
1551 | 1551 | learyja01 | 1882 | 2 | BL2 | AA | 4 | 18 | 3 | 4 | 1 | 0 | 0 | 0 | |||||||||
1553 | 1553 | luffhe01 | 1882 | 2 | CN2 | AA | 28 | 120 | 16 | 28 | 2 | 2 | 0 | 6 | 2 | ||||||||
1557 | 1557 | mannfr01 | 1882 | 2 | PH4 | AA | 29 | 121 | 13 | 28 | 7 | 4 | 0 | 4 | |||||||||
1565 | 1565 | mccafha01 | 1882 | 2 | LS2 | AA | 1 | 4 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||
1576 | 1576 | merried01 | 1882 | 2 | WOR | NL | 2 | 8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | |||||||
1582 | 1582 | mortoch01 | 1882 | 2 | SL4 | AA | 9 | 32 | 2 | 2 | 0 | 1 | 0 | 2 | |||||||||
1584 | 1584 | mountfr01 | 1882 | 2 | PH4 | AA | 9 | 36 | 5 | 12 | 3 | 0 | 0 | 2 | |||||||||
1600 | 1600 | piercgr01 | 1882 | 2 | BL2 | AA | 41 | 151 | 10 | 32 | 2 | 1 | 0 | 3 | |||||||||
1612 | 1612 | richmjo01 | 1882 | 2 | PH4 | AA | 18 | 65 | 8 | 12 | 2 | 2 | 0 | 4 | 11 | ||||||||
1622 | 1622 | sayji01 | 1882 | 2 | LS2 | AA | 1 | 4 | 1 | 1 | 0 | 0 | 0 | 0 | |||||||||
1635 | 1635 | smilebi01 | 1882 | 2 | BL2 | AA | 16 | 61 | 3 | 9 | 0 | 0 | 0 | 0 | |||||||||
1637 | 1637 | smithjo02 | 1882 | 2 | WOR | NL | 19 | 70 | 10 | 17 | 3 | 2 | 0 | 5 | 5 | 10 |
Advanced export
JSON shape: default, array, newline-delimited
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 );