
Load college football advanced passing from the SportsDataverse data repo
Source:R/load_espn_cfb.R
load_espn_cfb_adv_passing.RdLoads season-level advanced passing stats – one row per qualifying
passer with EPA, CPOE, air-yards, and pressure splits. Published to the
espn_cfb_adv_passing release tag on the sportsdataverse-data repo.
Usage
load_espn_cfb_adv_passing(
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 = TRUEfor every published season. (Min: 2004)- ...
Additional arguments passed to an underlying function that writes the season data into a database.
- dbConnection
A
DBIConnectionobject, as returned byDBI::dbConnect()- tablename
The name of the data table within the database
Value
Returns a cfbfastR_data tibble.
| col_name | types | description |
| pos_team_id | integer | ESPN team id of the team on offense. Present for every season 2004+. |
| pos_team | character | |
| passer_player_name | character | Display name of the passer – the FIRST participant in that role on the play. |
| Comp | integer | Completed passes recorded in the advanced box score. |
| Att | integer | Pass attempts recorded in the advanced box score. |
| xComp | double | Expected completions: the per-play completion probability (cp_game_state) summed over the passer's pass attempts, sacks excluded. |
| Yds | double | Passing yards from the advanced box score. |
| Pass_TD | integer | Passing touchdowns. |
| Int | integer | Interceptions thrown. |
| YPA | double | Yards per pass attempt. |
| EPA | double | |
| EPA_per_Play | double | EPA per play on the passer's plays. |
| WPA | double | |
| SR | double | Success rate on the passer's plays. |
| Sck | integer | Times the passer was sacked. |
| CompPct | double | Completion percentage from the advanced box score. |
| xCompPct | double | Expected completion rate on a 0-to-1 scale: xComp divided by Att (sacks excluded). 0 when Att is 0. |
| CPOE | double | Completion rate over expected: CompPct minus xCompPct, both over the passer's attempts (sacks excluded), as a 0-to-1 difference. |
| qbr_epa | double | EPA variant used as an input to the QBR calculation. |
| sack_epa | double | EPA credited to the player's sacks taken. |
| pass_epa | double | EPA credited to the player's pass plays. |
| rush_epa | double | EPA credited to the player's rush plays. |
| pen_epa | double | EPA attributable to penalties on the player's plays. |
| spread | double | |
| era0 | integer | Rule-era indicator for the earliest modelled era. |
| era1 | integer | Rule-era indicator for the second modelled era. |
| era2 | integer | Rule-era indicator for the third modelled era. |
| era3 | integer | Rule-era indicator for the most recent modelled era. |
| exp_qbr | double | Expected QBR for the passer. |
| game_id | integer | |
| season | integer | |
| week | integer |
Examples
# \donttest{
try(load_espn_cfb_adv_passing(2004))
#> ── college football advanced passing from the SportsDataverse data repo ────────
#> ℹ Data updated: 2026-10-12 13:09:12 UTC
#> # A tibble: 1,520 × 37
#> pos_team_id pos_team passer_player_name Comp Att xComp Yds Pass_TD Int
#> <int> <chr> <chr> <int> <int> <dbl> <dbl> <int> <int>
#> 1 30 USC Tro… Matt Leinart 19 29 16.6 272 3 0
#> 2 259 Virgini… Bryan Randall 14 29 16.5 153 1 1
#> 3 245 Texas A… Reggie McNeal 13 34 18.0 212 0 0
#> 4 254 Utah Ut… Alex Smith 21 29 17.9 359 3 0
#> 5 245 Texas A… Ty Branyon 6 8 4.01 60 0 0
#> 6 254 Utah Ut… Brian Johnson 1 2 1.24 11 0 0
#> 7 2050 Ball St… Joey Lynch 19 33 18.3 146 0 0
#> 8 103 Boston … Paul Peterson 13 24 13.6 140 1 1
#> 9 77 Northwe… Brett Basanez 37 59 31.2 495 4 1
#> 10 2628 TCU Hor… Tye Gunn 20 38 22.3 375 4 1
#> # ℹ 1,510 more rows
#> # ℹ 28 more variables: YPA <dbl>, EPA <dbl>, EPA_per_Play <dbl>, WPA <dbl>,
#> # SR <dbl>, Sck <int>, CompPct <dbl>, xCompPct <dbl>, CPOE <dbl>,
#> # AirYds <lgl>, aDOT <lgl>, CompAirYds <lgl>, YAC <lgl>, AirYdsPct <lgl>,
#> # qbr_epa <dbl>, sack_epa <dbl>, pass_epa <dbl>, rush_epa <dbl>,
#> # pen_epa <lgl>, spread <dbl>, era0 <int>, era1 <int>, era2 <int>,
#> # era3 <int>, exp_qbr <dbl>, game_id <int>, season <int>, week <int>
# }