Name: All NHL Regular Season Fights From 99/00 To 23/24
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

All NHL Regular Season Fights From 99/00 To 23/24

For hockey fans.
Data was obtained by scrapping hockeyfights.com. It contains all fighting from the latest 25 seasons with all the needed details.

Column description:

season: years of the season
season_type: type of season
fight: participants in the fight
player_1_name: name of player one
player_2_name: name of player two
player_1_team: team of player one
player_2_team: team of player two
date: date of the fight
period: period during which the fight occurred
gametime: time within the period
winner: result of the hockeyfights.com poll
rating: viewer ratings from hockeyfights.com
vote_count: number of votes from hockeyfights.com viewers
fight_id: unique identifier for the record

Tables

Nhl Regular All Fights

@kaggle.lucasprado_all_nhl_fights_from_regular_seasons_9900_to_2324.nhl_regular_all_fights

438.54 kB
11,535 rows
14 columns

CREATE TABLE nhl_regular_all_fights (
  "season" VARCHAR,
  "season_type" VARCHAR,
  "fight" VARCHAR,
  "player_1_name" VARCHAR,
  "player_2_name" VARCHAR,
  "player_1_team" VARCHAR,
  "player_2_team" VARCHAR,
  "date" VARCHAR,
  "period" VARCHAR,
  "gametime" VARCHAR,
  "winner" VARCHAR,
  "rating" BIGINT,
  "vote_count" BIGINT,
  "fight_id" BIGINT
);