Santorini Seismic And Volcanic Data

Comparative Data from International Institutions

@kaggle.brsdincer_santorini_seismic_and_volcanic_data_multiple

Table List

5 tables(741.97 KB)

Spec Query

@kaggle.brsdincer_santorini_seismic_and_volcanic_data_multiple.spec_query

19.38 KB
54 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
Tue Feb 04 2025 20:00:23 GMT+0000 (Coordinated Universal Time)	36.5432	25.5937	10	4.7	mww	90	58	1.377	1.25	us	us7000pbba	Tue Feb 04 2025 20:19:02 GMT+0000 (Coordinated Universal Time)	19 km NE of Firá, Greece	earthquake	5.6	1.773	0.063	24	reviewed	us	us
Tue Feb 04 2025 17:10:52 GMT+0000 (Coordinated Universal Time)	36.6246	25.6082	10	4.5	mww	111	39	1.456	1.15	us	us7000pba3	Tue Feb 04 2025 17:54:10 GMT+0000 (Coordinated Universal Time)	27 km NE of Oía, Greece	earthquake	4.65	1.787	0.075	17	reviewed	us	us
Tue Feb 04 2025 13:04:13 GMT+0000 (Coordinated Universal Time)	36.4572	25.5722	10	5.3	mww	101	74	1.292	0.66	us	us7000pb82	Tue Feb 04 2025 20:11:49 GMT+0000 (Coordinated Universal Time)	12 km ENE of Mesariá, Greece	earthquake	5.97	1.862	0.048	41	reviewed	us	us
Tue Feb 04 2025 12:36:50 GMT+0000 (Coordinated Universal Time)	36.4717	25.497	10	4.7	mb	98	58	1.28	0.71	us	us7000pb7w	Tue Feb 04 2025 13:30:48 GMT+0000 (Coordinated Universal Time)	8 km NE of Firá, Greece	earthquake	4.99	1.865	0.063	77	reviewed	us	us
Tue Feb 04 2025 10:35:48 GMT+0000 (Coordinated Universal Time)	36.6579	25.6513	10	4.2	mb	45	101	1.5	0.52	us	us7000pb7n	Tue Feb 04 2025 14:24:29 GMT+0000 (Coordinated Universal Time)	29 km SW of Amorgós, Greece	earthquake	4.83	1.886	0.11	23	reviewed	us	us
Tue Feb 04 2025 09:09:31 GMT+0000 (Coordinated Universal Time)	36.6545	25.6596	10	4.7	mb	65	82	1.5	1.41	us	us7000pb7g	Tue Feb 04 2025 09:31:01 GMT+0000 (Coordinated Universal Time)	29 km SW of Amorgós, Greece	earthquake	2.25	1.883	0.072	59	reviewed	us	us
Tue Feb 04 2025 09:03:19 GMT+0000 (Coordinated Universal Time)	36.5152	25.701	10	4.5	mb	77	86	1.391	0.85	us	us7000pb7d	Tue Feb 04 2025 12:30:06 GMT+0000 (Coordinated Universal Time)	26 km ENE of Mesariá, Greece	earthquake	6	1.858	0.075	52	reviewed	us	us
Tue Feb 04 2025 08:55:27 GMT+0000 (Coordinated Universal Time)	36.4997	25.6292	10	4.3	mb	39	85	1.35	1.2	us	us7000pb7a	Tue Feb 04 2025 09:16:41 GMT+0000 (Coordinated Universal Time)	19 km NE of Mesariá, Greece	earthquake	2.92	1.944	0.154	12	reviewed	us	us
Tue Feb 04 2025 08:15:44 GMT+0000 (Coordinated Universal Time)	36.4074	25.5573	10	4.3	mb	35	91	1.242	1.31	us	us7000pb74	Tue Feb 04 2025 09:03:07 GMT+0000 (Coordinated Universal Time)	9 km E of Mesariá, Greece	earthquake	3.75	1.871	0.154	12	reviewed	us	us
Tue Feb 04 2025 06:53:24 GMT+0000 (Coordinated Universal Time)	36.5778	25.6669	10	4.6	mb	102	58	1.433	1.12	us	us7000pb6g	Tue Feb 04 2025 07:21:37 GMT+0000 (Coordinated Universal Time)	27 km NE of Firá, Greece	earthquake	4.71	1.835	0.06	82	reviewed	us	us


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