gamepenalties

27 rows where game_id = 1001071

✎ 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
308237 1001071 1001071 0 1 1 0 0 5 27 32 689 689
308238 1001071 1001071 0 1 0 0 0 10 28 32 689 689
308239 1001071 1001071 1 1 1 0 0 2 3 505 143 143
308240 1001071 1001071 0 1 0 0 0 2 15 1167 643 643
308241 1001071 1001071 1 1 0 0 0 2 8 1167 118 118
308242 1001071 1001071 1 2 1 0 0 2 4 80 111 111
308243 1001071 1001071 0 2 1 0 0 2 3 251 659 659
308244 1001071 1001071 0 2 0 0 0 2 3 458 657 657
308245 1001071 1001071 1 2 0 0 0 2 9 458 143 143
308246 1001071 1001071 0 2 1 0 0 2 9 605 657 657
308247 1001071 1001071 0 2 0 0 0 5 13 605 657 657
308248 1001071 1001071 1 2 0 0 0 5 13 605 90 90
308249 1001071 1001071 0 2 1 0 0 2 1 867 661 661
308250 1001071 1001071 0 2 1 0 0 2 15 867 661 661
308251 1001071 1001071 0 2 1 0 0 2 6 941 662 662
308252 1001071 1001071 1 3 1 0 0 2 4 18 103 103
308253 1001071 1001071 0 3 0 0 0 2 11 110 663 663
308254 1001071 1001071 0 3 0 0 0 5 13 110 663 663
308255 1001071 1001071 1 3 0 0 0 2 35 110 77 77
308256 1001071 1001071 1 3 0 0 0 5 13 110 77 77
308257 1001071 1001071 1 3 0 0 0 10 36 110 77 77
308258 1001071 1001071 1 3 1 0 0 2 7 238 124 124
308259 1001071 1001071 1 3 1 0 0 2 1 516 127 127
308260 1001071 1001071 0 3 0 0 0 2 7 603 658 658
308261 1001071 1001071 1 3 1 0 0 2 7 617 97 97
308262 1001071 1001071 0 3 1 0 0 2 3 857 657 657
308263 1001071 1001071 0 3 1 0 0 2 3 917 653 653

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