Skip to contents

Loads the cfbfastR-schema-shaped variant of the stats.ncaa.org men's football play-by-play – the same plays as load_ncaa_mfb_pbp() reshaped onto cfbfastR pbp column conventions for cross-source binds. Published to the ncaa_mfb_pbp_cfbfastr release tag on the sportsdataverse-data repo.

Usage

load_ncaa_mfb_pbp_cfbfastr(
  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 2013 through the most recent season. Pass seasons = TRUE for every published season. (Min: 2013)

...

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_nametypesdescription
game_idinteger
id_playinteger
drive_idinteger
game_play_numberinteger
half_play_numberinteger
drive_play_numberinteger
drive_numberinteger
seasoninteger
yearinteger
weekinteger
periodinteger
halfinteger
clock.minutesinteger
clock.secondsinteger
TimeSecsReminteger
Under_twological
pos_teamcharacter
def_pos_teamcharacter
offense_playcharacter
defense_playcharacter
homecharacter
awaycharacter
pos_team_scoreinteger
def_pos_team_scoreinteger
offense_scoreinteger
defense_scoreinteger
pos_score_diffinteger
score_ptsinteger
scoring_playlogical
scoringlogical
downinteger
distanceinteger
yard_linecharacter
yards_to_goalinteger
yards_to_goal_endinteger
Goal_To_Gological
log_ydstogodouble
yards_gainedinteger
play_typecharacter
orig_play_typecharacter
play_textcharacter
rushlogical
rush_tdlogical
passlogical
pass_tdlogical
pass_attemptlogical
completionlogical
targetlogical
sacklogical
sack_veclogical
intlogical
int_tdlogical
turnover_veclogical
downs_turnoverlogical
touchdownlogical
td_playlogical
safetylogical
fumble_veclogical
puntlogical
punt_playlogical
kickoff_playlogical
kick_playlogical
fg_indslogical
fg_madelogical
punt_blockedlogical
punt_fair_catchlogical
firstD_by_yardslogical
firstD_by_penaltylogical
penalty_flaglogical
penalty_no_playlogical
penalty_declinedlogical
penalty_offsetlogical
penalty_textcharacter
yds_penaltyinteger
rusher_player_namecharacter
passer_player_namecharacter
receiver_player_namecharacter
interception_player_namecharacter
punter_player_namecharacter
punt_returner_player_namecharacter
fg_kicker_player_namecharacter
kickoff_player_namecharacter
kickoff_returner_player_namecharacter
yds_rushedinteger
yds_receivinginteger
yds_sackedinteger
yds_puntedinteger
yds_punt_returninteger
yds_kickoffinteger
yds_kickoff_returninteger
yds_int_returninteger
yds_fginteger
drive_resultcharacter
drive_scoringlogical
ot_synthesizedlogical
lag_pos_teamcharacter
lead_pos_teamcharacter
lag_play_typecharacter
lead_play_typecharacter
lag_play_textcharacter
lead_play_textcharacter
change_of_pos_teamlogical
play_after_turnoverlogical
n_plays_in_gameinteger
espn_game_idcharacter

Author

Saiem Gilani

Examples

# \donttest{
  try(load_ncaa_mfb_pbp_cfbfastr(2013))
#> ── NCAA men's football play-by-play, cfbfastR-shaped from the SportsDataverse da
#>  Data updated: 2026-08-27 04:23:07 UTC
#> # A tibble: 304,146 × 105
#>    game_id  id_play drive_id game_play_number half_play_number drive_play_number
#>      <int>  <int64>    <int>            <int>            <int>             <int>
#>  1  688871     6.e9 68887101                1                1                 1
#>  2  688871     6.e9 68887101                2                2                 2
#>  3  688871     6.e9 68887101                3                3                 3
#>  4  688871     6.e9 68887101                4                4                 4
#>  5  688871     6.e9 68887102                5                5                 1
#>  6  688871     6.e9 68887102                6                6                 2
#>  7  688871     6.e9 68887102                7                7                 3
#>  8  688871     6.e9 68887102                8                8                 4
#>  9  688871     6.e9 68887102                9                9                 5
#> 10  688871     6.e9 68887102               10               10                 6
#> # ℹ 304,136 more rows
#> # ℹ 99 more variables: drive_number <int>, season <int>, year <int>,
#> #   week <int>, period <int>, half <int>, clock.minutes <int>,
#> #   clock.seconds <int>, TimeSecsRem <int>, Under_two <lgl>, pos_team <chr>,
#> #   def_pos_team <chr>, offense_play <chr>, defense_play <chr>, home <chr>,
#> #   away <chr>, pos_team_score <int>, def_pos_team_score <int>,
#> #   offense_score <int>, defense_score <int>, pos_score_diff <int>, …
# }