PWHL dataset loaders

flowchart LR
  raw["scrape / raw"] --> enrich["enrich"] --> rel["release asset"] --> load["load_*()"]

Automation status

Dataset	Release tag	Pipeline
load_phf_pbp	phf_pbp	—
load_phf_player_boxscores	phf_player_boxscores	—
load_phf_schedules	phf_schedules	—
load_phf_team_boxscores	phf_team_boxscores	—
load_pwhl_game_info	pwhl_game_info	—
load_pwhl_game_rosters	pwhl_game_rosters	—
load_pwhl_shifts	pwhl_shifts	—
load_pwhl_goalie_boxscores	pwhl_goalie_boxscores	—
load_pwhl_officials	pwhl_officials	—
load_pwhl_pbp	pwhl_pbp	—
load_pwhl_xg_pbp	pwhl_xg_pbp	—
load_pwhl_penalty_summary	pwhl_penalty_summary	—
load_pwhl_player_boxscores	pwhl_player_boxscores	—
load_pwhl_rosters	pwhl_rosters	—
load_pwhl_schedules	pwhl_schedules	—
load_pwhl_scoring_summary	pwhl_scoring_summary	—
load_pwhl_shootout	pwhl_shootout	—
load_pwhl_shots_by_period	pwhl_shots_by_period	—
load_pwhl_skater_boxscores	pwhl_skater_boxscores	—
load_pwhl_team_boxscores	pwhl_team_boxscores	—
load_pwhl_three_stars	pwhl_three_stars	—

load_phf_pbp

Release: phf_pbp · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/phf_pbp/play_by_play_{season}.parquet

Returns

col_name	type
play_type	String
team	String
time	String
play_description	String
period_id	Int32
game_id	Int32
game_date	String
home_team	String
home_location	String
home_nickname	String
home_abbreviation	String
home_score_total	Int32
away_team	String
away_location	String
away_nickname	String
away_abbreviation	String
away_score_total	Int32
away_goalie	String
away_goalie_jersey	String
goalie_change	String
penalty	Int32
on_ice_situation	String
score	String
minute_start	Int32
second_start	Int32
clock	String
leader	String
away_goals	String
home_goals	String
sec_from_start	Int32
power_play_seconds	Int32
time_elapsed	String
time_remaining	String
player_name_1	String
player_jersey_1	String
home_skaters	Int32
away_skaters	Int32
home_goalie	String
home_goalie_jersey	String
player_name_2	String
player_jersey_2	String
shot_result	String
goalie_involved	String
penalty_type	String
penalty_level	String
penalty_length	String
start_power_play	Int32
end_power_play	Int32
player_name_3	String
player_jersey_3	String
scoring_team_abbrev	String
scoring_team_on_ice	String
offensive_player_name_1	String
offensive_player_name_2	String
offensive_player_name_3	String
offensive_player_name_4	String
offensive_player_name_5	String
defending_team_abbrev	String
offensive_player_jersey_1	String
offensive_player_jersey_2	String
offensive_player_jersey_3	String
offensive_player_jersey_4	String
offensive_player_jersey_5	String
defending_team_on_ice	String
defensive_player_name_1	String
defensive_player_name_2	String
defensive_player_name_3	String
defensive_player_name_4	String
defensive_player_name_5	String
defensive_player_jersey_1	String
defensive_player_jersey_2	String
defensive_player_jersey_3	String
defensive_player_jersey_4	String
defensive_player_jersey_5	String
defensive_player_name_6	String
defensive_player_jersey_6	String
offensive_player_name_6	String
offensive_player_jersey_6	String
season	Int32

load_phf_pbp(seasons=2023)

load_phf_player_boxscores

Release: phf_player_boxscores · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/phf_player_boxscores/player_box_{season}.parquet

Returns

col_name	type
player_jersey	Int32
player_name	String
position	String
goals	Int32
assists	Int32
points	Int32
penalty_minutes	Int32
shots_on_goal	Int32
blocks	Int32
giveaways	Int32
takeaways	Int32
faceoffs_won_lost	String
faceoffs_win_pct	Float64
powerplay_goals	Int32
shorthanded_goals	Int32
shots	Int32
shots_blocked	Int32
faceoffs_won	Int32
faceoffs_lost	Int32
team	String
skaters_href	String
player_id	String
game_id	Int32
minutes_played	String
shots_against	Int32
goals_against	Int32
saves	Int32
save_percent	Float64
goalies_href	String
season	Int32

load_phf_player_boxscores(seasons=2023)

load_phf_schedules

Release: phf_schedules · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/phf_schedules/phf_schedule_{season}.parquet

Returns

