Skip to main content
Version: 0.0.75

NFL dataset loaders

flowchart LR
raw["scrape / raw"] --> enrich["enrich"] --> rel["release asset"] --> load["load_*()"]

Automation status

DatasetRelease tagPipeline
load_nfl_pbppbp
load_nfl_rostersrosters
load_nfl_weekly_rostersweekly_rosters
load_nfl_depth_chartsdepth_charts
load_nfl_injuriesinjuries
load_nfl_snap_countssnap_counts
load_nfl_pbp_participationpbp_participation
load_nfl_ftn_chartingftn_charting

load_nfl_pbp

Release: pbp · asset https://github.com/nflverse/nflverse-data/releases/download/pbp/play_by_play_{season}.parquet

Returns

col_nametypedescription
play_idFloat64Numeric play id that when used with game_id and drive provides the unique identifier for a single play.
game_idStringTen digit identifier for NFL game.
old_game_idStringLegacy NFL game ID.
home_teamStringThe home team. Note that this contains the designated home team for games which no team is playing at home such as Super Bowls or NFL International games.
away_teamStringString abbreviation for the away team.
season_typeStringREG or POST indicating if the timeframe belongs to regular or post season.
weekInt32Season week.
posteamStringString abbreviation for the team with possession.
posteam_typeStringString indicating whether the posteam team is home or away.
defteamStringString abbreviation for the team on defense.
side_of_fieldStringString abbreviation for which team's side of the field the team with possession is currently on.
yardline_100Float64Numeric distance in the number of yards from the opponent's endzone for the posteam.
game_dateStringDate of the game.
quarter_seconds_remainingFloat64Numeric seconds remaining in the quarter.
half_seconds_remainingFloat64Numeric seconds remaining in the half.
game_seconds_remainingFloat64Numeric seconds remaining in the game.
game_halfStringString indicating which half the play is in, either Half1, Half2, or Overtime.
quarter_endFloat64Binary indicator for whether or not the row of the data is marking the end of a quarter.
driveFloat64Numeric drive number in the game.
spFloat64Binary indicator for whether or not a score occurred on the play.
qtrFloat64Quarter of the game (5 is overtime).
downFloat64The down for the given play.
goal_to_goInt32Binary indicator for whether or not the posteam is in a goal down situation.
timeStringTime at start of play provided in string format as minutes:seconds remaining in the quarter.
yrdlnStringString indicating the current field position for a given play.
ydstogoFloat64Numeric yards in distance from either the first down marker or the endzone in goal down situations.
ydsnetFloat64Numeric value for total yards gained on the given drive.
descStringDetailed string description for the given play.
play_typeStringString 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.
yards_gainedFloat64Numeric yards gained (or lost) by the possessing team, excluding yards gained via fumble recoveries and laterals.
shotgunFloat64Binary indicator for whether or not the play was in shotgun formation.
no_huddleFloat64Binary indicator for whether or not the play was in no_huddle formation.
qb_dropbackFloat64Binary indicator for whether or not the QB dropped back on the play (pass attempt, sack, or scrambled).
qb_kneelFloat64Binary indicator for whether or not the QB took a knee.
qb_spikeFloat64Binary indicator for whether or not the QB spiked the ball.
qb_scrambleFloat64Binary indicator for whether or not the QB scrambled.
pass_lengthStringString indicator for pass length: short or deep.
pass_locationStringString indicator for pass location: left, middle, or right.
air_yardsFloat64Numeric value for distance in yards perpendicular to the line of scrimmage at where the targeted receiver either caught or didn't catch the ball.
yards_after_catchFloat64Numeric value for distance in yards perpendicular to the yard line where the receiver made the reception to where the play ended.
run_locationStringString indicator for location of run: left, middle, or right.
run_gapStringString indicator for line gap of run: end, guard, or tackle
field_goal_resultStringString indicator for result of field goal attempt: made, missed, or blocked.
kick_distanceFloat64Numeric distance in yards for kickoffs, field goals, and punts.
extra_point_resultStringString indicator for the result of the extra point attempt: good, failed, blocked, safety (touchback in defensive endzone is 1 point apparently), or aborted.
two_point_conv_resultStringString indicator for result of two point conversion attempt: success, failure, safety (touchback in defensive endzone is 1 point apparently), or return.
home_timeouts_remainingFloat64Numeric timeouts remaining in the half for the home team.
away_timeouts_remainingFloat64Numeric timeouts remaining in the half for the away team.
timeoutFloat64Binary indicator for whether or not a timeout was called by either team.
timeout_teamStringString abbreviation for which team called the timeout.
td_teamStringString abbreviation for which team scored the touchdown.
td_player_nameStringString name of the player who scored a touchdown.
td_player_idStringUnique identifier of the player who scored a touchdown.
posteam_timeouts_remainingFloat64Number of timeouts remaining for the possession team.
defteam_timeouts_remainingFloat64Number of timeouts remaining for the team on defense.
total_home_scoreFloat64Score for the home team at the start of the play.
total_away_scoreFloat64Score for the away team at the start of the play.
posteam_scoreFloat64Score the posteam at the start of the play.
defteam_scoreFloat64Score the defteam at the start of the play.
score_differentialFloat64Score differential between the posteam and defteam at the start of the play.
posteam_score_postFloat64Score for the posteam at the end of the play.
defteam_score_postFloat64Score for the defteam at the end of the play.
score_differential_postFloat64Score differential between the posteam and defteam at the end of the play.
no_score_probFloat64Predicted probability of no score occurring for the rest of the half based on the expected points model.
opp_fg_probFloat64Predicted probability of the defteam scoring a FG next. 'Next' in this context means the next score in the same game half.
opp_safety_probFloat64Predicted probability of the defteam scoring a safety next. 'Next' in this context means the next score in the same game half.
opp_td_probFloat64Predicted probability of the defteam scoring a TD next. 'Next' in this context means the next score in the same game half.
fg_probFloat64Predicted probability of the posteam scoring a FG next. 'Next' in this context means the next score in the same game half.
safety_probFloat64Predicted probability of the posteam scoring a safety next. 'Next' in this context means the next score in the same game half.
td_probFloat64Predicted probability of the posteam scoring a TD next. 'Next' in this context means the next score in the same game half.
extra_point_probFloat64Predicted probability of the posteam scoring an extra point.
two_point_conversion_probFloat64Predicted probability of the posteam scoring the two point conversion.
epFloat64Using the scoring event probabilities, the estimated expected points with respect to the possession team for the given play.
epaFloat64Expected points added (EPA) by the posteam for the given play.
total_home_epaFloat64Cumulative total EPA for the home team in the game so far.
total_away_epaFloat64Cumulative total EPA for the away team in the game so far.
total_home_rush_epaFloat64Cumulative total rushing EPA for the home team in the game so far.
total_away_rush_epaFloat64Cumulative total rushing EPA for the away team in the game so far.
total_home_pass_epaFloat64Cumulative total passing EPA for the home team in the game so far.
total_away_pass_epaFloat64Cumulative total passing EPA for the away team in the game so far.
air_epaFloat64EPA 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.
yac_epaFloat64EPA 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).
comp_air_epaFloat64EPA from the air yards alone only for completions.
comp_yac_epaFloat64EPA from the yards after catch alone only for completions.
total_home_comp_air_epaFloat64Cumulative total completions air EPA for the home team in the game so far.
total_away_comp_air_epaFloat64Cumulative total completions air EPA for the away team in the game so far.
total_home_comp_yac_epaFloat64Cumulative total completions yac EPA for the home team in the game so far.
total_away_comp_yac_epaFloat64Cumulative total completions yac EPA for the away team in the game so far.
total_home_raw_air_epaFloat64Cumulative total raw air EPA for the home team in the game so far.
total_away_raw_air_epaFloat64Cumulative total raw air EPA for the away team in the game so far.
total_home_raw_yac_epaFloat64Cumulative total raw yac EPA for the home team in the game so far.
total_away_raw_yac_epaFloat64Cumulative total raw yac EPA for the away team in the game so far.
wpFloat64Estimated win probability for the posteam given the current situation at the start of the given play.
def_wpFloat64Estimated win probability for the defteam.
home_wpFloat64Estimated win probability for the home team.
away_wpFloat64Estimated win probability for the away team.
wpaFloat64Win probability added (WPA) for the posteam.
vegas_wpaFloat64Win probability added (WPA) for the posteam: spread_adjusted model.
vegas_home_wpaFloat64Win probability added (WPA) for the home team: spread_adjusted model.
home_wp_postFloat64Estimated win probability for the home team at the end of the play.
away_wp_postFloat64Estimated win probability for the away team at the end of the play.
vegas_wpFloat64Estimated win probability for the posteam given the current situation at the start of the given play, incorporating pre-game Vegas line.
vegas_home_wpFloat64Estimated win probability for the home team incorporating pre-game Vegas line.
total_home_rush_wpaFloat64Cumulative total rushing WPA for the home team in the game so far.
total_away_rush_wpaFloat64Cumulative total rushing WPA for the away team in the game so far.
total_home_pass_wpaFloat64Cumulative total passing WPA for the home team in the game so far.
total_away_pass_wpaFloat64Cumulative total passing WPA for the away team in the game so far.
air_wpaFloat64WPA through the air (same logic as air_epa).
yac_wpaFloat64WPA from yards after the catch (same logic as yac_epa).
comp_air_wpaFloat64The air_wpa for completions only.
comp_yac_wpaFloat64The yac_wpa for completions only.
total_home_comp_air_wpaFloat64Cumulative total completions air WPA for the home team in the game so far.
total_away_comp_air_wpaFloat64Cumulative total completions air WPA for the away team in the game so far.
total_home_comp_yac_wpaFloat64Cumulative total completions yac WPA for the home team in the game so far.
total_away_comp_yac_wpaFloat64Cumulative total completions yac WPA for the away team in the game so far.
total_home_raw_air_wpaFloat64Cumulative total raw air WPA for the home team in the game so far.
total_away_raw_air_wpaFloat64Cumulative total raw air WPA for the away team in the game so far.
total_home_raw_yac_wpaFloat64Cumulative total raw yac WPA for the home team in the game so far.
total_away_raw_yac_wpaFloat64Cumulative total raw yac WPA for the away team in the game so far.
punt_blockedFloat64Binary indicator for if the punt was blocked.
first_down_rushFloat64Binary indicator for if a running play converted the first down.
first_down_passFloat64Binary indicator for if a passing play converted the first down.
first_down_penaltyFloat64Binary indicator for if a penalty converted the first down.
third_down_convertedFloat64Binary indicator for if the first down was converted on third down.
third_down_failedFloat64Binary indicator for if the posteam failed to convert first down on third down.
fourth_down_convertedFloat64Binary indicator for if the first down was converted on fourth down.
fourth_down_failedFloat64Binary indicator for if the posteam failed to convert first down on fourth down.
incomplete_passFloat64Binary indicator for if the pass was incomplete.
touchbackFloat64Binary indicator for if a touchback occurred on the play.
interceptionFloat64Binary indicator for if the pass was intercepted.
punt_inside_twentyFloat64Binary indicator for if the punt ended inside the twenty yard line.
punt_in_endzoneFloat64Binary indicator for if the punt was in the endzone.
punt_out_of_boundsFloat64Binary indicator for if the punt went out of bounds.
punt_downedFloat64Binary indicator for if the punt was downed.
punt_fair_catchFloat64Binary indicator for if the punt was caught with a fair catch.
kickoff_inside_twentyFloat64Binary indicator for if the kickoff ended inside the twenty yard line.
kickoff_in_endzoneFloat64Binary indicator for if the kickoff was in the endzone.
kickoff_out_of_boundsFloat64Binary indicator for if the kickoff went out of bounds.
kickoff_downedFloat64Binary indicator for if the kickoff was downed.
kickoff_fair_catchFloat64Binary indicator for if the kickoff was caught with a fair catch.
fumble_forcedFloat64Binary indicator for if the fumble was forced.
fumble_not_forcedFloat64Binary indicator for if the fumble was not forced.
fumble_out_of_boundsFloat64Binary indicator for if the fumble went out of bounds.
solo_tackleFloat64Binary indicator if the play had a solo tackle (could be multiple due to fumbles).
safetyFloat64Binary indicator for whether or not a safety occurred.
penaltyFloat64Binary indicator for whether or not a penalty occurred.
tackled_for_lossFloat64Binary indicator for whether or not a tackle for loss on a run play occurred.
fumble_lostFloat64Binary indicator for if the fumble was lost.
own_kickoff_recoveryFloat64Binary indicator for if the kicking team recovered the kickoff.
own_kickoff_recovery_tdFloat64Binary indicator for if the kicking team recovered the kickoff and scored a TD.
qb_hitFloat64Binary indicator if the QB was hit on the play.
rush_attemptFloat64Binary indicator for if the play was a run.
pass_attemptFloat64Binary indicator for if the play was a pass attempt (includes sacks).
sackFloat64Binary indicator for if the play ended in a sack.
touchdownFloat64Binary indicator for if the play resulted in a TD.
pass_touchdownFloat64Binary indicator for if the play resulted in a passing TD.
rush_touchdownFloat64Binary indicator for if the play resulted in a rushing TD.
return_touchdownFloat64Binary indicator for if the play resulted in a return TD. Returns may occur on any of: interception, fumble, kickoff, punt, or blocked kicks.
extra_point_attemptFloat64Binary indicator for extra point attempt.
two_point_attemptFloat64Binary indicator for two point conversion attempt.
field_goal_attemptFloat64Binary indicator for field goal attempt.
kickoff_attemptFloat64Binary indicator for kickoff.
punt_attemptFloat64Binary indicator for punts.
fumbleFloat64Binary indicator for if a fumble occurred.
complete_passFloat64Binary indicator for if the pass was completed.
assist_tackleFloat64Binary indicator for if an assist tackle occurred.
lateral_receptionFloat64Binary indicator for if a lateral occurred on the reception.
lateral_rushFloat64Binary indicator for if a lateral occurred on a run.
lateral_returnFloat64Binary indicator for if a lateral occurred on a return. Returns may occur on any of: interception, fumble, kickoff, punt, or blocked kicks.
lateral_recoveryFloat64Binary indicator for if a lateral occurred on a fumble recovery.
passer_player_idStringUnique identifier for the player that attempted the pass.
passer_player_nameStringString name for the player that attempted the pass.
passing_yardsFloat64Numeric yards by the passer_player_name, including yards gained in pass plays with laterals. This should equal official passing statistics.
receiver_player_idStringUnique identifier for the receiver that was targeted on the pass.
receiver_player_nameStringString name for the targeted receiver.
receiving_yardsFloat64Numeric 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 of lateral_receiver_player_name for further information.
rusher_player_idStringUnique identifier for the player that attempted the run.
rusher_player_nameStringString name for the player that attempted the run.
rushing_yardsFloat64Numeric 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 of lateral_rusher_player_name for further information.
lateral_receiver_player_idStringUnique identifier for the player that received the last(!) lateral on a pass play.
lateral_receiver_player_nameStringString 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_yards for a list of plays where multiple players recorded lateral receiving yards.
lateral_receiving_yardsFloat64Numeric yards by the lateral_receiver_player_name in pass plays with laterals. Please see the description of lateral_receiver_player_name for further information.
lateral_rusher_player_idStringUnique identifier for the player that received the last(!) lateral on a run play.
lateral_rusher_player_nameStringString 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_yards for a list of plays where multiple players recorded lateral rushing yards.
lateral_rushing_yardsFloat64Numeric yards by the lateral_rusher_player_name in run plays with laterals. Please see the description of lateral_rusher_player_name for further information.
lateral_sack_player_idStringUnique identifier for the player that received the lateral on a sack.
lateral_sack_player_nameStringString name for the player that received the lateral on a sack.
interception_player_idStringUnique identifier for the player that intercepted the pass.
interception_player_nameStringString name for the player that intercepted the pass.
lateral_interception_player_idStringUnique identifier for the player that received the lateral on an interception.
lateral_interception_player_nameStringString name for the player that received the lateral on an interception.
punt_returner_player_idStringUnique identifier for the punt returner.
punt_returner_player_nameStringString name for the punt returner.
lateral_punt_returner_player_idStringUnique identifier for the player that received the lateral on a punt return.
lateral_punt_returner_player_nameStringString name for the player that received the lateral on a punt return.
kickoff_returner_player_nameStringString name for the kickoff returner.
kickoff_returner_player_idStringUnique identifier for the kickoff returner.
lateral_kickoff_returner_player_idStringUnique identifier for the player that received the lateral on a kickoff return.
lateral_kickoff_returner_player_nameStringString name for the player that received the lateral on a kickoff return.
punter_player_idStringUnique identifier for the punter.
punter_player_nameStringString name for the punter.
kicker_player_nameStringString name for the kicker on FG or kickoff.
kicker_player_idStringUnique identifier for the kicker on FG or kickoff.
own_kickoff_recovery_player_idStringUnique identifier for the player that recovered their own kickoff.
own_kickoff_recovery_player_nameStringString name for the player that recovered their own kickoff.
blocked_player_idStringUnique identifier for the player that blocked the punt or FG.
blocked_player_nameStringString name for the player that blocked the punt or FG.
tackle_for_loss_1_player_idStringUnique identifier for one of the potential players with the tackle for loss.
tackle_for_loss_1_player_nameStringString name for one of the potential players with the tackle for loss.
tackle_for_loss_2_player_idStringUnique identifier for one of the potential players with the tackle for loss.
tackle_for_loss_2_player_nameStringString name for one of the potential players with the tackle for loss.
qb_hit_1_player_idStringUnique 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.
qb_hit_1_player_nameStringString name 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.
qb_hit_2_player_idStringUnique 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.
qb_hit_2_player_nameStringString name 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.
forced_fumble_player_1_teamStringTeam of one of the players with a forced fumble.
forced_fumble_player_1_player_idStringUnique identifier of one of the players with a forced fumble.
forced_fumble_player_1_player_nameStringString name of one of the players with a forced fumble.
forced_fumble_player_2_teamStringTeam of one of the players with a forced fumble.
forced_fumble_player_2_player_idStringUnique identifier of one of the players with a forced fumble.
forced_fumble_player_2_player_nameStringString name of one of the players with a forced fumble.
solo_tackle_1_teamStringTeam of one of the players with a solo tackle.
solo_tackle_2_teamStringTeam of one of the players with a solo tackle.
solo_tackle_1_player_idStringUnique identifier of one of the players with a solo tackle.
solo_tackle_2_player_idStringUnique identifier of one of the players with a solo tackle.
solo_tackle_1_player_nameStringString name of one of the players with a solo tackle.
solo_tackle_2_player_nameStringString name of one of the players with a solo tackle.
assist_tackle_1_player_idStringUnique identifier of one of the players with a tackle assist.
assist_tackle_1_player_nameStringString name of one of the players with a tackle assist.
assist_tackle_1_teamStringTeam of one of the players with a tackle assist.
assist_tackle_2_player_idStringUnique identifier of one of the players with a tackle assist.
assist_tackle_2_player_nameStringString name of one of the players with a tackle assist.
assist_tackle_2_teamStringTeam of one of the players with a tackle assist.
assist_tackle_3_player_idStringUnique identifier of one of the players with a tackle assist.
assist_tackle_3_player_nameStringString name of one of the players with a tackle assist.
assist_tackle_3_teamStringTeam of one of the players with a tackle assist.
assist_tackle_4_player_idStringUnique identifier of one of the players with a tackle assist.
assist_tackle_4_player_nameStringString name of one of the players with a tackle assist.
assist_tackle_4_teamStringTeam of one of the players with a tackle assist.
tackle_with_assistFloat64Binary indicator for if there has been a tackle with assist.
tackle_with_assist_1_player_idStringUnique identifier of one of the players with a tackle with assist.
tackle_with_assist_1_player_nameStringString name of one of the players with a tackle with assist.
tackle_with_assist_1_teamStringTeam of one of the players with a tackle with assist.
tackle_with_assist_2_player_idStringUnique identifier of one of the players with a tackle with assist.
tackle_with_assist_2_player_nameStringString name of one of the players with a tackle with assist.
tackle_with_assist_2_teamStringTeam of one of the players with a tackle with assist.
pass_defense_1_player_idStringUnique identifier of one of the players with a pass defense.
pass_defense_1_player_nameStringString name of one of the players with a pass defense.
pass_defense_2_player_idStringUnique identifier of one of the players with a pass defense.
pass_defense_2_player_nameStringString name of one of the players with a pass defense.
fumbled_1_teamStringTeam of one of the first player with a fumble.
fumbled_1_player_idStringUnique identifier of the first player who fumbled on the play.
fumbled_1_player_nameStringString name of one of the first player who fumbled on the play.
fumbled_2_player_idStringUnique identifier of the second player who fumbled on the play.
fumbled_2_player_nameStringString name of one of the second player who fumbled on the play.
fumbled_2_teamStringTeam of one of the second player with a fumble.
fumble_recovery_1_teamStringTeam of one of the players with a fumble recovery.
fumble_recovery_1_yardsFloat64Yards gained by one of the players with a fumble recovery.
fumble_recovery_1_player_idStringUnique identifier of one of the players with a fumble recovery.
fumble_recovery_1_player_nameStringString name of one of the players with a fumble recovery.
fumble_recovery_2_teamStringTeam of one of the players with a fumble recovery.
fumble_recovery_2_yardsFloat64Yards gained by one of the players with a fumble recovery.
fumble_recovery_2_player_idStringUnique identifier of one of the players with a fumble recovery.
fumble_recovery_2_player_nameStringString name of one of the players with a fumble recovery.
sack_player_idStringUnique identifier of the player who recorded a solo sack.
sack_player_nameStringString name of the player who recorded a solo sack.
half_sack_1_player_idStringUnique identifier of the first player who recorded half a sack.
half_sack_1_player_nameStringString name of the first player who recorded half a sack.
half_sack_2_player_idStringUnique identifier of the second player who recorded half a sack.
half_sack_2_player_nameStringString name of the second player who recorded half a sack.
return_teamStringString abbreviation of the return team. Returns may occur on any of: interception, fumble, kickoff, punt, or blocked kicks.
return_yardsFloat64Yards gained by the return team. Returns may occur on any of: interception, fumble, kickoff, punt, or blocked kicks.
penalty_teamStringString abbreviation of the team with the penalty.
penalty_player_idStringUnique identifier for the player with the penalty.
penalty_player_nameStringString name for the player with the penalty.
penalty_yardsFloat64Yards gained (or lost) by the posteam from the penalty.
replay_or_challengeFloat64Binary indicator for whether or not a replay or challenge.
replay_or_challenge_resultStringString indicating the result of the replay or challenge.
penalty_typeStringString indicating the penalty type of the first penalty in the given play. Will be NA if desc is missing the type.
defensive_two_point_attemptFloat64Binary indicator whether or not the defense was able to have an attempt on a two point conversion, this results following a turnover.
defensive_two_point_convFloat64Binary indicator whether or not the defense successfully scored on the two point conversion.
defensive_extra_point_attemptFloat64Binary 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.
defensive_extra_point_convFloat64Binary indicator whether or not the defense successfully scored on an extra point attempt.
safety_player_nameStringString name for the player who scored a safety.
safety_player_idStringUnique identifier for the player who scored a safety.
seasonInt324 digit number indicating to which season(s) the specified timeframe belongs to.
cpFloat64Numeric value indicating the probability for a complete pass based on comparable game situations.
cpoeFloat64For 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.
seriesFloat64Starts at 1, each new first down increments, numbers shared across both teams NA: kickoffs, extra point/two point conversion attempts, non-plays, no posteam
series_successFloat641: scored touchdown, gained enough yards for first down.
series_resultStringPossible values: First down, Touchdown, Opp touchdown, Field goal, Missed field goal, Safety, Turnover, Punt, Turnover on downs, QB kneel, End of half
order_sequenceFloat64Column provided by NFL to fix out-of-order plays. Available 2011 and beyond with source "nfl".
start_timeStringKickoff time in eastern time zone.
time_of_dayStringTime of day of play in UTC "HH:MM:SS" format. Available 2011 and beyond with source "nfl".
stadiumStringName of the stadium
weatherStringString describing the weather including temperature, humidity and wind (direction and speed). Doesn't change during the game!
nfl_api_idStringUUID of the game in the new NFL API.
play_clockStringTime on the playclock when the ball was snapped.
play_deletedFloat64Binary indicator for deleted plays.
play_type_nflStringPlay type as listed in the NFL source. Slightly different to the regular play_type variable.
special_teams_playFloat64Binary indicator for whether play is special teams play from NFL source. Available 2011 and beyond with source "nfl".
st_play_typeStringType of special teams play from NFL source. Available 2011 and beyond with source "nfl".
end_clock_timeStringGame time at the end of a given play.
end_yard_lineStringString indicating the yardline at the end of the given play consisting of team half and yard line number.
fixed_driveFloat64Manually created drive number in a game.
fixed_drive_resultStringManually created drive result.
drive_real_start_timeStringLocal day time when the drive started (currently not used by the NFL and therefore mostly 'NA').
drive_play_countFloat64Numeric value of how many regular plays happened in a given drive.
drive_time_of_possessionStringTime of possession in a given drive.
drive_first_downsFloat64Number of first downs in a given drive.
drive_inside20Float64Binary indicator if the offense was able to get inside the opponents 20 yard line.
drive_ended_with_scoreFloat64Binary indicator the drive ended with a score.
drive_quarter_startFloat64Numeric value indicating in which quarter the given drive has started.
drive_quarter_endFloat64Numeric value indicating in which quarter the given drive has ended.
drive_yards_penalizedFloat64Numeric value of how many yards the offense gained or lost through penalties in the given drive.
drive_start_transitionStringString indicating how the offense got the ball.
drive_end_transitionStringString indicating how the offense lost the ball.
drive_game_clock_startStringGame time at the beginning of a given drive.
drive_game_clock_endStringGame time at the end of a given drive.
drive_start_yard_lineStringString indicating where a given drive started consisting of team half and yard line number.
drive_end_yard_lineStringString indicating where a given drive ended consisting of team half and yard line number.
drive_play_id_startedFloat64Play_id of the first play in the given drive.
drive_play_id_endedFloat64Play_id of the last play in the given drive.
away_scoreInt32The number of points the away team scored. Is NA for games which haven't yet been played.
home_scoreInt32The number of points the home team scored. Is NA for games which haven't yet been played.
locationStringEither Home if the home team is playing in their home stadium, or Neutral if the game is being played at a neutral location. This still shows as Home for games between the Giants and Jets even though they share the same home stadium.
resultInt32The number of points the home team scored minus the number of points the visiting team scored. Equals h_score - v_score. Is NA for games which haven't yet been played. Convenient for evaluating against the spread bets.
totalInt32The sum of each team's score in the game. Equals h_score + v_score. Is NA for games which haven't yet been played. Convenient for evaluating over/under total bets.
spread_lineFloat64The 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)
total_lineFloat64The closing total line for the game. (Source: Pro-Football-Reference)
div_gameInt32Binary indicator of whether or not game was played by 2 teams in the same division.
roofStringOne of 'dome', 'outdoors', 'closed', 'open' indicating indicating the roof status of the stadium the game was played in. (Source: Pro-Football-Reference)
surfaceStringWhat type of ground the game was played on. (Source: Pro-Football-Reference)
tempInt32The temperature at the stadium only for 'roof' = 'outdoors' or 'open'.(Source: Pro-Football-Reference)
windInt32The speed of the wind in miles/hour only for 'roof' = 'outdoors' or 'open'. (Source: Pro-Football-Reference)
home_coachStringFirst and last name of the home team coach. (Source: Pro-Football-Reference)
away_coachStringFirst and last name of the away team coach. (Source: Pro-Football-Reference)
stadium_idStringID of the stadium the game was played in. (Source: Pro-Football-Reference)
game_stadiumStringName of the stadium the game was played in. (Source: Pro-Football-Reference)
aborted_playFloat64Binary indicator if the play description indicates "Aborted".
successFloat64Binary indicator whether epa > 0 in the given play.
passerStringName of the dropback player (scrambles included) including plays with penalties.
passer_jersey_numberInt32Jersey number of the passer.
rusherStringName of the rusher (no scrambles) including plays with penalties.
rusher_jersey_numberInt32Jersey number of the rusher.
receiverStringName of the receiver including plays with penalties.
receiver_jersey_numberInt32Jersey number of the receiver.
passFloat64Binary indicator if the play was a pass play (sacks and scrambles included).
rushFloat64Binary indicator if the play was a rushing play.
first_downFloat64Binary indicator if the play ended in a first down.
specialFloat64Binary indicator if "play_type" is one of "extra_point", "field_goal", "kickoff", or "punt".
playFloat64Binary indicator: 1 if the play was a 'normal' play (including penalties), 0 otherwise.
passer_idStringID of the player in the 'passer' column.
rusher_idStringID of the player in the 'rusher' column.
receiver_idStringID of the player in the 'receiver' column.
nameStringName, as reported by MFL but reordered into FirstName LastName instead of Last, First
jersey_numberInt32Jersey number. Often useful for joins by name/team/jersey.
idStringID of the player in the 'name' column.
fantasy_player_nameStringName of the rusher on rush plays or receiver on pass plays (from official stats).
fantasy_player_idStringID of the rusher on rush plays or receiver on pass plays (from official stats).
fantasyStringName of the rusher on rush plays or receiver on pass plays.
fantasy_idStringID of the rusher on rush plays or receiver on pass plays.
out_of_boundsFloat641 if play description contains ran ob, pushed ob, or sacked ob; 0 otherwise.
home_opening_kickoffFloat641 if the home team received the opening kickoff, 0 otherwise.
qb_epaFloat64Gives 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.
xyac_epaFloat64Expected 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.
xyac_mean_yardageFloat64Average expected yards after the catch based on where the ball was caught.
xyac_median_yardageInt32Median expected yards after the catch based on where the ball was caught.
xyac_successFloat64Probability play earns positive EPA (relative to where play started) based on where ball was caught.
xyac_fdFloat64Probability play earns a first down based on where the ball was caught.
xpassFloat64Probability of dropback scaled from 0 to 1.
pass_oeFloat64Dropback percent over expected on a given play scaled from 0 to 100.
load_nfl_pbp(seasons=2024)

