penalty_type

40 rows where penalty_class_id = 6

✎ View and edit SQL

This data as json, CSV (advanced)

penalty_type_id ▼ penalty_description penalty_class_id
22 Game misconduct - Elbowing 6 6
25 Game misconduct - Spearing 6 6
28 Game misconduct - Boarding 6 6
29 Game misconduct - Aggressor 6 6
30 Game misconduct - Abuse of officials 6 6
38 Game misconduct - Kneeing 6 6
39 Game misconduct - Secondary altercation 6 6
41 Game misconduct - Checking from behind 6 6
45 Game misconduct - Third man in 6 6
48 Game misconduct - Slashing 6 6
52 Game misconduct - Instigator (last 5:00) 6 6
55 Game misconduct - Fighting prior to drop of puck 6 6
57 Game misconduct - Leaving the bench 6 6
58 Game misconduct - Cross-checking 6 6
65 Game misconduct - Interference 6 6
70 Game misconduct - Charging 6 6
73 Game misconduct - Unsportsmanlike conduct 6 6
74 Game misconduct - Continuing altercation 6 6
76 Game misconduct 6 6
83 Game misconduct - Elbow pad 6 6
86 Game misconduct - Leaving penalty bench 6 6
96 Game misconduct - Clipping 6 6
101 Game misconduct - Third major/second fight 6 6
102 Game misconduct - Fighting prior to/at puck drop 6 6
103 Game misconduct - Coach 6 6
104 Game misconduct - Physical abuse of officials (Cat. III) 6 6
107 Game misconduct - Jersey 6 6
110 Game misconduct - Fighting off the playing surface 6 6
119 Game misconduct - Head-butting 6 6
120 Game misconduct - Fighting other than during periods of game 6 6
121 Game misconduct - Physical abuse of officials (Cat. II) 6 6
122 Game misconduct - Throwing equipment 6 6
124 Game misconduct - Persisting a fight 6 6
133 Game misconduct - Delay of game 6 6
135 Game misconduct - Charging the goaltender 6 6
139 Game misconduct - Butt-ending 6 6
141 Game misconduct - Third major in game 6 6
152 Game misconduct - Returning to ice/bench 6 6
154 Game misconduct - Checking to the head 6 6
158 Game misconduct - Physical abuse of officials 6 6

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE penalty_type (
                penalty_type_id INTEGER PRIMARY KEY AUTOINCREMENT,
                penalty_description TEXT UNIQUE NOT NULL,
                penalty_class_id INTEGER,
                FOREIGN KEY (penalty_class_id) REFERENCES penaltyclass(penalty_class_id)
            );