quakes

1 row where mmi = "4.107"

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
us6000c7ce	5.4	33 km WNW of Moirāng, India	1602351480874	1602438072743		https://earthquake.usgs.gov/earthquakes/eventpage/us6000c7ce	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/us6000c7ce.geojson	79	4.8	4.107	green	reviewed	0	487	us	6000c7ce	,us6000c7ce,	,us,	,dyfi,losspager,origin,phase-data,shakemap,		0.846	0.59	22.0	mww	earthquake	M 5.4 - 33 km WNW of Moirāng, India	24.6316	93.4817

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