player_factions
6 rows where player = "david"
This data as json, CSV (advanced)
Suggested facets: faction, won, victory_points
game_id ✖
- 1613926800 1
- 1614452400 1
- 1614459600 1
- 1615143600 1
- 1616349600 1
- 1617127200 1
Link | rowid ▼ | player | faction | game_id | won | victory_points | dominance |
---|---|---|---|---|---|---|---|
1 | 1 | david | Eyrie Dynasty | 1613926800 1 | 1 | 30 | 0 |
4 | 4 | david | Woodland Alliance | 1614452400 2 | 1 | 30 | 0 |
8 | 8 | david | Woodland Alliance | 1614459600 3 | 1 | 30 | 0 |
12 | 12 | david | Lizard Cult | 1615143600 4 | 0 | 10 | 0 |
17 | 17 | david | Eyrie Dynasty | 1616349600 5 | 0 | 24 | 0 |
20 | 20 | david | Riverfolk Company | 1617127200 6 | 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 );