pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutageStartTimelatitudelongituderegionNameoutageDevices
675155 October 21, 2019 - 14:48:44 UTC 38.58794 -121.63567 34 []
652788 October 10, 2019 - 16:53:39 UTC 38.74847 -121.66232 34 []
687963 October 27, 2019 - 18:08:44 UTC 38.75497 -121.66475 34 []
736248 December 11, 2019 - 16:57:00 UTC 38.59107 -121.66921 34 []
714412 November 25, 2019 - 20:01:02 UTC 38.71263 -121.67657 34 []
732542 December 07, 2019 - 18:44:22 UTC 38.74826 -121.67781 34 [{"latitude": "38.74847", "longitude": "-121.66232"}, {"latitude": "38.75497", "longitude": "-121.66475"}, {"latitude": "38.75825", "longitude": "-121.66824"}, {"latitude": "38.75844", "longitude": "-121.66943"}, {"latitude": "38.75896", "longitude": "-121.67511"}]
714409 November 25, 2019 - 20:00:11 UTC 38.72727 -121.67976 34 []
722640 November 28, 2019 - 15:24:00 UTC 38.72727 -121.67976 34 []
732941 December 07, 2019 - 21:25:00 UTC 38.74854 -121.68158 34 [{"latitude": "38.73152", "longitude": "-121.67595"}, {"latitude": "38.73422", "longitude": "-121.66035"}, {"latitude": "38.74317", "longitude": "-121.67063"}, {"latitude": "38.73325", "longitude": "-121.6782"}]
689460 October 27, 2019 - 21:28:46 UTC 38.77649 -121.68919 34 []
714408 November 25, 2019 - 20:00:11 UTC 38.72585 -121.69011 34 []
689736 October 27, 2019 - 21:57:58 UTC 38.78156 -121.69252 34 []
715076 November 26, 2019 - 16:17:39 UTC 38.78249 -121.69425 34 []
714473 November 25, 2019 - 20:47:00 UTC 38.73503 -121.6973 34 []
710200 November 19, 2019 - 20:19:58 UTC 38.60306 -121.70813 34 []
698387 November 03, 2019 - 00:39:05 UTC 38.67773 -121.71008 34 []
699730 November 05, 2019 - 12:24:00 UTC 38.67686 -121.71031 34 [{"latitude": "38.67647", "longitude": "-121.71038"}, {"latitude": "38.67724", "longitude": "-121.71033"}, {"latitude": "38.67693", "longitude": "-121.7178"}]
1071873 September 15, 2020 - 17:58:33 UTC 38.65796 -121.71425 34 []
686258 October 27, 2019 - 08:58:25 UTC 38.60494 -121.71465 34 []
686628 October 27, 2019 - 08:58:25 UTC 38.60494 -121.71465 34 []
786339 February 10, 2020 - 04:08:01 UTC 38.63761 -121.7209 34 []
786593 February 10, 2020 - 06:38:19 UTC 38.63761 -121.7209 34 []
714582 November 25, 2019 - 21:38:00 UTC 38.69173 -121.72773 34 [{"latitude": "38.6907", "longitude": "-121.70987"}, {"latitude": "38.69814", "longitude": "-121.72037"}, {"latitude": "38.69159", "longitude": "-121.71696"}]
686263 October 27, 2019 - 09:01:15 UTC 38.60798 -121.72812 34 []
687307 October 27, 2019 - 16:00:16 UTC 38.60798 -121.72812 34 []
697579 November 01, 2019 - 19:30:47 UTC 38.74135 -121.72925 34 [{"latitude": "38.74109", "longitude": "-121.72049"}, {"latitude": "38.74136", "longitude": "-121.72872"}, {"latitude": "38.74125", "longitude": "-121.72841"}]
735893 December 11, 2019 - 00:22:28 UTC 38.79244 -121.72947 34 []
690943 October 28, 2019 - 04:30:00 UTC 38.60798 -121.72958 34 [{"latitude": "38.60694", "longitude": "-121.72037"}, {"latitude": "38.60799", "longitude": "-121.72697"}, {"latitude": "38.60798", "longitude": "-121.72945"}]
744489 December 17, 2019 - 18:57:10 UTC 38.60798 -121.72958 34 [{"latitude": "38.60694", "longitude": "-121.72037"}, {"latitude": "38.60799", "longitude": "-121.72697"}, {"latitude": "38.60798", "longitude": "-121.72945"}]
686262 October 27, 2019 - 09:01:15 UTC 38.60794 -121.72967 34 []
687312 October 27, 2019 - 16:01:24 UTC 38.60794 -121.72967 34 []
744443 December 17, 2019 - 18:24:15 UTC 38.60794 -121.72967 34 []
1064251 September 11, 2020 - 16:02:36 UTC 38.77802 -121.73068 34 []
654356 October 11, 2019 - 18:04:17 UTC 38.67287 -121.73142 34 []
702110 November 07, 2019 - 22:41:04 UTC 38.65256 -121.73145 34 []
651067 October 09, 2019 - 20:36:11 UTC 38.65211 -121.73257 34 []
1081919 September 18, 2020 - 23:14:00 UTC 38.67231 -121.7358 34 []
1081953 September 18, 2020 - 23:14:00 UTC 38.67231 -121.7358 34 []
699287 November 04, 2019 - 19:19:36 UTC 38.68511 -121.73748 34 []
1081914 September 18, 2020 - 22:57:00 UTC 38.6717 -121.73785 34 [{"latitude": "38.67285", "longitude": "-121.73725"}, {"latitude": "38.67298", "longitude": "-121.73337"}, {"latitude": "38.67322", "longitude": "-121.73525"}, {"latitude": "38.67325", "longitude": "-121.73679"}]
728634 December 03, 2019 - 18:28:21 UTC 38.67633 -121.73798 34 []
686264 October 27, 2019 - 09:01:36 UTC 38.61752 -121.73816 34 []
736207 December 11, 2019 - 16:35:00 UTC 38.64919 -121.74199 34 []
737223 December 12, 2019 - 16:43:27 UTC 38.64919 -121.74199 34 []
734668 December 09, 2019 - 20:54:45 UTC 38.66778 -121.74612 34 []
1068573 September 14, 2020 - 16:18:00 UTC 38.77806 -121.74691 34 []
691240 October 28, 2019 - 12:39:00 UTC 38.6917 -121.74789 34 []
641775 October 03, 2019 - 23:32:48 UTC 38.67823 -121.74907 34 []
691513 October 28, 2019 - 16:24:57 UTC 38.69047 -121.74964 34 []
734356 December 09, 2019 - 17:33:00 UTC 38.77827 -121.75063 34 []
718316 November 27, 2019 - 02:08:47 UTC 38.59012 -121.75158 34 [{"latitude": "38.59046", "longitude": "-121.75174"}, {"latitude": "38.59919", "longitude": "-121.74926"}, {"latitude": "38.60104", "longitude": "-121.7526"}, {"latitude": "38.6023", "longitude": "-121.76396"}, {"latitude": "38.60252", "longitude": "-121.76638"}, {"latitude": "38.59677", "longitude": "-121.76368"}]
789452 February 12, 2020 - 18:00:33 UTC 38.59046 -121.75174 34 []
691241 October 28, 2019 - 12:47:00 UTC 38.69072 -121.752 34 []
691248 October 28, 2019 - 12:52:00 UTC 38.69226 -121.75221 34 []
717136 November 27, 2019 - 02:09:28 UTC 38.60104 -121.7526 34 []
686044 October 27, 2019 - 08:13:39 UTC 38.67475 -121.75413 34 []
732601 December 07, 2019 - 19:19:22 UTC 38.66187 -121.75441 34 []
688753 October 27, 2019 - 20:11:31 UTC 38.67276 -121.75514 34 []
695394 October 30, 2019 - 20:50:38 UTC 38.68093 -121.75626 34 []
696156 October 31, 2019 - 02:50:06 UTC 38.68093 -121.75626 34 []
696170 October 31, 2019 - 02:50:06 UTC 38.68093 -121.75626 34 []
691235 October 28, 2019 - 12:14:00 UTC 38.69133 -121.7576 34 []
1073707 September 16, 2020 - 09:00:00 UTC 38.67717 -121.75825 34 [{"latitude": "38.67587", "longitude": "-121.7584"}, {"latitude": "38.6769", "longitude": "-121.75866"}, {"latitude": "38.67598", "longitude": "-121.75938"}]
693601 October 29, 2019 - 17:11:41 UTC 38.68487 -121.75834 34 []
710490 November 20, 2019 - 03:03:10 UTC 38.70948 -121.75893 34 [{"latitude": "38.70475", "longitude": "-121.759"}, {"latitude": "38.70643", "longitude": "-121.7585"}, {"latitude": "38.70862", "longitude": "-121.75894"}]
704015 November 10, 2019 - 22:01:00 UTC 38.70862 -121.75894 34 []
710356 November 19, 2019 - 22:57:02 UTC 38.70862 -121.75894 34 []
710386 November 19, 2019 - 23:44:09 UTC 38.70862 -121.75894 34 []
737939 December 13, 2019 - 03:10:57 UTC 38.66503 -121.75905 34 []
650849 October 09, 2019 - 17:24:00 UTC 38.6783 -121.75917 34 [{"latitude": "38.67254", "longitude": "-121.79538"}, {"latitude": "38.67845", "longitude": "-121.76139"}, {"latitude": "38.68339", "longitude": "-121.76635"}, {"latitude": "38.68686", "longitude": "-121.77008"}, {"latitude": "38.69067", "longitude": "-121.79721"}, {"latitude": "38.6909", "longitude": "-121.79906"}, {"latitude": "38.68918", "longitude": "-121.80144"}, {"latitude": "38.68773", "longitude": "-121.80203"}, {"latitude": "38.68074", "longitude": "-121.80206"}, {"latitude": "38.6745", "longitude": "-121.7993"}, {"latitude": "38.67305", "longitude": "-121.79808"}]
694015 October 29, 2019 - 19:20:00 UTC 38.68465 -121.7592 34 []
691220 October 28, 2019 - 10:14:56 UTC 38.68409 -121.75921 34 []
691646 October 28, 2019 - 17:49:43 UTC 38.68428 -121.75921 34 []
690525 October 28, 2019 - 01:14:35 UTC 38.66941 -121.75927 34 []
686467 October 27, 2019 - 09:57:06 UTC 38.69381 -121.75929 34 []
690723 October 28, 2019 - 02:14:04 UTC 38.69381 -121.75929 34 []
686048 October 27, 2019 - 08:07:00 UTC 38.67831 -121.7593 34 [{"latitude": "38.68108", "longitude": "-121.76107"}, {"latitude": "38.68487", "longitude": "-121.75834"}, {"latitude": "38.68823", "longitude": "-121.76057"}, {"latitude": "38.70044", "longitude": "-121.78295"}, {"latitude": "38.69911", "longitude": "-121.79798"}, {"latitude": "38.69854", "longitude": "-121.802"}, {"latitude": "38.69348", "longitude": "-121.8036"}, {"latitude": "38.68595", "longitude": "-121.80242"}, {"latitude": "38.68153", "longitude": "-121.80163"}]
727217 December 02, 2019 - 16:55:12 UTC 38.67831 -121.7593 34 [{"latitude": "38.68108", "longitude": "-121.76107"}, {"latitude": "38.68487", "longitude": "-121.75834"}, {"latitude": "38.68823", "longitude": "-121.76057"}, {"latitude": "38.70044", "longitude": "-121.78295"}, {"latitude": "38.69911", "longitude": "-121.79798"}, {"latitude": "38.69854", "longitude": "-121.802"}, {"latitude": "38.69348", "longitude": "-121.8036"}, {"latitude": "38.68595", "longitude": "-121.80242"}, {"latitude": "38.68153", "longitude": "-121.80163"}]
685794 October 27, 2019 - 07:30:57 UTC 38.67831 -121.75934 34 [{"latitude": "38.67818", "longitude": "-121.71646"}, {"latitude": "38.67843", "longitude": "-121.71498"}, {"latitude": "38.70212", "longitude": "-121.67278"}, {"latitude": "38.70563", "longitude": "-121.66979"}, {"latitude": "38.71649", "longitude": "-121.66372"}, {"latitude": "38.72109", "longitude": "-121.66401"}, {"latitude": "38.73551", "longitude": "-121.684"}, {"latitude": "38.73102", "longitude": "-121.69605"}, {"latitude": "38.70557", "longitude": "-121.74197"}, {"latitude": "38.68165", "longitude": "-121.76037"}, {"latitude": "38.68069", "longitude": "-121.75946"}]
688199 October 27, 2019 - 18:45:00 UTC 38.67831 -121.75934 34 [{"latitude": "38.67818", "longitude": "-121.71646"}, {"latitude": "38.67843", "longitude": "-121.71498"}, {"latitude": "38.70212", "longitude": "-121.67278"}, {"latitude": "38.70563", "longitude": "-121.66979"}, {"latitude": "38.71649", "longitude": "-121.66372"}, {"latitude": "38.72109", "longitude": "-121.66401"}, {"latitude": "38.73551", "longitude": "-121.684"}, {"latitude": "38.73102", "longitude": "-121.69605"}, {"latitude": "38.70557", "longitude": "-121.74197"}, {"latitude": "38.68165", "longitude": "-121.76037"}, {"latitude": "38.68069", "longitude": "-121.75946"}]
691304 October 28, 2019 - 14:09:50 UTC 38.69141 -121.75943 34 []
633882 October 01, 2019 - 15:45:00 UTC 38.69174 -121.75947 34 []
687895 October 27, 2019 - 18:00:01 UTC 38.6915 -121.75992 34 []
729615 December 04, 2019 - 17:51:57 UTC 38.66308 -121.76003 34 []
691290 October 28, 2019 - 13:51:00 UTC 38.69349 -121.7604 34 []
686472 October 27, 2019 - 09:57:32 UTC 38.69196 -121.76054 34 []
687354 October 27, 2019 - 16:10:04 UTC 38.66876 -121.76132 34 []
734860 December 09, 2019 - 23:37:53 UTC 38.66876 -121.76132 34 []
686466 October 27, 2019 - 09:57:06 UTC 38.69233 -121.76158 34 []
691320 October 28, 2019 - 14:28:00 UTC 38.69233 -121.76158 34 []
734980 December 10, 2019 - 02:32:23 UTC 38.67177 -121.76206 34 []
686473 October 27, 2019 - 09:57:32 UTC 38.69175 -121.76225 34 []
669753 October 18, 2019 - 19:50:52 UTC 38.68403 -121.76227 34 []
1062789 September 10, 2020 - 16:16:01 UTC 38.66256 -121.7624 34 []
655199 October 12, 2019 - 18:24:15 UTC 38.69092 -121.76258 34 []
687276 October 27, 2019 - 15:46:48 UTC 38.68045 -121.7626 34 []
709109 November 18, 2019 - 17:08:03 UTC 38.67379 -121.7627 34 []
658981 October 15, 2019 - 16:34:48 UTC 38.68068 -121.76309 34 []
704355 November 11, 2019 - 18:23:07 UTC 38.66976 -121.76317 34 []
705036 November 12, 2019 - 19:16:45 UTC 38.66028 -121.76347 34 []
680796 October 26, 2019 - 16:16:26 UTC 38.68472 -121.76349 34 []
Powered by Datasette · Query took 26.605ms · About: About this site