Minor League Statistics - Spritze - Page 4

terpsfan101 · 03-03-2010, 01:48 PM

Thanks for the latest fix.

terpsfan101 · 03-20-2010, 01:20 AM

I finally finished work on the first version of an enhanced Baseball Databank/Lahman database. Obviously, this database will not work with the game, unless you move some columns around and delete the columns not contained in the original Lahman/BDB tables. A write-up with table defintions and data sources is coming. I'm not afraid to say that this is the most complete and accurate baseball database around. I provided a database shell (MS Access). You'll have to manually import the tables. Here's the database link:

BDB 2010 v0.1.zip

terpsfan101 · 03-21-2010, 05:58 PM

Spritze, there are some duplicate player lines for a lot of the Japanese players in your unadulterated minor league tables. I tried to clean them up, but I ran into a road-block in the early 50's. I can't tell which duplicate line I should delete. For instance, take a look at "KozurMa95" for 1949 in the batting, and fielding tables. Which line should I delete? Let me also point out that the duplicate player line issue shows up in the FieldingOF table.

terpsfan101 · 03-23-2010, 08:01 PM

It took some patience, but I was able to remove the duplicate stat lines for some Japanese players in the Batting, Fielding, Pitching, and OF tables. I also fixed the negative caught stealings by changing them to zero. Here's a fixed version of Spritze's unadulterated minor league stats:

Unadulterated Minor League Stats (Fixed).zip

03-03-2010, 01:48 PM	#61
terpsfan101 Minors (Rookie Ball) Join Date: Feb 2010 Posts: 31	Thanks for the latest fix.

03-20-2010, 01:20 AM	#62
terpsfan101 Minors (Rookie Ball) Join Date: Feb 2010 Posts: 31	I finally finished work on the first version of an enhanced Baseball Databank/Lahman database. Obviously, this database will not work with the game, unless you move some columns around and delete the columns not contained in the original Lahman/BDB tables. A write-up with table defintions and data sources is coming. I'm not afraid to say that this is the most complete and accurate baseball database around. I provided a database shell (MS Access). You'll have to manually import the tables. Here's the database link: BDB 2010 v0.1.zip

03-21-2010, 05:58 PM	#63
terpsfan101 Minors (Rookie Ball) Join Date: Feb 2010 Posts: 31	Spritze, there are some duplicate player lines for a lot of the Japanese players in your unadulterated minor league tables. I tried to clean them up, but I ran into a road-block in the early 50's. I can't tell which duplicate line I should delete. For instance, take a look at "KozurMa95" for 1949 in the batting, and fielding tables. Which line should I delete? Let me also point out that the duplicate player line issue shows up in the FieldingOF table.

03-23-2010, 08:01 PM	#64
terpsfan101 Minors (Rookie Ball) Join Date: Feb 2010 Posts: 31	It took some patience, but I was able to remove the duplicate stat lines for some Japanese players in the Batting, Fielding, Pitching, and OF tables. I also fixed the negative caught stealings by changing them to zero. Here's a fixed version of Spritze's unadulterated minor league stats: Unadulterated Minor League Stats (Fixed).zip