load_espn_cfb_adv_team_gamelog: *Load college football advanced team gamelog from the...

In cfbfastR: Access College Football Play by Play Data

Load college football advanced team gamelog from the SportsDataverse data repo

Description

Loads season-level advanced team game logs – one row per team-game with the same advanced-stat profile at game grain. Published to the espn_cfb_adv_team_gamelog release tag on the sportsdataverse-data repo.

Usage

load_espn_cfb_adv_team_gamelog(
  seasons = most_recent_cfb_season(),
  ...,
  dbConnection = NULL,
  tablename = NULL
)

Arguments

seasons	A vector of 4-digit years associated with given college football seasons. Published coverage runs 2004 through the most recent season. Pass seasons = TRUE for every published season. (Min: 2004)
...	Additional arguments passed to an underlying function that writes the season data into a database.
dbConnection	A DBIConnection object, as returned by DBI::dbConnect()
tablename	The name of the data table within the database

Value

Returns a cfbfastR_data tibble.

col_name	types	description
season	integer
week	integer
season_type	integer
game_id	integer
start_date	character
team_id	integer
team	character
opponent_id	integer
opponent	character
is_home	logical
neutral_site	logical
points_for	integer
points_against	integer
margin	integer	Final scoring margin from this team's perspective, exactly points_for minus points_against.
win	logical
rushing_highlight_yards_per_opp	double	Highlight yards per rushing opportunity.
total_pen_yards	integer	Total penalty yards assessed.
EPA_penalty	double	Total EPA attributed to penalties.
penalty_first_downs_created	integer	Number of first downs the team gained via opponent penalty.
penalty_first_downs_created_rate	double	Share of the team's first downs that came via opponent penalty.
penalties	integer	Number of penalties assessed against the team.
penalty_yards	integer	Net penalty yardage assessed against the team; can be negative when enforcement moved the team forward on balance.
special_teams_plays	integer	Number of special-teams plays.
EPA_sp	double	Total special-teams EPA, ESPN's abbreviated field for the same phase.
EPA_special_teams	double	Total EPA generated on special-teams plays.
field_goals	integer	Number of field-goal attempts.
EPA_fg	double	Total EPA on field-goal attempts.
punt_plays	integer	Number of punt plays.
EPA_punt	double	Total EPA on punt plays.
kickoff_plays	integer	Number of kickoff plays.
EPA_kickoff	double	Total EPA on kickoff plays.
rushes	integer	Number of rushing attempts.
rush_yards	double	Total yards the team gained on rush plays.
yards_per_rush	double	Yards gained per rushing attempt.
rushing_power_rate	double	Share of carries that were power rushing attempts.
rushing_first_downs_created	integer	Number of first downs created on rush plays.
rushing_first_downs_created_rate	double	Share of rush plays that created a first down.
EPA_rushing_overall	double	Total EPA on rush plays.
EPA_rushing_per_play	double	EPA per rush play.
EPA_explosive_rushing	integer	Count of explosive rush plays. A play count, not an EPA total.
EPA_explosive_rushing_rate	double	Explosive-play rate on rush plays, over ESPN's qualifying-play denominator.
EPA_non_explosive_rushing	double	Total EPA on rush plays with explosive plays excluded.
EPA_non_explosive_rushing_per_play	double	EPA per rush play with explosive plays excluded.
passes	integer	Number of pass plays the team ran.
pass_yards	double	Total yards the team gained on pass plays.
yards_per_pass	double
passing_first_downs_created	integer	Number of first downs created on pass plays.
passing_first_downs_created_rate	double	Share of pass plays that created a first down.
EPA_passing_overall	double	Total EPA on pass plays.
EPA_passing_per_play	double	EPA per pass play.
EPA_explosive_passing	integer	Count of explosive pass plays. A play count, not an EPA total.
EPA_explosive_passing_rate	double	Explosive-play rate on pass plays, over ESPN's qualifying-play denominator.
EPA_non_explosive_passing	double	Total EPA on pass plays with explosive plays excluded.
EPA_non_explosive_passing_per_play	double	EPA per pass play with explosive plays excluded.
scrimmage_plays	integer	Number of plays from scrimmage (rushes plus passes), excluding special teams.
EPA_overall_off	double	Total offensive EPA for the team. Duplicated exactly by EPA_overall_offense in every published season checked -- prefer one and ignore the other.
EPA_overall_offense	double	Total offensive EPA. An exact duplicate of EPA_overall_off.
EPA_per_play	double	Offensive EPA per play.
EPA_non_explosive	double	Total EPA with explosive plays excluded, isolating the team's routine-down production.
EPA_non_explosive_per_play	double	EPA per play with explosive plays excluded.
EPA_explosive	integer	Count of explosive plays, per ESPN's advanced box score. Despite the EPA_ prefix this is a play COUNT, not an EPA total.
EPA_explosive_rate	double	Explosive-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_rate	double	Share of the team's plays from scrimmage that were pass plays.
off_yards	integer	Offensive yards gained from scrimmage.
total_off_yards	integer	Total offensive yards across all plays.
yards_per_play	double	Yards gained per play.
EPA_plays	integer	Number of plays ESPN's advanced box score scored for the team.
total_yards	integer	Total yards the team gained across all plays.
EPA_overall_total	double	Total EPA across all phases, which is why it differs from the offense-only EPA_overall_off.
rushes_rate	double	Share of the team's plays from scrimmage that were rush plays.
first_downs_created	integer	Number of first downs the team created.
first_downs_created_rate	double	Share of the team's plays that created a first down.
EPA_rushing_power	double	Total EPA on power rushing situations, as classified by ESPN's advanced box score.
EPA_rushing_power_per_play	double	EPA per play on power rushing situations.
rushing_power_success	integer	Count 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_rate	double	Share of power rushing attempts that succeeded.
rushing_power	integer	Count of power rushing attempts, in short-yardage situations as classified by ESPN's advanced box score.
rushing_stuff	integer	Count of stuffed rushing attempts.
rushing_stuff_rate	double	Share of the team's carries that were stuffed at or behind the line of scrimmage.
rushing_stopped	integer	Count of rushing attempts stopped at or behind the line of scrimmage.
rushing_stopped_rate	double	Share of carries stopped at or behind the line of scrimmage.
rushing_opportunity	integer	Count of rushing opportunities -- carries that reached ESPN's opportunity threshold.
rushing_opportunity_rate	double	Share of carries that qualified as rushing opportunities.
rushing_highlight	integer	Highlight yards -- rushing yardage credited to the back rather than the offensive line.
rushing_highlight_rate	double	Share of rushing yardage that was highlight (back-credited) yardage.
rushing_highlight_yards	double	Total 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_yards	double	Line 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_carry	double	Line yards per rushing attempt.
second_level_yards	double	Second-level yards -- rushing yardage earned just beyond the line of scrimmage.
open_field_yards	double	Open-field yards -- rushing yardage earned well downfield, past the second level.

Author(s)

Saiem Gilani

Examples

  try(load_espn_cfb_adv_team_gamelog(2004))

cfbfastR documentation built on Aug. 24, 2026, 5:13 p.m.