load_nfl_rosters

Release: rosters · asset https://github.com/nflverse/nflverse-data/releases/download/rosters/roster_{season}.parquet

Returns

col_nametypedescription
seasonInt32NFL season (year) the roster entry applies to.
teamStringTeam abbreviation in the nflverse standard (relocations folded, e.g. 'OAK' -> 'LV', 'SD' -> 'LAC', 'STL' -> 'LA').
positionStringPosition the player is listed at on the roster (e.g. 'QB', 'WR', 'CB').
depth_chart_positionStringFine-grained depth-chart position label, which may differ from the broader position group.
jersey_numberInt32Uniform (jersey) number the player wears.
statusStringRoster status code for the player (e.g. 'ACT' active, 'INA' inactive, 'RES' reserve/injured).
full_nameStringPlayer's full display name.
first_nameStringPlayer's first (given) name.
last_nameStringPlayer's last (family) name.
birth_dateDatePlayer's date of birth (YYYY-MM-DD).
heightInt32Player's height in inches.
weightInt32Player's listed weight in pounds.
collegeStringCollege or university the player attended.
gsis_idStringNFL GSIS player identifier — the canonical nflverse player key used to join across datasets.
espn_idStringESPN player identifier for cross-system joins.
sportradar_idStringSportradar player identifier for cross-system joins.
yahoo_idStringYahoo Sports player identifier for cross-system joins.
rotowire_idStringRotoWire player identifier for cross-system joins.
pff_idStringPro Football Focus (PFF) player identifier for cross-system joins.
pfr_idStringPro Football Reference (PFR) player identifier for cross-system joins.
fantasy_data_idStringFantasyData player identifier for cross-system joins.
sleeper_idStringSleeper player identifier for cross-system joins.
years_expInt32Number of accrued NFL seasons of experience for the player.
headshot_urlStringURL of the player's headshot image.
ngs_positionStringPlayer's position as classified by NFL Next Gen Stats.
weekInt32Week of the season the roster snapshot applies to (weekly rosters only).
game_typeStringType of game the roster snapshot applies to (e.g. 'REG', 'POST').
status_description_abbrStringAbbreviated roster status description code from the source feed.
football_nameStringPlayer's preferred football (commonly used) first name.
esb_idStringElias Sports Bureau (ESB) player identifier used for official NFL record-keeping.
gsis_it_idStringNFL GSIS internal tracking identifier for the player.
smart_idStringNFL SMART player identifier (GUID) used across modern NFL data feeds.
entry_yearInt32Calendar year the player first entered the NFL.
rookie_yearInt32Calendar year of the player's rookie season.
draft_clubStringTeam abbreviation of the club that drafted the player.
draft_numberInt32Overall pick number at which the player was selected in the NFL draft.
load_nfl_rosters(seasons=2024)

