Skip to main content

CFB dataset loaders — Other: ratings–model_pbp

load_cfb_ratings​

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

Returns​

col_nametypedescription
seasonInt64Season (4-digit year).
team_idInt64ESPN team id.
adj_off_epaFloat64Opponent-adjusted offensive EPA per play: the team's raw per-game EPA on pass and rush plays net of each opponent's ridge-fitted defensive strength, averaged over its games.
adj_def_epaFloat64Opponent-adjusted EPA per play allowed, netted the same way as the offensive rating, so lower is better because it measures EPA surrendered.
adj_st_epaFloat64Special-teams composite in EPA units: per-play mean EPA on field goals, punts, and kick returns, each centered on that unit's league mean and summed across the three units.
adj_netFloat64adj_off_epa minus adj_def_epa, the team's overall efficiency rating in EPA per play; special teams is deliberately excluded.
fei_offFloat64Drive-level offensive rating from a ridge fit on per-drive EPA, the Fremeau-style drive-efficiency counterpart to adj_off_epa.
fei_defFloat64Drive-level defensive rating from the same per-drive ridge fit, on the same scale as fei_off.
fei_netFloat64fei_off minus fei_def, the team's overall drive-efficiency rating, with the ridge's dropped reference team pinned at zero.
gamesInt64Number of games included in the ATS summary.
off_paceFloat64Tempo measure: scrimmage plays (pass plus rush) per game, centering near 65 and used as the pace input to the totals model.
off_rankInt64Dense rank of adj_off_epa in descending order, so rank 1 is the season's most efficient offense.
def_rankInt64Dense rank of adj_def_epa in ascending order, so rank 1 is the season's stingiest defense.
net_rankInt64Dense rank of adj_net in descending order, so rank 1 is the season's strongest overall team.
net_zFloat64adj_net restated as a z-score against the mean and standard deviation of adj_net across the rated teams that season.
fei_off_rankInt64Dense rank of fei_off in descending order, so rank 1 is the season's most efficient drive offense.
fei_def_rankInt64Dense rank of fei_def in ascending order, so rank 1 is the season's stingiest drive defense.
fei_net_rankInt64Dense rank of fei_net in descending order, so rank 1 is the season's strongest overall drive-efficiency team.
load_cfb_ratings(seasons=2024)

load_cfb_recruiting_proj​

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

Returns​

col_nametypedescription
seasonInt64Season (4-digit year).
team_idInt64ESPN team id.
pred_winsFloat64Ridge projection of the team's season win total, fit strictly on prior seasons from talent composite, blue-chip ratio, offensive and defensive returning production, and prior wins.
pred_marginFloat64Ridge projection of the team's average per-game scoring margin, from the same preseason-known feature set as pred_wins.
pred_net_epaFloat64Reserved slot for a projected adjusted net EPA; it ships all-null because the adjusted-EPA training target is not currently loadable.
load_cfb_recruiting_proj(seasons=2024)

load_cfb_recruits​

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

Returns​

col_nametypedescription
seasonInt64Season (4-digit year).
team_idInt64ESPN team id.
team_id_247String247Sports' own team key for the recruit's committed or signed school; not interchangeable with the ESPN/CFBD team id.
teamStringTeam name.
recruit_idStringESPN recruit id.
player_nameString
starsInt64Recruit star rating on the 247Sports scale (2-5).
gradeFloat64ESPN recruit grade (0-100; 0 = not rated).
positionStringAthlete position.
load_cfb_recruits(seasons=2024)

load_cfb_returning_production​

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

Returns​

col_nametypedescription
seasonInt64Season (4-digit year).
team_idInt64ESPN team id.
off_returningFloat64Share of the team's prior-season offensive production returning for the season.
def_returningFloat64Share of the team's prior-season defensive production returning for the season.
overall_returningFloat64Usage-weighted blend of the offensive and defensive returning-production shares.
n_returningInt64Number of returning players counted in the returning-production calculation.
def_basisStringDefensive measure behind def_returning: "participants" when the production season is 2014+ (tackle volume -- tackles, assists, tackles for loss, shared sacks, passes defended -- from load_cfb_play_participants), "pbp_splash" for 2004-2013 (sacks, interceptions, pass breakups and forced fumbles from play-by-play ids; no tackle volume, so not on the same scale), "box" when that source's release is missing and the ESPN player box stood in; null when def_returning is null.
overall_basisString"offense+defense" when overall_returning is the usage-weighted blend of off_returning and def_returning; "offense" when the team has no defensive value (e.g. production season 2003), so overall_returning equals off_returning.
is_estimatedBooleanWhether the returning-production figures for the row were estimated rather than derived from complete data.
load_cfb_returning_production(seasons=2024)

