my_database: gamepenalties: 19 rows where game

19 rows where game_id = 1001073

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
308162	1001073 1001073	0	1	1	2	4	61	385	385
308163	1001073 1001073	1	1	1	2	3	209	682	682
308164	1001073 1001073	1	1	1	2	10	243	522	522
308165	1001073 1001073	0	1	1	2	7	376	385	385
308166	1001073 1001073	0	1	1	2	3	804	344	344
308167	1001073 1001073	0	1	1	2	16	873	365	365
308168	1001073 1001073	0	1	1	2	3	973	382	382
308169	1001073 1001073	0	2	1	2	7	28	371	371
308170	1001073 1001073	1	2	1	2	4	403	540	540
308171	1001073 1001073	0	2	1	2	16	532	390	390
308172	1001073 1001073	0	2	1	2	6	540	699	699
308173	1001073 1001073	1	2	1	2	7	876	545	545
308174	1001073 1001073	1	2	1	2	15	906	544	544
308175	1001073 1001073	0	2	1	2	9	1145	348	348
308176	1001073 1001073	0	3	1	2	4	172	390	390
308177	1001073 1001073	0	3	1	2	1	367	340	340
308178	1001073 1001073	0	3	1	2	4	670	382	382
308179	1001073 1001073	1	3	1	2	3	827	537	537
308180	1001073 1001073	0	3	1	2	7	1195	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)
);