load_nfl_weekly_rosters

Release: weekly_rosters · asset https://github.com/nflverse/nflverse-data/releases/download/weekly_rosters/roster_weekly_{season}.parquet

Returns

col_nametypedescription
seasonInt32NFL season (year) the weekly roster snapshot applies to.
teamStringTeam abbreviation in the nflverse standard (relocations folded, e.g. 'OAK' -> 'LV', 'SD' -> 'LAC', 'STL' -> 'LA').
positionStringPosition the player is listed at on the roster (e.g. 'QB', 'WR', 'CB').
depth_chart_positionStringFine-grained depth-chart position label, which may differ from the broader position group.
jersey_numberInt32Uniform (jersey) number the player wears.
statusStringRoster status code for the player (e.g. 'ACT' active, 'INA' inactive, 'RES' reserve/injured).
full_nameStringPlayer's full display name.
first_nameStringPlayer's first (given) name.
last_nameStringPlayer's last (family) name.
birth_dateDatePlayer's date of birth (YYYY-MM-DD).
heightInt32Player's height in inches.
weightInt32Player's listed weight in pounds.
collegeStringCollege or university the player attended.
gsis_idStringNFL GSIS player identifier — the canonical nflverse player key used to join across datasets.
espn_idStringESPN player identifier for cross-system joins.
sportradar_idStringSportradar player identifier for cross-system joins.
yahoo_idStringYahoo Sports player identifier for cross-system joins.
rotowire_idStringRotoWire player identifier for cross-system joins.
pff_idStringPro Football Focus (PFF) player identifier for cross-system joins.
pfr_idStringPro Football Reference (PFR) player identifier for cross-system joins.
fantasy_data_idStringFantasyData player identifier for cross-system joins.
sleeper_idStringSleeper player identifier for cross-system joins.
years_expInt32Number of accrued NFL seasons of experience for the player.
headshot_urlStringURL of the player's headshot image.
ngs_positionStringPlayer's position as classified by NFL Next Gen Stats.
weekInt32Week of the season the weekly roster snapshot applies to.
game_typeStringType of game the weekly roster snapshot applies to (e.g. 'REG', 'POST').
status_description_abbrStringAbbreviated roster status description code from the source feed.
football_nameStringPlayer's preferred football (commonly used) first name.
esb_idStringElias Sports Bureau (ESB) player identifier used for official NFL record-keeping.
gsis_it_idStringNFL GSIS internal tracking identifier for the player.
smart_idStringNFL SMART player identifier (GUID) used across modern NFL data feeds.
entry_yearInt32Calendar year the player first entered the NFL.
rookie_yearInt32Calendar year of the player's rookie season.
draft_clubStringTeam abbreviation of the club that drafted the player.
draft_numberInt32Overall pick number at which the player was selected in the NFL draft.
load_nfl_weekly_rosters(seasons=2024)

