quakes

1 row where place = "231 km E of Levuka, Fiji"

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
us6000c617	6.0	231 km E of Levuka, Fiji	1601979106475	1602084409040		https://earthquake.usgs.gov/earthquakes/eventpage/us6000c617	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/us6000c617.geojson			1.634	green	reviewed	0	554	us	6000c617	,us6000c617,	,us,	,losspager,moment-tensor,origin,phase-data,shakemap,		3.298	1.11	18.0	mww	earthquake	M 6.0 - 231 km E of Levuka, Fiji	-18.0186	-178.4948

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