gamepenalties

25 rows where game_id = 1001054

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: home, period_id, powerplay, 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
307783 1001054 1001054 0 1 1 0 0 2 4 19 524 524
307784 1001054 1001054 0 1 1 0 0 2 3 341 536 536
307785 1001054 1001054 0 1 0 0 0 2 9 533 530 530
307786 1001054 1001054 1 1 0 0 0 2 9 533 106 106
307787 1001054 1001054 0 1 1 0 0 2 4 815 540 540
307788 1001054 1001054 0 1 0 0 0 2 1 981 534 534
307789 1001054 1001054 1 1 0 0 0 2 18 981 107 107
307790 1001054 1001054 1 1 1 0 0 2 1 1049 129 129
307791 1001054 1001054 0 2 0 0 0 5 13 61 537 537
307792 1001054 1001054 1 2 0 0 0 5 13 61 107 107
307793 1001054 1001054 1 2 1 0 0 2 1 94 127 127
307794 1001054 1001054 0 2 1 0 0 2 3 249 522 522
307795 1001054 1001054 1 2 1 0 0 2 2 466 133 133
307796 1001054 1001054 0 2 1 0 0 2 4 666 535 535
307797 1001054 1001054 1 2 1 0 0 5 67 1025 107 107
307798 1001054 1001054 0 2 0 0 0 2 4 1051 530 530
307799 1001054 1001054 0 3 1 0 0 2 4 151 521 521
307800 1001054 1001054 0 3 1 0 0 2 1 185 522 522
307801 1001054 1001054 0 3 0 0 0 5 13 346 540 540
307802 1001054 1001054 1 3 0 0 0 5 13 346 77 77
307803 1001054 1001054 0 3 1 0 0 2 3 369 542 542
307804 1001054 1001054 0 3 1 0 0 2 16 482 522 522
307805 1001054 1001054 0 3 1 0 0 2 44 640 521 521
307806 1001054 1001054 0 3 0 0 0 5 13 640 521 521
307807 1001054 1001054 1 3 0 0 0 5 13 640 101 101

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