gameroster

38 rows where game_id = 1001121

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_id, starter

Link game_id player_id team_id starter
1001121,28,314 1001121 1001121 28 314 1
1001121,37,314 1001121 1001121 37 314 0
1001121,158,314 1001121 1001121 158 314 1
1001121,162,314 1001121 1001121 162 314 0
1001121,166,314 1001121 1001121 166 314 0
1001121,173,314 1001121 1001121 173 314 0
1001121,185,314 1001121 1001121 185 314 1
1001121,188,314 1001121 1001121 188 314 0
1001121,191,314 1001121 1001121 191 314 0
1001121,194,314 1001121 1001121 194 314 0
1001121,199,314 1001121 1001121 199 314 0
1001121,200,314 1001121 1001121 200 314 0
1001121,204,314 1001121 1001121 204 314 0
1001121,206,314 1001121 1001121 206 314 0
1001121,208,314 1001121 1001121 208 314 1
1001121,209,314 1001121 1001121 209 314 0
1001121,212,314 1001121 1001121 212 314 1
1001121,411,318 1001121 1001121 411 318 1
1001121,423,318 1001121 1001121 423 318 0
1001121,433,318 1001121 1001121 433 318 1
1001121,438,318 1001121 1001121 438 318 0
1001121,451,318 1001121 1001121 451 318 0
1001121,456,318 1001121 1001121 456 318 0
1001121,458,318 1001121 1001121 458 318 0
1001121,462,318 1001121 1001121 462 318 0
1001121,466,318 1001121 1001121 466 318 0
1001121,472,318 1001121 1001121 472 318 1
1001121,478,318 1001121 1001121 478 318 0
1001121,481,318 1001121 1001121 481 318 1
1001121,482,314 1001121 1001121 482 314 0
1001121,485,318 1001121 1001121 485 318 0
1001121,489,318 1001121 1001121 489 318 0
1001121,490,318 1001121 1001121 490 318 1
1001121,494,318 1001121 1001121 494 318 0
1001121,501,318 1001121 1001121 501 318 1
1001121,502,318 1001121 1001121 502 318 0
1001121,729,314 1001121 1001121 729 314 1
1001121,766,318 1001121 1001121 766 318 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)
                );