quakes

3 rows where magType = "md" and rms = "0.23"

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
pr2020282016	2.28	2 km N of Yauco, Puerto Rico	1602180224320	1602181414592	https://earthquake.usgs.gov/earthquakes/eventpage/pr2020282016	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020282016.geojson	reviewed	80	pr	2020282016	,pr2020282016,	,pr,	,origin,phase-data,	10	0.0841	0.23	83.0	md	earthquake	M 2.3 - 2 km N of Yauco, Puerto Rico	18.0533	-66.8483
pr2020284018	2.84	4 km SW of La Parguera, Puerto Rico	1602373400190	1602375031305	https://earthquake.usgs.gov/earthquakes/eventpage/pr2020284018	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020284018.geojson	reviewed	124	pr	2020284018	,pr2020284018,	,pr,	,origin,phase-data,	19	0.0405	0.23	239.0	md	earthquake	M 2.8 - 4 km SW of La Parguera, Puerto Rico	17.9468	-67.0778
uu60023759	-0.62	18 km ENE of Milford, Utah	1601991730380	1602077596650	https://earthquake.usgs.gov/earthquakes/eventpage/uu60023759	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60023759.geojson	reviewed	0	uu	60023759	,uu60023759,	,uu,	,origin,phase-data,	5	0.03096	0.23	241.0	md	earthquake	M -0.6 - 18 km ENE of Milford, Utah	38.4818333	-112.835

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