quakes

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

View and edit SQL

Suggested facets: status, net, sources, types

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
hv72167616 1.77999997 5 km ESE of Pāhala, Hawaii 1601918837820 1601919028490   https://earthquake.usgs.gov/earthquakes/eventpage/hv72167616 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72167616.geojson         automatic 0 49 hv 72167616 ,hv72167616, ,hv, ,origin,phase-data, 30   0.159999996 173.0 md earthquake M 1.8 - 5 km ESE of Pāhala, Hawaii 19.1766662597656 -155.428833007812
hv72172306 1.71 3 km SSE of Pāhala, Hawaii 1602205031490 1602207370200   https://earthquake.usgs.gov/earthquakes/eventpage/hv72172306 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72172306.geojson         reviewed 0 45 hv 72172306 ,hv72172306, ,hv, ,origin,phase-data, 30   0.09 204.0 md earthquake M 1.7 - 3 km SSE of Pāhala, Hawaii 19.174 -155.469666666667
hv72172566 2.25 5 km SSW of Pāhala, Hawaii 1602221223650 1602221414220   https://earthquake.usgs.gov/earthquakes/eventpage/hv72172566 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72172566.geojson         automatic 0 78 hv 72172566 ,hv72172566, ,hv, ,origin,phase-data, 30   0.150000006 164.0 md earthquake M 2.3 - 5 km SSW of Pāhala, Hawaii 19.158332824707 -155.496826171875
nc73467256 1.32 7km NW of The Geysers, CA 1601973924780 1601980145466   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467256 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467256.geojson         automatic 0 27 nc 73467256 ,nc73467256, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 30 0.009211 0.02 55.0 md earthquake M 1.3 - 7km NW of The Geysers, CA 38.8121681 -122.8181686
nc73467931 0.9 8km NNW of Cholame, CA 1602099985260 1602144365502   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467931 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467931.geojson         reviewed 0 12 nc 73467931 ,nc73467931, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 30 0.01859 0.05 95.0 md earthquake M 0.9 - 8km NNW of Cholame, CA 35.7863333 -120.324
nc73467966 1.82 6km N of New Idria, CA 1602102803850 1602151924322   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467966 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467966.geojson         reviewed 0 51 nc 73467966 ,nc73467966, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 30 0.1531 0.1 172.0 md earthquake M 1.8 - 6km N of New Idria, CA 36.4746667 -120.67
nc73468401 1.36 4km W of Cobb, CA 1602183170850 1602188584994   https://earthquake.usgs.gov/earthquakes/eventpage/nc73468401 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73468401.geojson         automatic 0 28 nc 73468401 ,nc73468401, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 30 0.01108 0.03 56.0 md earthquake M 1.4 - 4km W of Cobb, CA 38.8196678 -122.7666702
nm60311892 2.63 6 km ENE of Maynard, Arkansas 1602466546340 1602511834970   https://earthquake.usgs.gov/earthquakes/eventpage/nm60311892 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nm60311892.geojson 2 2.2     reviewed 0 107 nm 60311892 ,nm60311892, ,nm, ,dyfi,origin,phase-data, 30 0.4503 0.2 69.0 md earthquake M 2.6 - 6 km ENE of Maynard, Arkansas 36.4376667 -90.831

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