No need.  Like I said, I sent it out somewhere, probably not here. Plus, I
sent out so many notes in those few days, who knows exactly what I was
saying.  I should have been more economical with my posts.

In any case, I'm glad that you gave it a second review.

Tom

> Sorry, I just missed that note.
>
> sean
>
>
>
>
> On Thu, Nov 20, 2008 at 11:06 AM, Tangotiger <tom@...> wrote:
>
>>   Hmmm... I made the announcement on my blog with the updated file, I
>> think
>> I made the announcement at Retrolist, and I guess I overlooked making
>> the
>> announcement here. Two out of three and all that...
>>
>> Thanks to Sean for the alert.
>>
>> The correct IDs, as well as the most up-to-date DB shell script, will
>> always be found here:
>>
>> http://tangotiger.net/bdb/
>>
>> Tom
>>
>>
>>
>
>
>
> --
> Sean Forman
> President, Sports Reference LLC
> http://www.sports-reference.com/
>


---------------------------------------------
The Book--Playing The Percentages In Baseball
http://www.InsideTheBook.com

I should highlight that in that folder, I have the primary positions file
for every player/season.

What I did *not* do was for the BDB shell script to import that file
automatically.  I could, but I didn't.  The reason was for that shell
script to only import the data that directly corresponds to the "official"
tables in the BDB.  (Note: it is very easy to import it manually, in
Access: just click NEW/Import Table.)

I could expand, for example, by including wOBA or LWTS, or creating a
"BattingNoStint" table to group the records to get rid of the stint field.
  Really, there's no end to what we can do in terms of making the DB more
friendly.

Perhaps I will make an exception for this particular case, simply because
it's a fairly involved process to try to get the primary position.  If
there are other useful things that can be generated (that would require a
fairly involved process), please post it, and I'll consider it.

Thanks, Tom


> The correct IDs, as well as the most up-to-date DB shell script, will
> always be found here:
>
> http://tangotiger.net/bdb/
>
> Tom
>
>
>

> Clem,
>
> It was purely a matter of trying to get the 2008 data out.  I definitely
> want to get your data in there, but just didn't have the time to.
>
> sean
>

What might be helpful is if someone creates a "2008" folder in the groups
section, and then all files that have not yet been incorporated can be
posted there.  This way, whoever has the time can provide a sql script or
set of commands to do whatever updates or creates are needed, much for
example, the way the new RETROids were incorporated.

Tom

For goldswa02 (Walt Goldsby), his listed weight is 1658.

--CW

Mistake Location: Teams Table

Mistake Field: teamIDretro

Mistake Description: The Anaheim Angels retrosheet ID is ANA from 1997
to 2008. In the Teams Table, ALA is listed for 2007 and 2008.

--- In baseball-databank@yahoogroups.com, "Clem Comly" <ccomly@...> wrote:
>
> Pete Palmer has assured me that the BIS data is correct.  But
obviously that is not the source of data for mlb.com,
baseball-reference, and baseball-databank.  He reports the sum of DH G
for all AL teams is 2454 and NL teams is 132 which is far more than
those 3 on-line sources seem to indicate.
>
> Clem Comly
>

I think I missed a post in here.  What is this in reply?

Anyway, I get a total of 2142 DH games for AL and 132 for NL.

Sanity check: there are 9 (I think) games each AL team doesn't play in
an AL park.  So, 153*14= 2142

Maybe I only have the "starts" for DH, and not the PH/DH games?  I'll
check.

Tom

I was wondering when the Lahman database is going to be ready for
public consumption.  The website still says end of November, which
was, you know, a while ago.

Thanks,
dave

> I was wondering when the Lahman database is going to be ready for
> public consumption.  The website still says end of November, which
> was, you know, a while ago.
>
> Thanks,
> dave
>
>

I suggest you download the Access database here:
http://tangotiger.net/bdb/

Follow the instructions, and in a few minutes, you'll have a working copy
that is equivalent to the Lahman database.

Tom

---------------------------------------------
The Book--Playing The Percentages In Baseball
http://www.InsideTheBook.com

Thanks for the replies, but I like the simplicity of the Lahman output -- no
macros or interpreting SQL files or anything.

dave

Has anyone complied number of days on DL data? Number of games missed
due to being on DL?

That data would be very interesting to consider when forecasting
player stats.

Craig Tomarkin

I looked for the data and the only place I could find any data is at:

http://www.baseball-injury-report.com/about.shtml

It is a pay site, but all that I could currently find.