load_cfb_player_box​

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

Returns​

col_nametypedescription
stat_1StringFirst value of ESPN's raw athlete stats array, written only when the category's key list does not line up with the stats list; on those rows the named per-category columns are all null.
stat_2StringSecond value of ESPN's raw athlete stats array, written only on rows where the category keys did not line up and the named columns could not be filled.
stat_3StringThird value of ESPN's raw athlete stats array, written only on rows where the category keys did not line up and the named columns could not be filled.
stat_4StringFourth value of ESPN's raw athlete stats array, written only on rows where the category keys did not line up and the named columns could not be filled.
stat_5StringFifth value of ESPN's raw athlete stats array, written only on rows where the category keys did not line up and the named columns could not be filled.
categoryStringCFBD stats category name (e.g. passing, rushing, defensive).
athlete_idInt64ESPN athlete id.
athlete_nameStringPlayer full name.
jerseyStringJersey number.
team_idInt64ESPN team id.
rushingAttemptsStringRushing attempts.
rushingYardsStringNet rushing yards gained.
yardsPerRushAttemptStringYards gained per rushing attempt.
rushingTouchdownsStringRushing touchdowns.
longRushingStringLongest rush of the game, in yards.
receptionsString
receivingYardsStringReceiving yards gained.
yardsPerReceptionStringYards gained per reception.
receivingTouchdownsStringReceiving touchdowns.
longReceptionStringLongest reception of the game, in yards.
totalTacklesStringPlayer's total tackles, solo plus assisted (ESPN box score).
soloTacklesStringPlayer's solo (unassisted) tackles (ESPN box score).
sacksStringSacks credited to the player (ESPN box score).
tacklesForLossStringPlayer's tackles made behind the line of scrimmage (ESPN box score).
passesDefendedStringPasses the player broke up or defended (ESPN box score).
hurriesStringQuarterback hurries credited to the player (ESPN box score).
defensiveTouchdownsStringTouchdowns the player scored on defense (ESPN box score).
interceptionsStringPassing interceptions.
interceptionYardsStringYards returned on interceptions.
interceptionTouchdownsStringTouchdowns scored on interception returns.
kickReturnsStringNumber of kickoff returns by the player (ESPN box score).
kickReturnYardsStringTotal kickoff-return yards by the player (ESPN box score).
yardsPerKickReturnStringAverage yards per kickoff return for the player (ESPN box score).
longKickReturnStringPlayer's longest kickoff return of the game, in yards (ESPN box score).
kickReturnTouchdownsStringKickoff returns the player took for touchdowns (ESPN box score).
fieldGoalsMade/fieldGoalAttemptsStringField goals made and attempted, as ESPN's combined string.
fieldGoalPctStringField-goal percentage.
longFieldGoalMadeStringLongest field goal made, in yards.
extraPointsMade/extraPointAttemptsStringExtra points made and attempted, as ESPN's combined string.
totalKickingPointsStringTotal points scored by kicking.
puntsStringPunts attempted.
puntYardsStringTotal punt yards.
grossAvgPuntYardsStringGross average yards per punt, before return yardage.
touchbacksStringPunts or kickoffs that resulted in a touchback.
puntsInside20StringPunts downed inside the opponent 20-yard line.
longPuntStringLongest punt of the game, in yards.
puntReturnsStringPunt returns attempted.
puntReturnYardsStringYards gained on punt returns.
yardsPerPuntReturnStringYards gained per punt return.
longPuntReturnStringLongest punt return of the game, in yards.
puntReturnTouchdownsStringTouchdowns scored on punt returns.
game_idInt64ESPN game identifier.
seasonInt64Season (4-digit year).
fumblesStringNumber of times the player fumbled in the game (ESPN box score).
fumblesLostStringNumber of the player's fumbles lost to the opponent (ESPN box score).
fumblesRecoveredStringNumber of fumbles the player recovered (ESPN box score).
completions/passingAttemptsStringCompletions and pass attempts, as ESPN's combined string.
passingYardsStringNet passing yards gained.
yardsPerPassAttemptStringYards gained per pass attempt.
passingTouchdownsStringPassing touchdowns.
adjQBRStringAdjusted Total QBR for the quarterback.
load_cfb_player_box(seasons=2024)

