gamepenalties

31 rows where game_id = 1001096

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: home, period_id, powerplay, bench, 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
308596 1001096 1001096 0 1 0 0 0 2 9 193 557 557
308597 1001096 1001096 1 1 0 0 0 2 9 193 509 509
308598 1001096 1001096 1 1 1 0 0 2 8 260 484 484
308599 1001096 1001096 1 1 1 0 0 2 4 371 512 512
308600 1001096 1001096 1 1 1 0 0 2 4 374 695 695
308601 1001096 1001096 0 1 1 0 0 2 1 757 557 557
308602 1001096 1001096 0 1 0 0 0 2 12 909 558 558
308603 1001096 1001096 1 1 0 0 0 2 12 909 444 444
308604 1001096 1001096 0 2 0 0 0 5 13 92 565 565
308605 1001096 1001096 1 2 1 0 0 2 14 92 513 513
308606 1001096 1001096 1 2 0 0 0 5 13 92 513 513
308607 1001096 1001096 1 2 1 0 0 2 3 373 512 512
308608 1001096 1001096 0 2 0 0 0 5 13 392 548 548
308609 1001096 1001096 1 2 1 1 0 2 31 392 0 529
308610 1001096 1001096 1 2 0 0 0 5 13 392 444 444
308611 1001096 1001096 0 2 1 0 0 2 2 491 550 550
308612 1001096 1001096 0 2 1 0 0 2 16 656 564 564
308613 1001096 1001096 1 2 1 0 0 2 4 671 514 514
308614 1001096 1001096 0 2 0 0 0 5 13 950 558 558
308615 1001096 1001096 0 2 0 0 0 10 110 950 558 558
308616 1001096 1001096 1 2 1 0 0 2 9 950 444 444
308617 1001096 1001096 1 2 0 0 0 5 13 950 444 444
308618 1001096 1001096 1 2 1 0 0 2 7 1026 512 512
308619 1001096 1001096 0 2 1 0 0 2 10 1158 551 551
308620 1001096 1001096 0 2 0 0 0 5 13 1158 551 551
308621 1001096 1001096 1 2 0 0 0 5 13 1158 529 529
308622 1001096 1001096 0 2 1 0 0 2 2 1167 572 572
308623 1001096 1001096 0 3 1 1 0 2 5 426 0 552
308624 1001096 1001096 0 3 1 0 0 2 3 578 549 549
308625 1001096 1001096 0 3 1 0 0 2 3 923 556 556
308626 1001096 1001096 1 3 1 0 0 2 1 1047 491 491

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