quakes

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

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
hv72170416 2.01 7 km E of Naalehu, Hawaii 1602067635310 1602094040310   https://earthquake.usgs.gov/earthquakes/eventpage/hv72170416 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72170416.geojson         reviewed 0 62 hv 72170416 ,hv72170416, ,hv, ,origin,phase-data, 27   0.12 184.0 md earthquake M 2.0 - 7 km E of Naalehu, Hawaii 19.0785 -155.509
nc73467726 1.95 10km ESE of Willits, CA 1602064246800 1602311344110   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467726 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467726.geojson         reviewed 0 58 nc 73467726 ,nc73467726, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 27 0.07304 0.08 59.0 md earthquake M 2.0 - 10km ESE of Willits, CA 39.3645 -123.2518333
nc73468256 1.78 7km WNW of The Geysers, CA 1602157426660 1602165785885   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468256 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468256.geojson         automatic 0 49 nc 73468256 ,nc73468256, ,nc, ,focal-mechanism,nearby-cities,origin,phase-data,scitech-link, 27 0.005352 0.05 65.0 md earthquake M 1.8 - 7km WNW of The Geysers, CA 38.8076668 -122.8225021
nc73469416 1.31 6km W of Cobb, CA 1602410246850 1602416225477   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469416 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469416.geojson         automatic 0 26 nc 73469416 ,nc73469416, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 27 0.01135 0.04 50.0 md earthquake M 1.3 - 6km W of Cobb, CA 38.8226662 -122.7888336
nm60311592 1.34 8 km SE of Marston, Missouri 1601952052550 1601996608140   https://earthquake.usgs.gov/earthquakes/eventpage/nm60311592 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nm60311592.geojson         reviewed 0 28 nm 60311592 ,nm60311592, ,nm, ,origin,phase-data, 27 0.06526 0.05 42.0 md earthquake M 1.3 - 8 km SE of Marston, Missouri 36.4623333 -89.5485

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