International Relations Database
Python R
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
doc
htsql
irdata
.gitignore
README.rst
build_irdata.py
schema_graph.py
setup.py
table_docs.py

README.rst

International Relations Data

I got tired of the merging and cleaning of international relations data, so I put it all together in a relational database.

It is similar to EUGene, but uses an relational database backend, and is much less complete.

The database currently includes the following datasets:

Install

The code is generally database agnostic since it is written with in sqlalchemy. I have tested it with sqlite and postgresql.

Sqlite

To install irdata as a sqlite database at path/to/database/irdata.db.

$ python build_irdata.py sqlite:///path/to/database/irdata.db

Postgresql

To install irdata to the postgresql database irdata

First create the database if it doesn't exist.

$ createdb irdata
$ python build_irdata.py postgresql://user@hostname/irdata

Roadmap

  • add all datasets currently in COW and EUGene
  • add a HTSQL frontend