gameroster

38 rows where game_id = 1001051

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_id, starter

Link game_id player_id team_id starter
1001051,70,321 1001051 1001051 70 321 0
1001051,221,321 1001051 1001051 221 321 0
1001051,222,321 1001051 1001051 222 321 1
1001051,223,321 1001051 1001051 223 321 1
1001051,224,321 1001051 1001051 224 321 0
1001051,225,321 1001051 1001051 225 321 0
1001051,226,321 1001051 1001051 226 321 1
1001051,229,321 1001051 1001051 229 321 0
1001051,231,321 1001051 1001051 231 321 0
1001051,232,321 1001051 1001051 232 321 1
1001051,233,321 1001051 1001051 233 321 0
1001051,234,321 1001051 1001051 234 321 0
1001051,236,321 1001051 1001051 236 321 0
1001051,238,321 1001051 1001051 238 321 1
1001051,240,321 1001051 1001051 240 321 0
1001051,244,321 1001051 1001051 244 321 0
1001051,246,321 1001051 1001051 246 321 0
1001051,247,321 1001051 1001051 247 321 0
1001051,249,321 1001051 1001051 249 321 1
1001051,553,334 1001051 1001051 553 334 0
1001051,559,334 1001051 1001051 559 334 0
1001051,563,334 1001051 1001051 563 334 1
1001051,567,334 1001051 1001051 567 334 1
1001051,573,334 1001051 1001051 573 334 0
1001051,574,334 1001051 1001051 574 334 0
1001051,582,334 1001051 1001051 582 334 0
1001051,592,334 1001051 1001051 592 334 0
1001051,602,334 1001051 1001051 602 334 0
1001051,603,334 1001051 1001051 603 334 1
1001051,606,334 1001051 1001051 606 334 1
1001051,607,334 1001051 1001051 607 334 0
1001051,608,334 1001051 1001051 608 334 1
1001051,610,334 1001051 1001051 610 334 0
1001051,612,334 1001051 1001051 612 334 0
1001051,613,334 1001051 1001051 613 334 0
1001051,614,334 1001051 1001051 614 334 0
1001051,615,334 1001051 1001051 615 334 1
1001051,684,334 1001051 1001051 684 334 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)
                );