quakes

21 rows where magType = "md" and nst = 4

View and edit SQL

Suggested facets: mag, place, sig, net, sources, types, rms, gap, type, title, latitude, 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
nc71113294 0.82 12km NNE of Shasta Lake, CA 1602275625290 1602278171627   https://earthquake.usgs.gov/earthquakes/eventpage/nc71113294 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc71113294.geojson         reviewed 0 10 nc 71113294 ,nc71113294, ,nc, ,nearby-cities,origin,phase-data, 4 0.1653 0.42 242.0 md quarry blast M 0.8 Quarry Blast - 12km NNE of Shasta Lake, CA 40.7776667 -122.3108333
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
nc73468411 -0.15 10km SE of Mammoth Lakes, CA 1602185028380 1602187773975   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468411 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468411.geojson         reviewed 0 0 nc 73468411 ,nc73468411, ,nc, ,nearby-cities,origin,phase-data, 4 0.0303 0.04 251.0 md earthquake M -0.2 - 10km SE of Mammoth Lakes, CA 37.5895 -118.8898333
nc73469066 0.6 16km E of Hidden Valley Lake, CA 1602329033830 1602343926609   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469066 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469066.geojson         reviewed 0 6 nc 73469066 ,nc73469066, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 4 0.05621 0.01 245.0 md earthquake M 0.6 - 16km E of Hidden Valley Lake, CA 38.7976667 -122.3765
nc73469871 0.43 11km ESE of Hidden Valley Lake, CA 1602489319430 1602519965291   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469871 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469871.geojson         reviewed 0 3 nc 73469871 ,nc73469871, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 4 0.03639 0.0 155.0 md earthquake M 0.4 - 11km ESE of Hidden Valley Lake, CA 38.7698333 -122.44
pr2020282017 1.61 7 km SSW of La Parguera, Puerto Rico 1602180622830 1602181597600   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020282017 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020282017.geojson         reviewed 0 40 pr 2020282017 ,pr2020282017, ,pr, ,origin,phase-data, 4 0.0632 0.09 309.0 md earthquake M 1.6 - 7 km SSW of La Parguera, Puerto Rico 17.9181 -67.0811
se60311597 -0.61 3 km SE of Sparta, North Carolina 1601966254500 1601989802240   https://earthquake.usgs.gov/earthquakes/eventpage/se60311597 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/se60311597.geojson         reviewed 0 0 se 60311597 ,se60311597, ,se, ,origin,phase-data, 4 0.003882 0.01 141.0 md earthquake M -0.6 - 3 km SE of Sparta, North Carolina 36.4825 -81.0935
se60311627 -0.37 2 km NE of Sparta, North Carolina 1602063945080 1602076346030   https://earthquake.usgs.gov/earthquakes/eventpage/se60311627 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/se60311627.geojson         reviewed 0 0 se 60311627 ,se60311627, ,se, ,origin,phase-data, 4 0.02219 0.03 276.0 md earthquake M -0.4 - 2 km NE of Sparta, North Carolina 36.519 -81.0995
se60311712 -0.61 2 km ESE of Sparta, North Carolina 1602119573410 1602180774770   https://earthquake.usgs.gov/earthquakes/eventpage/se60311712 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/se60311712.geojson         reviewed 0 0 se 60311712 ,se60311712, ,se, ,origin,phase-data, 4 0.01531 0.02 178.0 md earthquake M -0.6 - 2 km ESE of Sparta, North Carolina 36.494 -81.0958333
se60311717 -0.84 2 km ESE of Sparta, North Carolina 1602132456990 1602180169250   https://earthquake.usgs.gov/earthquakes/eventpage/se60311717 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/se60311717.geojson         reviewed 0 0 se 60311717 ,se60311717, ,se, ,origin,phase-data, 4 0.0158 0.02 181.0 md earthquake M -0.8 - 2 km ESE of Sparta, North Carolina 36.4945 -81.0958333
se60311722 -0.61 2 km ESE of Sparta, North Carolina 1602137861530 1602179942610   https://earthquake.usgs.gov/earthquakes/eventpage/se60311722 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/se60311722.geojson         reviewed 0 0 se 60311722 ,se60311722, ,se, ,origin,phase-data, 4 0.01546 0.02 179.0 md earthquake M -0.6 - 2 km ESE of Sparta, North Carolina 36.4941667 -81.0956667
se60311727 -0.61 2 km ESE of Sparta, North Carolina 1602143463890 1602179075480   https://earthquake.usgs.gov/earthquakes/eventpage/se60311727 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/se60311727.geojson         reviewed 0 0 se 60311727 ,se60311727, ,se, ,origin,phase-data, 4 0.01613 0.01 181.0 md earthquake M -0.6 - 2 km ESE of Sparta, North Carolina 36.4948333 -81.0956667
se60311757 -0.61 0 km SE of Sparta, North Carolina 1602182744140 1602247689630   https://earthquake.usgs.gov/earthquakes/eventpage/se60311757 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/se60311757.geojson         reviewed 0 0 se 60311757 ,se60311757, ,se, ,origin,phase-data, 4 0.02522 0.12 222.0 md earthquake M -0.6 - 0 km SE of Sparta, North Carolina 36.499 -81.1131667
se60311762 -0.67 3 km SE of Sparta, North Carolina 1602186031630 1602247385260   https://earthquake.usgs.gov/earthquakes/eventpage/se60311762 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/se60311762.geojson         reviewed 0 0 se 60311762 ,se60311762, ,se, ,origin,phase-data, 4 0.003396 0.05 131.0 md earthquake M -0.7 - 3 km SE of Sparta, North Carolina 36.4803333 -81.0908333
se60311792 -0.61 3 km SE of Sparta, North Carolina 1602229973990 1602247005570   https://earthquake.usgs.gov/earthquakes/eventpage/se60311792 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/se60311792.geojson         reviewed 0 0 se 60311792 ,se60311792, ,se, ,origin,phase-data, 4 0.002226 0.03 142.0 md earthquake M -0.6 - 3 km SE of Sparta, North Carolina 36.4806667 -81.0958333
se60311827 -0.46 3 km SSE of Sparta, North Carolina 1602303742840 1602337864780   https://earthquake.usgs.gov/earthquakes/eventpage/se60311827 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/se60311827.geojson         reviewed 0 0 se 60311827 ,se60311827, ,se, ,origin,phase-data, 4 0.005242 0.02 145.0 md earthquake M -0.5 - 3 km SSE of Sparta, North Carolina 36.4781667 -81.101
se60311832 -0.51 5 km ESE of Sparta, North Carolina 1602333290130 1602337722200   https://earthquake.usgs.gov/earthquakes/eventpage/se60311832 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/se60311832.geojson         reviewed 0 0 se 60311832 ,se60311832, ,se, ,origin,phase-data, 4 0.01737 0.01 197.0 md earthquake M -0.5 - 5 km ESE of Sparta, North Carolina 36.4806667 -81.0693333
uu60023754 -0.63 17 km ENE of Milford, Utah 1601991712430 1602077532100   https://earthquake.usgs.gov/earthquakes/eventpage/uu60023754 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60023754.geojson         reviewed 0 0 uu 60023754 ,uu60023754, ,uu, ,origin,phase-data, 4 0.02527 0.18 216.0 md earthquake M -0.6 - 17 km ENE of Milford, Utah 38.482 -112.8446667
uu60023809 -0.65 19 km ENE of West Yellowstone, Montana 1602101238460 1602164682930   https://earthquake.usgs.gov/earthquakes/eventpage/uu60023809 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60023809.geojson         reviewed 0 0 uu 60023809 ,uu60023809, ,uu, ,origin,phase-data, 4 0.05974 0.12 120.0 md earthquake M -0.7 - 19 km ENE of West Yellowstone, Montana 44.7336667 -110.8843333
uu60413477 -0.76 18 km ENE of West Yellowstone, Montana 1602101232860 1602164747190   https://earthquake.usgs.gov/earthquakes/eventpage/uu60413477 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uu60413477.geojson         reviewed 0 0 uu 60413477 ,uu60413477, ,uu, ,origin,phase-data, 4 0.0576 0.06 120.0 md earthquake M -0.8 - 18 km ENE of West Yellowstone, Montana 44.7383333 -110.8906667
uw61681612 0.65 4 km ENE of Sunnyslope, Washington 1602260643980 1602270488110   https://earthquake.usgs.gov/earthquakes/eventpage/uw61681612 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw61681612.geojson         reviewed 0 6 uw 61681612 ,uw61681612, ,uw, ,origin,phase-data, 4 0.116 0.1 287.0 md explosion M 0.7 Explosion - 4 km ENE of Sunnyslope, Washington 47.493 -120.285666666667

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