quakes

9 rows where magType = "md" and nst = 25

View and edit SQL

Suggested facets: status, 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
nc73467081 2.14 15km SW of Toms Place, CA 1601937267540 1602109925726   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467081 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467081.geojson         reviewed 0 70 nc 73467081 ,nc73467081,nn00777270, ,nc,nn, ,focal-mechanism,nearby-cities,origin,phase-data,scitech-link, 25 0.1042 0.04 130.0 md earthquake M 2.1 - 15km SW of Toms Place, CA 37.4781667 -118.816
nc73467211 1.33 7km WNW of The Geysers, CA 1601970857660 1601974684864   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467211 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467211.geojson         automatic 0 27 nc 73467211 ,nc73467211, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 25 0.004361 0.03 75.0 md earthquake M 1.3 - 7km WNW of The Geysers, CA 38.8058319 -122.8251648
nc73467746 1.31 7km W of Cobb, CA 1602065289320 1602068526311   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467746 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467746.geojson         automatic 0 26 nc 73467746 ,nc73467746, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 25 0.01269 0.02 49.0 md earthquake M 1.3 - 7km W of Cobb, CA 38.8338318 -122.8054962
nc73467771 0.92 8km NW of The Geysers, CA 1602070702660 1602073988851   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467771 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467771.geojson         automatic 0 13 nc 73467771 ,nc73467771, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 25 0.01648 0.03 47.0 md earthquake M 0.9 - 8km NW of The Geysers, CA 38.831665 -122.81633
nc73468326 0.79 6km WNW of The Geysers, CA 1602170027140 1602172505499   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468326 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468326.geojson         automatic 0 10 nc 73468326 ,nc73468326, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 25 0.006788 0.02 63.0 md earthquake M 0.8 - 6km WNW of The Geysers, CA 38.8084984 -122.8205032
nc73468956 1.86 7km WSW of St. Helena, CA 1602296719560 1602300965070   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468956 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468956.geojson         automatic 0 53 nc 73468956 ,nc73468956, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 25 0.1091 0.09 80.0 md earthquake M 1.9 - 7km WSW of St. Helena, CA 38.4765015 -122.5370026
nc73468996 1.83 13km N of Cloverdale, CA 1602314851990 1602323142233   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468996 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468996.geojson 1 2     automatic 0 52 nc 73468996 ,nc73468996, ,nc, ,dyfi,nearby-cities,origin,phase-data,scitech-link, 25 0.09838 0.05 74.0 md earthquake M 1.8 - 13km N of Cloverdale, CA 38.9216652 -123.0254974
nc73469196 1.21 8km W of Cobb, CA 1602360941160 1602362706602   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469196 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469196.geojson         automatic 0 23 nc 73469196 ,nc73469196, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 25 0.008635 0.02 48.0 md earthquake M 1.2 - 8km W of Cobb, CA 38.8320007 -122.8111649
nc73469521 1.78 10km NE of Milpitas, CA 1602424910200 1602428647021   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469521 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469521.geojson         automatic 0 49 nc 73469521 ,nc73469521, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 25 0.0483 0.06 78.0 md earthquake M 1.8 - 10km NE of Milpitas, CA 37.498333 -121.8320007

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