Appearances

107,357 rows

✎ View and edit SQL

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
1 1 1871 TRO   abercda01 1 1 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0
2 2 1871 RC1   addybo01 25 25 25 25 0 0 0 22 0 3 0 0 0 0 0 0 0
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
8 8 1871 BS1   barnero01 31 31 31 31 0 0 0 16 0 15 0 0 0 0 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
11 11 1871 CL1   bassjo01 22 22 22 22 0 1 0 0 0 22 0 0 0 0 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
16 16 1871 TRO   bellast01 29 29 29 29 0 0 0 0 28 1 0 0 0 0 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
30 30 1871 TRO   cravebi01 27 27 27 27 0 3 2 18 0 4 0 0 1 1 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
34 34 1871 CH1   duffyed01 26 26 26 26 0 0 0 0 1 26 0 0 0 0 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
41 41 1871 TRO   flowedi01 21 21 21 21 1 0 0 1 0 20 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
45 45 1871 WS3   forceda01 32 32 32 32 0 0 0 0 1 31 0 0 0 0 0 0 0
46 46 1871 RC1   fulmech01 16 16 16 16 0 0 1 0 0 16 0 0 0 0 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
48 48 1871 FW1   goldswa01 19 19 19 19 0 2 0 0 7 14 0 0 0 0 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
51 51 1871 FW1   halliji01 5 5 5 5 0 0 0 0 0 5 0 0 0 0 0 0 0
52 52 1871 RC1   hamra01 25 25 25 25 0 0 0 0 7 2 19 0 0 19 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
57 57 1871 CH1   hodesch01 28 28 28 28 0 20 0 0 10 1 0 3 1 4 0 0 0
58 58 1871 BS1   jackssa01 16 15 16 16 0 0 0 14 0 1 0 1 0 1 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
61 61 1871 CL1   kimbage01 29 29 29 29 0 0 0 17 2 6 2 1 7 9 0 0 0
62 62 1871 CH1   kingma01 20 20 20 20 0 9 0 0 1 3 1 10 0 11 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
65 65 1871 FW1   lennobi01 12 12 12 12 0 12 0 0 0 2 0 0 1 1 0 0 0
66 66 1871 WS3   leonaan01 31 31 31 31 0 0 0 19 0 1 11 0 0 11 0 0 0
67 67 1871 RC1   mackde01 25 25 25 25 3 0 24 0 0 1 1 0 0 1 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
73 73 1871 TRO   mcgeami01 29 29 29 29 0 26 0 0 0 3 0 0 0 0 0 0 0
74 74 1871 TRO   mcmuljo01 29 29 29 29 29 0 0 0 0 1 0 0 0 0 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
83 83 1871 NY2   pearcdi01 33 33 33 33 0 0 0 0 0 33 0 0 0 0 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
89 89 1871 CL1   questjo01 3 3 3 3 0 0 0 2 0 1 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
91 91 1871 PH1   radcljo01 28 28 28 28 0 0 0 0 0 28 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
93 93 1871 RC1   sagerpo01 8 8 8 8 0 0 0 0 0 5 4 0 0 4 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
95 95 1871 FW1   selmafr01 14 14 14 14 0 5 0 0 14 2 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

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