my_database: gamepenalties: 23 rows where game

23 rows where game_id = 1001082

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
308396	1001082 1001082	0	1	1	2	6	438	451	451
308397	1001082 1001082	1	1	1	2	3	580	45	45
308398	1001082 1001082	0	1	1	2	7	606	489	489
308399	1001082 1001082	0	1	1	2	4	954	497	497
308400	1001082 1001082	1	1	1	2	7	1020	94	94
308401	1001082 1001082	1	1	1	2	9	1098	47	47
308402	1001082 1001082	0	1	1	2	1	1200	497	497
308403	1001082 1001082	0	1	1	2	12	1200	497	497
308404	1001082 1001082	0	2	1	2	4	374	456	456
308405	1001082 1001082	1	2	1	2	8	528	38	38
308406	1001082 1001082	0	2	1	2	3	731	458	458
308407	1001082 1001082	1	2	1	2	16	888	76	76
308408	1001082 1001082	0	2	1	2	1	919	458	458
308409	1001082 1001082	1	2	1	2	3	1011	54	54
308410	1001082 1001082	0	2	0	2	12	1158	438	438
308411	1001082 1001082	1	2	0	2	12	1158	54	54
308412	1001082 1001082	1	2	1	2	6	1170	701	701
308413	1001082 1001082	1	3	1	2	6	307	52	52
308414	1001082 1001082	1	3	1	2	8	613	76	76
308415	1001082 1001082	0	3	0	5	13	728	497	497
308416	1001082 1001082	1	3	0	5	13	728	61	61
308417	1001082 1001082	1	3	1	2	3	736	94	94
308418	1001082 1001082	0	3	1	2	8	855	451	451

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