This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| uw61501228 | -0.2 | 22 km ENE of Ashford, Washington | 1602015945600 | 1602204895800 | https://earthquake.usgs.gov/earthquakes/eventpage/uw61501228 | https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw61501228.geojson | reviewed | 0 | 0 | uw | 61501228 | ,uw61501228, | ,uw, | ,origin,phase-data, | 10 | 0.02193 | 0.05 | 104.0 | md | earthquake | M -0.2 - 22 km ENE of Ashford, Washington | 46.8473333333333 | -121.76 | |||||
| uw61680437 | 0.56 | 14 km S of Glide, Oregon | 1601936904770 | 1602008793930 | https://earthquake.usgs.gov/earthquakes/eventpage/uw61680437 | https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw61680437.geojson | reviewed | 0 | 5 | uw | 61680437 | ,uw61680437, | ,uw, | ,origin,phase-data, | 3 | 0.1146 | 0.03 | 249.0 | md | explosion | M 0.6 Explosion - 14 km S of Glide, Oregon | 43.1715 | -123.1055 | |||||
| uw61680547 | 0.31 | 10 km SSE of Morton, Washington | 1601984502780 | 1602007533190 | https://earthquake.usgs.gov/earthquakes/eventpage/uw61680547 | https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw61680547.geojson | reviewed | 0 | 1 | uw | 61680547 | ,uw61680547, | ,uw, | ,origin,phase-data, | 6 | 0.1647 | 0.13 | 317.0 | md | earthquake | M 0.3 - 10 km SSE of Morton, Washington | 46.466 | -122.227833333333 | |||||
| uw61680752 | 1.6 | 7 km NW of Philomath, Oregon | 1602015674180 | 1602020306220 | https://earthquake.usgs.gov/earthquakes/eventpage/uw61680752 | https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw61680752.geojson | reviewed | 0 | 39 | uw | 61680752 | ,uw61680752, | ,uw, | ,origin,phase-data, | 9 | 0.08447 | 0.22 | 96.0 | md | explosion | M 1.6 Explosion - 7 km NW of Philomath, Oregon | 44.5898333333333 | -123.422666666667 | |||||
| uw61681612 | 0.65 | 4 km ENE of Sunnyslope, Washington | 1602260643980 | 1602270488110 | https://earthquake.usgs.gov/earthquakes/eventpage/uw61681612 | https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw61681612.geojson | reviewed | 0 | 6 | uw | 61681612 | ,uw61681612, | ,uw, | ,origin,phase-data, | 4 | 0.116 | 0.1 | 287.0 | md | explosion | M 0.7 Explosion - 4 km ENE of Sunnyslope, Washington | 47.493 | -120.285666666667 | |||||
| uw61691386 | 0.51 | 1 km NNW of Lake Marcel-Stillwater, Washington | 1602027677140 | 1602198247110 | https://earthquake.usgs.gov/earthquakes/eventpage/uw61691386 | https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw61691386.geojson | reviewed | 0 | 4 | uw | 61691386 | ,uw61691386, | ,uw, | ,origin,phase-data, | 6 | 0.142 | 0.14 | 107.0 | md | earthquake | M 0.5 - 1 km NNW of Lake Marcel-Stillwater, Washington | 47.7048333333333 | -121.919666666667 | |||||
| uw61692046 | 0.81 | 7 km SSW of Cottage Grove, Oregon | 1602193153590 | 1602271251580 | https://earthquake.usgs.gov/earthquakes/eventpage/uw61692046 | https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/uw61692046.geojson | reviewed | 0 | 10 | uw | 61692046 | ,uw61692046, | ,uw, | ,origin,phase-data, | 6 | 0.182 | 0.26 | 95.0 | md | explosion | M 0.8 Explosion - 7 km SSW of Cottage Grove, Oregon | 43.7331666666667 | -123.102666666667 |
JSON shape: default, array, newline-delimited, object
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 );