load_cfb_drives​

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

Returns​

col_nametypedescription
drive_idStringCFBD drive identifier the play belongs to.
team_idInt64ESPN team id.
resultStringDrive result code (e.g. PUNT, TD).
display_resultStringDrive-result label (e.g. Punt, Touchdown).
short_display_resultStringShort drive-result label.
descriptionStringESPN's description of the stat.
yardsInt64Total yards gained on the drive.
offensive_playsInt64Number of offensive plays on the drive.
is_scoreBooleanTRUE if the drive resulted in a score.
start_periodInt64Period (quarter) in which the drive starts.
start_yard_lineInt64Yard line at the start of the play.
start_clockStringGame clock display value at the start of the drive.
start_textStringField-position text at the start of the drive.
end_periodInt64Period (quarter) in which the drive ends.
end_yard_lineInt64Yard line at the end of the play.
end_clockStringGame clock display value at the end of the drive.
time_elapsedStringElapsed game time for the drive (MM:SS).
n_playsInt64Number of entries in ESPN's raw plays array for the drive, which is generally at least offensive_plays because it also counts penalties and other non-offensive snaps.
game_idInt64ESPN game identifier.
seasonInt64Season (4-digit year).
load_cfb_drives(seasons=2024)

load_cfb_play_participants​

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

Returns​

