Batting
107,429 rows sorted by H
This data as json, CSV (advanced)
These facets timed out: stint
Link | rowid | playerID | yearID | stint | teamID | lgID | G | AB | R | H ▼ | 2B | 3B | HR | RBI | SB | CS | BB | SO | IBB | HBP | SH | SF | GIDP |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | abercda01 | 1871 | 1 | TRO | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
12 | 12 | battijo01 | 1871 | 1 | CL1 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | |||||
17 | 17 | berkena01 | 1871 | 1 | PH1 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | |||||
20 | 20 | biermch01 | 1871 | 1 | FW1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | |||||
36 | 36 | ewellge01 | 1871 | 1 | CL1 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
80 | 80 | nortofr01 | 1871 | 1 | WS3 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||
84 | 84 | phelpne01 | 1871 | 1 | FW1 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | |||||
101 | 101 | stearbi01 | 1871 | 1 | WS3 | 2 | 9 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 2 | 0 | |||||
109 | 109 | whitewa01 | 1871 | 1 | WS3 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
127 | 127 | barrebi01 | 1872 | 1 | WS3 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
171 | 171 | galvijo01 | 1872 | 1 | BR2 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
185 | 185 | higby01 | 1872 | 1 | BR2 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
193 | 193 | hurledi01 | 1872 | 1 | WS3 | 2 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||
197 | 197 | kennejo01 | 1872 | 1 | BR2 | 5 | 19 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | |||||
198 | 198 | kingma01 | 1872 | 1 | TRO | 3 | 11 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | |||||
216 | 216 | mcdonja01 | 1872 | 2 | BR1 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | |||||
226 | 226 | mulle01 | 1872 | 1 | CL1 | 1 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
230 | 230 | orour01 | 1872 | 1 | BR1 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
250 | 250 | spenc01 | 1872 | 1 | WS4 | 1 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
269 | 269 | yeatmbi01 | 1872 | 1 | WS4 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||
279 | 279 | atkined01 | 1873 | 1 | WS5 | 2 | 8 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
310 | 310 | eland01 | 1873 | 1 | BL4 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
322 | 322 | goldswa01 | 1873 | 1 | BL4 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
333 | 333 | johnsto01 | 1873 | 1 | BL4 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | |||||
348 | 348 | mcdoo01 | 1873 | 1 | BL4 | 1 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
360 | 360 | phelpne01 | 1873 | 1 | NY2 | 1 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
362 | 362 | popplge01 | 1873 | 1 | BL4 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
373 | 373 | sheppjo01 | 1873 | 1 | BL4 | 3 | 11 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||
390 | 390 | woltery01 | 1873 | 1 | ELI | 1 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
391 | 391 | woodhre01 | 1873 | 1 | BL4 | 1 | 5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
414 | 414 | brown01 | 1874 | 1 | BL1 | 2 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
417 | 417 | carlle01 | 1874 | 1 | BL1 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
423 | 423 | connete01 | 1874 | 1 | CH2 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
440 | 440 | gaver01 | 1874 | 1 | BR2 | 1 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
459 | 459 | kohlehe01 | 1874 | 1 | BL1 | 2 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
471 | 471 | mckenfr01 | 1874 | 1 | PH2 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||
479 | 479 | oneal01 | 1874 | 1 | HR1 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||
490 | 490 | reedhu01 | 1874 | 1 | BL1 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
492 | 492 | revilhe01 | 1874 | 1 | BL1 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
500 | 500 | smilebi01 | 1874 | 1 | BL1 | 2 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
516 | 516 | wood01 | 1874 | 1 | BL1 | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||
528 | 528 | arundha01 | 1875 | 1 | BR2 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
531 | 531 | barloto01 | 1875 | 2 | BR2 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
541 | 541 | bolan01 | 1875 | 1 | BR2 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
543 | 543 | booth01 | 1875 | 1 | NH1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||
550 | 550 | bradyst01 | 1875 | 2 | HR1 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||
552 | 552 | brownol01 | 1875 | 1 | BR2 | 3 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
575 | 575 | dillojo01 | 1875 | 1 | SL1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
627 | 627 | jonesch01 | 1875 | 2 | HR1 | 1 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||
631 | 631 | knighge01 | 1875 | 1 | NH1 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
665 | 665 | munnho01 | 1875 | 1 | BR2 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
691 | 691 | rextewi01 | 1875 | 1 | BR2 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
700 | 700 | shaff01 | 1875 | 1 | BR2 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
702 | 702 | sheri01 | 1875 | 1 | BR2 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||
704 | 704 | smithjo01 | 1875 | 1 | NH1 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | |||||
726 | 726 | walkeos01 | 1875 | 1 | BR2 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||
732 | 732 | withech01 | 1875 | 1 | WS6 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
748 | 748 | berghjo01 | 1876 | 1 | PHN | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | |||||||
777 | 777 | fairge01 | 1876 | 1 | NY3 | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
779 | 779 | fieldsa01 | 1876 | 1 | CN1 | NL | 4 | 14 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | |||||||
784 | 784 | forceda01 | 1876 | 2 | NY3 | NL | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
797 | 797 | heubege01 | 1876 | 1 | NY3 | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
806 | 806 | laffefl01 | 1876 | 1 | PHN | NL | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
807 | 807 | larkite01 | 1876 | 1 | NY3 | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
817 | 817 | mcguijo01 | 1876 | 1 | NY3 | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
822 | 822 | mullejo01 | 1876 | 1 | PHN | NL | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
825 | 825 | nichotr01 | 1876 | 1 | BSN | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
827 | 827 | parksbi01 | 1876 | 1 | BSN | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
830 | 830 | pearcfr01 | 1876 | 1 | LS1 | NL | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
832 | 832 | phelpne01 | 1876 | 1 | NY3 | NL | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | |||||||
833 | 833 | phelpne01 | 1876 | 2 | PHN | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
840 | 840 | sewarge01 | 1876 | 1 | NY3 | NL | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
850 | 850 | treacpe01 | 1876 | 1 | NY3 | NL | 2 | 5 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||||
851 | 851 | valenbo01 | 1876 | 1 | NY3 | NL | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
853 | 853 | warnefr01 | 1876 | 1 | PHN | NL | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
854 | 854 | westbi01 | 1876 | 1 | NY3 | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
859 | 859 | wrighha01 | 1876 | 1 | BSN | NL | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | |||||||
874 | 874 | buncejo01 | 1877 | 1 | HAR | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
890 | 890 | fishech01 | 1877 | 1 | CHN | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | |||||||
898 | 898 | haldejo01 | 1877 | 1 | LS1 | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
917 | 917 | littlha01 | 1877 | 2 | LS1 | NL | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||
931 | 931 | newelte01 | 1877 | 1 | SL3 | NL | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
959 | 959 | wrighha01 | 1877 | 1 | BSN | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | |||||||
978 | 978 | fishech01 | 1878 | 1 | PRO | NL | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
995 | 995 | jennial01 | 1878 | 1 | ML2 | NL | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |||||||
1044 | 1044 | allisdo01 | 1879 | 1 | PRO | NL | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | |||||||
1066 | 1066 | dolanto01 | 1879 | 1 | CHN | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | |||||||
1089 | 1089 | gunklfr01 | 1879 | 1 | CL2 | NL | 1 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | |||||||
1097 | 1097 | hoffmhi01 | 1879 | 1 | CL2 | NL | 2 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | |||||||
1111 | 1111 | libbyst01 | 1879 | 1 | BFN | NL | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | |||||||
1113 | 1113 | magnejo01 | 1879 | 1 | CN1 | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||
1132 | 1132 | osterch01 | 1879 | 1 | SR1 | NL | 2 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
1151 | 1151 | stockle01 | 1879 | 1 | CL2 | NL | 2 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | |||||||
1160 | 1160 | wheelha01 | 1879 | 1 | CN1 | NL | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | |||||||
1174 | 1174 | bootham01 | 1880 | 1 | CN1 | NL | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
1176 | 1176 | briodfa01 | 1880 | 1 | TRN | NL | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
1213 | 1213 | geerbi01 | 1880 | 1 | WOR | NL | 2 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
1221 | 1221 | haleyfr01 | 1880 | 1 | TRN | NL | 2 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | |||||||
1235 | 1235 | kearnto01 | 1880 | 1 | BFN | NL | 2 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
1244 | 1244 | learyja01 | 1880 | 1 | BSN | NL | 1 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
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 );