NHL.com + Sochi 2014 Data URLs in JSON and JSONP

[morehockeystats]

I wrote yet another small scraper, which is a pure bash script. The key feature is that it can run continuously, downloading snapshots of the game at any given time. You can simulate the live consumption of the information later with these snapshots.

morehockeystats/nhl-utils

Enjoy.

 

[morehockeystats]

FYI, so far I detected a few changes/additions in the NHL reports this season:
The penalties 'High-sticking' and 'Cross-checking' - spelled with the dash.
Two new penalties:
* GOALIE REMOVED OWN MASK
* REMOVING OPPONENT'S HELMET
There's a new shot type: POKE

 

[morehockeystats]

Add two more shot types:
* BETWEEN LEGS (goes well with POKE)
* BATTED

 

[Kane One]

The “goalie removed own mask” is just a more granular delay of game, right?

 

[morehockeystats]

The “goalie removed own mask” is just a more granular delay of game, right?

Yes. Most of DoG penalties are classified with their own surnames.

 

[Bear of Bad News]

Dropping this @norrisnick post here because I think it's a valuable article on how to use the NHL API:



Is anyone aware of an American Hockey League API tutorial?

 

[Bear of Bad News]

Going to ask a dumb question - my favorite. I do most of my stuff in Excel with VBA (I know, I know) and I want to pull the API down into that structure using Power Query.

I've dinked around for a couple of hours at this point and I'm not making good headway, so I figure I'd ask if anyone's tried this and wouldn't mind sharing an example or two (say, pulling from the live feed the end-of-game statistics for each player?). Or hell, just something that spits out the entire live feed into a semi-structure in Excel where things can be found and parsed there?

Code would be ideal because the data controls on this machine will prohibit me from downloading working Excel models.

 

[Bear of Bad News]

For instance, if I do this:

I can see all of player 8446261 (Randy Cunneyworth)'s game stats for game #2 of the 1997-98 season:

And I could then pick a single statistic and load it. Is there a way that I could pull *all* statistics for a given player/game into Excel?

More generally, is there a way that I can do conditionals (say, pull all goalie stats from game #2 of the 1997-98 season for all [ID] where [IDxxxxxxx].[position].[code ] = "G"?)

 

[Cowumbus]

For instance, if I do this:

View attachment 760552

I can see all of player 8446261 (Randy Cunneyworth)'s game stats for game #2 of the 1997-98 season:

View attachment 760554

And I could then pick a single statistic and load it. Is there a way that I could pull *all* statistics for a given player/game into Excel?

More generally, is there a way that I can do conditionals (say, pull all goalie stats from game #2 of the 1997-98 season for all [ID] where [IDxxxxxxx].[position].[code ] = "G"?)

I can look into this tomorrow assuming I remember.

I haven’t looked into this data location, but just by your code it looks like you will need to remove some lines, then use the filters after the data is already brought by in.

 

[Bear of Bad News]

Thank you! I've been hammering at different things but not making much progress (it appears to be hard to make progress in 20-minute increments via trial and error ).

 

[morehockeystats]

The endpoints have been retired by the NHL abruptly.
We need to reverse engineer new-api.md · master · Drew Hynes / nhlapi · GitLab now.
FYI.

 

[Michael Farkas]

Cool...I wasn't using this API to try to teach myself Python or anything...

 

[Bear of Bad News]

Motherfreak.

 

[Bear of Bad News]

nhle.com sounds super stable as heck, too.

 

[morehockeystats]

Motherfreak.

So that Python tutorial you posted recently should be suspended until further notice.

 

[Bear of Bad News]

So that Python tutorial you posted recently should be suspended until further notice.

I'm about to start using the bones of it on the new structure - once again, 20 minutes at a time, unfortunately.

 

[morehockeystats]

I'm about to start using the bones of it on the new structure - once again, 20 minutes at a time, unfortunately.

It seems to be leaner than the old one. Doesn't have some information. Will have to investigate for some time.

 

[Bear of Bad News]

Anyone aware of an American Hockey League API? Reddit is suggesting it's (at minimum) hard to get.

 

[Michael Farkas]

Anyone aware of an American Hockey League API? Reddit is suggesting it's (at minimum) hard to get.

Is there any official announcement or literature pointing towards it? I might be able to help procure it, but I want to see how it's "advertised" (or not)...

 

[Bear of Bad News]

Is there any official announcement or literature pointing towards it? I might be able to help procure it, but I want to see how it's "advertised" (or not)...

Nothing official as far as I can see. I've been trying to reverse engineer something from their game center pages:

view-source:TheAHL.com | The American Hockey League

And I'm coming up wanting.

 

[Michael Farkas]

Nothing official as far as I can see. I've been trying to reverse engineer something from their game center pages:

view-source:TheAHL.com | The American Hockey League

And I'm coming up wanting.

I'll fish around and see if there any bites.

 

[Bear of Bad News]

I'm currently doing direct loading of these:

Gamesheet: Lehigh Valley at Belleville - Nov 4, 2022

Into Excel and trying to pull them apart via VBA there. Yes, I'm nuts (but you all knew that).

Here's the oldest one, for trivia buffs:

Gamesheet: Bridgeport at W-B/Scranton - Oct 5, 2005

Baby Fleury in net!

 

[Michael Farkas]

My initial thought when looking at their site is that they have a stats partner (unlike the NHL, who does their own work). Just out curiosity, have you gone down this road for the AHL? GitHub - jonathas/hockeytech: Package to access the HockeyTech API

 

[Bear of Bad News]

I haven't tried that route yet (good find!) - it does look promising (it appears to be same tech that a lot of the minor leagues use, so could open up a lot of avenues with one screwdriver).

 

[Michael Farkas]

I haven't tried that route yet (good find!) - it does look promising (it appears to be same tech that a lot of the minor leagues use, so could open up a lot of avenues with one screwdriver).

Indeed that is the direction this is heading...response from the AHL.
"Our stats hosts at FloSports have API subscriptions available for some AHL content. You can contact them at [email protected] for pricing and details."