Skip to contents

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

Loads shot events parsed from ESPN WNBA play-by-play feeds. One row per shot attempt (made or missed), with court coordinates and shot metadata. Backed by the wehoop-wnba-data pipeline that reads raw JSONs from wehoop-wnba-raw and publishes parquet/rds artifacts to the espn_wnba_shots release tag.

Usage

load_wnba_shots_manifest()

load_wnba_shots(
  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 shots data table within the database

Value

Returns a wehoop_data tibble with one row per shot attempt.

col_nametypesdescription
game_idcharacterUnique game identifier.
seasonintegerSeason identifier (4-digit year or 'YYYY-YY' string).
period_numberintegerNumeric period (1-4 for quarters; 5+ for OT).
clock_display_valuecharacterGame clock display string (e.g. '8:32').
team_idcharacterUnique team identifier.
athlete_id_1characterPrimary athlete identifier (e.g. shooter).
athlete_id_2characterSecondary athlete identifier (e.g. assister / fouler).
type_idcharacterType identifier (numeric).
type_textcharacterDisplay text for the type field.
scoring_playlogicalTRUE if the play resulted in points scored.
score_valueintegerPoint value of the play (2 / 3 / 1).
coordinate_xnumericX coordinate on the court (half-court layout).
coordinate_ynumericY coordinate on the court (half-court layout).
coordinate_x_rawnumericX coordinate as returned by the API before any adjustment.
coordinate_y_rawnumericY coordinate as returned by the API before any adjustment.

Examples

# \donttest{
  try(load_wnba_shots(seasons = most_recent_wnba_season()))
#> ──────────────────────────────────────────────────────────────── wehoop 3.0.0 ──
#> # A tibble: 16,849 × 15
#>      game_id season period_number clock_display_value team_id athlete_id_1
#>        <int>  <int>         <int> <chr>                 <int>        <int>
#>  1 401856980   2026             1 9:44                      5      3142191
#>  2 401856980   2026             1 9:41                      5      4432831
#>  3 401856980   2026             1 9:37                      5      4398829
#>  4 401856980   2026             1 9:32                      5      3142191
#>  5 401856980   2026             1 9:13                     19      4433405
#>  6 401856980   2026             1 8:54                     19      3142010
#>  7 401856980   2026             1 8:49                     19      4432865
#>  8 401856980   2026             1 8:30                      5      4432831
#>  9 401856980   2026             1 8:07                      5      4433403
#> 10 401856980   2026             1 7:49                     19      4432865
#> # ℹ 16,839 more rows
#> # ℹ 9 more variables: athlete_id_2 <int>, type_id <int>, type_text <chr>,
#> #   scoring_play <lgl>, score_value <int>, coordinate_x <dbl>,
#> #   coordinate_y <dbl>, coordinate_x_raw <dbl>, coordinate_y_raw <dbl>
# }