The great people at the Baseball Databank Yahoo Group and especially Sean Lahman and Dr Theodore L Turocy have compiled a vast amount of data related to baseball. As a passion of mine since I was a kid who would read stats on the back of baseball cards, this data is fascinating to me. I want to make it available to more people as a fully relational database. I plan also to build an OData API on top of the database that people can consume in a multitude of ways. The API should be available in the next week.
The database contains data related to both players and teams from 1873 to 2016.
If anyone wants to have the database I developed, the files are listed below.
- MS SQL Server 2014 Backup file (BaseballStats.bak)
- MS SQL Server 2014 Schema Script (BaseballStats_Schema.sql)
- MS SQL Server 2014 Views Script (BaseballStats_Views.sql)
- MS SQL Server 2014 Data Script (BaseballStats_Data.sql)
To learn more about OData go to http://www.odata.org