gameroster

38 rows where game_id = 1001045

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_id, starter

Link game_id player_id team_id starter
1001045,28,314 1001045 1001045 28 314 1
1001045,37,314 1001045 1001045 37 314 0
1001045,158,314 1001045 1001045 158 314 0
1001045,162,314 1001045 1001045 162 314 0
1001045,165,317 1001045 1001045 165 317 0
1001045,167,317 1001045 1001045 167 317 1
1001045,173,314 1001045 1001045 173 314 0
1001045,174,317 1001045 1001045 174 317 0
1001045,175,317 1001045 1001045 175 317 0
1001045,178,317 1001045 1001045 178 317 1
1001045,180,317 1001045 1001045 180 317 1
1001045,182,314 1001045 1001045 182 314 0
1001045,183,317 1001045 1001045 183 317 0
1001045,185,314 1001045 1001045 185 314 0
1001045,186,317 1001045 1001045 186 317 0
1001045,188,314 1001045 1001045 188 314 0
1001045,189,317 1001045 1001045 189 317 1
1001045,191,314 1001045 1001045 191 314 0
1001045,193,317 1001045 1001045 193 317 1
1001045,194,314 1001045 1001045 194 314 1
1001045,199,314 1001045 1001045 199 314 1
1001045,200,314 1001045 1001045 200 314 0
1001045,202,317 1001045 1001045 202 317 0
1001045,204,314 1001045 1001045 204 314 0
1001045,205,317 1001045 1001045 205 317 0
1001045,206,314 1001045 1001045 206 314 1
1001045,207,317 1001045 1001045 207 317 0
1001045,208,314 1001045 1001045 208 314 1
1001045,209,314 1001045 1001045 209 314 0
1001045,210,317 1001045 1001045 210 317 0
1001045,211,314 1001045 1001045 211 314 1
1001045,212,314 1001045 1001045 212 314 0
1001045,216,317 1001045 1001045 216 317 0
1001045,217,317 1001045 1001045 217 317 0
1001045,218,317 1001045 1001045 218 317 1
1001045,219,317 1001045 1001045 219 317 0
1001045,459,317 1001045 1001045 459 317 0
1001045,482,314 1001045 1001045 482 314 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)
                );