quakes

27 rows where magType = "md" and nst = 15

View and edit SQL

Suggested facets: mag, place, status, sig, net, sources, types, rms, gap, title, longitude

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
nc73467126 0.83 7km NW of The Geysers, CA 1601947066090 1601947925066   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467126 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467126.geojson         automatic 0 11 nc 73467126 ,nc73467126, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 15 0.0182 0.03 56.0 md earthquake M 0.8 - 7km NW of The Geysers, CA 38.8235016 -122.8075027
nc73467476 1.26 10km ESE of Willits, CA 1602016168670 1602310273488   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467476 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467476.geojson         reviewed 0 24 nc 73467476 ,nc73467476, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 15 0.07465 0.07 111.0 md earthquake M 1.3 - 10km ESE of Willits, CA 39.3676667 -123.2495
nc73467526 0.57 7km WNW of The Geysers, CA 1602022790640 1602022889035   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467526 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467526.geojson         automatic 0 5 nc 73467526 ,nc73467526, ,nc, ,nearby-cities,origin,phase-data, 15 0.002264 0.02 62.0 md earthquake M 0.6 - 7km WNW of The Geysers, CA 38.8100014 -122.8266678
nc73467711 1.08 8km WNW of Cobb, CA 1602059075980 1602062165684   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467711 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467711.geojson         automatic 0 18 nc 73467711 ,nc73467711, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 15 0.01419 0.02 53.0 md earthquake M 1.1 - 8km WNW of Cobb, CA 38.8356667 -122.8081665
nc73467871 0.4 5km E of Mammoth Lakes, CA 1602088964870 1602092242973   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467871 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467871.geojson         reviewed 0 2 nc 73467871 ,nc73467871, ,nc, ,nearby-cities,origin,phase-data, 15 0.01921 0.04 49.0 md earthquake M 0.4 - 5km E of Mammoth Lakes, CA 37.6388333 -118.921
nc73467891 1.26 10km ESE of Willits, CA 1602091960900 1602316204755   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467891 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467891.geojson         reviewed 0 24 nc 73467891 ,nc73467891, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 15 0.0713 0.05 109.0 md earthquake M 1.3 - 10km ESE of Willits, CA 39.3663333 -123.2568333
nc73468196 1.11 10km ESE of Willits, CA 1602143844320 1602164225713   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468196 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468196.geojson         reviewed 0 19 nc 73468196 ,nc73468196, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 15 0.06991 0.05 108.0 md earthquake M 1.1 - 10km ESE of Willits, CA 39.3641667 -123.2598333
nc73468206 1.0 3km ENE of The Geysers, CA 1602145237110 1602147005783   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468206 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468206.geojson         automatic 0 15 nc 73468206 ,nc73468206, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 15 0.008134 0.05 119.0 md earthquake M 1.0 - 3km ENE of The Geysers, CA 38.7896652 -122.7303314
nc73468276 0.82 6km NNW of The Geysers, CA 1602161257890 1602162125495   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468276 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468276.geojson         automatic 0 10 nc 73468276 ,nc73468276, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 15 0.01478 0.01 47.0 md earthquake M 0.8 - 6km NNW of The Geysers, CA 38.8241653 -122.7955017
nc73468521 0.41 5km ESE of Mammoth Lakes, CA 1602206205240 1602259747703   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468521 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468521.geojson         reviewed 0 3 nc 73468521 ,nc73468521, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 15 0.01511 0.13 95.0 md earthquake M 0.4 - 5km ESE of Mammoth Lakes, CA 37.6208333 -118.9308333
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
nc73468761 1.82 16km S of Tres Pinos, CA 1602261145140 1602270549803   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468761 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468761.geojson         automatic 0 51 nc 73468761 ,nc73468761, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 15 0.04464 0.2 68.0 md earthquake M 1.8 - 16km S of Tres Pinos, CA 36.6489983 -121.2856674
nc73468836 0.68 5km E of Mammoth Lakes, CA 1602276013630 1602279284369   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468836 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468836.geojson         reviewed 0 7 nc 73468836 ,nc73468836, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 15 0.0162 0.04 63.0 md earthquake M 0.7 - 5km E of Mammoth Lakes, CA 37.6376667 -118.9171667
nc73468841 0.56 5km E of Mammoth Lakes, CA 1602276041740 1602281466035   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468841 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468841.geojson         reviewed 0 5 nc 73468841 ,nc73468841, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 15 0.01668 0.05 59.0 md earthquake M 0.6 - 5km E of Mammoth Lakes, CA 37.6401667 -118.9171667
nc73468851 0.37 5km E of Mammoth Lakes, CA 1602276075240 1602282726163   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468851 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468851.geojson         reviewed 0 2 nc 73468851 ,nc73468851, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 15 0.0163 0.05 59.0 md earthquake M 0.4 - 5km E of Mammoth Lakes, CA 37.6421667 -118.9186667
nc73468866 0.53 6km E of Mammoth Lakes, CA 1602277272700 1602282260787   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468866 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468866.geojson         reviewed 0 4 nc 73468866 ,nc73468866, ,nc, ,nearby-cities,origin,phase-data, 15 0.01617 0.05 62.0 md earthquake M 0.5 - 6km E of Mammoth Lakes, CA 37.638 -118.9166667
nc73469291 2.54 64km WNW of Petrolia, CA 1602385839450 1602389047468   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469291 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469291.geojson         automatic 0 99 nc 73469291 ,nc73469291, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 15 0.5432 0.59 285.0 md earthquake M 2.5 - 64km WNW of Petrolia, CA 40.4404984 -125.0251694
nc73469541 0.56 8km WNW of Cobb, CA 1602429950500 1602430048441   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469541 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469541.geojson         automatic 0 5 nc 73469541 ,nc73469541, ,nc, ,nearby-cities,origin,phase-data, 15 0.01261 0.01 57.0 md earthquake M 0.6 - 8km WNW of Cobb, CA 38.8359985 -122.810997
nm60311927 1.33 5 km SW of Tiptonville, Tennessee 1602502400900 1602509277710   https://earthquake.usgs.gov/earthquakes/eventpage/nm60311927 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nm60311927.geojson         reviewed 0 27 nm 60311927 ,nm60311927, ,nm, ,origin,phase-data, 15 0.01536 0.04 75.0 md earthquake M 1.3 - 5 km SW of Tiptonville, Tennessee 36.345 -89.5166667
pr2020280003 2.34 3 km N of La Parguera, Puerto Rico 1601949920870 1601951862929   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020280003 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020280003.geojson         reviewed 0 84 pr 2020280003 ,pr2020280003, ,pr, ,origin,phase-data, 15 0.0415 0.08 99.0 md earthquake M 2.3 - 3 km N of La Parguera, Puerto Rico 18.01 -67.0531
pr2020282011 2.49 0 km E of Magas Arriba, Puerto Rico 1602172446490 1602173686179   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020282011 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020282011.geojson         reviewed 0 95 pr 2020282011 ,pr2020282011, ,pr, ,origin,phase-data, 15 0.1252 0.27 155.0 md earthquake M 2.5 - 0 km E of Magas Arriba, Puerto Rico 18.0186 -66.7618
pr2020282012 2.39 6 km S of Guánica, Puerto Rico 1602173479660 1602174661283   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020282012 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020282012.geojson         reviewed 0 88 pr 2020282012 ,pr2020282012, ,pr, ,origin,phase-data, 15 0.0636 0.13 210.0 md earthquake M 2.4 - 6 km S of Guánica, Puerto Rico 17.914 -66.897
pr2020284005 2.07 1 km WNW of Guayanilla, Puerto Rico 1602315984880 1602317139806   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020284005 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020284005.geojson         reviewed 0 66 pr 2020284005 ,pr2020284005, ,pr, ,origin,phase-data, 15 0.0911 0.17 123.0 md earthquake M 2.1 - 1 km WNW of Guayanilla, Puerto Rico 18.0263 -66.8038
pr2020285005 3.11 7 km N of Arecibo, Puerto Rico 1602385592310 1602412655111   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020285005 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020285005.geojson 1 2     reviewed 0 149 pr 2020285005 ,pr2020285005, ,pr, ,dyfi,origin,phase-data, 15 0.1948 0.22 208.0 md earthquake M 3.1 - 7 km N of Arecibo, Puerto Rico 18.5393 -66.7253
pr2020285011 2.43 6 km SSW of La Parguera, Puerto Rico 1602404040650 1602407217716   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020285011 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020285011.geojson         reviewed 0 91 pr 2020285011 ,pr2020285011, ,pr, ,origin,phase-data, 15 0.053 0.12 246.0 md earthquake M 2.4 - 6 km SSW of La Parguera, Puerto Rico 17.9275 -67.0766
pr2020285019 2.94 2 km S of La Parguera, Puerto Rico 1602439655890 1602440936749   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020285019 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020285019.geojson         reviewed 0 133 pr 2020285019 ,pr2020285019, ,pr, ,origin,phase-data, 15 0.018 0.11 236.0 md earthquake M 2.9 - 2 km S of La Parguera, Puerto Rico 17.9515 -67.0461
uu60413717 1.39 13 km WSW of Georgetown, Idaho 1602316418110 1602521979490   https://earthquake.usgs.gov/earthquakes/eventpage/uu60413717 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60413717.geojson         reviewed 0 30 uu 60413717 ,uu60413717, ,uu, ,origin,phase-data, 15 0.3733 0.2 118.0 md earthquake M 1.4 - 13 km WSW of Georgetown, Idaho 42.4351667 -111.5195

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