Skip to main content

MBB dataset loaders — Other

load_mbb_pbp​

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

Returns​

col_nametypedescription
game_play_numberInt32Sequential play number within the game.
idInt64Id.
sequence_numberInt32Sequence number representing a shot-possession (V3 PBP).
type_idInt32Type identifier (numeric).
type_textStringDisplay text for the type field.
textStringText description of the play / record.
away_scoreInt32Away team score at the time of the play.
home_scoreInt32Home team score at the time of the play.
period_numberInt32Numeric period (1-4 for quarters; 5+ for OT).
period_display_valueStringPeriod display label (e.g. '1st Quarter', 'OT').
clock_display_valueStringGame clock display string (e.g. '8:32').
scoring_playBooleanTRUE if the play resulted in points scored.
score_valueInt32Point value of the play (2 / 3 / 1).
team_idInt32Unique team identifier.
athlete_id_1Int32Primary athlete identifier (e.g. shooter).
wallclockStringWallclock.
shooting_playBooleanTRUE if the play was a shooting attempt.
points_attemptedInt32Point value at stake on the shot attempt (3 for threes, 2 for other field goals, 1 for free throws), from the ESPN play type.
short_descriptionStringShortened version of ESPN's play description text, without score context.
athlete_id_2Int32Secondary athlete identifier (e.g. assister / fouler).
game_idInt32Unique game identifier.
seasonInt32Season year.
season_typeInt32Season type (1=pre-season, 2=regular season, 3=postseason, 4=off-season for ESPN; or string label for WNBA Stats).
home_team_idInt32Unique identifier for the home team.
home_team_nameStringHome team name.
home_team_mascotStringHome team mascot.
home_team_abbrevStringHome team three-letter abbreviation.
home_team_name_altStringAlternate home team name.
away_team_idInt32Unique identifier for the away team.
away_team_nameStringAway team name.
away_team_mascotStringAway team mascot.
away_team_abbrevStringAway team three-letter abbreviation.
away_team_name_altStringAlternate away team name.
game_spreadFloat64Game spread (signed; positive = home favored).
home_favoriteBooleanTRUE if the home team is the betting favorite.
game_spread_availableBooleanTRUE if a point spread was available.
home_team_spreadFloat64Home team's point spread.
halfInt32Half of the game (1 or 2).
timeStringTime / clock value.
clock_minutesInt32Clock minutes split out for convenience.
clock_secondsInt32Clock seconds split out for convenience.
home_timeout_calledBooleanTrue when the home team called a timeout on the play.
away_timeout_calledBooleanTrue when the away team called a timeout on the play.
lag_periodInt32Period number of the previous play in the same game (period_number shifted forward one row within game_id), and null on each game's first play.
lead_periodInt32Period number of the next play in the same game (period_number shifted back one row within game_id), and null on each game's final play.
lag_halfInt32A lag column on the half
lead_halfInt32A lead column on the half
start_period_seconds_remainingInt32Seconds left in the current period when the play started, computed as 60 times the game clock minutes plus the seconds, so 1200 at the tip of each 20-minute half and 300 at the start of an overtime.
start_game_seconds_remainingInt32Seconds remaining in the game at the start of the play.
end_period_seconds_remainingInt32Seconds left in the period when the play ended.
end_game_seconds_remainingInt32Seconds remaining in the game at the end of the play.
game_dateDateGame date (YYYY-MM-DD).
game_date_timeDatetime(time_unit='us', time_zone='America/New_York')Game start date/time (ISO 8601).
coordinate_xFloat64X coordinate on the court (half-court layout).
coordinate_yFloat64Y coordinate on the court (half-court layout).
coordinate_x_rawFloat64X coordinate as returned by the API before any adjustment.
coordinate_y_rawFloat64Y coordinate as returned by the API before any adjustment.
athlete_name_1StringDisplay name of the first athlete in the ESPN play participants (e.g., the shooter on a shot attempt).
athlete_name_2StringDisplay name of the second athlete in the ESPN play participants (e.g., the assisting player), when present.
athlete_name_3StringDisplay name of the third athlete in the ESPN play participants, when present.
media_idStringMedia identifier (video / image).
pregame_home_probFloat64Model's pre-game win probability for the home team (0-1), constant within a game.
home_win_probFloat64Home win probability - pre-game prediction (0-1).
load_mbb_pbp(seasons=2024)

