my_database: gamepenalties: 21 rows where game

21 rows where game_id = 1001070

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
308317	1001070 1001070	0	1	1	2	3	78	231	231
308318	1001070 1001070	1	1	1	2	7	239	401	401
308319	1001070 1001070	0	1	1	2	3	550	231	231
308320	1001070 1001070	1	1	1	2	3	599	467	467
308321	1001070 1001070	0	1	1	2	4	741	227	227
308322	1001070 1001070	1	1	1	2	7	900	474	474
308323	1001070 1001070	1	2	1	2	9	76	436	436
308324	1001070 1001070	1	2	1	2	7	219	453	453
308325	1001070 1001070	0	2	1	2	4	235	226	226
308326	1001070 1001070	0	2	1	2	3	315	244	244
308327	1001070 1001070	0	2	1	2	7	420	685	685
308328	1001070 1001070	1	2	0	2	8	488	696	696
308329	1001070 1001070	0	2	1	2	1	521	242	242
308330	1001070 1001070	1	2	1	2	1	842	473	473
308331	1001070 1001070	0	2	1	5	19	887	231	231
308332	1001070 1001070	1	3	1	2	1	404	448	448
308333	1001070 1001070	0	3	0	2	7	466	231	231
308334	1001070 1001070	0	3	1	2	4	503	685	685
308335	1001070 1001070	1	3	1	2	3	559	436	436
308336	1001070 1001070	1	3	1	2	7	783	673	673
308337	1001070 1001070	1	3	1	2	9	908	696	696

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