Skip to contents

Loads season-level WNBA coaching staff data scraped from the WNBA Stats API. One row per coach-team-season triple. Backed by the wehoop-wnba-stats-data pipeline that reads raw JSONs from wehoop-wnba-stats-raw and publishes parquet/rds artifacts to the wnba_stats_coaches release tag.

load_wnba_stats_coaches_manifest() returns the per-season manifest CSV (season, row_count, generated_at_utc, source_endpoint) for the WNBA Stats coaches release tag without downloading any season's full data.

Usage

load_wnba_stats_coaches(
  seasons = most_recent_wnba_stats_season(),
  ...,
  dbConnection = NULL,
  tablename = NULL
)

load_wnba_stats_coaches_manifest()

Arguments

seasons

A vector of 4-digit years associated with given WNBA seasons. Published coverage runs 1997 through the most recent season with one gap: 2019 is absent upstreamcommonteamroster returns no coaching staff for that season (confirmed by positive controls on 2018 and 2020), so no 2019 asset is published. Requesting 2019 emits a download warning and contributes no rows. Historical seasons also lack the sub_sort_sequence column added in 2026. Pass seasons = TRUE for every published season. (Min: 1997)

...

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

Value

Returns a wehoop_data tibble with one row per coach-team-season.

Examples

# \donttest{
  try(load_wnba_stats_coaches(seasons = most_recent_wnba_stats_season()))
#> ──────────────────────────────────────────────────────────────── wehoop 3.0.0 ──
#> # A tibble: 89 × 11
#>       team_id season coach_id first_name last_name  coach_name      is_assistant
#>         <int>  <int>    <int> <chr>      <chr>      <chr>                  <int>
#>  1 1611661313   2026  1627666 Chris      DeMarco    Chris DeMarco              1
#>  2 1611661313   2026  1643608 Andrew     Wade       Andrew Wade                2
#>  3 1611661313   2026  1643609 Will       Sheehey    Will Sheehey               2
#>  4 1611661313   2026  1643610 Addi       Walters    Addi Walters               2
#>  5 1611661313   2026   201907 Courtney   Paris      Courtney Paris             2
#>  6 1611661313   2026  1642971 Norielis   Subero     Norielis Subero            3
#>  7 1611661317   2026   202891 Nate       Tibbetts   Nate Tibbetts              1
#>  8 1611661317   2026   201911 Kristi     Toliver    Kristi Toliver             9
#>  9 1611661317   2026   201069 Megan      Vogel      Megan Vogel                2
#> 10 1611661317   2026  1628240 John       McCullough John McCullough            2
#> # ℹ 79 more rows
#> # ℹ 4 more variables: coach_type <chr>, sort_sequence <lgl>,
#> #   sub_sort_sequence <int>, season_type <chr>
# }