gamepenalties

16 rows where game_id = 1001044

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: home, period_id, bench, 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
307496 1001044 1001044 1 1 1 0 0 2 3 25 58 58
307497 1001044 1001044 0 1 1 0 0 2 16 240 632 632
307498 1001044 1001044 1 1 1 0 0 2 7 383 59 59
307499 1001044 1001044 1 1 1 0 0 2 12 383 59 59
307500 1001044 1001044 0 1 1 0 0 2 6 587 624 624
307501 1001044 1001044 0 1 1 0 0 2 16 587 621 621
307502 1001044 1001044 0 1 1 0 0 2 7 748 624 624
307503 1001044 1001044 1 1 1 0 0 2 9 1129 55 55
307504 1001044 1001044 0 2 1 0 0 2 109 572 625 625
307505 1001044 1001044 1 2 1 0 0 2 7 657 32 32
307506 1001044 1001044 0 2 1 0 0 2 1 898 625 625
307507 1001044 1001044 1 2 1 0 0 2 3 921 32 32
307508 1001044 1001044 1 2 1 0 0 2 1 968 34 34
307509 1001044 1001044 0 2 1 0 0 2 3 1145 637 637
307510 1001044 1001044 0 3 1 1 0 2 64 298 0 626
307511 1001044 1001044 0 3 1 1 0 2 5 1084 0 626

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