my_database: gamepenalties: 15 rows where game

15 rows where game_id = 1001060

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
307997	1001060 1001060	1	1	1	2	4	140	87	87
307998	1001060 1001060	0	1	1	2	7	322	630	630
307999	1001060 1001060	1	1	1	2	3	468	104	104
308000	1001060 1001060	0	1	1	2	1	673	630	630
308001	1001060 1001060	0	2	1	2	3	94	620	620
308002	1001060 1001060	0	2	1	2	4	170	687	687
308003	1001060 1001060	0	2	1	2	3	234	624	624
308004	1001060 1001060	1	2	1	2	1	529	164	164
308005	1001060 1001060	1	2	1	2	14	731	131	131
308006	1001060 1001060	0	2	1	2	3	907	624	624
308007	1001060 1001060	0	3	1	2	8	334	619	619
308008	1001060 1001060	0	3	1	2	1	487	626	626
308009	1001060 1001060	0	3	1	2	4	674	639	639
308010	1001060 1001060	1	3	1	2	3	1062	131	131
308011	1001060 1001060	1	3	1	2	15	1096	155	155

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