my_database: gamepenalties: 24 rows where game

24 rows where game_id = 1001055

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
307845	1001055 1001055	1	1	1	2	10	40	667	667
307846	1001055 1001055	1	1	1	2	3	158	73	73
307847	1001055 1001055	1	1	1	2	4	257	110	110
307848	1001055 1001055	1	1	1	2	12	534	332	332
307849	1001055 1001055	0	1	1	2	3	557	436	436
307850	1001055 1001055	0	1	1	2	3	709	436	436
307851	1001055 1001055	1	1	1	2	137	798	115	115
307852	1001055 1001055	0	1	0	2	6	890	401	401
307853	1001055 1001055	1	1	1	2	8	893	88	88
307854	1001055 1001055	0	1	1	2	3	931	696	696
307855	1001055 1001055	1	1	1	2	4	1109	88	88
307856	1001055 1001055	0	2	1	2	8	146	448	448
307857	1001055 1001055	1	2	1	2	3	515	98	98
307858	1001055 1001055	1	2	1	2	7	676	78	78
307859	1001055 1001055	0	2	1	2	6	826	421	421
307860	1001055 1001055	0	3	1	2	4	83	436	436
307861	1001055 1001055	0	3	1	2	17	257	44	44
307862	1001055 1001055	1	3	1	2	3	424	98	98
307863	1001055 1001055	0	3	1	5	19	575	44	44
307864	1001055 1001055	0	3	0	2	12	938	432	432
307865	1001055 1001055	1	3	0	2	15	938	667	667
307866	1001055 1001055	0	3	0	2	9	1200	467	467
307867	1001055 1001055	1	3	0	2	9	1200	115	115
307868	1001055 1001055	1	3	0	2	9	1200	78	78

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