quakes

5 rows where magType = "md" and nst = 34

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
hv72169051 1.88 1 km E of Honaunau-Napoopoo, Hawaii 1601992605900 1601992787800   https://earthquake.usgs.gov/earthquakes/eventpage/hv72169051 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72169051.geojson         automatic 0 54 hv 72169051 ,hv72169051, ,hv, ,origin,phase-data, 34   0.170000002 111.0 md earthquake M 1.9 - 1 km E of Honaunau-Napoopoo, Hawaii 19.4563331604004 -155.850830078125
hv72169566 1.89999998 11 km ENE of Pāhala, Hawaii 1602014534810 1602014735000   https://earthquake.usgs.gov/earthquakes/eventpage/hv72169566 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72169566.geojson         automatic 0 56 hv 72169566 ,hv72169566, ,hv, ,origin,phase-data, 34   0.119999997 167.0 md earthquake M 1.9 - 11 km ENE of Pāhala, Hawaii 19.2325000762939 -155.376495361328
hv72169766 1.97000003 4 km SSE of Pāhala, Hawaii 1602027363440 1602027549040   https://earthquake.usgs.gov/earthquakes/eventpage/hv72169766 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/hv72169766.geojson         automatic 0 60 hv 72169766 ,hv72169766, ,hv, ,origin,phase-data, 34   0.170000002 208.0 md earthquake M 2.0 - 4 km SSE of Pāhala, Hawaii 19.1630001068115 -155.469329833984
nc73467796 2.19 10km ESE of Willits, CA 1602072317660 1602312307216   https://earthquake.usgs.gov/earthquakes/eventpage/nc73467796 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73467796.geojson         reviewed 0 74 nc 73467796 ,nc73467796, ,nc, ,nearby-cities,origin,phase-data,scitech-link, 34 0.07223 0.08 45.0 md earthquake M 2.2 - 10km ESE of Willits, CA 39.3645 -123.25
nc73469046 1.57 7km NW of The Geysers, CA 1602326616800 1602330905208   https://earthquake.usgs.gov/earthquakes/eventpage/nc73469046 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nc73469046.geojson         automatic 0 38 nc 73469046 ,nc73469046, ,nc, ,focal-mechanism,nearby-cities,origin,phase-data,scitech-link, 34 0.0024 0.04 39.0 md earthquake M 1.6 - 7km NW of The Geysers, CA 38.8209991 -122.8098297

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