5,375 rows sorted by yearID

View and edit SQL

Suggested facets: gameNum, lgID, GP, startingPos

Link rowid playerID yearID ▼ gameNum gameID teamID lgID GP startingPos
5375 bailean01       OAK AL 0  
1 gomezle01 1933 0 ALS193307060 NYA AL 1 1
2 ferreri01 1933 0 ALS193307060 BOS AL 1 2
3 gehrilo01 1933 0 ALS193307060 NYA AL 1 3
4 gehrich01 1933 0 ALS193307060 DET AL 1 4
5 dykesji01 1933 0 ALS193307060 CHA AL 1 5
6 cronijo01 1933 0 ALS193307060 WS1 AL 1 6
7 chapmbe01 1933 0 ALS193307060 WS1 AL 1 7
8 simmoal01 1933 0 ALS193307060 CHA AL 1 8
9 ruthba01 1933 0 ALS193307060 NYA AL 1 9
10 averiea01 1933 0 ALS193307060 CLE AL 1  
11 crowdal01 1933 0 ALS193307060 WS1 AL 1  
12 dickebi01 1933 0 ALS193307060 NYA AL 0  
13 ferrewe01 1933 0 ALS193307060 CLE AL 0  
14 foxxji01 1933 0 ALS193307060 PHA AL 0  
15 grovele01 1933 0 ALS193307060 PHA AL 1  
16 hildeor01 1933 0 ALS193307060 CLE AL 0  
17 lazzeto01 1933 0 ALS193307060 NYA AL 0  
18 westsa01 1933 0 ALS193307060 SLA AL 1  
19 hallabi01 1933 0 ALS193307060 SLN NL 1 1
20 wilsoji01 1933 0 ALS193307060 SLN NL 1 2
21 terrybi01 1933 0 ALS193307060 NY1 NL 1 3
22 friscfr01 1933 0 ALS193307060 SLN NL 1 4
23 martipe01 1933 0 ALS193307060 SLN NL 1 5
24 bartedi01 1933 0 ALS193307060 PHI NL 1 6
25 hafeych01 1933 0 ALS193307060 CIN NL 1 7
26 bergewa01 1933 0 ALS193307060 BSN NL 1 8
27 kleinch01 1933 0 ALS193307060 PHI NL 1 9
28 cuccito01 1933 0 ALS193307060 BRO NL 1  
29 engliwo01 1933 0 ALS193307060 CHN NL 1  
30 hartnga01 1933 0 ALS193307060 CHN NL 1  
31 hubbeca01 1933 0 ALS193307060 NY1 NL 1  
32 odoulle01 1933 0 ALS193307060 NY1 NL 1  
33 schumha02 1933 0 ALS193307060 NY1 NL 0  
34 traynpi01 1933 0 ALS193307060 PIT NL 1  
35 wanerpa01 1933 0 ALS193307060 PIT NL 1  
36 warnelo01 1933 0 ALS193307060 CHN NL 1  
37 gomezle01 1934 0 NLS193407100 NYA AL 1 1
38 dickebi01 1934 0 NLS193407100 NYA AL 1 2
39 gehrilo01 1934 0 NLS193407100 NYA AL 1 3
40 gehrich01 1934 0 NLS193407100 DET AL 1 4
41 foxxji01 1934 0 NLS193407100 PHA AL 1 5
42 cronijo01 1934 0 NLS193407100 WS1 AL 1 6
43 manushe01 1934 0 NLS193407100 WS1 AL 1 7
44 simmoal01 1934 0 NLS193407100 CHA AL 1 8
45 ruthba01 1934 0 NLS193407100 NYA AL 1 9
46 averiea01 1934 0 NLS193407100 CLE AL 1  
47 bridgto01 1934 0 NLS193407100 DET AL 0  
48 chapmbe01 1934 0 NLS193407100 NYA AL 1  
49 cochrmi01 1934 0 NLS193407100 DET AL 1  
50 dykesji01 1934 0 NLS193407100 CHA AL 0  
51 ferreri01 1934 0 NLS193407100 BOS AL 0  
52 hardeme01 1934 0 NLS193407100 CLE AL 1  
53 higgipi01 1934 0 NLS193407100 PHA AL 0  
54 ruffire01 1934 0 NLS193407100 NYA AL 1  
55 russeja01 1934 0 NLS193407100 WS1 AL 0  
56 westsa01 1934 0 NLS193407100 SLA AL 1  
57 hubbeca01 1934 0 NLS193407100 NY1 NL 1 1
58 hartnga01 1934 0 NLS193407100 CHN NL 1 2
59 terrybi01 1934 0 NLS193407100 NY1 NL 1 3
60 friscfr01 1934 0 NLS193407100 SLN NL 1 4
61 traynpi01 1934 0 NLS193407100 PIT NL 1 5
62 jackstr01 1934 0 NLS193407100 NY1 NL 1 6
63 medwijo01 1934 0 NLS193407100 SLN NL 1 7
64 bergewa01 1934 0 NLS193407100 BSN NL 1 8
65 cuyleki01 1934 0 NLS193407100 CHN NL 1 9
66 deandi01 1934 0 NLS193407100 SLN NL 1  
67 frankfr02 1934 0 NLS193407100 BSN NL 1  
68 hermabi01 1934 0 NLS193407100 CHN NL 1  
69 hermabi01 1934 0 NLS193407100 CHN NL 1  
70 kleinch01 1934 0 NLS193407100 CHN NL 1  
71 lopezal01 1934 0 NLS193407100 BRO NL 1  
72 martipe01 1934 0 NLS193407100 SLN NL 1  
73 moorejo02 1934 0 NLS193407100 NY1 NL 0  
74 mungova01 1934 0 NLS193407100 BRO NL 1  
75 ottme01 1934 0 NLS193407100 NY1 NL 1  
76 vaughar01 1934 0 NLS193407100 PIT NL 1  
77 wanerpa01 1934 0 NLS193407100 PIT NL 1  
78 warnelo01 1934 0 NLS193407100 CHN NL 1  
79 gomezle01 1935 0 ALS193507080 NYA AL 1 1
80 hemslro01 1935 0 ALS193507080 SLA AL 1 2
81 gehrilo01 1935 0 ALS193507080 NYA AL 1 3
82 gehrich01 1935 0 ALS193507080 DET AL 1 4
83 foxxji01 1935 0 ALS193507080 PHA AL 1 5
84 cronijo01 1935 0 ALS193507080 BOS AL 1 6
85 johnsbo01 1935 0 ALS193507080 PHA AL 1 7
86 simmoal01 1935 0 ALS193507080 CHA AL 1 8
87 vosmijo01 1935 0 ALS193507080 CLE AL 1 9
88 averiea01 1935 0 ALS193507080 CLE AL 0  
89 bluegos01 1935 0 ALS193507080 WS1 AL 1  
90 bridgto01 1935 0 ALS193507080 DET AL 0  
91 chapmbe01 1935 0 ALS193507080 NYA AL 1  
92 cochrmi01 1935 0 ALS193507080 DET AL 0  
93 cramedo01 1935 0 ALS193507080 PHA AL 1  
94 ferreri01 1935 0 ALS193507080 BOS AL 0  
95 grovele01 1935 0 ALS193507080 BOS AL 0  
96 hardeme01 1935 0 ALS193507080 CLE AL 1  
97 myerbu01 1935 0 ALS193507080 WS1 AL 0  
98 rowesc01 1935 0 ALS193507080 DET AL 0  
99 westsa01 1935 0 ALS193507080 SLA AL 0  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "AllstarFull" (
"playerID" TEXT,
  "yearID" INTEGER,
  "gameNum" INTEGER,
  "gameID" TEXT,
  "teamID" TEXT,
  "lgID" TEXT,
  "GP" INTEGER,
  "startingPos" INTEGER
);