load_espn_cfb_adv_defensive: *Load college football advanced defensive from the...

In cfbfastR: Access College Football Play by Play Data

Load college football advanced defensive from the SportsDataverse data repo

Description

Loads season-level advanced defensive team stats – one row per defense with havoc, TFL, drive-stop, and pass-rush aggregates. Published to the espn_cfb_adv_defensive release tag on the sportsdataverse-data repo.

Usage

load_espn_cfb_adv_defensive(
  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
def_pos_team_id	integer	ESPN team id of the team on defense. Present for every season 2004+.
def_pos_team	character
scrimmage_plays	integer	Number of plays from scrimmage (rushes plus passes), excluding special teams.
TFL	integer	Count of scrimmage plays the defense held to negative yardage (non-penalty, non-special-teams, ESPN statYardage below zero) plus every sack.
TFL_pass	integer	The TFL count restricted to plays classified as passes, so it covers sacks together with completions and laterals stopped behind the line.
TFL_rush	integer	The TFL count restricted to plays classified as rushes, that is rushing attempts the defense stopped for negative yardage.
havoc_total	integer
havoc_total_rate	double	Share of the defense's scrimmage plays producing a havoc event, a 0-to-1 fraction equal to havoc_total divided by scrimmage_plays.
fumbles	integer	Fumbles the defense forced, counted from plays whose narrative contains the phrase forced by, not the total number of fumbles on the play.
def_int	integer	Interceptions the defense recorded, counted from plays ESPN types as Interception Return or Interception Return Touchdown.
drive_stopped_rate	double	Percentage 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_plays	integer	Number of pass scrimmage plays the defense faced, the denominator behind havoc_total_pass_rate and sacks_rate.
havoc_total_pass	integer	Havoc events (tackle for loss, sack, interception, forced fumble, or pass breakup) recorded on the pass plays the defense faced.
havoc_total_pass_rate	double	havoc_total_pass divided by num_pass_plays, the defense's havoc rate against the pass as a 0-to-1 fraction.
sacks	integer
sacks_rate	double	Sacks divided by pass plays faced, the defense's per-pass-play sack rate as a 0-to-1 fraction.
pass_breakups	integer	Passes the defense broke up, counted from plays whose narrative contains the phrase broken up by.
havoc_total_rush	integer	Havoc events recorded on the rush plays the defense faced, in practice tackles for loss and forced fumbles.
havoc_total_rush_rate	double	Havoc events per rush play faced, the mean of the havoc flag over the defense's rush scrimmage plays.
game_id	integer
season	integer
week	integer

Author(s)

Saiem Gilani

Examples

  try(load_espn_cfb_adv_defensive(2004))

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