Search the web
Sign In
New User? Sign Up
baseball-databank · Baseball Databank
  • Members Only
  • Post
  • Files
  • Photos
  • Database
  • Polls
  • Members
  • Calendar
  • Promote
  • Groups Labs (Beta)
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Real people. Real stories. See how Yahoo! Groups impacts members worldwide.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

   Messages Help
Message #
Search:
Advanced
Different teamID's for A.A. Baltimore teams   Message List  
Reply | Forward Message #2226 of 3880 |

Why do the 1890 and 1891 A.A. Baltimore Orioles have a different
teamID (BL3) than the A.A. Baltimore Orioles from 1882 to 1889 (BL2)?


select name, teamid, lgid, yearid from teams where franchid = "BLO"

+-------------------+--------+------+--------+
| name | teamid | lgid | yearid |
+-------------------+--------+------+--------+
| Baltimore Orioles | BL2 | AA | 1882 |
| Baltimore Orioles | BL2 | AA | 1883 |
| Baltimore Orioles | BL2 | AA | 1884 |
| Baltimore Orioles | BL2 | AA | 1885 |
| Baltimore Orioles | BL2 | AA | 1886 |
| Baltimore Orioles | BL2 | AA | 1887 |
| Baltimore Orioles | BL2 | AA | 1888 |
| Baltimore Orioles | BL2 | AA | 1889 |
| Baltimore Orioles | BL3 | AA | 1890 |
| Baltimore Orioles | BL3 | AA | 1891 |
+-------------------+--------+------+--------+

Thanks.

Bill Knight
Sat Oct 2, 2004 2:35 am

Show Message Option
wknight94
Offline Offline
Send Email Send Email

Forward 		Message #2226 of 3880 |
Expand Messages Author Sort by Date

Why do the 1890 and 1891 A.A. Baltimore Orioles have a different teamID (BL3) than the A.A. Baltimore Orioles from 1882 to 1889 (BL2)? select name, teamid,... 		wknight94
Offline Send Email 		Oct 2, 2004
3:46 am

I believe it's because the original team of AA Baltimore Orioles dropped out of the AA after the 1889 season. In the 1890 season, when the Brooklyn Gladiators...
KJOK
kjokbaseball
Online Now Send Email 		Oct 3, 2004
5:51 am

Bill Knight & others, The Baltimore Orioles were one base ball club, 1882 to 1899. Around 1890, managed by Bill Barnie and owned by Harry von der Horst. After...
Paul Wendt
pgw02472
Offline Send Email 		Oct 3, 2004
5:17 pm

... The present IDs enable selection of the whole 1882-1899 history and its subsets demarcated 1889-1890 or 1891-1892. What practical problems does it create?...
Paul Wendt
pgw02472
Offline Send Email 		Oct 3, 2004
5:19 pm

These are great explanations for why they have different team ID's. From the sounds of it, however, they should also have different franchise ID's. In fact,...
wknight94
Offline Send Email 		Oct 4, 2004
1:38 am
< Prev Topic  |  Next Topic >
Message #
Search:
Advanced
Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help