Holy Crap! This is the greatest database since BB-Ref and then Baseball Cube! Thanks so much, Jeff. This is fantastic!

I was just about to send this to you, Mike. This is the freaking Holy Grail for a guy like me. No more spending hours a day in front of my laptop compiling the Yankee Minor League Splits.

He, apparently, went through every box score and tallied things up from there.
I dont want to think of how hard and time consuming that mustve been

This almost makes me want to root for the Brewers.

This is great. I wonder if it's the same guy who was talking about doing this in the offseason minor league stats thread here.

This should be on the main page. This is a breakthrough. No more wondering whether (Insert favorite RHP with less than awe inspiring stuff) can get lefties out even though scouts say he can't. No more using GO/FO ratio. No more wondering whether that toolsy OF with the line drive bat really has said line drive bat. Now you can check. There has to be some type of award for this.

He, apparently, went through every box score and tallied things up from there.

Actually, what he did was go through the game logs and write scripts to extract the split data - which is a heck of a lot of work to get correct as it is.

-- MWE

Kyle S: yeah, that's me.

There has to be some type of award for this.

Right now, being "done" is a very nice reward. Of course, they keep playing games, so there's that to content with, but when I started hacking away at this project, I had absolutely no idea of how involved it would be.

I just want to say that I love this person. Love, love, love, love, love.

I've been wishing for this for years. thanks so very much for creating this website.

I was wondering if anyone could help me with this.

I'm importing the data using a text database query in Excel. I can't figure out how to grab only part of a page, however.

For example:

On the Clippers page I want only Melky Cabrera's stats. Is there a way I can do this?

The text document says this:

WEB
1
http://www.angelfire.com/nb/jms/milb/ColIL.html
Selection=All
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False

I changed selection to just the info. for Melky I found when I view the source, but this didn't change anything.

I should note that below AAA where the scorers are using Gameday, the game logs are not necessarily accurate on the batted ball type on hits. I've done 15 Mudcats games for BIS so far, and there are usually a couple of hits per game that appear as as ground balls in the log when they have actually been looped over the infield.

-- MWE

Ack. Good to know. Yet another caveat to tack on to my data :-(

Womack,

You might want to just import the whole page (all the stats) if you can, and then filter out Melky's line on your machine (either through Excel or Access).

This is a heck of a tool, Jeff! You Brewers fans never cease to amaze. Thanks!

Wow, this is awesome.

I was curious as to how Daric Barton was hitting lefties. It turns out his OPS is almost 1300 against them this year, and he is hitting righties like Jason Kendall hits everyone.

Brandon Wood's home/road splits don't look very picturesque: 388/423/755 at Home/ 197/315/426 on the Road. I could only find park factors for 2004 but back then Arkansas's park was an offensive 1097.

Checking on some of my strat farm players I found a mistake.

Brew Crew has the Nationals' Bill Bray with 6 HRA in 25.3 IP. He's been homer prone, but not that bad. The actual figures from milb.com are 4 HRA in 21.7 IP.

Anybody else finding mistakes?

I could only find park factors for 2004 but back then Arkansas's park was an offensive 1097.

03-05 Park Factors

Arkansas is 1.07/1.02/1.21/1.46/0.97/0.88 for R/H/2B/HR/BB/K.

For the sweet love of god! this is amazing

so apart from the gushing, token fact revealed by perusal of said splits
Salty is struggling against RHP this season, and might be getting a bit hit unlucky, lots of line drives
Max Ramirez on the other hand, has an insane BABIP. might be time to sell high on him

philly -- I'll try to figure out what's going on with Bray. There are a number of things that I know aren't perfect, but I'm really surprised that a pitcher would be credited with extra innings.

One possibility that somebody warned me about--occasionally the milb gamelogs flat-out miss things, like the occasional pitching change. Could be that Bray left the game, the gamelog didn't mention it, and somebody came in for a few innings and gave up two bombs.

If we got get games played by position added on, too, Jeff will be my bestest friend ever!

One possibility that somebody warned me about--occasionally the milb gamelogs flat-out miss things, like the occasional pitching change. Could be that Bray left the game, the gamelog didn't mention it, and somebody came in for a few innings and gave up two bombs.

I just went through his logs looking for something like that and didn't find it.

The problem with Bray appears to be the 4/29 game at home with Nashville. Anastacio Martinez pitched seven innings in that game and allowed 2 HRs - but none of that shows up in his splits. It looks as though a large part of Martinez's innings there were credited to Bray.

-- MWE

This site makes me proud to where my Brewers jersey.

Wear do you where it? :)

-- MWE

Dan: hmm, I was planning on adding splits by position, but games played...I guess I can do that too.

Mike: Thanks for the catch. I'll check that and see what's going on. Weird.

Okay, yep, Mike is right. It's fixed in my database, will be reflected next time I update the PCL, probably Saturday. I haven't figured out why my script did that wrong, which worries me.

This just keeps getting stranger. I just ran that game again, and the script didn't make the same mistake. So apparently whatever problem there was, I fixed in in the last week or so. Oh well...hope it didn't make a lot of similar errors as well.

Any thoughts to adding monthly splits or 1st half/second half? I know second half stats aren't meaningful in MLB, but it's always fun (if not useful) to wishcast breakout seasons for minor leaguers who had big second halfs.

yeah, somebody else mentioned monthly splits to me. I'll do that.

Jeff's got Team and League splits up now.

Awesome stuff, Jeff.
By the way (and I suspect you know this), the pitching splits and batting splits don't add to the same totals (see PCL - pitchers have generated 6,797 groundballs while hitters have produced 6,803 - and so on).

Also (and this is more for future reference), the game logs have occasional flubs in the assignation of positions. In particular, I've noticed catchers and center fielders getting swapped.

Also (and this is more for future reference), the game logs have occasional flubs in the assignation of positions. In particular, I've noticed catchers and center fielders getting swapped.

I've seen at least one game where six positions out of the nine were wrong.

-- MWE

By the way (and I suspect you know this), the pitching splits and batting splits don't add to the same totals

Yeah, I do know this. I don't really know why, either. I've got a couple ideas, though. I've come to expect a certain amount of imprecision from the MILB gamelogs combined with my amateur scripts, but this one was a surprise.

the game logs have occasional flubs in the assignation of positions.

Hmm, that I haven't noticed. (Admittedly, I have looked too hard, and I don't know that it would've advertised itself to me.) Any chance you could point me to an example?

Any chance you could point me to an example?
Check out this game (identified through this thread).

Check out this game

Thanks. So any defensive stats I would come up with would be even more spotty than I had already figured they would. At least it looks like the game logs are accurate as to the directions of balls and whatnot...not like they're charging passed balls to the CF or something.

the pitching splits and batting splits don't add to the same totals

It'll be a couple of days before I get this fixed for all leagues, but I think I've fixed the script. Just ran it with the <a href=http://www.angelfire.com/nb/jms/milb/TEXteams.html#lg>Texas League</a>.

Most of the errors are now fixed.

People - check out the updates to this wonderful site (now at http://www.minorleaguesplits.com/) - they include games by position (Dan is now your bestest friend ever, Jeff), but that's just the tip of the iceberg. Great, great job.

MLEs and more have been added.