Helper that loads multiple seasons of per-game PWHL metadata (one row per game) from the sportsdataverse-data releases either into memory or writes it into a database.
Source release tag: pwhl_game_info. File naming convention:
game_info_{end_year}.rds.
Usage
load_pwhl_game_info(
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
DBIConnectionobject, as returned byDBI::dbConnect()- tablename
The name of the game info data table within the database
Value
A data frame of class fastRhockey_data. Common columns include:
| column | type | description |
game_id | integer | PWHL game id |
game_number | character | league game number |
game_date | character | human-readable game date |
game_date_iso | character | ISO-8601 game start datetime |
start_time | character | start time (local) |
end_time | character | end time (local) |
game_duration | character | game length (H:MM) |
game_venue | character | venue name |
attendance | integer | reported attendance |
game_status | character | final / status text |
game_season_id | integer | HockeyTech season id |
home_team_id | integer | home team id |
home_team | character | home team name |
home_team_abbr | character | home abbreviation |
home_score | integer | home final score |
away_team_id | integer | away team id |
away_team | character | away team name |
away_team_abbr | character | away abbreviation |
away_score | integer | away final score |
has_shootout | integer | shootout flag |
Examples
# \donttest{
try(load_pwhl_game_info(2024))
#> ─────────────────────────────────────────────────────────── fastRhockey 1.0.0 ──
#> # A tibble: 85 × 24
#> game_id game_number game_date game_date_iso start_time end_time game_duration
#> <int> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 2 1 Monday, … 2024-01-01T1… 12:48 pm … 3:15 pm… 2:27
#> 2 3 2 Tuesday,… 2024-01-02T1… 7:12 pm E… 9:35 pm… 2:23
#> 3 4 3 Wednesda… 2024-01-03T1… 7:14 pm E… 9:35 pm… 2:21
#> 4 5 4 Friday, … 2024-01-05T1… 7:15 pm E… 9:40 pm… 2:25
#> 5 6 5 Saturday… 2024-01-06T1… 2:42 pm C… 5:03 pm… 2:21
#> 6 9 8 Wednesda… 2024-01-10T1… 7:11 pm E… 9:37 pm… 2:26
#> 7 8 7 Wednesda… 2024-01-10T1… 7:08 pm C… 9:28 pm… 2:20
#> 8 10 9 Saturday… 2024-01-13T1… 1:09 pm E… 3:25 pm… 2:16
#> 9 11 10 Saturday… 2024-01-13T1… 3:48 pm E… 6:18 pm… 2:30
#> 10 12 11 Sunday, … 2024-01-14T1… 3:08 pm C… 5:32 pm… 2:24
#> # ℹ 75 more rows
#> # ℹ 17 more variables: game_venue <chr>, attendance <int>, game_status <chr>,
#> # game_season_id <int>, started <int>, final <int>, home_team_id <int>,
#> # home_team <chr>, home_team_abbr <chr>, home_score <int>,
#> # away_team_id <int>, away_team <chr>, away_team_abbr <chr>,
#> # away_score <int>, has_shootout <int>, game_report_url <chr>,
#> # boxscore_url <chr>
# }