quakes

1 row where dmin = "0.312" and mag = "1.1"

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
nn00777792	1.1	32 km ENE of Lee Vining, California	1602152116820	1602152761954		https://earthquake.usgs.gov/earthquakes/eventpage/nn00777792	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nn00777792.geojson					automatic	0	19	nn	00777792	,nn00777792,	,nn,	,origin,phase-data,	9	0.312	0.15	111.84	ml	earthquake	M 1.1 - 32 km ENE of Lee Vining, California	38.038	-118.7715

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