gamepenalties

29 rows where game_id = 1001062

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: home, period_id, powerplay, bench, minutes, penalty, time_of_penalty_seconds, player_penalized, player_server

id ▼ game_id home period_id powerplay bench penalty_shot minutes penalty time_of_penalty_seconds player_penalized player_server
307924 1001062 1001062 0 1 0 0 0 5 13 121 5 5
307925 1001062 1001062 1 1 0 0 0 5 13 121 212 212
307926 1001062 1001062 0 1 0 0 0 5 13 179 18 18
307927 1001062 1001062 1 1 0 0 0 5 13 179 166 166
307928 1001062 1001062 0 1 0 0 0 2 7 261 13 13
307929 1001062 1001062 1 1 0 0 0 2 3 261 199 199
307930 1001062 1001062 0 1 0 0 0 2 3 372 14 14
307931 1001062 1001062 1 1 0 0 0 2 18 372 200 200
307932 1001062 1001062 1 1 1 0 0 2 6 517 208 208
307933 1001062 1001062 0 1 1 0 0 2 7 691 13 13
307934 1001062 1001062 0 1 0 0 0 2 15 806 6 6
307935 1001062 1001062 0 1 0 0 0 2 12 806 14 14
307936 1001062 1001062 1 1 0 0 0 2 9 806 37 37
307937 1001062 1001062 1 1 0 0 0 2 12 806 191 191
307938 1001062 1001062 0 1 1 0 0 2 4 858 7 7
307939 1001062 1001062 0 1 1 0 0 2 6 1002 23 23
307940 1001062 1001062 0 1 1 0 0 2 1 1179 24 24
307941 1001062 1001062 0 1 0 0 0 2 9 1194 18 18
307942 1001062 1001062 1 1 0 0 0 2 9 1194 173 173
307943 1001062 1001062 0 1 1 1 0 2 31 1200 0 11
307944 1001062 1001062 0 2 0 0 0 5 13 125 6 6
307945 1001062 1001062 1 2 0 0 0 5 13 125 191 191
307946 1001062 1001062 0 2 1 0 0 2 6 140 18 18
307947 1001062 1001062 1 2 1 0 0 2 6 271 173 173
307948 1001062 1001062 1 2 1 0 0 2 7 599 191 191
307949 1001062 1001062 0 2 1 0 0 2 6 613 7 7
307950 1001062 1001062 1 2 1 0 0 2 7 1176 204 204
307951 1001062 1001062 0 3 1 0 0 2 1 247 24 24
307952 1001062 1001062 0 3 1 0 0 2 3 773 4 4

Advanced export

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

CSV options: 

CREATE TABLE "gamepenalties" (
    id INTEGER PRIMARY KEY,
    game_id INTEGER NOT NULL,
    home BOOLEAN,
    period_id INTEGER,
    powerplay BOOLEAN,
    bench BOOLEAN,
    penalty_shot BOOLEAN,
    minutes INTEGER,
    penalty INTEGER,
    time_of_penalty_seconds INTEGER,
    player_penalized INTEGER,
    player_server INTEGER,
    FOREIGN KEY (game_id) REFERENCES gamedata(game_id)
);