Table Definitions (Plain Text format - 26 KB)
Database in Comma-Delimited Form with Table Defs (Zipped Plain Text format - 8207 KB)
Database in mySQL Form (Zipped SQL format - 8566 KB)
Individual Tables in Comma-Delimited Form with Table Defs (Zipped Plain Text format)
Release Notes (last change 2011/03/28)
Consistency Query Results (last change 2011/03/28)
BDB Tables and row count
A volunteer effort to accumulate and redistribute baseball data in a convenient and easy to use form.
This is an open list that allows folks to discuss new features and bug fixes for the BDB.
We are undergoing a big change in db format and also governance, so there will be considerably change in the next two months.
We don't want to duplicate work we don't need to, so this will list the projects currently undertaken and the data currently accumulated by different project members. Contact project members through the mailing list through a public message or private note.
Since we have a bunch of folks posting errors and posting errors multiple times isn't really productive. I'm going to propose the following convention for subject lines.
ERROR - teams - ID LAN used for 2001 instead of LAD
First we show that we are posting an error, second the table or tables involved and third a brief description of the error. In this case, I'm just pointing out that the Dodgers have a different team ID for 2001 than for the previous 40 years.
Unless you can't avoid it, I think posting separate notes for separate tables is the way to go. That will make it easier for people to tick off corrections to their databases as they come in.
In addition to ERROR, you can come up with whatever terms seem appropriate.
Some possibilities (an organic evolution is more likely to stick.
SCHEMA - regarding suggestions about table and db structure
NEWDATA - newly available information, like someone died
Page maintained by Sean Forman
Last Modified: .