load_nfl_depth_charts

Release: depth_charts · asset https://github.com/nflverse/nflverse-data/releases/download/depth_charts/depth_charts_{season}.parquet

Returns

col_nametypedescription
dtStringThe timestamp (ISO8601-formatted text) indicating when the data record was loaded. Can be used to assign the data set to a specific point in time during the season.
teamStringNFL team. Uses official abbreviations as per NFL.com
player_nameStringFull name of player
espn_idStringESPN ID - usual format is an integer with ~5 digits
gsis_idStringGame Stats and Info Service ID: the primary ID for play-by-play data.
pos_grp_idStringPlayer position group identifier
pos_grpStringPlayer position group: formation of offense, defense, or special teams
pos_idStringPlayer position identifier
pos_nameStringPlayer position name
pos_abbStringPlayer position abbreviation
pos_slotInt32A number assigned to each position in a formation
pos_rankInt32Player's rank on depth chart grouped by pos_slot
load_nfl_depth_charts(seasons=2024)

load_nfl_injuries

Release: injuries · asset https://github.com/nflverse/nflverse-data/releases/download/injuries/injuries_{season}.parquet

Returns

col_nametypedescription
seasonInt324 digit number indicating to which season(s) the specified timeframe belongs to.
season_typeStringREG or POST indicating if the timeframe belongs to regular or post season.
game_typeStringThe most recent game type of that season that a player appeared on the roster.
teamStringNFL team. Uses official abbreviations as per NFL.com
weekInt32Season week.
gsis_idStringGame Stats and Info Service ID: the primary ID for play-by-play data.
positionStringPrimary position as reported by NFL.com
full_nameStringFull name as per NFL.com
first_nameStringFirst name of player
last_nameStringLast name of player
report_primary_injuryStringPrimary injury listed on official injury report
report_secondary_injuryStringSecondary injury listed on official injury report
report_statusStringPlayer's status for game on official injury report
practice_primary_injuryStringPrimary injury listed on practice injury report
practice_secondary_injuryStringSecondary injury listed on practice injury report
practice_statusStringPlayer's participation in practice
load_nfl_injuries(seasons=2024)

