quakes

1 row where mmi = "4.708"

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
us6000c5zm	5.9	68 km SE of Sand Point, Alaska	1601963690520	1602137023615		https://earthquake.usgs.gov/earthquakes/eventpage/us6000c5zm	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/us6000c5zm.geojson	13	4.6	4.708	green	reviewed	1	542	us	6000c5zm	,at00qhrn3g,ak020cv5sgx1,ak020cv5s0vm,us6000c5zm,	,at,ak,ak,us,	,dyfi,ground-failure,impact-link,losspager,moment-tensor,origin,phase-data,shakemap,		0.157	0.87	122.0	mww	earthquake	M 5.9 - 68 km SE of Sand Point, Alaska	54.8444	-159.8598

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