Skip to main content

CFB dataset loaders — Advanced stats

load_cfb_adv_team​

Release: espn_cfb_adv_team · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/espn_cfb_adv_team/adv_team_{season}.parquet

Returns​

col_nametypedescription
pos_team_idInt64ESPN team id of the team on offense. Present for every season 2004+.
pos_teamStringTeam name in possession at the start of the play (offense, kickoff-aware).
rushing_highlight_yards_per_oppFloat64Highlight yards per rushing opportunity.
total_pen_yardsInt64Total penalty yards assessed.
EPA_penaltyFloat64Total EPA attributed to penalties.
penalty_first_downs_createdInt64Number of first downs the team gained via opponent penalty.
penalty_first_downs_created_rateFloat64Share of the team's first downs that came via opponent penalty.
penaltiesInt64Number of penalties assessed against the team.
penalty_yardsInt64Net penalty yardage assessed against the team; can be negative when enforcement moved the team forward on balance.
special_teams_playsInt64Number of special-teams plays.
EPA_spFloat64Total special-teams EPA, ESPN's abbreviated field for the same phase.
EPA_special_teamsFloat64Total EPA generated on special-teams plays.
field_goalsInt64Number of field-goal attempts.
EPA_fgFloat64Total EPA on field-goal attempts.
punt_playsInt64Number of punt plays.
EPA_puntFloat64Total EPA on punt plays.
kickoff_playsInt64Number of kickoff plays.
EPA_kickoffFloat64Total EPA on kickoff plays.
rushesInt64Number of rushing attempts.
rush_yardsFloat64Total yards the team gained on rush plays.
yards_per_rushFloat64Yards gained per rushing attempt.
rushing_power_rateFloat64Share of carries that were power rushing attempts.
rushing_first_downs_createdInt64Number of first downs created on rush plays.
rushing_first_downs_created_rateFloat64Share of rush plays that created a first down.
EPA_rushing_overallFloat64Total EPA on rush plays.
EPA_rushing_per_playFloat64EPA per rush play.
EPA_explosive_rushingInt64Count of explosive rush plays. A play count, not an EPA total.
EPA_explosive_rushing_rateFloat64Explosive-play rate on rush plays, over ESPN's qualifying-play denominator.
EPA_non_explosive_rushingFloat64Total EPA on rush plays with explosive plays excluded.
EPA_non_explosive_rushing_per_playFloat64EPA per rush play with explosive plays excluded.
passesInt64Number of pass plays the team ran.
pass_yardsFloat64Total yards the team gained on pass plays.
yards_per_passFloat64Team game yards per pass.
passing_first_downs_createdInt64Number of first downs created on pass plays.
passing_first_downs_created_rateFloat64Share of pass plays that created a first down.
EPA_passing_overallFloat64Total EPA on pass plays.
EPA_passing_per_playFloat64EPA per pass play.
EPA_explosive_passingInt64Count of explosive pass plays. A play count, not an EPA total.
EPA_explosive_passing_rateFloat64Explosive-play rate on pass plays, over ESPN's qualifying-play denominator.
EPA_non_explosive_passingFloat64Total EPA on pass plays with explosive plays excluded.
EPA_non_explosive_passing_per_playFloat64EPA per pass play with explosive plays excluded.
scrimmage_playsInt64Number of plays from scrimmage (rushes plus passes), excluding special teams.
EPA_overall_offFloat64Total offensive EPA for the team. Duplicated exactly by EPA_overall_offense in every published season checked -- prefer one and ignore the other.
EPA_overall_offenseFloat64Total offensive EPA. An exact duplicate of EPA_overall_off.
EPA_per_playFloat64Offensive EPA per play.
EPA_non_explosiveFloat64Total EPA with explosive plays excluded, isolating the team's routine-down production.
EPA_non_explosive_per_playFloat64EPA per play with explosive plays excluded.
EPA_explosiveInt64Count of explosive plays, per ESPN's advanced box score. Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_explosive_rateFloat64Explosive-play rate. Note this is NOT EPA_explosive divided by EPA_plays -- ESPN divides by its own smaller qualifying-play count, so deriving it yourself will not reproduce this value.
passes_rateFloat64Share of the team's plays from scrimmage that were pass plays.
off_yardsInt64Offensive yards gained from scrimmage.
total_off_yardsInt64Total offensive yards across all plays.
yards_per_playFloat64Yards gained per play.
EPA_playsInt64Number of plays ESPN's advanced box score scored for the team.
total_yardsInt64Total yards the team gained across all plays.
EPA_overall_totalFloat64Total EPA across all phases, which is why it differs from the offense-only EPA_overall_off.
rushes_rateFloat64Share of the team's plays from scrimmage that were rush plays.
first_downs_createdInt64Number of first downs the team created.
first_downs_created_rateFloat64Share of the team's plays that created a first down.
EPA_rushing_powerFloat64Total EPA on power rushing situations, as classified by ESPN's advanced box score.
EPA_rushing_power_per_playFloat64EPA per play on power rushing situations.
rushing_power_successInt64Count of power rushing attempts that gained the yardage needed. An integer count, not a rate -- the rate is published separately as rushing_power_success_rate.
rushing_power_success_rateFloat64Share of power rushing attempts that succeeded.
rushing_powerInt64Count of power rushing attempts, in short-yardage situations as classified by ESPN's advanced box score.
rushing_stuffInt64Count of stuffed rushing attempts.
rushing_stuff_rateFloat64Share of the team's carries that were stuffed at or behind the line of scrimmage.
rushing_stoppedInt64Count of rushing attempts stopped at or behind the line of scrimmage.
rushing_stopped_rateFloat64Share of carries stopped at or behind the line of scrimmage.
rushing_opportunityInt64Count of rushing opportunities -- carries that reached ESPN's opportunity threshold.
rushing_opportunity_rateFloat64Share of carries that qualified as rushing opportunities.
rushing_highlightInt64Highlight yards -- rushing yardage credited to the back rather than the offensive line.
rushing_highlight_rateFloat64Share of rushing yardage that was highlight (back-credited) yardage.
rushing_highlight_yardsFloat64Total highlight yards the team accumulated -- the yardage credited to ball carriers rather than the line. The per-carry figure is rushing_highlight_yards_per_opp.
line_yardsFloat64Line yards -- the portion of rushing yardage credited to the offensive line under the standard rushing decomposition. ESPN applies its own qualifying threshold for the yardage split.
line_yards_per_carryFloat64Line yards per rushing attempt.
second_level_yardsFloat64Second-level yards -- rushing yardage earned just beyond the line of scrimmage.
open_field_yardsFloat64Open-field yards -- rushing yardage earned well downfield, past the second level.
game_idInt64ESPN game identifier.
seasonInt64Season (4-digit year).
weekInt64Game week of the season.
load_cfb_adv_team(seasons=2024)

