Jump to content

Help with Lahman Teams


rglass95

Recommended Posts

I have a list here of all the teams in the Lahman database, including the years they played. What I need for each team is the corresponding present-day team. For instance, the Brooklyn Dodgers correspond to the Los Angeles Dodgers of today. The Altoona team could correspond to the minor league Altoona team in MVP Baseball. So if anyone can help me out with a few of them or all of them :twisted:, I'd appreciate it.

ALT	1884	1884	Altoona Mountain City


ANA	1997	2004	Anaheim Angels


ARI	1998	2004	Arizona Diamondbacks


ATL	1966	2004	Atlanta Braves


BL1	1872	1874	Baltimore Canaries


BL4	1873	1873	Baltimore Marylands


BLU	1884	1884	Baltimore Monumentals


BLN	1882	2004	Baltimore Orioles


BLF	1914	1915	Baltimore Terrapins


BOS	1901	1901	Boston Americans


BSN	1883	1906	Boston Beaneaters


BSN	1936	1940	Boston Bees


BSN	1911	1952	Boston Braves


BSN	1907	1910	Boston Doves


BOS	1903	1906	Boston Pilgrims


BSN	1876	1882	Boston Red Caps


BOS	1907	2004	Boston Red Sox


BS1	1871	1875	Boston Red Stockings


BSU	1884	1891	Boston Reds


BOS	1902	1902	Boston Somersets


BR3	1872	1884	Brooklyn Atlantics


BRO	1888	1898	Brooklyn Bridegrooms


BRO	1911	1957	Brooklyn Dodgers


BR1	1872	1872	Brooklyn Eckfords


BR4	1890	1890	Brooklyn Gladiators


BR3	1885	1887	Brooklyn Grays


BRO	1891	1895	Brooklyn Grooms


BRO	1914	1931	Brooklyn Robins


BRO	1899	1913	Brooklyn Superbas


BRF	1914	1915	Brooklyn Tip-Tops


BRP	1890	1890	Brooklyn Ward's Wonders


BFP	1879	1890	Buffalo Bisons


BUF	1915	1915	Buffalo Blues


BUF	1914	1914	Buffalo Buffeds


CAL	1965	1996	California Angels


CHF	1914	1914	Chicago Chi-Feds


CHN	1890	1897	Chicago Colts


CHN	1903	2004	Chicago Cubs


CHN	1898	1902	Chicago Orphans


CHP	1890	1890	Chicago Pirates


CHF	1915	1915	Chicago Whales


CHA	1901	2004	Chicago White Sox


CHN	1871	1889	Chicago White Stockings


CHU	1884	1884	Chicago/Pittsburgh (Union League)


CN3	1891	1891	Cincinnati Kelly's Killers


CNU	1884	1884	Cincinnati Outlaw Reds


CN2	1882	1889	Cincinnati Red Stockings


CIN	1954	1959	Cincinnati Redlegs


CN1	1876	2004	Cincinnati Reds


CLE	1879	1901	Cleveland Blues


CLE	1902	1902	Cleveland Bronchos


CL1	1871	1872	Cleveland Forest Citys


CLE	1915	2004	Cleveland Indians


CLP	1890	1890	Cleveland Infants


CLE	1903	1914	Cleveland Naps


CL4	1889	1899	Cleveland Spiders


COL	1993	2004	Colorado Rockies


CL5	1883	1884	Columbus Buckeyes


CL6	1889	1891	Columbus Solons


DET	1901	2004	Detroit Tigers


DTN	1881	1888	Detroit Wolverines


ELI	1873	1873	Elizabeth Resolutes


FLO	1993	2004	Florida Marlins


FW1	1871	1871	Fort Wayne Kekiongas


HR1	1874	1877	Hartford Dark Blues


HOU	1965	2004	Houston Astros


HOU	1962	1964	Houston Colt .45's


IN1	1878	1878	Indianapolis Blues


IND	1884	1914	Indianapolis Hoosiers


KC1	1955	1967	Kansas City Athletics


KCU	1884	1889	Kansas City Cowboys


KCF	1914	1915	Kansas City Packers


KCA	1969	2004	Kansas City Royals


KEO	1875	1875	Keokuk Westerns


LAA	1961	1964	Los Angeles Angels


LAN	1958	2004	Los Angeles Dodgers


LS3	1885	1899	Louisville Colonels


LS2	1882	1884	Louisville Eclipse


LS1	1876	1877	Louisville Grays


MID	1872	1872	Middletown Mansfields


ML1	1953	1965	Milwaukee Braves


MLU	1884	2004	Milwaukee Brewers


ML2	1878	1878	Milwaukee Grays


