Difference between revisions of "Winner's Curse"

From edegan.com
Jump to navigation Jump to search
imported>Ed
imported>Ed
Line 6: Line 6:
 
==Player's Data==
 
==Player's Data==
  
The player's data will be retrieved by a web-crawler from http://www.nhl.com.
+
===Variables===
  
Specifically, go to Stats->Individuals or Stats, then the Players tab.
+
Variables are named 'view-name-prefix' followed by 'transformed NHL.com code'. The view name prefixes are three letter codes, listed in brackets next to the view names themselves. The untransformed NHL.com codes used are provided for each view name in the display box. The transformation rules are replacements as follows: % -> pc, / -> or OR / -> per (depending on context), + -> plus, - -> minus, ' ' -> '', 1 -> one, and so forth.
  
We want all seasons (no. players):
+
Bios (bio)
*1997-1998 (763)
+
# - Sweater Number
*1998-1999 (817)
+
Player - Player Name
*1999-2000 (838)
+
Team - Team
*2000-2001 (884)
+
Pos - Position
*2001-2002 (874)
+
DOB - Date of Birth
*2002-2003 (888)
+
Birth City - Birth City
*2003-2004 (916)
+
S/P - State/Province
*The was no 2004-2005 (870). This should not be included in pull list.
+
Ctry - Country
*2006-2007 (858)
+
Ht - Height in Inches
*2007-2008 (852)
+
Wt - Weight in Pounds
*2008-2009 (885)
+
S - Shoots
*2009-2010 (879)
+
Rk - Rookie
*2010-2011 (891)
+
GP - Games Played
*2011-2012 (894)
+
G - Goals
 +
A - Assists
 +
Pts - Points
 +
+/- - Plus/Minus
 +
PIM - Penalty Minutes
 +
TOI/G - Time On Ice Per Game
  
(14 seasons available - param pass is without the dash, e.g. season=20112012).
+
Summary (sum)
 +
PP - Power Play Goals
 +
SH - Short Handed Goals
 +
GW - Game Winning Goals
 +
GT - Game Tying Goals
 +
OT - Overtime Goals
 +
S - Shots
 +
S% - Shooting Percentage
 +
Sft/G - Average Shifts Per Game
 +
FO% - Faceoff Win Percentage
  
Pages (viewName=):
+
Assists (ast)
*Summary (summary)
+
  ESA - Even Strength Assists  
  (Player  Team  Pos  GP  G  A  P  +/-   PIM  PP  SH  GW  OT  S  S%  TOI/G  Sft/G  FO%)
+
  SHA - Short Handed Assists
*Assists (assists)
+
  PPA - Power Play Assists
  Player  Team  Pos  GP  G  A  P  +/-   ESA  SHA  PPA  HmA  RdA  DvA  ODvA  A/G
+
  HmA - Home Assists
*Bios (bios)
+
  RdA - Road Assists
  #    Player    Team    Pos    DOB    Birth City    S/P    Ctry    HT    Wt    S    Rk    GP    G    A    Pts    +/-     PIM    TOI/G
+
  DvA - Own Division Assists
*Goals (goals)
+
  ODvA - Other Division Assists
  Player  Team  Pos  GP  G  A  Pts  +/-   ESG  PPG  SHG  1G  OTG  GWG  HmG  RdG  DvG  ODvG  ENG  PSG  PST  G/G
+
  A/G - Average Assists Per Game
*Home (homeScoring)
 
  Player  Team  Pos  Home: GP  G  A  P  +/-  PIM  Pen  EV TOI/g  PP TOI/G  SH TOI/G  TOI/G  FO  FOW  FOL  FO%
 
*Penalties (penalties)
 
Player  Team  Pos  GP  PIM  Minor  Major  Misc  G Misc  Match
 
*Plus/Minus (plusMinus)
 
Player  Team  Pos  GP  G  A  P  +/-   Home +/-  Road +/-  Div +/-  Other Div +/-  Team GF  Team PPGF  Team GA  Team PPGA
 
*Points (points)
 
  Player  Team  Pos  GP  G  A  P  +/-   ESP  SHP  PPP  HmP  RdP  DvP  ODvP  P/G
 
*Real-time Stats (rtssPlayerStats)
 
  PlayerStats)
 
Player  Team  Pos  GP  Hits  BkS  MsS  GvA  TkA  FOW  FOL  Tot  FO%  %Tm  Shots  G  S%
 
*Road (roadScoring)
 
Player  Team  Pos  Road: GP  G  A  P  +/-   PIM  Pen  EV TOI/g  PP TOI/G  SH TOI/G  TOI/G  FO  FOW  FOL  FO%
 
