quakes

1 row where place = "38 km ENE of Kainantu, Papua New Guinea", type = "earthquake" and types = ",dyfi,ground-failure,impact-link,losspager,moment-tensor,origin,phase-data,shakemap,"

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
us6000c6mu	6.3	38 km ENE of Kainantu, Papua New Guinea	1602142532224	1602317079636		https://earthquake.usgs.gov/earthquakes/eventpage/us6000c6mu	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/us6000c6mu.geojson	28	6.9	5.525	green	reviewed	1	630	us	6000c6mu	,at00qhvh38,pt20282000,us6000c6mu,	,at,pt,us,	,dyfi,ground-failure,impact-link,losspager,moment-tensor,origin,phase-data,shakemap,		3.413	0.89	15.0	mww	earthquake	M 6.3 - 38 km ENE of Kainantu, Papua New Guinea	-6.114	146.1686

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