I’m running the first few queries on my pitch-by-pitch database. I’ve still got a few kinks to work out. I haven’t really spent much time validating the data other than on a couple games I picked for test cases. I want to parse a few more of the XML files and insert them into the database. Still, I’m excited! My database is finally up and running and giving me interesting PITCHf/x data!

To lead off, a question I’ve had, and one I’ve seen from others, is which stadia have the PITCHf/x system installed? There are nine parks that have had the system most of the year:

  • Seattle, 91% of pitches recorded with PITCHf/x
  • San Diego, 91%
  • Chicago White Sox, 91%
  • LA Anaheim, 86%
  • Toronto, 84%
  • LA Dodgers, 82%
  • Atlanta, 82%
  • Oakland, 80%
  • Texas, 77%

Other cities have been brought on line throughout the year, including the following teams:

  • Chicago Cubs, 33% of pitches recorded with PITCHf/x
  • Milwaukee, 22%
  • Boston, 21%
  • San Francisco, 19%
  • Arizona, 18%
  • Minnesota, 14%
  • St. Louis, 12%
  • Detroit, 12%
  • Houston, 10%
  • Cleveland, 9%
  • Cincinnati, 4%

Then there are four parks that have only a partial game’s worth of data:

  • Washington – 102 pitches
  • Colorado – 91 pitches
  • Kansas City – 50 pitches
  • Tampa Bay – 45 pitches

Finally, there are six parks that haven’t recorded any PITCHf/x data:

  • Baltimore
  • Florida
  • New York Mets
  • New York Yankees
  • Philadelphia
  • Pittsburgh

So, which pitchers have thrown the most pitches that have been recorded with the Enhanced Gameday PITCHf/x system this year?

  • Miguel Batista – 1,782
  • Dan Haren – 1,705
  • Kelvim Escobar – 1,627
  • Jarrod Washburn- 1,574
  • Jake Peavy – 1,548
  • John Lackey – 1,448
  • Joe Blanton – 1,428
  • Mark Buehrle – 1,397
  • Javier Vazquez – 1,397
  • Derek Lowe – 1,391
  • Chris Young – 1,356
  • Roy Halladay – 1,349
  • Kevin Millwood – 1,338
  • Tim Hudson – 1,323
  • Jon Garland – 1,294
  • Jered Weaver – 1,279
  • Felix Hernandez – 1,247
  • Brad Penny – 1,244
  • Chad Gaudin – 1,226
  • Shaun Marcum – 1,175
  • David Wells – 1,173
  • Kameron Loe – 1,147
  • John Smoltz – 1,147
  • Robinson Tejeda – 1,133
  • Jeff Weaver – 1,085
  • John Danks – 1,074
  • Greg Maddux – 1,029
  • Chuck James – 1,026
  • Justin Germano – 984
  • Mark Hendrickson – 979

That’s the top thirty. But what about notable relief pitchers that have an extensive history captured by the system this year?

  • Brandon Morrow – 606
  • J.J. Putz – 589
  • Heath Bell – 587
  • Scot Shields – 572
  • Joaquin Benoit – 547
  • C.J. Wilson – 530
  • Jonathan Broxton – 529
  • Rudy Seanez – 522
  • Oscar Villareal – 502
  • Dustin Moseley – 499

And some of the big-name closers?

  • Francisco Rodriguez – 453
  • Takashi Saito – 430
  • Eric Gagne – 388
  • Bobby Jenks – 362
  • Trevor Hoffman – 345
  • Bob Wickman – 294