outages

438 rows where regionName = 29 sorted by latitude

View and edit SQL

id outageStartTime latitude ▼ longitude regionName outageDevices
701531 November 07, 2019 - 15:03:02 UTC 37.54581 -122.28051 San Mateo 29 []
702622 November 08, 2019 - 17:20:26 UTC 37.54581 -122.28051 San Mateo 29 []
702754 November 08, 2019 - 18:53:00 UTC 37.54581 -122.28051 San Mateo 29 []
702773 November 08, 2019 - 19:13:01 UTC 37.54581 -122.28051 San Mateo 29 []
702881 November 08, 2019 - 21:25:00 UTC 37.54581 -122.28051 San Mateo 29 []
703116 November 09, 2019 - 04:07:00 UTC 37.54581 -122.28051 San Mateo 29 []
703285 November 09, 2019 - 17:24:00 UTC 37.54581 -122.28051 San Mateo 29 []
703393 November 09, 2019 - 20:01:00 UTC 37.54581 -122.28051 San Mateo 29 []
703749 November 10, 2019 - 04:09:00 UTC 37.54581 -122.28051 San Mateo 29 []
680380 October 25, 2019 - 17:36:51 UTC 37.54596 -122.32998 San Mateo 29 []
664193 October 17, 2019 - 16:39:00 UTC 37.54601 -122.30897 San Mateo 29 [{"latitude": "37.5453", "longitude": "-122.30803"}, {"latitude": "37.54588", "longitude": "-122.30867"}, {"latitude": "37.5456", "longitude": "-122.30837"}]
666478 October 17, 2019 - 21:40:54 UTC 37.5461 -122.28464 San Mateo 29 []
677602 October 23, 2019 - 18:47:00 UTC 37.54616 -122.28338 San Mateo 29 [{"latitude": "37.53924", "longitude": "-122.28131"}, {"latitude": "37.53958", "longitude": "-122.2802"}, {"latitude": "37.54058", "longitude": "-122.27833"}, {"latitude": "37.54327", "longitude": "-122.2784"}, {"latitude": "37.54581", "longitude": "-122.28051"}, {"latitude": "37.54571", "longitude": "-122.28207"}, {"latitude": "37.54565", "longitude": "-122.28291"}, {"latitude": "37.54527", "longitude": "-122.2833"}, {"latitude": "37.54108", "longitude": "-122.283"}, {"latitude": "37.53983", "longitude": "-122.28186"}]
707311 November 15, 2019 - 15:56:00 UTC 37.54616 -122.28338 San Mateo 29 [{"latitude": "37.53924", "longitude": "-122.28131"}, {"latitude": "37.53958", "longitude": "-122.2802"}, {"latitude": "37.54058", "longitude": "-122.27833"}, {"latitude": "37.54327", "longitude": "-122.2784"}, {"latitude": "37.54581", "longitude": "-122.28051"}, {"latitude": "37.54571", "longitude": "-122.28207"}, {"latitude": "37.54565", "longitude": "-122.28291"}, {"latitude": "37.54527", "longitude": "-122.2833"}, {"latitude": "37.54108", "longitude": "-122.283"}, {"latitude": "37.53983", "longitude": "-122.28186"}]
675834 October 21, 2019 - 15:36:02 UTC 37.54632 -122.28298 San Mateo 29 []
664379 October 17, 2019 - 17:02:00 UTC 37.54638 -122.30995 San Mateo 29 []
664993 October 17, 2019 - 17:57:00 UTC 37.54638 -122.30995 San Mateo 29 []
717854 November 27, 2019 - 03:21:31 UTC 37.54658 -122.28382 San Mateo 29 []
1078387 September 17, 2020 - 18:48:10 UTC 37.54679 -122.31598 San Mateo 29 []
647615 October 08, 2019 - 23:23:47 UTC 37.54701 -122.31512 San Mateo 29 [{"latitude": "37.53611", "longitude": "-122.32305"}, {"latitude": "37.54571", "longitude": "-122.31408"}, {"latitude": "37.54868", "longitude": "-122.31284"}, {"latitude": "37.5489", "longitude": "-122.31311"}, {"latitude": "37.54896", "longitude": "-122.3138"}, {"latitude": "37.54868", "longitude": "-122.31534"}, {"latitude": "37.54843", "longitude": "-122.31636"}, {"latitude": "37.54533", "longitude": "-122.32688"}, {"latitude": "37.54266", "longitude": "-122.33206"}, {"latitude": "37.54033", "longitude": "-122.33513"}, {"latitude": "37.53738", "longitude": "-122.32774"}, {"latitude": "37.53665", "longitude": "-122.32535"}]
691310 October 28, 2019 - 14:18:00 UTC 37.54701 -122.31512 San Mateo 29 [{"latitude": "37.53611", "longitude": "-122.32305"}, {"latitude": "37.54571", "longitude": "-122.31408"}, {"latitude": "37.54868", "longitude": "-122.31284"}, {"latitude": "37.5489", "longitude": "-122.31311"}, {"latitude": "37.54896", "longitude": "-122.3138"}, {"latitude": "37.54868", "longitude": "-122.31534"}, {"latitude": "37.54843", "longitude": "-122.31636"}, {"latitude": "37.54533", "longitude": "-122.32688"}, {"latitude": "37.54266", "longitude": "-122.33206"}, {"latitude": "37.54033", "longitude": "-122.33513"}, {"latitude": "37.53738", "longitude": "-122.32774"}, {"latitude": "37.53665", "longitude": "-122.32535"}]
782006 February 09, 2020 - 18:05:03 UTC 37.54717 -122.32969 San Mateo 29 []
778798 February 06, 2020 - 00:56:18 UTC 37.54739 -122.32597 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 []
658053 October 14, 2019 - 20:50:19 UTC 37.5481 -122.32694 San Mateo 29 []
730827 December 05, 2019 - 23:50:14 UTC 37.5483 -122.2892 San Mateo 29 []
1072074 September 15, 2020 - 18:39:16 UTC 37.54833 -122.32347 San Mateo 29 []
732252 December 07, 2019 - 14:58:00 UTC 37.5489 -122.33931 San Mateo 29 []
779660 February 07, 2020 - 01:53:15 UTC 37.54896 -122.32239 San Mateo 29 []
781961 February 09, 2020 - 18:00:36 UTC 37.54896 -122.32239 San Mateo 29 []
712167 November 21, 2019 - 17:36:00 UTC 37.549 -122.29036 San Mateo 29 []
720051 November 27, 2019 - 13:22:21 UTC 37.54917 -122.31017 San Mateo 29 []
728804 December 03, 2019 - 20:20:06 UTC 37.54917 -122.30663 San Mateo 29 []
737925 December 13, 2019 - 02:04:41 UTC 37.54917 -122.30663 San Mateo 29 []
737940 December 13, 2019 - 03:21:00 UTC 37.54917 -122.30663 San Mateo 29 []
737955 December 13, 2019 - 04:29:00 UTC 37.54917 -122.30663 San Mateo 29 []
644687 October 05, 2019 - 18:07:19 UTC 37.54939 -122.28965 San Mateo 29 []
1072834 September 15, 2020 - 21:10:21 UTC 37.54956 -122.29694 San Mateo 29 []
732148 December 07, 2019 - 12:17:55 UTC 37.54961 -122.33893 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 []
708108 November 16, 2019 - 15:18:00 UTC 37.54963 -122.32252 San Mateo 29 []
702153 November 07, 2019 - 23:42:42 UTC 37.5498 -122.32515 San Mateo 29 []
718536 November 27, 2019 - 04:36:05 UTC 37.54986 -122.29917 San Mateo 29 []
732147 December 07, 2019 - 12:18:00 UTC 37.54991 -122.33834 San Mateo 29 []
729245 December 04, 2019 - 13:04:54 UTC 37.55 -122.30936 San Mateo 29 []
729266 December 04, 2019 - 13:04:54 UTC 37.55 -122.30936 San Mateo 29 []
729307 December 04, 2019 - 14:46:22 UTC 37.55 -122.30936 San Mateo 29 []
729506 December 04, 2019 - 17:03:58 UTC 37.55 -122.30936 San Mateo 29 []
729754 December 04, 2019 - 19:39:56 UTC 37.55 -122.30936 San Mateo 29 []
721133 November 27, 2019 - 18:35:33 UTC 37.55004 -122.29836 San Mateo 29 []
722114 November 28, 2019 - 01:45:00 UTC 37.55004 -122.29836 San Mateo 29 []
736318 December 11, 2019 - 17:31:45 UTC 37.55015 -122.33766 San Mateo 29 []
643399 October 04, 2019 - 17:22:31 UTC 37.55025 -122.29107 San Mateo 29 []
721494 November 27, 2019 - 20:14:00 UTC 37.55032 -122.29916 San Mateo 29 [{"latitude": "37.55036", "longitude": "-122.2973"}, {"latitude": "37.55133", "longitude": "-122.29921"}, {"latitude": "37.55081", "longitude": "-122.2987"}]
706215 November 13, 2019 - 20:52:27 UTC 37.55036 -122.2973 San Mateo 29 []
718534 November 27, 2019 - 04:35:05 UTC 37.55036 -122.2973 San Mateo 29 []
786305 February 10, 2020 - 03:49:35 UTC 37.55036 -122.2973 San Mateo 29 []
1065534 September 12, 2020 - 15:46:21 UTC 37.55049 -122.28953 San Mateo 29 []
651524 October 09, 2019 - 23:25:15 UTC 37.55058 -122.30588 San Mateo 29 []
718527 November 27, 2019 - 04:35:00 UTC 37.55081 -122.2987 San Mateo 29 []
647699 October 09, 2019 - 01:52:00 UTC 37.55087 -122.31871 San Mateo 29 []
647797 October 09, 2019 - 06:14:54 UTC 37.55087 -122.31871 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"}]
1062174 September 09, 2020 - 20:40:52 UTC 37.5511 -122.30438 San Mateo 29 []
1062755 September 10, 2020 - 15:35:53 UTC 37.5511 -122.30438 San Mateo 29 []
647793 October 09, 2019 - 06:05:29 UTC 37.55112 -122.28621 San Mateo 29 []
712558 November 22, 2019 - 01:38:16 UTC 37.55142 -122.33608 San Mateo 29 []
635436 October 02, 2019 - 01:14:02 UTC 37.55162 -122.32408 San Mateo 29 []
650466 October 09, 2019 - 12:54:00 UTC 37.55162 -122.32408 San Mateo 29 []
744500 December 17, 2019 - 19:05:39 UTC 37.55162 -122.32408 San Mateo 29 []
781924 February 09, 2020 - 17:54:00 UTC 37.55165 -122.29251 San Mateo 29 [{"latitude": "37.52959", "longitude": "-122.34764"}, {"latitude": "37.53026", "longitude": "-122.34467"}, {"latitude": "37.55305", "longitude": "-122.30005"}, {"latitude": "37.55351", "longitude": "-122.29915"}, {"latitude": "37.5548", "longitude": "-122.29902"}, {"latitude": "37.55509", "longitude": "-122.29912"}, {"latitude": "37.56457", "longitude": "-122.30826"}, {"latitude": "37.56512", "longitude": "-122.30882"}, {"latitude": "37.56544", "longitude": "-122.30937"}, {"latitude": "37.57544", "longitude": "-122.36055"}, {"latitude": "37.57177", "longitude": "-122.3827"}, {"latitude": "37.56676", "longitude": "-122.38795"}, {"latitude": "37.56573", "longitude": "-122.38728"}, {"latitude": "37.53231", "longitude": "-122.36409"}]
647707 October 09, 2019 - 02:28:00 UTC 37.55167 -122.32196 San Mateo 29 []
718541 November 27, 2019 - 04:33:00 UTC 37.55171 -122.29226 San Mateo 29 [{"latitude": "37.53806", "longitude": "-122.29521"}, {"latitude": "37.53905", "longitude": "-122.29269"}, {"latitude": "37.53957", "longitude": "-122.29189"}, {"latitude": "37.53983", "longitude": "-122.29149"}, {"latitude": "37.54262", "longitude": "-122.28785"}, {"latitude": "37.55036", "longitude": "-122.2973"}, {"latitude": "37.55133", "longitude": "-122.29921"}, {"latitude": "37.55172", "longitude": "-122.30087"}, {"latitude": "37.55184", "longitude": "-122.30196"}, {"latitude": "37.55198", "longitude": "-122.30439"}, {"latitude": "37.55151", "longitude": "-122.30613"}, {"latitude": "37.54899", "longitude": "-122.31155"}, {"latitude": "37.54347", "longitude": "-122.30931"}, {"latitude": "37.54299", "longitude": "-122.30911"}, {"latitude": "37.54157", "longitude": "-122.30569"}, {"latitude": "37.5388", "longitude": "-122.29889"}]
647628 October 08, 2019 - 23:47:50 UTC 37.55186 -122.31353 San Mateo 29 []
724789 December 01, 2019 - 01:26:21 UTC 37.55186 -122.31353 San Mateo 29 []
677484 October 23, 2019 - 16:38:25 UTC 37.55188 -122.3141 San Mateo 29 []
686434 October 27, 2019 - 09:46:03 UTC 37.552 -122.33248 San Mateo 29 []
701005 November 06, 2019 - 20:39:46 UTC 37.55226 -122.32804 San Mateo 29 []
647623 October 08, 2019 - 23:31:48 UTC 37.55249 -122.31487 San Mateo 29 []
724794 December 01, 2019 - 01:26:22 UTC 37.55249 -122.31487 San Mateo 29 []
724830 December 01, 2019 - 01:32:00 UTC 37.55252 -122.31212 San Mateo 29 []
647618 October 08, 2019 - 23:26:17 UTC 37.55278 -122.3133 San Mateo 29 [{"latitude": "37.54811", "longitude": "-122.32026"}, {"latitude": "37.549", "longitude": "-122.31715"}, {"latitude": "37.55202", "longitude": "-122.31259"}, {"latitude": "37.56259", "longitude": "-122.31838"}, {"latitude": "37.56491", "longitude": "-122.32121"}, {"latitude": "37.5651", "longitude": "-122.32185"}, {"latitude": "37.56673", "longitude": "-122.3282"}, {"latitude": "37.56642", "longitude": "-122.32871"}, {"latitude": "37.564", "longitude": "-122.32829"}, {"latitude": "37.55983", "longitude": "-122.32713"}]
724769 December 01, 2019 - 00:46:25 UTC 37.55278 -122.3133 San Mateo 29 [{"latitude": "37.54811", "longitude": "-122.32026"}, {"latitude": "37.549", "longitude": "-122.31715"}, {"latitude": "37.55202", "longitude": "-122.31259"}, {"latitude": "37.56259", "longitude": "-122.31838"}, {"latitude": "37.56491", "longitude": "-122.32121"}, {"latitude": "37.5651", "longitude": "-122.32185"}, {"latitude": "37.56673", "longitude": "-122.3282"}, {"latitude": "37.56642", "longitude": "-122.32871"}, {"latitude": "37.564", "longitude": "-122.32829"}, {"latitude": "37.55983", "longitude": "-122.32713"}]
635790 October 02, 2019 - 15:33:15 UTC 37.55285 -122.32468 San Mateo 29 []
671102 October 19, 2019 - 14:35:00 UTC 37.55307 -122.29242 San Mateo 29 []
1076153 September 16, 2020 - 21:35:00 UTC 37.55311 -122.32703 San Mateo 29 []
654240 October 11, 2019 - 16:18:36 UTC 37.55328 -122.31822 San Mateo 29 []
654845 October 12, 2019 - 01:29:27 UTC 37.55328 -122.31822 San Mateo 29 []
1087320 September 22, 2020 - 17:37:19 UTC 37.55338 -122.32207 San Mateo 29 []
647629 October 08, 2019 - 23:47:56 UTC 37.5534 -122.31671 San Mateo 29 []
710754 November 20, 2019 - 15:17:57 UTC 37.55346 -122.32394 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"}]
706120 November 13, 2019 - 18:59:33 UTC 37.55364 -122.31549 San Mateo 29 []
654964 October 12, 2019 - 04:32:27 UTC 37.55374 -122.31755 San Mateo 29 []
712532 November 22, 2019 - 00:40:08 UTC 37.55396 -122.31418 San Mateo 29 []
733834 December 08, 2019 - 21:23:31 UTC 37.55407 -122.33376 San Mateo 29 []
691449 October 28, 2019 - 16:09:00 UTC 37.5541 -122.33535 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 813.754ms · About: About this site