my_database: gamepenalties: 26 rows where game

26 rows where game_id = 1001107

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
308934	1001107 1001107	1	1	1	2	3	35	700	700
308935	1001107 1001107	0	1	0	5	13	176	483	483
308936	1001107 1001107	1	1	0	5	13	176	389	389
308937	1001107 1001107	0	1	1	2	1	561	744	744
308938	1001107 1001107	0	1	1	2	3	774	403	403
308939	1001107 1001107	0	1	1	2	4	954	440	440
308940	1001107 1001107	1	2	1	2	3	49	351	351
308941	1001107 1001107	1	2	1	2	3	240	700	700
308942	1001107 1001107	1	2	1	2	4	287	356	356
308943	1001107 1001107	0	2	1	2	1	481	403	403
308944	1001107 1001107	0	2	1	2	4	497	500	500
308945	1001107 1001107	0	2	1	2	3	730	440	440
308946	1001107 1001107	1	2	1	2	3	919	324	324
308947	1001107 1001107	0	2	1	2	3	942	744	744
308948	1001107 1001107	0	2	1	2	9	1029	408	408
308949	1001107 1001107	0	2	0	5	13	1029	408	408
308950	1001107 1001107	1	2	0	5	13	1029	362	362
308951	1001107 1001107	0	2	1	2	1	1093	511	511
308952	1001107 1001107	0	2	0	2	3	1123	413	413
308953	1001107 1001107	1	2	1	2	3	1129	405	405
308954	1001107 1001107	1	2	1	2	6	1188	311	311
308955	1001107 1001107	1	3	1	2	4	455	412	412
308956	1001107 1001107	0	3	1	2	3	711	408	408
308957	1001107 1001107	0	3	1	2	4	889	413	413
308958	1001107 1001107	0	3	0	2	9	1091	446	446
308959	1001107 1001107	1	3	0	2	9	1091	377	377

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