gameroster

38 rows where game_id = 1001093

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_id, starter

Link game_id player_id team_id starter
1001093,77,325 1001093 1001093 77 325 0
1001093,90,325 1001093 1001093 90 325 0
1001093,97,325 1001093 1001093 97 325 0
1001093,101,325 1001093 1001093 101 325 1
1001093,103,325 1001093 1001093 103 325 1
1001093,106,325 1001093 1001093 106 325 1
1001093,107,325 1001093 1001093 107 325 1
1001093,109,325 1001093 1001093 109 325 0
1001093,111,325 1001093 1001093 111 325 0
1001093,116,325 1001093 1001093 116 325 0
1001093,118,325 1001093 1001093 118 325 0
1001093,124,325 1001093 1001093 124 325 0
1001093,127,325 1001093 1001093 127 325 1
1001093,129,325 1001093 1001093 129 325 0
1001093,132,325 1001093 1001093 132 325 0
1001093,133,325 1001093 1001093 133 325 1
1001093,141,325 1001093 1001093 141 325 0
1001093,143,325 1001093 1001093 143 325 0
1001093,394,323 1001093 1001093 394 323 0
1001093,403,323 1001093 1001093 403 323 0
1001093,408,323 1001093 1001093 408 323 0
1001093,413,323 1001093 1001093 413 323 1
1001093,429,323 1001093 1001093 429 323 0
1001093,434,323 1001093 1001093 434 323 0
1001093,440,323 1001093 1001093 440 323 1
1001093,446,323 1001093 1001093 446 323 1
1001093,475,323 1001093 1001093 475 323 0
1001093,492,323 1001093 1001093 492 323 1
1001093,495,323 1001093 1001093 495 323 0
1001093,500,323 1001093 1001093 500 323 0
1001093,508,323 1001093 1001093 508 323 0
1001093,511,323 1001093 1001093 511 323 0
1001093,516,323 1001093 1001093 516 323 1
1001093,669,323 1001093 1001093 669 323 0
1001093,681,323 1001093 1001093 681 323 0
1001093,698,325 1001093 1001093 698 325 0
1001093,722,323 1001093 1001093 722 323 1
1001093,744,323 1001093 1001093 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)
                );