Could someone help out with providing the various stints for the followoing players. They went from team A to team B and back to A last year and we need to...
I just finished updating the player's stints. I would appreciate a check naturally. The only errors that I know of are those with Jimmy Anderson and Ken...
In a message dated 10/8/2004 11:10:35 AM MDT, Mike Crain writes: Possible Manager Error Roy Johnson is listed as a Manafer of the 1944 CHicago Cubs. My old...
I have uploaded roster files w/ Retrosheet IDs for the 2004 AL teams. I double checked against Retrosheet's player roster to assign IDs for the players who...
OK, I think I have filled in all the gaps and small errors in the Batting, Fielding and Pitching data. All the data balances between hitting and pitching and...
Possible Manager Error Roy Johnson is listed as a Manafer of the 1944 CHicago Cubs. My old copy has the ID as johnsro01m who had been out of baseball (MLB)...
Here is a prinout of the teams and positions that are off by one or two on games started. The issue last year was for players who batted in the top of the...
To whoever else on the list that tracks this info - my list of 2004 MLB Debuts amounts to 208 players - does this jive with your list? I'd be interested in...
I believe the teams and manager files are correct, but I would certainly appreciate someone reviewing them for accuracy and verifying that they are accurate. ...
Why do the 1890 and 1891 A.A. Baltimore Orioles have a different teamID (BL3) than the A.A. Baltimore Orioles from 1882 to 1889 (BL2)? select name, teamid,...
Sean, Sean, Derek, Michael, et al: What is the process to get the 2004 data into BDB? With the number of websites offering data for hitting, pitching, and...
Folks, I may be looking at an outdated version of Master.csv, with almost no biographical data for the field managers and HOF members who never played in the...
Last week I spoke with the widow of Carden Gillenwater (gilleca01). Mr. Gillenwater passed away in 2001. I don't have his exact death date, but he died in...
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...
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...
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....
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 ...
Just got the following note about postseason fielding records with invalid IDs. I've checked, and these should be changed to: macdobo01(Bob MacDonald),...
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...
As a few people here use Access to import through csv or Excel, you may want to be aware of a (very annoying) problem with Access 2003. (We can talk at length...
I'm looking for an MySQL-compatible SQL query that will, given a year range and a stat, provide me with either (ideally) a major league average per year for...
Forwarding this sad news, for those who are not SABR members. Doug was a personal friend of mine and a great supporter of reasearch in general and the...
I have just uploaded a file containing a first pass at some of the data addition we have discussed, both here and over at Retrolist, during the last few...
As Derek Adair and others have pointed out there needs to be a good way to update and correct data. I'm not sure what form this structure should have. I know...
Thanks to all who have responded to my notes on what might be useful additions to the baseball-databank effort. This note is an attempt to summarize what is...
Hi Guys, Does anyone know of a utility that I could use to enter PBP data and spit out a retrosheet type of event file? I used to use the DWENTRY utility but...
I was hoping to get more detailed data than the baseball1.com database contains. Pitch-by-pitch data would be preferable, but anything more would be really...
Is there any easy way to pull this data into either Access or SQL Server? Those are the DB engines I am familiar with and have at my disposal...any hints? Jim...