load_cfb_adv_passing​

Release: espn_cfb_adv_passing · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/espn_cfb_adv_passing/adv_passing_{season}.parquet

Returns​

col_nametypedescription
pos_team_idInt64ESPN team id of the team on offense. Present for every season 2004+.
pos_teamStringTeam name in possession at the start of the play (offense, kickoff-aware).
passer_player_nameStringDisplay name of the passer -- the FIRST participant in that role on the play.
CompInt64Completed passes recorded in the advanced box score.
AttInt64Pass attempts recorded in the advanced box score.
xCompFloat64Expected completions, summed from the per-play completion model.
YdsFloat64Passing yards from the advanced box score.
Pass_TDInt64Passing touchdowns.
IntInt64Interceptions thrown.
YPAFloat64Yards per pass attempt.
EPAFloat64Expected Points Added on the play (cfbfastR EPA model output).
EPA_per_PlayFloat64EPA per play on the passer's plays.
WPAFloat64
SRFloat64Success rate on the passer's plays.
SckInt64Times the passer was sacked.
CompPctFloat64Completion percentage from the advanced box score.
xCompPctFloat64Expected completion percentage from the per-play completion model.
CPOEFloat64Completion percentage over expected -- actual minus modelled completion rate.
AirYdsInt64Air yards -- distance the ball travelled in the air, past the line of scrimmage, summed over the player's attempts/targets.
aDOTFloat64Average depth of target -- mean air yards per attempt/target.
CompAirYdsInt64Air yards on completed passes only.
YACInt64Yards after catch.
AirYdsPctFloat64Air-yards rate published alongside AirYds. Despite the Pct suffix this is NOT a 0-100 percentage and is not AirYds/Yds (verified: max absolute difference 33.0); observed values run negative to slightly above 1.
qbr_epaFloat64EPA variant used as an input to the QBR calculation.
sack_epaFloat64EPA credited to the player's sacks taken.
pass_epaFloat64EPA credited to the player's pass plays.
rush_epaFloat64EPA credited to the player's rush plays.
pen_epaFloat64EPA attributable to penalties on the player's plays.
spreadFloat64Pre-game point spread from the selected provider.
era0Int64Rule-era indicator for the earliest modelled era.
era1Int64Rule-era indicator for the second modelled era.
era2Int64Rule-era indicator for the third modelled era.
era3Int64Rule-era indicator for the most recent modelled era.
exp_qbrFloat64Expected QBR for the passer.
game_idInt64ESPN game identifier.
seasonInt64Season (4-digit year).
weekInt64Game week of the season.
load_cfb_adv_passing(seasons=2024)

