View Single Post
Old 01-27-2023, 06:58 PM   #199
thehef
Hall Of Famer
 
Join Date: Jun 2006
Posts: 5,391
Quote:
Originally Posted by TBird View Post
I opened the milbteams.csv file with the intent of comparing affiliate designations with other sources in order to make a list. It's going to be messy - the various sources do not always agree, but I'll give it a shot on another rain/snow day.
I don't know if there's one official or unofficial source for affiliates. Two best sources that I know of for minor league data in general are baseball-reference.com and statscrew.com... and they do not agree... To what degree they disagree, I dunno. So any project to double-check and/or update affiliates would first need to include determining what the official source is for the data.

Quote:
Originally Posted by TBird View Post
What I did notice after reading your post is that both the SF Seals and Sacramento Senators are abbreviated as "SaSe" in the spreadsheet, and both are listed as Dodger affiliates. That's definitely where the error occurred. Luckily 1935 was the only year the Senators were not independent, otherwise there could have been similar issues in other years.
Not sure if that prompted the error or not. I mean, those two teams having the same abbreviation in the milbteams.csv file occurs every year from 1921-35... (As far as the abbrev's themselves, I don't think much thought went into them. They were basically arrived at by taking the first two letters of the city and the first two letters of the nickname. In my experience, one can edit this field to show, for example, the type of abbreviation one might see on a sports page, and there are no issues; IOW, I'm fairly certain the field is used for nothing other than display.)
thehef is offline   Reply With Quote