gamepenalties

17 rows where game_id = 1001086

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: home, period_id, powerplay, bench, minutes, penalty, player_penalized, player_server

id ▼ game_id home period_id powerplay bench penalty_shot minutes penalty time_of_penalty_seconds player_penalized player_server
308476 1001086 1001086 0 1 1 0 0 2 3 140 348 348
308477 1001086 1001086 1 1 1 0 0 2 1 338 286 286
308478 1001086 1001086 1 1 0 0 0 2 1 547 320 320
308479 1001086 1001086 0 1 1 0 0 2 16 597 390 390
308480 1001086 1001086 0 1 1 0 0 2 16 624 336 336
308481 1001086 1001086 1 1 1 0 0 5 19 856 273 273
308482 1001086 1001086 0 2 1 0 0 2 1 19 361 361
308483 1001086 1001086 1 2 1 0 0 2 3 160 307 307
308484 1001086 1001086 1 2 1 0 0 2 1 404 323 323
308485 1001086 1001086 0 2 1 1 0 2 5 530 0 385
308486 1001086 1001086 0 2 1 0 0 2 3 828 390 390
308487 1001086 1001086 1 2 1 0 0 2 7 1167 269 269
308488 1001086 1001086 0 3 1 0 0 2 3 219 371 371
308489 1001086 1001086 0 3 1 0 0 2 3 449 336 336
308490 1001086 1001086 0 3 1 0 0 2 4 642 383 383
308491 1001086 1001086 1 3 1 0 0 2 3 650 338 338
308492 1001086 1001086 0 4 1 0 0 2 4 122 336 336

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