gamepenalties

29 rows where game_id = 1001092

✎ 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
308551 1001092 1001092 0 1 1 0 0 2 3 41 334 334
308552 1001092 1001092 0 1 0 0 0 5 13 352 334 334
308553 1001092 1001092 1 1 0 0 0 5 13 352 204 204
308554 1001092 1001092 0 1 0 0 0 5 13 354 294 294
308555 1001092 1001092 1 1 0 0 0 5 13 354 182 182
308556 1001092 1001092 0 1 0 0 0 5 13 368 359 359
308557 1001092 1001092 1 1 0 0 0 5 13 368 166 166
308558 1001092 1001092 0 1 0 0 0 5 13 369 318 318
308559 1001092 1001092 1 1 0 0 0 5 13 369 212 212
308560 1001092 1001092 0 1 1 0 0 2 7 434 315 315
308561 1001092 1001092 0 1 0 0 0 5 13 883 334 334
308562 1001092 1001092 0 1 1 0 0 2 6 883 352 352
308563 1001092 1001092 0 1 0 0 0 2 9 883 352 352
308564 1001092 1001092 1 1 0 0 0 2 9 883 208 208
308565 1001092 1001092 1 1 0 0 0 5 13 883 209 209
308566 1001092 1001092 0 1 1 0 0 2 15 919 315 315
308567 1001092 1001092 0 1 1 0 0 2 3 988 300 300
308568 1001092 1001092 0 1 1 0 0 2 12 988 300 300
308569 1001092 1001092 1 1 1 0 0 2 4 1097 162 162
308570 1001092 1001092 1 2 1 0 0 2 3 209 191 191
308571 1001092 1001092 1 2 1 0 0 2 17 407 212 212
308572 1001092 1001092 0 2 1 0 0 2 10 750 334 334
308573 1001092 1001092 0 2 1 0 0 2 15 956 347 347
308574 1001092 1001092 0 2 1 0 0 2 11 1118 341 341
308575 1001092 1001092 0 3 0 0 0 2 11 465 341 341
308576 1001092 1001092 0 3 0 0 0 10 20 465 359 359
308577 1001092 1001092 1 3 0 0 0 10 20 465 158 158
308578 1001092 1001092 1 3 1 0 0 2 9 465 200 200
308580 1001092 1001092 0 3 1 0 0 2 3 785 270 270

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)
);