gameroster

40 rows where game_id = 1027774

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_id, starter

Link game_id player_id team_id starter
1027774,5461,404 1027774 1027774 5461 404 1
1027774,5471,445 1027774 1027774 5471 445 0
1027774,5912,404 1027774 1027774 5912 404 1
1027774,6080,404 1027774 1027774 6080 404 1
1027774,6306,445 1027774 1027774 6306 445 0
1027774,6442,404 1027774 1027774 6442 404 0
1027774,6463,404 1027774 1027774 6463 404 1
1027774,6729,404 1027774 1027774 6729 404 0
1027774,6956,445 1027774 1027774 6956 445 0
1027774,7309,404 1027774 1027774 7309 404 0
1027774,8535,404 1027774 1027774 8535 404 0
1027774,8575,404 1027774 1027774 8575 404 0
1027774,8625,445 1027774 1027774 8625 445 0
1027774,9189,404 1027774 1027774 9189 404 0
1027774,9193,404 1027774 1027774 9193 404 0
1027774,9194,404 1027774 1027774 9194 404 0
1027774,9197,404 1027774 1027774 9197 404 0
1027774,9225,445 1027774 1027774 9225 445 1
1027774,9675,404 1027774 1027774 9675 404 0
1027774,9702,404 1027774 1027774 9702 404 0
1027774,9706,445 1027774 1027774 9706 445 0
1027774,9710,445 1027774 1027774 9710 445 0
1027774,9755,445 1027774 1027774 9755 445 1
1027774,9756,445 1027774 1027774 9756 445 1
1027774,9762,445 1027774 1027774 9762 445 0
1027774,9764,445 1027774 1027774 9764 445 1
1027774,10076,404 1027774 1027774 10076 404 1
1027774,10082,445 1027774 1027774 10082 445 0
1027774,10126,445 1027774 1027774 10126 445 0
1027774,10180,445 1027774 1027774 10180 445 0
1027774,10181,445 1027774 1027774 10181 445 0
1027774,10183,445 1027774 1027774 10183 445 0
1027774,10184,445 1027774 1027774 10184 445 0
1027774,10186,445 1027774 1027774 10186 445 1
1027774,10190,445 1027774 1027774 10190 445 1
1027774,10274,404 1027774 1027774 10274 404 0
1027774,10506,404 1027774 1027774 10506 404 1
1027774,10514,404 1027774 1027774 10514 404 0
1027774,10575,445 1027774 1027774 10575 445 0
1027774,10686,404 1027774 1027774 10686 404 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)
                );