gameroster

40 rows where game_id = 1027789

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_id, starter

Link game_id player_id team_id starter
1027789,5080,402 1027789 1027789 5080 402 0
1027789,6058,402 1027789 1027789 6058 402 0
1027789,6669,405 1027789 1027789 6669 405 1
1027789,6780,402 1027789 1027789 6780 402 0
1027789,6859,405 1027789 1027789 6859 405 0
1027789,6948,402 1027789 1027789 6948 402 1
1027789,7159,402 1027789 1027789 7159 402 1
1027789,7352,402 1027789 1027789 7352 402 0
1027789,7824,405 1027789 1027789 7824 405 1
1027789,7847,402 1027789 1027789 7847 402 0
1027789,7897,405 1027789 1027789 7897 405 0
1027789,7927,402 1027789 1027789 7927 402 1
1027789,8485,402 1027789 1027789 8485 402 1
1027789,8726,402 1027789 1027789 8726 402 1
1027789,8916,405 1027789 1027789 8916 405 1
1027789,9040,405 1027789 1027789 9040 405 0
1027789,9177,405 1027789 1027789 9177 405 0
1027789,9190,405 1027789 1027789 9190 405 0
1027789,9251,405 1027789 1027789 9251 405 0
1027789,9259,405 1027789 1027789 9259 405 0
1027789,9384,402 1027789 1027789 9384 402 0
1027789,9832,405 1027789 1027789 9832 405 0
1027789,9942,402 1027789 1027789 9942 402 0
1027789,10050,405 1027789 1027789 10050 405 0
1027789,10086,405 1027789 1027789 10086 405 0
1027789,10226,405 1027789 1027789 10226 405 1
1027789,10231,405 1027789 1027789 10231 405 1
1027789,10234,405 1027789 1027789 10234 405 1
1027789,10494,405 1027789 1027789 10494 405 0
1027789,10501,405 1027789 1027789 10501 405 0
1027789,10595,402 1027789 1027789 10595 402 0
1027789,10599,402 1027789 1027789 10599 402 0
1027789,10624,402 1027789 1027789 10624 402 0
1027789,10692,405 1027789 1027789 10692 405 0
1027789,10699,405 1027789 1027789 10699 405 0
1027789,10873,402 1027789 1027789 10873 402 0
1027789,10874,402 1027789 1027789 10874 402 0
1027789,10876,402 1027789 1027789 10876 402 0
1027789,10877,402 1027789 1027789 10877 402 0
1027789,10879,402 1027789 1027789 10879 402 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)
                );