gamepenalties

18 rows where game_id = 1001051

✎ 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
307688 1001051 1001051 1 1 1 1 0 2 5 30 0 573
307689 1001051 1001051 1 1 1 0 0 2 4 542 612 612
307690 1001051 1001051 0 1 1 0 0 2 15 898 231 231
307691 1001051 1001051 0 1 1 0 0 2 3 1179 236 236
307692 1001051 1001051 0 2 1 0 0 2 15 260 221 221
307693 1001051 1001051 1 2 1 0 0 2 17 536 613 613
307694 1001051 1001051 1 2 1 0 0 2 4 630 608 608
307695 1001051 1001051 1 2 1 0 0 2 7 1164 603 603
307696 1001051 1001051 1 3 1 0 0 2 1 135 603 603
307697 1001051 1001051 0 3 0 0 0 2 12 154 70 70
307698 1001051 1001051 0 3 0 0 0 10 33 154 246 246
307699 1001051 1001051 1 3 0 0 0 2 12 154 606 606
307700 1001051 1001051 1 3 0 0 0 10 33 154 606 606
307701 1001051 1001051 1 3 1 0 0 2 16 154 559 559
307702 1001051 1001051 0 3 1 0 0 2 7 651 222 222
307703 1001051 1001051 1 3 1 0 0 2 4 884 613 613
307704 1001051 1001051 0 3 1 0 0 2 11 1096 224 224
307705 1001051 1001051 0 3 1 0 0 2 10 1119 70 70

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