my_database: gamepenalties: 18 rows where game

18 rows where game_id = 1001050

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
307559	1001050 1001050	1	1	1	2	6	40	13	13
307560	1001050 1001050	1	1	1	2	6	180	13	13
307561	1001050 1001050	1	1	1	2	12	389	5	5
307562	1001050 1001050	0	1	1	2	3	499	195	195
307563	1001050 1001050	1	1	1	2	3	539	24	24
307564	1001050 1001050	1	1	1	2	34	1074	6	6
307565	1001050 1001050	1	2	1	2	4	172	21	21
307566	1001050 1001050	0	2	1	2	7	331	195	195
307567	1001050 1001050	0	2	1	2	14	485	146	146
307568	1001050 1001050	1	2	1	2	3	782	12	12
307569	1001050 1001050	1	2	1	2	3	856	4	4
307570	1001050 1001050	0	3	1	2	4	92	136	136
307571	1001050 1001050	0	3	1	2	6	351	142	142
307572	1001050 1001050	1	3	1	2	3	622	15	15
307573	1001050 1001050	0	3	1	2	3	725	142	142
307574	1001050 1001050	1	3	1	2	34	953	6	6
307575	1001050 1001050	1	3	1	2	12	953	6	6
307576	1001050 1001050	0	3	1	2	3	1031	150	150

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