my_database: gamepenalties: 25 rows where game

25 rows where game_id = 1001078

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
308264	1001078 1001078	0	1	1	2	9	23	484	484
308265	1001078 1001078	0	1	0	2	4	463	444	444
308266	1001078 1001078	0	1	0	5	13	463	444	444
308267	1001078 1001078	1	1	0	2	35	463	389	389
308268	1001078 1001078	1	1	0	5	13	463	389	389
308269	1001078 1001078	1	1	0	10	36	463	389	389
308270	1001078 1001078	1	1	1	2	7	501	377	377
308271	1001078 1001078	1	1	1	2	9	501	377	377
308272	1001078 1001078	1	1	1	2	15	519	311	311
308273	1001078 1001078	1	1	1	2	6	869	306	306
308274	1001078 1001078	0	1	1	2	10	937	513	513
308275	1001078 1001078	0	1	0	5	13	1109	510	510
308276	1001078 1001078	1	1	0	5	13	1109	335	335
308277	1001078 1001078	0	2	1	2	9	101	460	460
308278	1001078 1001078	0	2	1	2	4	420	507	507
308279	1001078 1001078	0	2	1	2	3	637	510	510
308280	1001078 1001078	0	2	1	2	1	849	441	441
308281	1001078 1001078	0	2	1	2	1	990	512	512
308282	1001078 1001078	0	2	0	2	9	1200	491	491
308283	1001078 1001078	0	2	0	2	9	1200	520	520
308284	1001078 1001078	1	2	0	2	9	1200	306	306
308285	1001078 1001078	1	2	0	2	9	1200	377	377
308286	1001078 1001078	1	3	1	2	9	35	412	412
308287	1001078 1001078	1	3	1	2	6	155	700	700
308288	1001078 1001078	0	3	1	2	4	703	479	479

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