my_database
Queries
Tables
gamedata
game_id, season_id, away_team_id, away_team_score, home_team_id, home_team_score, game_status, game_date, game_attendance, home_team_shots, away_team_shots, game_number, venue_id
25,695 rows
gamegoalies
id, game_id, player_id, team_id, period_start, time_start, period_end, time_end, saves, seconds, goals_against, shots_against, win, loss, shootout_loss, ot_loss, tie, shutout
87,149 rows
gamegoals
id, game_id, home, period_id, time_of_goal_seconds, team_id, goal_type, x_location, y_location, location_set, power_play, empty_net, penalty_shot, short_handed, insurance_goal, game_winning, game_tieing, scorer_goal_num, goal_scorer_player_id, assist1_player_id, assist2_player_id
148,366 rows
gamepenalties
id, game_id, home, period_id, powerplay, bench, penalty_shot, minutes, penalty, time_of_penalty_seconds, player_penalized, player_server
304,481 rows
mc_predictions
prediction_id, game_id, n_simulations, decay_rate, lookback_games, home_win_pct, away_win_pct, ot_pct, so_pct, avg_home_goals, avg_away_goals, score_dist_json, computed_at
3 rows
mc_team_stats
team_id, season_id, attack_rate, defense_rate, so_win_rate, games_used, computed_at
32 rows
player
id, first_name, last_name, position, height, weight, shoots, birth, birth_place, draft_team, draft_round, draft_pick
8,281 rows
playoff_brackets
series_id, playoff_season_id, reg_season_id, round_number, division_name, conference_name, series_label, higher_seed_team_id, lower_seed_team_id, higher_seed_wins, lower_seed_wins, series_winner_team_id, series_complete, source_series_a_id, source_series_b_id, updated_at
46 rows
playoff_prediction_snapshots
snapshot_id, playoff_season_id, snapshot_date, snapshot_type, bracket_json, champion_probs_json, n_simulations, computed_at
1 row
playoff_seedings
seeding_id, reg_season_id, team_id, division_name, conference_name, seed, points, wins, reg_wins, row_wins, gp, computed_at
64 rows
playoff_series_predictions
prediction_id, series_id, snapshot_date, home_team_id, away_team_id, home_series_win_pct, away_series_win_pct, expected_games, games_dist_json, n_simulations, computed_at
251 rows