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...
Show off your group to the world. Share a photo of your group with us.

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
Retrosheet Misc Batting and Pitching Stats   Message List  
Reply | Forward Message #3597 of 3878 |
Re: [baseball-databank] Retrosheet Misc Batting and Pitching Stats

Dave - Thanks so much for your efforts from the baseball databank group!

I was wondering if you could show me a thing or two.  Also I was wondering if you knew of an easy way to get pitch by pitch, or just similar data to what you have provided plus the basics (offense: AB, H, 2B, 3B, RBI, R, etc. and pitching: W L IP SV ER R BB, H, etc.) data into a database.  I have found some sites that I could scrape with PHP - but most of them are problematic and are subject to changes in design which would render my scraping schema useless.

Thanks so much again Dave!

Mat

On Thu, Sep 25, 2008 at 2:45 PM, Dave Carter <terpsfan101@...> wrote:
I have compiled additional batting and pitching statistics from
Retrosheet Play by Play data and wanted to share them here. I've
linked the Retro ID's to the BDB player ID's so you can easily join
them to your database. The only things stopping me from posting them
is that I don't know how to identify players with multiple stints on
the same team during one season. Also I am uncertain as to what
statistical categories I should include. For pitchers, I'd really
would of liked to have counted pickoffs. However, I didn't know an
easy way to seperate catchers pickoffs from pitchers pickoffs. That'll
be on the way shortly. Stolen Base and Caught Stealing data for
pitchers and catchers is already in the fielding tables.  Here's the
list of what I have compiled from Retrosheet from 1954 to 2007:

Batting:

Catcher's Interference
Reached on Error
Reached on Error Sacrifice Hit
Reached on Error Sacrifice Fly
Reached on Fielder's Choice (No Outs Recorded)
Reached on Fielder's Choice Sacrifice Hit
Pickoff Caught Stealing
Picked Off
Pickoff Error
Balk (Lead Baserunner)
Passed Ball (Lead baserunner that Advances)
Wild Pitch (Lead baserunner that Advances)
Defensive Indifference
Other Advance (Out Advancing)
Ground Balls
Fly Balls
Line Drives
Popups
GIDP Opportunities (Man on 1st, 0 or 1 out)
Retrosheet Plate Appearances
Missing Plate Appearances

Pitching

Doubles Allowed
Triples Allowed
GIDP Allowed
Sacrifice Hits Allowed (Complete from 1921 to the present)
Sacrifice Flys Allowed
Catcher's Interference Allowed
Reached on Error Allowed
Reached on Error Sacrifice Hit Allowed
Reached on Error Sacrifice Fly Allowed
Reached on Fielder's Choice Allowed
Reached on Fielder's Choice Sacrifice Hits Allowed
Ground Balls Against
Fly Balls Against
Line Drives Against
Popups Against
GIDP Against Opportunities
Retrosheet IP Outs
Missing IP Outs

Again, let me know what you'd for me to include. I can obviously
combine some of the categories.







------------------------------------

http://www.baseball-databank.org/Yahoo! Groups Links

<*> To visit your group on the web, go to:
   http://groups.yahoo.com/group/baseball-databank/

<*> Your email settings:
   Individual Email | Traditional

<*> To change settings online go to:
   http://groups.yahoo.com/group/baseball-databank/join
   (Yahoo! ID required)

<*> To change settings via email:
   mailto:baseball-databank-digest@yahoogroups.com
   mailto:baseball-databank-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
   baseball-databank-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
   http://docs.yahoo.com/info/terms/




Fri Sep 26, 2008 12:43 pm

tkestars
Offline Offline
Send Email Send Email

Forward
Message #3597 of 3878 |
Expand Messages Author Sort by Date

I have compiled additional batting and pitching statistics from Retrosheet Play by Play data and wanted to share them here. I've linked the Retro ID's to the...
Dave Carter
terpsfan101
Offline Send Email
Sep 26, 2008
11:15 am

Dave - Thanks so much for your efforts from the baseball databank group! I was wondering if you could show me a thing or two. Also I was wondering if you knew...
Matthew Gargano
tkestars
Offline Send Email
Sep 26, 2008
7:16 pm

Matt, I don't know anything about scraping data. The basic data (AB,H,...)is already in the BDB database. Unless you wanted to derive the basic data for 2008....
Dave Carter
terpsfan101
Offline Send Email
Sep 26, 2008
9:06 pm

... Join RetroSQL yahoo group. Tom...
Tangotiger
tom@...
Send Email
Sep 26, 2008
9:06 pm

... For pre-1980 years, the differences between these will blur in the data, and you won't have hits. I'd just go for: Air Outs - Pulled Ground Outs - Pulled ...
Charles Saeger
rasputin443556
Offline Send Email
Sep 27, 2008
3:23 am

Charles, Most of your suggestions shouldn't be difficult to implement. I had a feeling that I should have used outs for batted balls. Although seperating "Outs...
Dave Carter
terpsfan101
Offline Send Email
Sep 29, 2008
9:36 pm

I guess that I could throw out some of the baserunning categories. Here's my new list: Batting: XI ROE ROE SH ROE SF RFC RFC SH PkO CS PkO PkO Error GB FB LD ...
Dave Carter
terpsfan101
Offline Send Email
Sep 30, 2008
6:35 pm
Advanced

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