my_database: gamepenalties: 34 rows where game

34 rows where game_id = 1001049

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
307633	1001049 1001049	1	1	1	2	3	56	370	370
307634	1001049 1001049	1	1	1	2	4	79	356	356
307635	1001049 1001049	0	1	1	2	7	188	489	489
307636	1001049 1001049	0	1	1	2	3	444	494	494
307637	1001049 1001049	1	1	1	2	4	484	346	346
307638	1001049 1001049	0	1	1	2	6	577	498	498
307639	1001049 1001049	0	1	1	2	4	801	443	443
307640	1001049 1001049	0	1	1	2	3	865	438	438
307641	1001049 1001049	1	1	1	2	4	1001	356	356
307642	1001049 1001049	0	1	1	2	9	1112	415	415
307643	1001049 1001049	0	1	0	2	9	1134	458	458
307644	1001049 1001049	1	1	0	2	9	1134	412	412
307646	1001049 1001049	0	1	1	2	6	1166	469	469
307647	1001049 1001049	0	2	0	2	9	186	472	472
307648	1001049 1001049	0	2	1	2	3	186	481	481
307649	1001049 1001049	1	2	0	2	9	186	389	389
307650	1001049 1001049	0	2	1	2	6	289	415	415
307651	1001049 1001049	0	2	0	2	6	325	481	481
307652	1001049 1001049	1	2	0	2	18	325	306	306
307653	1001049 1001049	0	2	0	2	9	400	433	433
307654	1001049 1001049	1	2	0	2	9	400	314	314
307655	1001049 1001049	1	2	1	2	3	438	370	370
307656	1001049 1001049	0	2	1	2	7	576	456	456
307657	1001049 1001049	0	2	0	5	13	727	506	506
307658	1001049 1001049	1	2	0	5	13	727	389	389
307659	1001049 1001049	0	2	1	2	4	733	502	502
307660	1001049 1001049	1	2	0	2	9	788	356	356
307661	1001049 1001049	0	2	1	2	8	828	469	469
307662	1001049 1001049	0	2	1	2	3	1044	458	458
307663	1001049 1001049	1	3	1	2	3	583	370	370
307664	1001049 1001049	0	3	1	2	1	606	498	498
307665	1001049 1001049	0	3	1	2	3	773	438	438
307666	1001049 1001049	1	3	1	2	7	945	319	319
307667	1001049 1001049	1	3	1	2	3	1053	370	370

Advanced export

JSON shape: default, array, newline-delimited, object

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