quakes

8 rows where magType = "md" and nst = 41

View and edit SQL

Suggested facets: status, rms, gap

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
hv72169046 1.69 30 km SSE of Waimea, Hawaii 1601991730280 1602020896780   https://earthquake.usgs.gov/earthquakes/eventpage/hv72169046 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72169046.geojson         reviewed 0 44 hv 72169046 ,hv72169046, ,hv, ,origin,phase-data, 41   0.11 170.0 md earthquake M 1.7 - 30 km SSE of Waimea, Hawaii 19.7928333333333 -155.521166666667
hv72169071 1.73000002 9 km E of Pāhala, Hawaii 1601993721210 1601993906320   https://earthquake.usgs.gov/earthquakes/eventpage/hv72169071 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72169071.geojson         automatic 0 46 hv 72169071 ,hv72169071, ,hv, ,origin,phase-data, 41   0.109999999 170.0 md earthquake M 1.7 - 9 km E of Pāhala, Hawaii 19.2123336791992 -155.389663696289
hv72170016 2.0 5 km S of Pāhala, Hawaii 1602041019600 1602041212280   https://earthquake.usgs.gov/earthquakes/eventpage/hv72170016 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72170016.geojson         automatic 0 62 hv 72170016 ,hv72170016, ,hv, ,origin,phase-data, 41   0.119999997 139.0 md earthquake M 2.0 - 5 km S of Pāhala, Hawaii 19.1538333892822 -155.488662719727
hv72170756 1.97000003 7 km NE of Pāhala, Hawaii 1602093179270 1602093374110   https://earthquake.usgs.gov/earthquakes/eventpage/hv72170756 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72170756.geojson         automatic 0 60 hv 72170756 ,hv72170756, ,hv, ,origin,phase-data, 41   0.119999997 143.0 md earthquake M 2.0 - 7 km NE of Pāhala, Hawaii 19.2485008239746 -155.425003051758
hv72171106 1.8 2 km ESE of Pāhala, Hawaii 1602115423830 1602128449970   https://earthquake.usgs.gov/earthquakes/eventpage/hv72171106 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72171106.geojson         reviewed 0 50 hv 72171106 ,hv72171106, ,hv, ,origin,phase-data, 41   0.1 197.0 md earthquake M 1.8 - 2 km ESE of Pāhala, Hawaii 19.1928333333333 -155.462333333333
hv72171931 1.74000001 12 km SSE of Volcano, Hawaii 1602177229480 1602177416690   https://earthquake.usgs.gov/earthquakes/eventpage/hv72171931 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72171931.geojson         automatic 0 47 hv 72171931 ,hv72171931, ,hv, ,origin,phase-data, 41   0.140000001 79.0 md earthquake M 1.7 - 12 km SSE of Volcano, Hawaii 19.3393325805664 -155.181167602539
hv72172241 1.85000002 Island of Hawaii, Hawaii 1602198873560 1602199070520   https://earthquake.usgs.gov/earthquakes/eventpage/hv72172241 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72172241.geojson         automatic 0 53 hv 72172241 ,hv72172241, ,hv, ,origin,phase-data, 41   0.129999995 150.0 md earthquake M 1.9 - Island of Hawaii, Hawaii 19.154333114624 -155.467834472656
hv72175916 2.02999997 5 km SSE of Pāhala, Hawaii 1602398610970 1602398806190   https://earthquake.usgs.gov/earthquakes/eventpage/hv72175916 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72175916.geojson         automatic 0 63 hv 72175916 ,hv72175916, ,hv, ,origin,phase-data, 41   0.109999999 167.0 md earthquake M 2.0 - 5 km SSE of Pāhala, Hawaii 19.1609992980957 -155.45866394043

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