Examples_inconvenient

Datasets from the film An Inconvenient Truth

These sample datasets and SQL scripts can be used with the Entrance program. To execute a SQL script, click the "New" tool on the Entrance toolbar, then copy and paste text from the browser to Entrance. Links to the original source data are also provided.

The Keeling Curve

SQL to create the table: http://dbentrance.com/demo/create_keeling.sql

SQL to plot: http://dbentrance.com/demo/plot_keeling.sql

Source data: http://scrippsco2.ucsd.edu/data/in_situ_co2/monthly_mlo.csv

Rise in global temperature since 1880:

SQL to create the table: http://dbentrance.com/demo/create_global_temp.sql

SQL to plot: http://dbentrance.com/demo/plot_global_temp.sql

Source data: ftp://ftp.ncdc.noaa.gov/pub/data/anomalies/annual.land_and_ocean.90S.90N.df_1901-2000mean.dat

Vostok Ice Core Data

SQL to create the table: http://dbentrance.com/demo/create_vostok.sql

SQL to plot: http://dbentrance.com/demo/plot_vostok.sql

Data: ftp://ftp.ncdc.noaa.gov/pub/data/paleo/icecore/antarctica/vostok/co2nat.txt

Info: http://www.ncdc.noaa.gov/paleo/icecore/antarctica/vostok/vostok_co2.html

MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries.