gamepenalties

25 rows where game_id = 1001068

✎ 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
308090 1001068 1001068 0 1 0 0 0 5 13 451 334 334
308091 1001068 1001068 1 1 0 0 0 5 13 451 481 481
308092 1001068 1001068 0 1 1 0 0 2 6 505 341 341
308093 1001068 1001068 0 1 0 0 0 5 13 807 294 294
308094 1001068 1001068 1 1 0 0 0 5 13 807 490 490
308095 1001068 1001068 1 1 1 0 0 2 1 884 466 466
308096 1001068 1001068 0 1 0 0 0 2 9 1022 334 334
308097 1001068 1001068 1 1 0 0 0 2 9 1022 433 433
308098 1001068 1001068 1 1 1 0 0 2 3 1104 494 494
308099 1001068 1001068 0 2 1 0 0 2 14 26 322 322
308100 1001068 1001068 0 2 1 0 0 2 11 304 299 299
308101 1001068 1001068 1 2 1 0 0 2 6 453 456 456
308102 1001068 1001068 1 2 1 0 0 2 3 737 494 494
308103 1001068 1001068 0 2 1 0 0 2 15 1050 270 270
308104 1001068 1001068 1 2 1 0 0 2 10 1160 469 469
308105 1001068 1001068 0 3 1 0 0 2 4 162 359 359
308106 1001068 1001068 1 3 0 0 0 2 7 206 456 456
308107 1001068 1001068 0 3 1 0 0 2 4 217 279 279
308108 1001068 1001068 0 3 0 0 0 2 9 499 359 359
308109 1001068 1001068 1 3 1 0 0 2 10 499 469 469
308110 1001068 1001068 1 3 0 0 0 2 9 499 469 469
308111 1001068 1001068 1 3 1 0 0 2 3 727 501 501
308112 1001068 1001068 1 3 1 0 0 2 3 1037 423 423
308113 1001068 1001068 0 3 1 0 0 2 7 1052 270 270
308114 1001068 1001068 1 3 1 0 0 2 4 1137 458 458

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