load_cfb_adv_rushing​

Release: espn_cfb_adv_rushing · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/espn_cfb_adv_rushing/adv_rushing_{season}.parquet

Returns​

col_nametypedescription
pos_team_idInt64ESPN team id of the team on offense. Present for every season 2004+.
pos_teamStringTeam name in possession at the start of the play (offense, kickoff-aware).
rusher_player_nameStringDisplay name of the ball carrier on a rush -- the FIRST participant in that role on the play.
CarInt64Rushing attempts credited to this ball carrier in the game.
YdsFloat64Passing yards from the advanced box score.
Rush_TDInt64Rushing touchdowns scored by this ball carrier in the game.
YPCFloat64Yards per carry, the mean rushing yardage across the player's attempts in the game.
EPAFloat64Expected Points Added on the play (cfbfastR EPA model output).
EPA_per_PlayFloat64EPA per play on the passer's plays.
WPAFloat64
SRFloat64Success rate on the passer's plays.
FumInt64Count of the carrier's rush attempts whose play text mentions a fumble; it is a play-level flag, not a fumble charged to this player.
Fum_LostInt64Count of the carrier's rush attempts on which a fumble was lost to the opponent.
game_idInt64ESPN game identifier.
seasonInt64Season (4-digit year).
weekInt64Game week of the season.
load_cfb_adv_rushing(seasons=2024)

load_cfb_adv_receiving​

Release: espn_cfb_adv_receiving · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/espn_cfb_adv_receiving/adv_receiving_{season}.parquet

Returns​

col_nametypedescription
pos_team_idInt64ESPN team id of the team on offense. Present for every season 2004+.
pos_teamStringTeam name in possession at the start of the play (offense, kickoff-aware).
receiver_player_nameStringDisplay name of the targeted receiver -- the FIRST participant in that role on the play.
RecInt64Receptions credited to the receiver, the number of completions on plays where this player was the targeted receiver.
TarInt64Times the player was targeted on a pass attempt, the denominator behind YPT.
YdsFloat64Passing yards from the advanced box score.
Rec_TDInt64Receiving touchdowns, the count of the player's targeted plays that ended in a passing touchdown.
YPTFloat64Receiving yards per target, the mean of receiving yardage over every target rather than over receptions only.
EPAFloat64Expected Points Added on the play (cfbfastR EPA model output).
EPA_per_PlayFloat64EPA per play on the passer's plays.
WPAFloat64
SRFloat64Success rate on the passer's plays.
FumInt64Count of the receiver's targeted pass plays whose text mentions a fumble; it is a play-level flag, not a fumble charged to this player.
Fum_LostInt64Count of the receiver's targeted plays on which a fumble was lost to the opponent.
AirYdsInt64Air yards -- distance the ball travelled in the air, past the line of scrimmage, summed over the player's attempts/targets.
aDOTFloat64Average depth of target -- mean air yards per attempt/target.
CompAirYdsInt64Air yards on completed passes only.
YACInt64Yards after catch.
AirYdsPctFloat64Air-yards rate published alongside AirYds. Despite the Pct suffix this is NOT a 0-100 percentage and is not AirYds/Yds (verified: max absolute difference 33.0); observed values run negative to slightly above 1.
game_idInt64ESPN game identifier.
seasonInt64Season (4-digit year).
weekInt64Game week of the season.
load_cfb_adv_receiving(seasons=2024)

load_cfb_adv_defensive​

Release: espn_cfb_adv_defensive · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/espn_cfb_adv_defensive/adv_defensive_{season}.parquet

Returns​

