quakes

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

View and edit SQL

Suggested facets: mag, status, sig, 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
nc73467731 1.85 10km ESE of Willits, CA 1602064286120 1602310694871   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467731 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467731.geojson         reviewed 0 53 nc 73467731 ,nc73467731, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 24 0.07121 0.08 110.0 md earthquake M 1.9 - 10km ESE of Willits, CA 39.3616667 -123.2528333
nc73468131 1.17 16km SW of Toms Place, CA 1602133488200 1602192906760   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468131 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468131.geojson         reviewed 0 21 nc 73468131 ,nc73468131, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 24 0.1042 0.06 173.0 md earthquake M 1.2 - 16km SW of Toms Place, CA 37.4821667 -118.8243333
nc73468566 1.56 14km SW of Toms Place, CA 1602215409930 1602272044970   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468566 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468566.geojson         reviewed 0 37 nc 73468566 ,nc73468566, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 24 0.1107 0.05 128.0 md earthquake M 1.6 - 14km SW of Toms Place, CA 37.4805 -118.8076667
nc73468616 1.03 6km NW of The Geysers, CA 1602227026780 1602228484390   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468616 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468616.geojson         automatic 0 16 nc 73468616 ,nc73468616, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 24 0.01151 0.02 53.0 md earthquake M 1.0 - 6km NW of The Geysers, CA 38.8115005 -122.8148346
nc73469191 1.19 8km NW of The Geysers, CA 1602357597680 1602361145455   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469191 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469191.geojson         automatic 0 22 nc 73469191 ,nc73469191, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 24 0.006081 0.03 42.0 md earthquake M 1.2 - 8km NW of The Geysers, CA 38.8279991 -122.8151703
nc73469616 0.78 7km NW of The Geysers, CA 1602447159520 1602450844933   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469616 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469616.geojson         automatic 0 9 nc 73469616 ,nc73469616, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 24 0.004233 0.02 40.0 md earthquake M 0.8 - 7km NW of The Geysers, CA 38.8191681 -122.8096695
nm60311752 1.38 2 km S of Ridgely, Tennessee 1602181550050 1602258367330   https://earthquake.usgs.gov/earthquakes/eventpage/nm60311752 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nm60311752.geojson         reviewed 0 29 nm 60311752 ,nm60311752, ,nm, ,origin,phase-data, 24 0.02535 0.04 35.0 md earthquake M 1.4 - 2 km S of Ridgely, Tennessee 36.2406667 -89.486
uu60413662 1.03 4 km E of Magna, Utah 1602296273720 1602510114240   https://earthquake.usgs.gov/earthquakes/eventpage/uu60413662 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60413662.geojson         reviewed 0 16 uu 60413662 ,uu60413662, ,uu, ,origin,phase-data, 24 0.01845 0.1 45.0 md earthquake M 1.0 - 4 km E of Magna, Utah 40.7125 -112.051

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