quakes

2 rows where magType = "md" and net = "mb"

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
mb80467039	1.38	13 km NE of Seeley Lake, Montana	1601938530590	1602198929820		https://earthquake.usgs.gov/earthquakes/eventpage/mb80467039	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/mb80467039.geojson					reviewed	0	29	mb	80467039	,mb80467039,	,mb,	,origin,phase-data,	18	0.101	0.17	147.0	md	earthquake	M 1.4 - 13 km NE of Seeley Lake, Montana	47.2653333	-113.3498333
mb80467589	1.48	5 km E of Butte, Montana	1602270109890	1602282780730		https://earthquake.usgs.gov/earthquakes/eventpage/mb80467589	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/mb80467589.geojson					reviewed	0	34	mb	80467589	,mb80467589,	,mb,	,origin,phase-data,	11	0.061	0.14	111.0	md	quarry blast	M 1.5 Quarry Blast - 5 km E of Butte, Montana	46.0045	-112.47

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