my_database: gamepenalties: 29 rows where game

29 rows where game_id = 1001089

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
308748	1001089 1001089	1	1	1	2	3	256	723	723
308749	1001089 1001089	0	1	1	2	16	548	544	544
308750	1001089 1001089	0	1	1	2	3	687	535	535
308751	1001089 1001089	0	1	0	2	6	751	545	545
308752	1001089 1001089	1	1	0	2	17	751	723	723
308753	1001089 1001089	0	1	0	2	9	1055	521	521
308754	1001089 1001089	1	1	0	2	9	1055	348	348
308755	1001089 1001089	0	2	1	2	3	207	541	541
308756	1001089 1001089	1	2	1	2	3	288	344	344
308757	1001089 1001089	1	2	1	2	3	433	361	361
308758	1001089 1001089	0	2	1	2	15	500	541	541
308759	1001089 1001089	0	2	1	2	12	535	528	528
308760	1001089 1001089	0	2	1	2	16	535	528	528
308761	1001089 1001089	0	2	0	5	13	802	540	540
308762	1001089 1001089	1	2	0	5	13	802	385	385
308763	1001089 1001089	1	2	1	2	1	1096	379	379
308764	1001089 1001089	0	2	1	2	2	1148	730	730
308765	1001089 1001089	1	2	1	2	3	1191	348	348
308766	1001089 1001089	1	3	1	2	4	66	361	361
308767	1001089 1001089	0	3	1	2	6	306	521	521
308768	1001089 1001089	0	3	1	2	14	594	521	521
308769	1001089 1001089	1	3	1	2	8	668	724	724
308770	1001089 1001089	0	3	0	2	9	736	534	534
308771	1001089 1001089	0	3	0	2	14	736	535	535
308772	1001089 1001089	1	3	0	2	9	736	348	348
308773	1001089 1001089	1	3	0	2	9	736	340	340
308774	1001089 1001089	0	3	1	2	6	858	543	543
308775	1001089 1001089	1	3	1	2	3	949	390	390
308776	1001089 1001089	1	3	1	2	7	1093	361	361

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