quakes

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

View and edit SQL

Suggested facets: mag, place, felt, status, sig, net, sources, types, rms, gap, 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
hv72174361 1.73 3 km SSW of Pāhala, Hawaii 1602312986810 1602314427500   https://earthquake.usgs.gov/earthquakes/eventpage/hv72174361 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72174361.geojson         reviewed 0 46 hv 72174361 ,hv72174361, ,hv, ,origin,phase-data, 9   0.08 226.0 md earthquake M 1.7 - 3 km SSW of Pāhala, Hawaii 19.1795 -155.493666666667
nc73467311 0.56 8km NW of The Geysers, CA 1601982602680 1601985066021   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467311 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467311.geojson         automatic 0 5 nc 73467311 ,nc73467311, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 9 0.0137 0.04 92.0 md earthquake M 0.6 - 8km NW of The Geysers, CA 38.8351669 -122.8184967
nc73467371 1.75 9km N of McCloud, CA 1601998212540 1602009965852   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467371 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467371.geojson         reviewed 0 47 nc 73467371 ,nc73467371, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 9 0.03179 0.12 78.0 md earthquake M 1.8 - 9km N of McCloud, CA 41.3383333 -122.1545
nc73467416 0.9 3km NNE of The Geysers, CA 1602005867600 1602005964629   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467416 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467416.geojson         automatic 0 12 nc 73467416 ,nc73467416, ,nc, ,nearby-cities,origin,phase-data, 9 0.01605 0.01 167.0 md earthquake M 0.9 - 3km NNE of The Geysers, CA 38.7991676 -122.739502
nc73467846 0.4 2km NNE of The Geysers, CA 1602083989690 1602084846057   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467846 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467846.geojson         automatic 0 2 nc 73467846 ,nc73467846, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 9 0.02833 0.02 98.0 md earthquake M 0.4 - 2km NNE of The Geysers, CA 38.7989998 -122.7493362
nc73467876 1.09 16km NW of Parkfield, CA 1602089907340 1602092226889   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467876 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467876.geojson         automatic 0 18 nc 73467876 ,nc73467876, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 9 0.01628 0.03 87.0 md earthquake M 1.1 - 16km NW of Parkfield, CA 36.0 -120.5530014
nc73467916 -0.15 9km E of Mammoth Lakes, CA 1602097638620 1602103330788   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467916 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467916.geojson         reviewed 0 0 nc 73467916 ,nc73467916, ,nc, ,nearby-cities,origin,phase-data, 9 0.01497 0.03 124.0 md earthquake M -0.2 - 9km E of Mammoth Lakes, CA 37.6216667 -118.8815
nc73468056 0.4 3km W of Cobb, CA 1602118748190 1602119645804   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468056 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468056.geojson         automatic 0 2 nc 73468056 ,nc73468056, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 9 0.01292 0.03 123.0 md earthquake M 0.4 - 3km W of Cobb, CA 38.8198318 -122.760498
nc73468346 0.6 2km NNE of The Geysers, CA 1602176858350 1602177726997   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468346 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468346.geojson         automatic 0 6 nc 73468346 ,nc73468346, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 9 0.02888 0.03 95.0 md earthquake M 0.6 - 2km NNE of The Geysers, CA 38.7965012 -122.7490005
nc73468451 0.54 4km WNW of Cobb, CA 1602188266020 1602188363816   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468451 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468451.geojson         automatic 0 4 nc 73468451 ,nc73468451, ,nc, ,nearby-cities,origin,phase-data, 9 0.00869 0.04 132.0 md earthquake M 0.5 - 4km WNW of Cobb, CA 38.8408318 -122.7655029
nc73468481 0.41 2km ESE of The Geysers, CA 1602195523600 1602196746896   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468481 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468481.geojson         automatic 0 3 nc 73468481 ,nc73468481, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 9 0.01163 0.04 66.0 md earthquake M 0.4 - 2km ESE of The Geysers, CA 38.7716675 -122.7350006
nc73468886 0.97 2km SW of Cobb, CA 1602282469330 1602282563821   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468886 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468886.geojson         automatic 0 14 nc 73468886 ,nc73468886, ,nc, ,nearby-cities,origin,phase-data, 9 0.01937 0.02 127.0 md earthquake M 1.0 - 2km SW of Cobb, CA 38.8095016 -122.7376633
nc73469391 0.76 20km NW of Parkfield, CA 1602406840850 1602411727012   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469391 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469391.geojson         automatic 0 9 nc 73469391 ,nc73469391, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 9 0.04413 0.01 199.0 md earthquake M 0.8 - 20km NW of Parkfield, CA 36.0296669 -120.5849991
nc73469411 1.16 12km N of Mineral, CA 1602408675180 1602435904403   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469411 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469411.geojson         reviewed 0 21 nc 73469411 ,nc73469411, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 9 0.02147 0.04 105.0 md earthquake M 1.2 - 12km N of Mineral, CA 40.4648333 -121.5461667
nc73469426 0.74 1km NE of The Geysers, CA 1602411274540 1602412265064   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469426 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469426.geojson         automatic 0 8 nc 73469426 ,nc73469426, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 9 0.009214 0.04 159.0 md earthquake M 0.7 - 1km NE of The Geysers, CA 38.784832 -122.7483368
nc73469491 0.56 8km WNW of Cobb, CA 1602421904090 1602422001951   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469491 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469491.geojson         automatic 0 5 nc 73469491 ,nc73469491, ,nc, ,nearby-cities,origin,phase-data, 9 0.01545 0.01 66.0 md earthquake M 0.6 - 8km WNW of Cobb, CA 38.8388329 -122.8113327
nc73469511 2.14 4km W of Humboldt Hill, CA 1602423981320 1602427147535   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469511 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469511.geojson 1 3.1     automatic 0 71 nc 73469511 ,nc73469511, ,nc, ,dyfi,nearby-cities,origin,phase-data,scitech-link, 9 0.1802 0.13 228.0 md earthquake M 2.1 - 4km W of Humboldt Hill, CA 40.7249985 -124.2333298
nc73469716 0.63 2km NE of The Geysers, CA 1602463028850 1602465066300   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469716 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469716.geojson         automatic 0 6 nc 73469716 ,nc73469716, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 9 0.006861 0.37 127.0 md earthquake M 0.6 - 2km NE of The Geysers, CA 38.7895012 -122.7403336
nc73469746 0.56 5km WNW of Cobb, CA 1602466057750 1602466927506   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469746 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469746.geojson         automatic 0 5 nc 73469746 ,nc73469746, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 9 0.005809 0.02 100.0 md earthquake M 0.6 - 5km WNW of Cobb, CA 38.8376656 -122.7803345
nc73469806 0.89 2km NE of The Geysers, CA 1602472621190 1602474365291   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469806 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469806.geojson         automatic 0 12 nc 73469806 ,nc73469806, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 9 0.009289 0.02 96.0 md earthquake M 0.9 - 2km NE of The Geysers, CA 38.7924995 -122.7378311
nm60114133 2.64 5 km ENE of Maynard, Arkansas 1601993491660 1602053557488   https://earthquake.usgs.gov/earthquakes/eventpage/nm60114133 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nm60114133.geojson 1 2     reviewed 0 107 nm 60114133 ,nm60114133,us6000c65y, ,nm,us, ,dyfi,origin,phase-data, 9 0.4443 0.38 82.0 md earthquake M 2.6 - 5 km ENE of Maynard, Arkansas 36.4313333 -90.8328333
nm60114223 2.6 6 km E of Maynard, Arkansas 1602028339990 1602110619040   https://earthquake.usgs.gov/earthquakes/eventpage/nm60114223 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nm60114223.geojson         reviewed 0 104 nm 60114223 ,us6000c6ev,nm60114223, ,us,nm, ,origin,phase-data, 9 0.4463 0.12 127.0 md earthquake M 2.6 - 6 km E of Maynard, Arkansas 36.4298333 -90.8261667
nm60114723 2.56 6 km E of Maynard, Arkansas 1602180712820 1602261747978   https://earthquake.usgs.gov/earthquakes/eventpage/nm60114723 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nm60114723.geojson 2 3.4     reviewed 0 102 nm 60114723 ,nm60114723, ,nm, ,dyfi,origin,phase-data, 9 0.4442 0.16 144.0 md earthquake M 2.6 - 6 km E of Maynard, Arkansas 36.4261667 -90.8245
pr2020280007 2.37 3 km WSW of Fuig, Puerto Rico 1601989618240 1601990657884   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020280007 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020280007.geojson         reviewed 0 86 pr 2020280007 ,pr2020280007, ,pr, ,origin,phase-data, 9 0.0634 0.08 174.0 md earthquake M 2.4 - 3 km WSW of Fuig, Puerto Rico 17.9773 -66.9426
pr2020281014 2.54 7 km S of Indios, Puerto Rico 1602082863850 1602096518776   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020281014 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020281014.geojson 1 2.7     reviewed 0 100 pr 2020281014 ,pr2020281014, ,pr, ,dyfi,origin,phase-data, 9 0.0733 0.2 225.0 md earthquake M 2.5 - 7 km S of Indios, Puerto Rico 17.9271 -66.8238
uu60023784 0.8 3 km SE of Beaver, Utah 1602054804390 1602091935720   https://earthquake.usgs.gov/earthquakes/eventpage/uu60023784 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60023784.geojson         reviewed 0 10 uu 60023784 ,uu60023784, ,uu, ,origin,phase-data, 9 0.03377 0.11 114.0 md earthquake M 0.8 - 3 km SE of Beaver, Utah 38.2575 -112.6051667
uu60023864 1.89 10 km W of Diamondville, Wyoming 1602257304800 1602275153270   https://earthquake.usgs.gov/earthquakes/eventpage/uu60023864 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60023864.geojson         reviewed 0 55 uu 60023864 ,uu60023864, ,uu, ,origin,phase-data, 9 0.3637 0.12 141.0 md quarry blast M 1.9 Quarry Blast - 10 km W of Diamondville, Wyoming 41.7696667 -110.6666667
uu60413252 0.14 9 km E of Hebgen Lake Estates, Montana 1602005896690 1602014470860   https://earthquake.usgs.gov/earthquakes/eventpage/uu60413252 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60413252.geojson         reviewed 0 0 uu 60413252 ,uu60413252, ,uu, ,origin,phase-data, 9 0.04463 0.12 129.0 md earthquake M 0.1 - 9 km E of Hebgen Lake Estates, Montana 44.7721667 -111.0661667
uu60413347 0.58 4 km ENE of Magna, Utah 1602049379790 1602092215220   https://earthquake.usgs.gov/earthquakes/eventpage/uu60413347 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60413347.geojson         reviewed 0 5 uu 60413347 ,uu60413347, ,uu, ,origin,phase-data, 9 0.01596 0.09 115.0 md earthquake M 0.6 - 4 km ENE of Magna, Utah 40.7258333 -112.0568333
uu60413387 0.82 9 km W of Veyo, Utah 1602066623340 1602106831390   https://earthquake.usgs.gov/earthquakes/eventpage/uu60413387 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60413387.geojson         reviewed 0 10 uu 60413387 ,uu60413387, ,uu, ,origin,phase-data, 9 0.1347 0.14 84.0 md earthquake M 0.8 - 9 km W of Veyo, Utah 37.3358333 -113.7963333
uu60413447 0.97 13 km NW of Howell, Utah 1602091114190 1602097882530   https://earthquake.usgs.gov/earthquakes/eventpage/uu60413447 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60413447.geojson         reviewed 0 14 uu 60413447 ,uu60413447, ,uu, ,origin,phase-data, 9 0.1823 0.08 128.0 md earthquake M 1.0 - 13 km NW of Howell, Utah 41.8758333 -112.5676667
uw61680752 1.6 7 km NW of Philomath, Oregon 1602015674180 1602020306220   https://earthquake.usgs.gov/earthquakes/eventpage/uw61680752 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw61680752.geojson         reviewed 0 39 uw 61680752 ,uw61680752, ,uw, ,origin,phase-data, 9 0.08447 0.22 96.0 md explosion M 1.6 Explosion - 7 km NW of Philomath, Oregon 44.5898333333333 -123.422666666667

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