home / my_database

gamepenalties

29 rows where game_id = 1001040

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: home, period_id, powerplay, bench, 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
307446 1001040 1001040 1 1 1 0 0 2 6 80 567 567
307447 1001040 1001040 0 1 1 0 0 2 16 268 232 232
307448 1001040 1001040 1 1 1 0 0 2 3 685 573 573
307449 1001040 1001040 1 1 1 0 0 2 4 689 608 608
307450 1001040 1001040 1 1 1 1 0 2 5 834 0 573
307451 1001040 1001040 0 1 1 0 0 2 1 887 226 226
307452 1001040 1001040 0 1 1 0 0 2 7 918 223 223
307453 1001040 1001040 1 1 1 0 0 2 3 1067 608 608
307454 1001040 1001040 0 1 1 0 0 2 7 1080 231 231
307455 1001040 1001040 0 1 0 0 0 5 13 1116 246 246
307456 1001040 1001040 0 1 1 0 0 2 9 1116 223 223
307457 1001040 1001040 1 1 0 0 0 5 13 1116 592 592
307458 1001040 1001040 1 2 1 0 0 2 11 192 612 612
307459 1001040 1001040 1 2 1 0 0 2 3 408 563 563
307460 1001040 1001040 0 2 1 0 0 2 4 432 231 231
307461 1001040 1001040 1 2 1 0 0 2 3 451 610 610
307462 1001040 1001040 0 2 1 0 0 2 1 740 223 223
307463 1001040 1001040 0 2 0 0 0 5 13 939 237 237
307464 1001040 1001040 1 2 1 0 0 2 35 939 608 608
307465 1001040 1001040 1 2 0 0 0 5 13 939 608 608
307466 1001040 1001040 1 2 0 0 0 10 36 939 608 608
307467 1001040 1001040 0 2 1 0 0 2 7 1140 226 226
307468 1001040 1001040 0 2 0 0 0 2 9 1140 226 226
307469 1001040 1001040 1 2 0 0 0 2 9 1140 606 606
307470 1001040 1001040 0 2 0 0 0 5 13 1197 232 232
307471 1001040 1001040 0 2 1 0 0 2 6 1200 234 234
307472 1001040 1001040 0 3 1 0 0 2 16 972 246 246
307473 1001040 1001040 0 3 0 0 0 2 6 1200 233 233
307474 1001040 1001040 1 3 0 0 0 2 6 1200 567 567

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