points_and_times (view)

3,318,456 rows sorted by longitude

View and edit SQL

latitude longitude ▼ title
35.36763 -118.72555 2019-10-29 21:20:58-07:00
35.36763 -118.72555 2019-10-29 21:30:35-07:00
35.36241 -118.73109 2019-12-17 13:10:30-08:00
35.36241 -118.73109 2019-12-17 13:20:19-08:00
35.36241 -118.73109 2019-12-17 13:30:21-08:00
35.36241 -118.73109 2019-12-17 13:40:33-08:00
35.36241 -118.73109 2019-12-17 13:50:18-08:00
35.36241 -118.73109 2019-12-17 14:00:35-08:00
35.36241 -118.73109 2019-12-17 14:10:34-08:00
35.36241 -118.73109 2019-12-17 14:20:40-08:00
35.36241 -118.73109 2019-12-17 14:30:18-08:00
35.36241 -118.73109 2019-12-17 14:40:16-08:00
35.36241 -118.73109 2019-12-17 14:50:35-08:00
35.36241 -118.73109 2019-12-17 15:00:44-08:00
35.36241 -118.73109 2019-12-17 15:10:20-08:00
35.36241 -118.73109 2019-12-17 15:20:14-08:00
35.36241 -118.73109 2019-12-17 15:30:29-08:00
35.36241 -118.73109 2019-12-17 15:40:19-08:00
35.36241 -118.73109 2019-12-17 15:50:29-08:00
35.36241 -118.73109 2019-12-17 16:00:18-08:00
35.36241 -118.73109 2019-12-17 16:10:41-08:00
35.36241 -118.73109 2019-12-17 16:20:22-08:00
35.36241 -118.73109 2019-12-17 16:30:31-08:00
35.36241 -118.73109 2019-12-17 16:40:20-08:00
35.36241 -118.73109 2019-12-17 16:50:22-08:00
35.36241 -118.73109 2019-12-17 17:00:47-08:00
35.36241 -118.73109 2019-12-17 17:10:25-08:00
35.36241 -118.73109 2019-12-17 17:20:27-08:00
35.36241 -118.73109 2019-12-17 17:30:32-08:00
35.36241 -118.73109 2019-12-17 17:40:23-08:00
35.36241 -118.73109 2019-12-17 17:50:36-08:00
35.36241 -118.73109 2019-12-17 18:00:21-08:00
35.36241 -118.73109 2019-12-17 18:10:17-08:00
35.36241 -118.73109 2019-12-17 18:20:47-08:00
35.36241 -118.73109 2019-12-17 18:30:19-08:00
35.36241 -118.73109 2019-12-17 18:40:16-08:00
35.3339 -118.73151 2019-10-30 10:20:23-07:00
35.3339 -118.73151 2019-10-30 10:30:28-07:00
35.3339 -118.73151 2019-10-30 10:40:23-07:00
35.3339 -118.73151 2019-10-30 10:50:32-07:00
35.3339 -118.73151 2019-10-30 11:00:54-07:00
35.3339 -118.73151 2019-10-30 11:10:31-07:00
35.3339 -118.73151 2019-10-30 11:20:45-07:00
35.3339 -118.73151 2019-10-30 11:30:41-07:00
35.3339 -118.73151 2019-10-30 11:40:35-07:00
35.3339 -118.73151 2019-10-30 11:50:41-07:00
35.3339 -118.73151 2019-10-30 12:00:44-07:00
35.3339 -118.73151 2019-10-30 12:10:22-07:00
35.3339 -118.73151 2019-10-30 12:20:28-07:00
35.3339 -118.73151 2019-10-30 12:30:31-07:00
35.3339 -118.73151 2019-10-30 12:40:27-07:00
35.3339 -118.73151 2019-10-30 12:50:23-07:00
35.3339 -118.73151 2019-10-30 13:00:50-07:00
35.3339 -118.73151 2019-10-30 13:20:44-07:00
35.3339 -118.73151 2019-10-30 13:30:51-07:00
35.3339 -118.73151 2019-10-30 13:40:26-07:00
35.3339 -118.73151 2019-10-30 13:50:33-07:00
35.3339 -118.73151 2019-10-30 14:00:34-07:00
35.3339 -118.73151 2019-10-30 14:10:17-07:00
35.3339 -118.73151 2019-10-30 14:20:39-07:00
35.3339 -118.73151 2019-10-30 14:30:51-07:00
35.3339 -118.73151 2019-10-30 14:40:27-07:00
35.3339 -118.73151 2019-10-30 14:50:25-07:00
35.3339 -118.73151 2019-10-30 15:00:29-07:00
35.3339 -118.73151 2019-10-30 15:10:18-07:00
35.3339 -118.73151 2019-10-30 15:20:18-07:00
35.3339 -118.73151 2019-10-30 15:30:34-07:00
35.3339 -118.73151 2019-10-30 15:40:32-07:00
35.3339 -118.73151 2019-10-30 15:50:26-07:00
35.3339 -118.73151 2019-10-30 16:00:32-07:00
35.3339 -118.73151 2019-10-30 16:10:16-07:00
35.3339 -118.73151 2019-10-30 16:20:16-07:00
35.3339 -118.73151 2019-10-30 16:30:19-07:00
35.3339 -118.73151 2019-10-30 16:40:19-07:00
35.3339 -118.73151 2019-10-30 16:50:20-07:00
35.3339 -118.73151 2019-10-30 17:00:39-07:00
35.3339 -118.73151 2019-10-30 17:10:15-07:00
35.3339 -118.73151 2019-10-30 17:20:20-07:00
35.334 -118.73463 2019-10-10 12:20:25-07:00
35.334 -118.73463 2019-10-10 13:10:22-07:00
35.334 -118.73463 2019-10-10 13:20:22-07:00
35.334 -118.73463 2019-10-10 13:30:20-07:00
35.334 -118.73463 2019-10-10 13:40:23-07:00
35.334 -118.73463 2019-10-10 13:50:36-07:00
35.334 -118.73463 2019-10-10 14:10:27-07:00
35.334 -118.73463 2019-10-10 14:20:17-07:00
35.334 -118.73463 2019-10-10 14:41:38-07:00
35.334 -118.73463 2019-10-10 14:50:21-07:00
35.334 -118.73463 2019-10-10 15:00:18-07:00
35.334 -118.73463 2019-10-10 15:10:17-07:00
35.334 -118.73463 2019-10-10 15:20:36-07:00
35.334 -118.73463 2019-10-10 15:30:32-07:00
35.334 -118.73463 2019-10-10 15:40:39-07:00
35.334 -118.73463 2019-10-10 15:50:26-07:00
35.334 -118.73463 2019-10-10 16:00:43-07:00
35.334 -118.73463 2019-10-10 16:10:20-07:00
35.334 -118.73463 2019-10-10 16:30:37-07:00
35.334 -118.73463 2019-10-10 16:40:19-07:00
35.334 -118.73463 2019-10-10 16:50:19-07:00
35.334 -118.73463 2019-10-10 17:00:16-07:00

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW points_and_times as select outage_snapshots.latitude, outage_snapshots.longitude, snapshots.title
from outage_snapshots join snapshots on outage_snapshots.snapshot = snapshots.id
Powered by Datasette · Query took 2748.734ms · About: About this site