points_and_times (view)

3,318,456 rows sorted by latitude

View and edit SQL

latitude ▼ longitude title
34.51772 -120.30603 2019-11-12 16:50:30-08:00
34.51772 -120.30603 2019-11-12 17:00:34-08:00
34.51772 -120.30603 2019-11-12 17:10:19-08:00
34.52404 -120.28229 2019-10-31 09:20:23-07:00
34.52404 -120.28229 2019-10-31 09:30:40-07:00
34.52404 -120.28229 2019-10-31 09:40:18-07:00
34.52404 -120.28229 2019-10-31 09:50:37-07:00
34.52404 -120.28229 2019-10-31 10:00:44-07:00
34.52404 -120.28229 2019-10-31 10:10:30-07:00
34.52404 -120.28229 2019-10-31 10:20:19-07:00
34.52404 -120.28229 2019-10-31 10:30:45-07:00
34.52404 -120.28229 2019-10-31 10:40:26-07:00
34.52404 -120.28229 2019-10-31 10:51:33-07:00
34.52404 -120.28229 2019-10-31 11:01:07-07:00
34.52404 -120.28229 2019-10-31 11:10:59-07:00
34.52404 -120.28229 2019-10-31 11:20:20-07:00
34.52404 -120.28229 2019-10-31 11:30:31-07:00
34.52404 -120.28229 2019-10-31 11:40:30-07:00
34.52404 -120.28229 2019-10-31 11:50:23-07:00
34.52404 -120.28229 2019-10-31 12:00:57-07:00
34.52404 -120.28229 2019-10-31 12:10:32-07:00
34.52404 -120.28229 2019-10-31 12:20:17-07:00
34.52404 -120.28229 2019-10-31 12:30:25-07:00
34.52404 -120.28229 2019-10-31 12:40:48-07:00
34.52404 -120.28229 2019-10-31 12:50:16-07:00
34.52404 -120.28229 2019-10-31 13:00:45-07:00
34.52404 -120.28229 2019-10-31 13:10:59-07:00
34.52404 -120.28229 2019-10-31 13:20:24-07:00
34.52404 -120.28229 2019-10-31 13:30:32-07:00
34.52404 -120.28229 2019-10-31 13:40:23-07:00
34.52404 -120.28229 2019-10-31 13:50:39-07:00
34.52404 -120.28229 2019-10-31 14:00:54-07:00
34.52404 -120.28229 2019-10-31 14:10:27-07:00
34.52404 -120.28229 2019-10-31 14:20:40-07:00
34.52404 -120.28229 2019-10-31 14:30:38-07:00
34.52404 -120.28229 2019-10-31 14:40:19-07:00
34.52404 -120.28229 2019-10-31 14:50:25-07:00
34.52404 -120.28229 2019-10-31 15:00:49-07:00
34.52404 -120.28229 2019-10-31 15:10:35-07:00
34.52404 -120.28229 2019-10-31 15:20:23-07:00
34.52404 -120.28229 2019-10-31 15:30:35-07:00
34.5302 -120.31936 2019-12-06 17:01:05-08:00
34.5302 -120.31936 2019-12-06 17:10:24-08:00
34.5302 -120.31936 2019-12-06 17:20:14-08:00
34.5302 -120.31936 2019-12-06 17:30:18-08:00
34.5302 -120.31936 2019-12-06 17:40:34-08:00
34.5302 -120.31936 2019-12-06 17:50:24-08:00
34.5302 -120.31936 2019-12-06 18:00:56-08:00
34.5302 -120.31936 2019-12-06 18:10:17-08:00
34.5302 -120.31936 2019-12-06 18:20:34-08:00
34.5302 -120.31936 2019-12-06 18:30:24-08:00
34.5302 -120.31936 2019-12-06 18:40:27-08:00
34.5302 -120.31936 2019-12-06 18:50:53-08:00
34.5302 -120.31936 2019-12-06 19:00:28-08:00
34.5302 -120.31936 2019-12-06 19:10:25-08:00
34.5302 -120.31936 2019-12-06 19:20:18-08:00
34.5302 -120.31936 2019-12-06 19:30:16-08:00
34.53602 -120.17866 2019-11-09 07:20:24-08:00
34.53602 -120.17866 2019-11-09 07:30:39-08:00
34.53602 -120.17866 2019-11-09 07:40:12-08:00
34.53602 -120.17866 2019-11-09 07:50:10-08:00
34.53602 -120.17866 2019-11-09 08:00:29-08:00
34.53602 -120.17866 2019-11-09 08:10:12-08:00
34.53602 -120.17866 2019-11-09 08:20:11-08:00
34.53602 -120.17866 2019-11-09 08:30:11-08:00
34.53602 -120.17866 2019-11-09 08:40:14-08:00
34.53602 -120.17866 2019-11-09 08:50:25-08:00
34.53602 -120.17866 2019-11-09 09:00:17-08:00
34.53602 -120.17866 2019-11-09 09:10:31-08:00
34.53602 -120.17866 2019-11-09 09:20:13-08:00
34.53602 -120.17866 2019-11-09 09:30:19-08:00
34.53602 -120.17866 2019-11-09 09:40:18-08:00
34.53602 -120.17866 2019-11-09 09:50:12-08:00
34.53602 -120.17866 2019-11-09 10:01:43-08:00
34.53602 -120.17866 2019-11-09 10:10:17-08:00
34.53602 -120.17866 2019-11-09 10:20:18-08:00
34.53602 -120.17866 2019-11-09 10:30:55-08:00
34.53602 -120.17866 2019-11-09 10:40:14-08:00
34.53602 -120.17866 2019-11-09 10:50:26-08:00
34.53602 -120.17866 2019-11-09 11:00:22-08:00
34.53602 -120.17866 2019-11-09 11:10:14-08:00
34.53602 -120.17866 2019-11-09 11:20:13-08:00
34.53602 -120.17866 2019-11-09 11:30:15-08:00
34.53602 -120.17866 2019-11-09 11:40:28-08:00
34.53602 -120.17866 2019-11-09 11:50:16-08:00
34.53602 -120.17866 2019-11-09 12:00:25-08:00
34.53602 -120.17866 2019-11-09 12:10:13-08:00
34.53602 -120.17866 2019-11-09 12:20:13-08:00
34.53602 -120.17866 2019-11-09 12:30:16-08:00
34.53602 -120.17866 2019-11-09 12:40:15-08:00
34.53602 -120.17866 2019-11-09 12:50:17-08:00
34.53602 -120.17866 2019-11-09 13:00:16-08:00
34.53602 -120.17866 2019-11-09 13:10:12-08:00
34.53602 -120.17866 2019-11-09 13:20:16-08:00
34.53602 -120.17866 2019-11-09 13:30:18-08:00
34.55496 -120.35456 2019-11-05 15:40:21-08:00
34.55496 -120.35456 2019-11-05 16:10:33-08:00
34.55496 -120.35456 2019-11-05 16:20:43-08:00
34.55496 -120.35456 2019-11-05 16:30:33-08:00
34.55496 -120.35456 2019-11-05 16:40:21-08: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 4050.648ms · About: About this site