quakes

4 rows where place = "5km E of Mammoth Lakes, CA", sig = 5 and type = "earthquake"

View and edit SQL

Suggested facets: mag, types, rms

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
nc73466951 0.55 5km E of Mammoth Lakes, CA 1601918961190 1601920759918   https://earthquake.usgs.gov/earthquakes/eventpage/nc73466951 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73466951.geojson         reviewed 0 5 nc 73466951 ,nc73466951, ,nc, ,nearby-cities,origin,phase-data, 12 0.01355 0.06 87.0 md earthquake M 0.6 - 5km E of Mammoth Lakes, CA 37.6458333 -118.9185
nc73468841 0.56 5km E of Mammoth Lakes, CA 1602276041740 1602281466035   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468841 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468841.geojson         reviewed 0 5 nc 73468841 ,nc73468841, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 15 0.01668 0.05 59.0 md earthquake M 0.6 - 5km E of Mammoth Lakes, CA 37.6401667 -118.9171667
nc73468846 0.58 5km E of Mammoth Lakes, CA 1602276054150 1602282128436   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468846 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468846.geojson         reviewed 0 5 nc 73468846 ,nc73468846, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 16 0.01714 0.04 62.0 md earthquake M 0.6 - 5km E of Mammoth Lakes, CA 37.6388333 -118.9173333
nc73469821 0.58 5km E of Mammoth Lakes, CA 1602478831520 1602520145305   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469821 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469821.geojson         reviewed 0 5 nc 73469821 ,nc73469821, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 21 0.0209 0.05 55.0 md earthquake M 0.6 - 5km E of Mammoth Lakes, CA 37.6378333 -118.9246667

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 190.77ms · About: https://gist.github.com/simonw/656c21b5800d5e4624dec9930f00e093