gamepenalties

27 rows where game_id = 1001053

✎ 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
307755 1001053 1001053 0 1 1 0 0 2 9 272 433 433
307756 1001053 1001053 0 1 0 0 0 2 9 308 489 489
307757 1001053 1001053 0 1 0 0 0 2 9 308 494 494
307758 1001053 1001053 1 1 1 0 0 2 9 308 318 318
307760 1001053 1001053 1 1 0 0 0 2 9 308 359 359
307761 1001053 1001053 0 1 1 0 0 2 1 425 485 485
307762 1001053 1001053 0 1 0 0 0 2 9 549 433 433
307763 1001053 1001053 1 1 0 0 0 2 9 549 299 299
307764 1001053 1001053 1 1 1 0 0 2 7 1005 352 352
307765 1001053 1001053 0 1 0 0 0 5 13 1123 490 490
307766 1001053 1001053 1 1 0 0 0 5 13 1123 268 268
307767 1001053 1001053 0 1 0 0 0 5 13 1125 472 472
307768 1001053 1001053 1 1 0 0 0 5 13 1125 334 334
307769 1001053 1001053 0 1 0 0 0 10 20 1176 438 438
307770 1001053 1001053 0 1 0 0 0 10 20 1176 503 503
307771 1001053 1001053 0 1 1 0 0 2 9 1176 497 497
307772 1001053 1001053 1 1 0 0 0 10 20 1176 359 359
307773 1001053 1001053 0 2 1 0 0 2 6 244 458 458
307774 1001053 1001053 0 2 1 0 0 2 8 393 451 451
307775 1001053 1001053 1 2 1 0 0 2 7 474 331 331
307776 1001053 1001053 1 2 1 0 0 2 3 707 359 359
307777 1001053 1001053 1 2 1 0 0 2 3 1010 315 315
307778 1001053 1001053 0 3 1 0 0 2 3 106 490 490
307779 1001053 1001053 1 3 1 0 0 2 15 592 318 318
307780 1001053 1001053 0 3 1 0 0 2 7 658 443 443
307781 1001053 1001053 1 3 1 0 0 2 4 721 352 352
307782 1001053 1001053 1 3 1 0 0 2 6 823 359 359

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