View Single Post
Old 09-17-2006, 02:33 PM   #3 (permalink)
Tiger Fan
Hall Of Famer
 
Tiger Fan's Avatar
 
Join Date: Dec 2001
Location: Ontario Canada
Posts: 5,395
Open up the Teams.xls sheet from whichever database you are using (Lahman, ArodGarlon, etc) and the historical team id's for each season are listed.

For example here is 1871:
Code:

yearID	lgID	teamID	franchID
1871	NA	BS1	BNA
1871	NA	CH1	CNA
1871	NA	CL1	CFC
1871	NA	FW1	KEK
1871	NA	NY2	NNA
1871	NA	PH1	PNA
1871	NA	RC1	ROK
1871	NA	TRO	TRO
1871	NA	WS3	OLY
__________________
Cliff Markle HOB1 greatest pitcher 360-160, 9 Welch Awards, 11 WS titles

My current dynasty - Tiger Fan's All Sports Replay: The 1920's


Head Coach
2010 North Carolina State (5-7)
2011 North Carolina State (2-2)
2012 North Carolina (0-0)


2008 IFF Portsmouth FC
Tiger Fan is offline   Reply With Quote