Appearances
107,357 rows sorted by G_ss
This data as json, CSV (advanced)
Link | rowid | yearID | teamID | lgID | playerID | G_all | GS | G_batting | G_defense | G_p | G_c | G_1b | G_2b | G_3b | G_ss ▼ | G_lf | G_cf | G_rf | G_of | G_dh | G_ph | G_pr |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | 3 | 1871 | CL1 | allisar01 | 29 | 29 | 29 | 29 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 29 | 0 | 29 | 0 | 0 | 0 | |
4 | 4 | 1871 | WS3 | allisdo01 | 27 | 27 | 27 | 27 | 0 | 27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
5 | 5 | 1871 | RC1 | ansonca01 | 25 | 25 | 25 | 25 | 0 | 5 | 1 | 2 | 20 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | |
6 | 6 | 1871 | FW1 | armstbo01 | 12 | 12 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 1 | 12 | 0 | 0 | 0 | |
7 | 7 | 1871 | RC1 | barkeal01 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | |
9 | 9 | 1871 | FW1 | barrebi01 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
10 | 10 | 1871 | BS1 | barrofr01 | 18 | 17 | 18 | 18 | 0 | 0 | 0 | 1 | 0 | 0 | 13 | 0 | 4 | 17 | 0 | 0 | 0 | |
12 | 12 | 1871 | CL1 | battijo01 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | |
13 | 13 | 1871 | WS3 | bealsto01 | 10 | 10 | 10 | 10 | 0 | 0 | 0 | 2 | 0 | 0 | 4 | 0 | 4 | 8 | 0 | 0 | 0 | |
14 | 14 | 1871 | TRO | beaveed01 | 3 | 3 | 3 | 3 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
15 | 15 | 1871 | PH1 | bechtge01 | 20 | 19 | 20 | 20 | 3 | 0 | 0 | 0 | 3 | 0 | 1 | 3 | 11 | 15 | 0 | 0 | 0 | |
17 | 17 | 1871 | PH1 | berkena01 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | |
18 | 18 | 1871 | PH1 | berryto01 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | |
19 | 19 | 1871 | WS3 | berthha01 | 17 | 17 | 17 | 17 | 0 | 1 | 0 | 5 | 0 | 0 | 11 | 1 | 0 | 12 | 0 | 0 | 0 | |
20 | 20 | 1871 | FW1 | biermch01 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
21 | 21 | 1871 | RC1 | birdge01 | 25 | 25 | 25 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 25 | 0 | 25 | 0 | 0 | 0 | |
22 | 22 | 1871 | BS1 | birdsda01 | 29 | 29 | 29 | 29 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 27 | 0 | 0 | 0 | |
23 | 23 | 1871 | WS3 | brainas01 | 30 | 30 | 30 | 30 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
24 | 24 | 1871 | CH1 | brannmi01 | 3 | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
25 | 25 | 1871 | WS3 | burrohe01 | 12 | 11 | 12 | 12 | 0 | 0 | 0 | 1 | 5 | 0 | 4 | 0 | 4 | 8 | 0 | 0 | 0 | |
26 | 26 | 1871 | FW1 | careyto01 | 19 | 19 | 19 | 19 | 0 | 0 | 0 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
27 | 27 | 1871 | CL1 | carleji01 | 29 | 29 | 29 | 29 | 0 | 0 | 29 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
28 | 28 | 1871 | BS1 | conefr01 | 19 | 18 | 19 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 0 | 1 | 19 | 0 | 0 | 0 | |
29 | 29 | 1871 | TRO | connone01 | 7 | 7 | 7 | 7 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 0 | 0 | 0 | |
31 | 31 | 1871 | PH1 | cuthbne01 | 28 | 28 | 28 | 28 | 0 | 1 | 0 | 0 | 0 | 0 | 27 | 0 | 0 | 27 | 0 | 0 | 0 | |
32 | 32 | 1871 | FW1 | deaneha01 | 6 | 5 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 6 | 0 | 0 | 0 | |
33 | 33 | 1871 | FW1 | donnepe01 | 9 | 8 | 9 | 9 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 6 | 9 | 0 | 0 | 0 | |
35 | 35 | 1871 | NY2 | eggleda01 | 33 | 33 | 33 | 33 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 33 | 0 | 33 | 0 | 0 | 0 | |
36 | 36 | 1871 | CL1 | ewellge01 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | |
37 | 37 | 1871 | NY2 | fergubo01 | 33 | 33 | 33 | 33 | 1 | 5 | 0 | 11 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
38 | 38 | 1871 | RC1 | fishech01 | 25 | 25 | 25 | 25 | 24 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
39 | 39 | 1871 | PH1 | fislewe01 | 28 | 28 | 28 | 28 | 0 | 0 | 26 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
40 | 40 | 1871 | NY2 | fleetfr01 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
42 | 42 | 1871 | TRO | flynncl01 | 29 | 29 | 29 | 29 | 0 | 0 | 19 | 1 | 1 | 0 | 0 | 0 | 8 | 8 | 0 | 0 | 0 | |
43 | 43 | 1871 | CH1 | foleyto01 | 18 | 18 | 18 | 18 | 0 | 4 | 0 | 0 | 1 | 0 | 2 | 9 | 5 | 16 | 0 | 0 | 0 | |
44 | 44 | 1871 | FW1 | foranji01 | 19 | 19 | 19 | 19 | 0 | 0 | 16 | 0 | 0 | 0 | 3 | 1 | 0 | 4 | 0 | 0 | 0 | |
47 | 47 | 1871 | WS3 | glennjo01 | 26 | 26 | 26 | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 25 | 26 | 0 | 0 | 0 | |
49 | 49 | 1871 | BS1 | gouldch01 | 31 | 31 | 31 | 31 | 0 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | |
50 | 50 | 1871 | WS3 | hallge01 | 32 | 32 | 32 | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 31 | 0 | 32 | 0 | 0 | 0 | |
53 | 53 | 1871 | RC1 | hastisc01 | 25 | 25 | 25 | 25 | 0 | 23 | 1 | 2 | 0 | 0 | 2 | 1 | 0 | 2 | 0 | 0 | 0 | |
54 | 54 | 1871 | NY2 | hatfijo01 | 33 | 33 | 33 | 33 | 0 | 0 | 0 | 7 | 2 | 0 | 24 | 0 | 0 | 24 | 0 | 0 | 0 | |
55 | 55 | 1871 | PH1 | heubege01 | 17 | 17 | 17 | 17 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 16 | 16 | 0 | 0 | 0 | |
56 | 56 | 1871 | NY2 | highadi01 | 21 | 21 | 21 | 21 | 0 | 1 | 0 | 12 | 0 | 0 | 0 | 0 | 8 | 8 | 0 | 0 | 0 | |
59 | 59 | 1871 | CL1 | johnsca01 | 16 | 16 | 16 | 16 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | |
60 | 60 | 1871 | FW1 | kellybi01 | 18 | 17 | 18 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 14 | 18 | 0 | 0 | 0 | |
63 | 63 | 1871 | TRO | kingst01 | 29 | 29 | 29 | 29 | 0 | 0 | 0 | 0 | 0 | 0 | 29 | 0 | 0 | 29 | 0 | 0 | 0 | |
64 | 64 | 1871 | FW1 | kohlehe01 | 3 | 3 | 3 | 3 | 0 | 2 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
68 | 68 | 1871 | PH1 | malonfe01 | 27 | 27 | 27 | 27 | 0 | 27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
69 | 69 | 1871 | FW1 | mathebo01 | 19 | 19 | 19 | 19 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
70 | 70 | 1871 | CH1 | mcatebu01 | 26 | 26 | 26 | 26 | 0 | 0 | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
71 | 71 | 1871 | PH1 | mcbridi01 | 25 | 25 | 25 | 25 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
72 | 72 | 1871 | FW1 | mcderjo01 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | |
75 | 75 | 1871 | BS1 | mcveyca01 | 29 | 29 | 29 | 29 | 0 | 29 | 0 | 0 | 1 | 0 | 0 | 0 | 5 | 5 | 0 | 0 | 0 | |
76 | 76 | 1871 | PH1 | meyerle01 | 26 | 26 | 26 | 26 | 1 | 0 | 0 | 0 | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
77 | 77 | 1871 | NY2 | millsch01 | 32 | 32 | 32 | 32 | 0 | 29 | 0 | 0 | 1 | 0 | 0 | 0 | 4 | 4 | 0 | 0 | 0 | |
78 | 78 | 1871 | WS3 | millsev01 | 32 | 32 | 32 | 32 | 0 | 0 | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
79 | 79 | 1871 | FW1 | minched01 | 9 | 9 | 9 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 0 | 0 | 9 | 0 | 0 | 0 | |
80 | 80 | 1871 | WS3 | nortofr01 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | |
81 | 81 | 1871 | CL1 | paborch01 | 29 | 29 | 29 | 29 | 7 | 0 | 0 | 0 | 0 | 0 | 28 | 0 | 0 | 28 | 0 | 0 | 0 | |
82 | 82 | 1871 | NY2 | patteda01 | 32 | 32 | 32 | 32 | 0 | 0 | 0 | 2 | 0 | 0 | 9 | 0 | 22 | 31 | 0 | 0 | 0 | |
84 | 84 | 1871 | FW1 | phelpne01 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
85 | 85 | 1871 | TRO | pikeli01 | 28 | 28 | 28 | 28 | 0 | 0 | 4 | 7 | 0 | 0 | 0 | 0 | 18 | 18 | 0 | 0 | 0 | |
86 | 86 | 1871 | CH1 | pinkhed01 | 24 | 24 | 24 | 24 | 3 | 0 | 0 | 0 | 18 | 0 | 0 | 0 | 8 | 8 | 0 | 0 | 0 | |
87 | 87 | 1871 | CL1 | prattal01 | 29 | 29 | 29 | 29 | 28 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 2 | 7 | 0 | 0 | 0 | |
88 | 88 | 1871 | PH1 | prattto01 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
90 | 90 | 1871 | FW1 | quinnpa02 | 5 | 5 | 5 | 5 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
92 | 92 | 1871 | PH1 | reachal01 | 26 | 26 | 26 | 26 | 0 | 0 | 0 | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
94 | 94 | 1871 | BS1 | schafha01 | 31 | 31 | 31 | 31 | 0 | 0 | 0 | 0 | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
96 | 96 | 1871 | PH1 | senseco01 | 25 | 25 | 25 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 | 0 | 25 | 0 | 0 | 0 | |
97 | 97 | 1871 | CH1 | simmojo01 | 27 | 26 | 27 | 27 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 10 | 16 | 25 | 0 | 0 | 0 | |
98 | 98 | 1871 | NY2 | smithch01 | 14 | 14 | 14 | 14 | 0 | 0 | 0 | 3 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
99 | 99 | 1871 | BS1 | spaldal01 | 31 | 31 | 31 | 31 | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 0 | 9 | 0 | 0 | 0 | |
100 | 100 | 1871 | NY2 | startjo01 | 33 | 33 | 33 | 33 | 0 | 0 | 33 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
101 | 101 | 1871 | WS3 | stearbi01 | 2 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
102 | 102 | 1871 | RC1 | stirega01 | 25 | 25 | 25 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 | 25 | 0 | 0 | 0 | |
103 | 103 | 1871 | CL1 | suttoez01 | 29 | 29 | 29 | 29 | 0 | 1 | 0 | 0 | 29 | 0 | 0 | 1 | 1 | 2 | 0 | 0 | 0 | |
104 | 104 | 1871 | WS3 | sweasch01 | 5 | 5 | 5 | 5 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
105 | 105 | 1871 | CH1 | treacfr01 | 25 | 25 | 25 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 25 | 0 | 0 | 25 | 0 | 0 | 0 | |
106 | 106 | 1871 | WS3 | waterfr01 | 32 | 32 | 32 | 32 | 0 | 6 | 0 | 0 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
108 | 108 | 1871 | CL1 | whiteel01 | 15 | 15 | 15 | 15 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 15 | 0 | 0 | 0 | |
109 | 109 | 1871 | WS3 | whitewa01 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
110 | 110 | 1871 | NY2 | woltery01 | 32 | 32 | 32 | 32 | 32 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
111 | 111 | 1871 | CH1 | woodji01 | 28 | 28 | 28 | 28 | 0 | 0 | 0 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
114 | 114 | 1871 | TRO | yorkto01 | 29 | 29 | 29 | 29 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 29 | 0 | 29 | 0 | 0 | 0 | |
115 | 115 | 1871 | CH1 | zettlge01 | 28 | 28 | 28 | 28 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 0 | 0 | 0 | |
117 | 117 | 1872 | BR1 | allisan01 | 19 | 19 | 19 | 19 | 0 | 0 | 19 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | |
118 | 118 | 1872 | CL1 | allisar01 | 19 | 18 | 19 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 2 | 19 | 0 | 0 | 0 | |
119 | 119 | 1872 | BR1 | allisbi01 | 5 | 5 | 5 | 5 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 1 | 1 | 2 | 0 | 0 | 0 | |
120 | 120 | 1872 | BR1 | allisdo01 | 16 | 16 | 16 | 16 | 0 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
122 | 122 | 1872 | PH1 | ansonca01 | 46 | 46 | 46 | 46 | 0 | 0 | 0 | 0 | 46 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
123 | 123 | 1872 | MID | arnolbi01 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | |
125 | 125 | 1872 | BS1 | barnero01 | 45 | 45 | 45 | 45 | 0 | 0 | 0 | 45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
126 | 126 | 1872 | BR2 | barre01 | 7 | 7 | 7 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 0 | 7 | 0 | 0 | 0 | |
127 | 127 | 1872 | WS3 | barrebi01 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
128 | 128 | 1872 | BR2 | bassjo01 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | |
131 | 131 | 1872 | NY2 | bechtge01 | 50 | 50 | 50 | 50 | 0 | 0 | 1 | 0 | 0 | 0 | 13 | 0 | 36 | 49 | 0 | 0 | 0 | |
133 | 133 | 1872 | MID | bentlcy01 | 20 | 20 | 20 | 20 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | |
134 | 134 | 1872 | BR1 | besti01 | 3 | 3 | 3 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
135 | 135 | 1872 | WS4 | bielaos01 | 9 | 9 | 9 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 9 | 0 | 0 | 0 | |
136 | 136 | 1872 | BS1 | birdsda01 | 16 | 13 | 16 | 16 | 0 | 12 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 8 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "Appearances" ( "yearID" INTEGER, "teamID" TEXT, "lgID" REAL, "playerID" TEXT, "G_all" INTEGER, "GS" INTEGER, "G_batting" INTEGER, "G_defense" INTEGER, "G_p" INTEGER, "G_c" INTEGER, "G_1b" INTEGER, "G_2b" INTEGER, "G_3b" INTEGER, "G_ss" INTEGER, "G_lf" INTEGER, "G_cf" INTEGER, "G_rf" INTEGER, "G_of" INTEGER, "G_dh" INTEGER, "G_ph" INTEGER, "G_pr" INTEGER );