my_database: gamepenalties: 17 rows where game

17 rows where game_id = 1001121

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
309299	1001121 1001121	1	1	1	2	3	394	158	158
309300	1001121 1001121	1	1	1	2	16	481	158	158
309301	1001121 1001121	1	1	1	2	3	656	162	162
309302	1001121 1001121	0	1	1	2	7	809	502	502
309303	1001121 1001121	0	2	1	2	3	265	433	433
309304	1001121 1001121	0	2	1	2	1	402	423	423
309305	1001121 1001121	1	2	1	2	3	619	208	208
309306	1001121 1001121	0	2	1	2	4	839	502	502
309307	1001121 1001121	1	2	1	2	10	963	166	166
309308	1001121 1001121	0	2	1	2	8	1197	481	481
309309	1001121 1001121	1	3	1	2	3	221	204	204
309310	1001121 1001121	1	3	1	2	3	367	204	204
309311	1001121 1001121	0	3	1	2	15	521	433	433
309312	1001121 1001121	1	3	1	2	3	607	482	482
309313	1001121 1001121	0	3	1	2	34	744	485	485
309314	1001121 1001121	0	3	1	2	4	790	438	438
309315	1001121 1001121	1	3	1	2	3	963	191	191

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