my_database: gamepenalties: 27 rows where game

27 rows where game_id = 1001110

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
309002	1001110 1001110	0	1	0	2	12	86	510	510
309003	1001110 1001110	1	1	0	2	12	86	548	548
309004	1001110 1001110	1	1	1	2	6	244	554	554
309005	1001110 1001110	0	1	1	2	3	268	499	499
309006	1001110 1001110	0	1	1	2	10	285	513	513
309007	1001110 1001110	1	1	1	2	7	527	728	728
309008	1001110 1001110	0	1	0	2	3	741	431	431
309009	1001110 1001110	1	1	0	2	18	741	568	568
309010	1001110 1001110	0	1	1	2	4	888	441	441
309011	1001110 1001110	0	1	0	2	9	1066	488	488
309012	1001110 1001110	1	1	1	2	9	1066	566	566
309014	1001110 1001110	0	2	1	2	7	419	509	509
309015	1001110 1001110	1	2	1	2	4	615	556	556
309016	1001110 1001110	0	2	1	2	1	625	702	702
309017	1001110 1001110	1	2	1	2	7	820	566	566
309018	1001110 1001110	0	2	1	2	1	854	441	441
309019	1001110 1001110	0	2	1	2	1	921	526	526
309020	1001110 1001110	1	2	1	2	6	982	554	554
309021	1001110 1001110	0	2	1	2	7	1141	529	529
309022	1001110 1001110	1	2	1	5	27	1146	552	552
309023	1001110 1001110	1	2	1	2	4	1162	548	548
309024	1001110 1001110	0	3	1	2	6	318	488	488
309025	1001110 1001110	0	3	1	2	3	461	491	491
309026	1001110 1001110	0	3	1	2	15	498	509	509
309027	1001110 1001110	0	3	1	5	19	753	484	484
309028	1001110 1001110	0	3	1	2	6	1003	513	513
309029	1001110 1001110	1	3	1	2	3	1161	547	547

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