tutorial.worldwide_earthquakes
tutorial
Updated about 4 years ago
Rows
10
Sourced from: http://earthquake.usgs.gov/earthquakes/eqarchives/year/eqstats.php
Used in SQL School lesson: http://sqlschool.modeanalytics.com/solutions-to-common-problems/pivoting-columns-to-rows.html
Schema
| Name | Data Type |
|---|---|
| magnitude | String |
| year_2000 | Number |
| year_2001 | Number |
| year_2002 | Number |
| year_2003 | Number |
| year_2004 | Number |
| year_2005 | Number |
| year_2006 | Number |
| year_2007 | Number |
| year_2008 | Number |
| year_2009 | Number |
| year_2010 | Number |
| year_2011 | Number |
| year_2012 | Number |
| id | Serial |