Skip to contents

helper that loads multiple seasons from the data repo either into memory or writes it into a db using some forwarded arguments in the dots

Usage

load_mbb_pbp(
  seasons = most_recent_mbb_season(),
  ...,
  dbConnection = NULL,
  tablename = NULL
)

Arguments

seasons

A vector of 4-digit years associated with given men's college basketball seasons. (Min: 2006)

...

Additional arguments passed to an underlying function that writes the season data into a database (used by update_mbb_db()).

dbConnection

A DBIConnection object, as returned by

tablename

The name of the play by play data table within the database

Value

Returns a tibble

col_nametypes
idnumeric
sequence_numbercharacter
type_idcharacter
type_textcharacter
textcharacter
away_scoreinteger
home_scoreinteger
period_numberinteger
period_display_valuecharacter
clock_display_valuecharacter
scoring_playlogical
score_valueinteger
team_idcharacter
participants_0_athlete_idcharacter
wallclockcharacter
shooting_playlogical
participants_1_athlete_idcharacter
seasoninteger
season_typeinteger
away_team_idinteger
away_team_namecharacter
away_team_mascotcharacter
away_team_abbrevcharacter
away_team_name_altcharacter
home_team_idinteger
home_team_namecharacter
home_team_mascotcharacter
home_team_abbrevcharacter
home_team_name_altcharacter
home_team_spreadnumeric
game_spreadnumeric
home_favoritelogical
game_spread_availablelogical
game_idinteger
qtrinteger
timecharacter
clock_minutescharacter
clock_secondscharacter
halfcharacter
game_halfcharacter
lag_qtrnumeric
lead_qtrnumeric
lag_game_halfcharacter
lead_game_halfcharacter
start_quarter_seconds_remaininginteger
start_half_seconds_remaininginteger
start_game_seconds_remaininginteger
game_play_numberinteger
end_quarter_seconds_remainingnumeric
end_half_seconds_remainingnumeric
end_game_seconds_remainingnumeric
periodinteger
coordinate_xinteger
coordinate_yinteger
media_idcharacter

Examples

# \donttest{
  load_mbb_pbp(seasons = most_recent_mbb_season())
#> ── ESPN MBB Play-by-Play from hoopR data repository ───────────── hoopR 2.0.0 ──
#>  Data updated: 2023-04-12 08:24:51 UTC
#> # A tibble: 1,957,068 × 59
#>         id sequence_number type_id type_text         text  away_score home_score
#>      <dbl> <chr>             <int> <chr>             <chr>      <int>      <int>
#>  1 4.02e17 101799901           615 Jumpball          Jump…          0          0
#>  2 4.02e17 101806501           558 JumpShot          Jord…          0          2
#>  3 4.02e17 101808701           558 JumpShot          Lamo…          3          2
#>  4 4.02e17 101814901           598 Lost Ball Turnov… Tris…          3          2
#>  5 4.02e17 101817101           558 JumpShot          Darr…          6          2
#>  6 4.02e17 101819701           558 JumpShot          Adam…          6          4
#>  7 4.02e17 101825501           558 JumpShot          Kesh…          8          4
#>  8 4.02e17 101828401           558 JumpShot          Tris…          8          4
#>  9 4.02e17 101828402           587 Defensive Rebound Nath…          8          4
#> 10 4.02e17 101829701           558 JumpShot          Nath…          8          4
#> # ℹ 1,957,058 more rows
#> # ℹ 52 more variables: period_number <int>, period_display_value <chr>,
#> #   clock_display_value <chr>, scoring_play <lgl>, score_value <int>,
#> #   team_id <int>, athlete_id_1 <int>, wallclock <chr>, shooting_play <lgl>,
#> #   season <int>, season_type <int>, away_team_id <int>, away_team_name <chr>,
#> #   away_team_mascot <chr>, away_team_abbrev <chr>, away_team_name_alt <chr>,
#> #   home_team_id <int>, home_team_name <chr>, home_team_mascot <chr>, …
# }