quakes

5 rows where magType = "md" and nst = 29

View and edit SQL

Suggested facets: status, net, sources, 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
hv72167946 1.87 10 km ENE of Pāhala, Hawaii 1601939152360 1601939349220   https://earthquake.usgs.gov/earthquakes/eventpage/hv72167946 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72167946.geojson         automatic 0 54 hv 72167946 ,hv72167946, ,hv, ,origin,phase-data, 29   0.119999997 169.0 md earthquake M 1.9 - 10 km ENE of Pāhala, Hawaii 19.224666595459 -155.381164550781
nc73467336 1.73 6km W of Cobb, CA 1601990098090 1601993104963   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467336 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467336.geojson         automatic 0 46 nc 73467336 ,nc73467336, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 29 0.01272 0.04 45.0 md earthquake M 1.7 - 6km W of Cobb, CA 38.8256683 -122.7900009
nc73468166 2.02 8km NNW of Redwood Valley, CA 1602139848810 1602311266809   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468166 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468166.geojson         reviewed 0 63 nc 73468166 ,nc73468166, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 29 0.04091 0.06 54.0 md earthquake M 2.0 - 8km NNW of Redwood Valley, CA 39.3331667 -123.2355
nc73468216 1.17 6km WNW of The Geysers, CA 1602146436360 1602153424495   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468216 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468216.geojson         automatic 0 21 nc 73468216 ,nc73468216, ,nc, ,focal-mechanism,nearby-cities,origin,phase-data,scitech-link, 29 0.007902 0.03 76.0 md earthquake M 1.2 - 6km WNW of The Geysers, CA 38.8031654 -122.8221664
nc73469406 1.53 9km WNW of The Geysers, CA 1602408320280 1602413225165   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469406 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469406.geojson         automatic 0 36 nc 73469406 ,nc73469406, ,nc, ,focal-mechanism,nearby-cities,origin,phase-data,scitech-link, 29 0.006581 0.03 56.0 md earthquake M 1.5 - 9km WNW of The Geysers, CA 38.8203316 -122.8426666

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