col_name	type
type	String
id	String
league_id	Int32
season_id	Int32
tournament_id	Boolean
game_id	Int32
number	Int32
datetime	Datetime(time_unit='us', time_zone='UTC')
datetime_tz	Datetime(time_unit='us', time_zone='UTC')
time_zone	String
time_zone_abbr	String
updated_at	Datetime(time_unit='us', time_zone='UTC')
created_at	Datetime(time_unit='us', time_zone='UTC')
home_team_id	Int32
home_team	String
home_team_short	String
home_team_logo_url_full	String
home_team_logo_url_small	String
home_team_logo_url_medium	String
home_team_logo_url_large	String
home_team_logo_url_50	String
home_team_logo_url_100	String
home_team_logo_url_200	String
away_team_id	Int32
away_team	String
away_team_short	String
away_team_logo_url_full	String
away_team_logo_url_small	String
away_team_logo_url_medium	String
away_team_logo_url_large	String
away_team_logo_url_50	String
away_team_logo_url_100	String
away_team_logo_url_200	String
home_division_id	Int32
home_division	String
away_division_id	Int32
away_division	String
home_score	Int32
away_score	Int32
home_shots	Int32
away_shots	Int32
home_penalty_minutes	Int32
away_penalty_minutes	Int32
home_roster_count	Int32
away_roster_count	Int32
facility_id	Int32
facility	String
facility_address	String
rink_id	Boolean
rink	Boolean
game_type	String
notes	String
status	String
overtime	Boolean
shootout	Boolean
allow_players	Boolean
tickets_url	String
watch_live_url	String
external_url	Boolean
has_play_by_play	Boolean
highlight_color	Boolean
attendance	Int32
date_group	Date
winner	String
season	Int32
PBP	Boolean
team_box	Boolean
player_box	Boolean

load_phf_schedules(seasons=2023)

load_phf_team_boxscores

Release: phf_team_boxscores · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/phf_team_boxscores/team_box_{season}.parquet

Returns

col_name	type
team	String
game_id	Int32
winner	Boolean
total_scoring	Int32
successful_power_play	Float64
power_play_opportunities	Float64
power_play_percent	Float64
penalty_minutes	Float64
faceoff_percent	Float64
blocked_opponent_shots	Float64
takeaways	Float64
giveaways	Float64
period_1_shots	Int32
period_2_shots	Int32
period_3_shots	Int32
overtime_shots	Int32
shootout_made_shots	Int32
shootout_missed_shots	Int32
total_shots	Int32
period_1_scoring	Int32
period_2_scoring	Int32
period_3_scoring	Int32
overtime_scoring	Int32
shootout_made_scoring	Float64
shootout_missed_scoring	Float64
season	Int32

load_phf_team_boxscores(seasons=2023)

load_pwhl_game_info

Release: pwhl_game_info · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/pwhl_game_info/game_info_{season}.parquet

Returns

col_name	type
game_id	Int32
game_number	String
game_date	String
game_date_iso	String
start_time	String
end_time	String
game_duration	String
game_venue	String
attendance	Int32
game_status	String
game_season_id	Int32
started	Int32
final	Int32
home_team_id	Int32
home_team	String
home_team_abbr	String
home_score	Int32
away_team_id	Int32
away_team	String
away_team_abbr	String
away_score	Int32
has_shootout	Int32
game_report_url	String
boxscore_url	String

load_pwhl_game_info(seasons=2024)

load_pwhl_game_rosters

Release: pwhl_game_rosters · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/pwhl_game_rosters/game_rosters_{season}.parquet

Returns

col_name	type
game_id	Int32
team_id	Int32
team	String
team_abbr	String
team_side	String
player_type	String
player_id	Int32
first_name	String
last_name	String
jersey_number	Int32
position	String
birth_date	String
starting	Int32
status	String

load_pwhl_game_rosters(seasons=2024)

load_pwhl_shifts

Release: pwhl_shifts · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/pwhl_shifts/shifts_{season}.parquet

Returns

col_name	type
game_id	Int32
player_id	Int32
first_name	String
last_name	String
jersey_number	Int32
home	Int32
period	Int32
start_time	String
end_time	String
length	String
start_s	Int32
end_s	Int32
goal_on_shift	Int32
penalty_on_shift	Int32

load_pwhl_shifts(seasons=2025)

load_pwhl_goalie_boxscores

Release: pwhl_goalie_boxscores · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/pwhl_goalie_boxscores/goalie_box_{season}.parquet

Returns

col_name	type
player_id	String
first_name	String
last_name	String
position	String
team_id	Int32
game_id	Int32
league	String
toi	String
time_on_ice	Float64
saves	Int32
goals_against	Int32
shots_against	Int32
goals	Int32
assists	Int32
points	Int32
penalty_minutes	Int32
faceoff_attempts	Int32
faceoff_wins	Int32
faceoff_losses	Int32
faceoff_pct	Boolean
starting	Int32

load_pwhl_goalie_boxscores(seasons=2024)

load_pwhl_officials

