quakes

1 row where place = "5km NW of Brawley, CA" and rms = "0.25"

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
ci39660392	1.49	5km NW of Brawley, CA	1602480950290	1602481606410		https://earthquake.usgs.gov/earthquakes/eventpage/ci39660392	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39660392.geojson					automatic	0	34	ci	39660392	,ci39660392,	,ci,	,focal-mechanism,nearby-cities,origin,phase-data,scitech-link,	28	0.03013	0.25	44.0	ml	earthquake	M 1.5 - 5km NW of Brawley, CA	33.0086667	-115.5746667

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