player_factions
3 rows where faction = "Underground Duchy" sorted by won
This data as json, CSV (advanced)
Suggested facets: player, won, victory_points
Link | rowid | player | faction | game_id | won ▼ | victory_points | dominance |
---|---|---|---|---|---|---|---|
10 | 10 | alex | Underground Duchy | 1614459600 3 | 0 | 0 | 1 |
18 | 18 | terra | Underground Duchy | 1616349600 5 | 1 | 30 | 0 |
21 | 21 | terra | Underground Duchy | 1617127200 6 | 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 );