quakes

1 row where place = "49 km S of Neiafu, Tonga" and type = "earthquake"

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
us6000c74m	4.8	49 km S of Neiafu, Tonga	1602262873604	1602263969040		https://earthquake.usgs.gov/earthquakes/eventpage/us6000c74m	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/us6000c74m.geojson					reviewed	0	354	us	6000c74m	,us6000c74m,	,us,	,origin,phase-data,		5.593	0.9	78.0	mb	earthquake	M 4.8 - 49 km S of Neiafu, Tonga	-19.0982	-174.0334

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