Significant Earthquakes, 1965-2016

Date, time, and location of all earthquakes with magnitude of 5.5 or higher

@kaggle.usgs_earthquake_database

Table List

1 table(890.21 KB)

Database

@kaggle.usgs_earthquake_database.database

890.21 KB
23412 rows
21 columns

date Date	time Time	latitude Latitude	longitude Longitude	type Type	depth Depth	magnitude Magnitude	magnitude_type Magnitude Type	id ID	source Source	location_source Location Source	magnitude_source Magnitude Source	status Status
01/02/1965	13:44:18	19.246	145.616	Earthquake	131.6	6	MW	ISCGEM860706	ISCGEM	ISCGEM	ISCGEM	Automatic
01/04/1965	11:29:49	1.863	127.352	Earthquake	80	5.8	MW	ISCGEM860737	ISCGEM	ISCGEM	ISCGEM	Automatic
01/05/1965	18:05:58	-20.579	-173.972	Earthquake	20	6.2	MW	ISCGEM860762	ISCGEM	ISCGEM	ISCGEM	Automatic
01/08/1965	18:49:43	-59.076	-23.557	Earthquake	15	5.8	MW	ISCGEM860856	ISCGEM	ISCGEM	ISCGEM	Automatic
01/09/1965	13:32:50	11.938	126.427	Earthquake	15	5.8	MW	ISCGEM860890	ISCGEM	ISCGEM	ISCGEM	Automatic
01/10/1965	13:36:32	-13.405	166.629	Earthquake	35	6.7	MW	ISCGEM860922	ISCGEM	ISCGEM	ISCGEM	Automatic
01/12/1965	13:32:25	27.357	87.867	Earthquake	20	5.9	MW	ISCGEM861007	ISCGEM	ISCGEM	ISCGEM	Automatic
01/15/1965	23:17:42	-13.309	166.212	Earthquake	35	6	MW	ISCGEM861111	ISCGEM	ISCGEM	ISCGEM	Automatic
01/16/1965	11:32:37	-56.452	-27.043	Earthquake	95	6	MW	ISCGEMSUP861125	ISCGEMSUP	ISCGEM	ISCGEM	Automatic
01/17/1965	10:43:17	-24.563	178.487	Earthquake	565	5.8	MW	ISCGEM861148	ISCGEM	ISCGEM	ISCGEM	Automatic


CREATE TABLE database (
  "date" VARCHAR,
  "time" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "type" VARCHAR,
  "depth" DOUBLE,
  "depth_error" DOUBLE,
  "depth_seismic_stations" DOUBLE,
  "magnitude" DOUBLE,
  "magnitude_type" VARCHAR,
  "magnitude_error" DOUBLE,
  "magnitude_seismic_stations" DOUBLE,
  "azimuthal_gap" DOUBLE,
  "horizontal_distance" DOUBLE,
  "horizontal_error" DOUBLE,
  "root_mean_square" DOUBLE,
  "id" VARCHAR,
  "source" VARCHAR,
  "location_source" VARCHAR,
  "magnitude_source" VARCHAR,
  "status" VARCHAR
);