quakes

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

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
hv72169586 1.83000004 4 km SSE of Pāhala, Hawaii 1602015743280 1602015936060   https://earthquake.usgs.gov/earthquakes/eventpage/hv72169586 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72169586.geojson         automatic 0 52 hv 72169586 ,hv72169586, ,hv, ,origin,phase-data, 28   0.119999997 163.0 md earthquake M 1.8 - 4 km SSE of Pāhala, Hawaii 19.1650009155273 -155.467834472656
hv72169891 1.46 Island of Hawaii, Hawaii 1602034162170 1602040644740   https://earthquake.usgs.gov/earthquakes/eventpage/hv72169891 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72169891.geojson         reviewed 0 33 hv 72169891 ,hv72169891, ,hv, ,origin,phase-data, 28   0.1 179.0 md earthquake M 1.5 - Island of Hawaii, Hawaii 19.7851666666667 -155.591333333333
nc73468041 1.02 6km NW of The Geysers, CA 1602116678680 1602117547598   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468041 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468041.geojson         automatic 0 16 nc 73468041 ,nc73468041, ,nc, ,focal-mechanism,nearby-cities,origin,phase-data,scitech-link, 28 0.01318 0.02 56.0 md earthquake M 1.0 - 6km NW of The Geysers, CA 38.8074989 -122.8121643
nc73468061 1.29 7km WNW of The Geysers, CA 1602120043910 1602124505337   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468061 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468061.geojson         automatic 0 26 nc 73468061 ,nc73468061, ,nc, ,focal-mechanism,nearby-cities,origin,phase-data,scitech-link, 28 0.002767 0.03 65.0 md earthquake M 1.3 - 7km WNW of The Geysers, CA 38.8084984 -122.8256683
nc73468711 1.94 31km SE of Bodie, CA 1602250485050 1602296700428   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468711 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468711.geojson         reviewed 0 58 nc 73468711 ,nn00777935,nc73468711, ,nn,nc, ,focal-mechanism,nearby-cities,origin,phase-data,scitech-link, 28 0.2794 0.05 89.0 md earthquake M 1.9 - 31km SE of Bodie, CA 38.04 -118.7371667
nm60311897 1.53 1 km W of Howardville, Missouri 1602466413900 1602514897020   https://earthquake.usgs.gov/earthquakes/eventpage/nm60311897 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nm60311897.geojson         reviewed 0 36 nm 60311897 ,nm60311897, ,nm, ,origin,phase-data, 28 0.05122 0.03 36.0 md earthquake M 1.5 - 1 km W of Howardville, Missouri 36.5676667 -89.6171667

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