--- In baseball-databank@yahoogroups.com, KJOK <kjokbaseball@...> wrote:
>
> Craig:
>  
> This doesn't directly answer your question, but there has been some
discussion about adding DL and other types of 'off' time to the
transactions database over on that egroup:
>  
> http://sports.groups.yahoo.com/group/BBTransactions/?yguid=84616618
>  
> if you want to search the archives there.
>  
> THANKS,
> KJOK
>
>
> --- On Mon, 12/15/08, ctomarkin <CTOMARKIN@...> wrote:
>
> From: ctomarkin <CTOMARKIN@...>
> Subject: [baseball-databank] DL data
> To: baseball-databank@yahoogroups.com
> Date: Monday, December 15, 2008, 1:11 PM
>
>
>
>
>
>
> Has anyone complied number of days on DL data? Number of games missed
> due to being on DL?
>
> That data would be very interesting to consider when forecasting
> player stats.
>
> Craig Tomarkin
>

On Fri, Dec 19, 2008 at 9:49 AM, Matthew Gargano <mgargano@...> wrote:
> Has anyone complied minor league stats into a SQL/MDB database?

SABR is doing just that:

http://minors.sabrwebs.com

I will be releasing my annual CSV files of the previous year's minor
league statistics sometime in the next month, including all North
American leagues, plus Japan, Korea, Italy, and the Netherlands.

Ted

I went ahead and downloaded Tango's 2008 files (thank you, Tango) and
noticed something.  Kila Kaaihue (or Ka'aihue) had 24 plate
appearances with the Royals this year.  His record is in the batting
table, but he's not listed in the Master table.

I don't know who tracks these things, so I am just posting it to the list.

dave

I found him (Ka'aihue).  Stupid apostrophe!

dave

All,

Just uploaded the MLB transaction data, parsed out from the MLB
website.  The data includes all player transactions from 2001 up
through the end of October 2008.  Transactions are injuries, trades,
moves to the minors and back etc.

The data is in free form text, but there are some patterns.  I've
coded some rules to parse the information out into some basic
categories (to the DL, to the minors, trades, etc).  One other issue
is that the transactions are given by player name, no identifying
number is given.  I've tried to add the MLBID (sometimes called the
mlbam), which is used as a key to player sites on the MLB site.  The
table is rife with errors and mistakes, but some of the data is really
messy (especially in 2001-2002).

The layout of the table is below.  The file is actually a dump from a
Postgres database, but it should be basically compatible with MySQL
and other databases.  The file has the CREATE TABLE statements and
then loads the data with INSERT statements.  There are 21,677 records
in the data.

I'm all for free data, enjoy!


                  Table "mlb.mlb_trans"
    Column    |            Type             | Modifiers
-------------+-----------------------------+-----------
  transid     | integer                     |
  playername  | text                        |
  playerpos   | text                        |
  playerid    | integer                     |
  teamabbr    | text                        |
  trans_date  | date                        |
  trans_txt   | text                        |
  to_dl_ind   | smallint                    |
  from_dl_ind | smallint                    |
  dl_txt      | text                        |
  minors_ind  | smallint                    |
  minors_txt  | text                        |
  injury      | smallint                    |
  injury_txt  | text                        |
  callup_ind  | smallint                    |
  callup_txt  | text                        |
  sign_ind    | smallint                    |
  sign_txt    | text                        |
  insertdate  | timestamp without time zone |
  lost_ind    | smallint                    |
  lost_txt    | text                        |


Thanks,

Mike




--- In baseball-databank@yahoogroups.com, Michael Greene
<mfgreene79@...> wrote:
>
> The baseball transactions are all listed on the MLB website (going
> back to 2001).  I have done some work creating a web spider and
> trying to match the names back up to the player lists.  If this
> information is of interest, I can try and create an extract to get it
> up.  I don't use MYSQL (I'm a fan of Postgres), but I could probably
> set it up with inserts instead.
>
> Mike
>
>
>
> On Dec 19, 2008, at 11:03 AM, wydiyd wrote:
>
> > I looked for the data and the only place I could find any data is at:
> >
> > http://www.baseball-injury-report.com/about.shtml
> >
> > It is a pay site, but all that I could currently find.
> >
> > --- In baseball-databank@yahoogroups.com, KJOK <kjokbaseball@>
> > wrote:
> > >
> > > Craig:
> > >
> > > This doesn't directly answer your question, but there has been some
> > discussion about adding DL and other types of 'off' time to the
> > transactions database over on that egroup:
> > >
> > > http://sports.groups.yahoo.com/group/BBTransactions/?yguid=84616618
> > >
> > > if you want to search the archives there.
> > >
> > > THANKS,
> > > KJOK
> > >
> > >
> > > --- On Mon, 12/15/08, ctomarkin <CTOMARKIN@> wrote:
> > >
> > > From: ctomarkin <CTOMARKIN@>
> > > Subject: [baseball-databank] DL data
> > > To: baseball-databank@yahoogroups.com
> > > Date: Monday, December 15, 2008, 1:11 PM
> > >
> > >
> > >
> > >
> > >
> > >
> > > Has anyone complied number of days on DL data? Number of games
> > missed
> > > due to being on DL?
> > >
> > > That data would be very interesting to consider when forecasting
> > > player stats.
> > >
> > > Craig Tomarkin
> > >
> >
> >
> >
>