my_database: gamepenalties: 31 rows where game

31 rows where game_id = 1001112

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
309049	1001112 1001112	1	1	1	2	3	94	52	52
309050	1001112 1001112	0	1	1	2	3	573	131	131
309051	1001112 1001112	1	1	1	2	3	760	47	47
309052	1001112 1001112	0	1	0	2	9	848	140	140
309053	1001112 1001112	1	1	1	2	9	848	50	50
309055	1001112 1001112	1	1	1	2	4	960	47	47
309056	1001112 1001112	0	1	0	10	20	1176	108	108
309057	1001112 1001112	0	1	0	5	13	1176	134	134
309058	1001112 1001112	0	1	0	2	9	1176	160	160
309059	1001112 1001112	1	1	0	10	20	1176	732	732
309060	1001112 1001112	1	1	0	5	13	1176	47	47
309061	1001112 1001112	1	1	0	2	9	1176	701	701
309062	1001112 1001112	0	1	1	2	1	1195	155	155
309063	1001112 1001112	1	2	1	2	1	95	74	74
309064	1001112 1001112	0	2	1	2	3	310	152	152
309065	1001112 1001112	0	2	0	5	13	506	164	164
309066	1001112 1001112	1	2	1	2	34	506	74	74
309067	1001112 1001112	1	2	0	5	13	506	74	74
309068	1001112 1001112	0	2	1	2	18	548	152	152
309069	1001112 1001112	0	2	0	2	11	782	87	87
309070	1001112 1001112	0	2	1	2	9	782	157	157
309071	1001112 1001112	1	2	0	2	9	782	83	83
309072	1001112 1001112	0	2	1	2	7	1023	155	155
309073	1001112 1001112	1	3	1	2	4	41	50	50
309074	1001112 1001112	1	3	1	2	3	192	74	74
309075	1001112 1001112	1	3	1	2	16	489	52	52
309076	1001112 1001112	0	3	1	2	3	520	164	164
309077	1001112 1001112	0	3	1	2	3	617	152	152
309078	1001112 1001112	0	3	0	5	13	801	87	87
309079	1001112 1001112	1	3	0	5	13	801	96	96
309080	1001112 1001112	1	3	1	2	3	1081	67	67

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