Appearances
107,357 rows sorted by G_dh
This data as json, CSV (advanced)
These facets timed out: lgID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8093 | 8093 | 1901 | MLA | AL | anderjo01 | 138 | 138 | 138 | 0 | 0 | 125 | 0 | 0 | 0 | 12 | 0 | 1 | 13 | ||||
8094 | 8094 | 1901 | CLE | AL | bakerbo01 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8095 | 8095 | 1901 | PHA | AL | bakerbo01 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8096 | 8096 | 1901 | DET | AL | barreji01 | 135 | 135 | 135 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 135 | 0 | 135 | ||||
8097 | 8097 | 1901 | BSN | NL | barrysh01 | 11 | 11 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 0 | 0 | 11 | ||||
8098 | 8098 | 1901 | PHI | NL | barrysh01 | 67 | 67 | 67 | 0 | 0 | 0 | 35 | 16 | 1 | 3 | 9 | 1 | 13 | ||||
8099 | 8099 | 1901 | CIN | NL | bayha01 | 41 | 41 | 41 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 | 15 | 40 | ||||
8100 | 8100 | 1901 | PIT | NL | beaumgi01 | 133 | 133 | 133 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 133 | 0 | 133 | ||||
8101 | 8101 | 1901 | CLE | AL | becker01 | 135 | 135 | 135 | 0 | 0 | 0 | 132 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8102 | 8102 | 1901 | CIN | NL | becklja01 | 140 | 140 | 140 | 0 | 0 | 140 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8103 | 8103 | 1901 | CIN | NL | bergebi01 | 87 | 87 | 87 | 0 | 87 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8104 | 8104 | 1901 | NY1 | NL | bernacu01 | 23 | 23 | 23 | 0 | 0 | 0 | 4 | 1 | 2 | 0 | 8 | 7 | 15 | ||||
8105 | 8105 | 1901 | PHA | AL | bernhbi01 | 32 | 32 | 32 | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||
8106 | 8106 | 1901 | BOS | AL | bevilbe01 | 3 | 3 | 3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8107 | 8107 | 1901 | MLA | AL | bonege01 | 12 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 0 | ||||
8108 | 8108 | 1901 | NY1 | NL | bowerfr01 | 59 | 59 | 59 | 0 | 46 | 1 | 3 | 3 | 3 | 0 | 0 | 0 | 0 | ||||
8109 | 8109 | 1901 | CLE | AL | brackja01 | 12 | 12 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8110 | 8110 | 1901 | CLE | AL | bradlbi01 | 133 | 133 | 133 | 1 | 0 | 0 | 0 | 133 | 0 | 0 | 0 | 0 | 0 | ||||
8111 | 8111 | 1901 | CLE | AL | braggdi01 | 4 | 4 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8112 | 8112 | 1901 | CHA | AL | brainda01 | 5 | 5 | 5 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8113 | 8113 | 1901 | PIT | NL | branski01 | 139 | 139 | 139 | 0 | 0 | 139 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8114 | 8114 | 1901 | SLN | NL | breitte01 | 3 | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8115 | 8115 | 1901 | BLA | AL | bresnro01 | 86 | 86 | 86 | 2 | 69 | 0 | 2 | 4 | 0 | 7 | 0 | 1 | 8 | ||||
8116 | 8116 | 1901 | BLA | AL | brodist01 | 83 | 83 | 83 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 72 | 0 | 83 | ||||
8117 | 8117 | 1901 | BSN | NL | brownfr01 | 7 | 7 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 2 | 5 | ||||
8118 | 8118 | 1901 | PHI | NL | brownge01 | 8 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 8 | ||||
8119 | 8119 | 1901 | MLA | AL | bruyeed01 | 26 | 26 | 26 | 0 | 0 | 0 | 3 | 1 | 1 | 0 | 21 | 0 | 21 | ||||
8120 | 8120 | 1901 | NY1 | NL | bueloch01 | 22 | 22 | 22 | 0 | 0 | 0 | 2 | 17 | 0 | 0 | 0 | 0 | 0 | ||||
8121 | 8121 | 1901 | DET | AL | buelofr01 | 70 | 70 | 70 | 0 | 69 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8122 | 8122 | 1901 | SLN | NL | burkeje01 | 142 | 142 | 142 | 0 | 0 | 0 | 0 | 0 | 0 | 142 | 0 | 0 | 142 | ||||
8123 | 8123 | 1901 | CHA | AL | burkeji01 | 42 | 42 | 42 | 0 | 0 | 0 | 0 | 11 | 31 | 0 | 0 | 0 | 0 | ||||
8124 | 8124 | 1901 | MLA | AL | burkeji01 | 64 | 64 | 64 | 0 | 0 | 0 | 0 | 64 | 0 | 0 | 0 | 0 | 0 | ||||
8125 | 8125 | 1901 | PIT | NL | burkeji01 | 14 | 14 | 14 | 0 | 0 | 0 | 0 | 14 | 0 | 0 | 0 | 0 | 0 | ||||
8126 | 8126 | 1901 | SLN | NL | burnsfa01 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8127 | 8127 | 1901 | MLA | AL | butlejo01 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8128 | 8128 | 1901 | CHA | AL | callani01 | 45 | 45 | 45 | 27 | 0 | 0 | 2 | 6 | 0 | 0 | 0 | 0 | 0 | ||||
8129 | 8129 | 1901 | BSN | NL | carnepa01 | 13 | 13 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13 | 13 | ||||
8130 | 8130 | 1901 | PHA | AL | carrch01 | 2 | 2 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8131 | 8131 | 1901 | WS1 | AL | carribi01 | 42 | 42 | 42 | 42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8132 | 8132 | 1901 | PIT | NL | carrle01 | 9 | 9 | 9 | 0 | 0 | 0 | 0 | 1 | 9 | 0 | 0 | 0 | 0 | ||||
8133 | 8133 | 1901 | BRO | NL | carseki01 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8134 | 8134 | 1901 | CIN | NL | casech01 | 3 | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8135 | 8135 | 1901 | DET | AL | caseydo01 | 128 | 128 | 128 | 0 | 0 | 0 | 0 | 127 | 0 | 0 | 0 | 0 | 0 | ||||
8136 | 8136 | 1901 | CLE | AL | cermaed01 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||
8137 | 8137 | 1901 | CHN | NL | chancfr01 | 69 | 69 | 69 | 0 | 13 | 6 | 0 | 0 | 0 | 4 | 1 | 46 | 51 | ||||
8138 | 8138 | 1901 | PIT | NL | chesbja01 | 36 | 36 | 36 | 36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8139 | 8139 | 1901 | CHN | NL | childcu01 | 63 | 63 | 63 | 0 | 0 | 0 | 63 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8140 | 8140 | 1901 | CHN | NL | childpe01 | 60 | 60 | 60 | 0 | 0 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8141 | 8141 | 1901 | SLN | NL | childpe01 | 29 | 29 | 29 | 0 | 0 | 0 | 19 | 0 | 1 | 1 | 1 | 0 | 2 | ||||
8142 | 8142 | 1901 | WS1 | AL | clarkbo02 | 110 | 110 | 110 | 0 | 107 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8143 | 8143 | 1901 | PIT | NL | clarkfr01 | 129 | 129 | 129 | 0 | 0 | 0 | 0 | 1 | 1 | 127 | 0 | 0 | 127 | ||||
8144 | 8144 | 1901 | WS1 | AL | clingbi01 | 137 | 137 | 137 | 0 | 0 | 0 | 0 | 0 | 137 | 0 | 0 | 0 | 0 | ||||
8145 | 8145 | 1901 | BOS | AL | colliji01 | 138 | 138 | 138 | 0 | 0 | 0 | 0 | 138 | 0 | 0 | 0 | 0 | 0 | ||||
8146 | 8146 | 1901 | PHI | NL | connbe01 | 5 | 5 | 5 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8147 | 8147 | 1901 | CLE | AL | connojo03 | 37 | 37 | 37 | 0 | 32 | 0 | 0 | 0 | 1 | 0 | 0 | 4 | 4 | ||||
8148 | 8148 | 1901 | MLA | AL | connojo03 | 38 | 38 | 38 | 0 | 30 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | ||||
8149 | 8149 | 1901 | MLA | AL | conrowi01 | 131 | 131 | 131 | 0 | 0 | 0 | 0 | 12 | 118 | 0 | 0 | 0 | 0 | ||||
8150 | 8150 | 1901 | BSN | NL | cooledu01 | 63 | 63 | 63 | 0 | 0 | 10 | 0 | 0 | 0 | 29 | 24 | 0 | 53 | ||||
8151 | 8151 | 1901 | CIN | NL | corcoto01 | 31 | 31 | 31 | 0 | 0 | 0 | 0 | 0 | 30 | 0 | 0 | 0 | 0 | ||||
8152 | 8152 | 1901 | WS1 | AL | coughbi01 | 137 | 137 | 137 | 0 | 0 | 0 | 0 | 137 | 0 | 0 | 0 | 0 | 0 | ||||
8153 | 8153 | 1901 | CIN | NL | crawfsa01 | 131 | 131 | 131 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 126 | 127 | ||||
8154 | 8154 | 1901 | BOS | AL | crigelo01 | 76 | 76 | 76 | 0 | 68 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8155 | 8155 | 1901 | CLE | AL | cristbi01 | 6 | 6 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8156 | 8156 | 1901 | DET | AL | crockda01 | 28 | 28 | 28 | 0 | 0 | 27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8157 | 8157 | 1901 | CHN | NL | croftha01 | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | ||||
8158 | 8158 | 1901 | BSN | NL | crolifr01 | 49 | 49 | 49 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 46 | 49 | ||||
8159 | 8159 | 1901 | DET | AL | cronija01 | 31 | 31 | 31 | 30 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | ||||
8160 | 8160 | 1901 | CLE | AL | crossfr01 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||
8161 | 8161 | 1901 | PHA | AL | crossla01 | 100 | 100 | 100 | 0 | 0 | 0 | 0 | 100 | 0 | 0 | 0 | 0 | 0 | ||||
8162 | 8162 | 1901 | PHI | NL | crossmo01 | 139 | 139 | 139 | 0 | 0 | 0 | 0 | 0 | 139 | 0 | 0 | 0 | 0 | ||||
8163 | 8163 | 1901 | CHN | NL | cunnibe01 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8164 | 8164 | 1901 | BOS | AL | cuppyni01 | 17 | 17 | 17 | 13 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 4 | ||||
8165 | 8165 | 1901 | BRO | NL | dahlebi01 | 131 | 131 | 131 | 0 | 0 | 0 | 2 | 0 | 129 | 0 | 0 | 0 | 0 | ||||
8166 | 8166 | 1901 | BRO | NL | dalyto01 | 133 | 133 | 133 | 0 | 0 | 0 | 133 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8167 | 8167 | 1901 | NY1 | NL | davisge01 | 130 | 130 | 130 | 0 | 0 | 0 | 0 | 17 | 113 | 0 | 0 | 0 | 0 | ||||
8168 | 8168 | 1901 | PHA | AL | davisha01 | 117 | 117 | 117 | 0 | 0 | 117 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8169 | 8169 | 1901 | BRO | NL | davisle01 | 25 | 25 | 25 | 0 | 0 | 0 | 1 | 0 | 0 | 12 | 2 | 10 | 24 | ||||
8170 | 8170 | 1901 | PIT | NL | davisle01 | 87 | 87 | 87 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 86 | 86 | ||||
8171 | 8171 | 1901 | NY1 | NL | deegadu01 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8172 | 8172 | 1901 | PHI | NL | delahed01 | 139 | 139 | 139 | 0 | 0 | 58 | 0 | 0 | 0 | 82 | 1 | 1 | 84 | ||||
8173 | 8173 | 1901 | CHN | NL | delahji01 | 17 | 17 | 17 | 0 | 0 | 0 | 1 | 17 | 0 | 0 | 0 | 0 | 0 | ||||
8174 | 8174 | 1901 | BSN | NL | demonge01 | 140 | 140 | 140 | 0 | 0 | 0 | 120 | 20 | 0 | 0 | 0 | 0 | 0 | ||||
8175 | 8175 | 1901 | NY1 | NL | denzero01 | 11 | 11 | 11 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8176 | 8176 | 1901 | CHN | NL | dextech01 | 116 | 116 | 116 | 0 | 3 | 54 | 13 | 25 | 0 | 1 | 9 | 11 | 21 | ||||
8177 | 8177 | 1901 | DET | AL | dillopo01 | 74 | 74 | 74 | 0 | 0 | 74 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8178 | 8178 | 1901 | BSN | NL | dinnebi01 | 54 | 54 | 54 | 37 | 0 | 2 | 0 | 0 | 0 | 1 | 1 | 1 | 3 | ||||
8179 | 8179 | 1901 | CIN | NL | dobbsjo01 | 109 | 109 | 109 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 100 | 0 | 100 | ||||
8180 | 8180 | 1901 | NY1 | NL | dohened01 | 13 | 13 | 13 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8181 | 8181 | 1901 | PIT | NL | dohened01 | 11 | 11 | 11 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8182 | 8182 | 1901 | BRO | NL | dolanco01 | 66 | 66 | 66 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 57 | 5 | 64 | ||||
8183 | 8183 | 1901 | CHN | NL | dolanco01 | 43 | 43 | 43 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 41 | 41 | ||||
8184 | 8184 | 1901 | PHA | AL | dolanjo02 | 98 | 98 | 98 | 0 | 0 | 0 | 1 | 35 | 61 | 0 | 0 | 1 | 1 | ||||
8185 | 8185 | 1901 | PHI | NL | dolanjo02 | 10 | 10 | 10 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8186 | 8186 | 1901 | MLA | AL | donahji02 | 37 | 37 | 37 | 0 | 19 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8187 | 8187 | 1901 | PIT | NL | donahji02 | 2 | 2 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | ||||
8188 | 8188 | 1901 | PHI | NL | donahre01 | 34 | 34 | 34 | 34 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8189 | 8189 | 1901 | BLA | AL | donlimi01 | 121 | 121 | 121 | 0 | 0 | 47 | 0 | 0 | 0 | 73 | 1 | 0 | 74 | ||||
8190 | 8190 | 1901 | BRO | NL | donovbi01 | 46 | 46 | 46 | 45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
8191 | 8191 | 1901 | SLN | NL | donovpa01 | 130 | 130 | 130 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 129 | 129 | ||||
8192 | 8192 | 1901 | CLE | AL | donovto01 | 18 | 18 | 18 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 18 |
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 );