col_nametypedescription
def_pos_team_idInt64ESPN team id of the team on defense. Present for every season 2004+.
def_pos_teamStringTeam name on defense at the start of the play.
scrimmage_playsInt64Number of plays from scrimmage (rushes plus passes), excluding special teams.
TFLInt64Count of scrimmage plays the defense held to negative yardage (non-penalty, non-special-teams, ESPN statYardage below zero) plus every sack.
TFL_passInt64The TFL count restricted to plays classified as passes, so it covers sacks together with completions and laterals stopped behind the line.
TFL_rushInt64The TFL count restricted to plays classified as rushes, that is rushing attempts the defense stopped for negative yardage.
havoc_totalInt64Total havoc rate.
havoc_total_rateFloat64Share of the defense's scrimmage plays producing a havoc event, a 0-to-1 fraction equal to havoc_total divided by scrimmage_plays.
fumblesInt64Fumbles the defense forced, counted from plays whose narrative contains the phrase forced by, not the total number of fumbles on the play.
def_intInt64Interceptions the defense recorded, counted from plays ESPN types as Interception Return or Interception Return Touchdown.
drive_stopped_rateFloat64Percentage from 0 to 100 of the defense's scrimmage plays that occurred on drives ending in a punt, fumble, interception, or turnover on downs; the denominator is plays, not drives.
num_pass_playsInt64Number of pass scrimmage plays the defense faced, the denominator behind havoc_total_pass_rate and sacks_rate.
havoc_total_passInt64Havoc events (tackle for loss, sack, interception, forced fumble, or pass breakup) recorded on the pass plays the defense faced.
havoc_total_pass_rateFloat64havoc_total_pass divided by num_pass_plays, the defense's havoc rate against the pass as a 0-to-1 fraction.
sacksInt64Team sacks.
sacks_rateFloat64Sacks divided by pass plays faced, the defense's per-pass-play sack rate as a 0-to-1 fraction.
pass_breakupsInt64Passes the defense broke up, counted from plays whose narrative contains the phrase broken up by.
havoc_total_rushInt64Havoc events recorded on the rush plays the defense faced, in practice tackles for loss and forced fumbles.
havoc_total_rush_rateFloat64Havoc events per rush play faced, the mean of the havoc flag over the defense's rush scrimmage plays.
game_idInt64ESPN game identifier.
seasonInt64Season (4-digit year).
weekInt64Game week of the season.
load_cfb_adv_defensive(seasons=2024)

load_cfb_adv_defensive_players​

Release: espn_cfb_adv_defensive_players · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/espn_cfb_adv_defensive_players/adv_defensive_players_{season}.parquet

Returns​

col_nametypedescription
def_pos_team_idInt64ESPN team id of the team on defense. Present for every season 2004+.
def_pos_teamStringDisplay name of the team on defense (e.g. 'Ohio State Buckeyes'). Held an ESPN team id until the 2026-08 republish; the id now lives in def_pos_team_id.
player_nameStringDisplay name of the defender.
sacksFloat64Sacks recorded by the defender. Available from 2005 on; null for 2004.
sacks_yardsFloat64Yards lost by the offense on the defender's sacks. Available from 2005 on; null for 2004.
pass_breakupsInt64Passes broken up by the defender. Available from 2005 on; null for 2004.
interceptionsInt64Passes intercepted by the defender. Available from 2014 on; null for 2004-2013, which ESPN ships without interception statistics in this block.
interceptions_yardsInt64Yards returned on the defender's interceptions. Available from 2014 on; null for 2004-2013.
game_idInt64ESPN game identifier.
seasonInt64Season (4-digit year).
weekInt64Game week of the season.
forced_fumblesInt64Fumbles forced by the defender. Available from 2005 on; null for 2004, which ESPN ships with only the fumble-recovery statistics.
fumble_recoveriesInt64Fumbles recovered by the defender. Available for every season 2004+.
fumble_recoveries_yardsInt64Yards returned on the defender's fumble recoveries. Available for every season 2004+.
load_cfb_adv_defensive_players(seasons=2024)

load_cfb_adv_drives​

Release: espn_cfb_adv_drives · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/espn_cfb_adv_drives/adv_drives_{season}.parquet

Returns​

col_nametypedescription
pos_team_idInt64ESPN team id of the team on offense. Present for every season 2004+.
pos_teamStringTeam name in possession at the start of the play (offense, kickoff-aware).
drive_total_available_yardsFloat64Sum of each drive's starting distance to the opponent end zone taken across every scrimmage play, so a drive contributes its available yards once per play rather than once per drive.
drive_total_gained_yardsInt64Sum of ESPN's per-drive yardage repeated across every scrimmage play of that drive, so a drive contributes its yardage once per play.
avg_field_positionFloat64Mean distance to the opponent end zone at drive start averaged over the team's scrimmage plays, exactly drive_total_available_yards divided by that play count.
plays_per_driveFloat64Mean of ESPN's per-drive offensivePlays taken over plays rather than over drives, which weights every drive by its own length.
yards_per_driveFloat64Mean of ESPN's per-drive yardage taken over plays rather than over drives, exactly drive_total_gained_yards divided by the team's scrimmage-play count.
drivesInt64Number of distinct ESPN drive ids on which the team ran at least one scrimmage play.
drive_total_gained_yards_rateFloat64Available-yards conversion as a percentage, 100 times drive_total_gained_yards over drive_total_available_yards with both sums play-weighted.
game_idInt64ESPN game identifier.
seasonInt64Season (4-digit year).
weekInt64Game week of the season.
load_cfb_adv_drives(seasons=2024)

