my_database: gamepenalties: 28 rows where game

28 rows where game_id = 1001083

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
308437	1001083 1001083	0	1	0	2	3	12	372	372
308438	1001083 1001083	1	1	0	2	18	12	320	320
308439	1001083 1001083	0	1	0	5	13	162	383	383
308440	1001083 1001083	1	1	0	5	13	162	290	290
308441	1001083 1001083	0	1	1	2	9	182	379	379
308442	1001083 1001083	0	1	0	10	33	182	379	379
308443	1001083 1001083	1	1	1	2	4	313	266	266
308444	1001083 1001083	1	1	1	2	1	373	259	259
308445	1001083 1001083	0	1	1	2	1	706	383	383
308446	1001083 1001083	1	1	1	2	6	901	273	273
308447	1001083 1001083	1	1	1	2	15	998	338	338
308448	1001083 1001083	0	2	1	2	4	258	385	385
308449	1001083 1001083	0	2	1	2	4	647	344	344
308450	1001083 1001083	1	2	1	2	8	665	275	275
308451	1001083 1001083	0	2	1	2	7	820	361	361
308452	1001083 1001083	1	2	1	2	1	1118	266	266
308453	1001083 1001083	0	3	0	5	13	319	383	383
308454	1001083 1001083	1	3	0	5	13	319	307	307
308455	1001083 1001083	0	3	0	5	13	414	379	379
308456	1001083 1001083	1	3	0	5	13	414	320	320
308457	1001083 1001083	0	3	1	2	7	649	371	371
308458	1001083 1001083	1	3	1	2	14	752	716	716
308459	1001083 1001083	1	3	1	2	3	844	320	320
308460	1001083 1001083	0	3	1	2	3	1002	390	390
308461	1001083 1001083	0	3	1	2	9	1040	333	333
308462	1001083 1001083	0	3	1	2	1	1113	361	361
308463	1001083 1001083	1	3	1	2	7	1193	286	286
308464	1001083 1001083	1	4	1	2	7	156	273	273

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