Earthquake

Know about earthquakes just after they happen

@kaggle.farazrahman_earthquake

Table List

1 table(744.52 KB)

All Month

@kaggle.farazrahman_earthquake.all_month

744.52 KB
9064 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
2025-01-16T02:09:21.820Z	34.0446667	-117.1333333	6.41	1.39	ml	60	29	0.01965	0.17	ci	ci40840599	2025-01-16T02:14:01.618Z	3 km S of Mentone, CA	earthquake	0.13	0.32	0.174	27	automatic	ci	ci
2025-01-16T01:59:22.210Z	18.022666666667	-66.8325	16.26	2.42	md	12	131	0.06051	0.22	pr	pr71470933	2025-01-16T02:07:21.980Z	2 km SE of Yauco, Puerto Rico	earthquake	0.5	0.88	0.075361428755686	5	reviewed	pr	pr
2025-01-16T01:55:52.520Z	38.8313331604	-122.82133483887	2.2699999809265	0.48	md	9	129	0.01184	0.01	nc	nc75117811	2025-01-16T01:57:28.177Z	8 km NNW of The Geysers, CA	earthquake	0.47	0.829999983	0.28	9	automatic	nc	nc
2025-01-16T01:49:24.210Z	18.2545	-66.429	39.02	2.3	md	10	117	0.08961	0.07	pr	pr71470923	2025-01-16T02:00:19.900Z	5 km NW of Orocovis, Puerto Rico	earthquake	0.52	0.7	0.035799866534929	6	reviewed	pr	pr
2025-01-16T01:49:15.310Z	36.446166992188	-121.00816345215	0.87000000476837	1.66	md	7	125	0.04118	0.06	nc	nc75117806	2025-01-16T01:50:51.945Z	15 km SE of Pinnacles, CA	earthquake	0.47	1.01999998	0.04	6	automatic	nc	nc
2025-01-16T01:30:54.154Z	39.3857	-120.1475	4	1.3	ml	13	85.5	0.12	0.1414	nn	nn00892045	2025-01-16T01:32:59.659Z	7 km NNE of Truckee, California	earthquake		1.9	0.44	10	automatic	nn	nn
2025-01-16T01:29:56.630Z	38.834331512451	-122.87882995606	2.1300001144409	0.77	md	11	124	0.009775	0.04	nc	nc75117796	2025-01-16T01:31:31.925Z	12 km NW of The Geysers, CA	earthquake	0.4	0.620000005	0.3	12	automatic	nc	nc
2025-01-16T01:07:27.025Z	-3.0609	102.7448	201.079	4.8	mb	47	136	1.308	0.83	us	us6000pkbn	2025-01-16T01:20:30.040Z	28 km NNW of Lubuklinggau, Indonesia	earthquake	9.89	7.642	0.104	29	reviewed	us	us
2025-01-16T01:01:27.480Z	48.8931	153.4416	171.764	4.3	mb	34	187	5.003	0.37	us	us6000pkbm	2025-01-16T01:31:59.040Z	276 km SW of Severo-Kuril’sk, Russia	earthquake	16.17	13.998	0.104	26	reviewed	us	us
2025-01-16T00:55:54.720Z	33.1726667	-116.0361667	7.11	1.33	ml	34	42	0.04901	0.17	ci	ci40840591	2025-01-16T01:18:03.529Z	10 km ENE of Ocotillo Wells, CA	earthquake	0.19	0.49	0.129	24	reviewed	ci	ci


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