Historical MLB Player Numbers

ccm01 · 03-24-2009, 02:32 PM

I have a csv formatted text file with all historical major league player uniform numbers from 1929-2008. I became frustrated that this information is not readily available anywhere and set out to gather it, to make it available, and to make it sortable for ease of use (which it is via excel). The zip file is too large to attach here (532k). If anybody is interested in this, please let me know and I will try and make it available (somewhere).

ccm01

Kelric · 03-24-2009, 03:23 PM

Free file hosting - FileFactory

Bluenoser · 03-24-2009, 03:45 PM

532K is a tiny file.

ccm01 · 03-26-2009, 07:11 AM

Thank you. The zip file can be found here for those interested:

MLB_Numbers_1929-2008.zip - FileFactory

Bluenoser · 03-26-2009, 08:38 AM

Quote:

Originally Posted by ccm01

Thank you. The zip file can be found here for those interested:

MLB_Numbers_1929-2008.zip - FileFactory

Thanks for sharing this.

Kelric · 03-26-2009, 12:22 PM

And for taking the time to put it together.

ccm01 · 03-26-2009, 12:38 PM

No problem. Consider it my (small) contribution for those like me that can't stand tiny details like uniform numbers being incorrect in their seasons.

satchel · 03-28-2009, 06:50 PM

Fantastic! Thanks.

To some, jersey numbers are a "tiny detail," but to me they're very important.

satchel · 03-28-2009, 06:52 PM

Download went fine.

satchel · 03-29-2009, 07:04 PM

Been playing with this file. I notice that it's 65,536 lines long, which is the maximum for Excel files. This makes me think that some numbers were left out. Was there a particular criteria used for inclusion on this list?

Also: 98.96% of the numbers fall between 1-59. This is solid evidence that traditional baseball numbers don't go past the 50s in normal circumstances.

ccm01 · 03-30-2009, 11:10 PM

You either need to open this file via notepad (or a notepad type of editor) or by using Excel 2007 to see all of the rows. Older versions of Excel will cut the rows off after the limit you listed previously. That limitation is removed with Excel 2007.

satchel · 04-08-2009, 10:39 AM

Thanks for the response and explanation.

satchel · 04-08-2009, 05:17 PM

The file is only 69,173 lines long, so even if you have an older version of Excel, you can still get 95% of the numbers on one worksheet.

teukros · 11-02-2010, 01:32 PM

The FileFactory link no longer works. Does anyone still have the file? It would be really helpful if someone could post an updated link here. Thanks!

Spritze · 11-10-2010, 09:18 PM

This file exists in the OOTP stats folder. uni.csv It is used in game and updates uni numbers yearly in OOTP.

03-24-2009, 02:32 PM	#1 (permalink)
ccm01 Minors (Single A) Join Date: Mar 2002 Location: USA Posts: 85 Thanks: 0 Thanked 0x in 0 posts	Historical MLB Player Numbers I have a csv formatted text file with all historical major league player uniform numbers from 1929-2008. I became frustrated that this information is not readily available anywhere and set out to gather it, to make it available, and to make it sortable for ease of use (which it is via excel). The zip file is too large to attach here (532k). If anybody is interested in this, please let me know and I will try and make it available (somewhere). ccm01

03-24-2009, 03:23 PM	#2 (permalink)
Kelric Hall Of Famer Join Date: Mar 2002 Location: Greater Boston Area Posts: 3,983 Thanks: 7 Thanked 46x in 36 posts	Free file hosting - FileFactory __________________ Former Co-Commish and owner of the Boston Red Sox, 1783-1144, .609%, of the defunct Overlords Baseball League (1930-48). 17 Division wins, 9 ALCS wins, 5 World Series wins.

03-24-2009, 03:45 PM	#3 (permalink)
Bluenoser Hall Of Famer Join Date: Mar 2002 Location: Canada Posts: 5,598 Thanks: 56 Thanked 442x in 307 posts	532K is a tiny file. __________________ It takes neither courage nor intelligence to cheer for a team only when that team wins. The true test of a fan's mettle is the same as it is for a player: Were you there when you were needed?