Release: pwhl_officials · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/pwhl_officials/officials_{season}.parquet

Returns

col_name	type
game_id	Int32
role	String
first_name	String
last_name	String
jersey_number	Int32
official_role	String

load_pwhl_officials(seasons=2024)

load_pwhl_pbp

Release: pwhl_pbp · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/pwhl_pbp/play_by_play_{season}.parquet

Returns

col_name	type
game_id	Int32
event	String
team_id	Int32
period_of_game	String
time_of_period	String
player_id	Int32
player_name_first	String
player_name_last	String
player_position	String
player_two_id	Int32
player_two_name_first	String
player_two_name_last	String
player_two_position	String
x_coord	Float64
y_coord	Float64
home_win	Int32
player_team_id	Int32
event_type	String
shot_quality	String
goal	Boolean
goalie_id	Int32
goalie_first	String
goalie_last	String
player_three_id	Int32
player_three_name_first	String
player_three_name_last	String
player_three_position	String
empty_net	String
game_winner	String
penalty_shot	String
insurance	String
power_play	Int32
short_handed	String
plus_player_one_id	Int32
plus_player_one_first	String
plus_player_one_last	String
plus_player_one_position	String
plus_player_two_id	Int32
plus_player_two_first	String
plus_player_two_last	String
plus_player_two_position	String
plus_player_three_id	Int32
plus_player_three_first	String
plus_player_three_last	String
plus_player_three_position	String
plus_player_four_id	Int32
plus_player_four_first	String
plus_player_four_last	String
plus_player_four_position	String
plus_player_five_id	Int32
plus_player_five_first	String
plus_player_five_last	String
plus_player_five_position	String
minus_player_one_id	Int32
minus_player_one_first	String
minus_player_one_last	String
minus_player_one_position	String
minus_player_two_id	Int32
minus_player_two_first	String
minus_player_two_last	String
minus_player_two_position	String
minus_player_three_id	Int32
minus_player_three_first	String
minus_player_three_last	String
minus_player_three_position	String
minus_player_four_id	Int32
minus_player_four_first	String
minus_player_four_last	String
minus_player_four_position	String
minus_player_five_id	Int32
minus_player_five_first	String
minus_player_five_last	String
minus_player_five_position	String
penalty_length	String
game_date	String
game_season	Int32
game_season_id	String
home_team_id	Int32
home_team	String
away_team_id	Int32
away_team	String
x_coord_original	Int32
y_coord_original	Int32
x_coord_neutral	Int32
y_coord_neutral	Int32
x_coord_fixed	Float64
y_coord_fixed	Float64
x_coord_right	Float64
y_coord_right	Float64
x_coord_vertical	Float64
y_coord_vertical	Float64
minute_start	Int32
second_start	Int32
clock	String
sec_from_start	Int32

load_pwhl_pbp(seasons=2024)

load_pwhl_xg_pbp

Release: pwhl_xg_pbp · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/pwhl_xg_pbp/pwhl_xg_pbp_{season}.parquet

Returns

col_name	type
game_id	Int32
game_season	Int32
game_date	String
team_id	Int32
player_id	Int32
goalie_id	Int32
period_of_game	String
sec_from_start	Int32
clock	String
x_coord	Float64
y_coord	Float64
shot_distance	Float64
shot_angle	Float64
event_type	String
shot_quality	String
power_play	Int32
short_handed	String
empty_net	String
penalty_shot	String
goal	Boolean
xg	Float64

load_pwhl_xg_pbp(seasons=2025)

load_pwhl_penalty_summary

Release: pwhl_penalty_summary · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/pwhl_penalty_summary/penalty_summary_{season}.parquet

Returns

col_name	type
game_id	Int32
period_id	Int32
period	String
time	String
team_id	Int32
team	String
team_abbr	String
game_penalty_id	Int32
minutes	Int32
description	String
rule_number	String
is_power_play	Int32
is_bench	Int32
taken_by_id	Int32
taken_by_first	String
taken_by_last	String
taken_by_position	String
served_by_id	Int32
served_by_first	String
served_by_last	String

load_pwhl_penalty_summary(seasons=2024)

load_pwhl_player_boxscores

Release: pwhl_player_boxscores · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/pwhl_player_boxscores/player_box_{season}.parquet

Returns

col_name	type
player_id	String
first_name	String
last_name	String
position	String
team_id	Int32
game_id	Int32
league	String
toi	String
time_on_ice	Float64
goals	Int32
assists	Int32
points	Int32
shots	Int32
hits	Int32
blocked_shots	Int32
penalty_minutes	Int32
plus_minus	Int32
faceoff_attempts	Int32
faceoff_wins	Int32
faceoff_losses	Int32
faceoff_pct	Float64
starting	Int32
player_type	String
saves	Int32
goals_against	Int32
shots_against	Int32

load_pwhl_player_boxscores(seasons=2024)

