my_database: gamepenalties: 15 rows where game

15 rows where game_id = 1001116

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
309125	1001116 1001116	0	1	1	2	4	153	279	279
309126	1001116 1001116	1	1	1	2	8	323	147	147
309127	1001116 1001116	0	1	1	2	3	587	322	322
309128	1001116 1001116	1	1	1	2	15	849	108	108
309129	1001116 1001116	0	1	1	2	4	1035	359	359
309130	1001116 1001116	1	1	1	2	9	1158	108	108
309131	1001116 1001116	0	2	1	2	16	304	315	315
309132	1001116 1001116	0	2	1	2	3	580	359	359
309133	1001116 1001116	0	2	1	2	9	628	318	318
309134	1001116 1001116	1	2	1	2	1	778	160	160
309135	1001116 1001116	1	2	1	2	1	857	169	169
309136	1001116 1001116	0	2	1	2	3	1153	331	331
309137	1001116 1001116	0	2	1	2	2	1179	347	347
309138	1001116 1001116	1	3	1	2	8	278	102	102
309139	1001116 1001116	1	3	1	2	15	1080	169	169

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