quakes

23 rows where sig = 13

View and edit SQL

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

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
ci37457469 0.92 4km SSE of Westmorland, CA 1602117544180 1602167943620   https://earthquake.usgs.gov/earthquakes/eventpage/ci37457469 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci37457469.geojson         reviewed 0 13 ci 37457469 ,ci37457469, ,ci, ,nearby-cities,origin,phase-data,scitech-link, 7 0.03928 0.3 112.0 ml earthquake M 0.9 - 4km SSE of Westmorland, CA 33.0043333 -115.6056667
ci39653568 0.93 8km ESE of Ridgecrest, CA 1601933954260 1601934173920   https://earthquake.usgs.gov/earthquakes/eventpage/ci39653568 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39653568.geojson         automatic 0 13 ci 39653568 ,ci39653568, ,ci, ,nearby-cities,origin,phase-data,scitech-link, 14 0.101 0.17 99.0 ml earthquake M 0.9 - 8km ESE of Ridgecrest, CA 35.6003333 -117.585
ci39654496 0.91 13km SSW of Searles Valley, CA 1602009489220 1602027587392   https://earthquake.usgs.gov/earthquakes/eventpage/ci39654496 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39654496.geojson         reviewed 0 13 ci 39654496 ,ci39654496, ,ci, ,nearby-cities,origin,phase-data,scitech-link, 14 0.08193 0.16 167.0 ml earthquake M 0.9 - 13km SSW of Searles Valley, CA 35.6681667 -117.4726667
ci39655192 0.92 24km SW of Ocotillo Wells, CA 1602074631940 1602074844239   https://earthquake.usgs.gov/earthquakes/eventpage/ci39655192 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39655192.geojson         automatic 0 13 ci 39655192 ,ci39655192, ,ci, ,nearby-cities,origin,phase-data,scitech-link, 24 0.03162 0.18 89.0 ml earthquake M 0.9 - 24km SW of Ocotillo Wells, CA 32.9861667 -116.2998333
ci39657664 0.92 5km W of Ojai, CA 1602225032330 1602266791989   https://earthquake.usgs.gov/earthquakes/eventpage/ci39657664 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39657664.geojson         reviewed 0 13 ci 39657664 ,ci39657664, ,ci, ,nearby-cities,origin,phase-data,scitech-link, 11 0.04908 0.21 78.0 ml earthquake M 0.9 - 5km W of Ojai, CA 34.4461667 -119.2998333
ci39658224 0.92 14km W of Searles Valley, CA 1602271114800 1602273576265   https://earthquake.usgs.gov/earthquakes/eventpage/ci39658224 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39658224.geojson         reviewed 0 13 ci 39658224 ,ci39658224, ,ci, ,nearby-cities,origin,phase-data,scitech-link, 19 0.0505 0.11 84.0 ml earthquake M 0.9 - 14km W of Searles Valley, CA 35.7801667 -117.5533333
ci39658288 0.93 11km WNW of Lake Elsinore, CA 1602274156770 1602277616684   https://earthquake.usgs.gov/earthquakes/eventpage/ci39658288 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39658288.geojson         reviewed 0 13 ci 39658288 ,ci39658288, ,ci, ,nearby-cities,origin,phase-data,scitech-link, 28 0.05212 0.16 52.0 ml earthquake M 0.9 - 11km WNW of Lake Elsinore, CA 33.7106667 -117.4393333
ci39659736 0.91 20km ESE of Little Lake, CA 1602409021690 1602512573696   https://earthquake.usgs.gov/earthquakes/eventpage/ci39659736 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39659736.geojson         reviewed 0 13 ci 39659736 ,ci39659736, ,ci, ,nearby-cities,origin,phase-data,scitech-link, 15 0.06771 0.06 78.0 ml earthquake M 0.9 - 20km ESE of Little Lake, CA 35.8878333 -117.6891667
ci39660128 0.91 11km ENE of Coso Junction, CA 1602453143180 1602474626394   https://earthquake.usgs.gov/earthquakes/eventpage/ci39660128 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ci39660128.geojson         reviewed 0 13 ci 39660128 ,ci39660128, ,ci, ,nearby-cities,origin,phase-data,scitech-link, 22 0.04983 0.12 52.0 ml earthquake M 0.9 - 11km ENE of Coso Junction, CA 36.0713333 -117.8316667
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
nc73467951 0.91 9km SE of Hidden Valley Lake, CA 1602100638670 1602106748428   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467951 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467951.geojson         reviewed 0 13 nc 73467951 ,nc73467951, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 4 0.07589 0.02 206.0 md earthquake M 0.9 - 9km SE of Hidden Valley Lake, CA 38.7411667 -122.4988333
nc73468731 0.91 16km E of Seven Trees, CA 1602254082230 1602267918459   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468731 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468731.geojson         reviewed 0 13 nc 73468731 ,nc73468731, ,nc, ,nearby-cities,origin,phase-data, 22 0.05688 0.06 54.0 md earthquake M 0.9 - 16km E of Seven Trees, CA 37.287 -121.6628333
nc73468736 0.93 3km NNW of The Geysers, CA 1602257065640 1602261246870   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468736 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468736.geojson         automatic 0 13 nc 73468736 ,nc73468736, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 15 0.01356 0.04 74.0 md earthquake M 0.9 - 3km NNW of The Geysers, CA 38.8003349 -122.7731705
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
nc73469421 0.93 11km E of Navarro Head, CA 1602410714080 1602431431081   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469421 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469421.geojson         reviewed 0 13 nc 73469421 ,nc73469421, ,nc, ,nearby-cities,origin,phase-data, 7 0.009655 0.04 240.0 md earthquake M 0.9 - 11km E of Navarro Head, CA 39.2093333 -123.6408333
nc73469516 0.91 3km ESE of The Geysers, CA 1602424473250 1602425348376   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469516 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469516.geojson         automatic 0 13 nc 73469516 ,nc73469516, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 7 0.005866 0.01 106.0 md earthquake M 0.9 - 3km ESE of The Geysers, CA 38.7643318 -122.7314987
nn00777361 0.9 30 km SSE of Mina, Nevada 1601978668173 1601999065856   https://earthquake.usgs.gov/earthquakes/eventpage/nn00777361 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nn00777361.geojson 1 2.2     reviewed 0 13 nn 00777361 ,nn00777361, ,nn, ,dyfi,origin,phase-data, 17 0.022 0.0712 101.96 ml earthquake M 0.9 - 30 km SSE of Mina, Nevada 38.1517 -117.9363
ok2020ttyn 0.93 4 km S of Avard, Oklahoma 1602140983409 1602272988097   https://earthquake.usgs.gov/earthquakes/eventpage/ok2020ttyn https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ok2020ttyn.geojson         reviewed 0 13 ok 2020ttyn ,ok2020ttyn, ,ok, ,origin,phase-data, 23 0.112477928 0.12 119.0 ml earthquake M 0.9 - 4 km S of Avard, Oklahoma 36.65633333 -98.795
ok2020tucv 0.92 8 km NW of Perry, Oklahoma 1602148800520 1602263399805   https://earthquake.usgs.gov/earthquakes/eventpage/ok2020tucv https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ok2020tucv.geojson         reviewed 0 13 ok 2020tucv ,ok2020tucv, ,ok, ,origin,phase-data, 35 0.1277749262 0.26 96.0 ml earthquake M 0.9 - 8 km NW of Perry, Oklahoma 36.3495 -97.34866667
ok2020tudi 0.93 10 km NW of Perry, Oklahoma 1602149705610 1602274452079   https://earthquake.usgs.gov/earthquakes/eventpage/ok2020tudi https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ok2020tudi.geojson         reviewed 0 13 ok 2020tudi ,ok2020tudi, ,ok, ,origin,phase-data, 38 0.1034796938 0.31 98.0 ml earthquake M 0.9 - 10 km NW of Perry, Oklahoma 36.35666667 -97.36533333
ok2020tvzm 0.91 17 km SE of Waynoka, Oklahoma 1602237262309 1602262455711   https://earthquake.usgs.gov/earthquakes/eventpage/ok2020tvzm https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/ok2020tvzm.geojson         reviewed 0 13 ok 2020tvzm ,ok2020tvzm, ,ok, ,origin,phase-data, 24 0.01349735136 0.1 132.0 ml earthquake M 0.9 - 17 km SE of Waynoka, Oklahoma 36.483 -98.727
uu60413992 0.91 21 km SW of Kanosh, Utah 1602509322130 1602514425280   https://earthquake.usgs.gov/earthquakes/eventpage/uu60413992 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60413992.geojson         reviewed 0 13 uu 60413992 ,uu60413992, ,uu, ,origin,phase-data, 7 0.106 0.14 143.0 md earthquake M 0.9 - 21 km SW of Kanosh, Utah 38.6433333 -112.5755
uw61691756 0.92 2 km NNE of Woods Creek, Washington 1602112643880 1602194014680   https://earthquake.usgs.gov/earthquakes/eventpage/uw61691756 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw61691756.geojson         reviewed 0 13 uw 61691756 ,uw61691756, ,uw, ,origin,phase-data, 6 0.0009522 0.24 202.0 ml explosion M 0.9 Explosion - 2 km NNE of Woods Creek, Washington 47.8976666666667 -121.891166666667

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