quakes

1 row where mmi = "2.674"

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
ci39657280	2.76	2km WNW of Estacion Coahuila, B.C., MX	1602197049150	1602388301933		https://earthquake.usgs.gov/earthquakes/eventpage/ci39657280	https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39657280.geojson	1	2.2	2.674		reviewed	0	117	ci	39657280	,ew1602197036,ci39657280,us6000c6vv,	,ew,ci,us,	,dyfi,focal-mechanism,nearby-cities,origin,phase-data,scitech-link,shake-alert,shakemap,	18	0.06167	0.33	122.0	ml	earthquake	M 2.8 - 2km WNW of Estacion Coahuila, B.C., MX	32.2016667	-115.021

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