quakes

1 row where mmi = "3.18"

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
ak020cwv4p5l	4.1	30 km WNW of Susitna, Alaska	1602061170427	1602210771290		https://earthquake.usgs.gov/earthquakes/eventpage/ak020cwv4p5l	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ak020cwv4p5l.geojson	316	4.1	3.18	green	reviewed	1	388	ak	020cwv4p5l	,ak020cwv4p5l,at00qhtqb6,us6000c6d7,	,ak,at,us,	,dyfi,impact-link,losspager,moment-tensor,origin,phase-data,shakemap,			1.04		ml	earthquake	M 4.1 - 30 km WNW of Susitna, Alaska	61.6435	-151.0481

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
);