quakes

24 rows where sig = 28

View and edit SQL

Suggested facets: mag, place, status, net, sources, types, nst, rms, gap, magType, type, title

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
ci39653400 1.34 2km ENE of Westmorland, CA 1601924489600 1601924712877   https://earthquake.usgs.gov/earthquakes/eventpage/ci39653400 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39653400.geojson         automatic 0 28 ci 39653400 ,ci39653400, ,ci, ,nearby-cities,origin,phase-data,scitech-link, 13 0.02239 0.27 84.0 ml earthquake M 1.3 - 2km ENE of Westmorland, CA 33.045 -115.6073333
ci39653768 1.36 4km ENE of Westmorland, CA 1601953641690 1601953857674   https://earthquake.usgs.gov/earthquakes/eventpage/ci39653768 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39653768.geojson         automatic 0 28 ci 39653768 ,ci39653768, ,ci, ,nearby-cities,origin,phase-data,scitech-link, 16 0.01089 0.28 72.0 ml earthquake M 1.4 - 4km ENE of Westmorland, CA 33.0488333 -115.5851667
ci39654560 1.35 6km SE of Ocotillo, CA 1602010908390 1602011118140   https://earthquake.usgs.gov/earthquakes/eventpage/ci39654560 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39654560.geojson         automatic 0 28 ci 39654560 ,ci39654560, ,ci, ,nearby-cities,origin,phase-data,scitech-link, 21 0.05266 0.23 73.0 ml earthquake M 1.4 - 6km SE of Ocotillo, CA 32.6948333 -115.95
ci39655248 1.36 20km ESE of Little Lake, CA 1602076482160 1602076702432   https://earthquake.usgs.gov/earthquakes/eventpage/ci39655248 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39655248.geojson         automatic 0 28 ci 39655248 ,ci39655248, ,ci, ,nearby-cities,origin,phase-data,scitech-link, 21 0.07602 0.18 71.0 ml earthquake M 1.4 - 20km ESE of Little Lake, CA 35.8638333 -117.7005
ci39655864 1.36 13km SSW of Searles Valley, CA 1602106064600 1602106291860   https://earthquake.usgs.gov/earthquakes/eventpage/ci39655864 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39655864.geojson         automatic 0 28 ci 39655864 ,ci39655864, ,ci, ,nearby-cities,origin,phase-data,scitech-link, 19 0.08313 0.18 147.0 ml earthquake M 1.4 - 13km SSW of Searles Valley, CA 35.6691667 -117.4748333
ci39656104 1.35 4km ENE of Westmorland, CA 1602118871570 1602283254300   https://earthquake.usgs.gov/earthquakes/eventpage/ci39656104 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39656104.geojson         reviewed 0 28 ci 39656104 ,ci39656104, ,ci, ,focal-mechanism,nearby-cities,origin,phase-data,scitech-link, 32 0.01605 0.25 57.0 ml earthquake M 1.4 - 4km ENE of Westmorland, CA 33.0543333 -115.5828333
ci39657760 1.36 3km E of Westmorland, CA 1602236686420 1602267593210   https://earthquake.usgs.gov/earthquakes/eventpage/ci39657760 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39657760.geojson         reviewed 0 28 ci 39657760 ,ci39657760, ,ci, ,focal-mechanism,nearby-cities,origin,phase-data,scitech-link, 33 0.00646 0.28 56.0 ml earthquake M 1.4 - 3km E of Westmorland, CA 33.0351667 -115.5886667
ci39658120 1.35 10km NW of Kernville, CA 1602266694030 1602275862490   https://earthquake.usgs.gov/earthquakes/eventpage/ci39658120 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39658120.geojson         reviewed 0 28 ci 39658120 ,ci39658120, ,ci, ,focal-mechanism,nearby-cities,origin,phase-data,scitech-link, 27 0.08407 0.16 63.0 ml earthquake M 1.4 - 10km NW of Kernville, CA 35.8148333 -118.5158333
ci39659680 1.35 12km SE of Bodfish, CA 1602399876380 1602400100013   https://earthquake.usgs.gov/earthquakes/eventpage/ci39659680 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39659680.geojson         automatic 0 28 ci 39659680 ,ci39659680, ,ci, ,nearby-cities,origin,phase-data,scitech-link, 18 0.1669 0.17 100.0 ml earthquake M 1.4 - 12km SE of Bodfish, CA 35.5043333 -118.4085
ci39659752 1.35 2km N of View Park-Windsor Hills, CA 1602413171220 1602413818440   https://earthquake.usgs.gov/earthquakes/eventpage/ci39659752 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39659752.geojson         automatic 0 28 ci 39659752 ,ci39659752, ,ci, ,focal-mechanism,nearby-cities,origin,phase-data,scitech-link, 30 0.02463 0.21 38.0 ml earthquake M 1.4 - 2km N of View Park-Windsor Hills, CA 34.014 -118.3525
hv72173316 1.35 7 km SW of Volcano, Hawaii 1602269672120 1602274161460   https://earthquake.usgs.gov/earthquakes/eventpage/hv72173316 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72173316.geojson         reviewed 0 28 hv 72173316 ,hv72173316, ,hv, ,origin,phase-data, 16   0.07 50.0 ml earthquake M 1.4 - 7 km SW of Volcano, Hawaii 19.4038333333333 -155.288666666667
mb80467404 1.36 15 km SE of Lincoln, Montana 1602174618330 1602179785500   https://earthquake.usgs.gov/earthquakes/eventpage/mb80467404 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/mb80467404.geojson         reviewed 0 28 mb 80467404 ,mb80467404, ,mb, ,origin,phase-data, 14 0.055 0.1 98.0 ml earthquake M 1.4 - 15 km SE of Lincoln, Montana 46.8626667 -112.5363333
mb80467474 1.34 6 km NNW of Logan, Montana 1602193507110 1602198518340   https://earthquake.usgs.gov/earthquakes/eventpage/mb80467474 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/mb80467474.geojson         reviewed 0 28 mb 80467474 ,mb80467474, ,mb, ,origin,phase-data, 7 0.285 0.12 160.0 ml quarry blast M 1.3 Quarry Blast - 6 km NNW of Logan, Montana 45.93 -111.4706667
nc73467186 1.34 10km NE of Milpitas, CA 1601966562340 1602286084509   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467186 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467186.geojson         reviewed 0 28 nc 73467186 ,nc73467186, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 47 0.04664 0.06 30.0 md earthquake M 1.3 - 10km NE of Milpitas, CA 37.4951667 -121.8246667
nc73468071 1.35 0km NW of The Geysers, CA 1602121889020 1602129184865   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468071 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468071.geojson         automatic 0 28 nc 73468071 ,nc73468071, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 20 0.009756 0.05 64.0 md earthquake M 1.4 - 0km NW of The Geysers, CA 38.7781677 -122.7576675
nc73468401 1.36 4km W of Cobb, CA 1602183170850 1602188584994   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468401 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468401.geojson         automatic 0 28 nc 73468401 ,nc73468401, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 30 0.01108 0.03 56.0 md earthquake M 1.4 - 4km W of Cobb, CA 38.8196678 -122.7666702
nc73469756 1.34 7km WNW of The Geysers, CA 1602467050180 1602472385081   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469756 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469756.geojson         automatic 0 28 nc 73469756 ,nc73469756, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 23 0.005925 0.03 61.0 md earthquake M 1.3 - 7km WNW of The Geysers, CA 38.8096657 -122.8216629
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
nm60311882 1.34 2 km NNE of Marston, Missouri 1602399699940 1602523094510   https://earthquake.usgs.gov/earthquakes/eventpage/nm60311882 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nm60311882.geojson         reviewed 0 28 nm 60311882 ,nm60311882, ,nm, ,origin,phase-data, 20 0.03532 0.04 69.0 md earthquake M 1.3 - 2 km NNE of Marston, Missouri 36.54 -89.5971667
ok2020tsqz 1.36 9 km NNE of Quinlan, Oklahoma 1602079934769 1602193554243   https://earthquake.usgs.gov/earthquakes/eventpage/ok2020tsqz https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ok2020tsqz.geojson         reviewed 0 28 ok 2020tsqz ,ok2020tsqz, ,ok, ,origin,phase-data, 26 0.04859046489 0.08 105.0 ml earthquake M 1.4 - 9 km NNE of Quinlan, Oklahoma 36.5255 -98.9895
uu60413652 1.35 53 km SE of Mammoth, Wyoming 1602282448110 1602284482330   https://earthquake.usgs.gov/earthquakes/eventpage/uu60413652 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60413652.geojson         reviewed 0 28 uu 60413652 ,uu60413652, ,uu, ,origin,phase-data, 8 0.06359 0.11 134.0 md earthquake M 1.4 - 53 km SE of Mammoth, Wyoming 44.5785 -110.313
uw61680347 1.34 16 km S of Crawfordsville, Oregon 1601921765360 1601934954280   https://earthquake.usgs.gov/earthquakes/eventpage/uw61680347 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw61680347.geojson         reviewed 0 28 uw 61680347 ,uw61680347, ,uw, ,origin,phase-data, 7 0.0968 0.21 95.0 ml explosion M 1.3 Explosion - 16 km S of Crawfordsville, Oregon 44.2128333333333 -122.853333333333
uw61680697 1.36 22 km ENE of Ashford, Washington 1602011193450 1602204644460   https://earthquake.usgs.gov/earthquakes/eventpage/uw61680697 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw61680697.geojson         reviewed 0 28 uw 61680697 ,uw61680697, ,uw, ,origin,phase-data, 18 0.02144 0.08 84.0 ml earthquake M 1.4 - 22 km ENE of Ashford, Washington 46.8453333333333 -121.760833333333
uw61691836 1.35 4 km S of Fall City, Washington 1602156880870 1602181539220   https://earthquake.usgs.gov/earthquakes/eventpage/uw61691836 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw61691836.geojson         reviewed 0 28 uw 61691836 ,uw61691836, ,uw, ,origin,phase-data, 9 0.03788 0.14 186.0 ml earthquake M 1.4 - 4 km S of Fall City, Washington 47.5276666666667 -121.8985

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