gameroster

38 rows where game_id = 1001038

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_id, starter

Link game_id player_id team_id starter
1001038,394,323 1001038 1001038 394 323 0
1001038,403,323 1001038 1001038 403 323 0
1001038,408,323 1001038 1001038 408 323 1
1001038,413,323 1001038 1001038 413 323 1
1001038,425,335 1001038 1001038 425 335 0
1001038,429,323 1001038 1001038 429 323 0
1001038,431,335 1001038 1001038 431 335 0
1001038,434,323 1001038 1001038 434 323 0
1001038,440,323 1001038 1001038 440 323 1
1001038,441,335 1001038 1001038 441 335 0
1001038,444,335 1001038 1001038 444 335 0
1001038,446,323 1001038 1001038 446 323 1
1001038,449,335 1001038 1001038 449 335 0
1001038,452,323 1001038 1001038 452 323 0
1001038,460,335 1001038 1001038 460 335 0
1001038,475,323 1001038 1001038 475 323 1
1001038,479,335 1001038 1001038 479 335 1
1001038,484,335 1001038 1001038 484 335 0
1001038,487,323 1001038 1001038 487 323 0
1001038,488,335 1001038 1001038 488 335 0
1001038,491,335 1001038 1001038 491 335 1
1001038,495,323 1001038 1001038 495 323 0
1001038,499,335 1001038 1001038 499 335 0
1001038,500,323 1001038 1001038 500 323 0
1001038,504,323 1001038 1001038 504 323 0
1001038,507,335 1001038 1001038 507 335 0
1001038,508,323 1001038 1001038 508 323 0
1001038,509,335 1001038 1001038 509 335 1
1001038,510,335 1001038 1001038 510 335 0
1001038,511,323 1001038 1001038 511 323 0
1001038,512,335 1001038 1001038 512 335 1
1001038,513,335 1001038 1001038 513 335 1
1001038,514,335 1001038 1001038 514 335 0
1001038,516,323 1001038 1001038 516 323 1
1001038,517,335 1001038 1001038 517 335 1
1001038,529,335 1001038 1001038 529 335 0
1001038,669,323 1001038 1001038 669 323 0
1001038,744,323 1001038 1001038 744 323 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)
                );