diplomacy-league's Introduction

diplomacy-league

This repository contains code for scraping diplomacy game data from www.backstabr.com and generating an interactive dashboard to track league rankings and stats.

Workflow

Scrape JSON game state data from the website.
Parse the JSON into SQLite tables.
Perform additional transformations on the data.
Generate the dashboard.

Data

JSON data

DB tables

League tables

players
player name
account name

Game tables

games
- game.id
- game.data
game.players
- game.id
- player.id
- country
- winner

diplomacy-league's People

Contributors

Watchers

Forkers

arlm

diplomacy-league's Issues

Design some sort of entrypoint for parsing new games into database

new table: game turn summary

Add a convenience table that aggregates events and metrics per turn, including territories, units, number of attacks, etc

It might be best to group this by player turns, though the fixed player count (7) does make it possible to create a completely flat table.

Tropy favicons appear smaller?

from https://andrewcstewart.github.io/flexdashboard-sandbox/

New table: game moves

It'd be useful to add a table based on orders that joins player id's, and possibly add retreats, as well as deriving any additional information about movements.

(Alternatively), some additional summary tables could be created for specific actions such as attacks, which could include information on attack strength, units involved, allies involved, convoys, etc.

Recommend Projects