quakes

1 row where place = "27 km S of Hawthorne, Nevada", rms = "0.26" and type = "earthquake"

View and edit SQL

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
nn00777260 1.1 27 km S of Hawthorne, Nevada 1601931406270 1601932032526   https://earthquake.usgs.gov/earthquakes/eventpage/nn00777260 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nn00777260.geojson         automatic 0 19 nn 00777260 ,nn00777260, ,nn, ,origin,phase-data, 8 0.08 0.26 282.02 ml earthquake M 1.1 - 27 km S of Hawthorne, Nevada 38.2772 -118.5625

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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
);
Powered by Datasette · Query took 180.972ms · About: https://gist.github.com/simonw/656c21b5800d5e4624dec9930f00e093