gameroster

38 rows where game_id = 1001040

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_id, starter

Link game_id player_id team_id starter
1001040,221,321 1001040 1001040 221 321 1
1001040,222,321 1001040 1001040 222 321 0
1001040,223,321 1001040 1001040 223 321 0
1001040,224,321 1001040 1001040 224 321 0
1001040,226,321 1001040 1001040 226 321 1
1001040,227,321 1001040 1001040 227 321 0
1001040,229,321 1001040 1001040 229 321 1
1001040,231,321 1001040 1001040 231 321 0
1001040,232,321 1001040 1001040 232 321 0
1001040,233,321 1001040 1001040 233 321 1
1001040,234,321 1001040 1001040 234 321 0
1001040,236,321 1001040 1001040 236 321 0
1001040,237,321 1001040 1001040 237 321 0
1001040,238,321 1001040 1001040 238 321 1
1001040,240,321 1001040 1001040 240 321 0
1001040,244,321 1001040 1001040 244 321 0
1001040,246,321 1001040 1001040 246 321 0
1001040,247,321 1001040 1001040 247 321 0
1001040,249,321 1001040 1001040 249 321 1
1001040,553,334 1001040 1001040 553 334 1
1001040,559,334 1001040 1001040 559 334 1
1001040,563,334 1001040 1001040 563 334 0
1001040,567,334 1001040 1001040 567 334 0
1001040,573,334 1001040 1001040 573 334 0
1001040,574,334 1001040 1001040 574 334 0
1001040,582,334 1001040 1001040 582 334 0
1001040,592,334 1001040 1001040 592 334 1
1001040,602,334 1001040 1001040 602 334 0
1001040,603,334 1001040 1001040 603 334 0
1001040,606,334 1001040 1001040 606 334 0
1001040,607,334 1001040 1001040 607 334 1
1001040,608,334 1001040 1001040 608 334 0
1001040,610,334 1001040 1001040 610 334 1
1001040,611,334 1001040 1001040 611 334 0
1001040,612,334 1001040 1001040 612 334 0
1001040,613,334 1001040 1001040 613 334 0
1001040,614,334 1001040 1001040 614 334 0
1001040,615,334 1001040 1001040 615 334 1

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)
                );