Search the web
Sign In
New User? Sign Up
baseball-databank · Baseball Databank
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want to share photos of your group with the world? Add a group photo to Flickr.

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
Advanced
Different teamID's for A.A. Baltimore teams   Message List  
Reply | Forward Message #2228 of 3878 |
Re: [baseball-databank] Different teamID's for A.A. Baltimore teams

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 the 1889 season, the Brooklyn, Cinci, Baltimore, and Kansas City
clubs abandoned their AA franchises (*in the business of baseball, not the
baseball database sense). The first two received NL franchises (a sure
thing, if not formally arranged in advance; the cities were coveted).
Baltimore and KC joined minor leagues. The AA awarded franchises to three
strong minor league clubs and to a new club in Brooklyn. The latter
folded mid-season and the Baltimore Orioles replaced it.

When the NL and AA merged after the 1891 season, the 8 NL clubs and 4 of
the AA clubs including Baltimore retained their franchises*.

teamID BL3 apparently identifies that franchise* but I don't think teamID
generally does that. The structure isn't easy to perfect; I'm not sure it
is worth improving short of incorporating minor and independent clubs.

There has been some mention of a clubs project for the SABR 19c Cmte.

P/\/ \/\/t
Paul Wendt, Watertown MA, USA <pgw@...>
Chair, 19th Century Committee, SABR
Owner-Administrator, 19cBB (egroup at Yahoo)


> 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




Sun Oct 3, 2004 4:17 pm

pgw02472
Offline Offline
Send Email Send Email

Forward
Message #2228 of 3878 |
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
Offline 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
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help