quakes

2 rows where magType = "md", place = "5 km SSW of La Parguera, Puerto Rico" and rms = "0.11"

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
pr2020281004	3.05	5 km SSW of La Parguera, Puerto Rico	1602039184960	1602068133220		https://earthquake.usgs.gov/earthquakes/eventpage/pr2020281004	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020281004.geojson	4	3.1			reviewed	0	144	pr	2020281004	,us6000c6a0,pr2020281004,	,us,pr,	,dyfi,origin,phase-data,	22	0.048	0.11	238.0	md	earthquake	M 3.1 - 5 km SSW of La Parguera, Puerto Rico	17.9323	-67.0746
pr2020285001	2.87	5 km SSW of La Parguera, Puerto Rico	1602381587580	1602383718171		https://earthquake.usgs.gov/earthquakes/eventpage/pr2020285001	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020285001.geojson	1	2.2			reviewed	0	127	pr	2020285001	,us6000c7fc,pr2020285001,	,us,pr,	,dyfi,origin,phase-data,	22	0.0422	0.11	237.0	md	earthquake	M 2.9 - 5 km SSW of La Parguera, Puerto Rico	17.933	-67.0655

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