gamepenalties

34 rows where game_id = 1001130

✎ 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
309623 1001130 1001130 1 1 1 0 0 2 3 27 398 398
309624 1001130 1001130 0 1 1 1 0 2 5 108 0 439
309625 1001130 1001130 0 1 1 0 0 2 7 193 428 428
309626 1001130 1001130 0 1 1 0 0 2 7 557 374 374
309627 1001130 1001130 0 1 1 0 0 2 12 674 409 409
309628 1001130 1001130 1 1 1 0 0 2 9 697 436 436
309629 1001130 1001130 1 1 1 0 0 2 3 740 753 753
309630 1001130 1001130 1 1 1 0 0 2 4 962 44 44
309631 1001130 1001130 1 1 1 0 0 2 3 1093 421 421
309632 1001130 1001130 1 2 1 0 0 2 3 130 733 733
309633 1001130 1001130 0 2 0 0 0 5 21 650 718 718
309634 1001130 1001130 0 2 0 0 0 10 22 650 718 718
309635 1001130 1001130 1 2 0 0 0 5 21 650 436 436
309636 1001130 1001130 1 2 0 0 0 10 22 650 436 436
309637 1001130 1001130 0 2 0 0 0 2 9 1044 439 439
309638 1001130 1001130 1 2 0 0 0 2 9 1044 401 401
309639 1001130 1001130 1 3 1 1 0 2 31 270 0 398
309640 1001130 1001130 1 3 1 0 0 2 17 346 463 463
309641 1001130 1001130 0 3 1 0 0 2 17 369 414 414
309642 1001130 1001130 1 3 1 0 0 2 6 652 401 401
309643 1001130 1001130 0 3 0 0 0 2 9 837 374 374
309644 1001130 1001130 1 3 0 0 0 2 9 837 44 44
309645 1001130 1001130 1 3 1 0 0 2 8 965 693 693
309646 1001130 1001130 1 3 1 0 0 2 15 1037 465 465
309647 1001130 1001130 1 3 1 0 0 2 6 1072 44 44
309648 1001130 1001130 1 3 1 0 0 2 12 1072 44 44
309649 1001130 1001130 0 3 0 1 0 2 64 1200 0 -1
309650 1001130 1001130 0 3 0 0 0 2 9 1200 345 345
309651 1001130 1001130 0 3 0 0 0 5 13 1200 410 410
309652 1001130 1001130 0 3 0 0 0 2 9 1200 426 426
309654 1001130 1001130 1 3 0 1 0 2 64 1200 0 -1
309655 1001130 1001130 1 3 0 0 0 2 9 1200 401 401
309657 1001130 1001130 1 3 0 0 0 2 9 1200 762 762
309658 1001130 1001130 1 3 0 0 0 5 13 1200 693 693

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