gamepenalties

22 rows where game_id = 1001132

✎ 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
309452 1001132 1001132 0 1 1 0 0 2 3 159 385 385
309453 1001132 1001132 0 1 0 0 0 5 13 385 379 379
309454 1001132 1001132 1 1 0 0 0 5 13 385 540 540
309455 1001132 1001132 1 1 1 0 0 2 3 413 544 544
309456 1001132 1001132 1 1 1 0 0 2 3 446 528 528
309457 1001132 1001132 1 1 1 0 0 2 15 537 545 545
309458 1001132 1001132 0 1 1 0 0 2 1 1072 385 385
309459 1001132 1001132 0 2 1 0 0 2 3 66 381 381
309460 1001132 1001132 1 2 1 0 0 2 17 369 534 534
309461 1001132 1001132 0 2 1 0 0 2 8 512 340 340
309462 1001132 1001132 0 2 0 0 0 5 13 672 383 383
309463 1001132 1001132 1 2 0 0 0 5 13 672 521 521
309464 1001132 1001132 0 2 0 0 0 2 6 726 379 379
309465 1001132 1001132 1 2 0 0 0 2 6 726 541 541
309466 1001132 1001132 1 2 1 0 0 2 3 743 530 530
309467 1001132 1001132 0 2 1 0 0 2 34 997 361 361
309468 1001132 1001132 1 2 1 0 0 2 8 1119 534 534
309469 1001132 1001132 0 3 1 0 0 2 1 444 385 385
309470 1001132 1001132 0 3 1 0 0 2 16 537 383 383
309471 1001132 1001132 1 3 1 0 0 2 1 989 527 527
309472 1001132 1001132 1 4 0 0 0 5 40 300 537 537
309473 1001132 1001132 1 4 0 0 0 10 41 300 537 537

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