gamepenalties

18 rows where game_id = 1001079

✎ 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
308378 1001079 1001079 0 1 1 0 0 2 1 69 668 668
308379 1001079 1001079 1 1 1 0 0 2 7 211 312 312
308380 1001079 1001079 0 1 0 0 0 2 3 373 112 112
308381 1001079 1001079 1 1 0 0 0 2 9 373 296 296
308382 1001079 1001079 0 1 1 0 0 5 19 427 78 78
308383 1001079 1001079 1 1 0 1 0 2 5 555 0 263
308384 1001079 1001079 1 1 1 0 0 2 3 855 286 286
308385 1001079 1001079 0 1 1 0 0 2 8 1151 125 125
308386 1001079 1001079 0 2 1 0 0 2 9 195 78 78
308387 1001079 1001079 1 2 1 0 0 2 7 302 320 320
308388 1001079 1001079 0 2 1 0 0 2 4 630 112 112
308389 1001079 1001079 1 2 0 0 0 2 3 682 716 716
308390 1001079 1001079 0 2 1 0 0 2 1 696 119 119
308391 1001079 1001079 0 2 1 0 0 2 9 756 667 667
308392 1001079 1001079 0 2 1 0 0 2 15 927 98 98
308393 1001079 1001079 1 3 1 0 0 2 1 514 259 259
308394 1001079 1001079 0 3 1 0 0 2 3 647 119 119
308395 1001079 1001079 1 3 1 0 0 2 7 935 342 342

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