-
Notifications
You must be signed in to change notification settings - Fork 166
/
schema.Rmd
120 lines (94 loc) · 5.58 KB
/
schema.Rmd
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
---
output: github_document
---
<!-- README.md is generated from README.Rmd. Please edit that file -->
```{r, echo = FALSE}
knitr::opts_chunk$set(
collapse = TRUE,
comment = "#>",
fig.path = "man/figures/README-"
)
```
## Summary of data
Here, you'll find a summary of each data set in the 2019 Data Bowl, a list of *key* variables to join on, and a description of each variable.
## File descriptions
Game data: The `games.csv` file contains game-level information for each game from the first 6 weeks of the 2017 season. The *key* variable is **`gameId`**.
Play data: The `plays.csv` file contains play-level information from each game from the first 6 weeks of the 2017 season. The *key* variables are **`gameId`** and **`playId`**.
Player data: The `players.csv` file contains player-level information from players that participated in at least one play during the first six weeks of the 2017 regular season. The *key* variable is **`nflId`**.
Tracking data: Files `tracking_gameId_[gameId].csv` contain player tracking data from game `[gameId]`. Nearly all plays from `[gameId]` are included; certain plays with incomplete or missing data are dropped. The *key* variables are **`gameId`**, **`playId`**, and **`nflId`**.
## Game data
- `season`: Season of game (numeric)
- `week`: Week of game, 1 through 6 (numeric)
- `gameDate`: Game Date (time, mm/dd/yyyy)
- **`gameId`**: Game identifier, unique (numeric)
- `gameTimeEastern`: Start time of game (time, HH:MM:SS, EST)
- `HomeScore`: Final score for the home team (numeric)
- `VisitorScore`: Final score for the away team (numeric)
- `homeTeamAbbr`: Home team three-letter code (text)
- `visitorTeamAbbr`: Visiting team three-letter code (text)
- `homeDisplayName`: Home team name (text)
- `visitorDisplayName`: Visiting team name (text)
- `Stadium`: Stadium (text)
- `Location`: City (text)
- `StadiumType`: Type of stadium (text)
- `Turf`: Surface of stadium (text)
- `GameLength`: Time the game took to complete (time, HH:MM:SS)
- `GameWeather`: Game weather (text)
- `Temperature`: Temperature in Fahrenheit, drawn roughly at the start of the game (numeric)
- `Humidity`: Humidity (numeric)
- `WindSpeed`: Wind speed, in miles-per-hour (numeric)
- `WindDirection`: Direction of wind (text)
## Play data
- **`gameId`**: Game identifier, unique (numeric)
- **`playId`**: Play identifier, not unique across games (numeric)
- `quarter`: Game quarter (numeric)
- `GameClock`: Time on game clock at start of play (time, counting down from 15:00, MM:SS)
- `down`: Down (numeric)
- `yardsToGo`: Distance needed for a first down (numeric)
- `yardlineSide`: 3-letter team code corresponding to line-of-scrimmage (text)
- `yardlineNumber`: Yard line at line-of-scrimmage (numeric)
- `personnel.offense`: Personnel used by offensive team (text)
- `defendersInTheBox`: Number of defenders in close proximity to line-of-scrimmage (numeric)
- `numberOfPassRushers`: Number of pass rushers (numeric)
- `personnel.defense`: Personnel used by defensive team (text)
- `HomeScoreBeforePlay`: Home score prior to the play (numeric)
- `VisitorScoreBeforePlay`: Visiting team points at the end of the play (numeric)
- `HomeScoreAfterPlay`: Home team points at the end of the play (numeric)
- `VisitorScoreAfterPlay`: Humidity (numeric)
- `isPenalty`: Wind speed (numeric)
- `isSTPlay`: TRUE/FALSE for whether or not the play is labelled a special teams play (binary)
- `SpecialTeamsPlayType`: Type of play if `isSTPlay == TRUE` (text)
- `KickReturnYardage`: Return yardage among special teams plays (numeric)
- `PassLength`: Pass length, in yards (numeric)
- `PassResult`: Result of pass play (text, `C`: caught, `I`: incomplete, `IN`: intercepted, `R`: run, `S`: sack)
- `YardsAfterCatch`: Yardage receiver gained after a pass completion (numeric)
- `PlayResult`: Result of play, in yards (numeric)
- `playDescription`: Description of play (text)
## Player data
- **`nflId`**: Player identification number, unique across players (numeric)
- `FirstName`: First name of player (text)
- `LastName`: Last name of player (text)
- `PositionAbbr`: Position of player (text)
- `EntryYear`: Year in which player entered NFL (numeric)
- `DraftRound`: Round in which player was drafted --`NULL` for players not drafted (numeric)
- `DraftNumber`: Overall pick number among drafted players (numeric)
- `Height`: Player height in feet/inches (text)
- `Weight`: Player weight in pounds (numeric)
- `College`: Player college (text)
## Tracking data
Files `tracking_gameId_[gameId].csv` contains player tracking data from game `[gameId]`. Nearly all plays from `[gameId]` are included; certain plays with insufficient data are dropped.
- `time`: Time stamp of play (time, yyyy-mm-dd, hh:mm:ss)
- `x`: Player position along the long axis of the field, 0 - 120 yards. See Figure 1 below. (numeric)
- `y`: Player position along the short axis of the field, 0 - 53.3 yards. See Figure 1 below. (numeric)
- `s`: Speed in yards/second (numeric)
- `dis`: Distance traveled from prior time point, in yards (numeric)
- `dir`: Angle of player motion (deg), 0 - 360 degrees (numeric)
- `event`: Tagged play details, including moment of ball snap, pass release, pass catch, tackle, etc (text)
- **`nflId`**: Player identification number, unique across players (numeric)
- `displayName`: Player name (text)
- `jerseyNumber`: Jersey number of player (numeric)
- `team`: Team (away or home) of corresponding player (text)
- `frame.id`: Frame identifier for each play, starting at 1 (numeric)
- **`gameId`**: Game identifier, unique (numeric)
- **`playId`**: Play identifier, not unique across games (numeric)
<img src="Extras/Fig1.PNG" align="right" />