I'm trying to get a file that contains for 2004 position players: playerid,playername,team,games Playerid is not required, but would be preferable. Anyone who...
... Just to make sure, something like this: http://www.sportsline.com/mlb/stats/playersort/regularseason/yearly/MLB/ALL?&print_rows=9999 is not good enough, as...
Just got the following note about postseason fielding records with invalid IDs. I've checked, and these should be changed to: macdobo01(Bob MacDonald),...
Sean: Since I'll be working on this file in a few days to change some of the "OF" positions of the 2003 postseason data to "CF, LF, RF" data (and since these...
I was actually much closer to completing the "OF" replacments than I thought, so the file will be uploaded in just a few minutes with these corrections: 1....
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the baseball-databank group. File :...
baseball-databank@yah...
Jul 9, 2004 3:43 am
2187
Hi. I would like to begin work on a UI for Lahman 5.1 in Access and I was wondering if anyone knew of already existing UI's. Thanks in advance. David Dvorin ...
I would like a query with all the batting stats from 1990 on, by stint, BUT with columns for games played at each position. I'd also like to exclude pitchers....
I find the easiest thing is to create a matrix table. Create a table called PosMatrix, that looks like: Pos,Pos1,Pos2,Pos3...Pos9 1,1,0,0,0..,0 2,0,1,0,...,0 ...
On Sat Jul 10, 2004, Rob Miller asked for ... This worked on Planet Access: SELECT b.*, (SELECT f.G FROM fielding as f WHERE b.playerID = f.playerID AND ...
I looked in Files but did not spot anything. I want to determine Slugging allowed by pitchers but do not have doubles and triples allowed by pitchers. Does...
Jonathan Frankel is compiling those two and four other elementary statistics for 1899. He has consulted some sources, maybe enough to cover the field. I...
Ok, getting the W-L record for a team in 1-run games from the game log files. I've created a big table of game data, 1 row for each game. I know how to get the...
... Hi, There is a thread above discussing what new data to add to the database and 2B and 3B allowed are on the list, I believe. Right now, they are not...
This is handled using the Michael Mavrogiannis technique of using the IIF function in MS Access. Please do a search in the archives for IIF, and select the...
... In the Files section, within newdat.zip, the file named pidata.txt has the data as extracted from Retrosheet's event files. Check the Messages section for...
For reinhar01, Year = 1919, BFP should be equal to 1, not 4. BTW, it's mathematically impossible to face 4 batters without either giving up a run or recording...
Well, hold the phone. Even though MLB.COM, Baseballpropectus, etc. show 1 BFP, I thought I'd use PROQUEST to check the boxscores, and what do you know,...
I posted this question on the Retrosheet group, and Craig Burley posted it on the SABR-L list. So far, one report that game accounts said Reinhart hit a...
There are two potential mistakes which have recently come to my attention. 1) In the postseason stats for the 1979 world series, the pitching stats for both...
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.
