home / my_database

gamepenalties

23 rows where game_id = 1001128

✎ 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
309415 1001128 1001128 1 1 1 0 0 2 3 245 342 342
309416 1001128 1001128 0 1 1 0 0 2 8 466 445 445
309417 1001128 1001128 0 1 1 0 0 2 1 569 467 467
309418 1001128 1001128 0 1 1 0 0 2 15 619 463 463
309419 1001128 1001128 1 1 1 0 0 2 9 916 286 286
309420 1001128 1001128 0 1 1 0 0 2 7 1162 44 44
309421 1001128 1001128 1 2 1 0 0 2 4 344 349 349
309422 1001128 1001128 1 2 1 0 0 2 6 413 280 280
309423 1001128 1001128 0 2 1 0 0 2 10 560 445 445
309424 1001128 1001128 0 2 1 0 0 2 3 645 421 421
309425 1001128 1001128 1 2 1 0 0 2 15 1123 266 266
309426 1001128 1001128 0 3 1 0 0 5 27 77 467 467
309427 1001128 1001128 0 3 0 0 0 10 28 77 467 467
309428 1001128 1001128 1 3 1 0 0 2 8 294 286 286
309429 1001128 1001128 0 3 1 0 0 2 3 424 474 474
309430 1001128 1001128 0 3 1 0 0 2 1 441 762 762
309431 1001128 1001128 0 3 1 0 0 2 7 565 436 436
309432 1001128 1001128 1 3 0 0 0 2 6 626 305 305
309433 1001128 1001128 0 3 1 0 0 2 3 658 733 733
309434 1001128 1001128 0 3 0 0 0 2 9 722 44 44
309435 1001128 1001128 1 3 0 0 0 2 1 722 259 259
309436 1001128 1001128 1 3 1 0 0 2 1 905 323 323
309437 1001128 1001128 0 3 1 0 0 2 7 1195 465 465

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