gamepenalties

14 rows where game_id = 1001093

✎ 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
308678 1001093 1001093 1 1 1 0 0 2 1 390 508 508
308679 1001093 1001093 1 1 1 0 0 2 3 474 669 669
308680 1001093 1001093 0 1 1 0 0 2 3 593 107 107
308681 1001093 1001093 0 1 1 0 0 2 3 697 106 106
308682 1001093 1001093 1 1 1 0 0 2 7 816 508 508
308683 1001093 1001093 0 1 1 0 0 2 8 1094 109 109
308684 1001093 1001093 0 2 1 0 0 2 15 476 127 127
308685 1001093 1001093 0 2 1 0 0 2 1 700 698 698
308686 1001093 1001093 1 2 1 0 0 2 3 775 744 744
308687 1001093 1001093 1 3 1 0 0 2 3 352 429 429
308688 1001093 1001093 0 3 0 0 0 2 12 795 77 77
308689 1001093 1001093 1 3 1 0 0 2 1 795 722 722
308690 1001093 1001093 1 3 0 0 0 2 12 795 681 681
308691 1001093 1001093 0 3 1 0 0 2 7 992 90 90

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