Thursday, April 16, 2020

Ten years with one team.

855 players were with one team at least TEN seasons through 2019, not necessarily consecutive.

Four players were with two teams at least ten seasons:

FirstLast Fran1 Fran2
Eddie Collins Chicago White Sox Philadelphia Athletics
Carlton Fisk Boston Red Sox Chicago White Sox
Charlie Hough Los Angeles Dodgers Texas Rangers
Greg Maddux Atlanta Braves Chicago Cubs

At least 20 seasons:
qry10YerasOneTeam
franchID playerID Num NameF NameL Team1 Team2 Fran YearF YearL
BAL robinbr01 23 Brooks Robinson BAL BAL Baltimore Orioles 1955 1977
BOS yastrca01 23 Carl Yastrzemski BOS BOS Boston Red Sox 1961 1983
CHC ansonca01 22 Cap Anson CHN CHN Chicago Colts 1876 1897
DET cobbty01 22 Ty Cobb DET DET Detroit Tigers 1905 1926
SFG ottme01 22 Mel Ott NY1 NY1 New York Giants 1926 1947
STL musiast01 22 Stan Musial SLN SLN St. Louis Cardinals 1941 1963
DET kalinal01 22 Al Kaline DET DET Detroit Tigers 1953 1974
MIN johnswa01 21 Walter Johnson WS1 WS1 Washington Senators 1907 1927
CHW lyonste01 21 Ted Lyons CHA CHA Chicago White Sox 1923 1946
SFG mayswi01 21 Willie Mays NY1 SFN San Francisco Giants 1951 1972
MIN killeha01 21 Harmon Killebrew WS1 MIN Minnesota Twins 1954 1974
ATL aaronha01 21 Hank Aaron ML1 ATL Atlanta Braves 1954 1974
PIT stargwi01 21 Willie Stargell PIT PIT Pittsburgh Pirates 1962 1982
ATL niekrph01 21 Phil Niekro ATL ATL Atlanta Braves 1964 1987
KCR brettge01 21 George Brett KCA KCA Kansas City Royals 1973 1993
BAL ripkeca01 21 Cal Ripken BAL BAL Baltimore Orioles 1981 2001
CHW faberre01 20 Red Faber CHA CHA Chicago White Sox 1914 1933
CLE hardeme01 20 Mel Harder CLE CLE Cleveland Indians 1928 1947
CHW applilu01 20 Luke Appling CHA CHA Chicago White Sox 1930 1950
CHC cavarph01 20 Phil Cavarretta CHN CHN Chicago Cubs 1934 1953
ATL spahnwa01 20 Warren Spahn ML1 ML1 Milwaukee Braves 1942 1964
MIL yountro01 20 Robin Yount ML4 ML4 Milwaukee Brewers 1974 1993
DET trammal01 20 Alan Trammell DET DET Detroit Tigers 1977 1996
SDP gwynnto01 20 Tony Gwynn SDN SDN San Diego Padres 1982 2001
ATL smoltjo01 20 John Smoltz ATL ATL Atlanta Braves 1988 2008
HOU biggicr01 20 Craig Biggio HOU HOU Houston Astros 1988 2007
NYY jeterde01 20 Derek Jeter NYA NYA New York Yankees 1995 2014

Some players may have missed time between the first and last seasons. For instance Warren Spahn and Luke Appling served in World War II in the early 1940s.

Teams with the most ten year players sorted by the number of ten year players:

franchID Num Fran1 Fran2
LAD 53 Brooklyn Dodgers Los Angeles Dodgers
DET 53 Detroit Tigers Detroit Tigers
NYY 53 New York Yankees New York Yankees
SFG 53 New York Giants San Francisco Giants
MIN 49 Washington Senators Minnesota Twins
ATL 44 Boston BeaneatersAtlanta Braves
OAK 44 Philadelphia Athletics Oakland Athletics
PHI 43 Philadelphia Phillies Philadelphia Phillies
CHC 43 Chicago Colts Chicago Cubs
CIN 41 Cincinnati Redlegs Cincinnati Reds
CLE 41 Cleveland Indians Cleveland Indians
STL 40 St. Louis Cardinals St. Louis Cardinals
BAL 40 St. Louis BrownsBaltimore Orioles
PIT 39 Pittsburgh Pirates Pittsburgh Pirates
CHW 39 Chicago White Sox Chicago White Sox
BOS 32 Boston Red Sox Boston Red Sox
HOU 22 Houston Astros Houston Astros
KCR 17 Kansas City Royals Kansas City Royals
NYM 16 New York Mets New York Mets
MIL 15 Milwaukee Brewers Milwaukee Brewers
ANA 14 Los Angeles Angels of Anaheim California Angels
TEX 14 Texas Rangers Texas Rangers
TOR 12 Toronto Blue Jays Toronto Blue Jays
SEA 11 Seattle Mariners Seattle Mariners

