-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathlahman-readme.txt
791 lines (643 loc) · 33.4 KB
/
lahman-readme.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
The Lahman Baseball Database 1871-2023
Release Date: April 4, 2024
--------------------------------------------------------------------------------------------------------------------------------------------
README CONTENTS
0.1 Copyright Notice
0.2 Contact Information
1.0 Release Contents
1.1 Introduction
1.2 What's New
1.3 Acknowledgements
1.4 Using this Database
1.5 Revision History
2.0 Data Tables
--------------------------------------------------------------------------------------------------------------------------------------------
0.1 Copyright Notice & Limited Use License
This database is copyright 1996-2024 by Sean Lahman.
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0
Unported License. For details see: http://creativecommons.org/licenses/by-sa/3.0/
For licensing information or further information, contact Sean Lahman at: [email protected]
--------------------------------------------------------------------------------------------------------------------------------------------
0.2 Contact Information
Web site: http://www.baseball1.com
E-Mail : [email protected]
--------------------------------------------------------------------------------------------------------------------------------------------
1.0 Release Contents
This release of the database can be downloaded in several formats. The contents of each version are listed below.
MS Access Versions:
lahman_1871-2023.mdb
readme2023.txt
Comma Delimited Version:
readme.txt
AllStarFull.csv
Appearances.csv
AwardsManagers.csv
AwardsPlayers.csv
AwardsShareManagers.csv
AwardsSharePlayers.csv
Batting.csv
BattingPost.csv
CollegePlaying.csv
Fielding.csv
FieldingOF.csv
FieldingPost.csv
FieldingOFsplit
HallOfFame.csv
HomeGames.csv
Managers.csv
ManagersHalf.csv
Parks.csv
People.csv
Pitching.csv
PitchingPost.csv
readme2023.txt
Salaries.csv
Schools.csv
SeriesPost.csv
Teams.csv
TeamsFranchises.csv
TeamsHalf.csv
--------------------------------------------------------------------------------------------------------------------------------------------
1.1 Introduction
This database contains pitching, hitting, and fielding statistics for Major League Baseball from 1871 through 2023. It includes data from
the two current leagues (American and National), the four other "major" leagues (American Association, Union Association, Players League, and
Federal League), and the National Association of 1871-1875.
This database was created by Sean Lahman, who pioneered the effort to make baseball statistics freely available to the general public. What
started as a one man effort in 1994 has grown tremendously, and now a team of researchers have collected their efforts to make this the
largest and most accurate source for baseball statistics available anywhere. (See Acknowledgements below for a list of the key
contributors to this project.)
None of what we have done would have been possible without the pioneering work of Hy Turkin, S.C. Thompson, David Neft, and Pete
Palmer (among others). All baseball fans owe a debt of gratitude to the people who have worked so hard to build the tremendous set
of data that we have today. Our thanks also to the many members of the Society for American Baseball Research who have helped us over
the years. We strongly urge you to support and join their efforts. Please visit their website (www.sabr.org).
If you have any problems or find any errors, please let us know. Any feedback is appreciated.
--------------------------------------------------------------------------------------------------------------------------------------------
1.2 What's New
Player stats have been updated through the latest season. Supplemental tables except CollegePlaying, Salaries, and Schools have been updated.
Corrected 2022 catcher fielding for SB and CS.
Normalized award names across award tables.
Added non-appearing players to 2022 All-Star data.
Replaced #INF numeric data in PitchingPost table.
The HallOfFame table data has been expanded with the permission of Graham Womack and his fantastic research into Known Veterans and
Era Committee candidates, 1953-current, with some additional data researched and deduced by Bryan Walko. This provides us valuable
insight into not just the people who were voted in by these committees, but also what we know about those who were considered
over time.
Extended length of needed_note on HallOfFame table so additional information could be included.
--------------------------------------------------------------------------------------------------------------------------------------------
1.3 Acknowledgements
Much of the raw data contained in this database comes from the work of Pete Palmer, the legendary statistician, who has had a hand in most
of the baseball encyclopedias published since 1974. He is largely responsible for bringing the batting, pitching, and fielding data out
of the dark ages and into the computer era. Without him, none of this would be possible. For more on Pete's work, please read his own
account at: http://sabr.org/cmsfiles/PalmerDatabaseHistory.pdf
Three people have been key contributors to the work that followed, first by taking the raw data and creating a relational database, and later
by extending the database to make it more accessible to researchers.
Sean Lahman launched the Baseball Archive's website back before most people had heard of the world wide web. Frustrated by the
lack of sports data available, he led the effort to build a baseball database that everyone could use. He created the first version
of the database and began to make it available for free download from his website in 1995.
The work of Sean Forman to create and maintain an online encyclopedia at Baseball-Reference.com was a quantum leap for both fans and
researchers. The website launched in 2000, provIding a user-friendly interface to the Lahman Baseball Database. Forman and Lahman launched
the Baseball Databank in 2001, a group of researchers whose goal was to update and maintain the database as an open source collection available
to all.
Ted Turocy has done the lion's share of the work to updating the main data tables since 2012, automating the work of annual updates and linking
historical data to play-by-play accounts compiled by Retrosheet.
A handful of researchers have made substantial contributions to maintain this database over years. Listed alphabetically, they
are: Derek Adair, Mike Crain, Kevin Johnson, Rod Nelson, Tom Tango, and Paul Wendt. These folks did much of the heavy lifting, and are
largely responsible for the improvements made since 2000.
Others who made important contributions include: Dvd Avins, Clifford Blau, Bill Burgess, Clem Comly, Jeff Burk, Randy Cox,
Mitch Dickerman, Paul DuBois, Mike Emeigh, F.X. Flinn, Bill Hickman, Jerry Hoffman, Dan Holmes, Micke Hovmoller, Peter Kreutzer,
Danile Levine, Bruce Macleod, Ken Matinale, Michael Mavrogiannis, Cliff Otto, Alberto Perdomo, Dave Quinn, John Rickert, Tom Ruane,
Theron Skyles, Hans Van Slooten, Michael Westbay, and Rob Wood.
Many other people have made significant contributions to the database over the years. The contribution of Tom Ruane's effort to the overall
quality of the underlying data has been tremendous. His work at Retrosheet.org integrates the yearly data with the day-by-day data,
creating a reference source of startling depth.
Sean Holtz helped with a major overhaul and redesign before the 2000 season. Keith Woolner was instrumental in helping turn
a huge collection of stats into a relational database in the mid-1990s. Clifford Otto & Ted Nye also helped provide guidance to the early
versions. Lee Sinnis, John Northey & Erik Greenwood helped supply key pieces of data. Many others have written in with corrections and
suggestions that made each subsequent version even better than what preceded it.
The work of the SABR Baseball Records Committee, led by Lyle Spatz has been invaluable. So has the work of Bill Carle and the SABR
Biographical Committee. David Vincent, keeper of the Home Run Log and other bits of hard to find info, was always helpful. The recent
addition of colleges to player bios is the result of much research by members of SABR's Collegiate Baseball committee.
Salary data was first supplied by Doug Pappas, who passed away during the summer of 2004. He was the leading authority on many subjects,
most significantly the financial history of Major League Baseball. We are grateful that he allowed us to include some of the data he
compiled. His work has been continued by the SABR Business of Baseball committee.
Thanks is also due to the staff at the National Baseball Library in Cooperstown who have been so helpful over the years, including
Tim Wiles, Jim Gates, Bruce Markusen, and the rest of the staff.
A special debt of gratitude is owed to Dave Smith and the folks at Retrosheet. There is no other group working so hard to compile and
share baseball data. Their website (www.Retrosheet.org) will give you a taste of the wealth of information Dave and the gang have
collected.
The 2023 version of the Lahman Database was updated and generated by Bryan Walko, who learned about databases from the Lahman Database
back in the late 1990s.
The HallOfFame data has been expanded with the permission of Graham Womack and his fantastic research into Known Veterans and
Era Committee candidates, 1953-current, with some additional data researched and deduced by Bryan Walko. This provides us valuable
insight into not just the people who were voted in by these committees, but also what we know about those who were considered
over time.
Thanks to all contributors great and small. What you have created is a wonderful thing.
--------------------------------------------------------------------------------------------------------------------------------------------
1.4 Using this Database
This version of the database is available in Microsoft Access format, SQL files or in a generic, comma delimited format. Because this
is a relational database, you will not be able to use the data in a flat-database application.
Please note that this is not a stand alone application. It requires a database application or some other application designed specifically
to interact with the database.
If you are unable to import the data directly, you should download the database in the delimited text format. Then use the documentation
in section 2.0 of this document to import the data into your database application.
--------------------------------------------------------------------------------------------------------------------------------------------
1.5 Revision History
Version Date Comments
1.0 December 1992 Database ported from dBase
1.1 May 1993 Becomes fully relational
1.2 July 1993 Corrections made to full database
1.21 December 1993 1993 statistics added
1.3 July 1994 Pre-1900 data added
1.31 February 1995 1994 Statistics added
1.32 August 1995 Statistics added for other leagues
1.4 September 1995 Fielding Data added
1.41 November 1995 1995 statistics added
1.42 March 1996 HOF/All-Star tables added
1.5-MS October 1996 1st public release - MS Access format
1.5-GV October 1996 Released generic comma-delimited files
1.6-MS December 1996 Updated with 1996 stats, some corrections
1.61-MS December 1996 Corrected error in MASTER table
1.62 February 1997 Corrected 1914-1915 batters data and updated
2.0 February 1998 Major Revisions-added teams & managers
2.1 October 1998 Interim release w/1998 stats
2.2 January 1999 New release w/post-season stats & awards added
3.0 November 1999 Major release - fixed errors and 1999 statistics added
4.0 May 2001 Major release - proofed & redesigned tables
4.5 March 2002 Updated with 2001 stats and added new biographical data
5.0 December 2002 Major revision - new tables and data
5.1 January 2004 Updated with 2003 data, and new pitching categories
5.2 November 2004 Updated with 2004 season statistics.
5.3 December 2005 Updated with 2005 season statistics.
5.4 December 2006 Updated with 2006 season statistics.
5.5 December 2007 Updated with 2007 season statistics.
5.6 December 2008 Updated with 2008 season statistics.
5.7 December 2009 Updated for 2009 and added several tables.
5.8 December 2010 Updated with 2010 season statistics.
5.9 December 2011 Updated for 2011 and removed obsolete tables.
2012 December 2012 Updated with 2012 season statistics
2013 December 2013 Updated with 2013 season statistics
2014 December 2014 Updated with 2014 season statistics
2015 December 2015 Updated with 2015 season statistics
2016 February 2017 Updated for 2016 and added several tables
2017 March 2018 Updated for 2017
2018 February 2019 Updated for 2018
2019 February 2020 Updated for 2019
2020 February 2021 Updated for 2020
2021 February 2022 Updated for 2021
2022 February 2023 Updated for 2022
2023 April 2024 Updated for 2023, corrected 2022 catcher fielding SB and CS, normalized award names across award tables
Added non-appearing players to 2022 All-Star data, replaced #INF data in some tables, extended length
of needed_note on HallOfFame table so additional information could be included.
--------------------------------------------------------------------------------------------------------------------------------------------
2.0 Data Tables
The design follows these general principles. Each player is assigned a unique number (playerID). All of the information relating to that player
is tagged with his playerID. The playerIDs are linked to names and birthdates in the People table.
The database is comprised of the following main tables:
People Player names and biographical information
Teams Yearly stats and standings
TeamFranchises Franchise information
Parks List of major league ballparks
Batting Batting statistics
Pitching Pitching statistics
Fielding Fielding statistics
FieldingOF Outfield position data for years where LF/CF/RF fielding data is available
FieldingOFsplit LF/CF/RF game played splits for all years, including those where LF/CF/RF fielding data is not available
Appearances Details on the positions a player appeared at
Managers Managerial statistics
It is supplemented by these tables:
AllStarFull All-Star appearances
BattingPost Post-season batting statistics
PitchingPost Post-season pitching statistics
FieldingPost Post-season fielding data
SeriesPost Post-season series information
HomeGames Number of home games played by each team in each ballpark
ManagersHalf Split season data for managers
TeamsHalf Split season data for teams
AwardsManagers Awards won by managers
AwardsPlayers Awards won by players
AwardsShareManagers Award voting data for manager awards
AwardsSharePlayers Award voting data for player awards
HallofFame Hall of Fame voting data
CollegePlaying List of players and the colleges they attended (last updated 2014)
Salaries Player salary data (last updated 2016)
Schools List of colleges that players attended (last updated 2014)
--------------------------------------------------------------------------------------------------------------------------------------------
PEOPLE TABLE
playerID A unique code assigned to each player. The playerID links the data in this file with records in the other files.
birthYear Year player was born
birthMonth Month player was born
birthDay Day player was born
birthCountry Country where player was born
birthState State where player was born
birthCity City where player was born
deathYear Year player died
deathMonth Month player died
deathDay Day player died
deathCountry Country where player died
deathState State where player died
deathCity City where player died
nameFirst Player's first name
nameLast Player's last name
nameGiven Player's given name (typically first and middle)
weight Player's weight in pounds
height Player's height in inches
bats Player's batting hand (left, right, or both)
throws Player's throwing hand (left or right)
debut Date that player made first major league appearance
finalGame Date that player made first major league appearance (includes date of last played game even if still active)
retroID ID used by Retrosheet
bbrefID ID used by Baseball Reference website
---------------------------------------------------------------------
TEAMS TABLE
yearID Year
lgID League
teamID Team
franchID Franchise (links to TeamsFranchise table)
divID Team's division
Rank Position in final standings
G Games played
GHome Games played at home
W Wins
L Losses
DivWin Division Winner (Y or N)
WCWin Wild Card Winner (Y or N)
LgWin League Champion(Y or N)
WSWin World Series Winner (Y or N)
R Runs scored
AB At bats
H Hits by batters
2B Doubles
3B Triples
HR Homeruns by batters
BB Walks by batters
SO Strikeouts by batters
SB Stolen bases
CS Caught stealing
HBP Batters hit by pitch
SF Sacrifice flies
RA Opponents runs scored
ER Earned runs allowed
ERA Earned run average
CG Complete games
SHO Shutouts
SV Saves
IPOuts Outs Pitched (innings pitched x 3)
HA Hits allowed
HRA Homeruns allowed
BBA Walks allowed
SOA Strikeouts by pitchers
E Errors
DP Double Plays
FP Fielding percentage
name Team's full name
park Name of team's home ballpark
attendance Home attendance total
BPF Three-year park factor for batters
PPF Three-year park factor for pitchers
teamIDBR Team ID used by Baseball Reference website
teamIDlahman45 Team ID used in Lahman database version 4.5
teamIDretro Team ID used by Retrosheet
--------------------------------------------------------------------------------------------------------------------------------------------
TEAM FRANCHISES TABLE
franchID Franchise ID
franchName Franchise name
active Whether team is currently active or not (Y or N)
NAassoc ID of National Association team franchise played as
--------------------------------------------------------------------------------------------------------------------------------------------
PARKS TABLE
parkkey Ballpark ID code
parkname Name of ballpark
parkalias Alternate names of ballpark, separated by semicolon
city City
state State
country Country
--------------------------------------------------------------------------------------------------------------------------------------------
BATTING TABLE
playerID Player ID code
yearID Year
stint player's stint (order of appearances within a season)
teamID Team
lgID League
G Games
AB At Bats
R Runs
H Hits
2B Doubles
3B Triples
HR Homeruns
RBI Runs Batted In
SB Stolen Bases
CS Caught Stealing
BB Base on Balls
SO Strikeouts
IBB Intentional walks
HBP Hit by pitch
SH Sacrifice hits
SF Sacrifice flies
GIDP Grounded into double plays
--------------------------------------------------------------------------------------------------------------------------------------------
PITCHING TABLE
playerID Player ID code
yearID Year
stint player's stint (order of appearances within a season)
teamID Team
lgID League
W Wins
L Losses
G Games
GS Games Started
CG Complete Games
SHO Shutouts
SV Saves
IPOuts Outs Pitched (innings pitched x 3)
H Hits
ER Earned Runs
HR Homeruns
BB Walks
SO Strikeouts
BAOpp Opponent's Batting Average
ERA Earned Run Average
IBB Intentional Walks
WP Wild Pitches
HBP Batters Hit By Pitch
BK Balks
BFP Batters faced by Pitcher
GF Games Finished
R Runs Allowed
SH Sacrifices by opposing batters
SF Sacrifice flies by opposing batters
GIDP Grounded into double plays by opposing batter
--------------------------------------------------------------------------------------------------------------------------------------------
FIELDING TABLE
playerID Player ID code
yearID Year
stint player's stint (order of appearances within a season)
teamID Team
lgID League
Pos Position
G Games
GS Games Started
InnOuts Time played in the field expressed as outs
PO Putouts
A Assists
E Errors
DP Double Plays
PB Passed Balls (by catchers)
WP Wild Pitches (by catchers)
SB Opponent Stolen Bases (by catchers)
CS Opponents Caught Stealing (by catchers)
ZR Zone Rating
--------------------------------------------------------------------------------------------------------------------------------------------
FIELDING OF TABLE
playerID Player ID code
yearID Year
stint Player's stint (order of appearances within a season)
Glf Games played in left field
Gcf Games played in center field
Grf Games played in right field
--------------------------------------------------------------------------------------------------------------------------------------------
FIELDING OF SPLIT TABLE
playerID Player ID code
yearID Year
stint Player's stint (order of appearances within a season)
teamID Team
lgID League
Pos Position
G Games
GS Games Started
InnOuts Time played in the field expressed as outs
PO Putouts
A Assists
E Errors
DP Double Plays
--------------------------------------------------------------------------------------------------------------------------------------------
APPEARANCES TABLE
yearID Year
teamID Team
lgID League
playerID Player ID code
G_all Total games played
GS Games started
G_batting Games in which player batted
G_defense Games in which player appeared on defense
G_p Games as pitcher
G_c Games as catcher
G_1b Games as first baseman
G_2b Games as second baseman
G_3b Games as third baseman
G_ss Games as shortstop
G_lf Games as left fielder
G_cf Games as center fielder
G_rf Games as right fielder
G_of Games as outfielder
G_dh Games as designated hitter
G_ph Games as pinch hitter
G_pr Games as pinch runner
--------------------------------------------------------------------------------------------------------------------------------------------
MANAGERS TABLE
playerID Player ID Number
yearID Year
teamID Team
lgID League
inseason Managerial order, in order of appearance during the year. One if the individual managed the team the entire year.
G Games managed
W Wins
L Losses
rank Team's final position in standings that year
plyrMgr Player Manager (denoted by 'Y')
--------------------------------------------------------------------------------------------------------------------------------------------
ALL STAR FULL TABLE
playerID Player ID code
YearID Year
gameNum Game number (zero if only one All-Star game played that season)
gameID Retrosheet ID for the game idea
teamID Team
lgID League
GP 1 if Played in the game
startingPos If player was game starter, the position played
--------------------------------------------------------------------------------------------------------------------------------------------
BATTING POST TABLE
yearID Year
round Level of playoffs
playerID Player ID code
teamID Team
lgID League
G Games
AB At Bats
R Runs
H Hits
2B Doubles
3B Triples
HR Homeruns
RBI Runs Batted In
SB Stolen Bases
CS Caught stealing
BB Base on Balls
SO Strikeouts
IBB Intentional walks
HBP Hit by pitch
SH Sacrifices
SF Sacrifice flies
GIDP Grounded into double plays
--------------------------------------------------------------------------------------------------------------------------------------------
PITCHING POST TABLE
playerID Player ID code
yearID Year
round Level of playoffs
teamID Team
lgID League
W Wins
L Losses
G Games
GS Games Started
CG Complete Games
SHO Shutouts
SV Saves
IPOuts Outs Pitched (innings pitched x 3)
H Hits
ER Earned Runs
HR Homeruns
BB Walks
SO Strikeouts
BAOpp Opponents' batting average
ERA Earned Run Average
IBB Intentional Walks
WP Wild Pitches
HBP Batters Hit By Pitch
BK Balks
BFP Batters faced by Pitcher
GF Games Finished
R Runs Allowed
SH Sacrifice Hits allowed
SF Sacrifice Flies allowed
GIDP Grounded into Double Plays
--------------------------------------------------------------------------------------------------------------------------------------------
FIELDING POST TABLE
playerID Player ID code
yearID Year
teamID Team
lgID League
round Level of playoffs
Pos Position
G Games
GS Games Started
InnOuts Time played in the field expressed as outs
PO Putouts
A Assists
E Errors
DP Double Plays
TP Triple Plays
PB Passed Balls
SB Stolen Bases allowed (by catcher)
CS Caught Stealing (by catcher)
--------------------------------------------------------------------------------------------------------------------------------------------
SERIES POST TABLE
yearID Year
round Level of playoffs
teamIDwinner Team ID of the team that won the series
lgIDwinner League ID of the team that won the series
teamIDloser Team ID of the team that lost the series
lgIDloser League ID of the team that lost the series
wins Wins by team that won the series
losses Losses by team that won the series
ties Tie games
--------------------------------------------------------------------------------------------------------------------------------------------
HOME GAMES TABLE
yearkey Year
leaguekey League
teamkey Team ID
parkkey Ballpark ID
spanfirst Date of first game played
spanlast Date of last game played
games Total number of games
openings Total number of paid dates played (games with attendance)
attendance Total attendance
--------------------------------------------------------------------------------------------------------------------------------------------
MANAGERS HALF TABLE
playerID Manager ID code
yearID Year
teamID Team
lgID League
inseason Managerial order, in order of appearance during the year. One if the individual managed the team the entire year.
half First or second half of season
G Games managed
W Wins
L Losses
rank Team's position in standings for the half
--------------------------------------------------------------------------------------------------------------------------------------------
TEAMS HALF TABLE
yearID Year
lgID League
teamID Team
half First or second half of season
divID Division
DivWin Won Division (Y or N)
rank Team's position in standings for the half
G Games played
W Wins
L Losses
--------------------------------------------------------------------------------------------------------------------------------------------
AWARDS MANAGERS TABLE
playerID Manager ID code
awardID Name of award won
yearID Year
lgID League
tie Award was a tie (Y or N)
notes Notes about the award
--------------------------------------------------------------------------------------------------------------------------------------------
AWARDS PLAYERS TABLE
playerID Player ID code
awardID Name of award won
yearID Year
lgID League
tie Award was a tie (Y or N)
notes Notes about the award
--------------------------------------------------------------------------------------------------------------------------------------------
AWARDS SHARE MANAGERS TABLE
awardID Name of award votes were received for
yearID Year
lgID League
playerID Manager ID code
pointsWon Number of points received
pointsMax Maximum number of points possible
votesFirst Number of first place votes
--------------------------------------------------------------------------------------------------------------------------------------------
AWARDS SHARE PLAYERS TABLE
awardID Name of award votes were received for
yearID Year
lgID League
playerID Player ID code
pointsWon Number of points received
pointsMax Maximum number of points possible
votesFirst Number of first place votes
--------------------------------------------------------------------------------------------------------------------------------------------
HALL OF FAME TABLE
playerID Player ID code
yearID Year of ballot
votedBy Method by which player was voted upon
ballots Total ballots cast in that year
needed Number of votes needed for selection in that year
votes Total votes received
inducted Whether player was inducted by that vote or not (Y or N)
category Category in which candidate was honored
needed_note Explanation of qualifiers for special elections, revised in 2023 to include important notes about the record.
--------------------------------------------------------------------------------------------------------------------------------------------
COLLEGE PLAYING TABLE
playerid Player ID code
schoolID School ID code
year Year
--------------------------------------------------------------------------------------------------------------------------------------------
SALARIES TABLE
yearID Year
teamID Team
lgID League
playerID Player ID code
salary Salary
--------------------------------------------------------------------------------------------------------------------------------------------
SCHOOLS TABLE
schoolID School ID code
schoolName School name
schoolCity City where school is located
schoolState State where school's city is located
schoolNick Nickname for school's baseball team
<end of file>