gameroster

38 rows where game_id = 1001037

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_id, starter

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