my_database: gamepenalties: 15 rows where game

15 rows where game_id = 1001088

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
308711	1001088 1001088	1	1	1	2	7	24	409	409
308712	1001088 1001088	1	1	1	2	1	329	409	409
308713	1001088 1001088	0	1	1	2	16	419	658	658
308714	1001088 1001088	1	1	1	2	4	607	400	400
308715	1001088 1001088	0	1	1	2	7	1013	657	657
308716	1001088 1001088	1	1	1	2	7	1067	428	428
308717	1001088 1001088	0	2	1	2	7	89	658	658
308718	1001088 1001088	0	2	1	2	1	120	644	644
308719	1001088 1001088	1	2	1	2	9	407	426	426
308720	1001088 1001088	0	2	1	2	3	496	643	643
308721	1001088 1001088	0	2	1	2	4	760	646	646
308722	1001088 1001088	0	3	1	2	1	41	644	644
308723	1001088 1001088	0	3	1	2	7	67	662	662
308724	1001088 1001088	1	3	1	2	1	236	416	416
308725	1001088 1001088	0	3	1	2	9	422	659	659

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