my_database: gamepenalties: 25 rows where game

25 rows where game_id = 1001120

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
309372	1001120 1001120	0	1	1	2	6	33	372	372
309373	1001120 1001120	1	1	1	2	15	240	679	679
309374	1001120 1001120	1	1	1	2	17	361	679	679
309375	1001120 1001120	0	1	1	2	9	651	340	340
309376	1001120 1001120	1	1	1	2	3	807	659	659
309377	1001120 1001120	0	1	1	2	34	961	340	340
309378	1001120 1001120	0	1	1	5	67	1091	340	340
309379	1001120 1001120	0	1	0	5	13	1091	340	340
309380	1001120 1001120	1	1	0	2	35	1091	644	644
309381	1001120 1001120	1	1	0	5	13	1091	644	644
309382	1001120 1001120	1	1	0	10	36	1091	644	644
309383	1001120 1001120	1	1	1	2	3	1102	643	643
309384	1001120 1001120	1	1	1	2	3	1197	653	653
309385	1001120 1001120	0	2	1	2	7	178	344	344
309386	1001120 1001120	0	2	1	2	3	240	390	390
309387	1001120 1001120	0	2	1	2	1	325	361	361
309388	1001120 1001120	0	2	1	2	12	496	321	321
309389	1001120 1001120	1	2	1	2	4	861	658	658
309390	1001120 1001120	0	2	1	2	2	1003	321	321
309391	1001120 1001120	1	2	1	2	3	1045	643	643
309392	1001120 1001120	1	2	1	2	3	1081	659	659
309393	1001120 1001120	0	3	0	5	13	6	379	379
309394	1001120 1001120	1	3	0	5	13	6	663	663
309395	1001120 1001120	1	3	1	2	3	115	737	737
309396	1001120 1001120	1	3	1	2	15	564	644	644

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