player_factions
1 row where victory_points = 12 sorted by dominance
This data as json, CSV (advanced)
faction ✖
Link | rowid | player | faction | game_id | won | victory_points | dominance ▼ |
---|---|---|---|---|---|---|---|
19 | 19 | alex | Woodland Alliance | 1616349600 5 | 0 | 12 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE player_factions( player TEXT REFERENCES players(name), faction TEXT REFERENCES factions(name), game_id INTEGER REFERENCES games(id), won INTEGER, victory_points INTEGER, dominance INTEGER );