*Shooting % (shootingAll)
 
Player  Team  Pos  GP  S  G  S%  S/G  PS Goals  PS Taken
 
*Shootouts (shootouts)
 
Player  Team  Pos  Home: S  G  S%  GDG  Road: S  G  S%  GDG  Total: S  G  S%  GDG
 
*Special Teams (scoringLeaders)
 
Player  Team  Pos  GP  Even: G  A  P  Power Play: G  A  P  Shorthanded: G  A  P  GW  OT
 
*Time On Ice (timeOnIce)
 
Player  Team  Pos  GP  ES TOI  ES TOI/G  SH TOI  SH TOI/G  PP TOI  PP TOI/G  TOI  TOI/G  Shifts  TOI/S  Sft/G
 
*Division Goals (divisionScoring)
 
  Player  Team  Pos  Dv GP  Dv G  Dv A   Dv P  Dv +/-  ODGP  OD G   OD A  OD P  OD+/-   TtlGP  TtlG  TtlA  TtlP  Ttl+/-
 
*Faceoffs (faceOffPercentageAll)
 
Player  Team  Pos  GP  ESFOW  ESFOL  PPFOW  PPFOL  SHFOW  SHFOL  HFOW  HFOL  HFO%  RFOW  RFOL  RFO%  FOW  FOL  Tot  FO%
 
  
Season:
+
Division Scoring (dsc)
*Regular season (gameType=2)
+
Dv GP - Division Games Played
*Playoffs (gameType=3)
+
Dv G - Division Goals
 +
Dv A - Division Assists
 +
Dv P - Division Points
 +
Dv +/- - Division Plus/Minus
 +
ODGP - Other Division Games Played
 +
OD G - Other Division Goals
 +
OD A - Other Division Assists
 +
OD P - Other Division Points
 +
OD+/- - Other Division Plus/Minus
 +
 
 +
Faceoff Percentages (fpc)
 +
ESFOW - Even Strength Faceoffs Won
 +
ESFOL - Even Strength Faceoffs Lost
 +
PPFOW - Power Play Faceoffs Won
 +
PPFOL - Power Play Faceoffs Lost
 +
SHFOW - Shorthanded Faceoffs Won
 +
SHFOL - Shorthanded Faceoffs Lost
 +
HFOW - Home Faceoffs Won
 +
HFOL - Home Faceoffs Lost
 +
HFO% - Home Faceoff Win Percentage
 +
RFOW - Road Faceoffs Won
 +
RFOL - Road Faceoffs Lost
 +
RFO% - Road Faceoff Win Percentage
 +
FOW - Total Faceoffs Won
 +
FOL - Total Faceoffs Lost
 +
Tot - Total Faceoffs Taken
 +
FO% - Faceoff Win Percentage
 +
 
 +
Goals (gls)
 +
ESG - Even Strength Goals
 +
PPG - Power Play Goals
 +
SHG - Short Handed Goals
 +
1G - First Goals
 +
OTG - Overtime Goals
 +
GWG - Game Winning Goals
 +
GTG - Game Tying Goals
 +
HmG - Home Goals
 +
RdG - Road Goals
 +
DvG - Own Division Goals
 +
ODvG - Other Division Goals
 +
ENG - Empty Net Goals
 +
PSG - Penalty Shot Goals
 +
PST - Penalty Shots Taken
 +
G/G - Average Goals Per Game
 +
 
 +
Home Scoring (hsc)
 +
GP - Home Games Played
 +
G - Home Goals
 +
A - Home Assists
 +
P - Home Points
 +
+/- - Home Plus/Minus
 +
PIM - Home Penalty Minutes
 +
Pen - Home Penalties
 +
EV TOI/g - Home Avg Even TOI/game
 +
PP TOI/g - Home Avg PP TOI/game
 +
SH TOI/g - Home Avg SH TOI/game
 +
TOI/g - Home Avg TOI/game
 +
FO - Home Faceoffs Taken
 +
FOW - Home Faceoffs Won
 +
FOL - Home Faceoffs Lost
 +
FO% - Home Faceoff Win %
 +
 
 +
Penalties (pen)
 +
Player - Player Name
 +
Team - Team
 +
Pos - Position
 +
GP - Games Played
 +
PIM - Penalty Minutes
 +
Minor - Minor Penalties
 +
Major - Major Penalties
 +
Misc - Misconduct Penalties
 +
G Misc - Game Misconduct Penalties
 +
Match - Match Penalties
 +
 
 +
Plus Or Minus (pom)
 +
