my_database: gamepenalties: 26 rows where game

26 rows where game_id = 1001052

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
307729	1001052 1001052	0	1	1	2	7	69	1	1
307730	1001052 1001052	0	1	1	2	7	484	5	5
307731	1001052 1001052	0	1	0	5	13	745	19	19
307732	1001052 1001052	1	1	1	2	35	745	179	179
307733	1001052 1001052	1	1	0	5	13	745	179	179
307734	1001052 1001052	1	1	0	10	36	745	179	179
307735	1001052 1001052	0	1	1	2	3	877	21	21
307736	1001052 1001052	0	1	1	2	9	1076	1	1
307737	1001052 1001052	1	2	1	2	9	184	130	130
307738	1001052 1001052	0	2	1	2	16	357	5	5
307739	1001052 1001052	0	2	0	2	12	493	5	5
307740	1001052 1001052	1	2	0	2	12	493	142	142
307741	1001052 1001052	1	2	1	2	3	516	190	190
307742	1001052 1001052	0	2	1	2	4	629	20	20
307743	1001052 1001052	0	2	1	2	1	795	13	13
307744	1001052 1001052	0	2	1	2	7	983	21	21
307745	1001052 1001052	1	2	1	2	7	1082	159	159
307746	1001052 1001052	1	2	1	2	1	1189	190	190
307747	1001052 1001052	1	3	1	2	7	181	184	184
307748	1001052 1001052	1	3	1	2	1	502	139	139
307749	1001052 1001052	1	3	1	2	10	767	139	139
307750	1001052 1001052	0	3	1	2	8	775	12	12
307751	1001052 1001052	0	3	1	2	1	820	17	17
307752	1001052 1001052	1	3	1	2	7	983	154	154
307753	1001052 1001052	0	3	1	2	3	1162	7	7
307754	1001052 1001052	0	4	1	2	7	181	24	24

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