Data Dictionary - PBP (original) (raw)
play_id
Numeric play id that when used with game_id and drive provides the unique identifier for a single play.
numeric
game_id
Ten digit identifier for NFL game.
character
old_game_id
Legacy NFL game ID.
character
home_team
String abbreviation for the home team.
character
away_team
String abbreviation for the away team.
character
season_type
‘REG’ or ‘POST’ indicating if the game belongs to regular or post season.
character
week
Season week.
numeric
posteam
String abbreviation for the team with possession.
character
posteam_type
String indicating whether the posteam team is home or away.
character
defteam
String abbreviation for the team on defense.
character
side_of_field
String abbreviation for which team’s side of the field the team with possession is currently on.
character
yardline_100
Numeric distance in the number of yards from the opponent’s endzone for the posteam.
numeric
game_date
Date of the game.
character
quarter_seconds_remaining
Numeric seconds remaining in the quarter.
numeric
half_seconds_remaining
Numeric seconds remaining in the half.
numeric
game_seconds_remaining
Numeric seconds remaining in the game.
numeric
game_half
String indicating which half the play is in, either Half1, Half2, or Overtime.
character
quarter_end
Binary indicator for whether or not the row of the data is marking the end of a quarter.
numeric
drive
Numeric drive number in the game.
numeric
sp
Binary indicator for whether or not a score occurred on the play.
numeric
qtr
Quarter of the game (5 is overtime).
numeric
down
The down for the given play.
numeric
goal_to_go
Binary indicator for whether or not the posteam is in a goal down situation.
numeric
time
Time at start of play provided in string format as minutes:seconds remaining in the quarter.
character
yrdln
String indicating the current field position for a given play.
character
ydstogo
Numeric yards in distance from either the first down marker or the endzone in goal down situations.
numeric
ydsnet
Numeric value for total yards gained on the given drive.
numeric
desc
Detailed string description for the given play.
character
play_type
String indicating the type of play: pass (includes sacks), run (includes scrambles), punt, field_goal, kickoff, extra_point, qb_kneel, qb_spike, no_play (timeouts and penalties), and missing for rows indicating end of play.
character
yards_gained
Numeric yards gained (or lost) by the possessing team, excluding yards gained via fumble recoveries and laterals.
numeric
shotgun
Binary indicator for whether or not the play was in shotgun formation.
numeric
no_huddle
Binary indicator for whether or not the play was in no_huddle formation.
numeric
qb_dropback
Binary indicator for whether or not the QB dropped back on the play (pass attempt, sack, or scrambled).
numeric
qb_kneel
Binary indicator for whether or not the QB took a knee.
numeric
qb_spike
Binary indicator for whether or not the QB spiked the ball.
numeric
qb_scramble
Binary indicator for whether or not the QB scrambled.
numeric
pass_length
String indicator for pass length: short or deep.
character
pass_location
String indicator for pass location: left, middle, or right.
character
air_yards
Numeric value for distance in yards perpendicular to the line of scrimmage at where the targeted receiver either caught or didn’t catch the ball.
numeric
yards_after_catch
Numeric value for distance in yards perpendicular to the yard line where the receiver made the reception to where the play ended.
numeric
run_location
String indicator for location of run: left, middle, or right.
character
run_gap
String indicator for line gap of run: end, guard, or tackle
character
field_goal_result
String indicator for result of field goal attempt: made, missed, or blocked.
character
kick_distance
Numeric distance in yards for kickoffs, field goals, and punts.
numeric
extra_point_result
String indicator for the result of the extra point attempt: good, failed, blocked, safety (touchback in defensive endzone is 1 point apparently), or aborted.
character
two_point_conv_result
String indicator for result of two point conversion attempt: success, failure, safety (touchback in defensive endzone is 1 point apparently), or return.
character
home_timeouts_remaining
Numeric timeouts remaining in the half for the home team.
numeric
away_timeouts_remaining
Numeric timeouts remaining in the half for the away team.
numeric
timeout
Binary indicator for whether or not a timeout was called by either team.
numeric
timeout_team
String abbreviation for which team called the timeout.
character
td_team
String abbreviation for which team scored the touchdown.
character
td_player_name
String name of the player who scored a touchdown.
character
td_player_id
Unique identifier of the player who scored a touchdown.
character
posteam_timeouts_remaining
Number of timeouts remaining for the possession team.
numeric
defteam_timeouts_remaining
Number of timeouts remaining for the team on defense.
numeric
total_home_score
Score for the home team at the start of the play.
numeric
total_away_score
Score for the away team at the start of the play.
numeric
posteam_score
Score the posteam at the start of the play.
numeric
defteam_score
Score the defteam at the start of the play.
numeric
score_differential
Score differential between the posteam and defteam at the start of the play.
numeric
posteam_score_post
Score for the posteam at the end of the play.
numeric
defteam_score_post
Score for the defteam at the end of the play.
numeric
score_differential_post
Score differential between the posteam and defteam at the end of the play.
numeric
no_score_prob
Predicted probability of no score occurring for the rest of the half based on the expected points model.
numeric
opp_fg_prob
Predicted probability of the defteam scoring a FG next. ‘Next’ in this context means the next score in the same game half.
numeric
opp_safety_prob
Predicted probability of the defteam scoring a safety next. ‘Next’ in this context means the next score in the same game half.
numeric
opp_td_prob
Predicted probability of the defteam scoring a TD next. ‘Next’ in this context means the next score in the same game half.
numeric
fg_prob
Predicted probability of the posteam scoring a FG next. ‘Next’ in this context means the next score in the same game half.
numeric
safety_prob
Predicted probability of the posteam scoring a safety next. ‘Next’ in this context means the next score in the same game half.
numeric
td_prob
Predicted probability of the posteam scoring a TD next. ‘Next’ in this context means the next score in the same game half.
numeric
extra_point_prob
Predicted probability of the posteam scoring an extra point.
numeric
two_point_conversion_prob
Predicted probability of the posteam scoring the two point conversion.
numeric
ep
Using the scoring event probabilities, the estimated expected points with respect to the possession team for the given play.
numeric
epa
Expected points added (EPA) by the posteam for the given play.
numeric
total_home_epa
Cumulative total EPA for the home team in the game so far.
numeric
total_away_epa
Cumulative total EPA for the away team in the game so far.
numeric
total_home_rush_epa
Cumulative total rushing EPA for the home team in the game so far.
numeric
total_away_rush_epa
Cumulative total rushing EPA for the away team in the game so far.
numeric
total_home_pass_epa
Cumulative total passing EPA for the home team in the game so far.
numeric
total_away_pass_epa
Cumulative total passing EPA for the away team in the game so far.
numeric
air_epa
EPA from the air yards alone. For completions this represents the actual value provided through the air. For incompletions this represents the hypothetical value that could’ve been added through the air if the pass was completed.
numeric
yac_epa
EPA from the yards after catch alone. For completions this represents the actual value provided after the catch. For incompletions this represents the difference between the hypothetical air_epa and the play’s raw observed EPA (how much the incomplete pass cost the posteam).
numeric
comp_air_epa
EPA from the air yards alone only for completions.
numeric
comp_yac_epa
EPA from the yards after catch alone only for completions.
numeric
total_home_comp_air_epa
Cumulative total completions air EPA for the home team in the game so far.
numeric
total_away_comp_air_epa
Cumulative total completions air EPA for the away team in the game so far.
numeric
total_home_comp_yac_epa
Cumulative total completions yac EPA for the home team in the game so far.
numeric
total_away_comp_yac_epa
Cumulative total completions yac EPA for the away team in the game so far.
numeric
total_home_raw_air_epa
Cumulative total raw air EPA for the home team in the game so far.
numeric
total_away_raw_air_epa
Cumulative total raw air EPA for the away team in the game so far.
numeric
total_home_raw_yac_epa
Cumulative total raw yac EPA for the home team in the game so far.
numeric
total_away_raw_yac_epa
Cumulative total raw yac EPA for the away team in the game so far.
numeric
wp
Estimated win probabiity for the posteam given the current situation at the start of the given play.
numeric
def_wp
Estimated win probability for the defteam.
numeric
home_wp
Estimated win probability for the home team.
numeric
away_wp
Estimated win probability for the away team.
numeric
wpa
Win probability added (WPA) for the posteam.
numeric
vegas_wpa
Win probability added (WPA) for the posteam: spread_adjusted model.
numeric
vegas_home_wpa
Win probability added (WPA) for the home team: spread_adjusted model.
numeric
home_wp_post
Estimated win probability for the home team at the end of the play.
numeric
away_wp_post
Estimated win probability for the away team at the end of the play.
numeric
vegas_wp
Estimated win probabiity for the posteam given the current situation at the start of the given play, incorporating pre-game Vegas line.
numeric
vegas_home_wp
Estimated win probability for the home team incorporating pre-game Vegas line.
numeric
total_home_rush_wpa
Cumulative total rushing WPA for the home team in the game so far.
numeric
total_away_rush_wpa
Cumulative total rushing WPA for the away team in the game so far.
numeric
total_home_pass_wpa
Cumulative total passing WPA for the home team in the game so far.
numeric
total_away_pass_wpa
Cumulative total passing WPA for the away team in the game so far.
numeric
air_wpa
WPA through the air (same logic as air_epa).
numeric
yac_wpa
WPA from yards after the catch (same logic as yac_epa).
numeric
comp_air_wpa
The air_wpa for completions only.
numeric
comp_yac_wpa
The yac_wpa for completions only.
numeric
total_home_comp_air_wpa
Cumulative total completions air WPA for the home team in the game so far.
numeric
total_away_comp_air_wpa
Cumulative total completions air WPA for the away team in the game so far.
numeric
total_home_comp_yac_wpa
Cumulative total completions yac WPA for the home team in the game so far.
numeric
total_away_comp_yac_wpa
Cumulative total completions yac WPA for the away team in the game so far.
numeric
total_home_raw_air_wpa
Cumulative total raw air WPA for the home team in the game so far.
numeric
total_away_raw_air_wpa
Cumulative total raw air WPA for the away team in the game so far.
numeric
total_home_raw_yac_wpa
Cumulative total raw yac WPA for the home team in the game so far.
numeric
total_away_raw_yac_wpa
Cumulative total raw yac WPA for the away team in the game so far.
numeric
punt_blocked
Binary indicator for if the punt was blocked.
numeric
first_down_rush
Binary indicator for if a running play converted the first down.
numeric
first_down_pass
Binary indicator for if a passing play converted the first down.
numeric
first_down_penalty
Binary indicator for if a penalty converted the first down.
numeric
third_down_converted
Binary indicator for if the first down was converted on third down.
numeric
third_down_failed
Binary indicator for if the posteam failed to convert first down on third down.
numeric
fourth_down_converted
Binary indicator for if the first down was converted on fourth down.
numeric
fourth_down_failed
Binary indicator for if the posteam failed to convert first down on fourth down.
numeric
incomplete_pass
Binary indicator for if the pass was incomplete.
numeric
touchback
Binary indicator for if a touchback occurred on the play.
numeric
interception
Binary indicator for if the pass was intercepted.
numeric
punt_inside_twenty
Binary indicator for if the punt ended inside the twenty yard line.
numeric
punt_in_endzone
Binary indicator for if the punt was in the endzone.
numeric
punt_out_of_bounds
Binary indicator for if the punt went out of bounds.
numeric
punt_downed
Binary indicator for if the punt was downed.
numeric
punt_fair_catch
Binary indicator for if the punt was caught with a fair catch.
numeric
kickoff_inside_twenty
Binary indicator for if the kickoff ended inside the twenty yard line.
numeric
kickoff_in_endzone
Binary indicator for if the kickoff was in the endzone.
numeric
kickoff_out_of_bounds
Binary indicator for if the kickoff went out of bounds.
numeric
kickoff_downed
Binary indicator for if the kickoff was downed.
numeric
kickoff_fair_catch
Binary indicator for if the kickoff was caught with a fair catch.
numeric
fumble_forced
Binary indicator for if the fumble was forced.
numeric
fumble_not_forced
Binary indicator for if the fumble was not forced.
numeric
fumble_out_of_bounds
Binary indicator for if the fumble went out of bounds.
numeric
solo_tackle
Binary indicator if the play had a solo tackle (could be multiple due to fumbles).
numeric
safety
Binary indicator for whether or not a safety occurred.
numeric
penalty
Binary indicator for whether or not a penalty occurred.
numeric
tackled_for_loss
Binary indicator for whether or not a tackle for loss on a run play occurred.
numeric
fumble_lost
Binary indicator for if the fumble was lost.
numeric
own_kickoff_recovery
Binary indicator for if the kicking team recovered the kickoff.
numeric
own_kickoff_recovery_td
Binary indicator for if the kicking team recovered the kickoff and scored a TD.
numeric
qb_hit
Binary indicator if the QB was hit on the play.
numeric
rush_attempt
Binary indicator for if the play was a run.
numeric
pass_attempt
Binary indicator for if the play was a pass attempt (includes sacks).
numeric
sack
Binary indicator for if the play ended in a sack.
numeric
touchdown
Binary indicator for if the play resulted in a TD.
numeric
pass_touchdown
Binary indicator for if the play resulted in a passing TD.
numeric
rush_touchdown
Binary indicator for if the play resulted in a rushing TD.
numeric
return_touchdown
Binary indicator for if the play resulted in a return TD. Returns may occur on any of: interception, fumble, kickoff, punt, or blocked kicks.
numeric
extra_point_attempt
Binary indicator for extra point attempt.
numeric
two_point_attempt
Binary indicator for two point conversion attempt.
numeric
field_goal_attempt
Binary indicator for field goal attempt.
numeric
kickoff_attempt
Binary indicator for kickoff.
numeric
punt_attempt
Binary indicator for punts.
numeric
fumble
Binary indicator for if a fumble occurred.
numeric
complete_pass
Binary indicator for if the pass was completed.
numeric
assist_tackle
Binary indicator for if an assist tackle occurred.
numeric
lateral_reception
Binary indicator for if a lateral occurred on the reception.
numeric
lateral_rush
Binary indicator for if a lateral occurred on a run.
numeric
lateral_return
Binary indicator for if a lateral occurred on a return. Returns may occur on any of: interception, fumble, kickoff, punt, or blocked kicks.
numeric
lateral_recovery
Binary indicator for if a lateral occurred on a fumble recovery.
numeric
passer_player_id
Unique identifier for the player that attempted the pass.
character
passer_player_name
String name for the player that attempted the pass.
character
passing_yards
Numeric yards by the passer_player_name, including yards gained in pass plays with laterals. This should equal official passing statistics.
numeric
receiver_player_id
Unique identifier for the receiver that was targeted on the pass.
character
receiver_player_name
String name for the targeted receiver.
character
receiving_yards
Numeric yards by the receiver_player_name, excluding yards gained in pass plays with laterals. This should equal official receiving statistics but could miss yards gained in pass plays with laterals. Please see the description oflateral_receiver_player_name for further information.
numeric
rusher_player_id
Unique identifier for the player that attempted the run.
character
rusher_player_name
String name for the player that attempted the run.
character
rushing_yards
Numeric yards by the rusher_player_name, excluding yards gained in rush plays with laterals. This should equal official rushing statistics but could miss yards gained in rush plays with laterals. Please see the description oflateral_rusher_player_name for further information.
numeric
lateral_receiver_player_id
Unique identifier for the player that received the last(!) lateral on a pass play.
character
lateral_receiver_player_name
String name for the player that received the last(!) lateral on a pass play. If there were multiple laterals in the same play, this will only be the last player who received a lateral. Please see https://github.com/mrcaseb/nfl-data/tree/master/data/lateral_yardsfor a list of plays where multiple players recorded lateral receiving yards.
character
lateral_receiving_yards
Numeric yards by thelateral_receiver_player_name in pass plays with laterals. Please see the description of lateral_receiver_player_namefor further information.
numeric
lateral_rusher_player_id
Unique identifier for the player that received the last(!) lateral on a run play.
character
lateral_rusher_player_name
String name for the player that received the last(!) lateral on a run play. If there were multiple laterals in the same play, this will only be the last player who received a lateral. Please see https://github.com/mrcaseb/nfl-data/tree/master/data/lateral_yardsfor a list of plays where multiple players recorded lateral rushing yards.
character
lateral_rushing_yards
Numeric yards by thelateral_rusher_player_name in run plays with laterals. Please see the description of lateral_rusher_player_namefor further information.
numeric
lateral_sack_player_id
Unique identifier for the player that received the lateral on a sack.
character
lateral_sack_player_name
String name for the player that received the lateral on a sack.
character
interception_player_id
Unique identifier for the player that intercepted the pass.
character
interception_player_name
String name for the player that intercepted the pass.
character
lateral_interception_player_id
Unique indentifier for the player that received the lateral on an interception.
character
lateral_interception_player_name
String name for the player that received the lateral on an interception.
character
punt_returner_player_id
Unique identifier for the punt returner.
character
punt_returner_player_name
String name for the punt returner.
character
lateral_punt_returner_player_id
Unique identifier for the player that received the lateral on a punt return.
character
lateral_punt_returner_player_name
String name for the player that received the lateral on a punt return.
character
kickoff_returner_player_name
String name for the kickoff returner.
character
kickoff_returner_player_id
Unique identifier for the kickoff returner.
character
lateral_kickoff_returner_player_id
Unique identifier for the player that received the lateral on a kickoff return.
character
lateral_kickoff_returner_player_name
String name for the player that received the lateral on a kickoff return.
character
punter_player_id
Unique identifier for the punter.
character
punter_player_name
String name for the punter.
character
kicker_player_name
String name for the kicker on FG or kickoff.
character
kicker_player_id
Unique identifier for the kicker on FG or kickoff.
character
own_kickoff_recovery_player_id
Unique identifier for the player that recovered their own kickoff.
character
own_kickoff_recovery_player_name
String name for the player that recovered their own kickoff.
character
blocked_player_id
Unique identifier for the player that blocked the punt or FG.
character
blocked_player_name
String name for the player that blocked the punt or FG.
character
tackle_for_loss_1_player_id
Unique identifier for one of the potential players with the tackle for loss.
character
tackle_for_loss_1_player_name
String name for one of the potential players with the tackle for loss.
character
tackle_for_loss_2_player_id
Unique identifier for one of the potential players with the tackle for loss.
character
tackle_for_loss_2_player_name
String name for one of the potential players with the tackle for loss.
character
qb_hit_1_player_id
Unique identifier for one of the potential players that hit the QB. No sack as the QB was not the ball carrier. For sacks please see sack_player or half_sack_*_player.
character
qb_hit_1_player_name
String name for one of the potential players that hit the QB. No sack as the QB was not the ball carrier. For sacks please seesack_player or half_sack_*_player.
character
qb_hit_2_player_id
Unique identifier for one of the potential players that hit the QB. No sack as the QB was not the ball carrier. For sacks please see sack_player or half_sack_*_player.
character
qb_hit_2_player_name
String name for one of the potential players that hit the QB. No sack as the QB was not the ball carrier. For sacks please seesack_player or half_sack_*_player.
character
forced_fumble_player_1_team
Team of one of the players with a forced fumble.
character
forced_fumble_player_1_player_id
Unique identifier of one of the players with a forced fumble.
character
forced_fumble_player_1_player_name
String name of one of the players with a forced fumble.
character
forced_fumble_player_2_team
Team of one of the players with a forced fumble.
character
forced_fumble_player_2_player_id
Unique identifier of one of the players with a forced fumble.
character
forced_fumble_player_2_player_name
String name of one of the players with a forced fumble.
character
solo_tackle_1_team
Team of one of the players with a solo tackle.
character
solo_tackle_2_team
Team of one of the players with a solo tackle.
character
solo_tackle_1_player_id
Unique identifier of one of the players with a solo tackle.
character
solo_tackle_2_player_id
Unique identifier of one of the players with a solo tackle.
character
solo_tackle_1_player_name
String name of one of the players with a solo tackle.
character
solo_tackle_2_player_name
String name of one of the players with a solo tackle.
character
assist_tackle_1_player_id
Unique identifier of one of the players with a tackle assist.
character
assist_tackle_1_player_name
String name of one of the players with a tackle assist.
character
assist_tackle_1_team
Team of one of the players with a tackle assist.
character
assist_tackle_2_player_id
Unique identifier of one of the players with a tackle assist.
character
assist_tackle_2_player_name
String name of one of the players with a tackle assist.
character
assist_tackle_2_team
Team of one of the players with a tackle assist.
character
assist_tackle_3_player_id
Unique identifier of one of the players with a tackle assist.
character
assist_tackle_3_player_name
String name of one of the players with a tackle assist.
character
assist_tackle_3_team
Team of one of the players with a tackle assist.
character
assist_tackle_4_player_id
Unique identifier of one of the players with a tackle assist.
character
assist_tackle_4_player_name
String name of one of the players with a tackle assist.
character
assist_tackle_4_team
Team of one of the players with a tackle assist.
character
tackle_with_assist
Binary indicator for if there has been a tackle with assist.
numeric
tackle_with_assist_1_player_id
Unique identifier of one of the players with a tackle with assist.
character
tackle_with_assist_1_player_name
String name of one of the players with a tackle with assist.
character
tackle_with_assist_1_team
Team of one of the players with a tackle with assist.
character
tackle_with_assist_2_player_id
Unique identifier of one of the players with a tackle with assist.
character
tackle_with_assist_2_player_name
String name of one of the players with a tackle with assist.
character
tackle_with_assist_2_team
Team of one of the players with a tackle with assist.
character
pass_defense_1_player_id
Unique identifier of one of the players with a pass defense.
character
pass_defense_1_player_name
String name of one of the players with a pass defense.
character
pass_defense_2_player_id
Unique identifier of one of the players with a pass defense.
character
pass_defense_2_player_name
String name of one of the players with a pass defense.
character
fumbled_1_team
Team of one of the first player with a fumble.
character
fumbled_1_player_id
Unique identifier of the first player who fumbled on the play.
character
fumbled_1_player_name
String name of one of the first player who fumbled on the play.
character
fumbled_2_player_id
Unique identifier of the second player who fumbled on the play.
character
fumbled_2_player_name
String name of one of the second player who fumbled on the play.
character
fumbled_2_team
Team of one of the second player with a fumble.
character
fumble_recovery_1_team
Team of one of the players with a fumble recovery.
character
fumble_recovery_1_yards
Yards gained by one of the players with a fumble recovery.
numeric
fumble_recovery_1_player_id
Unique identifier of one of the players with a fumble recovery.
character
fumble_recovery_1_player_name
String name of one of the players with a fumble recovery.
character
fumble_recovery_2_team
Team of one of the players with a fumble recovery.
character
fumble_recovery_2_yards
Yards gained by one of the players with a fumble recovery.
numeric
fumble_recovery_2_player_id
Unique identifier of one of the players with a fumble recovery.
character
fumble_recovery_2_player_name
String name of one of the players with a fumble recovery.
character
sack_player_id
Unique identifier of the player who recorded a solo sack.
character
sack_player_name
String name of the player who recorded a solo sack.
character
half_sack_1_player_id
Unique identifier of the first player who recorded half a sack.
character
half_sack_1_player_name
String name of the first player who recorded half a sack.
character
half_sack_2_player_id
Unique identifier of the second player who recorded half a sack.
character
half_sack_2_player_name
String name of the second player who recorded half a sack.
character
return_team
String abbreviation of the return team. Returns may occur on any of: interception, fumble, kickoff, punt, or blocked kicks.
character
return_yards
Yards gained by the return team. Returns may occur on any of: interception, fumble, kickoff, punt, or blocked kicks.
numeric
penalty_team
String abbreviation of the team with the penalty.
character
penalty_player_id
Unique identifier for the player with the penalty.
character
penalty_player_name
String name for the player with the penalty.
character
penalty_yards
Yards gained (or lost) by the posteam from the penalty.
numeric
replay_or_challenge
Binary indicator for whether or not a replay or challenge.
numeric
replay_or_challenge_result
String indicating the result of the replay or challenge.
character
penalty_type
String indicating the penalty type of the first penalty in the given play. Will be NA if desc is missing the type.
character
defensive_two_point_attempt
Binary indicator whether or not the defense was able to have an attempt on a two point conversion, this results following a turnover.
numeric
defensive_two_point_conv
Binary indicator whether or not the defense successfully scored on the two point conversion.
numeric
defensive_extra_point_attempt
Binary indicator whether or not the defense was able to have an attempt on an extra point attempt, this results following a blocked attempt that the defense recovers the ball.
numeric
defensive_extra_point_conv
Binary indicator whether or not the defense successfully scored on an extra point attempt.
numeric
safety_player_name
String name for the player who scored a safety.
character
safety_player_id
Unique identifier for the player who scored a safety.
character
season
4 digit number indicating to which season the game belongs to.
numeric
cp
Numeric value indicating the probability for a complete pass based on comparable game situations.
numeric
cpoe
For a single pass play this is 1 - cp when the pass was completed or 0 - cp when the pass was incomplete. Analyzed for a whole game or season an indicator for the passer how much over or under expectation his completion percentage was.
numeric
series
Starts at 1, each new first down increments, numbers shared across both teams NA: kickoffs, extra point/two point conversion attempts, non-plays, no posteam
numeric
series_success
1: scored touchdown, gained enough yards for first down.
numeric
series_result
Possible values: First down, Touchdown, Opp touchdown, Field goal, Missed field goal, Safety, Turnover, Punt, Turnover on downs, QB kneel, End of half
character
order_sequence
Column provided by NFL to fix out-of-order plays. Available 2011 and beyond with source “nfl”.
numeric
start_time
Kickoff time in eastern time zone.
character
time_of_day
Time of day of play in UTC “HH:MM:SS” format. Available 2011 and beyond with source “nfl”.
character
stadium
Game site name.
character
weather
String describing the weather including temperature, humidity and wind (direction and speed). Doesn’t change during the game!
character
nfl_api_id
UUID of the game in the new NFL API.
character
play_clock
Time on the playclock when the ball was snapped.
character
play_deleted
Binary indicator for deleted plays.
numeric
play_type_nfl
Play type as listed in the NFL source. Slightly different to the regular play_type variable.
character
special_teams_play
Binary indicator for whether play is special teams play from NFL source. Available 2011 and beyond with source “nfl”.
numeric
st_play_type
Type of special teams play from NFL source. Available 2011 and beyond with source “nfl”.
character
end_clock_time
Game time at the end of a given play.
character
end_yard_line
String indicating the yardline at the end of the given play consisting of team half and yard line number.
character
fixed_drive
Manually created drive number in a game.
numeric
fixed_drive_result
Manually created drive result.
character
drive_real_start_time
Local day time when the drive started (currently not used by the NFL and therefore mostly ‘NA’).
character
drive_play_count
Numeric value of how many regular plays happened in a given drive.
numeric
drive_time_of_possession
Time of possession in a given drive.
character
drive_first_downs
Number of forst downs in a given drive.
numeric
drive_inside20
Binary indicator if the offense was able to get inside the opponents 20 yard line.
numeric
drive_ended_with_score
Binary indicator the drive ended with a score.
numeric
drive_quarter_start
Numeric value indicating in which quarter the given drive has started.
numeric
drive_quarter_end
Numeric value indicating in which quarter the given drive has ended.
numeric
drive_yards_penalized
Numeric value of how many yards the offense gained or lost through penalties in the given drive.
numeric
drive_start_transition
String indicating how the offense got the ball.
character
drive_end_transition
String indicating how the offense lost the ball.
character
drive_game_clock_start
Game time at the beginning of a given drive.
character
drive_game_clock_end
Game time at the end of a given drive.
character
drive_start_yard_line
String indicating where a given drive started consisting of team half and yard line number.
character
drive_end_yard_line
String indicating where a given drive ended consisting of team half and yard line number.
character
drive_play_id_started
Play_id of the first play in the given drive.
numeric
drive_play_id_ended
Play_id of the last play in the given drive.
numeric
away_score
Total points scored by the away team.
numeric
home_score
Total points scored by the home team.
numeric
location
Either ‘Home’ o ‘Neutral’ indicating if the home team played at home or at a neutral site.
character
result
Equals home_score - away_score and means the game outcome from the perspective of the home team.
numeric
total
Equals home_score + away_score and means the total points scored in the given game.
numeric
spread_line
The closing spread line for the game. A positive number means the home team was favored by that many points, a negative number means the away team was favored by that many points. (Source: Pro-Football-Reference)
numeric
total_line
The closing total line for the game. (Source: Pro-Football-Reference)
numeric
div_game
Binary indicator for if the given game was a division game.
numeric
roof
One of ‘dome’, ‘outdoors’, ‘closed’, ‘open’ indicating indicating the roof status of the stadium the game was played in. (Source: Pro-Football-Reference)
character
surface
What type of ground the game was played on. (Source: Pro-Football-Reference)
character
temp
The temperature at the stadium only for ‘roof’ = ‘outdoors’ or ‘open’.(Source: Pro-Football-Reference)
numeric
wind
The speed of the wind in miles/hour only for ‘roof’ = ‘outdoors’ or ‘open’. (Source: Pro-Football-Reference)
numeric
home_coach
First and last name of the home team coach. (Source: Pro-Football-Reference)
character
away_coach
First and last name of the away team coach. (Source: Pro-Football-Reference)
character
stadium_id
ID of the stadium the game was played in. (Source: Pro-Football-Reference)
character
game_stadium
Name of the stadium the game was played in. (Source: Pro-Football-Reference)
character
success
Binary indicator wheter epa > 0 in the given play.
numeric
passer
Name of the dropback player (scrambles included) including plays with penalties.
character
passer_jersey_number
Jersey number of the passer.
numeric
rusher
Name of the rusher (no scrambles) including plays with penalties.
character
rusher_jersey_number
Jersey number of the rusher.
numeric
receiver
Name of the receiver including plays with penalties.
character
receiver_jersey_number
Jersey number of the receiver.
numeric
pass
Binary indicator if the play was a pass play (sacks and scrambles included).
numeric
rush
Binary indicator if the play was a rushing play.
numeric
first_down
Binary indicator if the play ended in a first down.
numeric
aborted_play
Binary indicator if the play description indicates “Aborted”.
numeric
special
Binary indicator if “play_type” is one of “extra_point”, “field_goal”, “kickoff”, or “punt”.
numeric
play
Binary indicator: 1 if the play was a ‘normal’ play (including penalties), 0 otherwise.
numeric
passer_id
ID of the player in the ‘passer’ column.
character
rusher_id
ID of the player in the ‘rusher’ column.
character
receiver_id
ID of the player in the ‘receiver’ column.
character
name
Name of the ‘passer’ if it is not ‘NA’, or name of the ‘rusher’ otherwise.
character
jersey_number
Jersey number of the player listed in the ‘name’ column.
numeric
id
ID of the player in the ‘name’ column.
character
fantasy_player_name
Name of the rusher on rush plays or receiver on pass plays (from official stats).
character
fantasy_player_id
ID of the rusher on rush plays or receiver on pass plays (from official stats).
character
fantasy
Name of the rusher on rush plays or receiver on pass plays.
character
fantasy_id
ID of the rusher on rush plays or receiver on pass plays.
character
out_of_bounds
1 if play description contains ran ob, pushed ob, or sacked ob; 0 otherwise.
numeric
home_opening_kickoff
1 if the home team received the opening kickoff, 0 otherwise.
numeric
qb_epa
Gives QB credit for EPA for up to the point where a receiver lost a fumble after a completed catch and makes EPA work more like passing yards on plays with fumbles.
numeric
xyac_epa
Expected value of EPA gained after the catch, starting from where the catch was made. Zero yards after the catch would be listed as zero EPA.
numeric
xyac_mean_yardage
Average expected yards after the catch based on where the ball was caught.
numeric
xyac_median_yardage
Median expected yards after the catch based on where the ball was caught.
numeric
xyac_success
Probability play earns positive EPA (relative to where play started) based on where ball was caught.
numeric
xyac_fd
Probability play earns a first down based on where the ball was caught.
numeric
xpass
Probability of dropback scaled from 0 to 1.
numeric
pass_oe
Dropback percent over expected on a given play scaled from 0 to 100.
numeric