quakes

30 rows where magType = "md" and nst = 22

View and edit SQL

Suggested facets: mag, place, felt, cdi, status, sig, net, sources, types, dmin, rms, gap, latitude

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
nc73467556 0.6 8km NW of The Geysers, CA 1602028560580 1602030246222   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467556 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467556.geojson         automatic 0 6 nc 73467556 ,nc73467556, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 22 0.01603 0.03 47.0 md earthquake M 0.6 - 8km NW of The Geysers, CA 38.833168 -122.8161697
nc73468146 1.86 8km N of Lake Pillsbury, CA 1602134670520 1602154626636   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468146 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468146.geojson         reviewed 0 53 nc 73468146 ,nc73468146, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 22 0.1983 0.1 71.0 md earthquake M 1.9 - 8km N of Lake Pillsbury, CA 39.4835 -122.9488333
nc73468226 1.1 4km NNW of Pinnacles, CA 1602148350670 1602161827462   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468226 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468226.geojson         reviewed 0 19 nc 73468226 ,nc73468226, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 22 0.02272 0.12 122.0 md earthquake M 1.1 - 4km NNW of Pinnacles, CA 36.5693333 -121.1573333
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
nc73468981 0.79 8km W of Cobb, CA 1602310809350 1602310904803   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468981 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468981.geojson         automatic 0 10 nc 73468981 ,nc73468981, ,nc, ,nearby-cities,origin,phase-data, 22 0.01042 0.03 42.0 md earthquake M 0.8 - 8km W of Cobb, CA 38.8338318 -122.8103333
nc73469221 0.85 7km NW of The Geysers, CA 1602368194110 1602369965413   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469221 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469221.geojson         automatic 0 11 nc 73469221 ,nc73469221, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 22 0.002085 0.02 37.0 md earthquake M 0.9 - 7km NW of The Geysers, CA 38.8224983 -122.807663
nc73469481 1.28 8km WNW of Cobb, CA 1602421843640 1602426246453   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469481 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469481.geojson         automatic 0 25 nc 73469481 ,nc73469481, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 22 0.01357 0.03 58.0 md earthquake M 1.3 - 8km WNW of Cobb, CA 38.836834 -122.8126678
nc73469811 0.86 13km ESE of Mammoth Lakes, CA 1602472669200 1602523144574   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469811 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469811.geojson         reviewed 0 11 nc 73469811 ,nc73469811, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 22 0.01981 0.06 130.0 md earthquake M 0.9 - 13km ESE of Mammoth Lakes, CA 37.6098333 -118.8306667
pr2020279015 2.75 1 km NNW of Guayanilla, Puerto Rico 1601926111500 1601927245800   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020279015 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020279015.geojson         reviewed 0 116 pr 2020279015 ,pr2020279015, ,pr, ,origin,phase-data, 22 0.097 0.13 110.0 md earthquake M 2.8 - 1 km NNW of Guayanilla, Puerto Rico 18.0326 -66.8011
pr2020279016 3.07 4 km SSW of La Parguera, Puerto Rico 1601935289540 1602194356040   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020279016 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020279016.geojson         reviewed 0 145 pr 2020279016 ,us6000c5x7,pr2020279016, ,us,pr, ,origin,phase-data, 22 0.0387 0.09 237.0 md earthquake M 3.1 - 4 km SSW of La Parguera, Puerto Rico 17.9355 -67.0628
pr2020280000 2.86 7 km WSW of Fuig, Puerto Rico 1601944171810 1601945233580   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020280000 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020280000.geojson         reviewed 0 126 pr 2020280000 ,pr2020280000, ,pr, ,origin,phase-data, 22 0.0691 0.12 202.0 md earthquake M 2.9 - 7 km WSW of Fuig, Puerto Rico 17.9516 -66.9775
pr2020280001 3.17 0 km E of Guayanilla, Puerto Rico 1601947510400 1601950980002   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020280001 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020280001.geojson 2 2     reviewed 0 155 pr 2020280001 ,pr2020280001,us6000c5yk, ,pr,us, ,dyfi,origin,phase-data, 22 0.1027 0.14 135.0 md earthquake M 3.2 - 0 km E of Guayanilla, Puerto Rico 18.0185 -66.7861
pr2020280002 2.88 1 km SE of Guayanilla, Puerto Rico 1601947806030 1601949656327   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020280002 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020280002.geojson         reviewed 0 128 pr 2020280002 ,pr2020280002, ,pr, ,origin,phase-data, 22 0.1016 0.13 145.0 md earthquake M 2.9 - 1 km SE of Guayanilla, Puerto Rico 18.0086 -66.7833
pr2020280010 2.86 3 km SW of Guánica, Puerto Rico 1602007353000 1602008693872   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020280010 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020280010.geojson         reviewed 0 126 pr 2020280010 ,pr2020280010, ,pr, ,origin,phase-data, 22 0.0605 0.12 202.0 md earthquake M 2.9 - 3 km SW of Guánica, Puerto Rico 17.9438 -66.931
pr2020280011 3.18 3 km SSW of Indios, Puerto Rico 1602010241540 1602039188515   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020280011 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020280011.geojson         reviewed 0 156 pr 2020280011 ,pr2020280011,us6000c675, ,pr,us, ,origin,phase-data, 22 0.0433 0.25 183.0 md earthquake M 3.2 - 3 km SSW of Indios, Puerto Rico 17.9635 -66.8375
pr2020280012 3.3 9 km SSE of Indios, Puerto Rico 1602011133630 1602026661376   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020280012 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020280012.geojson 3 4.8     reviewed 0 169 pr 2020280012 ,pr2020280012,us6000c676, ,pr,us, ,dyfi,origin,phase-data, 22 0.1154 0.2 195.0 md earthquake M 3.3 - 9 km SSE of Indios, Puerto Rico 17.9228 -66.7763
pr2020280015 3.32 5 km SSE of Guánica, Puerto Rico 1602026327180 1602194707040   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020280015 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020280015.geojson 12 4.8     reviewed 0 175 pr 2020280015 ,us6000c68j,pr2020280015, ,us,pr, ,dyfi,origin,phase-data, 22 0.0505 0.16 211.0 md earthquake M 3.3 - 5 km SSE of Guánica, Puerto Rico 17.9261 -66.8913
pr2020280017 2.86 6 km SSE of Guánica, Puerto Rico 1602026825260 1602194811040   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020280017 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020280017.geojson 1 2     reviewed 0 126 pr 2020280017 ,us6000c68l,pr2020280017, ,us,pr, ,dyfi,origin,phase-data, 22 0.0589 0.14 208.0 md earthquake M 2.9 - 6 km SSE of Guánica, Puerto Rico 17.9163 -66.8826
pr2020281004 3.05 5 km SSW of La Parguera, Puerto Rico 1602039184960 1602068133220   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020281004 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020281004.geojson 4 3.1     reviewed 0 144 pr 2020281004 ,us6000c6a0,pr2020281004, ,us,pr, ,dyfi,origin,phase-data, 22 0.048 0.11 238.0 md earthquake M 3.1 - 5 km SSW of La Parguera, Puerto Rico 17.9323 -67.0746
pr2020281007 2.62 Puerto Rico region 1602056317750 1602135851040   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020281007 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020281007.geojson         reviewed 0 106 pr 2020281007 ,us6000c6cz,pr2020281007, ,us,pr, ,origin,phase-data, 22 0.1132 0.1 199.0 md earthquake M 2.6 - Puerto Rico region 17.955 -66.7678
pr2020281017 3.93 57 km E of Cruz Bay, U.S. Virgin Islands 1602095852750 1602114105602   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020281017 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020281017.geojson 39 4.9     reviewed 0 257 pr 2020281017 ,us6000c6iq,pr2020281017, ,us,pr, ,dyfi,origin,phase-data, 22 1.6087 0.56 207.0 md earthquake M 3.9 - 57 km E of Cruz Bay, U.S. Virgin Islands 18.3316 -64.2513
pr2020282007 3.9 52 km NE of Saint Croix, U.S. Virgin Islands 1602147986000 1602152021274   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020282007 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020282007.geojson 2 2.7     reviewed 0 235 pr 2020282007 ,us6000c6nk,pr2020282007, ,us,pr, ,dyfi,origin,phase-data, 22 1.5138 0.89 193.0 md earthquake M 3.9 - 52 km NE of Saint Croix, U.S. Virgin Islands 17.9956 -64.3421
pr2020282020 2.67 14 km SSE of Guánica, Puerto Rico 1602195491240 1602374398040   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020282020 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020282020.geojson         reviewed 0 110 pr 2020282020 ,us6000c6vt,pr2020282020, ,us,pr, ,origin,phase-data, 22 0.1254 0.14 235.0 md earthquake M 2.7 - 14 km SSE of Guánica, Puerto Rico 17.8513 -66.8595
pr2020282023 2.96 Puerto Rico region 1602200182480 1602202170040   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020282023 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020282023.geojson         reviewed 0 135 pr 2020282023 ,us6000c6wi,pr2020282023, ,us,pr, ,origin,phase-data, 22 0.0593 0.21 204.0 md earthquake M 3.0 - Puerto Rico region 17.9223 -66.9063
pr2020283001 2.35 5 km S of Guánica, Puerto Rico 1602214359570 1602216828448   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020283001 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020283001.geojson         reviewed 0 85 pr 2020283001 ,pr2020283001, ,pr, ,origin,phase-data, 22 0.0609 0.17 213.0 md earthquake M 2.4 - 5 km S of Guánica, Puerto Rico 17.9261 -66.9153
pr2020283004 2.69 4 km SSW of Guánica, Puerto Rico 1602228208750 1602229885313   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020283004 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020283004.geojson         reviewed 0 111 pr 2020283004 ,pr2020283004, ,pr, ,origin,phase-data, 22 0.0599 0.15 210.0 md earthquake M 2.7 - 4 km SSW of Guánica, Puerto Rico 17.931 -66.9198
pr2020283006 2.72 4 km S of Guánica, Puerto Rico 1602230149590 1602304962040   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020283006 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020283006.geojson         reviewed 0 114 pr 2020283006 ,us6000c6zv,pr2020283006, ,us,pr, ,origin,phase-data, 22 0.0525 0.25 199.0 md earthquake M 2.7 - 4 km S of Guánica, Puerto Rico 17.9333 -66.911
pr2020284003 2.8 7 km ESE of La Parguera, Puerto Rico 1602300056650 1602303784964   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020284003 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020284003.geojson         reviewed 0 121 pr 2020284003 ,pr2020284003, ,pr, ,origin,phase-data, 22 0.0691 0.09 204.0 md earthquake M 2.8 - 7 km ESE of La Parguera, Puerto Rico 17.9495 -66.9781
pr2020285001 2.87 5 km SSW of La Parguera, Puerto Rico 1602381587580 1602383718171   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020285001 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020285001.geojson 1 2.2     reviewed 0 127 pr 2020285001 ,us6000c7fc,pr2020285001, ,us,pr, ,dyfi,origin,phase-data, 22 0.0422 0.11 237.0 md earthquake M 2.9 - 5 km SSW of La Parguera, Puerto Rico 17.933 -67.0655
pr2020285004 2.71 1 km SW of Indios, Puerto Rico 1602384900060 1602387654309   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020285004 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020285004.geojson         reviewed 0 113 pr 2020285004 ,pr2020285004, ,pr, ,origin,phase-data, 22 0.0518 0.15 166.0 md earthquake M 2.7 - 1 km SW of Indios, Puerto Rico 17.9856 -66.8285

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