Database Information
Database things.
| Column | Description |
|---|---|
| season | Season of game. For the upcoming 2015-2016 season, this value would be 20152016. |
| gcode | 20001-21230 for regular season. 30XXX for playoffs: round, series, game. This ID is assigned via NHL.com |
| refdate | number of days since January 1, 2001 (obsolete) |
| event | numbered event in the game. For each game, this resets to 1. |
| period | Period #. In regular season: 1-3 for Periods 1-3. Overtime is period 4. The shootout is period 5. In playoffs, 1OT is 4, 2OT is 5, etc. |
| seconds | time on the clock, in seconds. The start of the first period is 0. End of the third period is 3,600. |
| etype | Event classification. This will be one of the event types here |
| a1 | away player 1 |
| a2 | away player 2 |
| a3 | away player 3 |
| a4 | away player 4 |
| a5 | away player 5 |
| a6 | away player 6 |
| h1 | home player 1 |
| h2 | home player 2 |
| h3 | home player 3 |
| h4 | home player 4 |
| h5 | home player 5 |
| h6 | home player 6 |
| ev.team | which team is registered for the event. See below for how this should be interpreted. |
| ev.player.1 | Player 1 of event. See below |
| ev.player.2 | Player 2 of event. See below |
| ev.player.3 | Player 3 of event. See below |
| distance | Original distance from net, as recorded by RTSS |
| type | Further description of event. See below |
| homezone | What zone the event happened in, relative to the home team. Will be one of Neu: Neutral, Off: Offensive zone, Unk: Unknown zone, Def: Defensive zone |
| xcoord | Original x coordinate as recorded by RTSS. This value is in feet relative to the center ice faceoff dot. Goals are at (89,0) and (-89,0) |
| ycoord | Original y coordinate as recorded by RTSS. |
| awayteam | Away team for event |
| hometeam | Home team for event |
| home.score | Home score, at time of event. So, if this event was the first GOAL for the home team, the score would still be 0. The subsequent event would have a score of 1. |
| away.score | Away score, at time of event. |
| event.length | Duration of the current event, relative to last recorded event. |
| away.G | Away goaltender |
| home.G | Home goaltender |
| home.skaters | Total players on ice for home team, including goaltender |
| away.skaters | Total players on ice for away team, including goaltender |
| adjusted.distance | corrected distance, after rink adjustment |
| shot.feature | Designates if shot was a rebound (reb) or rush (rush) as well as detail on event (shot/miss/bloack, or previous zone), and time since previous event occurred. Example: A value of "blockreb3" would indicate that the shot was a rebound which occurred 3 seconds after a blocked shot. |
| import.ies | Where data came from. 0=NHL, 1=imputed, 2=ESPN, 3=Spotsnet |
| loc.section | Area of the offensive zone where the event happened, using original RTSS coordinates. See below. |
| new.loc.section | Area of the offensive zone where the event happened, using corrected coordinatesSee below. |
| newxc | corrected x-coordinate |
| newyc | corrected y-coordinate |
| score.diff.cat | See below. |
| subdistance | deprecated, used for imputing missing locations |
| etype | description | eteam | ev.player.1 | ev.player.2 | ev.player.3 | type |
|---|---|---|---|---|---|---|
| FAC | Faceoff | ? | Faceoff winner | Faceoff loser | ||
| HIT | Hit | ? | Hitter | Who got hit | ||
| SHOT | Shot | Team taking shot | Shooter | Wrist, Snap, Slap, Backhand, Tip-In, Wrap, Deflected, or Unspecified | ||
| STOP | Stop | |||||
| CHANGE | Change | |||||
| BLOCK | Block | Team taking shot | Shooter | Shot blocker | Wrist, Snap, Slap, Backhand, Tip-In, Wrap, Deflected, or Unspecified | |
| GIVE | Giveaway | |||||
| MISS | Miss | Team taking shot | Shooter | Wrist, Snap, Slap, Backhand, Tip-In, Wrap, Deflected, or Unspecified | ||
| GOAL | Goal! | Team scoring goal | Goal scorer | Assist 1 | Assist 2 | Wrist, Snap, Slap, Backhand, Tip-In, Wrap, Deflected, or Unspecified |
| TAKE | Takeaway | ? | ||||
| PEND | ? | |||||
| PENL | Penalty | Team receiving penalty | Penalty taker | Penalty drawer | Penalty description | |
| SOC | ||||||
| GOFF |
| score.diff.cat | score situation |
|---|---|
| 0 | away lead by 3+ |
| 1 | away lead by 2 |
| 2 | away lead by 1 |
| 3 | tied |
| 4 | home lead by 1 |
| 5 | home lead by 2 |
| 6 | home lead by 3+ |
Danger 1 = Low danger, 2 = Medium danger, 3 = High danger
Here is an image which depicts these sections:
| loc.section | from shooter perspective | danger |
|---|---|---|
| 0 | (missing) | 0 |
| 1 | right point | 1 |
| 2 | "Center point" | 1 |
| 3 | left point | 1 |
| 4 | R-1 | 1 |
| 5 | R-2 | 2 |
| 6 | high slot | 2 |
| 7 | L-2 | 2 |
| 8 | L-1 | 1 |
| 9 | R-Low | 1 |
| 10 | R-Slot | 2 |
| 11 | Slot | 3 |
| 12 | LowSlot | 3 |
| 13 | L-Slot | 2 |
| 14 | L-Low | 1 |
| 15 | DownLow | 1 |
| 16 | Out of zone | 1 |