quakes

4 rows where title = "M 0.7 - 5km E of Mammoth Lakes, CA" and type = "earthquake"

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
nc73468236	0.72	5km E of Mammoth Lakes, CA	1602150097530	1602260313638	https://earthquake.usgs.gov/earthquakes/eventpage/nc73468236	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468236.geojson	reviewed	8	nc	73468236	,nc73468236,	,nc,	,nearby-cities,origin,phase-data,scitech-link,	21	0.02003	0.03	69.0	md	earthquake	M 0.7 - 5km E of Mammoth Lakes, CA	37.6298333	-118.9276667
nc73468831	0.69	5km E of Mammoth Lakes, CA	1602275900540	1602278502718	https://earthquake.usgs.gov/earthquakes/eventpage/nc73468831	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468831.geojson	reviewed	7	nc	73468831	,nc73468831,	,nc,	,nearby-cities,origin,phase-data,scitech-link,	17	0.01545	0.04	46.0	md	earthquake	M 0.7 - 5km E of Mammoth Lakes, CA	37.6358333	-118.918
nc73468836	0.68	5km E of Mammoth Lakes, CA	1602276013630	1602279284369	https://earthquake.usgs.gov/earthquakes/eventpage/nc73468836	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468836.geojson	reviewed	7	nc	73468836	,nc73468836,	,nc,	,nearby-cities,origin,phase-data,scitech-link,	15	0.0162	0.04	63.0	md	earthquake	M 0.7 - 5km E of Mammoth Lakes, CA	37.6376667	-118.9171667
nc73469626	0.73	5km E of Mammoth Lakes, CA	1602448534620	1602455406353	https://earthquake.usgs.gov/earthquakes/eventpage/nc73469626	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469626.geojson	reviewed	8	nc	73469626	,nc73469626,	,nc,	,nearby-cities,origin,phase-data,scitech-link,	18	0.01917	0.04	72.0	md	earthquake	M 0.7 - 5km E of Mammoth Lakes, CA	37.6365	-118.9231667

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