gameroster

38 rows where game_id = 1001091

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_id, starter

Link game_id player_id team_id starter
1001091,70,321 1001091 1001091 70 321 0
1001091,224,321 1001091 1001091 224 321 0
1001091,225,321 1001091 1001091 225 321 0
1001091,226,321 1001091 1001091 226 321 0
1001091,228,321 1001091 1001091 228 321 0
1001091,229,321 1001091 1001091 229 321 0
1001091,231,321 1001091 1001091 231 321 1
1001091,232,321 1001091 1001091 232 321 0
1001091,233,321 1001091 1001091 233 321 1
1001091,234,321 1001091 1001091 234 321 1
1001091,236,321 1001091 1001091 236 321 0
1001091,238,321 1001091 1001091 238 321 0
1001091,240,321 1001091 1001091 240 321 1
1001091,242,321 1001091 1001091 242 321 1
1001091,244,321 1001091 1001091 244 321 0
1001091,246,321 1001091 1001091 246 321 0
1001091,249,321 1001091 1001091 249 321 0
1001091,553,334 1001091 1001091 553 334 0
1001091,559,334 1001091 1001091 559 334 1
1001091,563,334 1001091 1001091 563 334 0
1001091,567,334 1001091 1001091 567 334 0
1001091,574,334 1001091 1001091 574 334 0
1001091,592,334 1001091 1001091 592 334 0
1001091,601,334 1001091 1001091 601 334 0
1001091,602,334 1001091 1001091 602 334 0
1001091,603,334 1001091 1001091 603 334 0
1001091,606,334 1001091 1001091 606 334 1
1001091,607,334 1001091 1001091 607 334 0
1001091,608,334 1001091 1001091 608 334 0
1001091,610,334 1001091 1001091 610 334 0
1001091,611,334 1001091 1001091 611 334 0
1001091,613,334 1001091 1001091 613 334 1
1001091,614,334 1001091 1001091 614 334 0
1001091,615,334 1001091 1001091 615 334 1
1001091,616,334 1001091 1001091 616 334 1
1001091,684,334 1001091 1001091 684 334 1
1001091,685,321 1001091 1001091 685 321 1
1001091,739,321 1001091 1001091 739 321 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE gameroster (
                    game_id INTEGER NOT NULL,
                    player_id INTEGER NOT NULL,
                    team_id INTEGER NOT NULL,
                    starter BOOLEAN,
                    PRIMARY KEY (game_id, player_id, team_id),
                    FOREIGN KEY (game_id) REFERENCES gamedata(game_id)
                );