Skip to main content
Version: 0.1.5

CFB dataset loaders — NCAA (stats.ncaa.org)

load_ncaa_mfb_pbp​

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

Returns​

col_nametypedescription
contest_idString
drive_numberInt64Sequential drive number within the game (1-indexed).
play_numberInt64Sequential play number within the game (1-indexed).
offenseStringFull name of the offense (team in possession) on the play.
drive_resultStringDrive result code (drive_-prefixed; every drive-level column is carried with this prefix).
drive_scoredBooleanWhether the possession containing this play ended in points for the offense.
downInt64Down of the play (1-4).
distanceInt64Yards to gain for a first down (or to the goal line in goal-to-go situations).
yard_lineStringField-position yard line at the start of the play (0-50 scale from the offense's side).
yard_line_sideStringWhich team's territory the ball was on at the snap ('OFF' own side, 'DEF' opponent side); pairs with yard_line_number for absolute field position.
yard_line_numberInt64Yard line at the snap (0-50); pairs with yard_line_side for absolute field position.
play_typeStringCFBD play type label (e.g. "Rush", "Pass Reception", "Field Goal Good").
clockStringGame clock display value at the play (MM:SS).
yards_gainedInt64Net yards gained by the offense on the play.
formationStringOffensive formation or personnel grouping reported for the play (e.g. 'Shotgun', 'I-Formation'), when the source narrative names it.
passerString
rusherString
receiverString
kickerStringName of the player who kicked off, punted, or attempted the field goal/PAT on this play.
punterStringName of the player who punted on this play.
returnerStringName of the player who fielded or returned the kickoff or punt on this play.
run_directionStringHole or side the ball carrier ran through on a rush play (e.g. 'left end', 'right guard'), when the narrative reports it.
qb_scrambleBoolean
pass_completeBooleanWhether a pass attempt on this play was completed.
pass_depthStringDepth classification of a pass attempt (e.g. 'short', 'deep'), when the narrative reports it.
pass_directionStringSide of the field the pass was thrown to (e.g. 'left', 'middle', 'right'), when the narrative reports it.
tackler_1StringName of the primary (first-listed) tackler on the play.
tackler_2StringName of the secondary (assisting) tackler on the play, when the narrative credits an assist.
kick_yardsInt64Yards traveled on a kickoff.
return_yardsInt64
punt_yardsInt64Gross yards traveled on a punt, before any return.
fg_distanceInt64Distance in yards of a field goal attempt.
fg_madeBooleanTRUE when the field goal attempt was successful.
is_first_downBooleanWhether the play resulted in a first down for the offense.
is_touchdownBooleanWhether the play resulted in a touchdown.
is_safetyBooleanWhether the play resulted in a safety.
is_fumbleBooleanWhether a fumble occurred on the play, regardless of which team recovered it.
is_turnoverBooleanTRUE if the play was a turnover.
turnover_typeStringKind of turnover on the play, if any (e.g. 'interception', 'fumble lost'); null when no turnover occurred.
out_of_boundsBoolean
no_playBooleanWhether the play was negated (e.g. by a penalty on the preceding down) and is excluded from drive/stat totals.
fair_catchBooleanWhether the returner called a fair catch on a kickoff or punt.
penalty_flagBooleanTRUE when a penalty was flagged on the play.
penalty_teamString
penalty_typeString
penalty_playerStringName of the player penalized on the play, when a penalty occurred.
penalty_yardsInt64
end_yard_lineStringYard line at the end of the play.
play_textStringFree-form text description of the play from the CFBD feed.
espn_game_idString
seasonInt64Season as a 4-digit starting year (integer). A 'YYYY-YY' string is not accepted.
load_ncaa_mfb_pbp(seasons=2024)

load_ncaa_mfb_pbp_cfbfastr​

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

Returns​

col_nametypedescription
game_idInt64ESPN game identifier.
id_playInt64Unique CFBD play identifier (concatenates game_id and play index).
drive_idInt64CFBD drive identifier the play belongs to.
game_play_numberInt64Sequential play number within the game (excludes timeouts/end markers).
half_play_numberInt64Sequential play number within the current half.
drive_play_numberInt64Sequential play number within the current drive.
drive_numberInt64Sequential drive number within the game (1-indexed).
seasonInt64Season as a 4-digit starting year (integer). A 'YYYY-YY' string is not accepted.
yearInt64Four-digit season year (e.g. 2019).
weekInt64Game week of the season.
periodInt64Period (quarter) number.
halfInt64Half indicator (1 or 2).
clock.minutesInt64Minutes remaining on the game clock at the start of the play (cfbfastR schema column).
clock.secondsInt64Seconds remaining within the current minute on the game clock at the start of the play (cfbfastR schema column).
TimeSecsRemInt64Seconds remaining in the half at the start of the play.
Under_twoBooleanTRUE when under two minutes remain in the half.
pos_teamStringTeam name in possession at the start of the play (offense, kickoff-aware).
def_pos_teamStringTeam name on defense at the start of the play.
offense_playStringOffensive team name as labeled by CFBD on the play.
defense_playStringDefensive team name as labeled by CFBD on the play.
homeStringHome team name.
awayStringAway team name.
pos_team_scoreInt64Score for the team in possession at the start of the play.
def_pos_team_scoreInt64Score for the defensive team at the start of the play.
offense_scoreInt64Offense team score at the start of the play.
defense_scoreInt64Defense team score at the start of the play.
pos_score_diffInt64Score differential from the possession team's perspective.
score_ptsInt64Points scored on the play.
scoring_playBooleanTRUE if the play resulted in a score.
scoringBooleanTRUE when the play results in a score (TD, FG, safety, two-point conversion).
downInt64Down of the play (1-4).
distanceInt64Yards to gain for a first down (or to the goal line in goal-to-go situations).
yard_lineStringField-position yard line at the start of the play (0-50 scale from the offense's side).
yards_to_goalInt64Distance in yards from the offense's spot to the opponent's goal line (0-100).
yards_to_goal_endInt64Yards to opponent end zone at the end of the play.
Goal_To_GoBooleanTRUE when the offense is in a goal-to-go situation.
log_ydstogoFloat64Natural log of distance-to-go (model feature).
yards_gainedInt64Net yards gained by the offense on the play.
play_typeStringCFBD play type label (e.g. "Rush", "Pass Reception", "Field Goal Good").
orig_play_typeStringOriginal CFBD play type label before cfbfastR cleaning.
play_textStringFree-form text description of the play from the CFBD feed.
rushBooleanBinary flag for a rushing play.
rush_tdBooleanBinary flag for a rushing touchdown.
passBooleanBinary flag for a passing play (includes sacks).
pass_tdBooleanBinary flag for a passing touchdown.
pass_attemptBooleanBinary flag for a pass attempt.
completionBooleanBinary flag for a completed pass.
targetBooleanBinary flag for a targeted receiver on the play.
sackBooleanBinary flag for a sack (duplicate of sack_vec for downstream use).
sack_vecBooleanBinary flag for a sack play.
intBooleanBinary flag for an interception.
int_tdBooleanBinary flag for an interception returned for a touchdown.
turnover_vecBooleanBinary flag for any play classified as a turnover.
downs_turnoverBooleanBinary flag for a turnover on downs.
touchdownBooleanBinary flag for a touchdown (duplicate of td_play for downstream use).
td_playBooleanBinary flag for a touchdown play.
safetyBooleanBinary flag for a safety.
fumble_vecBooleanBinary flag for a play involving a fumble.
puntBooleanBinary flag for a punt play.
punt_playBooleanBinary flag for any punt-related play (includes blocks/returns).
kickoff_playBooleanBinary flag for a kickoff play.
kick_playBooleanBinary flag for any kicking play (kickoff or field goal).
fg_indsBooleanBinary flag for a field goal attempt.
fg_madeBooleanTRUE when the field goal attempt was successful.
punt_blockedBooleanBinary flag for a blocked punt.
punt_fair_catchBooleanBinary flag for a punt fair catch.
firstD_by_yardsBooleanBinary flag for a new first down via yards gained.
firstD_by_penaltyBooleanBinary flag for a new first down via penalty.
penalty_flagBooleanTRUE when a penalty was flagged on the play.
penalty_no_playBooleanTRUE when the penalty nullified the play (no play counted).
penalty_declinedBooleanTRUE when the penalty was declined.
penalty_offsetBooleanTRUE when offsetting penalties were called.
penalty_textStringTRUE when penalty information is detectable in the play text.
yds_penaltyInt64Yardage assessed on the penalty.
rusher_player_nameStringName of the rusher on a rushing play.
passer_player_nameStringName of the passer on a passing play.
receiver_player_nameStringName of the receiver on a passing play.
interception_player_nameStringName of the defender credited with the interception.
punter_player_nameStringName of the punter.
punt_returner_player_nameStringName of the punt returner.
fg_kicker_player_nameStringName of the field goal kicker.
kickoff_player_nameStringName of the kickoff specialist.
kickoff_returner_player_nameStringName of the kickoff returner.
yds_rushedInt64Rushing yards gained on the play.
yds_receivingInt64Receiving yards gained on the play.
yds_sackedInt64Yards lost on the sack.
yds_puntedInt64Yards the ball traveled on the punt.
yds_punt_returnInt64Yards gained on the punt return.
yds_kickoffInt64Yards the ball traveled on the kickoff.
yds_kickoff_returnInt64Yards gained on the kickoff return.
yds_int_returnInt64Yards gained on an interception return.
yds_fgInt64Distance of the field goal attempt in yards.
drive_resultStringDrive result code (drive_-prefixed; every drive-level column is carried with this prefix).
drive_scoringBooleanBinary flag for a scoring drive.
ot_synthesizedBooleanWhether this row's overtime clock/period fields were synthesized rather than sourced directly -- stats.ncaa.org reports no running clock in overtime, so OT plays are assigned a synthetic countdown.
lag_pos_teamStringPossession team on the previous play (lag value).
lead_pos_teamStringPossession team on the next play (lead value).
lag_play_typeStringPlay type on the previous play (lag value).
lead_play_typeStringPlay type on the next play (lead value).
lag_play_textStringPlay text from the previous play (lag value).
lead_play_textStringPlay text from the next play (lead value).
change_of_pos_teamBooleanBinary flag for change of possession-team on the play.
play_after_turnoverBooleanBinary flag indicating the play immediately following a turnover.
n_plays_in_gameUInt32Total number of plays in the game this row belongs to, repeated on every row for convenience.
espn_game_idString
load_ncaa_mfb_pbp_cfbfastr(seasons=2024)

load_ncaa_mfb_drives​

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

Returns​

col_nametypedescription
contest_idString
drive_numberInt64Sequential drive number within the game (1-indexed).
quarterInt64Quarter in which the drive started (1-4 for regulation, 5+ for overtime periods).
periodInt64Period (quarter) number.
teamStringTeam name.
start_periodInt64Period (quarter) in which the drive starts.
start_howStringHow the drive began (e.g. 'Kickoff', 'Interception', 'Fumble', 'Downs', 'Punt').
start_clockStringGame clock display value at the start of the drive.
start_yard_lineStringYard line at the start of the play.
end_periodInt64Period (quarter) in which the drive ends.
end_howStringHow the drive ended (e.g. 'Touchdown', 'Punt', 'Interception', 'Fumble', 'End of Half').
end_clockStringGame clock display value at the end of the drive.
end_yard_lineStringYard line at the end of the play.
n_playsInt64Number of plays run during the drive.
yardsInt64Total yards gained on the drive.
espn_game_idString
seasonInt64Season as a 4-digit starting year (integer). A 'YYYY-YY' string is not accepted.
load_ncaa_mfb_drives(seasons=2024)

load_ncaa_mfb_schedule​

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

Returns​

col_nametypedescription
team_idStringESPN team id.
team_nameStringTeam nickname.
dateStringDate of the poll release.
opponent_idStringESPN team id of the opponent.
opponentStringOpponent team name.
resultStringDrive result code (e.g. PUNT, TD).
outcomeStringResult of the game from the home team's perspective (e.g. 'W', 'L', 'T').
team_scoreInt64Offense team score at the time of the play.
opponent_scoreInt64Defense / opponent team score at the time of the play.
contest_idString
attendanceInt64Reported attendance at the game.
academic_yearInt32Academic year the game was played in (the ENDING year of the fall/spring split, e.g. 2025 for the 2024 fall season) -- distinct from season, which is the STARTING year.
espn_game_idString
seasonInt64Season as a 4-digit starting year (integer). A 'YYYY-YY' string is not accepted.
load_ncaa_mfb_schedule(seasons=2024)

load_ncaa_mfb_rosters​

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

Returns​

col_nametypedescription
team_idStringESPN team id.
team_nameStringTeam nickname.
player_idStringESPN player id from the roster entry.
player_nameString
jerseyStringJersey number.
statcrew_jerseyStringJersey number as recorded in the NCAA StatCrew roster feed; can differ from the number a player actually wears on a given game day.
player_classStringPlayer's academic/eligibility class (e.g. 'FR', 'SO', 'JR', 'SR', 'GR').
positionStringAthlete position.
heightStringListed height (inches).
weightInt64Listed weight (lbs).
hometownString
high_schoolString
games_playedInt64
games_startedInt64
academic_yearInt32Academic year the roster snapshot covers (the ENDING year of the fall/spring split) -- distinct from season, which is the STARTING year.
seasonInt64Season as a 4-digit starting year (integer). A 'YYYY-YY' string is not accepted.
load_ncaa_mfb_rosters(seasons=2024)

load_ncaa_mfb_teams​

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

Coverage

No conference column: for conference membership by season use load_cfb_team_group_seasons (the cfb_groups release).

Returns​

col_nametypedescription
team_idStringstats.ncaa.org team id. It is issued per season, so a school's id changes from year to year; it is not an ESPN id.
team_nameStringSchool name as stats.ncaa.org lists it, without the mascot.
academic_yearInt32Academic year the team record covers (the ENDING year of the fall/spring split) -- distinct from season, which is the STARTING year.
divisionInt32stats.ncaa.org division code, 11 = FBS and 12 = FCS; not a conference division (the table has no conference column).
seasonInt64Season as a 4-digit starting year (integer). A 'YYYY-YY' string is not accepted.
load_ncaa_mfb_teams(seasons=2024)

load_ncaa_mfb_team_stats​

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

Returns​

col_nametypedescription
contest_idString
categoryStringstats.ncaa.org box-score section the stat belongs to (Passing, Rushing, First Downs, Total Offense, Kicking, Punt Returns, Kickoffs and KO Returns, Sacks, Passes Defended); not a CFBD category.
statString
periodStringPeriod (quarter) number.
away_teamStringAway team name.
away_valueStringTeam-stat value for the away team; each row is one stat category for one game, wide by side.
home_teamStringHome team name.
home_valueStringTeam-stat value for the home team; each row is one stat category for one game, wide by side.
espn_game_idString
seasonInt64Season as a 4-digit starting year (integer). A 'YYYY-YY' string is not accepted.
load_ncaa_mfb_team_stats(seasons=2024)

load_ncaa_mfb_player_stats​

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

Returns​

col_nametypedescription
contest_idString
team_idStringESPN team id.
numberString
nameStringPosition name (e.g. Quarterback).
positionStringAthlete position.
rush_attemptsString
rush_yds_gainedStringTotal positive rushing yards gained on carries, before subtracting yards lost to tackles for loss.
rush_yds_lostStringTotal rushing yards lost to tackles for loss on carries.
yds_rushStringNet rushing yards (rush_yds_gained minus rush_yds_lost).
rush_tdsStringRushing touchdowns for the game. Populated only on this player-game's 'rushing' category row (null on the 'passing'/'receiving' rows for the same player-game) -- the loader returns one row per player-game-category.
rush_longStringLongest single rush of the game.
categoryStringCFBD stats category name (e.g. passing, rushing, defensive).
espn_game_idString
pass_attemptsStringPass attempts for the game. Populated only on this player-game's 'passing' category row (null on the 'rushing'/'receiving' rows for the same player-game) -- the loader returns one row per player-game-category.
completionsString
pass_yardsString
interceptionsStringPassing interceptions.
pass_tdsStringPassing touchdowns thrown for the game. Populated only on this player-game's 'passing' category row (null on the 'rushing'/'receiving' rows for the same player-game) -- the loader returns one row per player-game-category.
pass_effStringPasser efficiency rating for the game, per the NCAA passer-rating formula.
yds_per_completionStringPassing yards divided by completions.
pctString
long_passStringLongest completed pass of the game.
recStringTotal receptions for the game.
receiving_yardsString
yards_per_receptionStringReceiving yards divided by receptions.
rec_tdStringReceiving touchdowns.
long_recStringLongest reception of the game.
ydsStringYards recorded for the player in the stat category of the row (can be negative).
playsStringTotal qualifying passing plays included in the WEPA calculation.
pbuStringPasses broken up.
intStringBinary flag for an interception.
intydsStringInterception return yards (can be negative).
int_ret_tdsStringTouchdowns scored on interception returns.
pdefStringPasses defended, as emitted by the feed with a decimal component (e.g. '7.00').
ko_retStringKickoff returns.
ko_ret_ydsStringKickoff return yards.
kick_ret_tdsStringTouchdowns scored on kick returns.
long_korStringLongest kickoff return, in yards.
sacksStringTeam sacks.
solo_tackStringSolo (unassisted) tackles.
asst_tackStringAssisted tackles.
tacklesStringTeam tackles.
fgmString
fgaString
fg_blocks_allowedStringField goals blocked against the player's unit.
punt_retStringPunt returns fielded by the player.
punt_ret_ydsStringPunt return yards (can be negative).
punt_ret_tdsStringTouchdowns scored on punt returns.
long_prStringLongest punt return, in yards.
seasonInt64Season as a 4-digit starting year (integer). A 'YYYY-YY' string is not accepted.
load_ncaa_mfb_player_stats(seasons=2024)

load_ncaa_mfb_officials​

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

Returns​

col_nametypedescription
contest_idString
roleString
officialStringFlag indicating that the media item comes from the official league feed rather than an editorial source.
espn_game_idString
seasonInt64Season as a 4-digit starting year (integer). A 'YYYY-YY' string is not accepted.
load_ncaa_mfb_officials(seasons=2024)

load_ncaa_mfb_linescore​

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

Returns​

col_nametypedescription
contest_idString
teamStringTeam name.
home_awayStringhome or away.
periodStringPeriod (quarter) number.
pointsInt64Total points accumulated by the school in the poll's weighted voting.
finalInt64
game_dateStringKickoff date-time (ISO 8601, UTC).
venueStringVenue name.
attendanceInt64Reported attendance at the game.
espn_game_idString
seasonInt64Season as a 4-digit starting year (integer). A 'YYYY-YY' string is not accepted.
load_ncaa_mfb_linescore(seasons=2024)