load_mbb_schedule​

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

Returns​

col_nametypedescription
idInt32Id.
uidStringESPN UID string.
dateStringDate in YYYY-MM-DD format.
attendanceFloat64Reported attendance.
time_validBooleanTime valid.
neutral_siteBooleanNeutral site.
conference_competitionBooleanConference competition.
play_by_play_availableBooleanWhether play-by-play data is available.
recentBooleanRecent.
start_dateStringStart date (YYYY-MM-DD).
broadcastStringBroadcast information string.
highlightsStringGame highlight urls.
notes_typeStringNotes type.
notes_headlineStringNotes headline.
broadcast_marketStringBroadcast market label (e.g. 'national', 'home').
broadcast_nameStringBroadcast name.
type_idInt32Type identifier (numeric).
type_abbreviationStringType abbreviation.
venue_idInt32Unique venue identifier.
venue_full_nameStringVenue full name.
venue_address_cityStringVenue address city.
venue_address_stateStringVenue address state / region.
venue_indoorBooleanTRUE if the venue is indoors.
status_clockFloat64Status clock.
status_display_clockStringStatus display clock.
status_periodFloat64Status period.
status_type_idInt32Unique identifier for status type.
status_type_nameStringStatus type name.
status_type_stateStringStatus type state.
status_type_completedBooleanStatus type completed.
status_type_descriptionStringStatus type description.
status_type_detailStringStatus type detail.
status_type_short_detailStringStatus type short detail.
format_regulation_periodsFloat64Format regulation periods.
home_idInt32Unique identifier for home.
home_uidStringHome team's uid.
home_locationStringHome team's location.
home_nameStringHome name.
home_abbreviationStringHome team's abbreviation.
home_display_nameStringHome display name.
home_short_display_nameStringHome short display name.
home_colorStringColor code (hex) for home.
home_alternate_colorStringColor code (hex) for home alternate.
home_is_activeBooleanHome team's is active.
home_venue_idInt32Unique identifier for home venue.
home_logoStringHome team logo URL.
home_conference_idInt32Unique identifier for home conference.
home_scoreInt32Home team score at the time of the play.
home_winnerBooleanHome team's winner.
home_current_rankFloat64Poll ranking ESPN listed for the home team at game time (unranked teams carry a sentinel value).
home_linescoresStringPeriod-by-period scores for the home team as a delimited string from ESPN's schedule feed.
home_recordsStringRecord strings (overall and split records) for the home team from ESPN's schedule feed.
away_idInt32Unique identifier for away.
away_uidStringAway team's uid.
away_locationStringAway team's location.
away_nameStringAway name.
away_abbreviationStringAway team's abbreviation.
away_display_nameStringAway display name.
away_short_display_nameStringAway short display name.
away_colorStringColor code (hex) for away.
away_alternate_colorStringColor code (hex) for away alternate.
away_is_activeBooleanAway team's is active.
away_venue_idInt32Unique identifier for away venue.
away_logoStringAway team logo URL.
away_conference_idInt32Unique identifier for away conference.
away_scoreInt32Away team score at the time of the play.
away_winnerBooleanAway team's winner.
away_current_rankFloat64Poll ranking ESPN listed for the away team at game time (unranked teams carry a sentinel value).
away_linescoresStringPeriod-by-period scores for the away team as a delimited string from ESPN's schedule feed.
away_recordsStringRecord strings (overall and split records) for the away team from ESPN's schedule feed.
game_idInt32Unique game identifier.
seasonInt32Season year.
season_typeInt32Season type (1=pre-season, 2=regular season, 3=postseason, 4=off-season for ESPN; or string label for WNBA Stats).
away_non_div1_teamBooleanESPN's non-Division I flag for the away team: True when the away team is not a Division I program (a lower-division or exhibition opponent, which also carries no away_conference_id); null, not False, for every Division I team. Sparse -- a handful of games per season.
status_type_alt_detailStringStatus type alt detail.
tournament_idInt32ESPN tournament identifier.
groups_idInt32Unique identifier for groups.
groups_nameStringGroups name.
groups_short_nameStringGroups short name.
groups_is_conferenceBooleanGroups is conference.
game_jsonBooleanWhether processed game JSON is available.
game_json_urlStringURL to the processed game JSON.
game_date_timeDatetime(time_unit='us', time_zone='America/New_York')Game start date/time (ISO 8601).
game_dateDateGame date (YYYY-MM-DD).
PBPBooleanWhether play-by-play data is available.
team_boxBooleanTeam box.
player_boxBooleanPlayer box.
load_mbb_schedule(seasons=2024)

