Exactly, Sean. Was just coming to post this specifically. Stint being included in the pitching/fielding/batting subtables wasn't a kluge. It was a necessity to...
4241
Mike Emeigh
mwemeigh
Mar 19, 2012 4:35 pm
This goes back to Tom's original question - how are people using stints? In a volunteer effort one has to evaluate the cost of maintaining and validating the...
4242
Rod Nelson
rockymtnsabr
Mar 19, 2012 4:44 pm
Zactly. We agree. That's the ideal format. Rod...
4243
Tangotiger
tom@...
Mar 19, 2012 4:54 pm
Right, Mike has the spirit of my question. When I ask if it's worth it, I'm not asking if it's useful. Clearly, it has many uses, be it the chrono-order of...
4244
KJOK
kjokbaseball
Mar 19, 2012 4:55 pm
Exactly. For example, LH/RH splits are probably much more useful, but we dont' have those in this database, primarily I suspect because they can be derived...
4245
railsplitter_44
Mar 19, 2012 5:14 pm
Just for the sake of a survey, I also use the stints in the Batting, Fielding, and Pitching tables for my website. Not only to correctly order the teams in...
4246
Tangotiger
tom@...
Mar 19, 2012 5:15 pm
Another advantage of having a STINTS table is that you can incorporate minor leagues as well. If someone has a Mets-Expos-Mets needs for same-year players,...
4247
Theodore Turocy
arb1ter
Mar 19, 2012 5:57 pm
Without giving away (too many) trade secrets, I can state the following about the way I manage statistical data. There is only one statistical table,...
4248
anson2995
Mar 20, 2012 1:39 pm
... The problem of bad data don't have anything to do with the database design. It's 100% attributable to me, the person who processed most of the updates....
4249
Paul Golba
pgolba2
Mar 24, 2012 9:45 pm
I'm not sure what the source of the park factors for the database are, but I was under the assumption that it was the same as the multi-year park factors as...
4250
Paul Golba
pgolba2
Mar 24, 2012 9:45 pm
Andy Phillips(phillan01), 2008, stint 1. Lahman 5.9.1 has 31 ABs. According to baseball-reference.com and Retrosheet, he only had 21 ABs. MLB.com has him...
4251
Paul Golba
pgolba2
Mar 24, 2012 9:45 pm
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. ...
