quakes

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

View and edit SQL

Suggested facets: status, net, sources, types, rms

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
nc73467251 1.98 7km NE of Los Molinos, CA 1601973891650 1602284586374   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467251 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467251.geojson         reviewed 0 60 nc 73467251 ,nc73467251, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 23 0.1196 0.13 70.0 md earthquake M 2.0 - 7km NE of Los Molinos, CA 40.058 -122.036
nc73467436 0.8 8km NW of The Geysers, CA 1602007112620 1602007209862   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467436 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467436.geojson         automatic 0 10 nc 73467436 ,nc73467436, ,nc, ,nearby-cities,origin,phase-data, 23 0.0155 0.02 48.0 md earthquake M 0.8 - 8km NW of The Geysers, CA 38.8336678 -122.8166656
nc73468231 0.83 10km NE of San Martin, CA 1602149861120 1602152256032   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468231 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468231.geojson         reviewed 0 11 nc 73468231 ,nc73468231, ,nc, ,nearby-cities,origin,phase-data, 23 0.0737 0.14 56.0 md earthquake M 0.8 - 10km NE of San Martin, CA 37.1403333 -121.5265
nc73469251 1.2 6km NW of The Geysers, CA 1602378646360 1602381184681   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469251 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469251.geojson         automatic 0 22 nc 73469251 ,nc73469251, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 23 0.009993 0.02 44.0 md earthquake M 1.2 - 6km NW of The Geysers, CA 38.8134995 -122.8081665
nc73469376 1.57 5km E of Mammoth Lakes, CA 1602404069340 1602466028414   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469376 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469376.geojson         reviewed 0 38 nc 73469376 ,nc73469376, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 23 0.01856 0.04 59.0 md earthquake M 1.6 - 5km E of Mammoth Lakes, CA 37.6331667 -118.9245
nc73469701 1.04 1km W of The Geysers, CA 1602458296070 1602458390412   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469701 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469701.geojson         automatic 0 17 nc 73469701 ,nc73469701, ,nc, ,nearby-cities,origin,phase-data, 23 0.007995 0.04 88.0 md earthquake M 1.0 - 1km W of The Geysers, CA 38.7786674 -122.7669983
nc73469756 1.34 7km WNW of The Geysers, CA 1602467050180 1602472385081   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469756 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469756.geojson         automatic 0 28 nc 73469756 ,nc73469756, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 23 0.005925 0.03 61.0 md earthquake M 1.3 - 7km WNW of The Geysers, CA 38.8096657 -122.8216629
nm60311607 1.41 4 km ENE of Caruthersville, Missouri 1601976669120 1601990508570   https://earthquake.usgs.gov/earthquakes/eventpage/nm60311607 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nm60311607.geojson         reviewed 0 31 nm 60311607 ,nm60311607, ,nm, ,origin,phase-data, 23 0.05516 0.04 49.0 md earthquake M 1.4 - 4 km ENE of Caruthersville, Missouri 36.2146667 -89.6113333
pr2020284011 3.21 3 km SSW of La Parguera, Puerto Rico 1602350402500 1602355745040   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020284011 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020284011.geojson 1 2     reviewed 0 159 pr 2020284011 ,pr2020284011,us6000c7ca, ,pr,us, ,dyfi,origin,phase-data, 23 0.0314 0.11 235.0 md earthquake M 3.2 - 3 km SSW of La Parguera, Puerto Rico 17.94 -67.0553
pr2020284017 3.12 2 km SSW of La Parguera, Puerto Rico 1602368821330 1602397765442   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020284017 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020284017.geojson 2 3.1     reviewed 0 150 pr 2020284017 ,us6000c7ee,pr2020284017, ,us,pr, ,dyfi,origin,phase-data, 23 0.0222 0.15 232.0 md earthquake M 3.1 - 2 km SSW of La Parguera, Puerto Rico 17.953 -67.0591
pr2020285006 3.69 3 km S of La Parguera, Puerto Rico 1602388847320 1602522153040   https://earthquake.usgs.gov/earthquakes/eventpage/pr2020285006 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/pr2020285006.geojson 19 4 3.336 green reviewed 0 217 pr 2020285006 ,us6000c7fy,pr2020285006, ,us,pr, ,dyfi,losspager,moment-tensor,origin,phase-data,shakemap, 23 0.0307 0.08 236.0 md earthquake M 3.7 - 3 km S of La Parguera, Puerto Rico 17.9396 -67.0515

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