my_database: gamepenalties: 29 rows where game

29 rows where game_id = 1001037

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
307348	1001037 1001037	1	1	1	2	7	35	158	158
307349	1001037 1001037	1	1	1	2	7	87	201	201
307350	1001037 1001037	0	1	1	2	1	119	186	186
307351	1001037 1001037	0	1	1	2	3	231	165	165
307352	1001037 1001037	0	1	1	2	1	520	207	207
307353	1001037 1001037	0	1	1	2	1	709	217	217
307354	1001037 1001037	1	1	1	2	3	811	37	37
307355	1001037 1001037	0	1	0	2	3	820	202	202
307356	1001037 1001037	1	1	1	2	3	822	208	208
307357	1001037 1001037	0	1	1	2	7	941	210	210
307358	1001037 1001037	1	1	1	2	3	957	162	162
307359	1001037 1001037	1	1	1	2	3	1061	199	199
307360	1001037 1001037	1	1	1	2	3	1150	204	204
307361	1001037 1001037	0	2	1	2	7	32	205	205
307362	1001037 1001037	0	2	1	2	1	234	205	205
307363	1001037 1001037	0	2	1	2	4	331	216	216
307364	1001037 1001037	1	2	0	2	3	361	209	209
307365	1001037 1001037	0	2	1	2	3	405	178	178
307366	1001037 1001037	0	2	1	2	6	449	180	180
307367	1001037 1001037	1	2	1	2	9	800	182	182
307368	1001037 1001037	0	2	1	2	3	1074	216	216
307369	1001037 1001037	1	2	1	2	4	1155	188	188
307370	1001037 1001037	0	3	1	2	4	73	167	167
307371	1001037 1001037	1	3	1	2	4	167	188	188
307372	1001037 1001037	0	3	1	2	1	353	207	207
307373	1001037 1001037	0	3	0	2	7	625	167	167
307374	1001037 1001037	1	3	0	2	18	625	208	208
307375	1001037 1001037	1	3	1	2	15	966	212	212
307377	1001037 1001037	0	3	0	2	3	1181	189	189

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