player_factions
2 rows where faction = "Marquise de Cat" sorted by player
This data as json, CSV (advanced)
game_id ✖
- 1613926800 1
- 1615143600 1
Link | rowid | player ▼ | faction | game_id | won | victory_points | dominance |
---|---|---|---|---|---|---|---|
3 | 3 | alex | Marquise de Cat | 1613926800 1 | 0 | 27 | 0 |
15 | 15 | lauren | Marquise de Cat | 1615143600 4 | 0 | 19 | 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 );