107,357 rows

View and edit SQL

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
201 1872 BS1   leonaan01 46 46 46 46 0 0 0 4 6 1 38 0 0 38 0 0 0
202 1872 BR1   leutz01 4 4 4 4 0 4 0 0 0 0 0 0 0 0 0 0 0
203 1872 BR2   lowech01 6 6 6 6 0 0 0 6 0 0 0 0 0 0 0 0 0
204 1872 PH1   mackde01 47 47 47 47 0 0 26 0 0 21 0 0 0 0 0 0 0
205 1872 PH1   malonfe01 41 41 41 41 0 24 17 0 0 0 0 0 0 0 0 0 0
206 1872 BR1   malonma01 4 4 4 4 2 0 0 0 0 0 0 0 2 2 0 0 0
207 1872 BR1   martial01 4 4 4 4 0 0 0 4 0 0 0 0 0 0 0 0 0
208 1872 BR1   martiph01 16 16 16 16 8 0 0 0 0 0 0 0 9 9 0 0 0
209 1872 TRO   martiph01 25 25 25 25 8 0 0 0 0 0 0 0 25 25 0 0 0
210 1872 BL1   mathebo01 49 49 49 49 48 0 0 0 3 0 0 0 8 8 0 0 0
211 1872 TRO   mcatebu01 25 25 25 25 0 0 25 0 0 0 0 0 0 0 0 0 0
212 1872 PH1   mcbridi01 47 47 47 47 47 0 0 0 0 0 0 0 0 0 0 0 0
213 1872 MID   mccarfr01 16 16 16 16 0 0 0 0 0 0 0 15 1 16 0 0 0
214 1872 BR1   mcderjo01 7 7 7 7 7 0 0 0 0 0 0 0 0 0 0 0 0
215 1872 BR1   mcdonja01 1 1 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0
216 1872 BR2   mcdonja01 15 15 15 15 0 0 0 0 0 0 1 0 14 15 0 0 0
217 1872 PH1   mcgeami01 47 47 47 47 0 23 0 0 0 23 0 0 1 1 0 0 0
218 1872 NY2   mcmuljo01 53 53 53 53 3 0 0 0 0 0 40 1 11 52 0 0 0
219 1872 BS1   mcveyca01 46 46 46 46 0 40 0 0 1 0 2 0 9 11 0 0 0
220 1872 PH1   meyerle01 27 27 27 27 0 0 0 0 1 0 0 0 26 26 0 0 0
221 1872 WS4   millejo01 1 1 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0
222 1872 NY2   millsch01 6 6 6 6 0 3 0 0 0 0 0 0 4 4 0 0 0
223 1872 BL1   millsev01 54 54 54 54 0 0 54 0 0 0 0 0 0 0 0 0 0
224 1872 WS4   minched01 10 10 10 10 0 0 0 0 0 0 10 0 0 10 0 0 0
225 1872 CL1   mulle01 1 0 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
226 1872 MID   murnati01 21 21 21 21 0 0 21 0 0 0 0 0 0 0 0 0 0
227 1872 BR1   nelsoca01 16 16 16 16 0 0 0 7 3 0 0 8 0 8 0 0 0
228 1872 TRO   nelsoca01 4 4 4 4 0 0 0 0 0 1 0 3 0 3 0 0 0
229 1872 BR1   orour01 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0
230 1872 MID   orourji01 20 20 20 20 0 8 0 0 2 13 0 0 0 0 0 0 0
231 1872 CL1   paborch01 21 21 21 21 2 0 0 0 0 0 19 0 0 19 0 0 0
232 1872 BR1   patteda01 10 10 10 10 0 0 1 0 0 0 2 7 0 9 0 0 0
233 1872 NY2   pearcdi01 43 43 43 43 0 0 0 0 0 41 1 0 1 2 0 0 0
234 1872 BL1   pikeli01 55 55 55 55 0 0 0 24 9 0 6 5 15 24 0 0 0
235 1872 CL1   prattal01 16 16 16 16 15 0 0 0 0 0 0 0 7 7 0 0 0
236 1872 BL1   radcljo01 55 55 55 55 0 0 0 1 6 49 0 0 0 0 0 0 0
237 1872 PH1   reachal01 24 23 24 24 0 0 4 0 0 0 0 0 20 20 0 0 0
238 1872 WS3   reachbo01 2 2 2 2 0 0 0 0 0 2 0 0 0 0 0 0 0
239 1872 BR2   remseja01 36 36 36 36 0 0 0 0 0 0 0 36 0 36 0 0 0
240 1872 WS3   robinva01 7 7 7 7 0 0 0 0 0 0 0 0 7 7 0 0 0
241 1872 BS1   rogerfr01 45 45 45 45 0 0 6 0 0 0 4 0 38 41 0 0 0
242 1872 BS1   schafha01 48 48 48 48 0 2 0 0 43 0 5 0 0 5 0 0 0
243 1872 WS3   selmafr01 9 9 9 9 0 7 0 0 2 0 0 0 0 0 0 0 0
244 1872 PH1   senseco01 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
245 1872 CL1   simmojo01 18 18 18 18 0 0 15 0 0 0 1 0 2 3 0 0 0
246 1872 BR1   snydeji01 23 23 23 23 0 1 0 0 0 22 0 0 1 1 0 0 0
247 1872 BR1   snydejo01 8 8 8 8 0 0 0 0 0 0 8 0 0 8 0 0 0
248 1872 BS1   spaldal01 48 48 48 48 48 0 0 0 0 0 0 7 0 7 0 0 0
249 1872 WS4   spenc01 1 1 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0
250 1872 NY2   startjo01 54 54 54 54 0 0 54 0 0 0 0 0 0 0 0 0 0
251 1872 WS4   stearbi01 10 10 10 10 10 0 0 0 0 0 0 0 0 0 0 0 0
252 1872 WS4   studlse01 5 5 5 5 0 0 0 0 0 0 0 5 0 5 0 0 0
253 1872 CL1   suttoez01 22 22 22 22 0 0 0 0 22 0 0 0 0 0 0 0 0
254 1872 BR1   swandma01 12 12 12 12 0 0 1 1 6 0 0 4 0 4 0 0 0
255 1872 CL1   sweasch01 12 12 12 12 0 0 0 11 0 0 0 0 1 1 0 0 0
256 1872 BR2   thakeal01 18 18 18 18 0 0 0 1 0 0 18 0 0 18 0 0 0
257 1872 MID   tippeji01 21 21 21 21 0 0 0 0 5 0 16 0 0 16 0 0 0
258 1872 PH1   treacfr01 47 47 47 47 0 0 0 0 0 0 0 47 0 47 0 0 0
259 1872 WS3   waterfr01 9 9 9 9 0 2 0 0 7 0 0 0 0 0 0 0 0
260 1872 CL1   whitede01 22 22 22 22 0 14 0 7 0 0 2 1 3 5 0 0 0
261 1872 WS4   whitewa01 9 9 9 9 0 0 0 0 8 1 0 0 0 0 0 0 0
262 1872 CL1   woltery01 16 16 16 16 12 0 0 0 0 0 0 0 11 11 0 0 0
263 1872 BR1   woodji01 7 7 7 7 0 0 0 7 0 0 0 0 0 0 0 0 0
264 1872 TRO   woodji01 25 25 25 25 0 0 0 25 0 0 0 0 0 0 0 0 0
265 1872 BR2   worthhe01 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
266 1872 BS1   wrighge01 48 48 48 48 0 0 0 0 0 48 0 0 0 0 0 0 0
267 1872 BS1   wrighha01 48 48 48 48 7 0 0 0 0 0 0 48 0 48 0 0 0
268 1872 WS4   yeatmbi01 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0
269 1872 BL1   yorkto01 50 50 50 50 0 0 0 0 0 0 50 0 1 50 0 0 0
270 1872 BR1   zettlge01 9 9 9 9 9 0 0 0 0 0 0 0 1 1 0 0 0
271 1872 TRO   zettlge01 25 25 25 25 25 0 0 0 0 0 0 0 8 8 0 0 0
272 1873 BS1   addybo01 31   31   0 0 0 0 0 0 0 0 31 31 0    
273 1873 PH2   addybo01 10   10   0 0 0 10 0 0 0 0 0 0 0    
274 1873 ELI   allisar01 23   23   0 1 3 0 0 0 8 9 4 21 0    
275 1873 ELI   allisdo01 19   19   0 18 0 0 0 0 0 1 3 4 0    
276 1873 NY2   allisdo01 11   11   0 11 0 0 0 0 0 0 1 1 0    
277 1873 PH1   ansonca01 52   52   0 3 36 3 11 0 0 3 0 3 0    
278 1873 WS5   atkined01 2   2   0 0 0 0 0 0 0 0 2 2 0    
279 1873 ELI   austihe01 23   23   0 0 0 0 0 0 0 14 9 23 0    
280 1873 BR2   barloto01 55   55   0 55 0 1 0 1 0 0 0 0 0    
281 1873 BS1   barnero01 60   60   0 0 0 47 13 0 0 0 0 0 0    
282 1873 BL1   barrebi01 1   1   0 0 0 0 0 1 0 0 1 1 0    
283 1873 PH1   battijo01 1   1   0 0 0 0 0 0 0 1 0 1 0    
284 1873 WS5   bealsto01 37   37   0 13 0 26 0 0 1 0 0 1 0    
285 1873 PH2   bechtge01 53   53   3 0 0 0 0 0 0 2 50 52 0    
286 1873 NY2   bellast01 8   8   0 0 0 3 7 0 0 0 0 0 0    
287 1873 WS5   bielaos01 38   38   0 0 0 0 0 0 2 0 36 38 0    
288 1873 BS1   birdsda01 3   3   0 0 0 0 0 0 1 0 3 3 0    
289 1873 BR2   boothed01 16   16   0 0 0 0 0 0 0 4 12 16 0    
290 1873 ELI   boothed01 18   18   0 0 0 1 0 0 15 0 2 17 0    
291 1873 BR2   boydbi01 48   48   0 0 0 0 8 0 0 0 43 43 0    
292 1873 BL1   brainas01 16   16   14 0 0 1 0 0 0 0 2 2 0    
293 1873 BR2   brittji01 54   54   54 0 0 0 0 0 0 0 3 3 0    
294 1873 BR2   burdoja01 55   55   0 2 0 55 0 0 0 0 0 0 0    
295 1873 ELI   campbhu01 20   20   19 0 0 1 0 1 0 0 1 1 0    
296 1873 ELI   campbmi02 21   21   0 0 18 0 0 3 0 0 1 1 0    
297 1873 BL1   careyto01 56   56   0 0 0 54 4 3 0 0 0 0 0    
298 1873 PH1   clappjo01 45   45   0 43 0 1 0 6 0 1 0 1 0    
299 1873 ELI   clintji01 9   9   0 0 0 0 9 0 0 0 0 0 0    
300 1873 ELI   cranefr01 1   1   0 0 0 1 0 0 0 0 0 0 0    

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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