gameroster

38 rows where game_id = 1001080

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_id, starter

Link game_id player_id team_id starter
1001080,327,336 1001080 1001080 327 336 1
1001080,345,336 1001080 1001080 345 336 1
1001080,374,336 1001080 1001080 374 336 0
1001080,387,336 1001080 1001080 387 336 0
1001080,400,336 1001080 1001080 400 336 1
1001080,407,336 1001080 1001080 407 336 0
1001080,409,336 1001080 1001080 409 336 0
1001080,410,336 1001080 1001080 410 336 0
1001080,416,336 1001080 1001080 416 336 0
1001080,422,336 1001080 1001080 422 336 0
1001080,426,336 1001080 1001080 426 336 0
1001080,428,336 1001080 1001080 428 336 0
1001080,430,336 1001080 1001080 430 336 0
1001080,439,336 1001080 1001080 439 336 1
1001080,442,336 1001080 1001080 442 336 1
1001080,447,336 1001080 1001080 447 336 0
1001080,450,336 1001080 1001080 450 336 0
1001080,461,336 1001080 1001080 461 336 1
1001080,553,334 1001080 1001080 553 334 0
1001080,559,334 1001080 1001080 559 334 1
1001080,563,334 1001080 1001080 563 334 0
1001080,567,334 1001080 1001080 567 334 0
1001080,573,334 1001080 1001080 573 334 1
1001080,587,334 1001080 1001080 587 334 0
1001080,592,334 1001080 1001080 592 334 1
1001080,601,334 1001080 1001080 601 334 0
1001080,602,334 1001080 1001080 602 334 0
1001080,603,334 1001080 1001080 603 334 0
1001080,607,334 1001080 1001080 607 334 0
1001080,608,334 1001080 1001080 608 334 0
1001080,610,334 1001080 1001080 610 334 0
1001080,612,334 1001080 1001080 612 334 1
1001080,613,334 1001080 1001080 613 334 0
1001080,614,334 1001080 1001080 614 334 1
1001080,615,334 1001080 1001080 615 334 0
1001080,616,334 1001080 1001080 616 334 0
1001080,711,334 1001080 1001080 711 334 1
1001080,718,336 1001080 1001080 718 336 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)
                );