Skip to contents

Helper that loads multiple seasons of pre-scraped PWHL goalie-only box score data from the sportsdataverse-data releases either into memory or writes it into a database.

Source release tag: pwhl_goalie_boxscores. File naming convention: goalie_box_{end_year}.rds.

Usage

load_pwhl_goalie_box(
  seasons = most_recent_pwhl_season(),
  ...,
  dbConnection = NULL,
  tablename = NULL
)

Arguments

seasons

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

...

Additional arguments (currently unused; kept for API symmetry).

dbConnection

A DBIConnection object, as returned by DBI::dbConnect()

tablename

The name of the goalie box data table within the database

Value

A data frame of class fastRhockey_data with one row per goalie per game. Common columns include:

columntypedescription
game_idintegerPWHL game id
team_idintegerHockeyTech team id
player_idintegerHockeyTech player id
first_namecharactergoalie first name
last_namecharactergoalie last name
jersey_numberintegerjersey number
time_on_icecharactertotal TOI (MM:SS)
shots_againstintegershots faced
goals_againstintegergoals allowed
savesintegersaves made
startingcharacterstarted the game (0/1)
player_typecharacteralways "goalie"

Examples

# \donttest{
  try(load_pwhl_goalie_box(2024))
#> ─────────────────────────────────────────────────────────── fastRhockey 1.0.0 ──
#> # A tibble: 340 × 22
#>    player_id first_name last_name  position team_id game_id league toi  
#>    <chr>     <chr>      <chr>      <chr>      <int>   <int> <chr>  <chr>
#>  1 70        Erica      Howe       G              6       2 pwhl   0    
#>  2 64        Kristen    Campbell   G              6       2 pwhl   59:59
#>  3 155       Corinne    Schroeder  G              4       2 pwhl   59:59
#>  4 41        Abbey      Levy       G              4       2 pwhl   0    
#>  5 48        Sandra     Abstreiter G              5       3 pwhl   0    
#>  6 59        Emerance   Maschmeyer G              5       3 pwhl   61:04
#>  7 85        Elaine     Chuli      G              3       3 pwhl   0    
#>  8 28        Ann-Renée  Desbiens   G              3       3 pwhl   61:04
#>  9 19        Emma       Söderberg  G              1       4 pwhl   0    
#> 10 6         Aerin      Frankel    G              1       4 pwhl   60:00
#> # ℹ 330 more rows
#> # ℹ 14 more variables: time_on_ice <dbl>, saves <int>, goals_against <int>,
#> #   shots_against <int>, goals <int>, assists <int>, points <int>,
#> #   penalty_minutes <int>, faceoff_attempts <int>, faceoff_wins <int>,
#> #   faceoff_losses <int>, faceoff_pct <lgl>, starting <chr>, player_type <chr>
# }