03-26-2009, 12:22 PM	#6 (permalink)
Kelric Hall Of Famer Join Date: Mar 2002 Location: Greater Boston Area Posts: 3,983 Thanks: 7 Thanked 46x in 36 posts	And for taking the time to put it together. __________________ Former Co-Commish and owner of the Boston Red Sox, 1783-1144, .609%, of the defunct Overlords Baseball League (1930-48). 17 Division wins, 9 ALCS wins, 5 World Series wins.

03-28-2009, 06:50 PM	#8 (permalink)
satchel Hall Of Famer Join Date: Apr 2002 Location: Ft Smith AR Posts: 2,680 Thanks: 52 Thanked 48x in 26 posts	Fantastic! Thanks. To some, jersey numbers are a "tiny detail," but to me they're very important. __________________ JL Commish NPBL Rhode Island Reds ’33 ’34 ’35 TCBA San Francisco Railbornes ’74 ’76 ’77 ’78 FL New Orleans Black Sox ’56 ’57 ’58 ’59 IOLD

03-26-2009, 07:11 AM	#4 (permalink)
ccm01 Minors (Single A) Join Date: Mar 2002 Location: USA Posts: 85 Thanks: 0 Thanked 0x in 0 posts	Thank you. The zip file can be found here for those interested: MLB_Numbers_1929-2008.zip - FileFactory

03-26-2009, 12:38 PM	#7 (permalink)
ccm01 Minors (Single A) Join Date: Mar 2002 Location: USA Posts: 85 Thanks: 0 Thanked 0x in 0 posts	No problem. Consider it my (small) contribution for those like me that can't stand tiny details like uniform numbers being incorrect in their seasons.

03-28-2009, 06:52 PM	#9 (permalink)
satchel Hall Of Famer Join Date: Apr 2002 Location: Ft Smith AR Posts: 2,680 Thanks: 52 Thanked 48x in 26 posts	Download went fine. Last edited by satchel; 03-28-2009 at 06:53 PM. Reason: no problem here

03-29-2009, 07:04 PM	#10 (permalink)
satchel Hall Of Famer Join Date: Apr 2002 Location: Ft Smith AR Posts: 2,680 Thanks: 52 Thanked 48x in 26 posts	Been playing with this file. I notice that it's 65,536 lines long, which is the maximum for Excel files. This makes me think that some numbers were left out. Was there a particular criteria used for inclusion on this list? Also: 98.96% of the numbers fall between 1-59. This is solid evidence that traditional baseball numbers don't go past the 50s in normal circumstances.

03-30-2009, 11:10 PM	#11 (permalink)
ccm01 Minors (Single A) Join Date: Mar 2002 Location: USA Posts: 85 Thanks: 0 Thanked 0x in 0 posts	You either need to open this file via notepad (or a notepad type of editor) or by using Excel 2007 to see all of the rows. Older versions of Excel will cut the rows off after the limit you listed previously. That limitation is removed with Excel 2007.

04-08-2009, 10:39 AM	#12 (permalink)
satchel Hall Of Famer Join Date: Apr 2002 Location: Ft Smith AR Posts: 2,680 Thanks: 52 Thanked 48x in 26 posts	Thanks for the response and explanation.

04-08-2009, 05:17 PM	#13 (permalink)
satchel Hall Of Famer Join Date: Apr 2002 Location: Ft Smith AR Posts: 2,680 Thanks: 52 Thanked 48x in 26 posts	The file is only 69,173 lines long, so even if you have an older version of Excel, you can still get 95% of the numbers on one worksheet.

11-02-2010, 01:32 PM	#14 (permalink)
teukros New User Join Date: Nov 2010 Posts: 1 Thanks: 0 Thanked 0x in 0 posts	The FileFactory link no longer works. Does anyone still have the file? It would be really helpful if someone could post an updated link here. Thanks!

11-10-2010, 09:18 PM	#15 (permalink)
Spritze Hall Of Famer Join Date: Dec 2001 Location: Redmond Wa and Cape Coast Ghana Posts: 2,946 Thanks: 16 Thanked 344x in 242 posts	This file exists in the OOTP stats folder. uni.csv It is used in game and updates uni numbers yearly in OOTP.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode