gamepenalties

16 rows where game_id = 1001065

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: home, period_id, powerplay, 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
308050 1001065 1001065 1 1 1 0 0 2 7 183 332 332
308051 1001065 1001065 0 1 1 0 0 2 1 302 401 401
308052 1001065 1001065 0 1 1 0 0 2 15 841 436 436
308053 1001065 1001065 0 1 1 0 0 2 1 951 401 401
308054 1001065 1001065 0 2 1 0 0 2 4 40 401 401
308055 1001065 1001065 1 2 1 0 0 2 9 350 668 668
308056 1001065 1001065 1 2 1 0 0 5 61 350 668 668
308057 1001065 1001065 1 2 0 0 0 10 58 350 668 668
308058 1001065 1001065 0 2 1 0 0 2 14 702 44 44
308059 1001065 1001065 0 2 1 0 0 5 19 825 448 448
308060 1001065 1001065 0 3 1 0 0 2 3 141 453 453
308061 1001065 1001065 0 3 0 0 0 2 9 270 471 471
308062 1001065 1001065 1 3 0 0 0 2 9 270 81 81
308063 1001065 1001065 0 3 0 0 0 2 8 782 432 432
308064 1001065 1001065 1 3 0 0 0 2 9 782 81 81
308065 1001065 1001065 1 3 1 0 0 2 7 908 112 112

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