my_database: gamepenalties: 19 rows where game

19 rows where game_id = 1001094

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
308692	1001094 1001094	0	1	1	2	1	60	619	619
308693	1001094 1001094	1	1	1	2	7	331	332	332
308694	1001094 1001094	0	1	1	2	3	537	727	727
308695	1001094 1001094	1	1	1	2	7	655	332	332
308696	1001094 1001094	0	1	1	2	7	715	631	631
308697	1001094 1001094	1	1	1	2	3	869	98	98
308698	1001094 1001094	1	1	1	2	10	1007	98	98
308699	1001094 1001094	0	1	1	2	1	1019	625	625
308700	1001094 1001094	0	1	1	5	27	1108	687	687
308701	1001094 1001094	1	1	0	2	9	1108	88	88
308702	1001094 1001094	1	2	1	2	1	204	119	119
308703	1001094 1001094	0	2	1	2	3	339	687	687
308704	1001094 1001094	0	2	1	2	3	603	621	621
308705	1001094 1001094	0	2	1	2	1	869	630	630
308706	1001094 1001094	1	2	1	2	1	1006	78	78
308707	1001094 1001094	0	3	1	2	7	283	714	714
308708	1001094 1001094	1	3	1	2	4	357	123	123
308709	1001094 1001094	0	3	1	2	3	410	626	626
308710	1001094 1001094	0	3	1	2	3	818	634	634

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