load_cfb_adv_situational​

Release: espn_cfb_adv_situational · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/espn_cfb_adv_situational/adv_situational_{season}.parquet

Returns​

col_nametypedescription
pos_team_idInt64ESPN team id of the team on offense. Present for every season 2004+.
pos_teamStringDisplay name of the team on offense (e.g. 'Ohio State Buckeyes').
EPA_successInt64Count of successful plays. Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_success_rateFloat64Success rate -- the share of those plays ESPN scored as successful.
EPA_success_passInt64Count of successful plays on pass plays. Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_success_pass_rateFloat64Success rate on pass plays -- the share of those plays ESPN scored as successful.
EPA_success_rushInt64Count of successful plays on rush plays. Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_success_rush_rateFloat64Success rate on rush plays -- the share of those plays ESPN scored as successful.
EPA_success_rzInt64Count of successful plays on the red zone. Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_success_rate_rzFloat64Success rate on the red zone -- the share of those plays ESPN scored as successful.
EPA_success_thirdInt64Count of successful plays on third down. Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_success_rate_thirdFloat64Success rate on third down -- the share of those plays ESPN scored as successful.
EPA_success_early_downInt64Count of successful plays on early downs. Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_success_early_down_rateFloat64Success rate on early downs -- the share of those plays ESPN scored as successful.
early_downsInt64Number of plays the team ran on early downs.
early_down_pass_rateFloat64Share of the team's plays on early downs that were pass plays.
early_down_rush_rateFloat64Share of the team's plays on early downs that were rush plays.
EPA_early_downFloat64Total EPA the team generated on early downs.
EPA_early_down_per_playFloat64EPA per play on early downs.
early_down_first_downInt64Number of early-down plays that produced a first down.
early_down_first_down_rateFloat64Share of early-down plays that produced a first down.
early_down_passInt64Number of pass plays the team ran on early downs.
EPA_early_down_passFloat64Total EPA the team generated on early downs on pass plays.
EPA_early_down_pass_per_playFloat64EPA per play on early downs on pass plays.
EPA_success_early_down_passInt64Count of successful plays on early downs on pass plays. Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_success_early_down_pass_rateFloat64Success rate on early downs on pass plays -- the share of those plays ESPN scored as successful.
early_down_rushInt64Number of rush plays the team ran on early downs.
EPA_early_down_rushFloat64Total EPA the team generated on early downs on rush plays.
EPA_early_down_rush_per_playFloat64EPA per play on early downs on rush plays.
EPA_success_early_down_rushInt64Count of successful plays on early downs on rush plays. Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_success_early_down_rush_rateFloat64Success rate on early downs on rush plays -- the share of those plays ESPN scored as successful.
middle_8Int64Number of plays the team ran in the middle eight -- the closing minutes of the first half and opening minutes of the second.
middle_8_pass_rateFloat64Share of the team's plays on the middle eight -- the closing minutes of the first half and opening minutes of the second that were pass plays.
middle_8_rush_rateFloat64Share of the team's plays on the middle eight -- the closing minutes of the first half and opening minutes of the second that were rush plays.
EPA_middle_8Float64Total EPA the team generated on the middle eight -- the closing minutes of the first half and opening minutes of the second.
EPA_middle_8_per_playFloat64EPA per play on the middle eight -- the closing minutes of the first half and opening minutes of the second.
EPA_middle_8_successInt64Count of successful plays on the middle eight -- the closing minutes of the first half and opening minutes of the second. Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_middle_8_success_rateFloat64Success rate on the middle eight -- the closing minutes of the first half and opening minutes of the second -- the share of those plays ESPN scored as successful.
middle_8_passInt64Number of pass plays the team ran on the middle eight -- the closing minutes of the first half and opening minutes of the second.
EPA_middle_8_passFloat64Total EPA the team generated on the middle eight -- the closing minutes of the first half and opening minutes of the second on pass plays.
EPA_middle_8_pass_per_playFloat64EPA per play on the middle eight -- the closing minutes of the first half and opening minutes of the second on pass plays.
EPA_middle_8_success_passInt64Count of successful plays on the middle eight -- the closing minutes of the first half and opening minutes of the second on pass plays. Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_middle_8_success_pass_rateFloat64Success rate on the middle eight -- the closing minutes of the first half and opening minutes of the second on pass plays -- the share of those plays ESPN scored as successful.
middle_8_rushInt64Number of rush plays the team ran on the middle eight -- the closing minutes of the first half and opening minutes of the second.
EPA_middle_8_rushFloat64Total EPA the team generated on the middle eight -- the closing minutes of the first half and opening minutes of the second on rush plays.
EPA_middle_8_rush_per_playFloat64EPA per play on the middle eight -- the closing minutes of the first half and opening minutes of the second on rush plays.
EPA_middle_8_success_rushInt64Count of successful plays on the middle eight -- the closing minutes of the first half and opening minutes of the second on rush plays. Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_middle_8_success_rush_rateFloat64Success rate on the middle eight -- the closing minutes of the first half and opening minutes of the second on rush plays -- the share of those plays ESPN scored as successful.
EPA_success_late_downInt64Count of successful plays on late downs. Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_success_late_down_passInt64Count of successful plays on late downs on pass plays. Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_success_late_down_rushInt64Count of successful plays on late downs on rush plays. Despite the EPA_ prefix this is a play COUNT, not an EPA total.
late_downsInt64Number of plays the team ran on late downs.
late_down_passInt64Number of pass plays the team ran on late downs.
late_down_rushInt64Number of rush plays the team ran on late downs.
EPA_late_downFloat64Total EPA the team generated on late downs.
EPA_late_down_per_playFloat64EPA per play on late downs.
EPA_success_late_down_rateFloat64Success rate on late downs -- the share of those plays ESPN scored as successful.
EPA_success_late_down_pass_rateFloat64Success rate on late downs on pass plays -- the share of those plays ESPN scored as successful.
EPA_success_late_down_rush_rateFloat64Success rate on late downs on rush plays -- the share of those plays ESPN scored as successful.
late_down_pass_rateFloat64Share of the team's plays on late downs that were pass plays.
late_down_rush_rateFloat64Share of the team's plays on late downs that were rush plays.
EPA_success_standard_downInt64Count of successful plays on standard downs (the team ahead of schedule for the series). Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_success_standard_down_rateFloat64Success rate on standard downs (the team ahead of schedule for the series) -- the share of those plays ESPN scored as successful.
EPA_standard_downFloat64Total EPA the team generated on standard downs (the team ahead of schedule for the series).
EPA_standard_down_per_playFloat64EPA per play on standard downs (the team ahead of schedule for the series).
standard_downsInt64Number of plays the team ran on standard downs (the team ahead of schedule for the series).
EPA_success_passing_downInt64Count of successful plays on passing downs (the team behind schedule for the series). Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_success_passing_down_rateFloat64Success rate on passing downs (the team behind schedule for the series) -- the share of those plays ESPN scored as successful.
EPA_passing_downFloat64Total EPA the team generated on passing downs (the team behind schedule for the series).
EPA_passing_down_per_playFloat64EPA per play on passing downs (the team behind schedule for the series).
passing_downsInt64Number of plays the team ran on passing downs (the team behind schedule for the series).
game_idInt64ESPN game identifier.
seasonInt64Season (4-digit year).
weekInt64Game week of the season.
load_cfb_adv_situational(seasons=2024)

