gameroster

38 rows where game_id = 1001035

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_id, starter

Link game_id player_id team_id starter
1001035,327,336 1001035 1001035 327 336 0
1001035,345,336 1001035 1001035 345 336 0
1001035,374,336 1001035 1001035 374 336 1
1001035,387,336 1001035 1001035 387 336 0
1001035,400,336 1001035 1001035 400 336 0
1001035,404,336 1001035 1001035 404 336 1
1001035,407,336 1001035 1001035 407 336 0
1001035,409,336 1001035 1001035 409 336 0
1001035,414,336 1001035 1001035 414 336 0
1001035,416,336 1001035 1001035 416 336 0
1001035,422,336 1001035 1001035 422 336 0
1001035,426,336 1001035 1001035 426 336 0
1001035,428,336 1001035 1001035 428 336 1
1001035,430,336 1001035 1001035 430 336 0
1001035,439,336 1001035 1001035 439 336 1
1001035,442,336 1001035 1001035 442 336 1
1001035,447,336 1001035 1001035 447 336 0
1001035,450,336 1001035 1001035 450 336 0
1001035,461,336 1001035 1001035 461 336 1
1001035,553,334 1001035 1001035 553 334 1
1001035,559,334 1001035 1001035 559 334 1
1001035,563,334 1001035 1001035 563 334 0
1001035,567,334 1001035 1001035 567 334 0
1001035,573,334 1001035 1001035 573 334 0
1001035,574,334 1001035 1001035 574 334 0
1001035,582,334 1001035 1001035 582 334 0
1001035,601,334 1001035 1001035 601 334 0
1001035,602,334 1001035 1001035 602 334 1
1001035,603,334 1001035 1001035 603 334 0
1001035,606,334 1001035 1001035 606 334 1
1001035,607,334 1001035 1001035 607 334 0
1001035,608,334 1001035 1001035 608 334 1
1001035,609,334 1001035 1001035 609 334 0
1001035,610,334 1001035 1001035 610 334 0
1001035,612,334 1001035 1001035 612 334 0
1001035,613,334 1001035 1001035 613 334 0
1001035,614,334 1001035 1001035 614 334 1
1001035,615,334 1001035 1001035 615 334 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)
                );