MLB

These files are automatically generated at 12:00 PM every day based on roster information at http://www.mlb.com. The ROS files are formatted in the Retrosheet roster format. The .CSV files are to be used with FixedIt baseball scoring software.

American League
Team Name ROS CSV (FixedIt) CSV (Ballstat)
Baltimore Orioles ROS CSV CSV
Boston Red Sox ROS CSV CSV
Chicago White Sox ROS CSV CSV
Cleveland Indians ROS CSV CSV
Detroit Tigers ROS CSV CSV
Kansas City Royals ROS CSV CSV
Los Angeles Angels of Anaheim ROS CSV CSV
Minnesota Twins ROS CSV CSV
New York Yankees ROS CSV CSV
Oakland Athletics ROS CSV CSV
Seattle Mariners ROS CSV CSV
Tampa Bay Rays ROS CSV CSV
Texas Rangers ROS CSV CSV
Toronto Blue Jays ROS CSV CSV


National League
Team Name ROS CSV (FixedIt) CSV (Ballstat)
Arizona Diamondbacks ROS CSV CSV
Atlanta Braves ROS CSV CSV
Chicago Cubs ROS CSV CSV
Cincinnati Reds ROS CSV CSV
Colorado Rockies ROS CSV CSV
Florida Marlins ROS CSV CSV
Houston Astros ROS CSV CSV
Los Angeles Dodgers ROS CSV CSV
Milwaukee Brewers ROS CSV CSV
New York Mets ROS CSV CSV
Philadelphia Phillies ROS CSV CSV
Pittsburgh Pirates ROS CSV CSV
San Diego Padres ROS CSV CSV
San Francisco Giants ROS CSV CSV
St. Louis Cardinals ROS CSV CSV
Washington Nationals ROS CSV CSV

Trackback

16 comments until now

  1. Richard Thomas

    Hello,

    Great site, love it!

    I’m interested in how you generate .ROS and .CSV files from http://www.mlb.com; i assume that you either scrape the info from each roster page or use XPath queries?

    I’ve written a similar program to do a similar thing, except i’m gathering from the roster files at http://hosted.stats.com/mlb/teams.asp. The advantage of those rosters over the ones at mlb.com is that there is more specific information about each players’ position.

    I don’t have my program running automatically at the moment, but it generates .CSV and .KSS (an xml format used by program KForCe [http://www.rakonza.com]). I used to generate .ROS as well, but gave up on FixedIt because of lack of support and updates.

    Again, thanks for your work!

  2. Hi Richard,

    I’m glad you like the site!

    The rosters are created by screen scraping the MLB/MiLB websites using PHP/Curl. It’s not the prettiest thing in the world, but it works.

    Thanks for the info on the Stats site. You’re right. They do a better job of listing LF,CF,RF vs. OF. I might consider switching to them for MLB info.

    What are your thoughts on KForCe?

    Ben

  3. Can’t get the Washington Nationals download .ros to work. Can you help?

    Darren

  4. works for me…

    http://www.pitchbypitch.com/rosters/files/WAS2009.ROS

    let me know if it’s not working.

  5. Hello, I use BallScore/BallStat and have been unable to find a site where I can download the rosters in a format usable by this program.

    Your site is the best I have found, and would like to thank you for providing this info!

    One thing I have noticed is that the ROS files don’t include the jersey number, and the CSV files combine the player’s name.

    BallScore can import either of these formats, but I end up having to manually add the missing pieces. For me the ROS files would work great if it included the jersey number. Is their any chance of adding this?

    Basically, BallScore uses a format as follows:

    Team Name
    Jersey#, First Name, Last Name, Bats, Throws
    Jersey#, First Name, Last Name, Bats, Throws
    etc, etc.

    The first line is not comma delimited.
    Then each following line is comma delimited.

    Just wanted to suggest this, as I know there are a lot of folks out there who use this program.

    Thanks again for the roster info. Great work!

  6. No problem. I generated the Ballstat .CSV files, and you can access them from the Roster Files pages.

    Let me know how they work.

    How do you like Ballstat? I’ve never used it.

  7. Robert B

    Tried Ballstat… It’s OK, but I’ve gotten so used to project scoresheet-style scoring that it’s hard to go back. Really waiting for the pitch-by-pitch portion of your sheet to really make it worthwhile.

    Now that I’ve seen how the bevent works, you can do so much analysis on these stats!

    Rob

  8. Harrison L

    I found an old scorecard from a couple of years ago and wanted to put it in the scoresheet on the computer. However, some of the players are free agents now and the current rosters won’t work for this. How can I figure out or create codes for older players.

  9. The most ideal way would be to download the season roster file for these two teams. You can get it from http://www.retrosheet.org/game.htm.

    Another way (if you’re just interested in just creating a scoresheet and box score and not analyzing this game with other games), is to manually type each player into the Home and Away tabs of the scoresheet. Put a random unique ID in column A, Last name in column B, first name in column C, and the player’s full name in Column H. Everything should process fine.

    Let me know how it works!
    Ben

  10. Robert B

    Just a curious question…

    If I find I need to add a player to a team’s ROS file (i.e. TOR2009.ROS to add Randy Ruiz), When I open the ROS file in notepad, I noticed there are no spaces or line breaks between records, but when I open it in Word, there are. Is that a special character between records?

    Thanks as always,
    Rob

  11. Richard Thomas

    Hello Ben,

    I haven’t visited your site for some time, but wow, what an improvement, looks great!

    I still have my program that reads http://hosted.stats.com/mlb/teams.asp and generates KSS (XML format used by KForCE [http://www.rakonza.com] and CSV formats. I gave up on generated ROS files long ago because i stopped using FixedIt because of their non-existent support (although i still can — i believe you gave me a utility to aid in doing so).

    Again, great job!

    Richard Thomas

  12. Richard Thomas

    Oops, i meant to say i stopped using CSV for FixedIt.

  13. Robert B

    I’d love to learn how I can set something up where I can automatically generate either CSV or ROS files. Unfortunately I’m not much of a programmer, so I’d need some sort of step-by-step process.
    I think this site has done a great job in opening up possibilities to run procedures and stuff with retrosheet-style event logs. Would love to learn more!

    Robert

  14. Great stuff. Thanks for the rosters.

    Any chance you will be able to produce rosters for the Arizona Fall League teams?

    http://mlb.mlb.com/mlb/events/winterleagues/?league=afl

    Thanks,
    Peter

  15. Sure… I added them today.

    Enjoy!

  16. [...] bigger pain. Being able to import a roster to the cellphone would be most welcomed. Ben collates the MLB rosters daily on his Pitch-By-Pitch site. I don’t know how 6-4-3 handles the roster, but being able to [...]

Add your comment now