Add HiveQL used to generate intermediate data

These queries could also be used on regular mysql if you have a
large enough database
Use a larger sample
Extract code that transforms data to state level

This makes it easier to operate on a sample of the full dataset.
The visualization script is now only responsible for the visualization