load_pwhl_rosters

Release: pwhl_rosters · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/pwhl_rosters/rosters_{season}.parquet

Returns

col_name	type
team_id	Int32
team	String
team_abbr	String
team_side	String
player_type	String
player_id	Int32
first_name	String
last_name	String
jersey_number	Int32
position	String
birth_date	String
season	Int32

load_pwhl_rosters(seasons=2024)

load_pwhl_schedules

Release: pwhl_schedules · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/pwhl_schedules/pwhl_schedule_{season}.parquet

Returns

col_name	type
game_id	String
season	Int32
game_date	String
game_status	String
home_team	String
home_team_id	String
away_team	String
away_team_id	String
home_score	String
away_score	String
winner	String
venue	String
venue_url	String
game_type	String
game_json	Boolean
game_json_url	String
PBP	Boolean
player_box	Boolean
skater_box	Boolean
goalie_box	Boolean
team_box	Boolean
game_info	Boolean
game_rosters	Boolean
scoring_summary	Boolean
penalty_summary	Boolean
three_stars	Boolean
officials	Boolean
shots_by_period	Boolean
shootout	Boolean

load_pwhl_schedules(seasons=2024)

load_pwhl_scoring_summary

Release: pwhl_scoring_summary · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/pwhl_scoring_summary/scoring_summary_{season}.parquet

Returns

col_name	type
game_id	Int32
period_id	Int32
period	String
time	String
team_id	Int32
team	String
team_abbr	String
game_goal_id	Int32
scorer_goal_number	Int32
scorer_id	Int32
scorer_first	String
scorer_last	String
scorer_position	String
assist_1_id	Int32
assist_1_first	String
assist_1_last	String
assist_2_id	Int32
assist_2_first	String
assist_2_last	String
is_power_play	Int32
is_short_handed	Int32
is_empty_net	Int32
is_penalty_shot	Int32
is_insurance	Int32
is_game_winning	Int32
x_location	Boolean
y_location	Boolean

load_pwhl_scoring_summary(seasons=2024)

load_pwhl_shootout

Release: pwhl_shootout · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/pwhl_shootout/shootout_summary_{season}.parquet

Returns

col_name	type
game_id	Int32
round	Int32
team_side	String
shooter_id	Int32
shooter_first	String
shooter_last	String
goalie_id	Int32
goalie_first	String
goalie_last	String
is_goal	Int32

load_pwhl_shootout(seasons=2026)

load_pwhl_shots_by_period

Release: pwhl_shots_by_period · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/pwhl_shots_by_period/shots_by_period_{season}.parquet

Returns

col_name	type
game_id	Int32
period_id	Int32
period	String
home_goals	Int32
home_shots	Int32
away_goals	Int32
away_shots	Int32

load_pwhl_shots_by_period(seasons=2024)

load_pwhl_skater_boxscores

Release: pwhl_skater_boxscores · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/pwhl_skater_boxscores/skater_box_{season}.parquet

Returns

col_name	type
player_id	String
first_name	String
last_name	String
position	String
team_id	Int32
game_id	Int32
league	String
toi	String
time_on_ice	Float64
goals	Int32
assists	Int32
points	Int32
shots	Int32
hits	Int32
blocked_shots	Int32
penalty_minutes	Int32
plus_minus	Int32
faceoff_attempts	Int32
faceoff_wins	Int32
faceoff_losses	Int32
faceoff_pct	Float64
starting	Int32

load_pwhl_skater_boxscores(seasons=2024)

load_pwhl_team_boxscores

Release: pwhl_team_boxscores · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/pwhl_team_boxscores/team_box_{season}.parquet

Returns

col_name	type
game_id	Int32
team_id	Int32
team	String
team_abbr	String
team_side	String
shots	Int32
goals	Int32
hits	Int32
pp_goals	Int32
pp_opportunities	Int32
goal_count	Int32
assist_count	Int32
penalty_minutes	Int32
infraction_count	Int32
faceoff_attempts	Int32
faceoff_wins	Int32
faceoff_win_pct	Float64
season_wins	Int32
season_losses	Int32
season_ot_wins	Int32
season_ot_losses	Int32
season_so_losses	Int32
season_record	String

load_pwhl_team_boxscores(seasons=2024)

load_pwhl_three_stars

Release: pwhl_three_stars · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/pwhl_three_stars/three_stars_{season}.parquet

Returns

col_name	type
game_id	Int32
star	Int32
team_id	Int32
team	String
team_abbr	String
player_id	Int32
first_name	String
last_name	String
jersey_number	Int32
position	String
is_goalie	Int32
is_home	Int32
goals	Int32
assists	Int32
points	Int32
shots	Int32
saves	Int32
shots_against	Int32
goals_against	Int32
time_on_ice	String

load_pwhl_three_stars(seasons=2024)