gamepenalties

29 rows where game_id = 1001035

✎ 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
307317 1001035 1001035 1 1 1 0 0 2 9 47 439 439
307318 1001035 1001035 0 1 1 1 0 2 5 392 0 573
307319 1001035 1001035 0 1 1 0 0 2 3 424 609 609
307320 1001035 1001035 1 1 1 0 0 2 7 521 387 387
307321 1001035 1001035 1 1 1 0 0 2 7 564 327 327
307322 1001035 1001035 1 1 1 0 0 2 8 690 430 430
307323 1001035 1001035 1 1 1 0 0 2 8 1200 345 345
307324 1001035 1001035 0 2 1 0 0 2 1 238 602 602
307325 1001035 1001035 0 2 1 0 0 2 3 238 602 602
307326 1001035 1001035 1 2 0 0 0 2 3 379 345 345
307327 1001035 1001035 1 2 1 0 0 2 7 470 416 416
307328 1001035 1001035 0 2 0 0 0 2 9 652 612 612
307330 1001035 1001035 1 2 0 0 0 2 9 652 439 439
307332 1001035 1001035 0 2 0 0 0 5 13 683 601 601
307333 1001035 1001035 1 2 0 0 0 5 13 683 442 442
307334 1001035 1001035 0 2 0 0 0 2 12 988 574 574
307335 1001035 1001035 1 2 0 0 0 2 12 988 400 400
307336 1001035 1001035 0 2 0 0 0 5 13 1115 574 574
307337 1001035 1001035 1 2 0 0 0 5 13 1115 400 400
307338 1001035 1001035 0 2 1 0 0 2 3 1140 553 553
307339 1001035 1001035 0 2 1 0 0 2 4 1150 563 563
307340 1001035 1001035 0 3 1 0 0 2 3 114 613 613
307341 1001035 1001035 1 3 1 0 0 2 3 264 345 345
307342 1001035 1001035 0 3 1 0 0 2 18 484 559 559
307343 1001035 1001035 1 3 1 0 0 2 7 581 422 422
307344 1001035 1001035 0 3 1 0 0 2 7 735 612 612
307345 1001035 1001035 0 3 1 1 0 2 12 931 0 573
307346 1001035 1001035 0 3 1 0 0 10 51 931 601 601
307347 1001035 1001035 0 3 1 0 0 2 15 1150 606 606

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