February 22, 2009
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.
| 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 |
| 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 |
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!
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
Can’t get the Washington Nationals download .ros to work. Can you help?
Darren
works for me…
http://www.pitchbypitch.com/rosters/files/WAS2009.ROS
let me know if it’s not working.
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!
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.
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
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.
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
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
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
Oops, i meant to say i stopped using CSV for FixedIt.
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
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
Sure… I added them today.
Enjoy!
[...] 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 [...]