quakes

1 row where mmi = "3.445"

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
us6000c760	5.4	110 km WNW of Port-Vila, Vanuatu	1602278543097	1602376887782		https://earthquake.usgs.gov/earthquakes/eventpage/us6000c760	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/us6000c760.geojson	2	3.4	3.445	green	reviewed	0	449	us	6000c760	,us6000c760,	,us,	,dyfi,losspager,origin,phase-data,shakemap,		1.771	0.71	24.0	mww	earthquake	M 5.4 - 110 km WNW of Port-Vila, Vanuatu	-17.2155	167.4266

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