quakes

1 row where mmi = "4.245"

Search:

descending

id ▼	mag	place	time	updated	tz	url	detail	felt	cdi	mmi	alert	status	tsunami	sig	net	code	ids	sources	types	nst	dmin	rms	gap	magType	type	title	latitude	longitude
us6000c6rg	5.7	47 km ESE of Nikolski, Alaska	1602166959520	1602513173434		https://earthquake.usgs.gov/earthquakes/eventpage/us6000c6rg	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/us6000c6rg.geojson	1	2.7	4.245	green	reviewed	1	500	us	6000c6rg	,at00qhvzxu,us6000c6rg,ak020cym0qd0,	,at,us,ak,	,dyfi,ground-failure,impact-link,losspager,moment-tensor,oaf,origin,phase-data,shakemap,		0.677	1.35	169.0	mww	earthquake	M 5.7 - 47 km ESE of Nikolski, Alaska	52.7184	-168.2558

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE [quakes] (
   [mag] FLOAT,
   [place] TEXT,
   [time] INTEGER,
   [updated] INTEGER,
   [tz] TEXT,
   [url] TEXT,
   [detail] TEXT,
   [felt] TEXT,
   [cdi] TEXT,
   [mmi] TEXT,
   [alert] TEXT,
   [status] TEXT,
   [tsunami] INTEGER,
   [sig] INTEGER,
   [net] TEXT,
   [code] TEXT,
   [ids] TEXT,
   [sources] TEXT,
   [types] TEXT,
   [nst] INTEGER,
   [dmin] FLOAT,
   [rms] FLOAT,
   [gap] FLOAT,
   [magType] TEXT,
   [type] TEXT,
   [title] TEXT,
   [latitude] FLOAT,
   [longitude] FLOAT,
   [id] TEXT PRIMARY KEY
);