load_cfb_schedule_crosswalk: *Load college football schedule id crosswalk from the...

In cfbfastR: Access College Football Play by Play Data

Load college football schedule id crosswalk from the SportsDataverse data repo

Description

Loads the game-level id crosswalk linking CFBD game ids to ESPN event ids – one row per game-season. Published to the cfb_crosswalk release tag on the sportsdataverse-data repo.

Usage

load_cfb_schedule_crosswalk(
  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 2014 through the most recent season. Pass seasons = TRUE for every published season. (Min: 2014)
...	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
matchup_key	character	Order-independent key for the game: the two normalized team names sorted alphabetically and joined with a pipe.
espn_game_id	integer	ESPN game id for the crosswalk row.
fox_game_id	character	Fox Sports game id for the same game.
yahoo_game_id	character	Yahoo Sports game id for the same game.
yahoo_global_game_id	character	Yahoo's cross-season global game key in ncaaf.g.NNNN form, distinct from the date-encoded yahoo_game_id.
home_team	character
away_team	character
espn_date	character	Kickoff date as YYYY-MM-DD taken from ESPN's schedule, null on games that matched no ESPN row.
fox_date	character	Kickoff date as YYYY-MM-DD taken from the Fox Sports schedule, null on games that matched no Fox row.
yahoo_date	character	Kickoff date as YYYY-MM-DD, parsed from Yahoo's RFC-2822 start_time string.
matched_sources	character	Plus-joined provenance tag naming which of espn, fox, and yahoo actually supplied a row for this game.

Author(s)

Saiem Gilani

Examples

  try(load_cfb_schedule_crosswalk(2014))

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