Data!

So far I’ve crunched three seasons worth of data – 2014/15 so far, 2013/2014, and 2012/2013.

They are in CSV format and hopefully the content is self-explanatory.  I’ll be updating these with fixed, updated, and enhanced information on a regular basis.  Two more seasons to go.


You can download the CSV’s here:

Dataset for the predictive/comparable variables post:

If you’re using this data, check back regularly for adds and updates.


Data TO DO List:

  1. Finish parsing and converting seasons 2011/2012 and 2010/2011
  2. Add the missing games for each season (if I can, some appears to be bad data on the NHL site … GIGO)
  3. Fix some errors with shot locations (shots that occur in the same second can get the location information duplicated … haven’t figured a clever way to fix this yet)
  4. Add scores and situation columns (e.g. “close”, “up 2”, and so on)
  5. Add shot quality location indicators – low, medium, high, specific to shot type, based on the location data generated from the same three seasons
  6. Add temporal indicators – rush, rebound, cycle
  7. Separate players on ice out from a single column to 14 separate columns (Players 1 to 6 plus goalie, for each team).  Need 6 players for when the goalie is pulled.
  8. I may parse and convert the other related RTSS files (shifts and roster).
  9. I may try to adjust for rink shot location bias.

Metrics for defenders:

  • Does the conversion rate of Corsi (or Fenwick or shots) to scoring chances (per war-on-ice) provide a useful metric for evaluating defenders?

Orange for McDavid Project:

  • NHLE using only the Top 5 picks – DONE!

I should add one last key link … before I started collecting the event data myself (since there is no other published dataset available that I could find), the number crunching that I did do was collected from a variety of sites.  However, the key data came from Rob Vollman, who has made some enormous datasets freely available.  While some of them are the more esoteric datasets (e.g. GVT), Vollman has published spreadsheets (up to 350 data points each) on every player and goalie since 1967.

Staggering.  Such an amazing and generous contribution.  Making my data available is just my feeble attempt at walking in those same footsteps.

The link to his data page if you are interested is here: http://www.hockeyabstract.com/testimonials

(not sure why the page is linked with ‘testimonials’, it actually takes you to his statistics page).

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s