quakes

1 row where magType = "mww", type = "earthquake" and types = ",ground-failure,losspager,moment-tensor,origin,phase-data,shakemap,"

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
us6000c7b1	5.9	Easter Island region	1602335697344	1602422329581		https://earthquake.usgs.gov/earthquakes/eventpage/us6000c7b1	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/us6000c7b1.geojson			0	green	reviewed	0	536	us	6000c7b1	,us6000c7b1,	,us,	,ground-failure,losspager,moment-tensor,origin,phase-data,shakemap,		2.901	1.02	50.0	mww	earthquake	M 5.9 - Easter Island region	-28.5676	-112.3045

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