player_factions
4 rows where dominance = 0 and game_id = 2
This data as json, CSV (advanced)
Suggested facets: won, victory_points
Link | rowid ▼ | player | faction | game_id | won | victory_points | dominance |
---|---|---|---|---|---|---|---|
4 | 4 | david | Woodland Alliance | 1614452400 2 | 1 | 30 | 0 |
5 | 5 | terra | Vagabond | 1614452400 2 | 1 | 30 | 0 |
6 | 6 | alex | Eyrie Dynasty | 1614452400 2 | 1 | 30 | 0 |
7 | 7 | bot | Mechanical Marquise | 1614452400 2 | 0 | 22 | 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 );