load_cfb_adv_specialists​

Release: espn_cfb_adv_specialists · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/espn_cfb_adv_specialists/adv_specialists_{season}.parquet

Returns​

col_nametypedescription
pos_team_idInt64ESPN team id of the team on offense. Present for every season 2004+.
pos_teamStringTeam name in possession at the start of the play (offense, kickoff-aware).
player_nameString
field_goalsInt64Number of field-goal attempts.
field_goals_yardsInt64Sum of the field-goal attempt distances parsed out of the play text; it stays at zero when no distance could be parsed from the narrative.
puntsInt64Punts attempted.
punts_yardsInt64Total gross punt yardage parsed from the play text for this punter, working out to roughly 42 yards per punt league-wide.
kick_returnsInt64Number of kick returns.
kick_returns_yardsInt64Total yards the team gained returning kickoffs.
punt_returnsInt64Number of punt returns.
punt_returns_yardsInt64Total punt-return yardage credited to this returner, with fair catches, downed punts, and out-of-bounds punts scored as zero.
game_idInt64ESPN game identifier.
seasonInt64Season (4-digit year).
weekInt64Game week of the season.
load_cfb_adv_specialists(seasons=2024)

load_cfb_adv_turnover​

Release: espn_cfb_adv_turnover · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/espn_cfb_adv_turnover/adv_turnover_{season}.parquet

Returns​

