my_database: gamepenalties: 25 rows where game

25 rows where game_id = 1001119

descending

id ▼	game_id	home	period_id	powerplay	minutes	penalty	time_of_penalty_seconds	player_penalized	player_server
309191	1001119 1001119	0	1	1	2	1	34	410	410
309192	1001119 1001119	0	1	1	2	6	145	409	409
309193	1001119 1001119	1	1	1	2	3	290	527	527
309194	1001119 1001119	1	1	1	2	15	559	528	528
309195	1001119 1001119	0	1	1	2	3	665	439	439
309196	1001119 1001119	1	1	1	2	8	796	527	527
309197	1001119 1001119	1	1	1	2	1	874	545	545
309198	1001119 1001119	1	1	1	2	3	997	546	546
309199	1001119 1001119	0	1	1	2	17	1200	765	765
309200	1001119 1001119	1	2	1	2	7	157	524	524
309201	1001119 1001119	0	2	1	2	7	341	765	765
309202	1001119 1001119	1	2	1	2	7	368	545	545
309203	1001119 1001119	0	2	1	2	1	562	407	407
309204	1001119 1001119	0	2	1	2	1	828	407	407
309205	1001119 1001119	0	2	1	2	12	973	400	400
309206	1001119 1001119	1	2	1	2	1	1073	524	524
309207	1001119 1001119	1	3	1	2	10	342	528	528
309208	1001119 1001119	1	3	1	2	8	794	545	545
309209	1001119 1001119	1	3	1	2	16	861	536	536
309210	1001119 1001119	1	3	1	2	4	977	537	537
309211	1001119 1001119	1	3	1	2	3	1046	522	522
309212	1001119 1001119	0	3	0	2	15	1147	442	442
309213	1001119 1001119	0	3	0	10	20	1147	442	442
309214	1001119 1001119	1	3	0	2	15	1147	543	543
309215	1001119 1001119	0	3	0	10	20	1190	400	400

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