Santorini Seismic And Volcanic Data
Comparative Data from International Institutions
@kaggle.brsdincer_santorini_seismic_and_volcanic_data_multiple
Comparative Data from International Institutions
@kaggle.brsdincer_santorini_seismic_and_volcanic_data_multiple
It contains data obtained from different institutions conducting seismological and volcanic research. There are also examples and links in the data that you can use. It is recommended that you pay attention to tabulation and data naming.
CREATE TABLE all_month (
"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
);
CREATE TABLE ieb_export (
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"time" VARCHAR,
"lat" DOUBLE,
"lon" DOUBLE,
"depth" DOUBLE,
"mag" DOUBLE,
"region" VARCHAR,
"timestamp" BIGINT
);
CREATE TABLE ieb_export_table (
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"time" VARCHAR,
"lat" DOUBLE,
"lon" DOUBLE,
"depth" DOUBLE,
"mag" DOUBLE,
"region" VARCHAR,
"timestamp" BIGINT
);
CREATE TABLE n_2_5_day (
"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
);
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
);
Anyone who has the link will be able to view this.