Union @ Cornell

[nshapiro]

So sure has been discussed before but is there any chance in relatively near future that UPenn and Columbia get D-I hockey programs and Ivy can form a new 8-team conference with an autobid?!

Pretty sure you only need 6 teams in a conference for the auto-bid.

I guess that leads to the modified question of why the ECAC doesn't split into two conferences so they get two auto-bids.  Teams could still play exactly the same regular season schedule - calling  ivy vs. non-ivy games OOC, just hold two post-season tournaments

[upprdeck]

doesnt it take a yr or 2 for this to happen though

[adamw]

If you can figure out the right way to do this with a window function, good on you. I spent a little time thinking about it and figured it was easier to just build progressive CTEs manually for each goal amount since we don't need more than 12-15ish....

I'm sure it's possible though. I've even done regressive sql before and felt like a golden god

I've done it with Window functions. Just not on the event level. Only on a game level (i.e. most goals in any 20-game rolling span). In fact, this is (half)-implemented on College Hockey News right now. I say half, because it's finding X-game spans from beginning or end of season -- which is slightly easier than ANY rolling x-game span, though has its own challenges.

Event level would be the same thing, in essence.

[DL]

Anyone have a link to video of the scoring breakout?

This!

Thanks! Shame it was just highlights instead of full play time surrounding the goals, considering how short it was.

13 minutes and 13 seconds for your entertainment.

What a rush. Thank you!

[marty]

Anyone have a link to video of the scoring breakout?

This!

Thanks! Shame it was just highlights instead of full play time surrounding the goals, considering how short it was.

13 minutes and 13 seconds for your entertainment.

What a rush. Thank you!

I didn't see Nick Young put up his dukes to incur the penalty - I was in section L on Saturday.  But I had seen someone else belt one of the Cornell players earlier in the period in a similar move. Couldn't feel bad for Union after realizing that at least one of the soon to be formerly known as Dutchman was getting a well deserved penalty.

[abmarks]

a database would make this pretty easy to figure out and compute without having to go look for stuff. I know we have something here is listed  even if it doesnt work.

Even if there was a database of every goal, its time and game -- computing "fastest in xx span" is not easy. I know because I have this data dating back to 2002 for all of college hockey, and the entire NHL, and I haven't gotten around to writing a method for computing it yet, because it's challenging. And I do this for a living.  Game level spans are hard enough - "for any floating x game span" ... I've done it for NHL. Haven't done it yet for NCAA.

Serious suggestion, not trolling.

Ask ChatGPT to write the code (or do the task)


From https://platform.openai.com/docs/guides/code/best-practices

Using source data to write database functions.
 Just as a human programmer would benefit from understanding the database structure and the column names, Codex can use this data to help you write accurate query requests. In this example we insert the schema for a database and tell Codex what to query the database for.

# Table albums, columns = [AlbumId, Title, ArtistId]
# Table artists, columns = [ArtistId, Name]
# Table media_types, columns = [MediaTypeId, Name]
# Table playlists, columns = [PlaylistId, Name]
# Table playlist_track, columns = [PlaylistId, TrackId]
# Table tracks, columns = [TrackId, Name, AlbumId, MediaTypeId, GenreId, Composer, Milliseconds, Bytes, UnitPrice]

# Create a query for all albums by Adele

[billhoward]

I'm in favor of  having all stats dating to Beebe Lake days being digitized and query-able. By somebody else. I'm sort of in favor of handing them off to Chatbot GPT.

I'm working on it, dammit.

You think that if you retire or scale back to half-time, you'll have time. Except you'll do things such as sleep 'til eleven that suck up your day.

My plan was to organize a million photos -- paper, film, slide, old diplomas and yearbooks -- which I started in 2014 while working full-time, I did maybe 10,000 images and in that period added ~50K digital images. Organizing hockey stats or photos takes a stable personality. More correctly, an Augean Stable personality.

[billhoward]

Penn brings back hockey.. does not rejoin the ivy because they want to have scholies. they become decent as an independent because they are located close to so many.   This forces the ivies to get out of the dark ages

Hand around that joint. If there's any left.

The Pennsylvania Class of 1923 (mostly them) funded  the rink that opened in 1970. The rink Wiki page notes it holds 2,500 (for "hockey / indoor football") and further notes it is the second largest college rink in the state behind only Penn State's Pegula Arena (6,014). By 1978 men's varsity hockey was gone. Penn made a bunch of spending cuts that year, many were rescinded, not hockey.

Penn has a women's 'student organization' hockey team; that seems to sound like club hockey.

If hockey came back, it'd have to be two teams, not one. It's not impossible. The NHL is as far south as Florida, Arizona, California. Other than Arizona State, Princeton sits at 40 degrees North latitude, Lindenwood (I had to look it up) in St. Lous at 39 degrees. So it's not crazy that Penn wouldn't at some day come back. Maybe Maryland and Rutgers would give it a good in the Big10. If I was a Class of '23 at Penn, I'd be pissed my donation mattered for less than a decade. IIRC, there was a donor-VIP box, glassed in, on stilts (?), at the rink.

[billhoward]

More stats is sort of good. But there's other historical-more-than-statisical stuff: when Clarkson sweaters went from okay to terrible, the year Union players allegedly got in some sort of racist/religious mischief, the highest temperatures in visitor locker rooms (did Harkness retire that award), the longest road trips by bus, attendance vs. rink capcity, the geo-center of the ECAC (I tried that once drawing lines and the center is pretty close to Albany), etcetera. Also which rinks have and which viewer feeds get overhead goal cam views.

[marty]

Also which rinks have and which viewer feeds get overhead goal cam views.

This just reminded me.  RPI used to have 2 over each goal. One official cam and one RPI TV cam.

Maybe Ursaminor can comment, but did the RPI TV free live feed die? Are they allowed to archive the games?

[billhoward]

I guess that leads to the modified question of why the ECAC doesn't split into two conferences so they get two auto-bids.

It's ready to be split:

• 6 in the Ivy Division
• 6 in the Safety Division

If the Bobcats had a sense of humor -- they do or did have the Ed McMahon School of Broadcasting -- fan T-shirts would say The Last Shall Be First.

[billhoward]

Also which rinks have and which viewer feeds get overhead goal cam views.

This just reminded me.  RPI used to have 2 over each goal. One official cam and one RPI TV cam.

Maybe Ursaminor can comment, but did the RPI TV free live feed die? Are they allowed to archive the games?

Probably. Fricking students were embarrassing professional video crews.

[ursusminor]

Also which rinks have and which viewer feeds get overhead goal cam views.

This just reminded me.  RPI used to have 2 over each goal. One official cam and one RPI TV cam.

Maybe Ursaminor can comment, but did the RPI TV free live feed die? Are they allowed to archive the games?

The free feed died because the league demanded it. I heard that they did archive games, but the website is under maintenance, so I can't check. They are not on their You-Tube channel.

[marty]

Also which rinks have and which viewer feeds get overhead goal cam views.

This just reminded me.  RPI used to have 2 over each goal. One official cam and one RPI TV cam.

Maybe Ursaminor can comment, but did the RPI TV free live feed die? Are they allowed to archive the games?

The free feed died because the league demanded it. I heard that they did archive games, but the website is under maintenance, so I can't check. They are not on their You-Tube channel.

ESPN Minus

[The Rancor]

Anyone have a link to video of the scoring breakout?

This!

Thanks! Shame it was just highlights instead of full play time surrounding the goals, considering how short it was.

13 minutes and 13 seconds for your entertainment.

What a rush. Thank you!

Seriously, thank you for the highlight reel!