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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| us6000c5ze | 5.4 | northern Mid-Atlantic Ridge | 1601958297607 | 1602023773040 | https://earthquake.usgs.gov/earthquakes/eventpage/us6000c5ze | https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/us6000c5ze.geojson | 0 | green | reviewed | 0 | 449 | us | 6000c5ze | ,us6000c5ze, | ,us, | ,losspager,origin,phase-data,shakemap, | 19.023 | 0.7 | 50.0 | mww | earthquake | M 5.4 - northern Mid-Atlantic Ridge | 32.8645 | -39.838 | ||||
| us6000c7b1 | 5.9 | Easter Island region | 1602335697344 | 1602422329581 | https://earthquake.usgs.gov/earthquakes/eventpage/us6000c7b1 | https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/us6000c7b1.geojson | 0 | green | reviewed | 0 | 536 | us | 6000c7b1 | ,us6000c7b1, | ,us, | ,ground-failure,losspager,moment-tensor,origin,phase-data,shakemap, | 2.901 | 1.02 | 50.0 | mww | earthquake | M 5.9 - Easter Island region | -28.5676 | -112.3045 | ||||
| us6000c7k9 | 5.7 | Easter Island region | 1602427280526 | 1602513868258 | https://earthquake.usgs.gov/earthquakes/eventpage/us6000c7k9 | https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/us6000c7k9.geojson | 1 | 2.2 | 0 | green | reviewed | 0 | 500 | us | 6000c7k9 | ,us6000c7k9, | ,us, | ,dyfi,losspager,moment-tensor,origin,phase-data,shakemap, | 2.804 | 1.06 | 60.0 | mww | earthquake | M 5.7 - Easter Island region | -28.5928 | -112.1617 |
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 );