outages

447 rows where regionName = 29 sorted by longitude descending

View and edit SQL

id outageStartTime latitude longitude ▲ regionName outageDevices
700108 November 05, 2019 - 20:08:54 UTC 37.56361 -122.35311 San Mateo 29 []
685497 October 27, 2019 - 06:22:29 UTC 37.5675 -122.35008 San Mateo 29 []
733189 December 08, 2019 - 01:03:16 UTC 37.56408 -122.34989 San Mateo 29 []
659747 October 15, 2019 - 19:57:05 UTC 37.56905 -122.34843 San Mateo 29 []
711007 November 20, 2019 - 16:21:06 UTC 37.56699 -122.34485 San Mateo 29 []
782699 February 09, 2020 - 19:04:41 UTC 37.5747 -122.34114 San Mateo 29 []
680644 October 26, 2019 - 00:25:10 UTC 37.57274 -122.34084 San Mateo 29 []
790466 February 13, 2020 - 20:44:21 UTC 37.57274 -122.34084 San Mateo 29 []
784569 February 09, 2020 - 18:58:02 UTC 37.57612 -122.34061 San Mateo 29 []
668258 October 18, 2019 - 16:21:20 UTC 37.57033 -122.34053 San Mateo 29 []
706895 November 14, 2019 - 19:55:06 UTC 37.57526 -122.34023 San Mateo 29 []
732252 December 07, 2019 - 14:58:00 UTC 37.5489 -122.33931 San Mateo 29 []
732148 December 07, 2019 - 12:17:55 UTC 37.54961 -122.33893 San Mateo 29 []
732147 December 07, 2019 - 12:18:00 UTC 37.54991 -122.33834 San Mateo 29 []
736318 December 11, 2019 - 17:31:45 UTC 37.55015 -122.33766 San Mateo 29 []
665714 October 17, 2019 - 19:27:25 UTC 37.56895 -122.33731 San Mateo 29 []
1088822 September 23, 2020 - 14:48:22 UTC 37.56895 -122.33731 San Mateo 29 []
712558 November 22, 2019 - 01:38:16 UTC 37.55142 -122.33608 San Mateo 29 []
683241 October 27, 2019 - 03:06:38 UTC 37.51714 -122.3356 San Mateo 29 [{"latitude": "37.5172", "longitude": "-122.33263"}, {"latitude": "37.51746", "longitude": "-122.33097"}, {"latitude": "37.53453", "longitude": "-122.32171"}, {"latitude": "37.53826", "longitude": "-122.32744"}, {"latitude": "37.53377", "longitude": "-122.34491"}, {"latitude": "37.52943", "longitude": "-122.34497"}, {"latitude": "37.52178", "longitude": "-122.34067"}, {"latitude": "37.51974", "longitude": "-122.33817"}, {"latitude": "37.51863", "longitude": "-122.33672"}]
691449 October 28, 2019 - 16:09:00 UTC 37.5541 -122.33535 San Mateo 29 []
787782 February 10, 2020 - 23:26:18 UTC 37.56721 -122.33519 San Mateo 29 []
789776 February 12, 2020 - 22:50:16 UTC 37.56721 -122.33519 San Mateo 29 []
1064583 September 11, 2020 - 18:14:09 UTC 37.51598 -122.33514 San Mateo 29 []
691349 October 28, 2019 - 15:02:11 UTC 37.57454 -122.33509 San Mateo 29 []
633962 October 01, 2019 - 17:57:02 UTC 37.54962 -122.33508 San Mateo 29 []
1061386 September 08, 2020 - 23:26:38 UTC 37.54962 -122.33508 San Mateo 29 []
1086032 September 21, 2020 - 22:59:54 UTC 37.57652 -122.33501 San Mateo 29 []
665575 October 17, 2019 - 19:15:53 UTC 37.55552 -122.33495 San Mateo 29 []
710470 November 20, 2019 - 02:12:59 UTC 37.57321 -122.33466 San Mateo 29 []
784603 February 09, 2020 - 21:45:27 UTC 37.57908 -122.33463 San Mateo 29 []
723755 November 29, 2019 - 23:40:58 UTC 37.58006 -122.33413 San Mateo 29 []
782591 February 09, 2020 - 18:56:00 UTC 37.58006 -122.33413 San Mateo 29 []
787696 February 10, 2020 - 22:11:41 UTC 37.57627 -122.33408 San Mateo 29 []
784602 February 09, 2020 - 21:45:27 UTC 37.57857 -122.33407 San Mateo 29 []
736370 December 11, 2019 - 18:06:24 UTC 37.5765 -122.3338 San Mateo 29 []
737808 December 12, 2019 - 23:11:59 UTC 37.5765 -122.3338 San Mateo 29 []
787697 February 10, 2020 - 22:11:41 UTC 37.5765 -122.3338 San Mateo 29 []
733834 December 08, 2019 - 21:23:31 UTC 37.55407 -122.33376 San Mateo 29 []
683519 October 27, 2019 - 03:26:40 UTC 37.55354 -122.33362 San Mateo 29 [{"latitude": "37.54772", "longitude": "-122.34765"}, {"latitude": "37.54807", "longitude": "-122.34268"}, {"latitude": "37.54846", "longitude": "-122.33858"}, {"latitude": "37.55029", "longitude": "-122.33599"}, {"latitude": "37.55085", "longitude": "-122.33532"}, {"latitude": "37.5523", "longitude": "-122.33433"}, {"latitude": "37.55407", "longitude": "-122.33376"}, {"latitude": "37.55607", "longitude": "-122.33441"}, {"latitude": "37.56039", "longitude": "-122.33838"}, {"latitude": "37.56247", "longitude": "-122.34251"}, {"latitude": "37.56219", "longitude": "-122.34345"}, {"latitude": "37.55356", "longitude": "-122.3489"}, {"latitude": "37.55174", "longitude": "-122.34914"}, {"latitude": "37.54865", "longitude": "-122.34834"}]
784601 February 09, 2020 - 21:45:27 UTC 37.57765 -122.33338 San Mateo 29 []
706302 November 13, 2019 - 22:46:24 UTC 37.57832 -122.33314 San Mateo 29 []
784587 February 09, 2020 - 21:45:26 UTC 37.57568 -122.33307 San Mateo 29 []
723754 November 29, 2019 - 23:40:00 UTC 37.57847 -122.33292 San Mateo 29 [{"latitude": "37.57315", "longitude": "-122.3398"}, {"latitude": "37.57317", "longitude": "-122.3385"}, {"latitude": "37.57582", "longitude": "-122.33338"}, {"latitude": "37.57832", "longitude": "-122.33314"}, {"latitude": "37.58172", "longitude": "-122.3378"}, {"latitude": "37.57691", "longitude": "-122.34969"}]
699204 November 04, 2019 - 18:25:15 UTC 37.52659 -122.33268 San Mateo 29 []
647056 October 08, 2019 - 13:44:33 UTC 37.55778 -122.33261 San Mateo 29 []
784566 February 09, 2020 - 21:45:25 UTC 37.58461 -122.33252 San Mateo 29 []
784599 February 09, 2020 - 21:45:27 UTC 37.57684 -122.33249 San Mateo 29 []
686434 October 27, 2019 - 09:46:03 UTC 37.552 -122.33248 San Mateo 29 []
683744 October 27, 2019 - 03:37:47 UTC 37.55102 -122.33245 San Mateo 29 [{"latitude": "37.54962", "longitude": "-122.33508"}, {"latitude": "37.55021", "longitude": "-122.33432"}, {"latitude": "37.55144", "longitude": "-122.33291"}, {"latitude": "37.55082", "longitude": "-122.33365"}]
651175 October 09, 2019 - 21:47:00 UTC 37.5446 -122.3322 San Mateo 29 []
784589 February 09, 2020 - 21:45:26 UTC 37.57623 -122.33217 San Mateo 29 []
784567 February 09, 2020 - 21:45:25 UTC 37.58389 -122.33175 San Mateo 29 []
663173 October 17, 2019 - 00:47:15 UTC 37.56566 -122.33142 San Mateo 29 []
784597 February 09, 2020 - 21:45:27 UTC 37.57537 -122.33084 San Mateo 29 []
635824 October 02, 2019 - 15:49:11 UTC 37.57242 -122.33075 San Mateo 29 []
784596 February 09, 2020 - 21:45:26 UTC 37.57525 -122.33071 San Mateo 29 []
784590 February 09, 2020 - 21:45:26 UTC 37.57601 -122.33063 San Mateo 29 []
1062225 September 09, 2020 - 21:32:12 UTC 37.55656 -122.33043 San Mateo 29 []
695338 October 30, 2019 - 20:14:07 UTC 37.56484 -122.3303 San Mateo 29 []
786592 February 10, 2020 - 06:37:59 UTC 37.55715 -122.33002 San Mateo 29 []
789130 February 12, 2020 - 03:37:07 UTC 37.55715 -122.33002 San Mateo 29 []
680380 October 25, 2019 - 17:36:51 UTC 37.54596 -122.32998 San Mateo 29 []
783992 February 09, 2020 - 20:41:16 UTC 37.54486 -122.32979 San Mateo 29 []
786299 February 10, 2020 - 03:46:15 UTC 37.54486 -122.32979 San Mateo 29 []
723928 November 30, 2019 - 06:19:06 UTC 37.56181 -122.32974 San Mateo 29 []
691859 October 28, 2019 - 20:00:00 UTC 37.51599 -122.32972 San Mateo 29 []
735793 December 10, 2019 - 22:26:31 UTC 37.56099 -122.32969 San Mateo 29 []
739430 December 14, 2019 - 18:06:06 UTC 37.56099 -122.32969 San Mateo 29 []
782006 February 09, 2020 - 18:05:03 UTC 37.54717 -122.32969 San Mateo 29 []
699839 November 05, 2019 - 16:23:11 UTC 37.57428 -122.32966 San Mateo 29 []
784595 February 09, 2020 - 21:45:26 UTC 37.57428 -122.32966 San Mateo 29 []
1061477 September 09, 2020 - 01:16:37 UTC 37.52413 -122.32958 San Mateo 29 []
654314 October 11, 2019 - 17:19:44 UTC 37.56725 -122.32956 San Mateo 29 []
789495 February 12, 2020 - 18:40:23 UTC 37.58236 -122.32938 San Mateo 29 []
723756 November 29, 2019 - 23:40:58 UTC 37.57385 -122.32917 San Mateo 29 []
723783 November 29, 2019 - 23:40:58 UTC 37.57385 -122.32917 San Mateo 29 []
782775 February 09, 2020 - 19:11:53 UTC 37.57385 -122.32917 San Mateo 29 []
647745 October 09, 2019 - 03:38:00 UTC 37.57472 -122.32829 San Mateo 29 []
723927 November 30, 2019 - 06:18:02 UTC 37.564 -122.32829 San Mateo 29 []
724133 November 30, 2019 - 18:17:19 UTC 37.564 -122.32829 San Mateo 29 []
789094 February 12, 2020 - 02:07:13 UTC 37.57472 -122.32829 San Mateo 29 []
1062103 September 09, 2020 - 19:20:30 UTC 37.55764 -122.32825 San Mateo 29 []
733178 December 08, 2019 - 00:51:59 UTC 37.56946 -122.32823 San Mateo 29 []
647472 October 08, 2019 - 19:21:26 UTC 37.58132 -122.32814 San Mateo 29 []
734249 December 09, 2019 - 16:57:00 UTC 37.58132 -122.32814 San Mateo 29 []
712446 November 21, 2019 - 22:52:45 UTC 37.57065 -122.32809 San Mateo 29 []
1070499 September 15, 2020 - 00:27:09 UTC 37.54753 -122.32807 San Mateo 29 []
1074913 September 16, 2020 - 17:29:05 UTC 37.54753 -122.32807 San Mateo 29 []
1081534 September 18, 2020 - 21:53:07 UTC 37.54753 -122.32807 San Mateo 29 []
701005 November 06, 2019 - 20:39:46 UTC 37.55226 -122.32804 San Mateo 29 []
683260 October 27, 2019 - 03:06:38 UTC 37.5374 -122.32801 San Mateo 29 [{"latitude": "37.53879", "longitude": "-122.32851"}, {"latitude": "37.53929", "longitude": "-122.32699"}, {"latitude": "37.54056", "longitude": "-122.32916"}]
718226 November 27, 2019 - 03:59:06 UTC 37.56051 -122.32801 San Mateo 29 []
786449 February 10, 2020 - 04:45:46 UTC 37.56642 -122.32766 San Mateo 29 []
786585 February 10, 2020 - 06:17:13 UTC 37.56642 -122.32766 San Mateo 29 []
728750 December 03, 2019 - 19:37:37 UTC 37.55706 -122.32757 San Mateo 29 []
1092301 September 25, 2020 - 16:42:39 UTC 37.55814 -122.32747 San Mateo 29 []
708158 November 16, 2019 - 16:38:37 UTC 37.57337 -122.32745 San Mateo 29 []
1083301 September 20, 2020 - 20:39:00 UTC 37.53227 -122.32721 San Mateo 29 [{"latitude": "37.53198", "longitude": "-122.32708"}, {"latitude": "37.53238", "longitude": "-122.32735"}, {"latitude": "37.53234", "longitude": "-122.32735"}]
1076153 September 16, 2020 - 21:35:00 UTC 37.55311 -122.32703 San Mateo 29 []
658053 October 14, 2019 - 20:50:19 UTC 37.5481 -122.32694 San Mateo 29 []

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [outages] (
   [id] INTEGER PRIMARY KEY,
   [outageStartTime] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [regionName] INTEGER REFERENCES [regionName]([id]),
   [outageDevices] TEXT
)
Powered by Datasette · Query took 363.954ms · About: About this site