home / my_database

gameofficial

3 rows where game_id = 1001125

✎ View and edit SQL

This data as json, CSV (advanced)

Link game_id person_id official_type_id
1001125,5907 1001125 1001125 5907 3
1001125,5921 1001125 1001125 5921 1
1001125,5953 1001125 1001125 5953 4

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE gameofficial (
                    game_id INTEGER NOT NULL,
                    person_id INTEGER NOT NULL,
                    official_type_id INTEGER,
                    PRIMARY KEY (game_id, person_id),
                    FOREIGN KEY (game_id) REFERENCES gamedata(game_id)
                );
Powered by Datasette · Queries took 376.511ms