quakes

3 rows where title = "M 2.0 - 16 km WNW of Clayton, Idaho", type = "earthquake" and types = ",origin,phase-data,"

Search:

descending

id ▼	mag	place	time	updated	url	detail	status	sig	net	code	ids	sources	types	nst	dmin	rms	gap	magType	type	title	latitude	longitude
mb80468074	2.01	16 km WNW of Clayton, Idaho	1602404980910	1602513805370	https://earthquake.usgs.gov/earthquakes/eventpage/mb80468074	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/mb80468074.geojson	reviewed	62	mb	80468074	,mb80468074,	,mb,	,origin,phase-data,	8	0.63	0.18	58.0	ml	earthquake	M 2.0 - 16 km WNW of Clayton, Idaho	44.295	-114.5981667
mb80468124	1.96	16 km WNW of Clayton, Idaho	1602407985980	1602513554720	https://earthquake.usgs.gov/earthquakes/eventpage/mb80468124	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/mb80468124.geojson	reviewed	59	mb	80468124	,mb80468124,	,mb,	,origin,phase-data,	11	0.63	0.2	58.0	ml	earthquake	M 2.0 - 16 km WNW of Clayton, Idaho	44.2966667	-114.5988333
mb80468129	2.03	16 km WNW of Clayton, Idaho	1602408162860	1602513211500	https://earthquake.usgs.gov/earthquakes/eventpage/mb80468129	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/mb80468129.geojson	reviewed	63	mb	80468129	,mb80468129,	,mb,	,origin,phase-data,	12	0.634	0.24	58.0	ml	earthquake	M 2.0 - 16 km WNW of Clayton, Idaho	44.305	-114.5966667

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