quakes

16 rows where magType = "md" and nst = 18

View and edit SQL

Suggested facets: place, status, sig, net, sources, types, rms, gap, latitude

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
mb80467039 1.38 13 km NE of Seeley Lake, Montana 1601938530590 1602198929820   https://earthquake.usgs.gov/earthquakes/eventpage/mb80467039 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/mb80467039.geojson         reviewed 0 29 mb 80467039 ,mb80467039, ,mb, ,origin,phase-data, 18 0.101 0.17 147.0 md earthquake M 1.4 - 13 km NE of Seeley Lake, Montana 47.2653333 -113.3498333
nc73467466 0.78 8km NW of The Geysers, CA 1602014835230 1602016746707   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467466 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467466.geojson         automatic 0 9 nc 73467466 ,nc73467466, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 18 0.01647 0.02 44.0 md earthquake M 0.8 - 8km NW of The Geysers, CA 38.8286667 -122.8151703
nc73467736 1.12 10km ESE of Willits, CA 1602064439360 1602139506981   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467736 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467736.geojson         reviewed 0 19 nc 73467736 ,nc73467736, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 18 0.07217 0.09 110.0 md earthquake M 1.1 - 10km ESE of Willits, CA 39.3626667 -123.2531667
nc73467971 0.87 9km ENE of Gilroy, CA 1602105919590 1602146664569   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467971 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467971.geojson         reviewed 0 12 nc 73467971 ,nc73467971, ,nc, ,nearby-cities,origin,phase-data, 18 0.02565 0.13 51.0 md earthquake M 0.9 - 9km ENE of Gilroy, CA 37.051 -121.482
nc73468221 1.19 10km ESE of Willits, CA 1602146915670 1602323526425   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468221 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468221.geojson         reviewed 0 22 nc 73468221 ,nc73468221, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 18 0.06954 0.04 108.0 md earthquake M 1.2 - 10km ESE of Willits, CA 39.3648333 -123.26
nc73468436 0.75 7km NW of The Geysers, CA 1602186865160 1602186960848   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468436 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468436.geojson         automatic 0 9 nc 73468436 ,nc73468436, ,nc, ,nearby-cities,origin,phase-data, 18 0.00254 0.02 37.0 md earthquake M 0.8 - 7km NW of The Geysers, CA 38.8213348 -122.8081665
nc73468596 0.74 5km W of Cobb, CA 1602225562610 1602227347281   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468596 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468596.geojson         automatic 0 8 nc 73468596 ,nc73468596, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 18 0.008065 0.02 44.0 md earthquake M 0.7 - 5km W of Cobb, CA 38.8213348 -122.7805023
nc73468691 1.17 10km SE of Cloverdale, CA 1602249398230 1602252725930   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468691 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468691.geojson         automatic 0 21 nc 73468691 ,nc73468691, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 18 0.06262 0.03 231.0 md earthquake M 1.2 - 10km SE of Cloverdale, CA 38.7324982 -122.9499969
nc73468856 0.92 5km E of Mammoth Lakes, CA 1602276200480 1602281238483   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468856 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468856.geojson         reviewed 0 13 nc 73468856 ,nc73468856, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 18 0.01742 0.05 61.0 md earthquake M 0.9 - 5km E of Mammoth Lakes, CA 37.6406667 -118.9185
nc73469626 0.73 5km E of Mammoth Lakes, CA 1602448534620 1602455406353   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469626 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469626.geojson         reviewed 0 8 nc 73469626 ,nc73469626, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 18 0.01917 0.04 72.0 md earthquake M 0.7 - 5km E of Mammoth Lakes, CA 37.6365 -118.9231667
nm60311917 1.45 5 km NW of Ridgely, Tennessee 1602481033920 1602509731180   https://earthquake.usgs.gov/earthquakes/eventpage/nm60311917 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nm60311917.geojson         reviewed 0 32 nm 60311917 ,nm60311917, ,nm, ,origin,phase-data, 18 0.03705 0.06 49.0 md earthquake M 1.5 - 5 km NW of Ridgely, Tennessee 36.2971667 -89.5356667
pr2020281021 2.85 6 km SSE of Guánica, Puerto Rico 1602110928010 1602111774712   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020281021 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020281021.geojson         reviewed 0 125 pr 2020281021 ,pr2020281021, ,pr, ,origin,phase-data, 18 0.0608 0.13 218.0 md earthquake M 2.9 - 6 km SSE of Guánica, Puerto Rico 17.9143 -66.8805
pr2020281022 2.68 5 km S of Guánica, Puerto Rico 1602111650190 1602112540112   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020281022 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020281022.geojson         reviewed 0 110 pr 2020281022 ,pr2020281022, ,pr, ,origin,phase-data, 18 0.0535 0.17 212.0 md earthquake M 2.7 - 5 km S of Guánica, Puerto Rico 17.9251 -66.8983
pr2020282006 2.31 4 km S of Indios, Puerto Rico 1602149086980 1602152448580   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020282006 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020282006.geojson         reviewed 0 82 pr 2020282006 ,pr2020282006, ,pr, ,origin,phase-data, 18 0.0578 0.16 195.0 md earthquake M 2.3 - 4 km S of Indios, Puerto Rico 17.9543 -66.8253
pr2020283000 4.5 85 km ENE of Saint Croix, U.S. Virgin Islands 1602206484710 1602247882911   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020283000 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020283000.geojson 20 4.3     reviewed 0 320 pr 2020283000 ,us6000c6wr,pr2020283000, ,us,pr, ,dyfi,origin,phase-data, 18 1.8634 0.49 348.0 md earthquake M 4.5 - 85 km ENE of Saint Croix, U.S. Virgin Islands 17.994 -63.9913
pr2020285015 2.51 Puerto Rico region 1602419507050 1602422514437   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020285015 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020285015.geojson         reviewed 0 97 pr 2020285015 ,pr2020285015, ,pr, ,origin,phase-data, 18 0.0378 0.09 243.0 md earthquake M 2.5 - Puerto Rico region 17.936 -67.0618

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