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
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 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
);
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_table (
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"time" VARCHAR,
"lat" DOUBLE,
"lon" DOUBLE,
"depth" DOUBLE,
"mag" DOUBLE,
"region" VARCHAR,
"timestamp" BIGINT
);
Anyone who has the link will be able to view this.