quakes

23 rows where magType = "md" and nst = 7

View and edit SQL

Suggested facets: mag, place, status, sig, net, sources, types, rms, gap, 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
nc73467076 0.34 5km E of Mammoth Lakes, CA 1601936538590 1601939254016   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467076 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467076.geojson         reviewed 0 2 nc 73467076 ,nc73467076, ,nc, ,nearby-cities,origin,phase-data, 7 0.02214 0.02 107.0 md earthquake M 0.3 - 5km E of Mammoth Lakes, CA 37.6376667 -118.9266667
nc73467406 0.89 8km NW of The Geysers, CA 1602004456660 1602005825335   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467406 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467406.geojson         automatic 0 12 nc 73467406 ,nc73467406, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 7 0.006869 0.02 108.0 md earthquake M 0.9 - 8km NW of The Geysers, CA 38.8176651 -122.8296661
nc73467451 0.57 9km WNW of Cobb, CA 1602011609000 1602011705211   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467451 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467451.geojson         automatic 0 5 nc 73467451 ,nc73467451, ,nc, ,nearby-cities,origin,phase-data, 7 0.01497 0.03 64.0 md earthquake M 0.6 - 9km WNW of Cobb, CA 38.8396683 -122.822998
nc73467456 0.2 5km E of Mammoth Lakes, CA 1602012567250 1602016086638   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467456 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467456.geojson         reviewed 0 1 nc 73467456 ,nc73467456, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 7 0.01832 0.01 99.0 md earthquake M 0.2 - 5km E of Mammoth Lakes, CA 37.6348333 -118.9231667
nc73467546 0.57 2km NNE of The Geysers, CA 1602025957680 1602026054812   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467546 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467546.geojson         automatic 0 5 nc 73467546 ,nc73467546, ,nc, ,nearby-cities,origin,phase-data, 7 0.01322 0.01 172.0 md earthquake M 0.6 - 2km NNE of The Geysers, CA 38.7913322 -122.7476654
nc73468136 -0.29 8km WSW of Mammoth Lakes, CA 1602133442530 1602147146748   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468136 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468136.geojson         reviewed 0 0 nc 73468136 ,nc73468136, ,nc, ,nearby-cities,origin,phase-data, 7 0.01803 0.03 234.0 md earthquake M -0.3 - 8km WSW of Mammoth Lakes, CA 37.616 -119.0695
nc73468296 0.57 6km WNW of The Geysers, CA 1602161675830 1602161769464   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468296 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468296.geojson         automatic 0 5 nc 73468296 ,nc73468296, ,nc, ,nearby-cities,origin,phase-data, 7 0.007201 0.01 173.0 md earthquake M 0.6 - 6km WNW of The Geysers, CA 38.8068352 -122.8203354
nc73468571 0.11 8km NNE of Mineral, CA 1602218429240 1602259265649   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468571 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468571.geojson         reviewed 0 0 nc 73468571 ,nc73468571, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 7 0.04431 0.03 133.0 md earthquake M 0.1 - 8km NNE of Mineral, CA 40.421 -121.5311667
nc73468881 0.56 5km WNW of Cobb, CA 1602281033680 1602281128809   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468881 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468881.geojson         automatic 0 5 nc 73468881 ,nc73468881, ,nc, ,nearby-cities,origin,phase-data, 7 0.00629 0.03 98.0 md earthquake M 0.6 - 5km WNW of Cobb, CA 38.8364983 -122.7826691
nc73468946 1.17 5km WSW of Daly City, CA 1602294767630 1602299404911   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468946 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468946.geojson         automatic 0 21 nc 73468946 ,nc73468946, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 7 0.04754 0.01 206.0 md earthquake M 1.2 - 5km WSW of Daly City, CA 37.6679993 -122.5205002
nc73469206 0.76 2km WNW of Cobb, CA 1602363237960 1602366307009   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469206 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469206.geojson         automatic 0 9 nc 73469206 ,nc73469206, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 7 0.01943 0.04 137.0 md earthquake M 0.8 - 2km WNW of Cobb, CA 38.8284988 -122.745163
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
nc73469611 1.43 13km N of Redwood Valley, CA 1602446723670 1602449346795   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469611 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469611.geojson         automatic 0 31 nc 73469611 ,nc73469611, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 7 0.07577 0.03 201.0 md earthquake M 1.4 - 13km N of Redwood Valley, CA 39.3801651 -123.1865005
nc73469691 0.56 7km NW of The Geysers, CA 1602458145610 1602459484773   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469691 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469691.geojson         automatic 0 5 nc 73469691 ,nc73469691, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 7 0.006763 0.01 148.0 md earthquake M 0.6 - 7km NW of The Geysers, CA 38.8120003 -122.8215027
nm60114228 2.43 6 km E of Maynard, Arkansas 1602017649480 1602083742780   https://earthquake.usgs.gov/earthquakes/eventpage/nm60114228 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nm60114228.geojson         reviewed 0 91 nm 60114228 ,nm60114228, ,nm, ,origin,phase-data, 7 0.4484 0.11 148.0 md earthquake M 2.4 - 6 km E of Maynard, Arkansas 36.4291667 -90.8206667
nm60114433 2.62 6 km ENE of Maynard, Arkansas 1601939884590 1602296250040   https://earthquake.usgs.gov/earthquakes/eventpage/nm60114433 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nm60114433.geojson         reviewed 0 106 nm 60114433 ,us6000c6hw,nm60114433, ,us,nm, ,origin,phase-data, 7 0.4451 0.13 92.0 md earthquake M 2.6 - 6 km ENE of Maynard, Arkansas 36.4306667 -90.8301667
uu60023819 0.23 19 km ENE of West Yellowstone, Montana 1602101256570 1602164400530   https://earthquake.usgs.gov/earthquakes/eventpage/uu60023819 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60023819.geojson         reviewed 0 1 uu 60023819 ,uu60023819, ,uu, ,origin,phase-data, 7 0.05716 0.13 99.0 md earthquake M 0.2 - 19 km ENE of West Yellowstone, Montana 44.7363333 -110.8838333
uu60413187 1.07 37 km S of Silver Gate, Montana 1601951804820 1601990924780   https://earthquake.usgs.gov/earthquakes/eventpage/uu60413187 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60413187.geojson         reviewed 0 18 uu 60413187 ,uu60413187, ,uu, ,origin,phase-data, 7 0.102 0.18 162.0 md earthquake M 1.1 - 37 km S of Silver Gate, Montana 44.6688333 -110.0345
uu60413222 0.54 17 km ENE of Milford, Utah 1601988722640 1601993733320   https://earthquake.usgs.gov/earthquakes/eventpage/uu60413222 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60413222.geojson         reviewed 0 4 uu 60413222 ,uu60413222, ,uu, ,origin,phase-data, 7 0.02785 0.1 148.0 md earthquake M 0.5 - 17 km ENE of Milford, Utah 38.4831667 -112.8401667
uu60413227 0.6 31 km ESE of West Yellowstone, Montana 1601991562570 1601993576870   https://earthquake.usgs.gov/earthquakes/eventpage/uu60413227 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60413227.geojson         reviewed 0 6 uu 60413227 ,uu60413227, ,uu, ,origin,phase-data, 7 0.08073 0.11 138.0 md earthquake M 0.6 - 31 km ESE of West Yellowstone, Montana 44.557 -110.7336667
uu60413302 0.51 17 km ENE of Milford, Utah 1602044102850 1602103498150   https://earthquake.usgs.gov/earthquakes/eventpage/uu60413302 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60413302.geojson         reviewed 0 4 uu 60413302 ,uu60413302, ,uu, ,origin,phase-data, 7 0.01247 0.08 220.0 md earthquake M 0.5 - 17 km ENE of Milford, Utah 38.4816667 -112.8433333
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

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