Colgate vs. Cornell home-and-home 1/19-20

[Trotsky]

stuff

That is awesome.  My portion of the lifelong project has been lifelong -- to record every box score of every Cornell game.  I'm at about 85% now.  I don't do penalties and that gives Arthur the sad, but it's good enough for me.

All I need is where to find the instructions to bypass CHN's interface and just download the raw data of game results.  All I need is the game_ID table mapping a key to each team and then game_ID-indexed table fields [date], [home_ID], [vis_ID], [home_G], [vis_G].  Basically, that's it: about 20 keystrokes per record for, oh let's say 100,000 games (a hundred teams averaging 10 "home" games a year over a hundred years) -- so maybe 2 million keystrokes.  

If you've got that, hey, share it!  I send a fresh copy of my full Access database to the Cornell AD every year (where no doubt he or she completely ignores it).

[Swampy]

stuff

That is awesome.  My portion of the lifelong project has been lifelong -- to record every box score of every Cornell game.  I'm at about 85% now.  I don't do penalties and that gives Arthur the sad, but it's good enough for me.

All I need is where to find the instructions to bypass CHN's interface and just download the raw data of game results.  All I need is the game_ID table mapping a key to each team and then game_ID-indexed table fields [date], [home_ID], [vis_ID], [home_G], [vis_G].  Basically, that's it: about 20 keystrokes per record for, oh let's say 100,000 games (a hundred teams averaging 10 "home" games a year over a hundred years) -- so maybe 2 million keystrokes.  

If you've got that, hey, share it!  I send a fresh copy of my full Access database to the Cornell AD every year (where no doubt he or she completely ignores it).

Probably don't ignore it. AD & staff just get a good laugh: "Oh look. Another database from that fool alum who can't get a life." ::dribble::

[adamw]

stuff

That is awesome.  My portion of the lifelong project has been lifelong -- to record every box score of every Cornell game.  I'm at about 85% now.  I don't do penalties and that gives Arthur the sad, but it's good enough for me.

All I need is where to find the instructions to bypass CHN's interface and just download the raw data of game results.  All I need is the game_ID table mapping a key to each team and then game_ID-indexed table fields [date], [home_ID], [vis_ID], [home_G], [vis_G].  Basically, that's it: about 20 keystrokes per record for, oh let's say 100,000 games (a hundred teams averaging 10 "home" games a year over a hundred years) -- so maybe 2 million keystrokes.  

If you've got that, hey, share it!  I send a fresh copy of my full Access database to the Cornell AD every year (where no doubt he or she completely ignores it).

Well, I only have about 10 teams, actually maybe more like 6 or 7 - and I am sharing it - on CHN .... If I get them all, maybe then I'd put it out there in CSV form for every team. It's excruciating work.  If you're really enterprising you can grab it ... But really, where else can you search for all-time college hockey results going back to 1896? And easily. By the way, it's 100% complete going back to 1986-87. All NCAA tournament, conference tournament, Beanpot and GLI results are in there all-time as well. Then Cornell, Yale, Harvard, BU, BC, Minnesota, Wisconsin, Michigan, North Dakota - maybe not the last few - I did a significant amount on them, can't remember if I did it all.

[upprdeck]

from other schools i have had discussions with there is mostly very little interest in any kind of database information.. some do it, most dont. even a school like cornell all they would have to do is open up the paper backups and someone would create it, probably for free.  get a database class project to provide the output..

[Trotsky]

Probably don't ignore it. AD & staff just get a good laugh: "Oh look. Another database from that fool alum who can't get a life." ::dribble::

I'm not the one stuck in Ithaca.  ::whistle::  ;-)

[Jim Hyla]

By the way, these pages - one for each season - have a summation of all of this kind of stuff.  For example, 2003 here:

https://www.collegehockeynews.com/reports/ncaa-tournament/2003

And it has the left/right arrow paradigm that you refer to. I haven't done that kind of thing for a week-by-week of the Pairwise - yet - not sure how used that would ever be. Or even if a week-by-week concept even makes sense in the context of the Pairwise, since it literally can change at any time. I get that "one week" is a good time frame in college hockey terms, but it's also kinda arbitrary when it comes to the Pairwise.

Adam, as I scanned thru the years, I noticed that when you started the Frozen Four bracket format, sometimes the Regional Semi winners get listed as winning the wrong regional semi game.

For example, look at 2016. BC beats Harvard, but is listed in the PU-UMD game. Maybe there's a reason that I don't understand, but it always seems to occur on the right side of the bracket page.

[abmarks]

responses to bits and pieces in this thread:

-Who's to assume that a NC is enough for Mike?  Some of the most successful coaches have gone well into their seventies- just look at Jerry York or Jack Parker.  If he just loves coaching maybe a NC would let him staff longer, since the pressure might be off.

-On the skating vs. size thing.  It's not just that we have more speed now.  Schaefer has talked about wanting his D-men to get up into the play no with their speed when the chance is there.  This is a completely new directive - so he's not just faster, but is also deploying that speed differently than he might have in the past.

-With this 10-player frosh group that is absolutely outperforming, we ought to be looking two or three years into the future and wondering just how good the team will be then;  especially if Mike is strategic with incoming recruits and fills the right needs.

[scoop85]

When I saw all the posts today for a moment I thought we had another visit from Sir Spamalot ::dribble::

[Swampy]

responses to bits and pieces in this thread:

-Who's to assume that a NC is enough for Mike?  Some of the most successful coaches have gone well into their seventies- just look at Jerry York or Jack Parker.  If he just loves coaching maybe a NC would let him staff longer, since the pressure might be off.

-On the skating vs. size thing.  It's not just that we have more speed now.  Schaefer has talked about wanting his D-men to get up into the play no with their speed when the chance is there.  This is a completely new directive - so he's not just faster, but is also deploying that speed differently than he might have in the past.

-With this 10-player frosh group that is absolutely outperforming, we ought to be looking two or three years into the future and wondering just how good the team will be then;  especially if Mike is strategic with incoming recruits and fills the right needs.

+1

[adamw]

Adam, as I scanned thru the years, I noticed that when you started the Frozen Four bracket format, sometimes the Regional Semi winners get listed as winning the wrong regional semi game.

For example, look at 2016. BC beats Harvard, but is listed in the PU-UMD game. Maybe there's a reason that I don't understand, but it always seems to occur on the right side of the bracket page.

Thanks Jim - I'll take a look.