home / my_database

gamepenalties

24 rows where game_id = 1001067

✎ 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
308066 1001067 1001067 0 1 1 0 0 2 3 395 376 376
308067 1001067 1001067 0 1 1 0 0 2 16 497 348 348
308068 1001067 1001067 0 1 0 0 0 5 13 682 379 379
308069 1001067 1001067 1 1 0 0 0 5 13 682 612 612
308070 1001067 1001067 1 1 1 0 0 2 3 690 610 610
308071 1001067 1001067 0 1 1 0 0 2 7 780 340 340
308072 1001067 1001067 0 1 1 0 0 2 15 1055 344 344
308073 1001067 1001067 1 1 1 0 0 2 1 1173 616 616
308074 1001067 1001067 0 2 1 0 0 2 16 64 365 365
308075 1001067 1001067 0 2 0 0 0 5 13 243 392 392
308076 1001067 1001067 1 2 0 0 0 5 13 243 574 574
308077 1001067 1001067 0 2 1 0 0 2 7 304 344 344
308078 1001067 1001067 1 2 1 0 0 2 8 542 563 563
308079 1001067 1001067 0 2 1 0 0 2 12 817 340 340
308080 1001067 1001067 0 2 0 0 0 2 1 817 340 340
308081 1001067 1001067 1 2 0 0 0 2 9 817 612 612
308082 1001067 1001067 1 2 1 0 0 2 17 951 559 559
308083 1001067 1001067 0 2 1 0 0 2 1 1109 392 392
308084 1001067 1001067 1 2 1 0 0 2 7 1147 610 610
308085 1001067 1001067 0 3 1 0 0 2 3 163 385 385
308086 1001067 1001067 0 3 0 0 0 2 9 667 333 333
308087 1001067 1001067 1 3 0 0 0 2 14 667 567 567
308088 1001067 1001067 0 3 0 0 0 2 18 906 376 376
308089 1001067 1001067 1 3 0 0 0 2 15 906 613 613

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)
);
Powered by Datasette · Queries took 888.725ms