quakes

13 rows where magType = "md" and net = "se"

View and edit SQL

Suggested facets: mag, place, sig, nst, rms, gap, 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
se60114628 2.29 3 km NW of South Webster, Ohio 1602143450720 1602179719110   https://earthquake.usgs.gov/earthquakes/eventpage/se60114628 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/se60114628.geojson         reviewed 0 81 se 60114628 ,se60114628, ,se, ,origin,phase-data, 20 0.4955 0.29 65.0 md earthquake M 2.3 - 3 km NW of South Webster, Ohio 38.8388333 -82.7571667
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
se60311807 2.3 7 km W of New Market, Tennessee 1602275042590 1602337598810   https://earthquake.usgs.gov/earthquakes/eventpage/se60311807 https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/se60311807.geojson         reviewed 0 81 se 60311807 ,se60311807, ,se, ,origin,phase-data, 14 0.2041 0.11 83.0 md earthquake M 2.3 - 7 km W of New Market, Tennessee 36.1018333 -83.6378333
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

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