MIN	1961	2004	Minnesota Twins


MON	1969	2004	Montreal Expos


NH1	1875	1875	New Haven Elm Citys


NYP	1885	1957	New York Giants


NY1	1883	1884	New York Gothams


NYA	1903	1912	New York Highlanders


NY4	1883	1887	New York Metropolitans


NYN	1962	2004	New York Mets


NY3	1871	1876	New York Mutuals


NYA	1913	2004	New York Yankees


NEW	1915	1915	Newark Pepper


OAK	1968	2004	Oakland Athletics


PHP	1871	1954	Philadelphia Athletics


PHI	1943	1944	Philadelphia Blue Jays


PH3	1875	1875	Philadelphia Centennials


PHU	1884	1884	Philadelphia Keystones


PHI	1890	2004	Philadelphia Phillies


PHI	1883	1889	Philadelphia Quakers


PH2	1873	1875	Philadelphia Whites


PT1	1882	1890	Pittsburgh Alleghenys


PTP	1890	1890	Pittsburgh Burghers


PIT	1891	2004	Pittsburgh Pirates


PTF	1914	1915	Pittsburgh Rebels


PRO	1878	1885	Providence Grays


RIC	1884	1884	Richmond Virginians


RC2	1890	1890	Rochester Broncos


RC1	1871	1871	Rockford Forest Citys


SDN	1969	2004	San Diego Padres


SFN	1958	2004	San Francisco Giants


SEA	1977	2004	Seattle Mariners


SE1	1969	1969	Seattle Pilots


SL4	1875	1882	St. Louis Brown Stockings


SLN	1883	1953	St. Louis Browns


SLN	1900	2004	St. Louis Cardinals


SLU	1884	1886	St. Louis Maroons


SLN	1899	1899	St. Louis Perfectos


SL1	1875	1875	St. Louis Red Stockings


SLF	1914	1915	St. Louis Terriers


SPU	1884	1884	St. Paul Apostles


SR2	1879	1890	Syracuse Stars


TBA	1998	2004	Tampa Bay Devil Rays


TEX	1972	2004	Texas Rangers


TL1	1884	1884	Toledo Blue Stockings


TL2	1890	1890	Toledo Maumees


TOR	1977	2004	Toronto Blue Jays


TRO	1871	1872	Troy Haymakers


TRN	1879	1882	Troy Trojans


WS5	1873	1873	Washington Blue Legs


WSU	1872	1889	Washington Nationals


WS3	1871	1872	Washington Olympics


WSN	1892	1971	Washington Senators


WS9	1891	1891	Washington Statesmen


WIL	1884	1884	Wilmington Quicksteps


WOR	1880	1882	Worcester Ruby Legs

Link to comment
Share on other sites

I can help you out with most of the teams. I have a book, The Ball Clubs by Dewey & Acocella, that has every franchise officially recognized by Major League Baseball. I can post the info here or save it to a MS Word or MS Excel file. Let me know which you prefer. It will take me a day or two to complete the list.

I'm almost done but I see krawhitham beat me to it. I have it in Excel format and it's organized by franchise. Let me know if you still want it.

Link to comment
Share on other sites

Altoona Mountain City have no present day team

Philadelphia Athletics = Oakland Athletics

Baltimore Canaries have no present day team

Baltimore Marylands have no present day team

Baltimore Monumentals have no present day team

Baltimore Terrapins have no present day team

Boston Americans = Boston Red Sox

Boston Beaneaters = Atlanta Braves

Boston Bees = Atlanta Braves

Boston Braves = Atlanta Braves

Boston Doves = Atlanta Braves

Boston Pilgrims = Boston Red Sox

Boston Red Caps = Atlanta Braves

Boston Red Stockings have no present day team

Boston Reds have no present day team

Boston Somersets = Boston Red Sox

Link to comment
Share on other sites

Brooklyn Atlantics have no present day team

Brooklyn Bridegrooms = Los Angeles Dodgers

Brooklyn Dodgers = Los Angeles Dodgers

Brooklyn Eckfords have no present day team

Brooklyn Gladiators have no present day team

Brooklyn Grays = Los Angeles Dodgers

Brooklyn Grooms = Los Angeles Dodgers

Brooklyn Robins = Los Angeles Dodgers

Brooklyn Superbas = Los Angeles Dodgers

Brooklyn Tip-Tops have no present day team

Brooklyn Ward's Wonders have no present day team

Link to comment
Share on other sites

Buffalo Bisons have no present day team

Buffalo Blues = Buffalo Buffeds they have no present day team

California Angels = Los Angeles Angels of Anaheim

