quakes

6 rows where magType = "md" and nst = 45

View and edit SQL

Suggested facets: 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
hv72168431 1.91999996 2 km WSW of Pāhala, Hawaii 1601959689240 1601959887080   https://earthquake.usgs.gov/earthquakes/eventpage/hv72168431 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72168431.geojson         automatic 0 57 hv 72168431 ,hv72168431, ,hv, ,origin,phase-data, 45   0.119999997 82.0 md earthquake M 1.9 - 2 km WSW of Pāhala, Hawaii 19.1941661834717 -155.502838134766
hv72169456 1.98000002 6 km E of Pāhala, Hawaii 1602010154330 1602010341580   https://earthquake.usgs.gov/earthquakes/eventpage/hv72169456 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72169456.geojson         automatic 0 60 hv 72169456 ,hv72169456, ,hv, ,origin,phase-data, 45   0.119999997 164.0 md earthquake M 2.0 - 6 km E of Pāhala, Hawaii 19.2005004882812 -155.417999267578
hv72169591 2.21000004 3 km SSE of Pāhala, Hawaii 1602015947920 1602016135410   https://earthquake.usgs.gov/earthquakes/eventpage/hv72169591 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72169591.geojson         automatic 0 75 hv 72169591 ,hv72169591, ,hv, ,origin,phase-data, 45   0.140000001 161.0 md earthquake M 2.2 - 3 km SSE of Pāhala, Hawaii 19.1713333129883 -155.467163085938
hv72172236 1.84000003 21 km SE of Pāhala, Hawaii 1602198498520 1602198696880   https://earthquake.usgs.gov/earthquakes/eventpage/hv72172236 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72172236.geojson         automatic 0 52 hv 72172236 ,hv72172236, ,hv, ,origin,phase-data, 45   0.109999999 212.0 md earthquake M 1.8 - 21 km SE of Pāhala, Hawaii 19.0588340759277 -155.339172363281
hv72177366 2.02999997 4 km S of Pāhala, Hawaii 1602490176100 1602490370380   https://earthquake.usgs.gov/earthquakes/eventpage/hv72177366 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72177366.geojson         automatic 0 63 hv 72177366 ,hv72177366, ,hv, ,origin,phase-data, 45   0.109999999 106.0 md earthquake M 2.0 - 4 km S of Pāhala, Hawaii 19.1646671295166 -155.479339599609
nc73468601 2.26 7km WSW of Gilroy, CA 1602226812860 1602257241452   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468601 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468601.geojson 9 4.3     automatic 0 82 nc 73468601 ,nc73468601, ,nc, ,dyfi,focal-mechanism,nearby-cities,origin,phase-data,scitech-link, 45 0.05413 0.1 38.0 md earthquake M 2.3 - 7km WSW of Gilroy, CA 36.9830017 -121.6431656

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