Skip to content

Incorrect event time shown when querying events before 1640

From @nambruz...

Summary

Events before ~1640 show an incorrect datetime when queried using CSV or QuakeML format, possibly due to integer underflow with conversion from Epoch time to timestamp. The correct Epoch time is shown when querying using geoJSON format.

For example, querying event official16380611190000000 shows an event time of 1970-02-03T09:26:40.000Z, when the actual event time is 1638-06-11T19:00:00.000.

Additional details

CSV query: https://earthquake.usgs.gov/fdsnws/event/1/query?starttime=1550-01-01%2000:00:00&endtime=1639-12-31%2023:59:59&orderby=time-asc&format=csv

QuakeML query: https://earthquake.usgs.gov/fdsnws/event/1/query?starttime=1550-01-01%2000:00:00&endtime=1639-12-31%2023:59:59&orderby=time-asc&format=quakeml

geoJSON query: https://earthquake.usgs.gov/fdsnws/event/1/query?starttime=1550-01-01%2000:00:00&endtime=1639-12-31%2023:59:59&orderby=time-asc&format=geojson