Results 1 to 14 of 14

Thread: Baseball Data

  1. #1
    Staff Emeritus
    Military Professional
    Shek's Avatar
    Join Date
    23 Feb 05
    Location
    Krblachistan
    Posts
    11,473

    Baseball Data

    For those of you interested in baseball data, here are some sites:

    www.retrosheet.org - This site has play-by-play data as well as other data; this is the most comprehensive site in terms of data, but it doesn't have a user interface. You have to download the data and slice and dice it yourself. If anyone is interested in this data, I'm writing a script to unpack the play-by-play information from 1953-2008 into an Excel spreadsheet (warning, the file will probably be about 1GB and will require you to manually download and unzip over 100 folders and then transfer all the files from these folders into a single folder).

    www.baseball1.com - This has the Lahman Database that includes individual and team data from 1871-2008 in .csv or .dba formats. You have to compute advanced statistics if you wish to look at those (e.g., OBP, SLG, etc.).

    www.baseball-reference.com - This site has advanced statistics already computed for you, but you can't download data. They are working on a beta site that will have an even larger array of stats: http://sandbox.baseball-reference.com/.
    "So little pains do the vulgar take in the investigation of truth, accepting readily the first story that comes to hand." Thucydides 1.20.3

  2. #2
    Global Moderator
    Military Professional
    Defense Professional
    Albany Rifles's Avatar
    Join Date
    27 Apr 07
    Location
    Prince George, VA
    Posts
    4,445
    There is a large puddle of drool on the floor in front of my computer

    Thanks Shek
    Knowledge is knowing a tomato is a fruit. Wisdom is to know to not use it in a fruit salad.

  3. #3
    Official Thread Jacker Senior Contributor gunnut's Avatar
    Join Date
    27 Jan 06
    Location
    DPRK, Demokratik People's Republik of Kalifornia
    Posts
    21,348
    Quote Originally Posted by Albany Rifles View Post
    There is a large puddle of drool on the floor in front of my computer

    Thanks Shek
    Don't tell me...you're a statistician looking for a challenge?
    "Only Nixon can go to China." -- Old Vulcan proverb.

  4. #4
    Staff Emeritus
    Military Professional
    Shek's Avatar
    Join Date
    23 Feb 05
    Location
    Krblachistan
    Posts
    11,473
    Just finished running the play-by-play script: 3.6 GB of data

    If you're curious about what information is in the play-by-play files, the attachment has the data that's captured.
    Attached Files Attached Files
    "So little pains do the vulgar take in the investigation of truth, accepting readily the first story that comes to hand." Thucydides 1.20.3

  5. #5
    Registered User
    Join Date
    06 Apr 07
    Posts
    1,596
    Thanks Shek, I've always used baseball-reference, but I'll check out the other sites too.

  6. #6
    Staff Emeritus
    Military Professional
    Shek's Avatar
    Join Date
    23 Feb 05
    Location
    Krblachistan
    Posts
    11,473
    "So little pains do the vulgar take in the investigation of truth, accepting readily the first story that comes to hand." Thucydides 1.20.3

  7. #7
    Staff Emeritus
    Military Professional
    Shek's Avatar
    Join Date
    23 Feb 05
    Location
    Krblachistan
    Posts
    11,473
    Here's the code to get all the play by play information from regular season baseball games from 1953-2008 (you'll have to do some manual downloading and unzipping, but once that's done, it's short and easy ).

    1. Download Perl: http://www.perl.org/.
    2. Download all the event files from Retrosheet: http://www.retrosheet.org/game.htm.
    3. Extract all the downloaded zip files.
    4. Copy all the contents of the by year/league folders into a single folder.
    5. Place the attached ".txt" file into the same folder and rename the file with a ".pl" extension. Make sure that you have the BEVENT executable in the same folder: http://www.retrosheet.org/tools.htm. Click on the file and watch play by play files from 1953-2008 appear in the same folder as ".csv" files . The total download is right at 3.5 GB.
    Attached Files Attached Files
    "So little pains do the vulgar take in the investigation of truth, accepting readily the first story that comes to hand." Thucydides 1.20.3

  8. #8
    Global Moderator
    Military Professional
    Defense Professional
    Albany Rifles's Avatar
    Join Date
    27 Apr 07
    Location
    Prince George, VA
    Posts
    4,445
    Quote Originally Posted by gunnut View Post
    Don't tell me...you're a statistician looking for a challenge?

    Mrs AR would laugh long and loud at you...I never took a stats course in my life...for which she, with her MS in Nursing degree, always said my MA in history was not a real degree.


    Its just that baseball is such a numbers driven sport
    Knowledge is knowing a tomato is a fruit. Wisdom is to know to not use it in a fruit salad.

  9. #9
    Official Thread Jacker Senior Contributor gunnut's Avatar
    Join Date
    27 Jan 06
    Location
    DPRK, Demokratik People's Republik of Kalifornia
    Posts
    21,348
    Quote Originally Posted by Albany Rifles View Post
    Mrs AR would laugh long and loud at you...I never took a stats course in my life...for which she, with her MS in Nursing degree, always said my MA in history was not a real degree.


    Its just that baseball is such a numbers driven sport
    It is, sir. It is.

    There's probably a stat kept for players hitting at visitors park, at night, against left hand pitching, with 2 strikes and 1 ball, man in scoring position, with wind blowing in from the right field, and a home crowd of less than 12,000.

    "Yes, Johnny Rico hit .255 under such a condition."

    "Pull a 2-for-1 switch. Let's play the numbers here. Bob Smith hit .256..."

    "But Rico is .780 against this particular lefty on the mound!"

    "Aha, all the hits came at home."
    "Only Nixon can go to China." -- Old Vulcan proverb.

  10. #10
    Staff Emeritus
    Military Professional
    Shek's Avatar
    Join Date
    23 Feb 05
    Location
    Krblachistan
    Posts
    11,473
    Quote Originally Posted by gunnut View Post
    It is, sir. It is.

    There's probably a stat kept for players hitting at visitors park, at night, against left hand pitching, with 2 strikes and 1 ball, man in scoring position, with wind blowing in from the right field, and a home crowd of less than 12,000.

    "Yes, Johnny Rico hit .255 under such a condition."

    "Pull a 2-for-1 switch. Let's play the numbers here. Bob Smith hit .256..."

    "But Rico is .780 against this particular lefty on the mound!"

    "Aha, all the hits came at home."
    Wind blowing in from right field is the only piece of data that Retrosheet doesn't have. However, with some high speed spidering skills (I don't have any), you could pick that data up easily and mash it with the rest.
    "So little pains do the vulgar take in the investigation of truth, accepting readily the first story that comes to hand." Thucydides 1.20.3

  11. #11
    Global Moderator
    Military Professional
    Defense Professional
    Albany Rifles's Avatar
    Join Date
    27 Apr 07
    Location
    Prince George, VA
    Posts
    4,445
    Quote Originally Posted by gunnut View Post
    It is, sir. It is.

    There's probably a stat kept for players hitting at visitors park, at night, against left hand pitching, with 2 strikes and 1 ball, man in scoring position, with wind blowing in from the right field, and a home crowd of less than 12,000.

    "Yes, Johnny Rico hit .255 under such a condition."

    "Pull a 2-for-1 switch. Let's play the numbers here. Bob Smith hit .256..."

    "But Rico is .780 against this particular lefty on the mound!"

    "Aha, all the hits came at home."

    Ever see the Tom Selleck movie Mister Baseball? They have a scene in it just like that.

    And about 10 years ago someome at MIT did her doctoral thesis on the drop off in home runs at Fenway Park after the Red Sox put in roof seats with a wind break behind them!
    Knowledge is knowing a tomato is a fruit. Wisdom is to know to not use it in a fruit salad.

  12. #12
    Defense Professional Dreadnought's Avatar
    Join Date
    12 May 05
    Location
    Philadelphia, PA.
    Posts
    13,648
    Hall of Fame sports broadcaster Harry Kalas, 73, was found unconscious in the broadcast booth at Washington DC’s Nationals Park and rushed to the hospital according to media reports.

    Philadelphia Phillies President David Montgomery is quoted as speculating “it’s serious.”

    Update: Sadly, Philadelphia broadcasting legend Harry Kalas is dead at 73 according to AP.


    The man went out doing his thing from the booth. God Bless Harry were sure going to miss ya!:(
    Fortitude.....The strength to persist...The courage to endure.

  13. #13
    Global Moderator
    Military Professional
    Defense Professional
    Albany Rifles's Avatar
    Join Date
    27 Apr 07
    Location
    Prince George, VA
    Posts
    4,445
    Died in the saddle.

    I was listening to the Nationals game broadcast yesterday and couldn't figured out why the game was delayed.

    It was so they could regroup for the broadcast.

    At least he got to see the Phillies win the Series again before he went.
    Knowledge is knowing a tomato is a fruit. Wisdom is to know to not use it in a fruit salad.

  14. #14
    Senior Contributor
    Join Date
    10 Oct 07
    Posts
    3,018

    ManRam (AR's nickname for Ramirez) Ties Mickey Mantle

    This belongs in this thread:

    MILWAUKEE(AP) Manny Ramirez called it just another home run. Dodgers manager Joe Torre acknowledged the feat was special while noting in the same breath the suspicion that will hang over the enigmatic slugger's final numbers.

    Ramirez tied Mickey Mantle on the career home run chart early, and Matt Kemp hit a 10th-inning grand slam and made a fantastic catch for the final out to lead the Los Angeles Dodgers over the struggling Milwaukee Brewers 12-8 on Friday night.

    ''It feels good, but it's just like another home run,'' said Ramirez, who was distracted watching film of at-bats against the Phillies and swinging his arms gently through an imaginary strike zone. ''It makes me proud, but like I said it's just another home run that I hit. I didn't even know I tied him.''

    Ramirez's 536th homer pulled him even with Mantle for 15th place, and the Dodgers rallied against Trevor Hoffman in the ninth. Casey Blake drove in Ramirez with a triple in the 10th, and Kemp's slam broke it open moments later.

    ''Manny's a special talent, he's a special player, so was Mickey, obviously,'' Torre said. ''I know there's going to be some questions for the rest of his career. I'm not sure you can question how many he hits, it's how far they go. I think that's really what affects it more than anything else.''

    Andre Ethier , James Loney and Russell Martin also homered for the Dodgers (55-31), who will enter the All-Star break with the best record in the majors.

    Ramirez continued his torrid pace since returning from a 50-game drug suspension, hitting a two-run shot in the sixth. With two on in the 10th, Kemp made a running, over-the-shoulder grab of Jason Kendall 's drive to deep center with his back to home plate, similar to Willie Mays ' famous catch in the 1954 World Series.

    ''I was messing around with it in batting practice today,'' said Kemp, who ran up the wall for show after the catch. ''I guess I thought I'd use it in the game.''

    Torre joked it was more like Wesley Snipes' character in Major League: ''He comes in and says, 'Willie Mays Hayes.'''

    Brewers manager Ken Macha said it was a fitting end.

    ''To rub a little salt in our wounds the guy makes an over-the-shoulder catch to end it,'' Brewers manager Ken Macha said. ''It's a little disappointing to lose two days in a row having a one-run lead late.''

    This loss was especially painful for the Brewers because Hoffman blew a save opportunity for the second time this year and Carlos Villanueva (2-6) gave up six runs in the 10th for his second loss in as many days.

    The five Dodgers homers marked their biggest power surge since hitting seven against the San Diego Padres nearly three years ago, but small ball paid off first.

    ''You better win if you do that,'' Torre said. ''That's not normally what our signature is, but we certainly put them to good use tonight.''

    Ramirez walked with one out in the 10th and Blake, who had been 0 for 4, hammered a pitch off the wall in right-center field that allowed Ramirez to easily score.

    Juan Pierre intentionally walked and Martin hit an infield single that scored Blake. Orlando Hudson walked to load the bases and Kemp's homer landed in the second deck in left field, sending fans streaming to the exits.

    Ramon Troncoso (3-0) struck out Ryan Braun with the winning run at second to end the ninth and Jonathan Broxton gave up two runs in the bottom of the 10th in his second straight shaky appearance after allowing three in Sunday's 13-inning win against the Padres.

    Rookie Mat Gamel and J.J. Hardy homered for the Brewers, who have lost seven of nine and fell three games behind first-place St. Louis in the NL Central to match their largest deficit since May 7.

    Gamel's homer in the eighth put Milwaukee up 6-5, but Hoffman gave it back after converting 19 of his first 20 save chances.

    Martin singled to start the ninth, advanced to second on a sacrifice bunt by Hudson, reached third on Kemp's bunt single and scored when Mark Loretta singled up the middle to tie it at 6.

    ''Against teams like that, it's important to close the door,'' Hoffman said. ''I was just trying to be aggressive. It comes with the territory.''

    Notes: Ramirez is 7 of 22 with three homers, nine RBIs and seven runs scored in seven games since returning to the lineup. ... Brewers RHP Dave Bush (triceps) allowed four hits and an unearned run in 4 2-3 innings at Class-A Wisconsin in his first rehab start. He could return to the rotation as soon as July 20. ... Brewers RF Corey Hart (foot) missed his third straight game.
    Wow, no one's really going crazy. But to tie Mickey Mantle, the legend, just wow.

    Deserves to be posted in this thread.

    Congrats ManRam, Mickey Mantle was the great, hopefully we will look at you as one of the greats too.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. The Great Global Warming Swindle
    By Canmoore in forum Science & Technology
    Replies: 86
    Last Post: 30 Jun 07,, 09:32
  2. 2003 Navy Global Conops
    By Defcon 6 in forum Naval Warfare
    Replies: 6
    Last Post: 07 Jul 06,, 03:26
  3. Big Battleship Doctrine 2
    By Defcon 6 in forum Battleships Board
    Replies: 581
    Last Post: 16 Jun 06,, 21:37
  4. Refiguring The Iraq Body Count
    By Shek in forum The Middle East and North Africa
    Replies: 3
    Last Post: 18 Dec 05,, 16:34

Share this thread with friends:

Share this thread with friends:

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •