my_database: gamepenalties: 28 rows where game

28 rows where game_id = 1001076

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
308289	1001076 1001076	1	1	1	2	8	120	625	625
308290	1001076 1001076	0	1	1	2	3	283	262	262
308291	1001076 1001076	1	1	1	2	3	404	632	632
308292	1001076 1001076	0	1	1	2	3	424	248	248
308293	1001076 1001076	0	1	1	2	3	823	284	284
308294	1001076 1001076	0	1	0	2	35	823	256	256
308295	1001076 1001076	0	1	0	5	13	823	256	256
308296	1001076 1001076	0	1	0	10	36	823	256	256
308297	1001076 1001076	1	1	0	2	12	823	637	637
308298	1001076 1001076	1	1	0	5	13	823	637	637
308299	1001076 1001076	1	1	0	10	20	823	637	637
308300	1001076 1001076	1	1	1	2	6	1106	634	634
308301	1001076 1001076	0	2	1	2	3	124	262	262
308302	1001076 1001076	0	2	1	2	35	244	284	284
308303	1001076 1001076	0	2	1	5	13	244	284	284
308304	1001076 1001076	0	2	0	10	36	244	284	284
308305	1001076 1001076	0	2	0	10	29	244	284	284
308306	1001076 1001076	0	2	0	10	45	244	277	277
308307	1001076 1001076	1	2	0	2	32	522	618	618
308308	1001076 1001076	1	2	1	2	6	900	637	637
308309	1001076 1001076	0	2	1	2	7	1039	262	262
308310	1001076 1001076	1	2	1	2	4	1104	639	639
308311	1001076 1001076	1	2	1	2	7	1111	619	619
308312	1001076 1001076	1	3	1	2	1	278	628	628
308313	1001076 1001076	1	3	1	2	10	675	619	619
308314	1001076 1001076	1	3	1	2	1	841	687	687
308315	1001076 1001076	1	3	1	2	1	892	714	714
308316	1001076 1001076	0	3	1	2	1	951	271	271

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