col_nametypedescription
game_idInt64ESPN game identifier.
play_idInt64ESPN play id.
kicker_player_nameStringDisplay name of the kicker -- the FIRST participant in that role on the play.
returner_player_nameStringDisplay name of the player returning the kick or punt -- the FIRST participant in that role on the play.
tackler_player_nameStringDisplay name of a defender credited with the tackle -- the FIRST participant in that role on the play.
rusher_player_nameStringDisplay name of the ball carrier on a rush -- the FIRST participant in that role on the play.
passer_player_nameStringDisplay name of the passer -- the FIRST participant in that role on the play.
receiver_player_nameStringDisplay name of the targeted receiver -- the FIRST participant in that role on the play.
assisted_by_player_nameStringDisplay name of a defender credited with an assisted tackle -- the FIRST participant in that role on the play.
scorer_player_nameStringDisplay name of the player credited with the score -- the FIRST participant in that role on the play.
pat_scorer_player_nameStringDisplay name of the player credited with the point-after score -- the FIRST participant in that role on the play.
punter_player_nameStringDisplay name of the punter -- the FIRST participant in that role on the play.
pass_defender_player_nameStringDisplay name of the defender credited with defending the pass -- the FIRST participant in that role on the play.
sacked_by_player_nameStringDisplay name of a defender credited with the sack -- the FIRST participant in that role on the play.
penalized_player_nameStringDisplay name of the penalized player -- the FIRST participant in that role on the play.
pat_passer_player_nameStringDisplay name of the passer on the point-after attempt -- the FIRST participant in that role on the play.
kicker_player_idStringESPN athlete id of the kicker -- the FIRST participant in that role on the play.
returner_player_idStringESPN athlete id of the player returning the kick or punt -- the FIRST participant in that role on the play.
tackler_player_idStringESPN athlete id of a defender credited with the tackle -- the FIRST participant in that role on the play.
rusher_player_idStringESPN athlete id of the ball carrier on a rush -- the FIRST participant in that role on the play.
passer_player_idStringESPN athlete id of the passer -- the FIRST participant in that role on the play.
receiver_player_idStringESPN athlete id of the targeted receiver -- the FIRST participant in that role on the play.
assisted_by_player_idStringESPN athlete id of a defender credited with an assisted tackle -- the FIRST participant in that role on the play.
scorer_player_idStringESPN athlete id of the player credited with the score -- the FIRST participant in that role on the play.
pat_scorer_player_idStringESPN athlete id of the player credited with the point-after score -- the FIRST participant in that role on the play.
punter_player_idStringESPN athlete id of the punter -- the FIRST participant in that role on the play.
pass_defender_player_idStringESPN athlete id of the defender credited with defending the pass -- the FIRST participant in that role on the play.
sacked_by_player_idStringESPN athlete id of a defender credited with the sack -- the FIRST participant in that role on the play.
penalized_player_idStringESPN athlete id of the penalized player -- the FIRST participant in that role on the play.
pat_passer_player_idStringESPN athlete id of the passer on the point-after attempt -- the FIRST participant in that role on the play.
kicker_player_namesStringList of the display names of EVERY participant credited as the kicker on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
returner_player_namesStringList of the display names of EVERY participant credited as the player returning the kick or punt on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
tackler_player_namesStringList of the display names of EVERY participant credited as a defender credited with the tackle on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
rusher_player_namesStringList of the display names of EVERY participant credited as the ball carrier on a rush on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
passer_player_namesStringList of the display names of EVERY participant credited as the passer on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
receiver_player_namesStringList of the display names of EVERY participant credited as the targeted receiver on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
assisted_by_player_namesStringList of the display names of EVERY participant credited as a defender credited with an assisted tackle on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
scorer_player_namesStringList of the display names of EVERY participant credited as the player credited with the score on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
pat_scorer_player_namesStringList of the display names of EVERY participant credited as the player credited with the point-after score on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
punter_player_namesStringList of the display names of EVERY participant credited as the punter on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
pass_defender_player_namesStringList of the display names of EVERY participant credited as the defender credited with defending the pass on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
sacked_by_player_namesStringList of the display names of EVERY participant credited as a defender credited with the sack on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
penalized_player_namesStringList of the display names of EVERY participant credited as the penalized player on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
pat_passer_player_namesStringList of the display names of EVERY participant credited as the passer on the point-after attempt on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
kicker_player_idsStringList of the athlete ids of EVERY participant credited as the kicker on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
returner_player_idsStringList of the athlete ids of EVERY participant credited as the player returning the kick or punt on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
tackler_player_idsStringList of the athlete ids of EVERY participant credited as a defender credited with the tackle on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
rusher_player_idsStringList of the athlete ids of EVERY participant credited as the ball carrier on a rush on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
passer_player_idsStringList of the athlete ids of EVERY participant credited as the passer on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
receiver_player_idsStringList of the athlete ids of EVERY participant credited as the targeted receiver on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
assisted_by_player_idsStringList of the athlete ids of EVERY participant credited as a defender credited with an assisted tackle on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
scorer_player_idsStringList of the athlete ids of EVERY participant credited as the player credited with the score on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
pat_scorer_player_idsStringList of the athlete ids of EVERY participant credited as the player credited with the point-after score on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
punter_player_idsStringList of the athlete ids of EVERY participant credited as the punter on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
pass_defender_player_idsStringList of the athlete ids of EVERY participant credited as the defender credited with defending the pass on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
sacked_by_player_idsStringList of the athlete ids of EVERY participant credited as a defender credited with the sack on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
penalized_player_idsStringList of the athlete ids of EVERY participant credited as the penalized player on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
pat_passer_player_idsStringList of the athlete ids of EVERY participant credited as the passer on the point-after attempt on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
seasonInt64Season (4-digit year).
weekInt64Game week of the season.
recoverer_player_nameStringDisplay name of the player who recovered the fumble -- the FIRST participant in that role on the play.
fumbler_player_nameStringDisplay name of the first (primary) player who fumbled on the play, from ESPN's per-play participants.
forced_by_player_nameStringDisplay name of the defender who forced the fumble -- the FIRST participant in that role on the play.
recoverer_player_idStringESPN athlete id of the player who recovered the fumble -- the FIRST participant in that role on the play.
fumbler_player_idStringESPN athlete id of the first (primary) player who fumbled on the play.
forced_by_player_idStringESPN athlete id of the defender who forced the fumble -- the FIRST participant in that role on the play.
recoverer_player_namesStringList of the display names of EVERY participant credited as the player who recovered the fumble on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
fumbler_player_namesStringDisplay names of every player who fumbled on the play, as a list.
forced_by_player_namesStringList of the display names of EVERY participant credited as the defender who forced the fumble on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
recoverer_player_idsStringList of the athlete ids of EVERY participant credited as the player who recovered the fumble on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
fumbler_player_idsStringESPN athlete ids of every player who fumbled on the play, as a list.
forced_by_player_idsStringList of the athlete ids of EVERY participant credited as the defender who forced the fumble on the play, so multi-entry roles such as split sacks or gang tackles are not collapsed to one.
kicker_position_idStringESPN position id of the kicker -- the FIRST participant in that role on the play, as listed in the game's participants.
returner_position_idStringESPN position id of the player returning the kick or punt -- the FIRST participant in that role on the play, as listed in the game's participants.
penalized_position_idStringESPN position id of the penalized player -- the FIRST participant in that role on the play, as listed in the game's participants.
passer_position_idStringESPN position id of the passer -- the FIRST participant in that role on the play, as listed in the game's participants.
receiver_position_idStringESPN position id of the targeted receiver -- the FIRST participant in that role on the play, as listed in the game's participants.
assisted_by_position_idStringESPN position id of a defender credited with an assisted tackle -- the FIRST participant in that role on the play, as listed in the game's participants.
tackler_position_idStringESPN position id of a defender credited with the tackle -- the FIRST participant in that role on the play, as listed in the game's participants.
punter_position_idStringESPN position id of the punter -- the FIRST participant in that role on the play, as listed in the game's participants.
rusher_position_idStringESPN position id of the ball carrier on a rush -- the FIRST participant in that role on the play, as listed in the game's participants.
pass_defender_position_idStringESPN position id of the defender credited with defending the pass -- the FIRST participant in that role on the play, as listed in the game's participants.
scorer_position_idStringESPN position id of the player credited with the score -- the FIRST participant in that role on the play, as listed in the game's participants.
pat_scorer_position_idStringESPN position id of the player credited with the point-after score -- the FIRST participant in that role on the play, as listed in the game's participants.
sacked_by_position_idStringESPN position id of a defender credited with the sack -- the FIRST participant in that role on the play, as listed in the game's participants.
recoverer_position_idStringESPN position id of the player who recovered the fumble -- the FIRST participant in that role on the play, as listed in the game's participants.
fumbler_position_idStringESPN position id of the fumbler -- the FIRST participant in that role on the play, as listed in the game's participants.
forced_by_position_idStringESPN position id of the defender who forced the fumble -- the FIRST participant in that role on the play, as listed in the game's participants.
pat_passer_position_idStringESPN position id of the passer on the point-after attempt -- the FIRST participant in that role on the play, as listed in the game's participants.
load_cfb_play_participants(seasons=2024)

