gamepenalties

21 rows where game_id = 1001064

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: home, period_id, powerplay, 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
308012 1001064 1001064 0 1 1 0 0 2 3 36 184 184
308013 1001064 1001064 0 1 1 0 0 2 4 150 150 150
308014 1001064 1001064 1 1 1 0 0 2 7 434 511 511
308015 1001064 1001064 0 1 1 0 0 2 3 717 159 159
308016 1001064 1001064 1 1 1 0 0 2 4 780 492 492
308017 1001064 1001064 0 1 1 0 0 2 7 938 179 179
308018 1001064 1001064 0 1 1 0 0 2 4 1042 142 142
308019 1001064 1001064 0 1 1 0 0 2 12 1042 142 142
308020 1001064 1001064 0 2 1 0 0 2 7 103 195 195
308021 1001064 1001064 0 2 1 0 0 2 3 471 153 153
308022 1001064 1001064 0 2 1 0 0 2 6 668 179 179
308023 1001064 1001064 1 2 1 0 0 2 4 805 504 504
308024 1001064 1001064 1 2 1 0 0 2 8 1151 495 495
308025 1001064 1001064 1 3 1 0 0 2 4 308 440 440
308026 1001064 1001064 1 3 1 0 0 2 3 327 408 408
308027 1001064 1001064 0 3 0 0 0 2 9 429 156 156
308028 1001064 1001064 0 3 0 0 0 2 9 429 142 142
308029 1001064 1001064 1 3 0 0 0 2 9 429 511 511
308030 1001064 1001064 1 3 0 0 0 2 9 429 413 413
308031 1001064 1001064 1 3 1 0 0 2 1 1031 504 504
308032 1001064 1001064 1 3 1 0 0 2 3 1123 403 403

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