load_mbb_ratings​

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

Returns​

col_nametypedescription
seasonInt64Season year.
team_idStringUnique team identifier.
adj_oFloat64Adj o.
adj_dFloat64Adj d.
adj_emFloat64Adj em.
adj_tempoFloat64Opponent-adjusted possessions per 40 minutes, solved by the same fixed point as the efficiency ratings under the additive model that a game's pace is the two teams' tempos less the league baseline; it averages about 71 in 2025.
raw_oFloat64Raw o.
raw_dFloat64Raw d.
gamesInt64Games played.
rankInt64Rank.
adj_em_zFloat64Within-season z-score of adj_em, computed as adj_em minus the season mean divided by the season standard deviation, so each season is centered at zero with unit spread.
load_mbb_ratings(seasons=2025)

load_mbb_shots​

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

Returns​

col_nametypedescription
game_idInt32Unique game identifier.
seasonInt32Season year.
period_numberInt32Numeric period (1-4 for quarters; 5+ for OT).
clock_display_valueStringGame clock display string (e.g. '8:32').
team_idInt32Unique team identifier.
athlete_id_1Int32Primary athlete identifier (e.g. shooter).
athlete_id_2Int32Secondary athlete identifier (e.g. assister / fouler).
type_idInt32Type identifier (numeric).
type_textStringDisplay text for the type field.
scoring_playBooleanTRUE if the play resulted in points scored.
score_valueInt32Point value of the play (2 / 3 / 1).
coordinate_xFloat64X coordinate on the court (half-court layout).
coordinate_yFloat64Y coordinate on the court (half-court layout).
coordinate_x_rawFloat64X coordinate as returned by the API before any adjustment.
coordinate_y_rawFloat64Y coordinate as returned by the API before any adjustment.
athlete_name_1StringDisplay name of the shooter credited on the attempt in ESPN's play participants.
athlete_name_2StringDisplay name of the second athlete tied to the attempt (typically the assister), when present.
team_nameStringFull team display name (e.g. 'Las Vegas Aces').
team_mascotStringMascot/nickname of the shooting team from ESPN's team record.
team_abbrevStringAbbreviation for team.
load_mbb_shots(seasons=2025)

load_mbb_standings​

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

Returns​

col_nametypedescription
seasonInt32Season year.
group_idStringESPN group id.
group_nameStringGroup name (conference / division).
group_abbreviationStringGroup abbreviation.
group_short_nameStringAbbreviated conference label ESPN prints in standings tables, such as ACC, Big Ten or Am. East, one value per group_id.
team_idInt32Unique team identifier.
team_uidStringESPN universal team identifier (UID format 's:40~l:...~t:...').
team_slugStringURL-safe team identifier (e.g. 'lasvegas-aces' / 'aces').
team_locationStringTeam city or location string.
team_nameStringFull team display name (e.g. 'Las Vegas Aces').
team_abbreviationStringShort team abbreviation (e.g. 'LAS').
team_display_nameStringFull team display name.
team_short_display_nameStringShort team display name (e.g. 'Aces').
team_colorStringTeam primary color (hex without leading '#').
team_alternate_colorStringTeam alternate color (hex without leading '#').
team_logoStringTeam logo image URL.
stat_nameStringStat key.
stat_display_nameStringStat display name.
stat_short_display_nameStringShort human-readable stat name.
stat_descriptionStringESPN's longer-form label for the standings statistic, which can differ from stat_display_name (streak is described as Current Streak and playoffSeed as Playoff Seed).
stat_abbreviationStringShort code ESPN prints for the standings statistic in a table header, such as W, L, PCT, GB or STRK; it diverges from stat_short_display_name for playoff seed and the home and conference record rows.
stat_typeStringStat type code (e.g. "win", "loss").
display_valueStringDisplay-formatted value.
valueFloat64Numeric or string value field.
load_mbb_standings(seasons=2025)

load_mbb_rosters​

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

Returns​

