gamepenalties

40 rows where game_id = 1001080

✎ 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
308338 1001080 1001080 1 1 1 0 0 2 3 34 612 612
308339 1001080 1001080 0 1 1 0 0 2 3 320 400 400
308340 1001080 1001080 0 1 0 0 0 5 13 612 718 718
308341 1001080 1001080 1 1 0 0 0 5 13 612 587 587
308342 1001080 1001080 0 1 0 0 0 5 13 617 439 439
308343 1001080 1001080 0 1 0 0 0 2 9 617 400 400
308344 1001080 1001080 0 1 0 0 0 5 13 617 400 400
308345 1001080 1001080 0 1 0 0 0 10 39 617 400 400
308346 1001080 1001080 1 1 1 0 0 2 6 617 601 601
308347 1001080 1001080 1 1 0 0 0 2 35 617 612 612
308348 1001080 1001080 1 1 0 0 0 5 13 617 612 612
308349 1001080 1001080 1 1 0 0 0 10 36 617 612 612
308350 1001080 1001080 1 1 0 0 0 5 13 617 711 711
308351 1001080 1001080 1 1 0 0 0 10 39 617 711 711
308352 1001080 1001080 0 1 1 0 0 2 3 655 422 422
308353 1001080 1001080 0 1 1 0 0 2 3 813 374 374
308354 1001080 1001080 0 1 1 0 0 2 15 913 345 345
308355 1001080 1001080 1 1 1 0 0 2 3 1102 592 592
308356 1001080 1001080 0 2 1 0 0 2 3 92 374 374
308357 1001080 1001080 0 2 0 0 0 5 13 156 718 718
308358 1001080 1001080 1 2 0 0 0 5 13 156 587 587
308359 1001080 1001080 0 2 0 0 0 2 9 179 430 430
308360 1001080 1001080 1 2 0 0 0 2 12 179 608 608
308361 1001080 1001080 0 2 1 0 0 2 1 295 327 327
308362 1001080 1001080 0 2 1 0 0 2 4 471 407 407
308363 1001080 1001080 0 2 1 0 0 2 17 584 461 461
308364 1001080 1001080 1 2 1 0 0 2 10 593 603 603
308365 1001080 1001080 0 2 0 0 0 2 9 737 718 718
308366 1001080 1001080 0 2 0 0 0 10 20 737 718 718
308367 1001080 1001080 1 2 0 0 0 2 17 737 613 613
308368 1001080 1001080 0 2 1 0 0 2 10 921 422 422
308369 1001080 1001080 1 2 1 0 0 2 4 1079 616 616
308370 1001080 1001080 1 2 1 0 0 2 3 1145 602 602
308371 1001080 1001080 0 3 0 0 0 5 13 597 718 718
308372 1001080 1001080 0 3 0 0 0 10 101 597 718 718
308373 1001080 1001080 1 3 0 0 0 5 13 597 612 612
308374 1001080 1001080 1 3 1 0 0 2 3 730 567 567
308375 1001080 1001080 1 3 1 0 0 2 7 956 616 616
308376 1001080 1001080 0 3 0 0 0 5 13 1192 439 439
308377 1001080 1001080 1 3 0 0 0 5 13 1192 573 573

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