Other Div +/- - Other Division Plus/Minus
 +
Team GF - Team Goals For
 +
Team PPGF - Team Powerplay Goals For
 +
Team GA - Team Goals Against
 +
Team PPGA - Team Powerplay Goals Against
 +
 
 +
Points (pnt)
 +
ESP - Even Strength Points
 +
SHP - Short Handed Points
 +
ODvP - Other Division Points
 +
P/G - Average Points Per Game
 +
 
 +
Road Scoring (rsc)
 +
GP - Road Games Played
 +
G - Road Goals
 +
A - Road Assists
 +
P - Road Points
 +
+/- - Road Plus/Minus
 +
PIM - Road Penalty Minutes
 +
Pen - Road Penalties
 +
EV TOI/g - Road Avg Even TOI/game
 +
PP TOI/g - Road Avg PP TOI/game
 +
SH TOI/g - Road Avg SH TOI/game
 +
TOI/g - Road Avg TOI/game
 +
FO - Road Faceoffs Taken
 +
FOW - Road Faceoffs Won
 +
FOL - Road Faceoffs Lost
 +
FO% - Road Faceoff Win %
 +
 
 +
Real Time Stats (rts)
 +
Hits - Hits
 +
BkS - Blocked Shots
 +
MsS - Missed Shots
 +
GvA - Giveaways
 +
TkA - Takeaways
 +
%Tm - % of Team Faceoffs Taken
 +
Shots - Shots
 +
% - Shooting Percentage
 +
 
 +
Special Teams (spc)
 +
G - Power Play Goals
 +
A - Power Play Assists
 +
P - Power Play Points
 +
 
 +
Shooting (sho)
 +
S/G - Average Shots Per Game
 +
PS Goals - Penalty Shot Goals
 +
PS Taken - Penalty Shots Taken
 +
 
 +
Shootouts (sou)
 +
Player - Player Name
 +
Team - Team
 +
Pos - Position
 +
Home: S - Home Shots
 +
G - Home Goals
 +
S% - Home Shooting Percentage
 +
GDG - Home Game-Deciding Goals
 +
Road: S - Road Shots
 +
G - Road Goals
 +
S% - Road Shooting Percentage
 +
GDG - Road Game-Deciding Goals
 +
GDG - Total Game-Deciding Goals
  
 
==Contract Data==
 
==Contract Data==

Revision as of 19:49, 16 August 2012

This page provides notes for the Winner's Curse Project with Jim Brander. Access is restricted to this page.

See also:

Player's Data

Variables

Variables are named 'view-name-prefix' followed by 'transformed NHL.com code'. The view name prefixes are three letter codes, listed in brackets next to the view names themselves. The untransformed NHL.com codes used are provided for each view name in the display box. The transformation rules are replacements as follows: % -> pc, / -> or OR / -> per (depending on context), + -> plus, - -> minus, ' ' -> , 1 -> one, and so forth.

Bios (bio)

# - Sweater Number 
Player - Player Name 
Team - Team 
Pos - Position 
DOB - Date of Birth 
Birth City - Birth City 
S/P - State/Province 
Ctry - Country 
Ht - Height in Inches 
Wt - Weight in Pounds 
S - Shoots 
Rk - Rookie 
GP - Games Played 
G - Goals 
A - Assists 
Pts - Points 
+/- - Plus/Minus 
PIM - Penalty Minutes 
TOI/G - Time On Ice Per Game 

Summary (sum)

PP - Power Play Goals 
SH - Short Handed Goals 
GW - Game Winning Goals 
GT - Game Tying Goals 
OT - Overtime Goals 
S - Shots 
S% - Shooting Percentage 
Sft/G - Average Shifts Per Game 
FO% - Faceoff Win Percentage 

Assists (ast)

ESA - Even Strength Assists 
SHA - Short Handed Assists 
PPA - Power Play Assists 
HmA - Home Assists 
RdA - Road Assists 
DvA - Own Division Assists 
ODvA - Other Division Assists 
A/G - Average Assists Per Game 

Division Scoring (dsc)

Dv GP - Division Games Played 
Dv G - Division Goals 
Dv A - Division Assists 
Dv P - Division Points 
Dv +/- - Division Plus/Minus 
ODGP - Other Division Games Played 
OD G - Other Division Goals 
OD A - Other Division Assists 
OD P - Other Division Points 
OD+/- - Other Division Plus/Minus 

Faceoff Percentages (fpc)

