quakes

1 row where mmi = "2.89"

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
ak020d1vb29a	4.6	111 km SSE of Port Graham, Alaska	1602328930452	1602342095220		https://earthquake.usgs.gov/earthquakes/eventpage/ak020d1vb29a	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ak020d1vb29a.geojson	6	2.7	2.89	green	reviewed	1	327	ak	020d1vb29a	,ak020d1vb29a,at00qhzgwy,us6000c7an,	,ak,at,us,	,dyfi,impact-link,losspager,origin,phase-data,shakemap,			0.63		ml	earthquake	M 4.6 - 111 km SSE of Port Graham, Alaska	58.5024	-150.7889

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