Significant Earthquakes, 1900-Present

Comprehensive Earthquake Dataset, Magnitude 5+ Since 1900 - Updated Regularly

@kaggle.usamabuttar_significant_earthquakes

Table List

1 table(6.69 MB)

Significant Earthquakes

@kaggle.usamabuttar_significant_earthquakes.significant_earthquakes

6.69 MB
105061 rows
23 columns

unnamed_0 Unnamed: 0	time Time	latitude Latitude	longitude Longitude	mag Mag	magtype MagType	net Net	id Id	updated Updated	place Place	type Type	status Status	locationsource LocationSource	magsource MagSource
	1900-10-09T12:25:00.000Z	57.09	-153.48	7.86	mw	ushis	ushis391	2022-05-09T14:44:17.838Z	16 km SW of Old Harbor, Alaska	earthquake	reviewed	ushis	pt
1	1901-03-03T07:45:00.000Z	36	-120.5	6.4	ms	ushis	ushis393	2018-06-04T20:43:44.000Z	12 km NNW of Parkfield, California	earthquake	reviewed	ushis	ell
2	1901-07-26T22:20:00.000Z	40.8	-115.7	5	fa	ushis	ushis395	2018-06-04T20:43:44.000Z	6 km SE of Elko, Nevada	earthquake	reviewed	ushis	sjg
3	1901-12-30T22:34:00.000Z	52	-160	7	ms	ushis	ushis397	2018-06-04T20:43:44.000Z	south of Alaska	earthquake	reviewed	ushis	abe
4	1902-01-01T05:20:30.000Z	52.38	-167.45	7	ms	ushis	ushis400	2018-06-04T20:43:44.000Z	113 km ESE of Nikolski, Alaska	earthquake	reviewed	ushis	abe
5	1902-05-19T18:31:00.000Z	38.3	-121.9	5.4	ml	ushis	ushis402	2018-06-04T20:43:44.000Z	5 km S of Elmira, California	earthquake	reviewed	ushis	cdmg
6	1902-07-28T06:57:00.000Z	34.8	-120.4	5.4	ml	ushis	ushis404	2018-06-04T20:43:44.000Z	7 km SSE of Orcutt, California	earthquake	reviewed	ushis	cdmg
7	1902-11-17T19:50:00.000Z	37.4	-113.5	6.3	mint	ushis	ushis408	2022-11-27T22:54:19.228Z	Near Pine Valley, Utah	earthquake	reviewed	ushis	uu
8	1903-01-17T16:05:00.000Z	50.85	-175.16	7	ms	ushis	ushis411	2018-06-04T20:43:44.000Z	153 km SE of Adak, Alaska	earthquake	reviewed	ushis	abe
9	1903-02-05T18:26:00.000Z	52	175	6.8	ms	ushis	ushis413	2018-06-04T20:43:44.000Z	155 km SE of Attu Station, Alaska	earthquake	reviewed	ushis	abe


CREATE TABLE significant_earthquakes (
  "unnamed_0" BIGINT,
  "time" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "depth" DOUBLE,
  "mag" DOUBLE,
  "magtype" VARCHAR,
  "nst" DOUBLE,
  "gap" DOUBLE,
  "dmin" DOUBLE,
  "rms" DOUBLE,
  "net" VARCHAR,
  "id" VARCHAR,
  "updated" VARCHAR,
  "place" VARCHAR,
  "type" VARCHAR,
  "horizontalerror" DOUBLE,
  "deptherror" DOUBLE,
  "magerror" DOUBLE,
  "magnst" DOUBLE,
  "status" VARCHAR,
  "locationsource" VARCHAR,
  "magsource" VARCHAR
);