quakes

1 row where place = "3km ENE of San Ramon, CA", type = "earthquake" and types = ",dyfi,focal-mechanism,nearby-cities,origin,phase-data,scitech-link,"

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
nc73469736	2.34	3km ENE of San Ramon, CA	1602465400260	1602493513529		https://earthquake.usgs.gov/earthquakes/eventpage/nc73469736	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469736.geojson	5	2.2			automatic	0	85	nc	73469736	,nc73469736,	,nc,	,dyfi,focal-mechanism,nearby-cities,origin,phase-data,scitech-link,	48	0.07635	0.07	62.0	md	earthquake	M 2.3 - 3km ENE of San Ramon, CA	37.791832	-121.946167

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