quakes

1 row where rms = "0.21", sig = 107 and type = "earthquake"

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
ci39656712	2.57	14km WNW of Anza, CA	1602178248830	1602265257290		https://earthquake.usgs.gov/earthquakes/eventpage/ci39656712	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39656712.geojson	15	3.8			reviewed	0	107	ci	39656712	,ci39656712,	,ci,	,dyfi,focal-mechanism,nearby-cities,origin,phase-data,scitech-link,	113	0.04462	0.21	14.0	ml	earthquake	M 2.6 - 14km WNW of Anza, CA	33.583	-116.816

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