gameroster

38 rows where game_id = 1001085

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_id, starter

Link game_id player_id team_id starter
1001085,70,321 1001085 1001085 70 321 0
1001085,224,321 1001085 1001085 224 321 0
1001085,225,321 1001085 1001085 225 321 0
1001085,226,321 1001085 1001085 226 321 0
1001085,227,321 1001085 1001085 227 321 0
1001085,229,321 1001085 1001085 229 321 0
1001085,231,321 1001085 1001085 231 321 1
1001085,233,321 1001085 1001085 233 321 1
1001085,234,321 1001085 1001085 234 321 1
1001085,236,321 1001085 1001085 236 321 0
1001085,238,321 1001085 1001085 238 321 1
1001085,240,321 1001085 1001085 240 321 0
1001085,242,321 1001085 1001085 242 321 0
1001085,244,321 1001085 1001085 244 321 1
1001085,246,321 1001085 1001085 246 321 0
1001085,249,321 1001085 1001085 249 321 0
1001085,553,334 1001085 1001085 553 334 1
1001085,559,334 1001085 1001085 559 334 0
1001085,563,334 1001085 1001085 563 334 0
1001085,567,334 1001085 1001085 567 334 0
1001085,574,334 1001085 1001085 574 334 0
1001085,592,334 1001085 1001085 592 334 1
1001085,601,334 1001085 1001085 601 334 0
1001085,602,334 1001085 1001085 602 334 1
1001085,603,334 1001085 1001085 603 334 0
1001085,606,334 1001085 1001085 606 334 0
1001085,607,334 1001085 1001085 607 334 1
1001085,608,334 1001085 1001085 608 334 0
1001085,610,334 1001085 1001085 610 334 1
1001085,612,334 1001085 1001085 612 334 0
1001085,613,334 1001085 1001085 613 334 0
1001085,614,334 1001085 1001085 614 334 0
1001085,615,334 1001085 1001085 615 334 1
1001085,616,334 1001085 1001085 616 334 0
1001085,671,321 1001085 1001085 671 321 0
1001085,684,334 1001085 1001085 684 334 0
1001085,685,321 1001085 1001085 685 321 1
1001085,726,321 1001085 1001085 726 321 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)
                );