load_nfl_snap_counts

Release: snap_counts · asset https://github.com/nflverse/nflverse-data/releases/download/snap_counts/snap_counts_{season}.parquet

Returns

col_nametypedescription
game_idStringTen digit identifier for NFL game.
pfr_game_idStringPFR game ID
seasonInt324 digit number indicating to which season(s) the specified timeframe belongs to.
game_typeStringThe most recent game type of that season that a player appeared on the roster.
weekInt32Season week.
playerStringPlayer name
pfr_player_idStringID from Pro Football Reference
positionStringPrimary position as reported by NFL.com
teamStringNFL team. Uses official abbreviations as per NFL.com
opponentStringOpposing team of player
offense_snapsFloat64Number of snaps on offense
offense_pctFloat64Percent of offensive snaps taken
defense_snapsFloat64Number of snaps on defense
defense_pctFloat64Percent of defensive snaps taken
st_snapsFloat64Number of snaps on special teams
st_pctFloat64Percent of special teams snaps taken
load_nfl_snap_counts(seasons=2024)

load_nfl_pbp_participation

Release: pbp_participation · asset https://github.com/nflverse/nflverse-data/releases/download/pbp_participation/pbp_participation_{season}.parquet

Returns

col_nametypedescription
nflverse_game_idStringnflverse identifier for games. Format is season, week, away_team, home_team
old_game_idStringLegacy NFL game ID.
play_idFloat64Numeric play id that when used with game_id and drive provides the unique identifier for a single play.
possession_teamStringString abbreviation for the team with possession.
offense_formationStringFormation the offense lines up in to snap the ball.
offense_personnelStringThe positions of the offensive personnel lined up on the field for a play.
defenders_in_boxInt32Number of defensive players lined up in the box at the snap.
defense_personnelStringThe positions of the defensive personnel lined up on the field for a play.
number_of_pass_rushersInt32Number of defensive player who rushed the passer.
players_on_playStringA list of every player on the field for the play, by gsis_id
offense_playersStringA list of every offensive player on the field for the play, by gsis_id
defense_playersStringA list of every defensive player on the field for the play, by gsis_id
n_offenseInt32Number of offensive players on the field for the play
n_defenseInt32Number of defensive players on the field for the play
ngs_air_yardsFloat64Legacy column. For 2023 and prior years, reflects the distance (in yards) that the ball traveled in the air on a given passing play as tracked by NGS. Is NA for 2024 on--we advise instead using the air_yards column from nflreadr::load_pbp() moving forward.
time_to_throwFloat64Duration (in seconds) between the time of the ball being snapped and the time of release of a pass attempt
was_pressureBooleanA boolean indicating whether or not the QB was pressured on a play
routeStringA string indicating the route the primary receiver on a play took. Has the following possible values: "CORNER", "DEEP OUT", "GO", "HITCH/CURL", "IN/DIG", "POST", "QUICK OUT", "SCREEN", "SHALLOW CROSS/DRAG", "SLANT", "SWING", "TEXAS/ANGLE", "WHEEL".
defense_man_zone_typeStringA string indicating whether the defense was in man or zone coverage on a play
defense_coverage_typeStringA string indicating what type of cover the defense was in on a play. Has one of the following values: "COVER_0", "COVER_1", "COVER_2", "2_MAN", "COVER_3", "COVER_4", "COVER_6", "COVER_9", "COMBO", "BLOWN".
offense_namesStringA string listing all of the names of offensive players in the order of their gsis_ids in offense_players.
defense_namesStringA string listing all of the names of defensive players in the order of their gsis_ids in defense_players.
offense_positionsStringA string listing all of the positions of offensive players in the order of their gsis_ids in offense_players.
defense_positionsStringA string listing all of the positions of defensive players in the order of their gsis_ids in defense_players.
offense_numbersStringA string listing all of the numbers of offensive players in the order of their gsis_ids in offense_players.
defense_numbersStringA string listing all of the numbers of defensive players in the order of their gsis_ids in defense_players.
load_nfl_pbp_participation(seasons=2024)

