points_and_times (view)

2,395,974 rows

View and edit SQL

Suggested facets: title (date)

latitude longitude title
37.09211 -119.55301 2019-10-01 00:00:15-07:00
35.35389 -118.95864 2019-10-01 00:00:15-07:00
35.54847 -121.08542 2019-10-01 00:00:15-07:00
37.69717 -122.08699 2019-10-01 00:00:15-07:00
38.36723 -121.54198 2019-10-01 00:00:15-07:00
38.37341 -121.54748 2019-10-01 00:00:15-07:00
40.78042 -124.18235 2019-10-01 00:00:15-07:00
37.04293 -122.09002 2019-10-01 00:00:15-07:00
36.81337 -120.25931 2019-10-01 00:00:15-07:00
40.55785 -124.14553 2019-10-01 00:00:15-07:00
35.99202 -119.57146 2019-10-01 00:00:15-07:00
36.29815 -119.76184 2019-10-01 00:00:15-07:00
37.66234 -121.69662 2019-10-01 00:00:15-07:00
37.25687 -120.43449 2019-10-01 00:00:15-07:00
37.83977 -122.12694 2019-10-01 00:00:15-07:00
38.31483 -122.33439 2019-10-01 00:00:15-07:00
37.84695 -122.21344 2019-10-01 00:00:15-07:00
37.73454 -122.13937 2019-10-01 00:00:15-07:00
39.0775 -121.52568 2019-10-01 00:00:15-07:00
35.15723 -120.672 2019-10-01 00:00:15-07:00
38.69685 -120.77764 2019-10-01 00:00:15-07:00
40.18335 -122.2206 2019-10-01 00:00:15-07:00
38.17765 -121.71222 2019-10-01 00:00:15-07:00
38.12243 -121.83043 2019-10-01 00:00:15-07:00
36.37987 -119.92783 2019-10-01 00:00:15-07:00
36.61393 -121.56663 2019-10-01 00:00:15-07:00
37.50476 -122.25824 2019-10-01 00:00:15-07:00
37.75326 -122.42691 2019-10-01 00:00:15-07:00
37.75354 -122.42749 2019-10-01 00:00:15-07:00
37.75334 -122.42578 2019-10-01 00:00:15-07:00
37.76364 -122.38797 2019-10-01 00:00:15-07:00
37.75475 -122.42896 2019-10-01 00:00:15-07:00
37.75335 -122.42778 2019-10-01 00:00:15-07:00
37.3361 -121.9288 2019-10-01 00:00:15-07:00
37.29857 -121.97725 2019-10-01 00:00:15-07:00
37.25649 -121.94472 2019-10-01 00:00:15-07:00
37.70999 -122.17583 2019-10-01 00:00:15-07:00
35.30441 -120.77233 2019-10-01 00:00:15-07:00
37.56994 -122.31673 2019-10-01 00:00:15-07:00
38.50277 -122.71038 2019-10-01 00:00:15-07:00
36.45004 -121.35438 2019-10-01 00:00:15-07:00
38.1891 -120.82691 2019-10-01 00:00:15-07:00
37.89203 -122.03894 2019-10-01 00:00:15-07:00
38.65738 -121.77805 2019-10-01 00:00:15-07:00
37.09211 -119.55301 2019-10-01 00:10:38-07:00
35.35389 -118.95864 2019-10-01 00:10:38-07:00
35.54847 -121.08542 2019-10-01 00:10:38-07:00
37.69717 -122.08699 2019-10-01 00:10:38-07:00
38.36723 -121.54198 2019-10-01 00:10:38-07:00
38.37341 -121.54748 2019-10-01 00:10:38-07:00
40.78042 -124.18235 2019-10-01 00:10:38-07:00
37.04293 -122.09002 2019-10-01 00:10:38-07:00
36.81337 -120.25931 2019-10-01 00:10:38-07:00
40.55785 -124.14553 2019-10-01 00:10:38-07:00
36.76072 -119.7904 2019-10-01 00:10:38-07:00
35.99202 -119.57146 2019-10-01 00:10:38-07:00
36.29815 -119.76184 2019-10-01 00:10:38-07:00
37.66234 -121.69662 2019-10-01 00:10:38-07:00
37.25687 -120.43449 2019-10-01 00:10:38-07:00
37.83977 -122.12694 2019-10-01 00:10:38-07:00
38.31483 -122.33439 2019-10-01 00:10:38-07:00
37.84695 -122.21344 2019-10-01 00:10:38-07:00
37.73454 -122.13937 2019-10-01 00:10:38-07:00
39.0775 -121.52568 2019-10-01 00:10:38-07:00
35.15723 -120.672 2019-10-01 00:10:38-07:00
38.69685 -120.77764 2019-10-01 00:10:38-07:00
40.18335 -122.2206 2019-10-01 00:10:38-07:00
38.17765 -121.71222 2019-10-01 00:10:38-07:00
38.12243 -121.83043 2019-10-01 00:10:38-07:00
36.37987 -119.92783 2019-10-01 00:10:38-07:00
36.61393 -121.56663 2019-10-01 00:10:38-07:00
37.50476 -122.25824 2019-10-01 00:10:38-07:00
37.75326 -122.42691 2019-10-01 00:10:38-07:00
37.75354 -122.42749 2019-10-01 00:10:38-07:00
37.75334 -122.42578 2019-10-01 00:10:38-07:00
37.76364 -122.38797 2019-10-01 00:10:38-07:00
37.75475 -122.42896 2019-10-01 00:10:38-07:00
37.75335 -122.42778 2019-10-01 00:10:38-07:00
37.3361 -121.9288 2019-10-01 00:10:38-07:00
37.29857 -121.97725 2019-10-01 00:10:38-07:00
37.25649 -121.94472 2019-10-01 00:10:38-07:00
37.70999 -122.17583 2019-10-01 00:10:38-07:00
35.30441 -120.77233 2019-10-01 00:10:38-07:00
37.56994 -122.31673 2019-10-01 00:10:38-07:00
38.50277 -122.71038 2019-10-01 00:10:38-07:00
36.45004 -121.35438 2019-10-01 00:10:38-07:00
38.1891 -120.82691 2019-10-01 00:10:38-07:00
37.89203 -122.03894 2019-10-01 00:10:38-07:00
38.65738 -121.77805 2019-10-01 00:10:38-07:00
37.09211 -119.55301 2019-10-01 00:20:14-07:00
35.35389 -118.95864 2019-10-01 00:20:14-07:00
35.54847 -121.08542 2019-10-01 00:20:14-07:00
37.69717 -122.08699 2019-10-01 00:20:14-07:00
38.36723 -121.54198 2019-10-01 00:20:14-07:00
38.37341 -121.54748 2019-10-01 00:20:14-07:00
40.78042 -124.18235 2019-10-01 00:20:14-07:00
37.04293 -122.09002 2019-10-01 00:20:14-07:00
36.81337 -120.25931 2019-10-01 00:20:14-07:00
40.55785 -124.14553 2019-10-01 00:20:14-07:00
36.76072 -119.7904 2019-10-01 00:20:14-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 547.947ms · About: About this site