Sports Reference Blog

Archive for the 'Hockey-Reference.com' Category

Exporting Data

7th November 2016

As you may have noticed, on our re-designed sites we recently disabled the feature allowing you to export our tables directly to Excel. This was because updated browsers were no longer supporting the function and it was becoming problematic to keep up. However, this doesn't mean that you can't still easily export our tables into spreadsheets. There's just an extra step or two, now.

First, look for the "Share & more" tab atop the table you'd like to export. If you don't see this tab, it means the particular table you're looking at isn't exportable. Otherwise, hover over it and options will drop down (see image). Select "Get table as CSV (for Excel)", which will convert the table to comma-separated values.

csv-descrip

Once the table has been converted to CSV, copy and paste the entirety of the table (or whatever section of it you want) into Excel, as text. You will now have an unintelligible, single-column mess in your spreadsheet, but that's fine. The commas are there for a reason and Excel will help us easily convert those commas into nice, readable columns of data. This next step is sometimes variable depending on the version of Excel you're working with, but what you want to find is the "text to columns" function. In my Excel for Mac 2011, this can be found under the "Data" tab. If you can't find it on your version, a google search for "Excel text to columns" with your Excel version number should yield useful results.

Once you have located the "text to columns" function, you will choose a file type that best describes your data. You will want to choose "delimited" since the fields are separated by commas. Next, you will choose the delimiter. Check the box next to "comma." Once you make that selection, you can finish up with the text to columns wizard and you should then have a nicely formatted spreadsheet.

We realize this is not quite as quick or simple as the old export function, but unfortunately we can no longer support that function. Once you get the hang of this method, you'll see it's also quite simple.

Posted in Announcement, Basketball-Reference.com, CBB at Sports Reference, CFB at Sports Reference, Data, Features, Hockey-Reference.com, HowTo, Pro-Football-Reference.com, Redesign, Tips and Tricks | 1 Comment »

Every Championship Round Game 7

2nd November 2016

With tonight's World Series Game 7, we thought we'd post quick links to Play Index searches showing every championship round Game 7 in MLB, NBA and NHL history. The lists are searches for home teams in Game 7s, sorted by date. If you click the date, you can see the box score for the game (when available). Enjoy!

