quakes

1 row where mmi = "5.526"

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
us6000c6si	5.8	86 km ESE of Kimbe, Papua New Guinea	1602172729998	1602261933332		https://earthquake.usgs.gov/earthquakes/eventpage/us6000c6si	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/us6000c6si.geojson			5.526	green	reviewed	0	518	us	6000c6si	,us6000c6si,	,us,	,losspager,moment-tensor,origin,phase-data,shakemap,		2.152	0.8	28.0	mww	earthquake	M 5.8 - 86 km ESE of Kimbe, Papua New Guinea	-5.9004	150.8349

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