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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
nn00777260 | 1.1 | 27 km S of Hawthorne, Nevada | 1601931406270 | 1601932032526 | https://earthquake.usgs.gov/earthquakes/eventpage/nn00777260 | https://earthquake.usgs.gov/earthquakes/feed/v1.0/detail/nn00777260.geojson | automatic | 0 | 19 | nn | 00777260 | ,nn00777260, | ,nn, | ,origin,phase-data, | 8 | 0.08 | 0.26 | 282.02 | ml | earthquake | M 1.1 - 27 km S of Hawthorne, Nevada | 38.2772 | -118.5625 |
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 );