col_nametypedescription
seasonInt32Season year.
team_idInt32Unique team identifier.
team_slugStringURL-safe team identifier (e.g. 'lasvegas-aces' / 'aces').
team_abbreviationStringShort team abbreviation (e.g. 'LAS').
team_display_nameStringFull team display name.
team_short_display_nameStringShort team display name (e.g. 'Aces').
team_colorStringTeam primary color (hex without leading '#').
team_alternate_colorStringTeam alternate color (hex without leading '#').
team_logoStringTeam logo image URL.
athlete_idStringUnique athlete identifier (ESPN).
uidStringESPN UID string.
guidStringStable cross-league team GUID.
full_nameStringPlayer's full name.
display_nameStringDisplay name.
short_nameStringShort display name.
first_nameStringPlayer's first name.
last_nameStringPlayer's last name.
jerseyStringJersey number worn by the player.
position_abbreviationStringPosition abbreviation ('G' / 'F' / 'C').
position_nameStringListed roster position ('Guard', 'Forward', 'Center').
position_idStringUnique position identifier.
heightStringPlayer height (string e.g. '6-2' or inches).
weightStringPlayer weight in pounds.
ageStringPlayer age (in years).
date_of_birthStringDate of birth (YYYY-MM-DD).
birth_place_cityStringBirth place city.
birth_place_stateStringBirth place state.
birth_place_countryStringBirth place country.
experience_yearsStringExperience years.
experience_display_valueStringExperience display value.
headshot_hrefStringHeadshot image URL.
headshot_altStringAlternative-text label for the headshot.
link_webStringWeb link / URL.
status_idStringStatus identifier.
status_nameStringStatus label.
status_typeStringStatus type.
load_mbb_rosters(seasons=2025)

load_mbb_officials​

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

Returns​

col_nametypedescription
seasonInt32Season year.
game_idInt32Unique game identifier.
official_full_nameStringFull name of the game official as published in ESPN's gameInfo officials list; in this release it is byte-identical to official_display_name on every row.
official_display_nameStringDisplay form of the official's name used by ESPN's game feed, which duplicates official_full_name for all 18,284 rows of the 2025 release.
official_positionStringESPN's role label for the crew member, which is the constant Referee for every men's college basketball official in this release rather than a distinct crew chief or umpire designation.
official_position_idInt32ESPN's numeric code for the official's role, constant at 40 (Referee) across the entire men's college basketball officials release.
official_orderInt32Position of the official within the game's listed officiating crew.
load_mbb_officials(seasons=2025)

load_mbb_game_rosters​

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

Returns​

col_nametypedescription
seasonInt32Season year.
game_idStringUnique game identifier.
team_idInt32Unique team identifier.
team_slugStringURL-safe team identifier (e.g. 'lasvegas-aces' / 'aces').
team_abbreviationStringShort team abbreviation (e.g. 'LAS').
team_display_nameStringFull team display name.
home_awayStringGame venue label ('home' or 'away').
athlete_idInt32Unique athlete identifier (ESPN).
athlete_uidStringESPN athlete UID (universal identifier).
athlete_guidStringESPN athlete GUID.
athlete_display_nameStringAthlete display name (full).
athlete_short_nameStringAthlete short display name.
athlete_first_nameStringPlayer first name; athlete_detail = TRUE only.
athlete_last_nameStringAthlete last name.
athlete_jerseyStringAthlete jersey number.
athlete_positionStringAthlete position.
athlete_headshotStringURL of the player's ESPN headshot image, whose filename is the athlete_id (verified equal for all 190,365 non-null rows in 2025); null when ESPN publishes no photo for that player.
starterBooleanTRUE if the player was in the starting lineup; FALSE otherwise.
did_not_playBooleanTRUE if the player did not appear in the game.
activeBooleanTRUE if the row represents an active record (player / team / season).
ejectedBooleanTRUE if the player was ejected from the game.
reasonStringReason.
load_mbb_game_rosters(seasons=2025)

load_mbb_schedule_crosswalk​

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

Returns​

