CREATE TABLE AwardsMisc
(
    name  TEXT not null
        primary key,
    ID    TEXT,
    award TEXT,
    year  INTEGER,
    lgID  TEXT,
    note  TEXT
);
AwardsMisc
CREATE TABLE HOF
(
    year     INTEGER,
    hofID    TEXT not null
        primary key,
    name     TEXT,
    category TEXT
);
HOF
CREATE TABLE Teams
(
    year       INTEGER          not null,
    lgID       TEXT,
    tmID       TEXT not null,
    franchID   TEXT,
    confID     TEXT,
    divID      TEXT,
    rank       INTEGER,
    playoff    TEXT,
    G          INTEGER,
    W          INTEGER,
    L          INTEGER,
    T          INTEGER,
    OTL        TEXT,
    Pts        INTEGER,
    SoW        TEXT,
    SoL        TEXT,
    GF         INTEGER,
    GA         INTEGER,
    name       TEXT,
    PIM        TEXT,
    BenchMinor TEXT,
    PPG        TEXT,
    PPC       TEXT,
    SHA        TEXT,
    PKG       TEXT,
    PKC        TEXT,
    SHF        TEXT,
    primary key (year, tmID)
);
Teams
CREATE TABLE Coaches
(
    coachID TEXT    not null,
    year    INTEGER not null,
    tmID    TEXT    not null,
    lgID    TEXT,
    stint   INTEGER not null,
    notes   TEXT,
    g       INTEGER,
    w       INTEGER,
    l       INTEGER,
    t       INTEGER,
    postg   TEXT,
    postw   TEXT,
    postl   TEXT,
    postt   TEXT,
    primary key (coachID, year, tmID, stint),
    foreign key (year, tmID) references Teams (year, tmID)
        on update cascade on delete cascade
);
Coaches
CREATE TABLE AwardsCoaches
(
    coachID TEXT,
    award   TEXT,
    year    INTEGER,
    lgID    TEXT,
    note    TEXT,
    foreign key (coachID) references Coaches (coachID)
);
AwardsCoaches
CREATE TABLE Master
(
    playerID     TEXT,
    coachID      TEXT,
    hofID        TEXT,
    firstName    TEXT,
    lastName     TEXT not null,
    nameNote     TEXT,
    nameGiven    TEXT,
    nameNick     TEXT,
    height       TEXT,
    weight       TEXT,
    shootCatch   TEXT,
    legendsID    TEXT,
    ihdbID       TEXT,
    hrefID       TEXT,
    firstNHL     TEXT,
    lastNHL      TEXT,
    firstWHA     TEXT,
    lastWHA     TEXT,
    pos          TEXT,
    birthYear    TEXT,
    birthMon     TEXT,
    birthDay     TEXT,
    birthCountry TEXT,
    birthState   TEXT,
    birthCity    TEXT,
    deathYear    TEXT,
    deathMon     TEXT,
    deathDay     TEXT,
    deathCountry TEXT,
    deathState   TEXT,
    deathCity    TEXT,
    foreign key (coachID) references Coaches (coachID)
            on update cascade on delete cascade
);
Master
CREATE TABLE AwardsPlayers
(
    playerID TEXT    not null,
    award    TEXT    not null,
    year     INTEGER not null,
    lgID     TEXT,
    note     TEXT,
    pos      TEXT,
    primary key (playerID, award, year),
    foreign key (playerID) references Master (playerID)
            on update cascade on delete cascade
);
AwardsPlayers
CREATE TABLE CombinedShutouts
(
    year      INTEGER,
    month     INTEGER,
    date      INTEGER,
    tmID      TEXT,
    oppID     TEXT,
    "R/P"     TEXT,
    IDgoalie1 TEXT,
    IDgoalie2 TEXT,
    foreign key (IDgoalie1) references Master (playerID)
            on update cascade on delete cascade,
    foreign key (IDgoalie2) references  Master (playerID)
            on update cascade on delete cascade
);
CombinedShutouts
CREATE TABLE Goalies
(
    playerID TEXT    not null,
    year     INTEGER not null,
    stint    INTEGER not null,
    tmID     TEXT,
    lgID     TEXT,
    GP       TEXT,
    Min      TEXT,
    W        TEXT,
    L        TEXT,
    "T/OL"   TEXT,
    ENG      TEXT,
    SHO      TEXT,
    GA       TEXT,
    SA       TEXT,
    PostGP   TEXT,
    PostMin  TEXT,
    PostW    TEXT,
    PostL    TEXT,
    PostT    TEXT,
    PostENG  TEXT,
    PostSHO  TEXT,
    PostGA   TEXT,
    PostSA   TEXT,
    primary key (playerID, year, stint),
    foreign key (year, tmID) references Teams (year, tmID)
        on update cascade on delete cascade,
    foreign key (playerID) references Master (playerID)
            on update cascade on delete cascade
);
Goalies
CREATE TABLE GoaliesSC
(
    playerID TEXT    not null,
    year     INTEGER not null,
    tmID     TEXT,
    lgID     TEXT,
    GP       INTEGER,
    Min      INTEGER,
    W        INTEGER,
    L        INTEGER,
    T        INTEGER,
    SHO      INTEGER,
    GA       INTEGER,
    primary key (playerID, year),
    foreign key (year, tmID) references Teams (year, tmID)
        on update cascade on delete cascade,
    foreign key (playerID) references Master (playerID)
            on update cascade on delete cascade
);
GoaliesSC
CREATE TABLE GoaliesShootout
(
    playerID TEXT,
    year     INTEGER,
    stint    INTEGER,
    tmID     TEXT,
    W        INTEGER,
    L        INTEGER,
    SA       INTEGER,
    GA       INTEGER,
    foreign key (year, tmID) references Teams (year, tmID)
        on update cascade on delete cascade,
    foreign key (playerID)  references Master (playerID)
            on update cascade on delete cascade
);
GoaliesShootout
CREATE TABLE Scoring
(
    playerID  TEXT,
    year      INTEGER,
    stint     INTEGER,
    tmID      TEXT,
    lgID      TEXT,
    pos       TEXT,
    GP        INTEGER,
    G         INTEGER,
    A         INTEGER,
    Pts       INTEGER,
    PIM       INTEGER,
    "+/-"     TEXT,
    PPG       TEXT,
    PPA       TEXT,
    SHG       TEXT,
    SHA       TEXT,
    GWG       TEXT,
    GTG       TEXT,
    SOG       TEXT,
    PostGP    TEXT,
    PostG     TEXT,
    PostA     TEXT,
    PostPts   TEXT,
    PostPIM   TEXT,
    "Post+/-" TEXT,
    PostPPG   TEXT,
    PostPPA   TEXT,
    PostSHG   TEXT,
    PostSHA   TEXT,
    PostGWG  TEXT,
    PostSOG   TEXT,
    foreign key (year, tmID) references Teams (year, tmID)
        on update cascade on delete cascade,
    foreign key (playerID) references Master (playerID)
            on update cascade on delete cascade
);
Scoring
CREATE TABLE ScoringSC
(
    playerID TEXT,
    year     INTEGER,
    tmID     TEXT,
    lgID     TEXT,
    pos      TEXT,
    GP       INTEGER,
    G        INTEGER,
    A        INTEGER,
    Pts      INTEGER,
    PIM      INTEGER,
    foreign key (year, tmID) references Teams (year, tmID)
        on update cascade on delete cascade,
    foreign key (playerID) references Master (playerID)
            on update cascade on delete cascade
);
ScoringSC
CREATE TABLE ScoringShootout
(
    playerID TEXT,
    year     INTEGER,
    stint    INTEGER,
    tmID     TEXT,
    S        INTEGER,
    G        INTEGER,
    GDG      INTEGER,
     foreign key (year, tmID) references Teams (year, tmID)
        on update cascade on delete cascade,
    foreign key (playerID) references Master (playerID)
            on update cascade on delete cascade
);
ScoringShootout
CREATE TABLE ScoringSup
(
    playerID TEXT,
    year     INTEGER,
    PPA      TEXT,
    SHA      TEXT,
     foreign key (playerID) references Master (playerID)
            on update cascade on delete cascade
);
ScoringSup
CREATE TABLE SeriesPost
(
    year        INTEGER,
    round       TEXT,
    series      TEXT,
    tmIDWinner  TEXT,
    lgIDWinner  TEXT,
    tmIDLoser   TEXT,
    lgIDLoser   TEXT,
    W           INTEGER,
    L           INTEGER,
    T           INTEGER,
    GoalsWinner INTEGER,
    GoalsLoser  INTEGER,
    note        TEXT,
    foreign key (year, tmIDWinner) references Teams (year, tmID)
        on update cascade on delete cascade,
    foreign key (year, tmIDLoser) references Teams (year, tmID)
        on update cascade on delete cascade
);
SeriesPost
CREATE TABLE TeamSplits
(
    year  INTEGER          not null,
    lgID  TEXT,
    tmID  TEXT not null,
    hW    INTEGER,
    hL    INTEGER,
    hT    INTEGER,
    hOTL  TEXT,
    rW    INTEGER,
    rL    INTEGER,
    rT    INTEGER,
    rOTL  TEXT,
    SepW  TEXT,
    SepL  TEXT,
    SepT  TEXT,
    SepOL TEXT,
    OctW TEXT,
    OctL  TEXT,
    OctT  TEXT,
    OctOL TEXT,
    NovW  TEXT,
    NovL  TEXT,
    NovT  TEXT,
    NovOL TEXT,
    DecW  TEXT,
    DecL  TEXT,
    DecT  TEXT,
    DecOL TEXT,
    JanW  INTEGER,
    JanL  INTEGER,
    JanT  INTEGER,
    JanOL TEXT,
    FebW  INTEGER,
    FebL  INTEGER,
    FebT  INTEGER,
    FebOL TEXT,
    MarW  TEXT,
    MarL  TEXT,
    MarT  TEXT,
    MarOL TEXT,
    AprW  TEXT,
    AprL  TEXT,
    AprT  TEXT,
    AprOL TEXT,
    primary key (year, tmID),
    foreign key (year, tmID) references Teams (year, tmID)
        on update cascade on delete cascade
);
TeamSplits
CREATE TABLE TeamVsTeam
(
    year  INTEGER          not null,
    lgID  TEXT,
    tmID  TEXT not null,
    oppID TEXT not null,
    W     INTEGER,
    L     INTEGER,
    T     INTEGER,
    OTL   TEXT,
    primary key (year, tmID, oppID),
    foreign key (year, tmID) references Teams (year, tmID)
        on update cascade on delete cascade,
    foreign key (oppID, year) references Teams (tmID, year)
        on update cascade on delete cascade
);
TeamVsTeam
CREATE TABLE TeamsHalf
(
    year INTEGER          not null,
    lgID TEXT,
    tmID TEXT not null,
    half INTEGER          not null,
    rank INTEGER,
    G    INTEGER,
    W    INTEGER,
    L    INTEGER,
    T    INTEGER,
    GF   INTEGER,
    GA   INTEGER,
    primary key (year, tmID, half),
    foreign key (tmID, year) references Teams (tmID, year)
        on update cascade on delete cascade
);
TeamsHalf
CREATE TABLE TeamsPost
(
    year       INTEGER          not null,
    lgID       TEXT,
    tmID       TEXT not null,
    G          INTEGER,
    W          INTEGER,
    L          INTEGER,
    T          INTEGER,
    GF         INTEGER,
    GA         INTEGER,
    PIM        TEXT,
    BenchMinor TEXT,
    PPG        TEXT,
    PPC        TEXT,
    SHA        TEXT,
    PKG        TEXT,
    PKC        TEXT,
    SHF        TEXT,
    primary key (year, tmID),
    foreign key (year, tmID) references Teams (year, tmID)
        on update cascade on delete cascade
);
TeamsPost
CREATE TABLE TeamsSC
(
    year INTEGER          not null,
    lgID TEXT,
    tmID TEXT not null,
    G    INTEGER,
    W    INTEGER,
    L    INTEGER,
    T    INTEGER,
    GF   INTEGER,
    GA   INTEGER,
    PIM  TEXT,
    primary key (year, tmID),
    foreign key (year, tmID) references Teams (year, tmID)
        on update cascade on delete cascade
);
TeamsSC
CREATE TABLE abbrev
(
    Type     TEXT not null,
    Code     TEXT not null,
    Fullname TEXT,
    primary key (Type, Code)
);
abbrev
original_column_name,column_name,column_description,data_format,value_description
Type,,type of hockey games,text,
Code,,abbreviated codes,text,
Fullname,,full names of code,text,
abbrev
original_column_name,column_name,column_description,data_format,value_description
year,,year,integer,
round,,round ,text,see abbrev.csv for details
series,,series,text,used for the NHL designations
tmIDWinner,Team ID of winner,Team ID of winner,text,
lgIDWinner,League ID of winner,League ID of winner,text,
tmIDLoser,Team ID of loser,Team ID of winner,text,
lgIDLoser,league id of loser,league id of loser,text,
W,wins ,wins ,integer,
L,loses,loses,integer,
T,ties ,ties ,integer,
GoalsWinner,goals for winner,goals for winner,integer,
GoalsLoser,goals for loser,goals for loser,integer,
note,,note,note,"Note: EX = exhibition, ND = no decision, TG = total-goals series"
SeriesPost
original_column_name,column_name,column_description,data_format,value_description
name,,unique name of awards,text,unique name of awards
ID,,"id number of players or coaches, etc.",text,
award,,awarder,text,not useful
year,,year of the award,integer,
lgID,league ID,league abbreviated name,text,
note ,,note if needed,text,"commonsense evidence: 
noted information"
AwardsMisc
original_column_name,column_name,column_description,data_format,value_description
playerID,,id number identifying the player,text,number identifying players
year,,year,integer,"2005-06 listed as ""2005"""
tmID,team ID,team abbreviated name,text,
lgID,league ID,league abbreviated name,text,
GP,Games played,Games played,integer,
Min,Minutes,Minutes of appearance,integer,
W,Wins,Wins,integer,
L,Loses,Loses,integer,
T,Ties,Ties,integer,
SHO,Shutouts,Shutouts,integer,"commonsense evidence:
In ice hockey, a shutout (SHO) is credited to a goaltender who successfully stops the other team from scoring during the entire game."
GA,Goals against,Goals against,integer,"commonsense evidence:
“Goals Against” are the number of goals recorded while the goalie is on the ice. Include all goals against during regulation and overtime play."
GoaliesSC
original_column_name,column_name,column_description,data_format,value_description
playerID,,id number identifying the player,text,
coachID,coach ID,coach id number,text,"commonsense evidence:
if a person has both playerID and coachID, it means this person becomes coach after retirement."
hofID,,hall of fame id,text,
firstName,first name,first name,text,
lastName,last name,last name,text,
nameNote,name note,note about name,text,
nameGiven,name given ,Given name,text,
nameNick,Nickname ,Nickname ,text,"(multiple entries separated by ""/"")"
height,,height,text,
weight,,weight,text,
shootCatch,shoot catch,Shooting hand (or catching hand for goalies),text,"commonsense evidence: 
Shooting hand (or catching hand for goalies)
L: left hand
R: right hand
if null or 'empty', it means this player is good at both left and right hand"
legendsID,legends ID,ID at Legends Of Hockey,text,
ihdbID,Internet Hockey Database ID,ID at the Internet Hockey Database,text,
hrefID,Hockey-Reference.com ID,ID at Hockey-Reference.com,text,
firstNHL,First NHL season,First NHL season,text,
lastNHL,Last NHL season,Last NHL season,text,
firstWHA,First WHA season,First WHA season,text,
lastWHA,Last WHA season,Last WHA season,text,
pos,position,,text,"commonsense evidence:
LW: left winger
RW: right winger
C: center
G: goalie
D: defenseman
W: winger
F: forward
the player with W (winger) means he can play the role as both LW (left winger) and RW (right winger)
some players have two positions, which will be shown as ""L/D"". It means that LW + D --> left winger and defenseman"
birthYear,birth Year,birth Year,text,
birthMon,birth Month,birth Month,text,
birthDay,birth Day,birth Day,text,"commonsense evidence:
the entire / detail birth date in this table is ""year"" / ""month"" / ""date"""
birthCountry,birth Country,birth Country,text,
birthState,birth State,birth State,text,
birthCity,birth city,birth city,text,
deathYear,death year,death year,text,
deathMon,death month,death month,text,
deathDay,death day,death day,text,
deathCountry,death country,death country,text,
deathState,death state,death state,text,
deathCity,death city,death city,text,
Master
original_column_name,column_name,column_description,data_format,value_description
year,,year,integer,
lgID,league ID,league ID number,text,
tmID,team ID,team ID,text,
franchID,Franchise ID,Franchise ID,text,
confID,Conference ID,Conference ID,text,see abbrev.csv for details
divID,Division ID,Division ID,text,see abbrev.csv for details
rank,,Final standing,integer,
playoff,,playoff results,text,
G,games,games,integer,
W,wins,wins,integer,
L,loses,loses,integer,
T,ties,ties,integer,
OTL,Overtime losses,Overtime losses,text,
Pts,points,points,integer,
SoW,Shootout wins,Shootout wins,text,
SoL,Shootout loses,Shootout loses,text,
GF,Goals for,Goals for,integer,
GA,Goals against,goals against,integer,
name,Full team name,Full team name,text,
PIM,Penalty minutes,Penalty minutes,text,
BenchMinor,Bench minors (minutes),Bench minors (minutes),text,"commonsense evidence: 
A bench minor penalty is a minor penalty committed by a player or coach that is not on the ice. It is like a minor penalty in that it calls for the offending player to serve two minutes in the penalty box."
PPG,Power play goals,Power play goals,text,
PPC,Power play chances,Power play chances,text,"commonsense evidence: 
power play percentage (PP%) = PPG / PPC"
SHA,Shorthanded goals against,Shorthanded goals against,text,
PKG,Power play goals against,Power play goals against,text,
PKC,Penalty kill chances,Penalty kill chances,text,
SHF,Shorthanded goals for,Shorthanded goals for,text,
Teams
original_column_name,column_name,column_description,data_format,value_description
playerID,player id,id number identifying the player,text,number identifying the player
year,,year,integer,"2005-06 listed as ""2005"""
stint,,stint,integer,
tmID,team ID,team abbreviated name,text,
S,shots,shots,integer,
G,goals,goals,integer,
GDG,game deciding goals,game deciding goals,integer,
ScoringShootout
original_column_name,column_name,column_description,data_format,value_description
playerID,player id,string ID of players,text,unique string ID of the player
year,,,,
PPA,Power play assists,Power play assists,text,
SHA,Shorthanded assists,Shorthanded assists,text,
ScoringSup
original_column_name,column_name,column_description,data_format,value_description
year,,year,integer,
lgID,league ID,league ID number,text,
tmID,team ID,team ID,text,
hW,home wins,home wins,integer,
hL,home loses,home loses,integer,
hT,home ties,home ties,integer,
hOTL,Home overtime losses,Home overtime losses,text,
rW,Road wins,Road wins,integer,
rL,Road loses,Road loses,integer,
rT,Road ties,Road ties,integer,
rOTL,road overtime loses,road overtime loses,text,
SepW,September wins,September wins,text,
SepL,September loses,September loses,text,
SepT,September ties,September ties,text,
SepOL,September overtime loses,September overtime loses,text,
OctW,October wins,October wins,text,
OctL,October loses,October loses,text,
OctT,October ties,October ties,text,
OctOL,October overtime loses,October overtime loses,text,
NovW,November wins,November wins,text,
NovL,November loses,November loses,text,
NovT,November ties,November ties,text,
NovOL,November overtime loses,November overtime loses,text,
DecW,December wins,December wins,text,
DecL,December loses,December loses,text,
DecT,December ties,December ties,text,
DecOL,December overtime loses,December overtime loses,text,
JanW,January wins,January wins,integer,
JanL,January loses,January loses,integer,
JanT,January ties,January ties,integer,
JanOL,January overtime loses,January overtime loses,text,
FebW,February wins,February wins,integer,
FebL,February loses,February loses,integer,
FebT,February ties,February ties,integer,
FebOL,February overtime loses,February overtime loses,text,
MarW,March wins,March wins,text,
MarL,March loses,March loses,text,
MarT,March ties,March ties,text,
MarOL,March overtime loses,March overtime loses,text,
AprW,April wins,April wins,text,
AprL,April loses,April loses,text,
AprT,April ties,April ties,text,
AprOL,April overtime loses,April overtime loses,text,
TeamSplits
original_column_name,column_name,column_description,data_format,value_description
playerID,,id number identifying the player,text,number identifying players
year,,year,integer,"2005-06 listed as ""2005"""
stint,,order of appearance in a season,integer,"commonsense evidence: 
the entire date in this table is ""year"" / ""month"" / ""date"""
tmID,team ID,team abbreviated name,text,
lgID,league ID,league abbreviated name,text,
GP,Games played,Games played,text,
Min,Minutes,Minutes of appearance,text,
W,wins,wins,text,
L,loses,loses,text,
T/OL,Ties / overtime losses,Ties / overtime losses,text,
ENG,Empty net goals,Empty net goals,text,"commonsense evidence: 
An empty net goal happens when a team scores against their opponent who has pulled their goalie. Since there is no goalie in the net, the net is considered “empty"" "
SHO,Shutouts,Shutouts,text,"commonsense evidence: 
In ice hockey, a shutout (SHO) is credited to a goaltender who successfully stops the other team from scoring during the entire game."
GA,Goals against,Goals against,text,"commonsense evidence: 
“Goals Against” are the number of goals recorded while the goalie is on the ice. Include all goals against during regulation and overtime play."
SA,Shots against,Shots against,text,"commonsense evidence: 
“Shot Against” are the number of shots recorded while the goalie is on the ice"
PostGP,Postseason games played,Postseason games played,text,
PostMin,Postseason minutes,Postseason minutes,text,
PostW,Postseason wins,Postseason wins,text,
PostL,Postseason loses,Postseason loses,text,
PostT,Postseason ties,Postseason ties,text,
PostENG,Postseason empty net goals,Postseason empty net goals,text,"commonsense evidence: 
An empty net goal happens when a team scores against their opponent who has pulled their goalie. Since there is no goalie in the net, the net is considered “empty"" "
PostSHO,Postseason Shutouts,Postseason Shutouts,text,"commonsense evidence: 
In ice hockey, a shutout (SHO) is credited to a goaltender who successfully stops the other team from scoring during the entire game."
PostGA,Postseason Goals against,Postseason Goals against,text,"commonsense evidence: 
“Goals Against” are the number of goals recorded while the goalie is on the ice. Include all goals against during regulation and overtime play."
PostSA,Postseason Shots against,Postseason Shots against,text,"commonsense evidence: 
“Shot Against” are the number of shots recorded while the goalie is on the ice."
Goalies
original_column_name,column_name,column_description,data_format,value_description
year,,year,integer,
lgID,league ID,league ID number,text,
tmID,team ID,team ID,text,
G,Games,Games,integer,
W,wins,wins,integer,
L,loses,loses,integer,
T,ties,ties,integer,
GF,goals for,goals for,integer,
GA,goals against,goals against,integer,
PIM,penalty minutes,penalty minutes,text,
BenchMinor,Bench minors (minutes),Bench minors (minutes),text,
PPG,Power play goals,Power play goals,text,
PPC,Power play chances,Power play chances,text,
SHA,Shorthanded goals against,Shorthanded goals against,text,
PKG,Power play goals against,Power play goals against,text,
PKC,Penalty kill chances,Penalty kill chances,text,
SHF,Shorthanded goals for,Shorthanded goals for,text,
TeamsPost
original_column_name,column_name,column_description,data_format,value_description
year,,year of hall of fame,integer,
hofID,hall of fame id,hall of fame id,text,
name,,name,text,
category,,category,text,
HOF
original_column_name,column_name,column_description,data_format,value_description
year,,year,integer,
lgID,league ID,league ID number,text,
tmID,team ID,team ID,text,
half,,First or second half of season,integer,
rank,,Final standing for the half,integer,
G,Games,Games,integer,
W,wins,wins,integer,
L,loses,loses,integer,
T,ties,ties,integer,
GF,goals for,goals for,integer,
GA,goals against,goal against,integer,
TeamsHalf
original_column_name,column_name,column_description,data_format,value_description
year,,year,integer,
lgID,league ID,league ID number,text,
tmID,team ID,team ID,text,
oppID,opponent ID,opponent ID,text,
W,wins,wins,integer,
L,loses,loses,integer,
T,ties,ties,integer,
OTL,overtime loses,overtime loses,text,
TeamVsTeam
original_column_name,column_name,column_description,data_format,value_description
coachID,coach ID,string ID of the coach,text,
award,,awards that the coach achieve,text,
year,,year of award,integer,
lgID,league ID,league abbreviated name,text,
note,,,text,
AwardsCoaches
original_column_name,column_name,column_description,data_format,value_description
year,,year,integer,
lgID,league ID,league ID number,text,
tmID,team ID,team ID,text,
G,Games,Games,integer,
W,wins,wins,integer,
L,loses,loses,integer,
T,ties,ties,integer,
GF,goals for,goals for,integer,
GA,goals against,goals against,integer,
PIM,penalty minutes,penalty minutes,text,
TeamsSC
original_column_name,column_name,column_description,data_format,value_description
playerID,player id,string ID of players,text,unique string ID of the player
award,,award name,text,
year,,year of award,integer,
lgID,league ID,league abbreviated name,text,
note,,note if needed,text,
pos,position,position of players,text,"commonsense evidence: 
LW: left winger
RW: right winger
C: center
G: goalie
D: defenseman
W: winger
F: forward

the player with W (winger) means he can play the role as both LW (left winger) and RW (right winger)"
AwardsPlayers
original_column_name,column_name,column_description,data_format,value_description
year,,year,integer,
month,,month,integer,
date,,day,integer,"commonsense evidence: 
the entire date in this table is ""year"" / ""month"" / ""date"""
tmID,team ID,team abbreviated name,text,
oppID,opposite team ID,Team ID of opponent,text,
R/P ,regular / postseason,regular / postseason,text,"R"" for regular season, or ""P"" for postseason"
IDgoalie1,ID of goalie 1,ID of first goalie,text,
IDgoalie2,ID of goalie 2,ID of second goalie,text,
CombinedShutouts
original_column_name,column_name,column_description,data_format,value_description
playerID,,id number identifying the player,text,number identifying the player
year,,year,integer,"2005-06 listed as ""2005"""
tmID,team ID,team abbreviated name,text,
lgID,league ID,league abbreviated name,text,
pos,position ,position,text,
GP,Games played,Games played,integer,
G,Goals,goals,integer,
A,assists,assists,integer,
Pts,points,points,integer,
PIM,Penalty minutes,Penalty minutes,integer,
ScoringSC
original_column_name,column_name,column_description,data_format,value_description
coachID,coach ID,number identifying coaches,text,number identifying coaches
year,,In which year did the coach teach this team,integer,
tmID,team ID,team abbreviated name,text,
lgID,league ID,league abbreviated name,text,
stint,,stint,integer,
notes ,,note if needed,text,"commonsense evidence: 
noted information"
g,games,number of games,integer,
w,wins,number of wins,integer,"commonsense evidence: 
winning rates = wins / (wins + loses)"
l,loses,number of loses,integer,
t,ties,number of ties,integer,
postg,post-season games,number of post-season games,text,
postw,post-season wins,number of post-season wins,text,
postl,post-season loses,number of post-season loses,text,
postt,post-season ties,number of post-season ties,text,
Coaches
original_column_name,column_name,column_description,data_format,value_description
playerID,,player ID,text,
year,,play year,integer,
stint,,Stint (order of appearance in a season),integer,
tmID,team id,team id,text,
lgID,league id,league id,text,
pos,position ,position,text,"commonsense evidence:
LW: left winger
RW: right winger
C: center
G: goalie
D: defenseman
W: winger
F: forward
the player with W (winger) means he can play the role as both LW (left winger) and RW (right winger)
some players have two positions, which will be shown as ""L/D"". It means that LW + D --> left winger and defenseman"
GP,game played,game played,integer,
G,goals,goals,integer,
A,assists,assists,integer,
Pts,points,points,integer,
PIM,Penalty minutes,Penalty minutes,integer,
+/-,Plus / minus,Plus / minus,text,"commonsense evidence:
The plus minus stat is used to determine how often a player is on the ice when a goal is scored for the team versus against the team. A positive plus minus means that the player has been on for more goals scored than against, while a negative number means they have been on for more against.
In another words, higher ""+ / -"" means more importance to the team, lower means less importance"
PPG,Power play goals,Power play goals,text,"commonsense evidence:
When a team with more players on the ice scores a goal it is known as a power play goal. Many goals are scored in power play situations as the team is able to keep possession of the puck and have more scoring chances."
PPA,Power play assists,Power play assists,text,
SHG,Shorthanded goals,Shorthanded goals,text,"commonsense evidence: 
Sometimes the team with fewer players on the ice known as the short-handed team will score a goal."
SHA,Shorthanded assists,Shorthanded assists,text,
GWG,Game-winning goals,Game-winning goals,text,"commonsense evidence: 
A game-winning goal (GWG) is the goal scored to put the winning team in excess of the losing team's final score.
commonsense evidence:
if a player gets more GWG, it means this player is more trustworthy in the critical moment."
GTG,Game-tying goals,Game-tying goals,text,A game-tying goal (GWG) is the goal scored to put the winning team in the ties of the losing team's final score
SOG,Shots on goal,Shots on goal,text,"commonsense evidence:
a shot that enters the goal or would have entered the goal if it had not been blocked by the goalkeeper or another defensive player."
PostGP,Postseason games played,Postseason games played,text,
PostG,Postseason goals,Postseason goals,text,
PostA,Postseason assists,Postseason assists,text,
PostPts,Postseason points,Postseason points,text,
PostPIM,Postseason penalty minutes,Postseason penalty minutes,text,
Post+/-,Postseason Plus / minus,Postseason Plus / minus,text,
PostPPG,Postseason power play goals,Postseason power play goals,text,
PostPPA,Postseason power play assists,Postseason power play assists,text,
PostSHG,Postseason Shorthanded goals,Postseason Shorthanded goals,text,
PostSHA,Postseason Shorthanded assists,Postseason Shorthanded assists,text,
PostGWG,Postseason game-winning goals,Postseason game-winning goals,text,
PostSOG,Postseason shots on goal,Postseason shots on goal,text,
Scoring
original_column_name,column_name,column_description,data_format,value_description
playerID,,,integer,
year,,year,integer,"2005-06 listed as ""2005"""
stint,,stint,text,
tmID,team ID,team abbreviated name,integer,
W,Wins,Wins,integer,
L,Loses,Loses,integer,
SA,Shots against,Shots against,integer,"commonsense evidence: 
“Shot Against” are the number of shots recorded while the goalie is on the ice."
GA,Goals against,Goals against,integer,"commonsense evidence: 
“Goals Against” are the number of goals recorded while the goalie is on the ice. Include all goals against during regulation and overtime play."
GoaliesShootout