Yankees:
qry10YerasOneTeam
franchID playerID Num NameF NameL Team1 Team2 Fran YearF YearL
NYY jeterde01 20 Derek Jeter NYA NYA New York Yankees 1995 2014
NYY riverma01 19 Mariano Rivera NYA NYA New York Yankees 1995 2013
NYY berrayo01 18 Yogi Berra NYA NYA New York Yankees 1946 1963
NYY mantlmi01 18 Mickey Mantle NYA NYA New York Yankees 1951 1968
NYY gehrilo01 17 Lou Gehrig NYA NYA New York Yankees 1923 1939
NYY dickebi01 17 Bill Dickey NYA NYA New York Yankees 1928 1946
NYY crosefr01 17 Frankie Crosetti NYA NYA New York Yankees 1932 1948
NYY posadjo01 17 Jorge Posada NYA NYA New York Yankees 1995 2011
NYY fordwh01 16 Whitey Ford NYA NYA New York Yankees 1950 1967
NYY willibe02 16 Bernie Williams NYA NYA New York Yankees 1991 2006
NYY ruthba01 15 Babe Ruth NYA NYA New York Yankees 1920 1934
NYY ruffire01 15 Red Ruffing NYA NYA New York Yankees 1930 1946
NYY whitero01 15 Roy White NYA NYA New York Yankees 1965 1979
NYY pettian01 15 Andy Pettitte NYA NYA New York Yankees 1995 2013
NYY guidrro01 14 Ron Guidry NYA NYA New York Yankees 1975 1988
NYY mattido01 14 Don Mattingly NYA NYA New York Yankees 1982 1995
NYY shawkbo01 13 Bob Shawkey NYA NYA New York Yankees 1915 1927
NYY gomezle01 13 Lefty Gomez NYA NYA New York Yankees 1930 1942
NYY dimagjo01 13 Joe DiMaggio NYA NYA New York Yankees 1936 1951
NYY rizzuph01 13 Phil Rizzuto NYA NYA New York Yankees 1941 1956
NYY howarel01 13 Elston Howard NYA NYA New York Yankees 1955 1967
NYY murcebo01 13 Bobby Murcer NYA NYA New York Yankees 1965 1983
NYY randowi01 13 Willie Randolph NYA NYA New York Yankees 1976 1988
NYY combsea01 12 Earle Combs NYA NYA New York Yankees 1924 1935
NYY lazzeto01 12 Tony Lazzeri NYA NYA New York Yankees 1926 1937
NYY murphjo04 12 Johnny Murphy NYA NYA New York Yankees 1932 1946
NYY bauerha01 12 Hank Bauer NYA NYA New York Yankees 1948 1959
NYY richabo01 12 Bobby Richardson NYA NYA New York Yankees 1955 1966
NYY rodrial01 12 Alex Rodriguez NYA NYA New York Yankees 2004 2016
NYY gardnbr01 12 Brett Gardner NYA NYA New York Yankees 2008 2019
NYY pippwa01 11 Wally Pipp NYA NYA New York Yankees 1915 1925
NYY pennohe01 11 Herb Pennock NYA NYA New York Yankees 1923 1933
NYY jorgear01 11 Arndt Jorgens NYA NYA New York Yankees 1929 1939
NYY henrito01 11 Tommy Henrich NYA NYA New York Yankees 1937 1950
NYY chandsp01 11 Spud Chandler NYA NYA New York Yankees 1937 1947
NYY kellech01 11 Charlie Keller NYA NYA New York Yankees 1939 1952
NYY byrneto01 11 Tommy Byrne NYA NYA New York Yankees 1943 1957
NYY stottme01 11 Mel Stottlemyre NYA NYA New York Yankees 1964 1974
NYY munsoth01 11 Thurman Munson NYA NYA New York Yankees 1969 1979
NYY nettlgr01 11 Graig Nettles NYA NYA New York Yankees 1973 1983
NYY pinielo01 11 Lou Piniella NYA NYA New York Yankees 1974 1984
NYY righeda01 11 Dave Righetti NYA NYA New York Yankees 1979 1990
NYY sabatcc01 11 CC Sabathia NYA NYA New York Yankees 2009 2019
NYY wardaa01 10 Aaron Ward NYA NYA New York Yankees 1917 1926
NYY meusebo01 10 Bob Meusel NYA NYA New York Yankees 1920 1929
NYY hoytwa01 10 Waite Hoyt NYA NYA New York Yankees 1921 1930
NYY rolfere01 10 Red Rolfe NYA NYA New York Yankees 1931 1942
NYY lindejo01 10 Johnny Lindell NYA NYA New York Yankees 1941 1950
NYY collijo01 10 Joe Collins NYA NYA New York Yankees 1948 1957
NYY mcdougi01 10 Gil McDougald NYA NYA New York Yankees 1951 1960
NYY gibbsja01 10 Jake Gibbs NYA NYA New York Yankees 1962 1971
NYY clarkho01 10 Horace Clarke NYA NYA New York Yankees 1965 1974
NYY velarra01 10 Randy Velarde NYA NYA New York Yankees 1987 2001


No comments: