I'm going to post the updated version of the database to my website within the next few hours. It'll be available from my website http://seanlahman.com --...
4204
dianagram@...
dianagramr
Feb 6, 2012 7:13 pm
Thank YOU Sean for all your good work. -----Original Message----- From: anson2995 Sent: Feb 6, 2012 2:08 PM To: baseball-databank@yahoogroups.com Subject:...
4205
iddwiz
Feb 6, 2012 7:26 pm
Once Sean has released the new database, could some kind soul create a mysqldump and post the script either here or to Sean's site? Much appreciated!!...
4206
Peter Kreutzer
pkreutzer
Feb 6, 2012 8:24 pm
Thanks Sean. I'd like a role in this business, but I'm not a database jock. If you have any ideas for useful work that needs doing, please let me know. Peter ...
4207
Jeff Zimmerman
wydiyd
Feb 6, 2012 10:37 pm
I could host it once someone has it done already. If not, I will import the data and post the .sql in a week or so. Jeff Z....
4208
Matthew Gargano
tkestars
Feb 7, 2012 5:02 pm
In celebration of this momentous occasion, and as a way to further my development experience, I am proud to be releasing a PHP library that I built that wraps...
4209
michael Webb
ShekWebb
Feb 7, 2012 9:31 pm
I converted the access database to MySQL and have a MySQL dump file. Here are the counts for the main tables: select count(*) from master; 17914 select...
4210
mirv
Feb 13, 2012 4:45 am
Alberto - It appears that your stint changes were not incorporated by Sean L. in the lahman59 version of Fielding.csv. Stint numbers are "1" for all 2011...
4211
Clay Dreslough
dreslough
Feb 21, 2012 10:57 am
It looks like Michael Stutes is in the 'Master' file, but not in Batting.csv, Pitching.csv, or Fielding.csv: For the CSV files, here's the line to add to...
4212
Clem Comly
ccomly2003
Feb 21, 2012 2:27 pm
This doesn't look like Stutes. It looks closer to Stutes post season than regular season but it isn't post season either. Clem Comly ... From: Clay Dreslough ...
4213
Clem Comly
ccomly2003
Feb 21, 2012 2:28 pm
Figured it out. From the zip file I downloaded 1/23/12 in all but master.csv Stutes is listed as sttuemi01. Clem Comly ... From: Clay Dreslough To:...
4214
anson2995
Feb 21, 2012 3:27 pm
Clay, I believe this issue was fixed in the updated release, 5.9.1. In the original version, he had the ID "sttuemi01" --Sean...
4215
wydiyd
Feb 24, 2012 9:25 pm
There is no data for 2011 in the salaries table. Is there any plans to correct this issue?...
4216
railsplitter_44
Mar 1, 2012 11:01 am
Hello, I'm currently getting my personal database ready for the 2012 season and I like to keep it with the same player, team, and franchID's as the databank...
4217
Sean Lahman
anson2995
Mar 1, 2012 2:54 pm
My plan is to use "MIA" as the teamID for the Miami Marlins. Don't think BBRef or Retrosheet have weighed in yet. As far as the FranchiseID, my inclination is...
4218
Mike Emeigh
mwemeigh
Mar 1, 2012 4:21 pm
I would expect Retrosheet to leave it alone, as was done when Anaheim became the Los Angeles Angels of Anaheim. Sent from my iPhone...
4219
KJOK
kjokbaseball
Mar 1, 2012 4:22 pm
First, I would strongly advise to leave the FranchiseID as is. Â "MIA" is used as a team ID in the 'SABR minor league database', the last time being 1991 for...
4220
Matthew Gargano
tkestars
Mar 1, 2012 4:23 pm
Using standard database protocol, franchise ID should *never* change. Regardless of where the team moves....
4221
Tangotiger
tom@...
Mar 1, 2012 6:09 pm
There are several considerations in assigning a new ID. Here are a few: 1. Did the team substantially change its personnel? 2. Did the team change its name? ...
4222
KJOK
kjokbaseball
Mar 5, 2012 5:20 am
Certainly, FRANCHISE ID is a misnomer, as a franchise is a property right - the privilege of a spot in the league granted BY the league. Team Continuity ID...
4223
dflory
glad_nad
Mar 5, 2012 3:48 pm
I noticed that at least some players that returned to playing after an absence didn't have their final game dates changes. One example is Ryan Vogelsong,...
4224
fp505jbd
Mar 6, 2012 6:37 pm
Hi. I wanted to share a Japanese baseball database with this group. It covers Nippon Professional Baseball from 1936 to 2011. I tried to incorporate some of...
4225
KJOK
kjokbaseball
Mar 6, 2012 8:17 pm
Michael - Glad to see an updated Japanese Baseball Database - this is great. THANKS, Kevin ... Michael - Glad to see an updated Japanese Baseball Database -...
4226
vansloot
Mar 8, 2012 9:33 pm
Hi Sean, I'm not sure where this netted out, but it looks like [AllstarFull] still contains at least a reference to 'sabatc.01'. Maybe related, there there is...
4227
Alberto Perdomo
albertop69
Mar 10, 2012 5:59 pm
Hi, Sean: Thanks for your new version. However, I'm still finding duplicate rows in the Fielding table. Did you fix that table with the feedback provided? ...
4228
Alberto Perdomo
albertop69
Mar 10, 2012 7:06 pm
Hi, all: Uploaded the latest release of Lahman database (591) and found a lot of errors. [00] Stint column in Fielding table must have a different value for...
4229
Paul Golba
pgolba2
Mar 19, 2012 1:12 pm
Just downloaded the Lahman DB 5.9.1. I see an issue with Mike MacDougal (macdomi01) in 2009. In the Pitching and Fielding tables, he has two stints: stint...
4230
Tangotiger
tom@...
Mar 19, 2012 1:37 pm
I'd like to know if people actually use the stint information, or, if they end up summing at the player-team-year level. From my perspective, the value of the...
4231
Alberto Perdomo
albertop69
Mar 19, 2012 3:04 pm
Yes, I use stints to create statistics tables with the correct order....
4232
KJOK
kjokbaseball
Mar 19, 2012 3:33 pm
Most of the time player-team-year I what I need, but sometimes stint info is useful. Â I think ideally the stint data would be in a separate table...
