quakes

2 rows where magType = "mw", status = "reviewed" 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
ci39654952	3.43	10km N of Big Bear City, CA	1602035044730	1602164457577		https://earthquake.usgs.gov/earthquakes/eventpage/ci39654952	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39654952.geojson	90	4.3	3.88		reviewed	0	220	ci	39654952	,ci39654952,us6000c69m,	,ci,us,	,dyfi,focal-mechanism,moment-tensor,nearby-cities,origin,phase-data,scitech-link,shakemap,	112	0.006167	0.15	28.0	mw	earthquake	M 3.4 - 10km N of Big Bear City, CA	34.3541667	-116.8266667
nc73468941	3.73	30km NNE of Redway, CA	1602293051430	1602383916956		https://earthquake.usgs.gov/earthquakes/eventpage/nc73468941	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468941.geojson	20	3.8	4.58		reviewed	0	222	nc	73468941	,nc73468941,us6000c76w,	,nc,us,	,dyfi,focal-mechanism,moment-tensor,nearby-cities,origin,phase-data,scitech-link,shakemap,	37	0.1591	0.19	35.0	mw	earthquake	M 3.7 - 30km NNE of Redway, CA	40.3761667	-123.7326667

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