gameroster

38 rows where game_id = 1001042

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_id, starter

Link game_id player_id team_id starter
1001042,77,325 1001042 1001042 77 325 0
1001042,90,325 1001042 1001042 90 325 0
1001042,97,325 1001042 1001042 97 325 0
1001042,100,325 1001042 1001042 100 325 1
1001042,101,325 1001042 1001042 101 325 0
1001042,103,325 1001042 1001042 103 325 1
1001042,106,325 1001042 1001042 106 325 0
1001042,107,325 1001042 1001042 107 325 0
1001042,109,325 1001042 1001042 109 325 0
1001042,111,325 1001042 1001042 111 325 1
1001042,113,325 1001042 1001042 113 325 0
1001042,116,325 1001042 1001042 116 325 1
1001042,118,325 1001042 1001042 118 325 0
1001042,124,325 1001042 1001042 124 325 1
1001042,127,325 1001042 1001042 127 325 0
1001042,129,325 1001042 1001042 129 325 0
1001042,132,325 1001042 1001042 132 325 1
1001042,133,325 1001042 1001042 133 325 0
1001042,138,325 1001042 1001042 138 325 0
1001042,394,323 1001042 1001042 394 323 1
1001042,403,323 1001042 1001042 403 323 0
1001042,408,323 1001042 1001042 408 323 1
1001042,413,323 1001042 1001042 413 323 1
1001042,418,323 1001042 1001042 418 323 0
1001042,429,323 1001042 1001042 429 323 0
1001042,434,323 1001042 1001042 434 323 0
1001042,440,323 1001042 1001042 440 323 1
1001042,446,323 1001042 1001042 446 323 1
1001042,452,323 1001042 1001042 452 323 0
1001042,475,323 1001042 1001042 475 323 0
1001042,487,323 1001042 1001042 487 323 0
1001042,495,323 1001042 1001042 495 323 0
1001042,500,323 1001042 1001042 500 323 0
1001042,508,323 1001042 1001042 508 323 0
1001042,511,323 1001042 1001042 511 323 0
1001042,516,323 1001042 1001042 516 323 0
1001042,669,323 1001042 1001042 669 323 1
1001042,744,323 1001042 1001042 744 323 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)
                );