peacehack

This should actually be running on BigQuery 😱

Ukraine mentions in february 2014 (ukraine revolution):

For more info read here

Ukraine mentions 9th september (plane shot)

For more info read here

Nigeria mentions in november (kidnap)

For more info read here

Palestine mentions in 8 july

For more info read here

Whatever

Next time go for spark...

Some interesting stats on a db.r3.xlarge (30gb ram 4 cpu, ~20gb data, 58 cols):

sudo apt-get install python-virtualenv
git clone git@github.com:papaloizouc/peacehack.git
cd peacehack/peacehack
virtualenv venv
source venv/bin/activate
sourve dev.env
pip install -r req.txt
python manage.py collectstatic
python manage.py runserver