Changes
Jump to navigation
Jump to search
no edit summary
See also:
*[[The Winner's Curse Literature Review]]
==Data==
The two primary datasets are:
*The CapGeek data
*The NHL.com data
===CapGeek Data===
All contract data was be taken from http://www.CapGeek.com by a custom web-crawler. This includes all '''known''' (to capgeek) buyouts: http://www.capgeek.com/buyouts.php. Data was retrieved using player ID's, which are unique, start at 11, and end at 2352 (assigned to Biggs, Taylor, who signed a new entry level contract on 8/9 at 19:46. See http://www.capgeek.com/latest_contracts.php and look for the highest entry for an new signing.) Not all ID's exist.
Data retrieved includes:
*The player name (in the page level 1 header)
*The player's position and team name (in the page level 2 header)
*The full contract history. Notes on contracts (i.e. known clauses) are included in the dbase but not the STATA export.
CapGeek provides contract data on 2241 players, of which 1459 appear in the NHL statistics data, who held contracts from 2001 to the present day. 194 capgeek players have teams marked as 'Inactive', and these invariably do not appear in the NHL data. The missing capgeek players presumably play in the minors.
===NHL Data===
The NHL data was retrieved from NHL.com using a custom webcrawler. The data covers the years 1997-present, except for the 2004-2005 season (which was a lockout). Data was retrieved seperately for skaters and goalies. We have data on all 2870 NHL players that have stats recorded on NHL.com in the final dataset.
====Joining to CapGeek====
NHL.com does not provide unique player identifiers. These were created using player names and dates of birth. Players were matched to CapGeek using their names, and when names were non-unique matches were established manually by checking birth dates, teams and positions in both sources. Birth-date - player-name dyads were found to be unique. For a small percentage of players (approximately 45/1459) their names were recorded differently in each source. Fuzzy-matching software provided potential candidate matches and all matches were checked by hand.
Of the 2870 NHL players with statistics, we have CapGeek contract records for 1459 (51%). Part of the discrepancy is due to retirement. 442 players played their last game before 2001 and do not have CapGeek records. This leaves 969 (34%) of the NHL players that do not have contracts in CapGeek for some other reason - most likely that CapGeek's coverage is incomplete.
==Variables==
*bamount - the amount of the buyout
Note that if a player played for the Atlanta Thrashers and the Winnipeg Jets, this counts as the same team.
===Player's Data===