load_nfl_ftn_charting

Release: ftn_charting · asset https://github.com/nflverse/nflverse-data/releases/download/ftn_charting/ftn_charting_{season}.parquet

Returns

col_nametypedescription
ftn_game_idInt32FTN game ID
nflverse_game_idStringnflverse identifier for games. Format is season, week, away_team, home_team
seasonInt324 digit number indicating to which season(s) the specified timeframe belongs to.
weekInt32Season week.
ftn_play_idInt32FTN play ID
nflverse_play_idInt32Play ID used by nflverse, corresponds to GSIS play ID
starting_hashStringhash the ball was place(L = left, M = middle, R = right)
qb_locationStringpre-snap position of quarterback(U = under center, S = shotgun, P = pistol)
n_offense_backfieldInt32number of players in the backfield at the snap
n_defense_boxInt32Number of defenders aligned in the box at the time of the snap, as charted by FTN Data.
is_no_huddleBooleanno huddle
is_motionBooleanmotion occurred on the play before or at the time of the snap
is_play_actionBooleanplay-action pass
is_screen_passBooleanscreen pass
is_rpoBooleanplay is considered run-pass option
is_trick_playBooleantrick play
is_qb_out_of_pocketBooleanquarterback moved out of pocket
is_interception_worthyBooleaninterception worthy pass
is_throw_awayBooleanquarterback thrown away
read_thrownStringread the ball was thrown
is_catchable_ballBooleancatchable ball(defined by throws that are generally on target that are not defended away)
is_contested_ballBooleancontested ball(defined by whether or not the receiver is facing physical contact at the time of the catch)
is_created_receptionBooleancreated reception(defined by a reception that only occurs due to an exceptional play by the receiver)
is_dropBooleanreceiver drop
is_qb_sneakBooleanquarterback sneak
n_blitzersInt32number of blitzers
n_pass_rushersInt32number of pass rushers
is_qb_fault_sackBooleansack that is the fault of the quarterback
date_pulledDatetime(time_unit='us', time_zone='UTC')Date the data was retrieved from the FTN Data API by nflverse jobs
load_nfl_ftn_charting(seasons=2024)