gamepenalties

33 rows where game_id = 1001077

✎ 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
308204 1001077 1001077 0 1 1 0 0 2 3 14 596 596
308205 1001077 1001077 1 1 1 1 0 2 5 125 0 83
308206 1001077 1001077 1 1 1 0 0 2 6 162 47 47
308207 1001077 1001077 0 1 0 0 0 5 13 300 585 585
308208 1001077 1001077 1 1 0 0 0 5 13 300 96 96
308209 1001077 1001077 1 1 1 0 0 2 6 322 91 91
308210 1001077 1001077 0 1 1 0 0 2 15 443 595 595
308211 1001077 1001077 1 1 1 0 0 2 9 495 52 52
308212 1001077 1001077 0 1 1 0 0 2 15 500 599 599
308213 1001077 1001077 0 1 1 0 0 2 1 619 589 589
308214 1001077 1001077 1 1 1 0 0 2 4 777 38 38
308215 1001077 1001077 0 1 1 0 0 2 3 847 581 581
308216 1001077 1001077 0 1 1 0 0 2 7 880 596 596
308217 1001077 1001077 1 1 1 0 0 2 17 1035 47 47
308218 1001077 1001077 0 1 0 0 0 5 13 1171 589 589
308219 1001077 1001077 1 1 0 0 0 5 13 1171 35 35
308220 1001077 1001077 0 2 1 0 0 2 4 104 578 578
308221 1001077 1001077 1 2 1 0 0 2 3 166 74 74
308222 1001077 1001077 1 2 1 0 0 2 7 398 61 61
308223 1001077 1001077 0 2 1 0 0 2 15 415 586 586
308224 1001077 1001077 1 2 1 0 0 2 3 595 94 94
308225 1001077 1001077 0 2 1 0 0 2 7 671 539 539
308226 1001077 1001077 0 2 1 0 0 2 6 772 717 717
308227 1001077 1001077 0 2 0 0 0 2 9 913 595 595
308228 1001077 1001077 1 2 0 0 0 2 9 913 96 96
308229 1001077 1001077 1 2 1 0 0 2 3 1015 47 47
308230 1001077 1001077 0 2 1 0 0 2 3 1143 586 586
308231 1001077 1001077 1 3 1 0 0 2 6 432 38 38
308232 1001077 1001077 1 3 1 0 0 2 1 752 76 76
308233 1001077 1001077 0 3 1 0 0 2 4 834 593 593
308234 1001077 1001077 1 3 1 0 0 2 9 1131 54 54
308235 1001077 1001077 0 3 0 0 0 5 13 1200 595 595
308236 1001077 1001077 1 3 0 0 0 5 13 1200 45 45

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)
);