gamepenalties

32 rows where game_id = 1001085

✎ 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
308493 1001085 1001085 0 1 1 0 0 2 15 248 613 613
308494 1001085 1001085 0 1 1 0 0 2 6 386 574 574
308495 1001085 1001085 0 1 1 0 0 2 3 473 559 559
308496 1001085 1001085 1 1 1 0 0 2 1 697 224 224
308497 1001085 1001085 1 1 1 0 0 2 3 853 244 244
308498 1001085 1001085 0 2 1 0 0 2 6 162 563 563
308499 1001085 1001085 1 2 1 0 0 2 3 275 231 231
308500 1001085 1001085 0 2 0 0 0 2 8 409 602 602
308501 1001085 1001085 1 2 0 0 0 2 34 409 224 224
308502 1001085 1001085 1 2 1 0 0 2 3 462 70 70
308503 1001085 1001085 0 2 0 0 0 2 9 689 612 612
308504 1001085 1001085 1 2 0 0 0 2 9 689 242 242
308505 1001085 1001085 1 2 1 0 0 2 3 938 231 231
308506 1001085 1001085 1 2 1 0 0 2 9 948 249 249
308507 1001085 1001085 0 2 1 0 0 2 3 1098 601 601
308508 1001085 1001085 0 3 1 0 0 2 8 26 592 592
308509 1001085 1001085 0 3 0 0 0 2 9 72 607 607
308510 1001085 1001085 1 3 0 0 0 2 9 72 70 70
308511 1001085 1001085 1 3 1 0 0 2 9 72 246 246
308512 1001085 1001085 0 3 1 0 0 5 67 596 574 574
308513 1001085 1001085 0 3 1 0 0 2 4 737 602 602
308514 1001085 1001085 0 3 1 0 0 2 1 820 612 612
308515 1001085 1001085 1 3 1 0 0 2 4 967 224 224
308516 1001085 1001085 0 3 0 0 0 5 13 1134 608 608
308517 1001085 1001085 0 3 0 0 0 5 13 1134 612 612
308518 1001085 1001085 0 3 0 0 0 10 39 1134 612 612
308519 1001085 1001085 1 3 0 0 0 5 13 1134 244 244
308520 1001085 1001085 1 3 0 0 0 10 39 1134 244 244
308521 1001085 1001085 1 3 1 0 0 2 1 1134 242 242
308522 1001085 1001085 1 3 0 0 0 5 13 1134 224 224
308523 1001085 1001085 1 3 0 0 0 10 29 1134 224 224
308524 1001085 1001085 1 3 0 0 0 2 3 1200 233 233

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