outages

431 rows where regionName = 29 sorted by latitude descending

View and edit SQL

id outageStartTime latitude ▲ longitude regionName outageDevices
784566 February 09, 2020 - 21:45:25 UTC 37.58461 -122.33252 San Mateo 29 []
784567 February 09, 2020 - 21:45:25 UTC 37.58389 -122.33175 San Mateo 29 []
744272 December 17, 2019 - 17:05:48 UTC 37.58355 -122.31606 San Mateo 29 []
789495 February 12, 2020 - 18:40:23 UTC 37.58236 -122.32938 San Mateo 29 []
743906 December 17, 2019 - 04:13:03 UTC 37.58189 -122.31538 San Mateo 29 []
723750 November 29, 2019 - 23:35:00 UTC 37.58164 -122.32014 San Mateo 29 [{"latitude": "37.5713", "longitude": "-122.32588"}, {"latitude": "37.58838", "longitude": "-122.32436"}, {"latitude": "37.57852", "longitude": "-122.34652"}, {"latitude": "37.57624", "longitude": "-122.34974"}, {"latitude": "37.57422", "longitude": "-122.34844"}]
782501 February 09, 2020 - 18:53:00 UTC 37.58164 -122.32014 San Mateo 29 [{"latitude": "37.5713", "longitude": "-122.32588"}, {"latitude": "37.58838", "longitude": "-122.32436"}, {"latitude": "37.57852", "longitude": "-122.34652"}, {"latitude": "37.57624", "longitude": "-122.34974"}, {"latitude": "37.57422", "longitude": "-122.34844"}]
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 []
743908 December 17, 2019 - 04:14:00 UTC 37.58099 -122.31627 San Mateo 29 [{"latitude": "37.57977", "longitude": "-122.31831"}, {"latitude": "37.58036", "longitude": "-122.31559"}, {"latitude": "37.58106", "longitude": "-122.31702"}]
729098 December 04, 2019 - 01:44:22 UTC 37.58069 -122.32012 San Mateo 29 []
743904 December 17, 2019 - 04:13:00 UTC 37.5806 -122.31552 San Mateo 29 []
730669 December 05, 2019 - 21:01:28 UTC 37.58014 -122.32686 San Mateo 29 []
735721 December 10, 2019 - 20:51:19 UTC 37.58014 -122.32686 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 []
743900 December 17, 2019 - 04:11:21 UTC 37.57922 -122.31565 San Mateo 29 []
743914 December 17, 2019 - 04:20:00 UTC 37.57922 -122.31909 San Mateo 29 []
702126 November 07, 2019 - 22:59:06 UTC 37.57916 -122.32103 San Mateo 29 []
784603 February 09, 2020 - 21:45:27 UTC 37.57908 -122.33463 San Mateo 29 []
700917 November 06, 2019 - 19:23:27 UTC 37.5789 -122.31821 San Mateo 29 []
784602 February 09, 2020 - 21:45:27 UTC 37.57857 -122.33407 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"}]
706302 November 13, 2019 - 22:46:24 UTC 37.57832 -122.33314 San Mateo 29 []
726306 December 01, 2019 - 23:56:39 UTC 37.57832 -122.32584 San Mateo 29 []
784601 February 09, 2020 - 21:45:27 UTC 37.57765 -122.33338 San Mateo 29 []
730316 December 05, 2019 - 16:37:25 UTC 37.57756 -122.32052 San Mateo 29 []
680579 October 25, 2019 - 22:27:00 UTC 37.57705 -122.32446 San Mateo 29 []
784599 February 09, 2020 - 21:45:27 UTC 37.57684 -122.33249 San Mateo 29 []
655921 October 14, 2019 - 16:03:55 UTC 37.57682 -122.32 San Mateo 29 []
713771 November 24, 2019 - 16:56:15 UTC 37.57682 -122.32 San Mateo 29 []
708476 November 17, 2019 - 01:36:21 UTC 37.57672 -122.31846 San Mateo 29 []
713770 November 24, 2019 - 16:56:15 UTC 37.57669 -122.31933 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 []
659867 October 15, 2019 - 22:17:37 UTC 37.57647 -122.32212 San Mateo 29 []
680316 October 25, 2019 - 16:31:35 UTC 37.57647 -122.32212 San Mateo 29 []
787696 February 10, 2020 - 22:11:41 UTC 37.57627 -122.33408 San Mateo 29 []
784589 February 09, 2020 - 21:45:26 UTC 37.57623 -122.33217 San Mateo 29 []
778799 February 06, 2020 - 00:57:22 UTC 37.57617 -122.32491 San Mateo 29 []
784098 February 09, 2020 - 20:57:22 UTC 37.57617 -122.32491 San Mateo 29 []
784569 February 09, 2020 - 18:58:02 UTC 37.57612 -122.34061 San Mateo 29 []
784590 February 09, 2020 - 21:45:26 UTC 37.57601 -122.33063 San Mateo 29 []
784587 February 09, 2020 - 21:45:26 UTC 37.57568 -122.33307 San Mateo 29 []
680324 October 25, 2019 - 16:35:08 UTC 37.57567 -122.3151 San Mateo 29 []
784597 February 09, 2020 - 21:45:27 UTC 37.57537 -122.33084 San Mateo 29 []
706895 November 14, 2019 - 19:55:06 UTC 37.57526 -122.34023 San Mateo 29 []
784596 February 09, 2020 - 21:45:26 UTC 37.57525 -122.33071 San Mateo 29 []
699537 November 05, 2019 - 00:02:42 UTC 37.57504 -122.31903 San Mateo 29 []
647745 October 09, 2019 - 03:38:00 UTC 37.57472 -122.32829 San Mateo 29 []
789094 February 12, 2020 - 02:07:13 UTC 37.57472 -122.32829 San Mateo 29 []
782699 February 09, 2020 - 19:04:41 UTC 37.5747 -122.34114 San Mateo 29 []
671075 October 19, 2019 - 12:10:07 UTC 37.57464 -122.32013 San Mateo 29 []
691349 October 28, 2019 - 15:02:11 UTC 37.57454 -122.33509 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 []
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 []
782365 February 09, 2020 - 18:40:48 UTC 37.57346 -122.32058 San Mateo 29 []
708158 November 16, 2019 - 16:38:37 UTC 37.57337 -122.32745 San Mateo 29 []
708869 November 18, 2019 - 07:59:41 UTC 37.57328 -122.31866 San Mateo 29 []
719514 November 27, 2019 - 08:07:04 UTC 37.57328 -122.31866 San Mateo 29 []
723578 November 29, 2019 - 19:47:19 UTC 37.57328 -122.31866 San Mateo 29 []
723861 November 30, 2019 - 03:09:49 UTC 37.57328 -122.31866 San Mateo 29 []
723934 November 30, 2019 - 06:37:45 UTC 37.57328 -122.31866 San Mateo 29 []
710470 November 20, 2019 - 02:12:59 UTC 37.57321 -122.33466 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 []
726420 December 02, 2019 - 01:02:41 UTC 37.57272 -122.32613 San Mateo 29 []
635824 October 02, 2019 - 15:49:11 UTC 37.57242 -122.33075 San Mateo 29 []
782774 February 09, 2020 - 19:11:00 UTC 37.57207 -122.32543 San Mateo 29 []
790612 February 14, 2020 - 00:22:45 UTC 37.57168 -122.30105 San Mateo 29 []
784389 February 09, 2020 - 21:31:42 UTC 37.57106 -122.30839 San Mateo 29 []
738296 December 13, 2019 - 16:44:53 UTC 37.57071 -122.30019 San Mateo 29 []
743253 December 16, 2019 - 19:42:38 UTC 37.57071 -122.30019 San Mateo 29 []
712446 November 21, 2019 - 22:52:45 UTC 37.57065 -122.32809 San Mateo 29 []
738674 December 13, 2019 - 23:02:14 UTC 37.57055 -122.3263 San Mateo 29 []
733715 December 08, 2019 - 19:29:37 UTC 37.57048 -122.32057 San Mateo 29 []
668258 October 18, 2019 - 16:21:20 UTC 37.57033 -122.34053 San Mateo 29 []
781830 February 09, 2020 - 17:48:37 UTC 37.57017 -122.31096 San Mateo 29 []
632115 September 30, 2019 - 20:08:17 UTC 37.56994 -122.31673 San Mateo 29 []
790661 February 14, 2020 - 02:05:21 UTC 37.56963 -122.30687 San Mateo 29 []
733178 December 08, 2019 - 00:51:59 UTC 37.56946 -122.32823 San Mateo 29 []
633773 October 01, 2019 - 15:45:58 UTC 37.56931 -122.30385 San Mateo 29 []
659747 October 15, 2019 - 19:57:05 UTC 37.56905 -122.34843 San Mateo 29 []
708937 November 18, 2019 - 15:13:14 UTC 37.56899 -122.30183 San Mateo 29 []
738342 December 13, 2019 - 17:09:36 UTC 37.56899 -122.30183 San Mateo 29 []
665714 October 17, 2019 - 19:27:25 UTC 37.56895 -122.33731 San Mateo 29 []
706477 November 14, 2019 - 03:59:16 UTC 37.56893 -122.31239 San Mateo 29 []
708532 November 17, 2019 - 06:42:17 UTC 37.56856 -122.30133 San Mateo 29 []
670727 October 18, 2019 - 23:19:00 UTC 37.5685 -122.31448 San Mateo 29 []
661774 October 16, 2019 - 19:59:43 UTC 37.56828 -122.30775 San Mateo 29 []
714640 November 25, 2019 - 22:16:00 UTC 37.56826 -122.32385 San Mateo 29 []
697485 November 01, 2019 - 18:43:31 UTC 37.56806 -122.30893 San Mateo 29 []
698003 November 02, 2019 - 02:40:51 UTC 37.56806 -122.30893 San Mateo 29 []
698082 November 02, 2019 - 14:56:44 UTC 37.56806 -122.30893 San Mateo 29 []
686090 October 27, 2019 - 08:24:00 UTC 37.56796 -122.29915 San Mateo 29 []
789850 February 13, 2020 - 00:45:15 UTC 37.56751 -122.30581 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 312.988ms · About: About this site