pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

idoutageStartTimelatitudelongituderegionNameoutageDevices
1237521 January 28, 2021 - 03:56:00 UTC 37.66785 -121.26282 38 []
1182231 December 13, 2020 - 09:45:18 UTC 37.66694 -121.26503 38 []
675891 October 21, 2019 - 15:57:00 UTC 37.66527 -121.26688 38 [{"latitude": "37.66471", "longitude": "-121.26086"}, {"latitude": "37.66875", "longitude": "-121.26279"}, {"latitude": "37.66987", "longitude": "-121.26658"}, {"latitude": "37.66644", "longitude": "-121.26558"}]
1228173 January 27, 2021 - 04:49:53 UTC 37.67974 -121.26696 38 []
784005 February 09, 2020 - 20:42:27 UTC 37.68098 -121.26826 38 []
786313 February 09, 2020 - 20:42:27 UTC 37.68098 -121.26826 38 []
675893 October 21, 2019 - 15:56:00 UTC 37.66394 -121.26835 38 [{"latitude": "37.64701", "longitude": "-121.30427"}, {"latitude": "37.65048", "longitude": "-121.28383"}, {"latitude": "37.65894", "longitude": "-121.26691"}, {"latitude": "37.66521", "longitude": "-121.2704"}, {"latitude": "37.66163", "longitude": "-121.28598"}]
1182247 December 13, 2020 - 12:40:04 UTC 37.66278 -121.27015 38 []
725851 December 01, 2019 - 17:27:00 UTC 37.67546 -121.27119 38 []
727816 December 02, 2019 - 23:19:44 UTC 37.67899 -121.27252 38 []
1216999 January 19, 2021 - 20:24:44 UTC 37.67781 -121.27256 38 []
1182245 December 13, 2020 - 12:02:35 UTC 37.67329 -121.27266 38 []
675861 October 21, 2019 - 15:53:10 UTC 37.67242 -121.27275 38 [{"latitude": "37.67329", "longitude": "-121.27266"}, {"latitude": "37.67396", "longitude": "-121.26929"}, {"latitude": "37.6751", "longitude": "-121.26604"}, {"latitude": "37.67464", "longitude": "-121.26935"}]
1155930 November 29, 2020 - 22:02:50 UTC 37.67242 -121.27275 38 [{"latitude": "37.67329", "longitude": "-121.27266"}, {"latitude": "37.67396", "longitude": "-121.26929"}, {"latitude": "37.6751", "longitude": "-121.26604"}, {"latitude": "37.67464", "longitude": "-121.26935"}]
675900 October 21, 2019 - 16:06:38 UTC 37.67254 -121.27342 38 []
717243 November 27, 2019 - 02:20:25 UTC 37.68086 -121.27362 38 []
734741 December 09, 2019 - 21:31:38 UTC 37.68086 -121.27362 38 []
785847 February 10, 2020 - 01:12:15 UTC 37.68086 -121.27362 38 []
785601 February 10, 2020 - 00:22:57 UTC 37.67943 -121.2745 38 []
1089653 September 23, 2020 - 18:45:31 UTC 37.67943 -121.2745 38 []
1137708 November 06, 2020 - 21:22:32 UTC 37.67879 -121.27542 38 []
1249904 February 07, 2021 - 02:21:42 UTC 37.67879 -121.27542 38 []
714607 November 25, 2019 - 21:53:34 UTC 37.68347 -121.2763 38 []
718262 November 27, 2019 - 04:03:21 UTC 37.67816 -121.27635 38 []
1200520 December 29, 2020 - 04:25:35 UTC 37.67816 -121.27635 38 []
1221659 January 23, 2021 - 17:02:56 UTC 37.67816 -121.27635 38 []
1251438 February 09, 2021 - 17:37:51 UTC 37.67816 -121.27635 38 []
1260043 February 23, 2021 - 16:49:03 UTC 37.67816 -121.27635 38 []
1182548 December 13, 2020 - 19:45:24 UTC 37.67991 -121.27682 38 []
1260177 February 23, 2021 - 17:59:27 UTC 37.69825 -121.27742 38 []
1090995 September 24, 2020 - 16:17:00 UTC 37.67695 -121.27793 38 [{"latitude": "37.67444", "longitude": "-121.27315"}, {"latitude": "37.67469", "longitude": "-121.27182"}, {"latitude": "37.67539", "longitude": "-121.26975"}, {"latitude": "37.67838", "longitude": "-121.26647"}, {"latitude": "37.67981", "longitude": "-121.26517"}, {"latitude": "37.68643", "longitude": "-121.2793"}, {"latitude": "37.68581", "longitude": "-121.28114"}, {"latitude": "37.68512", "longitude": "-121.28262"}, {"latitude": "37.68464", "longitude": "-121.28351"}, {"latitude": "37.68235", "longitude": "-121.28238"}, {"latitude": "37.67702", "longitude": "-121.27786"}, {"latitude": "37.675", "longitude": "-121.27442"}]
691318 October 28, 2019 - 14:26:26 UTC 37.67259 -121.27797 38 []
676742 October 22, 2019 - 16:17:45 UTC 37.67982 -121.27826 38 []
1247777 February 04, 2021 - 17:39:46 UTC 37.68086 -121.27848 38 []
709881 November 19, 2019 - 16:30:33 UTC 37.68335 -121.27883 38 []
1179177 December 11, 2020 - 20:25:53 UTC 37.68512 -121.27979 38 []
717267 November 27, 2019 - 02:23:40 UTC 37.6829 -121.28007 38 []
1091695 September 24, 2020 - 22:55:17 UTC 37.68059 -121.28043 38 []
717508 November 27, 2019 - 02:46:06 UTC 37.68327 -121.28093 38 []
723810 November 30, 2019 - 00:55:19 UTC 37.68327 -121.28093 38 []
1226570 January 27, 2021 - 00:59:16 UTC 37.68581 -121.28114 38 []
1180814 December 12, 2020 - 15:16:57 UTC 37.66507 -121.28775 38 []
1221151 January 22, 2021 - 22:11:29 UTC 37.63031 -121.28794 38 []
729657 December 04, 2019 - 18:22:40 UTC 37.6339 -121.29028 38 []
1191920 December 17, 2020 - 15:40:00 UTC 37.66718 -121.29702 38 []
1234800 January 27, 2021 - 18:24:42 UTC 37.62978 -121.29712 38 []
1140766 November 10, 2020 - 08:17:00 UTC 37.62319 -121.30078 38 []
655892 October 14, 2019 - 15:45:00 UTC 37.66743 -121.30146 38 []
1140758 November 10, 2020 - 08:08:19 UTC 37.62264 -121.30181 38 []
779294 February 06, 2020 - 19:18:12 UTC 37.74978 -121.30259 38 []
1093799 September 26, 2020 - 16:33:12 UTC 37.72837 -121.30344 38 []
1070485 September 14, 2020 - 23:55:08 UTC 37.72781 -121.30388 38 []
1077787 September 17, 2020 - 16:24:59 UTC 37.77245 -121.30472 38 []
1093801 September 26, 2020 - 16:33:25 UTC 37.72675 -121.30472 38 []
1104333 October 01, 2020 - 19:12:11 UTC 37.77245 -121.30472 38 []
1113143 October 08, 2020 - 01:17:00 UTC 37.69551 -121.30615 38 []
1113157 October 08, 2020 - 01:17:00 UTC 37.69551 -121.30615 38 []
1093800 September 26, 2020 - 16:33:25 UTC 37.72431 -121.30667 38 []
736610 December 11, 2019 - 21:36:48 UTC 37.70749 -121.30734 38 []
1224711 January 25, 2021 - 22:28:00 UTC 37.77421 -121.30771 38 []
1098373 September 29, 2020 - 16:55:20 UTC 37.71124 -121.31163 38 []
1225620 January 26, 2021 - 16:52:00 UTC 37.77087 -121.3122 38 [{"latitude": "37.76058", "longitude": "-121.31091"}, {"latitude": "37.7627", "longitude": "-121.31111"}, {"latitude": "37.76401", "longitude": "-121.31794"}, {"latitude": "37.76302", "longitude": "-121.31958"}, {"latitude": "37.76108", "longitude": "-121.31869"}]
692300 October 28, 2019 - 23:41:12 UTC 37.67138 -121.31536 38 []
1257524 February 19, 2021 - 00:39:02 UTC 37.67426 -121.3154 38 []
1113142 October 08, 2020 - 01:16:59 UTC 37.69648 -121.31863 38 []
1113159 October 08, 2020 - 01:16:59 UTC 37.69648 -121.31863 38 []
693627 October 29, 2019 - 17:13:25 UTC 37.60159 -121.32122 38 []
1112003 October 06, 2020 - 17:08:30 UTC 37.60159 -121.32122 38 []
1191885 December 17, 2020 - 14:39:45 UTC 37.60159 -121.32122 38 []
1200007 December 28, 2020 - 17:13:05 UTC 37.60159 -121.32122 38 []
1200685 December 29, 2020 - 17:38:29 UTC 37.66735 -121.32144 38 [{"latitude": "37.66007", "longitude": "-121.32452"}, {"latitude": "37.66735", "longitude": "-121.3219"}, {"latitude": "37.66781", "longitude": "-121.32207"}, {"latitude": "37.66939", "longitude": "-121.32354"}, {"latitude": "37.66986", "longitude": "-121.33021"}, {"latitude": "37.66846", "longitude": "-121.33547"}, {"latitude": "37.66662", "longitude": "-121.33863"}]
1201176 December 30, 2020 - 16:29:45 UTC 37.6018 -121.32176 38 []
1113145 October 08, 2020 - 01:17:15 UTC 37.69647 -121.32181 38 []
1267974 March 04, 2021 - 21:03:21 UTC 37.63097 -121.32343 38 []
721028 November 27, 2019 - 18:11:00 UTC 37.6443 -121.32434 38 []
787300 February 10, 2020 - 18:18:04 UTC 37.6694 -121.3245 38 []
699485 November 04, 2019 - 23:07:21 UTC 37.67262 -121.32454 38 []
1113176 October 08, 2020 - 02:15:00 UTC 37.69334 -121.32473 38 []
1113141 October 08, 2020 - 01:17:00 UTC 37.69603 -121.32475 38 []
1113144 October 08, 2020 - 01:17:00 UTC 37.69574 -121.32475 38 [{"latitude": "37.68277", "longitude": "-121.31706"}, {"latitude": "37.69498", "longitude": "-121.32474"}, {"latitude": "37.68934", "longitude": "-121.32472"}, {"latitude": "37.68694", "longitude": "-121.32471"}]
1113156 October 08, 2020 - 01:17:00 UTC 37.69603 -121.32475 38 []
1123451 October 22, 2020 - 17:56:15 UTC 37.6388 -121.32507 38 []
1241417 January 29, 2021 - 17:53:34 UTC 37.66733 -121.32515 38 []
1180846 December 12, 2020 - 15:52:00 UTC 37.67094 -121.32598 38 []
1211837 January 17, 2021 - 20:29:49 UTC 37.67094 -121.32598 38 []
1180858 December 12, 2020 - 15:55:00 UTC 37.67364 -121.32627 38 []
1164749 December 05, 2020 - 18:44:02 UTC 37.66732 -121.3268 38 []
698723 November 03, 2019 - 22:14:45 UTC 37.72343 -121.32719 38 []
725477 December 01, 2019 - 07:15:10 UTC 37.6673 -121.32849 38 [{"latitude": "37.66662", "longitude": "-121.33863"}, {"latitude": "37.6673", "longitude": "-121.32856"}, {"latitude": "37.66846", "longitude": "-121.33547"}]
1268556 March 05, 2021 - 16:34:00 UTC 37.59446 -121.32958 38 [{"latitude": "37.58209", "longitude": "-121.32047"}, {"latitude": "37.58833", "longitude": "-121.32378"}, {"latitude": "37.58761", "longitude": "-121.32378"}, {"latitude": "37.5849", "longitude": "-121.32373"}]
1140751 November 10, 2020 - 08:08:01 UTC 37.59447 -121.33102 38 []
1201405 December 30, 2020 - 22:07:32 UTC 37.59447 -121.33102 38 []
779419 February 06, 2020 - 20:40:09 UTC 37.72915 -121.33219 38 []
1258660 February 20, 2021 - 22:30:46 UTC 37.72915 -121.33219 38 []
698170 November 02, 2019 - 16:31:55 UTC 37.63853 -121.3334 38 []
1140764 November 10, 2020 - 08:15:36 UTC 37.59445 -121.33428 38 [{"latitude": "37.57535", "longitude": "-121.35823"}, {"latitude": "37.58338", "longitude": "-121.33055"}, {"latitude": "37.596", "longitude": "-121.33702"}, {"latitude": "37.59091", "longitude": "-121.34234"}]
725825 December 01, 2019 - 16:55:00 UTC 37.76556 -121.335 38 []
1092293 September 25, 2020 - 16:38:50 UTC 37.596 -121.33702 38 []
1173574 December 09, 2020 - 18:42:04 UTC 37.71172 -121.34234 38 []
1255306 February 15, 2021 - 21:26:27 UTC 37.71134 -121.34245 38 []
1073258 September 15, 2020 - 22:28:42 UTC 37.7645 -121.34552 38 []