gameroster

38 rows where game_id = 1001118

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_id, starter

Link game_id player_id team_id starter
1001118,70,321 1001118 1001118 70 321 0
1001118,77,325 1001118 1001118 77 325 1
1001118,90,325 1001118 1001118 90 325 0
1001118,97,325 1001118 1001118 97 325 1
1001118,101,325 1001118 1001118 101 325 0
1001118,103,325 1001118 1001118 103 325 0
1001118,106,325 1001118 1001118 106 325 1
1001118,107,325 1001118 1001118 107 325 1
1001118,109,325 1001118 1001118 109 325 0
1001118,111,325 1001118 1001118 111 325 0
1001118,113,325 1001118 1001118 113 325 0
1001118,116,325 1001118 1001118 116 325 0
1001118,118,325 1001118 1001118 118 325 0
1001118,124,325 1001118 1001118 124 325 0
1001118,127,325 1001118 1001118 127 325 1
1001118,129,325 1001118 1001118 129 325 0
1001118,138,325 1001118 1001118 138 325 0
1001118,143,325 1001118 1001118 143 325 0
1001118,151,325 1001118 1001118 151 325 1
1001118,222,321 1001118 1001118 222 321 0
1001118,224,321 1001118 1001118 224 321 0
1001118,225,321 1001118 1001118 225 321 0
1001118,226,321 1001118 1001118 226 321 0
1001118,227,321 1001118 1001118 227 321 1
1001118,229,321 1001118 1001118 229 321 0
1001118,231,321 1001118 1001118 231 321 1
1001118,233,321 1001118 1001118 233 321 1
1001118,236,321 1001118 1001118 236 321 0
1001118,237,321 1001118 1001118 237 321 0
1001118,238,321 1001118 1001118 238 321 1
1001118,240,321 1001118 1001118 240 321 0
1001118,242,321 1001118 1001118 242 321 1
1001118,244,321 1001118 1001118 244 321 1
1001118,246,321 1001118 1001118 246 321 0
1001118,249,321 1001118 1001118 249 321 0
1001118,671,321 1001118 1001118 671 321 0
1001118,685,321 1001118 1001118 685 321 0
1001118,764,325 1001118 1001118 764 325 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)
                );