quakes

7 rows where magType = "md" and nst = 26

View and edit SQL

Suggested facets: mag, place, status, sig, net, sources, types, rms, title

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
hv72169881 0.99 29 km ENE of Honaunau-Napoopoo, Hawaii 1602033496850 1602037853330   https://earthquake.usgs.gov/earthquakes/eventpage/hv72169881 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72169881.geojson         reviewed 0 15 hv 72169881 ,hv72169881, ,hv, ,origin,phase-data, 26   0.1 154.0 md earthquake M 1.0 - 29 km ENE of Honaunau-Napoopoo, Hawaii 19.5435 -155.600333333333
hv72172311 1.70000005 2 km SE of Pāhala, Hawaii 1602205184590 1602205373430   https://earthquake.usgs.gov/earthquakes/eventpage/hv72172311 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72172311.geojson         automatic 0 44 hv 72172311 ,hv72172311, ,hv, ,origin,phase-data, 26   0.129999995 206.0 md earthquake M 1.7 - 2 km SE of Pāhala, Hawaii 19.1881675720215 -155.462005615234
nc73467216 1.33 7km WNW of The Geysers, CA 1601971285770 1601976185007   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467216 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467216.geojson         automatic 0 27 nc 73467216 ,nc73467216, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 26 0.004037 0.03 69.0 md earthquake M 1.3 - 7km WNW of The Geysers, CA 38.8061676 -122.8253326
nc73467501 1.08 7km NW of The Geysers, CA 1602017380170 1602017479210   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467501 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467501.geojson         automatic 0 18 nc 73467501 ,nc73467501, ,nc, ,nearby-cities,origin,phase-data, 26 0.007918 0.03 50.0 md earthquake M 1.1 - 7km NW of The Geysers, CA 38.8148346 -122.8225021
nc73468671 1.33 7km WNW of The Geysers, CA 1602244173760 1602246606364   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468671 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468671.geojson         automatic 0 27 nc 73468671 ,nc73468671, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 26 0.005303 0.03 59.0 md earthquake M 1.3 - 7km WNW of The Geysers, CA 38.8113327 -122.8231659
nc73469006 1.17 9km WNW of The Geysers, CA 1602316484960 1602326824754   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469006 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469006.geojson         automatic 0 21 nc 73469006 ,nc73469006, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 26 0.006991 0.03 51.0 md earthquake M 1.2 - 9km WNW of The Geysers, CA 38.8204994 -122.8433304
pr2020280013 4.05 6 km SSE of Guánica, Puerto Rico 1602025382920 1602112029526   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020280013 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020280013.geojson 32 4.8 4.368 green reviewed 0 268 pr 2020280013 ,us6000c68e,pr2020280013, ,us,pr, ,dyfi,losspager,origin,phase-data,shakemap, 26 0.057 0.15 203.0 md earthquake M 4.1 - 6 km SSE of Guánica, Puerto Rico 17.9193 -66.8908

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