US ENERGY PRODUCTION AND CONSUMPTION DATA 2001-2009
Copyright (C) 2010 Patrick Crews
====================================================

This is a sample database for testing purposes.

The original data came from the U.S. Energy Information Administration
http://www.eia.doe.gov/cneaf/electricity/epa/epa_sprdshts_monthly.html

The data was exported into relational form from the excel spreadsheets:
2001 - Present Net Generation by State by Type of Producer by Energy Source
2001 - Present Fossil Fuel Consumption for Electricity Generation by Year, Industry Type and State

The database contains ~290k records across all of the tables.  The data seems
to allow for many interesting JOINs and data mining queries.

USAGE
=====

Simply use the drizzle client to send the SQL to a running server:
$drizzle -uroot -pYOUR_PORT < us_energy_data_dump.sql

The schema for the tables can be seen in the file:
us_energy_data_schema.pdf

It is possible to create tables for US totals by month as well.
While this data can be extracted, it might allow for easier and more
interesting random testing with an extra set of JOIN'able tables
in the mix.

	

LICENSE
=======
This work is licensed under the 
Creative Commons Attribution-Share Alike 3.0 Unported License. 
To view a copy of this license, visit 
http://creativecommons.org/licenses/by-sa/3.0/ or send a letter to 
Creative Commons, 171 Second Street, Suite 300, San Francisco, 
California, 94105, USA.



