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
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/