home / my_database

gamepenalties

28 rows where game_id = 1001076

✎ 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
308289 1001076 1001076 1 1 1 0 0 2 8 120 625 625
308290 1001076 1001076 0 1 1 0 0 2 3 283 262 262
308291 1001076 1001076 1 1 1 0 0 2 3 404 632 632
308292 1001076 1001076 0 1 1 0 0 2 3 424 248 248
308293 1001076 1001076 0 1 1 0 0 2 3 823 284 284
308294 1001076 1001076 0 1 0 0 0 2 35 823 256 256
308295 1001076 1001076 0 1 0 0 0 5 13 823 256 256
308296 1001076 1001076 0 1 0 0 0 10 36 823 256 256
308297 1001076 1001076 1 1 0 0 0 2 12 823 637 637
308298 1001076 1001076 1 1 0 0 0 5 13 823 637 637
308299 1001076 1001076 1 1 0 0 0 10 20 823 637 637
308300 1001076 1001076 1 1 1 0 0 2 6 1106 634 634
308301 1001076 1001076 0 2 1 0 0 2 3 124 262 262
308302 1001076 1001076 0 2 1 0 0 2 35 244 284 284
308303 1001076 1001076 0 2 1 0 0 5 13 244 284 284
308304 1001076 1001076 0 2 0 0 0 10 36 244 284 284
308305 1001076 1001076 0 2 0 0 0 10 29 244 284 284
308306 1001076 1001076 0 2 0 0 0 10 45 244 277 277
308307 1001076 1001076 1 2 0 0 0 2 32 522 618 618
308308 1001076 1001076 1 2 1 0 0 2 6 900 637 637
308309 1001076 1001076 0 2 1 0 0 2 7 1039 262 262
308310 1001076 1001076 1 2 1 0 0 2 4 1104 639 639
308311 1001076 1001076 1 2 1 0 0 2 7 1111 619 619
308312 1001076 1001076 1 3 1 0 0 2 1 278 628 628
308313 1001076 1001076 1 3 1 0 0 2 10 675 619 619
308314 1001076 1001076 1 3 1 0 0 2 1 841 687 687
308315 1001076 1001076 1 3 1 0 0 2 1 892 714 714
308316 1001076 1001076 0 3 1 0 0 2 1 951 271 271

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