my_database: gamepenalties: 26 rows where game

26 rows where game_id = 1001117

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
309151	1001117 1001117	0	1	1	2	3	181	471	471
309152	1001117 1001117	1	1	1	2	3	324	93	93
309153	1001117 1001117	0	1	1	2	3	655	473	473
309154	1001117 1001117	1	1	1	2	3	841	105	105
309155	1001117 1001117	1	1	1	2	10	906	95	95
309156	1001117 1001117	0	1	0	2	1	1104	473	473
309157	1001117 1001117	1	1	0	2	7	1104	112	112
309158	1001117 1001117	1	1	1	2	3	1174	93	93
309159	1001117 1001117	0	2	1	2	7	141	465	465
309160	1001117 1001117	0	2	1	2	12	389	445	445
309161	1001117 1001117	1	2	1	2	10	432	667	667
309162	1001117 1001117	0	2	1	2	3	658	421	421
309163	1001117 1001117	1	2	1	2	1	687	78	78
309164	1001117 1001117	1	2	1	2	4	875	332	332
309165	1001117 1001117	1	2	1	2	1	1066	743	743
309166	1001117 1001117	0	3	1	2	3	92	463	463
309167	1001117 1001117	0	3	1	2	6	193	693	693
309168	1001117 1001117	1	3	1	2	7	357	95	95
309169	1001117 1001117	0	3	1	2	6	439	436	436
309170	1001117 1001117	0	3	1	2	3	578	436	436
309171	1001117 1001117	0	3	1	5	13	778	445	445
309172	1001117 1001117	1	3	1	2	35	778	125	125
309173	1001117 1001117	1	3	0	5	13	778	125	125
309174	1001117 1001117	1	3	0	10	36	778	125	125
309175	1001117 1001117	1	3	1	2	8	871	93	93
309176	1001117 1001117	0	3	1	2	6	918	474	474

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