quakes

3 rows where magType = "md", sources = ",uw," 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
uw61501228	-0.2	22 km ENE of Ashford, Washington	1602015945600	1602204895800	https://earthquake.usgs.gov/earthquakes/eventpage/uw61501228	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw61501228.geojson	reviewed	0	uw	61501228	,uw61501228,	,uw,	,origin,phase-data,	10	0.02193	0.05	104.0	md	earthquake	M -0.2 - 22 km ENE of Ashford, Washington	46.8473333333333	-121.76
uw61680547	0.31	10 km SSE of Morton, Washington	1601984502780	1602007533190	https://earthquake.usgs.gov/earthquakes/eventpage/uw61680547	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw61680547.geojson	reviewed	1	uw	61680547	,uw61680547,	,uw,	,origin,phase-data,	6	0.1647	0.13	317.0	md	earthquake	M 0.3 - 10 km SSE of Morton, Washington	46.466	-122.227833333333
uw61691386	0.51	1 km NNW of Lake Marcel-Stillwater, Washington	1602027677140	1602198247110	https://earthquake.usgs.gov/earthquakes/eventpage/uw61691386	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw61691386.geojson	reviewed	4	uw	61691386	,uw61691386,	,uw,	,origin,phase-data,	6	0.142	0.14	107.0	md	earthquake	M 0.5 - 1 km NNW of Lake Marcel-Stillwater, Washington	47.7048333333333	-121.919666666667

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