All The Earthquakes Dataset : From 1990-2023

Unveiling Earth's Seismic Secrets - A Comprehensive Dataset (1990-2023)

@kaggle.alessandrolobello_the_ultimate_earthquake_from_1990_2023

Table List

1 table(144.72 MB)

Eartquakes 1990–2023

@kaggle.alessandrolobello_the_ultimate_earthquake_from_1990_2023.eartquakes_1990_2023

144.72 MB
3445751 rows
12 columns

time Time	place Place	status Status	significance Significance	data_type Data Type	magnitudo Magnitudo	state State	longitude Longitude	latitude Latitude	depth Depth	date Date
631153353990	12 km NNW of Meadow Lakes, Alaska	reviewed	96	earthquake	2.5	Alaska	-149.6692	61.7302	30.1	1990-01-01 00:22:33.990000+00:00
631153491210	14 km S of Volcano, Hawaii	reviewed	31	earthquake	1.41	Hawaii	-155.2123333	19.3176667	6.585	1990-01-01 00:24:51.210000+00:00
631154083450	7 km W of Cobb, California	reviewed	19	earthquake	1.11	California	-122.8061667	38.821	3.22	1990-01-01 00:34:43.450000+00:00
631155512130	11 km E of Mammoth Lakes, California	reviewed	15	earthquake	0.98	California	-118.8463333	37.6643333	-0.584	1990-01-01 00:58:32.130000+00:00
631155824490	16km N of Fillmore, CA	reviewed	134	earthquake	2.95	California	-118.934	34.546	16.122	1990-01-01 01:03:44.490000+00:00
631155853760	16km N of Fillmore, CA	reviewed	118	earthquake	2.77	California	-118.923	34.543	16.342	1990-01-01 01:04:13.760000+00:00
631156030570	6 km WSW of Mammoth Lakes, California	reviewed	20	earthquake	1.13	California	-119.04	37.6326667	-1.499	1990-01-01 01:07:10.570000+00:00
631156431950	12 km E of Mammoth Lakes, California	reviewed	11	earthquake	0.83	California	-118.8341667	37.6615	0.556	1990-01-01 01:13:51.950000+00:00
631156614070	11 km E of Mammoth Lakes, California	reviewed	39	earthquake	1.59	California	-118.8401667	37.6623333	-0.234	1990-01-01 01:16:54.070000+00:00
631156620210	1 km W of Wilkeson, Washington	reviewed	74	earthquake	2.2	Washington	-122.0711667	47.1025	8.382	1990-01-01 01:17:00.210000+00:00


CREATE TABLE eartquakes_1990_2023 (
  "time" BIGINT,
  "place" VARCHAR,
  "status" VARCHAR,
  "tsunami" BIGINT,
  "significance" BIGINT,
  "data_type" VARCHAR,
  "magnitudo" DOUBLE,
  "state" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "depth" DOUBLE,
  "date" VARCHAR
);