gamepenalties

13 rows where game_id = 1001133

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: home, period_id, powerplay, 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
309588 1001133 1001133 1 1 1 0 0 2 7 380 630 630
309589 1001133 1001133 0 1 1 0 0 2 4 474 341 341
309590 1001133 1001133 0 1 1 0 0 2 4 648 279 279
309591 1001133 1001133 0 1 0 0 0 2 9 1134 334 334
309592 1001133 1001133 1 1 0 0 0 2 9 1134 714 714
309593 1001133 1001133 0 2 1 0 0 2 17 161 331 331
309594 1001133 1001133 1 2 1 0 0 2 1 351 630 630
309595 1001133 1001133 0 2 1 0 0 2 1 932 268 268
309596 1001133 1001133 0 2 1 0 0 2 11 984 270 270
309597 1001133 1001133 1 3 1 0 0 2 9 437 640 640
309598 1001133 1001133 1 3 1 0 0 2 1 580 687 687
309599 1001133 1001133 0 3 1 0 0 2 15 775 341 341
309600 1001133 1001133 0 3 1 0 0 2 9 775 341 341

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