my_database: gamepenalties: 20 rows where game

20 rows where game_id = 1001036

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
307475	1001036 1001036	0	1	1	2	4	82	119	119
307476	1001036 1001036	0	1	1	2	1	301	78	78
307477	1001036 1001036	0	1	1	2	3	518	123	123
307478	1001036 1001036	1	1	1	2	7	545	371	371
307479	1001036 1001036	1	1	1	2	14	760	382	382
307480	1001036 1001036	1	1	1	2	15	835	372	372
307481	1001036 1001036	1	1	1	2	3	957	386	386
307482	1001036 1001036	0	1	1	2	16	1194	78	78
307483	1001036 1001036	0	2	1	2	9	417	78	78
307484	1001036 1001036	0	2	1	2	7	551	81	81
307485	1001036 1001036	0	2	1	2	16	578	123	123
307486	1001036 1001036	1	2	1	2	9	780	344	344
307487	1001036 1001036	0	2	0	2	9	784	79	79
307488	1001036 1001036	1	2	1	2	9	784	379	379
307490	1001036 1001036	0	2	1	2	3	946	73	73
307491	1001036 1001036	0	2	1	2	4	1081	110	110
307492	1001036 1001036	1	3	1	2	3	443	348	348
307493	1001036 1001036	0	3	1	2	4	845	99	99
307494	1001036 1001036	0	3	1	2	1	999	98	98
307495	1001036 1001036	1	3	1	2	3	1007	372	372

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