Retrosheet Database Download

For the past 3 years I have compiled the Retrosheet Baseball Data into a mysql database for my brother, and made it publicly available . I started this project by using the tutorial provided by Tom Tango. If you want to import this data into a different database that is a good place to start. The zipped files range in sizes from 30MB to 550MB. The mostly used database is the last 10 years which is around 100MB, but if you want all the data go ahead and download the full retrosheet.

As always please help me with my bandwidth costs for this data. Just buy me a beer.

Click Here to download the last 10 years Retrosheet database.
Click Here to download the Full Retrosheet database.
Click Here to download the 1950′s Retrosheet database.
Click Here to download the 1960′s Retrosheet database.
Click Here to download the 1970′s Retrosheet database.
Click Here to download the 1980′s Retrosheet database.
Click Here to download the 1990′s Retrosheet database.
Click Here to download the 2000′s Retrosheet database.
Click Here to download the 2010′s Retrosheet database.

29 thoughts on “Retrosheet Database Download

  1. I can’t run the MySQL script because it’s incompatible with MSSQL Server scripting. Can you offer up a ZIP file with the MDF and log files?
    Thanks.

  2. I have the csv files if that works, but I will not put it in mssql format. You can reformat my insert statements with some unix commands to be compatible for mssql.

  3. Dumb newb question, but here goes: I downloaded the .sql file, and imported it with ‘reverse engineer script’, but that only got me the structure. All the tables are there, but they have no rows. How do I get the data itself to show up?

  4. You are awesome and this is awesome and I’ll buy you a beer every year I download this and did I mention this is awesome

  5. Same question as Nick, I was able to download the database fine, reverse engineer it into mySQL. then when i go to show first 1000 rows it doesn’t populate any data, anyone what I am doing wrong?

  6. Any chance of an updated “Last 10″ file? I realize it just came out today. The suspense is palpable.

  7. I’m using Workbench also, and I tried to Open SQL Script, but it says the file is too big to open. I was able to get the data in by using the MySQL command line. I ran the following:

    use retrosheet;
    source C:/last10.sql;

    Hope this helps.

  8. Workbench users: if it’s a .sql file, just use the “import sql dump” option – no other steps needed.

    Jeff – long shot here, but any chance of you posting a script file for updating the roster/master/fielding tables? I can grab the events and games from retrosheet myself, and get those tables updated, but I’m avoiding thinking through the others if possible.

  9. Thanks, awesome stuff. I may have made an error uploading stuff, but I think there are ~244 games missing from the games table in 2013 (all Yankees, Angels, and Padres home games). They exist in the events table but not the games table: SELECT DISTINCT GAME_ID FROM `events` WHERE GAME_ID NOT IN (SELECT GAME_ID FROM games)

  10. Also, I didn’t see this year’s players in the `id` table but they are all in the `rosters` table (Jedd Gyorko for example)

  11. Keith – I am looking into the first issue. I don’t see a problem with the send issue

    select * from id
    where debut like ‘%2013′

    and Gyorko is there.

    -Jeff

  12. Minor quibble: Jose Fernandez listed in the ID table as fernj001 but in the events table he shows up (correctly, I believe) as fernj003. I’m using the Last 10. Thanks for continuing to host this, guys.

  13. Pingback: The Unlikeliest Way to Score from First Base | Community – FanGraphs Baseball

  14. Pingback: Did Jack Morris pitch to the score? | War on WAR

  15. Pingback: Did Jack Morris pitch to the score? | War on WAR

  16. Pingback: 쌩쑈의 전말 | 데이터분석과 예측

  17. The data for the games table for the 1990s seem to be missing. All the other tables seem to have populated fine.

  18. The 1990s are missing the games data. It creates the table but then does not populate the games.

Leave a Reply

Your email address will not be published. Required fields are marked *


4 − = one

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>