load_cfb_game_rosters​

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

Returns​

col_nametypedescription
athlete_idInt64ESPN athlete id.
athlete_uidString
athlete_guidString
athlete_typeString
first_nameStringAthlete first name.
last_nameStringAthlete last name.
full_nameStringVenue full name (e.g. Tenney Stadium).
athlete_display_nameStringPlayer display name.
short_nameStringRanking source short name (e.g. AP Poll).
weightFloat64Listed weight (lbs).
display_weightStringHuman-readable weight (e.g. 205 lbs).
heightFloat64Listed height (inches).
display_heightStringHuman-readable height (e.g. 6' 1").
slugStringURL slug for the team.
jerseyStringJersey number.
linkedBoolean
activeBooleanTRUE if the player was active for the game.
alternate_ids_sdrString
birth_place_cityString
birth_place_stateString
birth_place_countryString
birth_country_alternate_idStringESPN's internal alternate identifier for the athlete's birth country, paired with birth_place_country and the flag fields.
birth_country_abbreviationString
headshot_hrefStringURL of the athlete headshot image.
headshot_altString
flag_hrefStringURL of the birth-country flag image hosted on ESPN's CDN under teamlogos/countries.
flag_altStringAlt text ESPN attaches to the birth-country flag image, which is the country's name spelled out.
flag_relStringStringified relationship list ESPN ships with the flag image; the only non-null value observed is a single country-flag entry.
experience_yearsFloat64Years of experience.
experience_display_valueString
experience_abbreviationString
status_idStringESPN commitment status id.
status_nameStringStatus-type key (e.g. STATUS_FINAL).
status_typeStringStatus type.
status_abbreviationString
hand_typeString
hand_abbreviationString
hand_display_valueString
starterBooleanTRUE if the athlete started the game.
jersey_rightStringSecondary or alternate jersey number display string from ESPN's roster record, distinct from the primary jersey number.
validBooleanTRUE if the roster entry is flagged valid by ESPN.
did_not_playBooleanTRUE if the athlete did not play.
display_nameStringHuman-readable metric name.
athlete_hrefStringESPN Core v2 API reference URL for the athlete's season record, ending in the athlete id.
position_hrefStringESPN Core v2 API reference URL for the position resource ESPN lists the athlete at.
statistics_hrefStringESPN Core v2 API reference URL for this athlete's stat line in this game, null for the roughly 71 percent of listed players who recorded no stats.
team_idInt64ESPN team id.
orderInt64Team order within the competition (0 = first).
home_awayStringhome or away.
winnerBooleanTRUE if this team won the game.
team_guidString
team_uidString
team_slugStringTeam slug for the stat row.
team_locationStringTeam location / school name.
team_nameStringTeam nickname.
team_nicknameStringTeam nickname label.
team_abbreviationStringTeam abbreviation.
team_display_nameStringFull team display name.
team_short_display_nameStringShort team display name.
team_colorStringPrimary team color.
team_alternate_colorStringAlternate team color.
is_activeBooleanWhether the team is currently active.
is_all_starBooleanWhether the team is an all-star team.
team_alternate_ids_sdrStringThe team's Sportradar alternate identifier, which maps one-to-one with team_id.
logo_hrefStringURL of the default team logo.
logo_dark_hrefStringURL of the dark-variant team logo.
game_idInt64ESPN game identifier.
seasonInt64Season (4-digit year).
weekInt64Game week of the season.
citizenshipString
middle_nameString
ageFloat64
date_of_birthStringPlayer date of birth (if published).
draft_display_textString
draft_roundFloat64
draft_yearFloat64
draft_selectionFloat64
nicknameStringTeam nickname / location label.
load_cfb_game_rosters(seasons=2024)

load_cfb_linescores​

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

Returns​

col_nametypedescription
team_idInt64ESPN team id.
periodInt64Period (quarter) number.
valueStringMetric value.
game_idInt64ESPN game identifier.
seasonInt64Season (4-digit year).
load_cfb_linescores(seasons=2024)

load_cfb_betting​

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

Returns​

col_nametypedescription
game_idInt64ESPN game identifier.
seasonInt64Season (4-digit year).
weekInt64Game week of the season.
game_spreadFloat64
over_underFloat64Pre-game over/under total from the selected provider.
home_favoriteBooleanTRUE if the home team is the favorite.
home_team_spreadFloat64
game_spread_availableBoolean
odds_sourceStringProvenance of the spread and over/under used for the game: summary_pickcenter when ESPN's own pickcenter carried them, core_odds_api when they came from the live odds endpoint, default when neither resolved, injected when supplied by an offline rebuild.
load_cfb_betting(seasons=2024)

load_cfb_fpi_weekly​

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

Returns​

col_nametypedescription
seasonInt64Season (4-digit year).
season_typeInt64ESPN season type (2 = regular, 3 = postseason).
weekInt64Game week of the season.
team_idInt64ESPN team id.
last_updatedStringTimestamp ESPN last refreshed the power index.
run_date_time_keyInt64ESPN's run key for the snapshot, as an integer timestamp (e.g. 20241021040000). This is the AS-OF date the snapshot represents, which is not the same as last_updated (when ESPN computed it); the gap between the two is what snapshot_is_contemporaneous flags.
snapshot_out_of_sequenceBooleanTrue when this snapshot was computed AFTER one belonging to a later week of the same season type -- so it cannot be read as an as-of-that-week rating. Almost always the week-1 slot, which ESPN overwrites with a late-season computation (2024 week 1 is stamped 2024-12-15). Filter these out for any point-in-time or backtest use.
fpiFloat64Football Power Index that measures team's true strength on net points scale; expected point margin vs average opponent on neutral field.
fpirankFloat64ESPN's FPI rank field. Agrees with rank on 99.4% of rows; on the ~0.6% where they differ it is stale -- it never matches the rank implied by the published fpi, while rank always does. Prefer rank.
projectedwFloat64Projected overall W-L, accounting for results to date and FPI-based projections for remaining scheduled games (and potential conference championship games). May not sum to a whole number because of differing number of games played in each simulation.
projectedlFloat64Projected overall Losses, accounting for results to date and FPI-based projections for remaining scheduled games (including potential conference championship games). May not sum to a whole number because of differing number of games played in each simulation.
projectedtNullProjected ties. Always null -- college football abolished ties in 1996, and ESPN emits the key beside projectedw/projectedl without ever populating it. Retained so the column set matches the upstream payload.
projectedwpctrankFloat64Rank among FBS teams by projected win percentage. ESPN publishes the rank without the underlying percentage; derive it from projectedw and projectedl.
probwinoutFloat64Percent of season simulations in which team won all remaining scheduled games as well as conference championship game (if applicable).
probwinconfFloat64Percent of season simulations in which team won its conference, incorporating chance of getting to and winning conference championship game (if applicable). Accounts for shared conference titles in conferences that allow them.
sosremainingrankFloat64Rank among all FBS teams of remaining schedule strength, from perspective of an average FBS team.
accomplishmentFloat64Reflects chance that an average Top 25 team would have team's record or better, given the schedule. On a 0 to 100 scale, where 100 is best.
accomplishmentrankFloat64Strength of Record rank. Reflects chance that an average Top 25 team would have team's record or better, given the schedule.
adjwinsFloat64Team's Wins adjusted for chance an average FBS team would have team's record or better, given the schedule.
adjlossesFloat64Team's Losses adjusted for chance an average FBS team would have team's record or better, given the schedule.
adjwinpctrankFloat64Rank among FBS teams by adjusted win percentage. ESPN publishes the rank without the underlying percentage; derive it from adjwins and adjlosses. 0 is an unranked placeholder, not a rank -- it appears where the underlying value is null.
gamecontrolFloat64Reflects chance that an average Top 25 team would control games from start to end the way this team did, given the schedule. On a 0 to 100 scale, where 100 is best.
gamecontrolrankFloat64Game Control rank. Reflects chance that an average Top 25 team would control games from start to end the way this team did, given the schedule.
adjavgingamewpFloat64Team's average in-game win probability adjusted for chance that an average FBS team would control games from start to end the way this team did, given the schedule.
adjavgingamewprankFloat64Rank among FBS teams by adjavgingamewp (average in-game win probability adjusted for opponent). Null for most pre-2019 snapshots. 0 is an unranked placeholder, not a rank.
avgingamewpFloat64Team's average in-game win probability across all plays of all games played, not adjusted for site or opponent.
avgingamewprankFloat64Team's average in-game win probability rank adjusted for chance that an average FBS team would control games from start to end the way this team did, given the schedule.
avgsosrankFloat64Rank among all FBS teams of games already played schedule strength, from perspective of an average Top 25 team.
topsosrankFloat64Rank among all FBS teams of games already played schedule strength, from perspective of an top FBS team.
epaoffenseFloat64Offensive component of FPI. Offensive contribution to expected point margin vs average opponent on neutral field.
epadefenseFloat64Defensive component of FPI. Defensive contribution to expected point margin vs average opponent on neutral field.
epaspecialteamsFloat64Special teams component of FPI. Special teams contribution to expected point margin vs average opponent on neutral field.
probwindivFloat64Percent of season simulations in which team won its conference division, for those conferences that have divisions.
probmakeplayoffsFloat64Chance to make the CFB Playoff, according to the Playoff Predictor.
probmaketitlegameFloat64Chance to make the CFB Playoff National Championship game, according to the Playoff Predictor.
numwinsFloat64Actual wins to date at the time of the snapshot. Distinct from projectedw (full-season projection) and adjwins (opponent-adjusted).
numlossesFloat64Actual losses to date at the time of the snapshot. Distinct from projectedl (full-season projection) and adjlosses (opponent-adjusted).
numtiesFloat64Actual ties to date. Never nonzero -- college football abolished ties in 1996; the column is null or 0 in every published row.
probwintitleFloat64Chance to win the CFB Playoff National Championship, according to the Playoff Predictor.
rankchange7daysFloat64FPI Rank change from previous week.
prob6winsFloat64Percent of season simulations in which a team won at least 6 games (typically bowl-eligible).
rankFloat64FPI rank among FBS teams for this snapshot (1 = best). Prefer this over fpirank: the two agree on 99.4% of rows, and on the ~0.6% where they differ, rank is always the one consistent with the published fpi value.
offefficiencyFloat64Offensive efficiency on 0-100 scale; based on offense's contribution to scoring margin on per-play basis, adjusted for strength of opposing defenses faced.
offefficiencyrankFloat64Team's offensive efficiency rank among all FBS teams.
defefficiencyFloat64Defensive efficiency on 0-100 scale; based on defense's contribution to scoring margin on per-play basis, adjusted for strength of opposing offenses faced.
defefficiencyrankFloat64Team's defensive efficiency rank among all FBS teams.
stefficiencyFloat64Special teams efficiency on 0-100 scale; based on special teams' contribution to scoring margin on per-play basis, adjusted for strength of opposing special teams faced.
stefficiencyrankFloat64Team's special teams efficiency rank among all FBS teams.
totefficiencyFloat64Net efficiency on 0-100 scale; incorporates offense, defense and special teams efficiencies into a single schedule-adjusted measure of per-play efficiency.
totefficiencyrankFloat64Team's overall efficiency rank among all FBS teams.
snapshot_is_contemporaneousBooleanTrue when the snapshot was computed inside its own season's window (August of the season year through February of the next), i.e. it is a live weekly run rather than a retrospective backfill. False for every row before 2015, which ESPN computed in one pass afterwards. A retrospective row is a reconstruction, not an as-of-week rating.
load_cfb_fpi_weekly(seasons=2024)

load_cfb_power_index​

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

Returns​

col_nametypedescription
seasonInt64Season (4-digit year).
game_idInt64ESPN game identifier.
team_idInt64ESPN team id.
teampredptdiffFloat64Expected margin of victory for the FPI favorite.
gameprojectionFloat64Team's predicted win percentage in this game at time of given BPI run.
matchupqualityFloat64A measure of projected competitiveness and excitement in the game, using a 0 to 100 scale, with 100 as the most exciting.
teamadjgamescoreNullA measure of how well a team performed compared to their expected performance and the expected performance of a typical top 25 team.
load_cfb_power_index(seasons=2024)

load_cfb_model_pbp​

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

Returns​

col_nametypedescription
game_idInt64ESPN game identifier.
idString247Sports referencing id for the recruit.
sequenceNumberString
game_play_numberInt64Sequential play number within the game (excludes timeouts/end markers).
drive.idStringESPN's drive identifier, formed as the game id followed by the drive's sequence number within that game.
seasonInt64Season (4-digit year).
weekInt64Game week of the season.
periodInt64Period (quarter) number.
pos_teamInt64Team name in possession at the start of the play (offense, kickoff-aware).
def_pos_teamInt64Team name on defense at the start of the play.
start.pos_team.nameStringSchool name of the team with possession at the snap, taken from ESPN's team location field so it carries no mascot.
homeTeamIdInt64ESPN team id of the home team, read off the game header and stamped on every play.
awayTeamIdInt64ESPN team id of the away team, read off the game header and stamped on every play.
homeTeamNameStringHome team's school name from ESPN's team location field, without the mascot.
awayTeamNameStringAway team's school name from ESPN's team location field, without the mascot.
type.textStringESPN's play-type label, for example Rush, Pass Reception, Sack, Punt, Penalty, or Timeout.
textStringFull play description.
start.downInt64Down at the snap as ESPN reports it; 0 marks the small share of rows ESPN leaves without a down, overwhelmingly timeouts and penalty administrations.
start.distanceInt64Yards the offense needs for a first down at the snap, carried through from ESPN without correction.
start.yardsToEndzoneInt64Distance in yards from the offense's spot at the snap to the opponent's end zone, ranging 0 to 100.
pos_score_diff_startInt64Score differential for the possession team at the start of the play.
start.TimeSecsRemInt64Seconds remaining in the half from ESPN's clock stamp for this play, which is the end-of-play time in 2005 and 2007+ (the snap time in 2004 and most of 2006); tops out at 1800.
start.is_homeBooleanTrue when the team holding possession at the snap is the home team.
passing_downBooleanTrue on second and eight or longer, third and five or longer, or fourth and five or longer, the standard obvious-passing-situation flag.
passBooleanBinary flag for a passing play (includes sacks).
rushBooleanBinary flag for a rushing play.
completionBooleanBinary flag for a completed pass.
scoring_playBooleanTRUE if the play resulted in a score.
statYardageInt64Yards gained on the play as ESPN reports it, negative on plays that lost yardage.
passer_player_nameStringDisplay name of the passer -- the FIRST participant in that role on the play.
ep_beforeFloat64Expected points value before the play (cfbfastR EPA model).
ep_afterFloat64Expected points value after the play (cfbfastR EPA model).
epaFloat64
wp_beforeFloat64Win probability for the possession team before the play (0-1).
wp_afterFloat64Win probability for the possession team after the play (0-1).
wpaFloat64Win Probability Added on the play (cfbfastR WP model output).
completion_probFloat64Modelled probability the pass is completed.
cpoeFloat64
model_pbp_versionStringVersion of the model-scored play-by-play build.
cp_model_versionStringVersion of the completion-probability model that scored the play.
ep_model_versionStringVersion of the expected-points model that scored the play.
wp_model_versionStringVersion of the win-probability model that scored the play.
scored_dateStringDate on which the play was scored by the models.
load_cfb_model_pbp(seasons=2024)