player_factions
2 rows where player = "alex" and victory_points = 30 sorted by won descending
This data as json, CSV (advanced)
faction ✖
Link | rowid | player | faction | game_id | won ▲ | victory_points | dominance |
---|---|---|---|---|---|---|---|
6 | 6 | alex | Eyrie Dynasty | 1614452400 2 | 1 | 30 | 0 |
14 | 14 | alex | Riverfolk Company | 1615143600 4 | 1 | 30 | 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 );