col_nametypedescription
pos_team_idInt64ESPN team id of the team on offense. Present for every season 2004+.
pos_teamStringTeam name in possession at the start of the play (offense, kickoff-aware).
turnoversInt64Turnovers total.
st_turnovers_lostInt64Turnovers the team lost on special-teams plays.
IntInt64Interceptions thrown.
fumbles_lostInt64Fumbles lost.
pass_breakupsInt64Passes thrown by this offense that the opposing defense broke up; it equals the opponent's row in the advanced defensive table exactly.
total_fumblesInt64Team total fumbles.
fumbles_recoveredInt64Team fumbles recovered.
team_idInt64ESPN team id.
turnovers_pbpInt64Turnover count derived from the play-by-play, retained unchanged so it can be reconciled against the ESPN-sourced turnovers total.
Int_pbpInt64Interception count derived from the play-by-play, kept alongside the ESPN-sourced Int for reconciliation.
fumbles_lost_pbpInt64Fumbles-lost count derived from the play-by-play, kept alongside the ESPN-sourced fumbles_lost for reconciliation.
espn_sourcedBooleanCONSTANT: true on every published row. It records that the row was built from the ESPN feed rather than an alternate provider, and no other provider is currently used.
expected_turnoversFloat64Turnover expectation for this team, computed as half its total fumbles plus 0.22 times the sum of its pass breakups and interceptions.
expected_turnover_marginFloat64The opponent's expected_turnovers minus this team's, so positive means the team was expected to win the turnover battle.
turnover_marginInt64The opponent's turnovers minus this team's turnovers, positive when the team gained more possessions than it gave away.
turnover_luckFloat64Points of scoring luck attributed to turnovers, five points per turnover times the gap between turnover_margin and expected_turnover_margin.
takeawaysInt64
st_turnovers_gainedInt64Special-teams turnovers this team recovered, taken as the opponent's st_turnovers_lost.
fumble_recoveries_gainedInt64Opponent fumbles this team recovered, taken as the opponent's fumbles_lost.
game_idInt64ESPN game identifier.
seasonInt64Season (4-digit year).
weekInt64Game week of the season.
load_cfb_adv_turnover(seasons=2024)

load_cfb_adv_team_gamelog​

Release: espn_cfb_adv_team_gamelog · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/espn_cfb_adv_team_gamelog/adv_team_gamelog_{season}.parquet

Returns​

