my_database: gamepenalties: 18 rows where game

18 rows where game_id = 1001081

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
308419	1001081 1001081	1	1	1	2	7	99	439	439
308420	1001081 1001081	0	1	1	2	3	274	112	112
308421	1001081 1001081	1	1	1	2	1	371	374	374
308422	1001081 1001081	0	1	1	2	3	545	105	105
308423	1001081 1001081	1	1	1	2	7	660	400	400
308424	1001081 1001081	1	1	1	2	7	755	345	345
308425	1001081 1001081	1	1	1	2	3	898	422	422
308426	1001081 1001081	0	1	1	2	7	1051	105	105
308427	1001081 1001081	1	1	1	2	3	1160	430	430
308428	1001081 1001081	0	2	1	2	1	112	79	79
308429	1001081 1001081	1	2	1	2	14	391	718	718
308430	1001081 1001081	0	2	1	2	3	558	332	332
308431	1001081 1001081	0	2	0	2	9	730	332	332
308432	1001081 1001081	0	2	0	5	13	730	332	332
308433	1001081 1001081	1	2	0	2	9	730	718	718
308434	1001081 1001081	1	2	0	5	13	730	387	387
308435	1001081 1001081	0	3	1	2	4	469	332	332
308436	1001081 1001081	1	3	1	2	6	987	718	718

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