LAST 30 DAYS - EARTHQUAKE / USGS

Scientific Reasons - REAL TIME

@kaggle.brsdincer_last_30_days_earthquake_usgs

Table List

1 table(730.45 KB)

Last 30 Days Earthquakes

@kaggle.brsdincer_last_30_days_earthquake_usgs.last_30_days_earthquakes

730.45 KB
9983 rows
22 columns

time Time	latitude Latitude	longitude Longitude	depth Depth	mag Mag	magtype MagType	nst Nst	gap Gap	dmin Dmin	rms Rms	net Net	id Id	updated Updated	place Place	type Type	horizontalerror HorizontalError	deptherror DepthError	magerror MagError	magnst MagNst	status Status	locationsource LocationSource	magsource MagSource
Sun Oct 24 2021 07:46:44 GMT+0000 (Coordinated Universal Time)	38.16	-118.209	4.2	0.6	ml	9	171.25	0.123	0.0948	nn	nn00826538	Sun Oct 24 2021 07:50:24 GMT+0000 (Coordinated Universal Time)	27 km SSW of Mina, Nevada	earthquake		36	0.37	5	automatic	nn	nn
Sun Oct 24 2021 07:43:48 GMT+0000 (Coordinated Universal Time)	62.1216	-149.3807	13.8	2.5	ml				0.73	ak	ak021dnb1ff9	Sun Oct 24 2021 07:52:56 GMT+0000 (Coordinated Universal Time)	24 km E of Susitna North, Alaska	earthquake		0.4			automatic	ak	ak
Sun Oct 24 2021 07:41:52 GMT+0000 (Coordinated Universal Time)	59.0518	-137.9189	2.6	2.2	ml				0.45	ak	ak021dnb10ce	Sun Oct 24 2021 07:48:15 GMT+0000 (Coordinated Universal Time)	115 km WSW of Covenant Life, Alaska	earthquake		0.4			automatic	ak	ak
Sun Oct 24 2021 07:15:04 GMT+0000 (Coordinated Universal Time)	36.8261681	-121.4256668	10.15	1.54	md	20	169	0.06291	0.13	nc	nc73643975	Sun Oct 24 2021 07:32:13 GMT+0000 (Coordinated Universal Time)	3km SW of Hollister, CA	earthquake	0.67	0.74	0.16	14	automatic	nc	nc
Sun Oct 24 2021 07:09:17 GMT+0000 (Coordinated Universal Time)	19.4138336181641	-155.26383972168	3.16000008583069	1.71	ml	12	70		0.0599999987	hv	hv72767687	Sun Oct 24 2021 07:14:48 GMT+0000 (Coordinated Universal Time)	4 km SW of Volcano, Hawaii	earthquake	0.31	0.409999996	0.28	3	automatic	hv	hv
Sun Oct 24 2021 07:08:56 GMT+0000 (Coordinated Universal Time)	36.4703331	-120.6039963	16.46	2.26	md	30	92	0.2334	0.22	nc	nc73643970	Sun Oct 24 2021 07:17:16 GMT+0000 (Coordinated Universal Time)	9km NE of New Idria, CA	earthquake	0.47	0.92	0.21	18	automatic	nc	nc
Sun Oct 24 2021 07:07:52 GMT+0000 (Coordinated Universal Time)	38.235	-112.6866667	8.02	3.26	ml	30	60	0.2623	0.18	uu	uu60464457	Sun Oct 24 2021 07:59:30 GMT+0000 (Coordinated Universal Time)	6 km SW of Beaver, Utah	earthquake	0.32	0.64	0.149	21	reviewed	uu	uu
Sun Oct 24 2021 07:00:20 GMT+0000 (Coordinated Universal Time)	61.793	-151.0945	76.9	1.9	ml				0.62	ak	ak021dnas5h1	Sun Oct 24 2021 07:44:54 GMT+0000 (Coordinated Universal Time)	27 km SE of Skwentna, Alaska	earthquake		0.5			automatic	ak	ak
Sun Oct 24 2021 06:49:12 GMT+0000 (Coordinated Universal Time)	32.9681664	-115.8748322	11.85	3.46	mlr	107	26	0.04453	0.29	ci	ci39841127	Sun Oct 24 2021 07:51:39 GMT+0000 (Coordinated Universal Time)	25km WSW of Westmorland, CA	earthquake	0.24	0.62	0.278	17	reviewed	ci	ci
Sun Oct 24 2021 06:43:38 GMT+0000 (Coordinated Universal Time)	38.1725	-117.881	11.1	1	ml	16	102.07	0.013	0.16	nn	nn00826529	Sun Oct 24 2021 06:46:25 GMT+0000 (Coordinated Universal Time)	31 km SE of Mina, Nevada	earthquake		0.5	0.17	9	automatic	nn	nn


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