player_factions
4 rows where game_id = 6 sorted by faction
This data as json, CSV (advanced)
faction ✖
Link | rowid | player | faction ▼ | game_id | won | victory_points | dominance |
---|---|---|---|---|---|---|---|
20 | 20 | david | Riverfolk Company | 1617127200 6 | 0 | 22 | 0 |
21 | 21 | terra | Underground Duchy | 1617127200 6 | 1 | 30 | 0 |
22 | 22 | alex | Vagabond | 1617127200 6 | 0 | 24 | 0 |
23 | 23 | gabe | Woodland Alliance | 1617127200 6 | 0 | 24 | 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 );