pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutageStartTimelatitudelongituderegionNameoutageDevices
633524 October 01, 2019 - 11:26:51 UTC 37.29081 -121.95834 43 [{"latitude": "37.29132", "longitude": "-121.9585"}, {"latitude": "37.29177", "longitude": "-121.95685"}, {"latitude": "37.29439", "longitude": "-121.95733"}, {"latitude": "37.29446", "longitude": "-121.95998"}, {"latitude": "37.29377", "longitude": "-121.96015"}, {"latitude": "37.29283", "longitude": "-121.96013"}]
633526 October 01, 2019 - 11:28:11 UTC 37.29066 -121.95854 43 []
633528 October 01, 2019 - 11:31:53 UTC 37.29 -121.9594 43 []
633537 October 01, 2019 - 12:44:50 UTC 37.29243 -121.96658 43 []
633549 October 01, 2019 - 13:43:00 UTC 37.29066 -121.95854 43 []
633912 October 01, 2019 - 17:20:23 UTC 37.29407 -121.94072 43 []
633947 October 01, 2019 - 17:41:55 UTC 37.2844 -121.94634 43 []
636634 October 02, 2019 - 17:49:17 UTC 37.30129 -121.9409 43 []
638666 October 02, 2019 - 23:20:19 UTC 37.27298 -121.97336 43 []
638845 October 03, 2019 - 01:29:13 UTC 37.27943 -121.93996 43 []
642741 October 04, 2019 - 16:02:00 UTC 37.29065 -121.97348 43 [{"latitude": "37.28671", "longitude": "-121.97291"}, {"latitude": "37.28674", "longitude": "-121.9711"}, {"latitude": "37.28935", "longitude": "-121.96941"}, {"latitude": "37.29237", "longitude": "-121.97322"}, {"latitude": "37.28822", "longitude": "-121.97468"}, {"latitude": "37.28728", "longitude": "-121.97466"}, {"latitude": "37.28675", "longitude": "-121.97368"}]
643464 October 04, 2019 - 18:22:54 UTC 37.28964 -121.95635 43 []
643655 October 04, 2019 - 19:48:30 UTC 37.29038 -121.97432 43 []
643682 October 04, 2019 - 20:21:55 UTC 37.2834 -121.94884 43 []
644934 October 05, 2019 - 22:22:22 UTC 37.26513 -121.96736 43 []
645146 October 06, 2019 - 03:29:29 UTC 37.26513 -121.96736 43 []
646122 October 07, 2019 - 18:28:27 UTC 37.28964 -121.95635 43 []
647070 October 08, 2019 - 14:12:23 UTC 37.28635 -121.98042 43 []
647298 October 08, 2019 - 16:14:03 UTC 37.28988 -121.92487 43 []
647541 October 08, 2019 - 21:03:29 UTC 37.28709 -121.97957 43 []
647784 October 09, 2019 - 05:33:38 UTC 37.26412 -121.96746 43 []
648198 October 09, 2019 - 08:08:04 UTC 37.26434 -121.99085 43 []
654293 October 11, 2019 - 17:03:00 UTC 37.27653 -121.94241 43 []
654795 October 12, 2019 - 00:27:00 UTC 37.28584 -121.9473 43 []
655417 October 13, 2019 - 01:55:35 UTC 37.26407 -121.96971 43 []
655805 October 14, 2019 - 14:14:46 UTC 37.28635 -121.98042 43 []
656174 October 14, 2019 - 16:31:55 UTC 37.28617 -121.92431 43 []
656215 October 14, 2019 - 16:35:59 UTC 37.26986 -121.97143 43 []
658812 October 15, 2019 - 14:37:23 UTC 37.28883 -121.94372 43 []
658823 October 15, 2019 - 14:59:20 UTC 37.27145 -121.95156 43 []
659781 October 15, 2019 - 20:29:29 UTC 37.29203 -121.96343 43 []
659818 October 15, 2019 - 14:59:20 UTC 37.27145 -121.95156 43 []
664015 October 17, 2019 - 15:36:33 UTC 37.28216 -121.96036 43 []
667275 October 18, 2019 - 02:47:58 UTC 37.2879 -121.97265 43 []
667414 October 18, 2019 - 14:40:21 UTC 37.28495 -121.93039 43 []
670413 October 18, 2019 - 21:44:10 UTC 37.28419 -121.92258 43 []
670916 October 19, 2019 - 00:06:57 UTC 37.2879 -121.97265 43 []
671676 October 19, 2019 - 16:13:27 UTC 37.28271 -121.92581 43 []
674962 October 21, 2019 - 02:38:09 UTC 37.27264 -121.9607 43 []
675927 October 21, 2019 - 16:16:22 UTC 37.27182 -121.95155 43 [{"latitude": "37.27036", "longitude": "-121.95157"}, {"latitude": "37.27177", "longitude": "-121.95155"}, {"latitude": "37.27145", "longitude": "-121.95156"}, {"latitude": "37.27075", "longitude": "-121.95157"}]
679024 October 24, 2019 - 00:56:48 UTC 37.2913 -121.97015 43 []
679289 October 24, 2019 - 09:00:49 UTC 37.29105 -121.96964 43 [{"latitude": "37.29127", "longitude": "-121.96683"}, {"latitude": "37.29128", "longitude": "-121.96601"}, {"latitude": "37.2913", "longitude": "-121.96445"}, {"latitude": "37.29132", "longitude": "-121.9634"}, {"latitude": "37.29203", "longitude": "-121.96343"}, {"latitude": "37.29393", "longitude": "-121.96549"}, {"latitude": "37.29354", "longitude": "-121.97075"}, {"latitude": "37.29289", "longitude": "-121.97117"}, {"latitude": "37.29128", "longitude": "-121.9713"}]
690253 October 27, 2019 - 23:36:45 UTC 37.2697 -121.96689 43 []
690995 October 28, 2019 - 05:16:46 UTC 37.292 -121.94815 43 []
692253 October 28, 2019 - 23:24:34 UTC 37.27518 -121.96121 43 []
692870 October 29, 2019 - 09:36:37 UTC 37.29081 -121.95834 43 [{"latitude": "37.29132", "longitude": "-121.9585"}, {"latitude": "37.29177", "longitude": "-121.95685"}, {"latitude": "37.29439", "longitude": "-121.95733"}, {"latitude": "37.29446", "longitude": "-121.95998"}, {"latitude": "37.29377", "longitude": "-121.96015"}, {"latitude": "37.29283", "longitude": "-121.96013"}]
693231 October 29, 2019 - 15:23:06 UTC 37.28573 -121.94161 43 []
693402 October 29, 2019 - 16:08:55 UTC 37.27318 -121.98188 43 []
693466 October 29, 2019 - 16:37:00 UTC 37.28677 -121.93981 43 []
694034 October 29, 2019 - 19:54:39 UTC 37.28636 -121.94214 43 []
696920 October 31, 2019 - 21:40:31 UTC 37.26729 -121.96596 43 []
697005 October 31, 2019 - 23:06:33 UTC 37.2801 -121.95997 43 []
699057 November 04, 2019 - 16:55:36 UTC 37.27686 -121.9383 43 []
699476 November 04, 2019 - 22:48:57 UTC 37.27291 -121.96119 43 []
700212 November 05, 2019 - 22:29:06 UTC 37.28988 -121.96598 43 []
700522 November 06, 2019 - 15:50:59 UTC 37.29764 -121.93193 43 []
701288 November 07, 2019 - 01:51:39 UTC 37.29105 -121.94257 43 []
701420 November 07, 2019 - 08:38:00 UTC 37.29081 -121.95834 43 [{"latitude": "37.29132", "longitude": "-121.9585"}, {"latitude": "37.29177", "longitude": "-121.95685"}, {"latitude": "37.29439", "longitude": "-121.95733"}, {"latitude": "37.29446", "longitude": "-121.95998"}, {"latitude": "37.29377", "longitude": "-121.96015"}, {"latitude": "37.29283", "longitude": "-121.96013"}]
702805 November 08, 2019 - 19:45:07 UTC 37.27028 -121.94343 43 []
703296 November 09, 2019 - 17:29:51 UTC 37.3055 -121.94398 43 []
704897 November 12, 2019 - 17:44:23 UTC 37.26513 -121.96736 43 []
705631 November 13, 2019 - 04:21:13 UTC 37.27264 -121.9607 43 []
707888 November 15, 2019 - 23:23:14 UTC 37.27518 -121.96121 43 []
708009 November 16, 2019 - 03:40:02 UTC 37.28873 -121.9745 43 []
712017 November 21, 2019 - 16:29:03 UTC 37.29078 -121.92386 43 []
712021 November 21, 2019 - 16:38:25 UTC 37.26539 -121.96898 43 []
712129 November 21, 2019 - 17:22:41 UTC 37.27586 -121.94383 43 []
712678 November 22, 2019 - 15:57:08 UTC 37.26626 -121.95455 43 []
713748 November 24, 2019 - 15:17:00 UTC 37.29173 -121.93566 43 [{"latitude": "37.2677", "longitude": "-121.92283"}, {"latitude": "37.26792", "longitude": "-121.92014"}, {"latitude": "37.2731", "longitude": "-121.91919"}, {"latitude": "37.27567", "longitude": "-121.92034"}, {"latitude": "37.28927", "longitude": "-121.92735"}, {"latitude": "37.29017", "longitude": "-121.92807"}, {"latitude": "37.29134", "longitude": "-121.93412"}, {"latitude": "37.29021", "longitude": "-121.93447"}, {"latitude": "37.2777", "longitude": "-121.93378"}, {"latitude": "37.27327", "longitude": "-121.93336"}, {"latitude": "37.26906", "longitude": "-121.931"}, {"latitude": "37.26773", "longitude": "-121.92599"}, {"latitude": "37.2677", "longitude": "-121.9241"}]
720766 November 27, 2019 - 17:04:12 UTC 37.27865 -121.93569 43 []
722402 November 28, 2019 - 05:23:25 UTC 37.28299 -121.93402 43 []
722780 November 28, 2019 - 17:40:28 UTC 37.27818 -121.97687 43 []
723002 November 28, 2019 - 20:28:00 UTC 37.28283 -121.96383 43 []
723039 November 28, 2019 - 20:59:25 UTC 37.28283 -121.96383 43 []
724160 November 30, 2019 - 18:51:30 UTC 37.27864 -121.97803 43 []
724685 December 01, 2019 - 00:52:20 UTC 37.27282 -121.98082 43 []
724765 December 01, 2019 - 01:16:06 UTC 37.27342 -121.95978 43 []
725009 December 01, 2019 - 02:10:48 UTC 37.29518 -121.95368 43 []
725121 December 01, 2019 - 03:51:29 UTC 37.29164 -121.95266 43 []
725190 December 01, 2019 - 04:46:35 UTC 37.30217 -121.93892 43 []
725268 December 01, 2019 - 06:02:00 UTC 37.28162 -121.96387 43 []
725288 December 01, 2019 - 06:20:27 UTC 37.30381 -121.94445 43 []
725306 December 01, 2019 - 06:37:04 UTC 37.29158 -121.92435 43 []
725323 December 01, 2019 - 06:40:21 UTC 37.30081 -121.94529 43 []
725337 December 01, 2019 - 06:51:44 UTC 37.27864 -121.97803 43 []
725344 December 01, 2019 - 07:03:34 UTC 37.2915 -121.92576 43 []
725961 December 01, 2019 - 18:56:39 UTC 37.27864 -121.97803 43 []
726062 December 01, 2019 - 20:20:32 UTC 37.29164 -121.95266 43 []
726142 December 01, 2019 - 21:39:00 UTC 37.29164 -121.95266 43 []
726279 December 01, 2019 - 23:19:00 UTC 37.29164 -121.95266 43 []
726380 December 01, 2019 - 06:20:27 UTC 37.30381 -121.94445 43 []
727658 December 02, 2019 - 21:15:56 UTC 37.26776 -121.96756 43 []
727687 December 02, 2019 - 21:39:11 UTC 37.25777 -121.95039 43 []
728891 December 03, 2019 - 21:33:42 UTC 37.29392 -121.95742 43 []
729790 December 04, 2019 - 20:13:13 UTC 37.29281 -121.95265 43 []
730215 December 05, 2019 - 13:05:18 UTC 37.28577 -121.9356 43 []
730254 December 05, 2019 - 15:32:11 UTC 37.26651 -121.94499 43 []
730700 December 05, 2019 - 21:37:08 UTC 37.27178 -121.94457 43 []
730753 December 05, 2019 - 22:14:53 UTC 37.28024 -121.95922 43 []
730832 December 05, 2019 - 23:58:09 UTC 37.28769 -121.92266 43 []
731497 December 06, 2019 - 19:34:18 UTC 37.28656 -121.94598 43 []
Powered by Datasette · Query took 16.501ms · About: About this site