World Series Game 7s (please note that this list is Winner Take All games, rather than Game 7s due to some World Series being longer than 7 games or having 7th games that weren't decisive in the early years)

NBA Finals Game 7s

Stanley Cup Final Game 7s

 

Posted in Announcement, Baseball-Reference.com, Basketball-Reference.com, Data, History, Hockey-Reference.com, Play Index, Playoffs | No Comments »

What the Heck is Corsi? A Primer on Advanced Hockey Statistics

13th October 2016

Good news for fans of zambonis, fighting, and the greatest video game of the 1990s: the NHL has finally returned! After a wild season last year, there are all kinds of juicy storylines to follow this year. Can the Pittsburgh Penguins become the first back-to-back Stanley Cup winners since the Detroit Red Wings of the 1990s? How will the San Jose Sharks bounce back from coming so close and falling short. Will Alex Ovechkin reach 1,000 goals? Can Connor McDavid build upon a promising rookie year and live up to the hype? What round of the Eastern Conference Playoffs will the Washington Capitals be eliminated in this year (I kid, I kid)?

This blog post will seek to answer none of those. Instead, this week, I wanted to dig into one of the major trends that's been sweeping across the NHL the last few years, among fans and front offices alike. I'm talking, of course, about the rise of advanced statistics.

If you're a sports fan, you're probably at least vaguely familiar with Moneyball and the advanced stat wars in baseball. And you may have read articles about how thinkers in other sports, like basketball, have used similar principles to deepen their understanding of the game. This movement has reached hockey in recent years, as researchers have uncovered several new ways of understanding the game beyond the traditional stats like goals, assists, and plus/minus. These new analytics can help us understand why a team is over or under-performing, and whether that performance is sustainable. They can also help us appreciate unsung players who do more for their team than we may realize, because they don't put up flashy traditional numbers.

So, with that in mind, here's some of the basics to get you started in the world of advanced hockey stats. Read the rest of this entry

Posted in Advanced Stats, Announcement, Hockey-Reference.com, Stat Questions, Statgeekery | 2 Comments »

Player Comparison Finder Added to Hockey Reference

20th September 2016

If you're an avid user of Pro Football Reference or Basketball Reference, you might be familiar with the Player Comparison tool in the Play Index. We're happy to announce that this popular tool has now been added to the Hockey Reference Play Index, as well.

With the Player Comparison Finder, you can choose anywhere from 2-6 players and compare single seasons, a selection of seasons, or their entire careers.

For instance, you can easily compare the rookie seasons of Alex Ovechkin and Mario Lemieux. Or you can compare their age-20 seasons. You can also compare spans of seasons. For instance, here's Wayne Gretzky's 1st 5 NHL seasons vs Lemieux's 1st 5 seasons.

You can also choose to compare entire careers. And, remember, you can select up to 6 players at a time:

Regular Season Comparison Table
Scoring Goals Per Game Point Shares
Player GP G A PTS +/- PIM EV PP SH GW G A PTS OPS DPS PS
Mike Bossy* 752 573 553 1126 381 210 384 181 8 82 0.76 0.74 1.50 93.1 17.8 110.9
Wayne Gretzky* 1567 917 2042 2959 505 611 633 210 74 94 0.59 1.30 1.89 231.5 27.8 259.3
Gordie Howe* 1767 801 1049 1850 87 1685 172 78 11 27 0.45 0.59 1.05 186.6 30.5 217.1
Mario Lemieux* 915 690 1033 1723 115 834 405 236 49 74 0.75 1.13 1.88 152.4 15.5 167.9
Eric Lindros* 760 372 493 865 215 1398 254 111 7 46 0.49 0.65 1.14 81.7 20.0 101.6
Mark Messier* 1756 694 1193 1887 210 1910 452 179 63 92 0.40 0.68 1.07 135.6 24.8 160.5
Provided by Hockey-Reference.com: View Original Table
Generated 9/20/2016.

Posted in Announcement, Features, Hockey-Reference.com, Play Index | No Comments »

NHL Rookies of the Month Added Back to 1983-84

11th August 2016

In January, we added NHL Rookies of the Month back to the 2005-06 season. We've recently made some additions and now have the award listed back to 1983-84.

There are a few holes in the data, however. If anyone has the October 1987, November 1989 or December 1990 winners, please let us know.

We hope you enjoy this addition to our NHL Awards section.

Posted in Announcement, Awards, Data, History, Hockey-Reference.com | Comments Off on NHL Rookies of the Month Added Back to 1983-84

Sports Reference to Launch Redesigned Sites this Summer

10th July 2016

If you follow me on twitter, you know that this work has been a long time coming. Starting last summer, Adam Wodon, Adam Darowski, and I started throwing around ideas for a more mobile-friendly version of our sites. Our mobile experience is probably charitably described as limited and functional and with now over 2/3rd's of our visits coming from handheld devices, we clearly needed to up our game there.

This led to complete review of what we have on our sites and how we present that data on desktop and how we can make that usable on a small screen. It's not easy and after months of design, user testing and work, we have an approach that we believe will serve both desktop and mobile users better than they are now. This is the first in a series of posts we'll publish about our redesign.
Read the rest of this entry

Posted in Announcement, Baseball-Reference.com, Basketball-Reference.com, CBB at Sports Reference, CFB at Sports Reference, Hockey-Reference.com, Pro-Football-Reference.com | 36 Comments »

Sports Reference Ending Page Sponsorships

1st July 2016

If you are a friend of Sports Reference, you'll know that sponsorships, which launched in July of 2002, were our second revenue generator (the first being just asking for money). For those who want to know, Charles Saeger sponsored Scott Erickson on July 21, 2002 to kick things off. For a number of years, sponsorships were our main revenue generator and paid all of the bills. Since 2006, however, sponsorships have become less and less of our overall revenue, now representing less than 4% of our annual revenue.
Read the rest of this entry

Posted in Announcement, Baseball-Reference.com, Basketball-Reference.com, CBB at Sports Reference, CFB at Sports Reference, Hockey-Reference.com, Pro-Football-Reference.com, Redesign | 3 Comments »

Redesign: Team and League Logos Courtesy SportsLogos.net

19th June 2016

See SportsLogos.net for historical and current sports logos

Chris Creamer does amazing work at SportsLogos.net and I've been wanting to work with him for quite a while to put examples of past and current logos on our sites.  So when our 2016 redesign got underway, we worked out an agreement that we could use copies of his aggregated logos on our site.

We also realize that many historical logos show offensive representations of various ethnic groups and peoples that were commonplace in their time and in American society. These representations are wrong now and were wrong then. We present them, as we do all of our facts, to educate and illuminate, and these prejudices have been an unfortunate part of the history of the sports we all enjoy and love.

Obviously, we do not own these logos and cannot give you permission to use them. We use them under a fair use argument. We use small resolution images, which do not impact the economic viability of the logos for their owners. And we provide them for educational purposes only. It's up to you to know the relevant intellectual property law and, since I'm not a lawyer, this is clearly not legal advice.

Enough with the disclaimers. Check out some old-time teams for some old-time logo goodness.

Posted in Announcement, Baseball-Reference.com, Basketball-Reference.com, CBB at Sports Reference, CFB at Sports Reference, FBref, General, Hockey-Reference.com, Pro-Football-Reference.com, Redesign | Comments Off on Redesign: Team and League Logos Courtesy SportsLogos.net

Player and Team Elo Rater Shutting Down

3rd June 2016

We have decided to remove the team and player Elo Rating pages. We had high hopes for the raters when we launched them but over the years they have too often become a test tube for online campaigns to elevate Dallas Cowboys or push down Los Angeles Lakers to a degree that we don't have any faith that they represent actual general user opinions on the relative quality of players or teams.

These pages will be removed as we launch our redesigned sites this summer beginning with hockey in a week or two.

Posted in Announcement, Baseball-Reference.com, Basketball-Reference.com, CBB at Sports Reference, CFB at Sports Reference, Hockey-Reference.com, Olympics at S-R, Pro-Football-Reference.com | 33 Comments »

2016 Stanley Cup Playoffs Statistics

13th April 2016

With playoffs season upon us, we wanted to point out our 2016 NHL Stanley Cup Playoffs section. While it's mostly a shell right now, it will be a good bookmark for info as the playoffs get going. You can find a schedule & results for every game, stats for every skater, goalie & team, as well as leaderboards.

There are also series preview pages to see how opponents match up with each other.

If you're more of a history buff, you can also take a skate down memory lane by checking out past playoff seasons, such as 2015 or 1987. Stats for series are also available, such as the 2013 Stanley Cup Final. Links to all playoff seasons (and a list of champions, runners-up and Conn Smythe winners) are available here.

Other Stanley Cup Playoff resources include our all-time Leaders & Records section, list of frequent champions and our Player Season Finder tool. With the Player Season Finder, you can run restrict your searches to playoff games and run all sorts of custom queries such as leading goal scorers, assists leaders, short-handed goal leaders and many others.

Our Team Game Finder & Player Game Finder also contain options to restrict your searches to playoff games only. You can search for things such as the most recent playoff hat tricks & team records in their playoff openers. You can also run searches for things like worst playoff opening loss by the eventual Stanley Cup champ. For player game searches, it should be noted that our player game logs currently go back to the 1988 Playoffs.

We also have historical sections for Stanley Cup Playoff Comebacks, a game-by-game breakdown of every possible scenario in a 7-game playoff series and every overtime goal in Stanley Cup Playoffs history.

We hope you enjoy these features and please let us know what you'd like to see in the future.

Posted in Announcement, Data, History, Hockey-Reference.com, Playoffs, Uncategorized | Comments Off on 2016 Stanley Cup Playoffs Statistics