home / my_database

gamepenalties

24 rows where game_id = 1001055

✎ 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
307845 1001055 1001055 1 1 1 0 0 2 10 40 667 667
307846 1001055 1001055 1 1 1 0 0 2 3 158 73 73
307847 1001055 1001055 1 1 1 0 0 2 4 257 110 110
307848 1001055 1001055 1 1 1 0 0 2 12 534 332 332
307849 1001055 1001055 0 1 1 0 0 2 3 557 436 436
307850 1001055 1001055 0 1 1 0 0 2 3 709 436 436
307851 1001055 1001055 1 1 1 0 0 2 137 798 115 115
307852 1001055 1001055 0 1 0 0 0 2 6 890 401 401
307853 1001055 1001055 1 1 1 0 0 2 8 893 88 88
307854 1001055 1001055 0 1 1 0 0 2 3 931 696 696
307855 1001055 1001055 1 1 1 0 0 2 4 1109 88 88
307856 1001055 1001055 0 2 1 0 0 2 8 146 448 448
307857 1001055 1001055 1 2 1 0 0 2 3 515 98 98
307858 1001055 1001055 1 2 1 0 0 2 7 676 78 78
307859 1001055 1001055 0 2 1 0 0 2 6 826 421 421
307860 1001055 1001055 0 3 1 0 0 2 4 83 436 436
307861 1001055 1001055 0 3 1 0 0 2 17 257 44 44
307862 1001055 1001055 1 3 1 0 0 2 3 424 98 98
307863 1001055 1001055 0 3 1 0 0 5 19 575 44 44
307864 1001055 1001055 0 3 0 0 0 2 12 938 432 432
307865 1001055 1001055 1 3 0 0 0 2 15 938 667 667
307866 1001055 1001055 0 3 0 0 0 2 9 1200 467 467
307867 1001055 1001055 1 3 0 0 0 2 9 1200 115 115
307868 1001055 1001055 1 3 0 0 0 2 9 1200 78 78

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 915.225ms