gamepenalties

23 rows where game_id = 1001043

✎ 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
307512 1001043 1001043 0 1 1 0 0 2 3 277 644 644
307513 1001043 1001043 0 1 0 0 0 2 9 477 648 648
307514 1001043 1001043 1 1 0 0 0 2 15 477 535 535
307515 1001043 1001043 1 1 1 0 0 2 3 517 522 522
307516 1001043 1001043 0 1 0 0 0 5 13 681 654 654
307517 1001043 1001043 1 1 0 0 0 5 13 681 540 540
307518 1001043 1001043 0 1 1 0 0 2 18 709 653 653
307519 1001043 1001043 1 1 1 0 0 2 3 808 542 542
307520 1001043 1001043 1 1 1 0 0 2 3 987 535 535
307521 1001043 1001043 0 2 1 0 0 2 3 56 657 657
307522 1001043 1001043 1 2 1 0 0 2 3 282 527 527
307523 1001043 1001043 0 2 1 0 0 2 3 551 643 643
307524 1001043 1001043 1 2 1 0 0 2 1 679 521 521
307525 1001043 1001043 0 2 1 0 0 2 8 906 657 657
307526 1001043 1001043 1 2 1 0 0 2 3 1147 521 521
307527 1001043 1001043 1 3 1 0 0 2 7 167 521 521
307528 1001043 1001043 1 3 1 0 0 2 3 316 537 537
307529 1001043 1001043 1 3 0 0 0 2 7 506 682 682
307530 1001043 1001043 0 3 1 0 0 2 3 634 644 644
307531 1001043 1001043 0 3 0 0 0 2 12 779 663 663
307532 1001043 1001043 1 3 0 0 0 2 12 779 521 521
307533 1001043 1001043 1 3 1 0 0 2 1 1129 528 528
307534 1001043 1001043 0 3 0 0 0 2 1 1197 679 679

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