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: 39,350 × 20
#>      game_id season period_number clock_display_value team_id athlete_id_1
#>        <int>  <int>         <int> <chr>                 <int>        <int>
#>  1 401857105   2026             1 9:43                     19      4433405
#>  2 401857105   2026             1 9:33                     17      4065870
#>  3 401857105   2026             1 9:24                     19      4433405
#>  4 401857105   2026             1 9:13                     19      4594786
#>  5 401857105   2026             1 8:47                     17      4065870
#>  6 401857105   2026             1 8:32                     19      4433405
#>  7 401857105   2026             1 8:07                     17      4065870
#>  8 401857105   2026             1 8:00                     19      4594786
#>  9 401857105   2026             1 7:43                     17      3149391
#> 10 401857105   2026             1 7:18                     17      3099736
#> # ℹ 39,340 more rows
#> # ℹ 14 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>,
#> #   athlete_name_1 <chr>, athlete_name_2 <chr>, team_name <chr>,
#> #   team_mascot <chr>, team_abbrev <chr>
# }