col_nametypedescription
seasonInt64Season (4-digit year).
weekInt64Game week of the season.
season_typeInt32ESPN season type (2 = regular, 3 = postseason).
game_idInt64ESPN game identifier.
start_dateStringSeason start timestamp (ISO 8601, UTC).
team_idInt64ESPN team id.
teamStringTeam name.
opponent_idInt64ESPN team id of the opponent.
opponentStringOpponent team name.
is_homeBoolean
neutral_siteBooleanTRUE/FALSE flag for if the game took place at a neutral site.
points_forInt64
points_againstInt64
marginInt64Final scoring margin from this team's perspective, exactly points_for minus points_against.
winBoolean
rushing_highlight_yards_per_oppFloat64Highlight yards per rushing opportunity.
total_pen_yardsInt64Total penalty yards assessed.
EPA_penaltyFloat64Total EPA attributed to penalties.
penalty_first_downs_createdInt64Number of first downs the team gained via opponent penalty.
penalty_first_downs_created_rateFloat64Share of the team's first downs that came via opponent penalty.
penaltiesInt64Number of penalties assessed against the team.
penalty_yardsInt64Net penalty yardage assessed against the team; can be negative when enforcement moved the team forward on balance.
special_teams_playsInt64Number of special-teams plays.
EPA_spFloat64Total special-teams EPA, ESPN's abbreviated field for the same phase.
EPA_special_teamsFloat64Total EPA generated on special-teams plays.
field_goalsInt64Number of field-goal attempts.
EPA_fgFloat64Total EPA on field-goal attempts.
punt_playsInt64Number of punt plays.
EPA_puntFloat64Total EPA on punt plays.
kickoff_playsInt64Number of kickoff plays.
EPA_kickoffFloat64Total EPA on kickoff plays.
rushesInt64Number of rushing attempts.
rush_yardsFloat64Total yards the team gained on rush plays.
yards_per_rushFloat64Yards gained per rushing attempt.
rushing_power_rateFloat64Share of carries that were power rushing attempts.
rushing_first_downs_createdInt64Number of first downs created on rush plays.
rushing_first_downs_created_rateFloat64Share of rush plays that created a first down.
EPA_rushing_overallFloat64Total EPA on rush plays.
EPA_rushing_per_playFloat64EPA per rush play.
EPA_explosive_rushingInt64Count of explosive rush plays. A play count, not an EPA total.
EPA_explosive_rushing_rateFloat64Explosive-play rate on rush plays, over ESPN's qualifying-play denominator.
EPA_non_explosive_rushingFloat64Total EPA on rush plays with explosive plays excluded.
EPA_non_explosive_rushing_per_playFloat64EPA per rush play with explosive plays excluded.
passesInt64Number of pass plays the team ran.
pass_yardsFloat64Total yards the team gained on pass plays.
yards_per_passFloat64Team game yards per pass.
passing_first_downs_createdInt64Number of first downs created on pass plays.
passing_first_downs_created_rateFloat64Share of pass plays that created a first down.
EPA_passing_overallFloat64Total EPA on pass plays.
EPA_passing_per_playFloat64EPA per pass play.
EPA_explosive_passingInt64Count of explosive pass plays. A play count, not an EPA total.
EPA_explosive_passing_rateFloat64Explosive-play rate on pass plays, over ESPN's qualifying-play denominator.
EPA_non_explosive_passingFloat64Total EPA on pass plays with explosive plays excluded.
EPA_non_explosive_passing_per_playFloat64EPA per pass play with explosive plays excluded.
scrimmage_playsInt64Number of plays from scrimmage (rushes plus passes), excluding special teams.
EPA_overall_offFloat64Total offensive EPA for the team. Duplicated exactly by EPA_overall_offense in every published season checked -- prefer one and ignore the other.
EPA_overall_offenseFloat64Total offensive EPA. An exact duplicate of EPA_overall_off.
EPA_per_playFloat64Offensive EPA per play.
EPA_non_explosiveFloat64Total EPA with explosive plays excluded, isolating the team's routine-down production.
EPA_non_explosive_per_playFloat64EPA per play with explosive plays excluded.
EPA_explosiveInt64Count of explosive plays, per ESPN's advanced box score. Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_explosive_rateFloat64Explosive-play rate. Note this is NOT EPA_explosive divided by EPA_plays -- ESPN divides by its own smaller qualifying-play count, so deriving it yourself will not reproduce this value.
passes_rateFloat64Share of the team's plays from scrimmage that were pass plays.
off_yardsInt64Offensive yards gained from scrimmage.
total_off_yardsInt64Total offensive yards across all plays.
yards_per_playFloat64Yards gained per play.
EPA_playsInt64Number of plays ESPN's advanced box score scored for the team.
total_yardsInt64Total yards the team gained across all plays.
EPA_overall_totalFloat64Total EPA across all phases, which is why it differs from the offense-only EPA_overall_off.
rushes_rateFloat64Share of the team's plays from scrimmage that were rush plays.
first_downs_createdInt64Number of first downs the team created.
first_downs_created_rateFloat64Share of the team's plays that created a first down.
EPA_rushing_powerFloat64Total EPA on power rushing situations, as classified by ESPN's advanced box score.
EPA_rushing_power_per_playFloat64EPA per play on power rushing situations.
rushing_power_successInt64Count of power rushing attempts that gained the yardage needed. An integer count, not a rate -- the rate is published separately as rushing_power_success_rate.
rushing_power_success_rateFloat64Share of power rushing attempts that succeeded.
rushing_powerInt64Count of power rushing attempts, in short-yardage situations as classified by ESPN's advanced box score.
rushing_stuffInt64Count of stuffed rushing attempts.
rushing_stuff_rateFloat64Share of the team's carries that were stuffed at or behind the line of scrimmage.
rushing_stoppedInt64Count of rushing attempts stopped at or behind the line of scrimmage.
rushing_stopped_rateFloat64Share of carries stopped at or behind the line of scrimmage.
rushing_opportunityInt64Count of rushing opportunities -- carries that reached ESPN's opportunity threshold.
rushing_opportunity_rateFloat64Share of carries that qualified as rushing opportunities.
rushing_highlightInt64Highlight yards -- rushing yardage credited to the back rather than the offensive line.
rushing_highlight_rateFloat64Share of rushing yardage that was highlight (back-credited) yardage.
rushing_highlight_yardsFloat64Total highlight yards the team accumulated -- the yardage credited to ball carriers rather than the line. The per-carry figure is rushing_highlight_yards_per_opp.
line_yardsFloat64Line yards -- the portion of rushing yardage credited to the offensive line under the standard rushing decomposition. ESPN applies its own qualifying threshold for the yardage split.
line_yards_per_carryFloat64Line yards per rushing attempt.
second_level_yardsFloat64Second-level yards -- rushing yardage earned just beyond the line of scrimmage.
open_field_yardsFloat64Open-field yards -- rushing yardage earned well downfield, past the second level.
load_cfb_adv_team_gamelog(seasons=2024)