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...
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. ...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 ...
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 ...
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...
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...
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...
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...
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...
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....
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,...
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,...
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...
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...
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...
4242
Rod Nelson
rockymtnsabr
Mar 19, 2012 4:44 pm
Zactly. We agree. That's the ideal format. Rod...
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...