Chicago Chi-Feds = Chicago Whales they have no present day team

Chicago Colts = Chicago Cubs

Chicago Orphans = Chicago Cubs

Chicago Pirates have no present day team

Chicago White Stockings have no present day team

Chicago/Pittsburgh (Union League) have no present day team

Cincinnati Kelly's Killers have no present day team

Cincinnati Outlaw Reds have no present day team

Cincinnati Red Stockings = Cincinnati Reds

Cincinnati Redlegs = Cincinnati Reds

Link to comment
Share on other sites

Cleveland Blues have no present day team

Cleveland Bronchos = Cleveland Indians

Cleveland Forest Citys have no present day team

Cleveland Infants have no present day team

Cleveland Naps = Cleveland Indians

Cleveland Spiders have no present day team

Columbus Buckeyes have no present day team

Columbus Solons have no present day team

Detroit Wolverines have no present day team

Elizabeth Resolutes have no present day team

Fort Wayne Kekiongas have no present day team

Hartford Dark Blues have no present day team

Houston Colt .45's = Houston Astros

Indianapolis Blues have no present day team

Indianapolis Hoosiers have no present day team

Link to comment
Share on other sites

Kansas City Athletics = Oakland Athletics

Kansas City Cowboys have no present day team

Kansas City Packers have no present day team

Keokuk Westerns have no present day team

Los Angeles Angels = Los Angeles Angels of Anaheim

Louisville Colonels = Louisville Eclipse they have no present day team

Louisville Grays have no present day team

Middletown Mansfields have no present day team

Milwaukee Braves = Atlanta Braves

Milwaukee Grays have no present day team

Montreal Expos = Washington Nationals

New Haven Elm Citys have no present day team

New York Giants = San Francisco Giants

New York Gothams = San Francisco Giants

New York Highlanders = New York Yankees

New York Metropolitans have no present day team

New York Mutuals have no present day team

Newark Pepper have no present day team

I'll do more later

Link to comment
Share on other sites

Philadelphia Athletics = Oakland Athletics

Philadelphia Blue Jays = Philadelphia Phillies

Philadelphia Centennials have no present day team

Philadelphia Keystones have no present day team

Philadelphia Quakers = Philadelphia Phillies

Philadelphia Whites = Philadelphia White Stockings they have no present day team

Pittsburgh Alleghenys = Pittsburgh Pirates

Pittsburgh Burghers have no present day team

Pittsburgh Rebels have no present day team

Providence Grays have no present day team

Richmond Virginians have no present day team

Rochester Broncos have no present day team

Rockford Forest Citys have no present day team

Seattle Pilots = Milwaukee Brewers

St. Louis Brown Stockings have no present day team

St. Louis Browns = Baltimore Orioles

St. Louis Maroons have no present day team

St. Louis Perfectos = St. Louis Cardinals

St. Louis Red Stockings have no present day team

St. Louis Terriers have no present day team

St. Paul Apostles have no present day team

Syracuse Stars have no present day team

Link to comment
Share on other sites

Toledo Blue Stockings have no present day team

Toledo Maumees have no present day team

Troy Haymakers have no present day team

Troy Trojans have no present day team

Washington Blue Legs have no present day team

Washington Olympics have no present day team

Washington Senators = Texas Rangers

Washington Statesmen have no present day team

Wilmington Quicksteps have no present day team

Worcester Ruby Legs have no present day team

Link to comment
Share on other sites

A few franchises have used the same team name. Baltimore Orioles, Milwaukee Brewers, St. Louis Browns and Washington Senators.

Baltimore Orioles 1954-pres < St. Louis Browns 1902-1953 < Milwaukee Brewers 1901

St. Louis Cardinals were called the St. Louis Browns 1883-1898

New York Yankees 1913-pres < NY Highlanders 1903-1912 < Baltimore Orioles 1901-1902

Texas Rangers 1972-pres < Washington Senators 1961-1971

Minnesota Twins 1961-pres < Washington Senators 1901-1960

Milwaukee Brewers 1970-pres < Seattle Pilots 1969

Mr. Lahman associates the various names a franchise has used to the current team ID. Therefore Walter Johnson would be part of the Twins franchise.

Link to comment
Share on other sites

I can help you out with most of the teams. I have a book, The Ball Clubs by Dewey & Acocella, that has every franchise officially recognized by Major League Baseball. I can post the info here or save it to a MS Word or MS Excel file. Let me know which you prefer. It will take me a day or two to complete the list.

I'm almost done but I see krawhitham beat me to it. I have it in Excel format and it's organized by franchise. Let me know if you still want it.

Yes, Excel will probably be easier. Thanks.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...