Skip to contents

load_wnba_game_rosters_manifest() returns the per-season manifest CSV (season, row_count, generated_at_utc, source_endpoint) for the game rosters release tag without downloading any season's full data.

Loads per-game rosters scraped from ESPN WNBA box scores. One row per athlete-team-game triple, with athlete identifiers, jersey, position, starter flag, and DNP status. Backed by the wehoop-wnba-data pipeline that reads raw JSONs from wehoop-wnba-raw and publishes parquet/rds artifacts to the espn_wnba_game_rosters release tag.

Usage

load_wnba_game_rosters_manifest()

load_wnba_game_rosters(
  seasons = most_recent_wnba_season(),
  ...,
  dbConnection = NULL,
  tablename = NULL
)

Arguments

seasons

A vector of 4-digit years associated with given WNBA seasons. (Min: 2002)

...

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 game rosters data table within the database

Value

Returns a wehoop_data tibble with one row per athlete-team-game.

col_nametypes
game_idcharacter
seasoninteger
team_idcharacter
athlete_idcharacter
athlete_display_namecharacter
athlete_positioncharacter
athlete_jerseycharacter
starterlogical
did_not_playlogical

Examples

# \donttest{
  try(load_wnba_game_rosters(seasons = most_recent_wnba_season()))
#> ──────────────────────────────────────────────────────────────── wehoop 3.0.0 ──
#> # A tibble: 562 × 22
#>    season game_id   team_id team_slug       team_abbreviation team_display_name
#>     <int> <chr>       <int> <chr>           <chr>             <chr>            
#>  1   2026 401856890      18 connecticut-sun CON               Connecticut Sun  
#>  2   2026 401856890      18 connecticut-sun CON               Connecticut Sun  
#>  3   2026 401856890      18 connecticut-sun CON               Connecticut Sun  
#>  4   2026 401856890      18 connecticut-sun CON               Connecticut Sun  
#>  5   2026 401856890      18 connecticut-sun CON               Connecticut Sun  
#>  6   2026 401856890      18 connecticut-sun CON               Connecticut Sun  
#>  7   2026 401856890      18 connecticut-sun CON               Connecticut Sun  
#>  8   2026 401856890      18 connecticut-sun CON               Connecticut Sun  
#>  9   2026 401856890      18 connecticut-sun CON               Connecticut Sun  
#> 10   2026 401856890      18 connecticut-sun CON               Connecticut Sun  
#> # ℹ 552 more rows
#> # ℹ 16 more variables: home_away <chr>, athlete_id <int>, athlete_uid <chr>,
#> #   athlete_guid <chr>, athlete_display_name <chr>, athlete_short_name <chr>,
#> #   athlete_first_name <chr>, athlete_last_name <chr>, athlete_jersey <chr>,
#> #   athlete_position <chr>, athlete_headshot <chr>, starter <lgl>,
#> #   did_not_play <lgl>, active <lgl>, ejected <lgl>, reason <chr>
# }