gamepenalties

32 rows where game_id = 1001103

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ game_id home period_id powerplay bench penalty_shot minutes penalty time_of_penalty_seconds player_penalized player_server
308791 1001103 1001103 0 1 1 0 0 2 15 14 68 68
308792 1001103 1001103 1 1 1 0 0 2 3 501 168 168
308793 1001103 1001103 0 1 1 0 0 2 6 711 56 56
308794 1001103 1001103 1 1 1 0 0 2 4 839 172 172
308795 1001103 1001103 0 1 0 0 0 2 3 856 51 51
308796 1001103 1001103 1 1 1 0 0 2 8 892 190 190
308797 1001103 1001103 0 1 0 0 0 5 13 1200 59 59
308798 1001103 1001103 0 1 0 0 0 2 12 1200 707 707
308799 1001103 1001103 1 1 0 0 0 2 12 1200 179 179
308800 1001103 1001103 1 1 0 0 0 5 13 1200 139 139
308801 1001103 1001103 0 2 1 0 0 2 15 115 27 27
308802 1001103 1001103 0 2 1 0 0 2 4 263 29 29
308803 1001103 1001103 1 2 1 0 0 2 7 295 187 187
308804 1001103 1001103 0 2 1 1 0 2 5 392 0 39
308805 1001103 1001103 0 2 1 0 0 2 15 516 34 34
308807 1001103 1001103 1 2 0 0 0 2 9 516 179 179
308808 1001103 1001103 1 2 1 0 0 2 6 600 187 187
308809 1001103 1001103 0 2 1 1 0 2 5 870 0 32
308810 1001103 1001103 0 2 1 0 0 2 1 977 51 51
308811 1001103 1001103 0 2 0 0 0 10 20 977 51 51
308812 1001103 1001103 0 2 1 0 0 2 3 1080 680 680
308813 1001103 1001103 0 3 1 0 0 2 35 171 63 63
308814 1001103 1001103 0 3 0 0 0 5 13 171 63 63
308815 1001103 1001103 0 3 0 0 0 10 36 171 63 63
308816 1001103 1001103 1 3 0 0 0 5 13 171 179 179
308817 1001103 1001103 1 3 1 0 0 2 3 305 168 168
308818 1001103 1001103 0 3 1 0 0 2 7 378 53 53
308819 1001103 1001103 1 3 1 0 0 2 1 547 190 190
308820 1001103 1001103 0 3 0 0 0 5 13 796 29 29
308821 1001103 1001103 0 3 0 0 0 10 29 796 29 29
308822 1001103 1001103 1 3 0 0 0 5 13 796 190 190
308823 1001103 1001103 0 3 1 0 0 2 7 1117 680 680

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