ESFOW - Even Strength Faceoffs Won 
ESFOL - Even Strength Faceoffs Lost 
PPFOW - Power Play Faceoffs Won 
PPFOL - Power Play Faceoffs Lost 
SHFOW - Shorthanded Faceoffs Won 
SHFOL - Shorthanded Faceoffs Lost 
HFOW - Home Faceoffs Won 
HFOL - Home Faceoffs Lost 
HFO% - Home Faceoff Win Percentage 
RFOW - Road Faceoffs Won 
RFOL - Road Faceoffs Lost 
RFO% - Road Faceoff Win Percentage 
FOW - Total Faceoffs Won 
FOL - Total Faceoffs Lost 
Tot - Total Faceoffs Taken 
FO% - Faceoff Win Percentage 

Goals (gls)

ESG - Even Strength Goals 
PPG - Power Play Goals 
SHG - Short Handed Goals 
1G - First Goals 
OTG - Overtime Goals 
GWG - Game Winning Goals 
GTG - Game Tying Goals 
HmG - Home Goals 
RdG - Road Goals 
DvG - Own Division Goals 
ODvG - Other Division Goals 
ENG - Empty Net Goals 
PSG - Penalty Shot Goals 
PST - Penalty Shots Taken 
G/G - Average Goals Per Game 

Home Scoring (hsc)

GP - Home Games Played 
G - Home Goals 
A - Home Assists 
P - Home Points 
+/- - Home Plus/Minus 
PIM - Home Penalty Minutes 
Pen - Home Penalties 
EV TOI/g - Home Avg Even TOI/game 
PP TOI/g - Home Avg PP TOI/game 
SH TOI/g - Home Avg SH TOI/game 
TOI/g - Home Avg TOI/game 
FO - Home Faceoffs Taken 
FOW - Home Faceoffs Won 
FOL - Home Faceoffs Lost 
FO% - Home Faceoff Win % 

Penalties (pen)

Player - Player Name 
Team - Team 
Pos - Position 
GP - Games Played 
PIM - Penalty Minutes 
Minor - Minor Penalties 
Major - Major Penalties 
Misc - Misconduct Penalties 
G Misc - Game Misconduct Penalties 
Match - Match Penalties 

Plus Or Minus (pom)

Other Div +/- - Other Division Plus/Minus 
Team GF - Team Goals For 
Team PPGF - Team Powerplay Goals For 
Team GA - Team Goals Against 
Team PPGA - Team Powerplay Goals Against 

Points (pnt)

ESP - Even Strength Points 
SHP - Short Handed Points 
ODvP - Other Division Points 
P/G - Average Points Per Game 

Road Scoring (rsc)

GP - Road Games Played 
G - Road Goals 
A - Road Assists 
P - Road Points 
+/- - Road Plus/Minus 
PIM - Road Penalty Minutes 
Pen - Road Penalties 
EV TOI/g - Road Avg Even TOI/game 
PP TOI/g - Road Avg PP TOI/game 
SH TOI/g - Road Avg SH TOI/game 
TOI/g - Road Avg TOI/game 
FO - Road Faceoffs Taken 
FOW - Road Faceoffs Won 
FOL - Road Faceoffs Lost 
FO% - Road Faceoff Win % 

Real Time Stats (rts)

Hits - Hits 
BkS - Blocked Shots 
MsS - Missed Shots 
GvA - Giveaways 
TkA - Takeaways 
%Tm - % of Team Faceoffs Taken 
Shots - Shots 
% - Shooting Percentage 

Special Teams (spc)

G - Power Play Goals 
A - Power Play Assists 
P - Power Play Points 

Shooting (sho)

S/G - Average Shots Per Game 
PS Goals - Penalty Shot Goals 
PS Taken - Penalty Shots Taken 

Shootouts (sou)

Player - Player Name 
Team - Team 
Pos - Position 
Home: S - Home Shots 
G - Home Goals 
S% - Home Shooting Percentage 
GDG - Home Game-Deciding Goals 
Road: S - Road Shots 
G - Road Goals 
S% - Road Shooting Percentage 
GDG - Road Game-Deciding Goals 
GDG - Total Game-Deciding Goals

Contract Data

The contract data will be taken from http://www.CapGeek.com

Using Player IDs:

The player name is in a page level 1 header, followed by position and team name (which is hyperlinked) in the page level 2 header.

We want the Contract History. Specifically, the header data, then the following section data. We should also take the known clauses...

There is a bug in the script tha leads to contamination in the data. This can be removed with s/.*CONTRACT DETAILS.*\n//;

Buyout data

All known (to capgeek) buyouts are listed on the page http://www.capgeek.com/buyouts.php

Arbitration data

All I have so far is:

And some articles/blog posts: