my_database: gamepenalties: 23 rows where game

23 rows where game_id = 1001041

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
307706	1001041 1001041	1	1	1	2	3	405	374	374
307707	1001041 1001041	0	1	1	2	7	597	259	259
307708	1001041 1001041	1	1	1	2	1	668	384	384
307709	1001041 1001041	0	1	1	2	16	802	263	263
307710	1001041 1001041	0	1	1	2	1	934	253	253
307711	1001041 1001041	0	1	1	2	3	1070	342	342
307712	1001041 1001041	1	1	1	2	3	1086	409	409
307713	1001041 1001041	0	2	1	2	15	36	273	273
307714	1001041 1001041	0	2	1	2	6	105	296	296
307715	1001041 1001041	1	2	1	5	19	155	410	410
307716	1001041 1001041	1	2	1	2	16	391	327	327
307717	1001041 1001041	0	2	1	2	7	532	342	342
307718	1001041 1001041	0	2	1	2	17	568	307	307
307719	1001041 1001041	0	2	0	2	9	722	320	320
307720	1001041 1001041	1	2	1	2	9	722	439	439
307721	1001041 1001041	1	2	0	2	9	722	400	400
307722	1001041 1001041	0	2	1	2	18	756	259	259
307723	1001041 1001041	0	2	0	10	20	756	320	320
307724	1001041 1001041	1	2	1	2	1	1084	327	327
307725	1001041 1001041	0	3	1	2	3	450	286	286
307726	1001041 1001041	1	3	1	2	9	743	327	327
307727	1001041 1001041	1	3	1	2	6	994	404	404
307728	1001041 1001041	0	3	1	2	1	1014	263	263

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