Good morning all, I'm going to start searching around, but if anyone can point me to a quick reference on how fielding efficiency or effectiveness statistics ...
I've noticed that 'El Cajon' and 'La Mesa' are listed as 'ElCajon' and 'LaMesa' in the biographical data. Other errors I've found (I used Google Maps to verify...
I think this may have been mentioned before, but just in case... There seem to be two different teams that use a team ID of PH4 in the Teams table. The first...
Last time mentioned was post #3503: I think I've mentioned this for a couple of years, but the 1891 AA Philadelphia team has a Team ID of PH4, but I believe it...
Question... Does the DB have agent data tied to recent players? Have read somewhere that that might be the case, but can't seem to find the data. -- Maury...
Will Young mentioned he was doing this on baseballthinkfactory.org, but he has not provided it to us. sean 2009/2/8 Maury Brown <maurybaseballcrazy@...> ...
I believe it's still a work in progress.  I will talk to Will and see what his plans are about completing it and sharing it.  THANKS, Kevin ... From: Sean...
Hey, thanks, guys. Will work with Euston to see what I can dig up. On that note... once salary arbitration is completed, I will be publishing as much detail on...
Just reviving an old thread here, but this error still hasn't been fixed... Since this was first discussed, Retrosheet's PBP data has been revised for the play...
One other note for documentation, in case this does ever get corrected, is that Retrosheet also uses the incorrect PH4 for the 1891 Philadelphia American...
Don't think we've mentioned these except within a table, but here is a summary of the team ID differences between BBDB and Retrosheet: 2005 - 2008 Los Angeles...
I have the 2009 mlb schedules availble to download on my site http://www.fan-exchange.com/mlb/schedule.asp Fields include homefranchid, awayfranchid and...
I just thought it would be cool if we all shared how we utilize the data we download. I started the website www.fan-exchange.com so fans can post their...
This post is only for those who sees this from a clinical rather than moral perspective. Please ignore this post is you are in the latter group. Can someone...
Tangotiger
tom@...
Apr 16, 2009 3:05 pm
3745
Craig Depken and Jon Ford have a paper in the 2006 Journal of Socio Economics looking at the impact of race on allstar ballots. I can provide the data we used...
Tom, I someone else was looking to do this and was using some kind of program to looked at the player's pitcher and then set the race accordingly. I look for...
When a player plays for multiple teams in the same year, each season is listed, plus a sum of all which is noted with team titled TOT (for total) at Baseball...
Is anyone using openoffice with the Lahman database? I am having issues when I try to make a query with the 2B and 3B data, getting errors that I do not...
The problem is likely that the query doesn't like a field name beginning with a number. I'm not certain what the syntax with OpenOffice is, but try something...
I did just find some help documentation. It appears that a double-quote is what you want to use. Vive la difference... select * from batting where "3B" like...
Could you point out a couple of the places where this occurs? sean 2009/5/1 htlfkbz <judsongreen@...> ... -- Sean Forman President, Sports Reference LLC ...
Most programming languages and DB don't like column/field names that start with digits. Instead of 2B, 3B, rename them to B2, B3. Alternatively, if you give...
Tangotiger
tom@...
May 4, 2009 10:42 am
3756
Is there a MySQL equivalent to this query? I'm struggling with converting it from Access to Mysql....
Can you show us what functions you've tried? Here's a related one in Oracle I've used (for something else): substr(min(to_char(order_id + 90000,'00000') || ...
Tangotiger
tom@...
May 8, 2009 8:58 pm
3758
I just figured it out: SELECT f2.yearid, f2.playerid, MID(MAX(CONCAT(1000 + CAST(f2.GP as CHAR(3)),"_",f2.pos)),6) AS PrimPos, Max(f2.GP) AS GP_Pos, SUM(f2.GP)...
The query that is described is a neat trick and a good concept to know, but it's not a great permanent solution. ACCESS: SELECT yearID, teamID, Pos,...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
