My vote is to keep the stints as is. From a database perspective, it is much, much easier to take a stint divided table and sum it up to get the overall...
4252
Tangotiger
tom@...
Mar 24, 2012 11:28 pm
Paul, Your post is clear why we do *not* want to keep the stints as-is. The requirement about chrono-stints can already be addressed by a Stints table that...
4253
chrislambrou
Mar 26, 2012 3:40 pm
Does anyone have a comment on the reply below? I'm always running into problems with appearances and have to use the fielding table. Not the best table to...
4254
Tangotiger
tom@...
Mar 26, 2012 6:47 pm
There's an APPEARANCES table in the Lahman DB. I haven't verified it, but that might help you. Tom ... The Book--Playing The Percentages In Baseball ...
4255
Nicholas Miceli
nsmiceli
Apr 6, 2012 7:48 pm
Dear Members, Thank you to all who responded to my request for help for readers. As I get into the planning process for research, I'm sure that list members ...
4256
Clay Dreslough
upa2112
Apr 6, 2012 11:55 pm
I don't fully understand what is being proposed, but I just wanted to take a moment to speak out in favor of backwards compatibility. For example, people...
4257
Clem Comly
ccomly2003
Apr 7, 2012 5:27 pm
I don't currently have access to a good relational database. If I did, the solution for stints in Fielding.csv is easy. For all 2011 fielding stints for...
4258
Tangotiger
tom@...
Apr 8, 2012 3:05 pm
BDB or Lahman DB would be "backward compatible" with the proposed change, or at least have that as a potential. If we do this with a STINTS table that shows it...
4259
KJOK
kjokbaseball
Apr 10, 2012 8:06 pm
Retrosheet changed their minds and will be using TeamID MIA - I think we should do the same... THANKS, Kevin...
4260
chrislambrou
Apr 17, 2012 1:37 pm
I didn't see a response on this... Will DH no longer be included in the fielding table? Thanks. -Chris...
4261
N. S. Miceli, Ph.D.
nsmiceli
Apr 19, 2012 3:40 pm
Dear group members, Please excuse the cross posting. When examining more than one season's worth of data, do you think that there is a need to examine the data...
4262
David J Wheeler
dj.wheeler
Apr 24, 2012 12:46 pm
Being new to databases, I am wondering if someone might help me with instructions on how to query career stats from the csv data provided recently. I have...
4263
Tangotiger
tom@...
Apr 24, 2012 1:36 pm
You should download the Lahman MS Access database: http://www.seanlahman.com/baseball-archive/statistics/ It'll make life easier for you. Tom ... The...
4264
Matthew Gargano
tkestars
Apr 24, 2012 1:37 pm
The easy way: use microsoft access If you are using windows, the cheaper-and-not-as-easy-but-probably-better-way is to install XAMPP (or LAMP if you have a...
4265
FrankPereiro
franpereiro
May 3, 2012 7:52 pm
Hi there, I would like to merge (unite, join or however it's called) different databases. We have a baseball site to highlight stats of latino players and we...
4266
Clem Comly
ccomly2003
May 17, 2012 1:01 pm
The latest consistency check has 5 found when 2 expected. Two of the 5 are cases apparently where the same player is accidentally in Master twice. It looks...
4267
KJOK
kjokbaseball
May 18, 2012 5:00 am
I think smith02 is now smithre01 - Rex Smith? THANKS, Kevin ... 5 are cases apparently where the same player is accidentally in Master twice. It looks to me...
4268
Clem Comly
ccomly2003
May 18, 2012 11:58 am
I downloaded the ACCESS version of the DB early this week and hope it is in sync with other versions, Alberto reported [query 09] There are 78 rows (season...
4269
Clem Comly
ccomly2003
May 18, 2012 11:58 am
Yes, Rex Smith. Thanks, Kevin. But all existing smithre01 records will need stint = 2 (Fielding,Pitching, Batting) before changing smith02 to smithre01. ...
4270
Clem Comly
ccomly2003
May 20, 2012 11:43 am
I downloaded Access version and it doesn’t come with consistency queries and posted consistency queries each need manual updating to run in access. For...
4271
OrcomBoy
May 28, 2012 10:58 am
Good day, While I was merging the database with the current active rosters from mlb.com I came across the following discrepancies in birth dates: Name...
4272
KJOK
kjokbaseball
May 28, 2012 6:15 pm
Freddie Garcia's discrepancy is I think well known. Apparently the date was originally mis-interpreted because 6/10 internationally is October 6th not June...
4273
chrislambrou
May 29, 2012 11:59 am
Probably a dumb question but can anyone lead me to a good source for 2012 MLB data? I'd like to provide current stats and suspect there are many services that...
4274
KJOK
kjokbaseball
May 29, 2012 6:46 pm
From David Vincent via Rod Nelson, the SABR Biographical database (which Baseball-Reference.com uses) has most of these resolved: Player SABR DB MLB.com ...
4275
Sean Forman
sforman71
May 29, 2012 7:03 pm
sean ... Sean Forman Sports Reference LLC, President http://www.sports-reference.com/ ... sean --- Sean Forman Sports Reference LLC, President...
4276
chrislambrou
Jun 5, 2012 8:48 pm
I don't see any draft info in the master table and no external files that seem to contain this - is there a source for draft data elsewhere? Is this one of...
4277
railsplitter_44
Jun 5, 2012 9:50 pm
The only free data that I know of is from the retrosheet transactions database. But this will only contain draft info from players who made it to the major...
4278
KJOK
kjokbaseball
Jun 5, 2012 10:13 pm
The data has been compiled, as you can see here: Â http://www.baseball-reference.com/draft/ Â However, to my knowledge that dataset has not been publicly...
4279
Clay Dreslough
upa2112
Jun 7, 2012 1:43 pm
Speaking of stints, is there a consensus on the abbreviation to use for the single-game wild card round when displaying player stats? For example, the current...
4280
chrislambrou
Jun 7, 2012 1:44 pm
PlayerID for year 2011 is 'ortizra02' instead of 'ortizra01' in the appearances table only. Please let me know if I am missing something. Thanks. -Chris...
