Now that the baseball season is over I thought I would throw together a little data breakdown of the 2014 playoffs according to the public StatCast records available. I created a rough relational database that will allow me to run a few simple queries to give us an idea of what information the new system will be able to spit out on a daily basis (fingers crossed, next season). I built the database with the anticipation of adding to the records next year as more data is released. I hope, eventually, there will be complete statistics available for each play because in the current format there are many null values which drives me nuts, but it is what it is.
Seven tables make up the database that is designed to catch each play in it's entirety. The four main tables are BATTING, FIELDING, PITCHING, and RUNNING. This is where all of the new fancy data is stored. Now as to not get further into the weeds lets take a look at what we got.
0 comments:
Post a Comment