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
ccm01 Minors (Single A) Join Date: Mar 2002 Location: USA Posts: 85	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-28-2009, 06:50 PM	#8
satchel Hall Of Famer Join Date: Apr 2002 Location: Ft Smith Ark. USA Posts: 2,681	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

03-28-2009, 06:52 PM	#9
satchel Hall Of Famer Join Date: Apr 2002 Location: Ft Smith Ark. USA Posts: 2,681	Download went fine. Last edited by satchel; 03-28-2009 at 06:53 PM. Reason: no problem here

03-24-2009, 03:23 PM	#2
Kelric Hall Of Famer Join Date: Mar 2002 Location: Greater Boston Area Posts: 3,992	Free file hosting - FileFactory

03-24-2009, 03:45 PM	#3
Bluenoser Hall Of Famer Join Date: Mar 2002 Location: In The Moment Posts: 14,177	532K is a tiny file.

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

03-26-2009, 12:22 PM	#6
Kelric Hall Of Famer Join Date: Mar 2002 Location: Greater Boston Area Posts: 3,992	And for taking the time to put it together.

03-26-2009, 12:38 PM	#7
ccm01 Minors (Single A) Join Date: Mar 2002 Location: USA Posts: 85	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-29-2009, 07:04 PM	#10
satchel Hall Of Famer Join Date: Apr 2002 Location: Ft Smith Ark. USA Posts: 2,681	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
ccm01 Minors (Single A) Join Date: Mar 2002 Location: USA Posts: 85	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
satchel Hall Of Famer Join Date: Apr 2002 Location: Ft Smith Ark. USA Posts: 2,681	Thanks for the response and explanation.

04-08-2009, 05:17 PM	#13
satchel Hall Of Famer Join Date: Apr 2002 Location: Ft Smith Ark. USA Posts: 2,681	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
teukros New User Join Date: Nov 2010 Posts: 1	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
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	This file exists in the OOTP stats folder. uni.csv It is used in game and updates uni numbers yearly in OOTP.