col_nametypedescription
seasonInt32Season year.
game_dateDateGame date (YYYY-MM-DD).
home_espn_team_idInt32ESPN home team id (NA for bart-only rows).
away_espn_team_idInt32ESPN away team id (NA for bart-only rows).
espn_game_idStringESPN game id (NA for bart-only rows).
bart_muidStringTorvik muid (NA for espn-only rows).
bart_team1StringTorvik team1 name (NA for espn-only rows).
bart_team2StringTorvik team2 name (NA for espn-only rows).
bart_winnerStringTorvik winner name (NA for espn-only rows).
kp_game_idStringKenPom game id (NA unless kenpom enabled).
fox_game_idStringFox game id (NA placeholder).
yahoo_game_idStringYahoo game id (NA placeholder).
match_methodStringCombination of matched sources, e.g. "fox+bart" / "fox_only" / "bart_only" / "espn_only".
match_confidenceFloat64Jaro-Winkler score or 1 for exact (NA if none).
load_mbb_schedule_crosswalk(seasons=2026)

load_mbb_groups​

Release: mbb_groups · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/mbb_groups/mbb_groups.parquet

Coverage

One season-less file: one row per group lineage (the league, subdivisions, conferences, divisions) with the first and last season it had members. group_id is SDV's own id (e.g. mbb:big-east) and names a lineage: a rename that keeps continuity keeps the id, a new body gets a new one, and notes records each call. Seasons are the ENDING year (2025 = the 2024-25 season).

Returns​

col_nametypedescription
leagueStringLeague code of the table ("mbb"); the prefix of every group_id in it.
group_idStringSDV group id, {league}:{slug}. It names a lineage: renames that keep continuity keep the id, and a new body (a new conference, or a merger the sources treat as new) gets a new one.
levelStringHierarchy level of the group: "league", "subdivision", "conference" or "division".
first_seasonInt32First season in which the group had at least one member (ENDING year: 2025 = the 2024-25 season).
last_seasonInt32Last season in which the group had at least one member (ENDING year: 2025 = the 2024-25 season).
notesStringBuilder notes on the group: the lineage decisions behind its group_id and any source caveats.
load_mbb_groups()

load_mbb_group_seasons​

Release: mbb_groups · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/mbb_groups/mbb_group_seasons.parquet

Coverage

One season-less file: one row per group per season it existed, with its name, short name, abbreviation and parent group AS OF that season (never today's label applied to the past) and its member count. season is the ENDING year (2025 = the 2024-25 season).

Returns​

col_nametypedescription
leagueStringLeague code of the table ("mbb"); the prefix of every group_id in it.
group_idStringSDV group id, {league}:{slug}. It names a lineage: renames that keep continuity keep the id, and a new body (a new conference, or a merger the sources treat as new) gets a new one.
seasonInt32Season the row describes (ENDING year: 2025 = the 2024-25 season).
levelStringHierarchy level of the group: "league", "subdivision", "conference" or "division".
nameStringFull name of the group as of that season -- the label in use then, not today's name.
short_nameStringShort display name of the group as of that season.
abbreviationStringAbbreviation of the group as of that season.
parent_group_idStringgroup_id one level up as of that season (division -> conference -> subdivision -> league); null at the top level or where no higher group applied that season.
n_teamsInt32Number of member teams in the group that season.
load_mbb_group_seasons()

load_mbb_group_aliases​

Release: mbb_groups · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/mbb_groups/mbb_group_aliases.parquet

Coverage

One season-less file: every name, abbreviation, slug and source id that a source (espn, kenpom, ncaa, sdv) uses for a group, each with the seasons it is valid for (valid_from / valid_to, inclusive; null = unbounded). Match a source's conference or division label here to reach group_id.

Returns​

col_nametypedescription
leagueStringLeague code of the table ("mbb"); the prefix of every group_id in it.
group_idStringSDV group id, {league}:{slug}. It names a lineage: renames that keep continuity keep the id, and a new body (a new conference, or a merger the sources treat as new) gets a new one.
sourceStringSource that uses this label or id (in this table: espn, kenpom, ncaa, sdv); "sdv" marks SDV's own labels.
source_idStringThe source's own id for the group (ESPN group id, NCAA conf_id, CFBD id, MLB division id) when it has one; null otherwise.
name_kindStringKind of label in value: "name", "short_name", "abbreviation", "slug" or "code".
valueStringThe label exactly as the source writes it; match a source's conference or division label against it to reach group_id.
valid_fromInt32First season the alias is valid for, inclusive (ENDING year: 2025 = the 2024-25 season); null = unbounded.
valid_toInt32Last season the alias is valid for, inclusive (ENDING year: 2025 = the 2024-25 season); null = unbounded (still in use).
load_mbb_group_aliases()