my_database: gamepenalties: 19 rows where game

19 rows where game_id = 1001099

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
308885	1001099 1001099	0	1	1	2	1	189	38	38
308886	1001099 1001099	0	1	1	2	3	418	91	91
308887	1001099 1001099	0	1	1	2	3	543	76	76
308888	1001099 1001099	1	1	1	2	3	683	678	678
308889	1001099 1001099	1	1	1	2	4	829	193	193
308890	1001099 1001099	0	1	1	2	8	946	91	91
308891	1001099 1001099	0	1	1	2	3	1051	74	74
308892	1001099 1001099	1	2	1	2	4	197	167	167
308893	1001099 1001099	0	2	1	2	6	332	50	50
308894	1001099 1001099	1	2	1	2	3	610	186	186
308895	1001099 1001099	0	2	1	2	1	841	76	76
308896	1001099 1001099	1	2	1	2	3	1076	217	217
308897	1001099 1001099	0	3	1	2	7	49	61	61
308898	1001099 1001099	0	3	1	2	15	112	76	76
308899	1001099 1001099	1	3	1	2	7	136	193	193
308900	1001099 1001099	1	3	1	2	3	764	180	180
308901	1001099 1001099	1	3	1	2	7	957	174	174
308902	1001099 1001099	1	3	1	2	3	1045	189	189
308903	1001099 1001099	1	3	1	2	3	1120	207	207

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