pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

idoutageStartTimelatitudelongituderegionNameoutageDevices
1064583 September 11, 2020 - 18:14:09 UTC 37.51598 -122.33514 29 []
691859 October 28, 2019 - 20:00:00 UTC 37.51599 -122.32972 29 []
683241 October 27, 2019 - 03:06:38 UTC 37.51714 -122.3356 29 [{"latitude": "37.5172", "longitude": "-122.33263"}, {"latitude": "37.51746", "longitude": "-122.33097"}, {"latitude": "37.53453", "longitude": "-122.32171"}, {"latitude": "37.53826", "longitude": "-122.32744"}, {"latitude": "37.53377", "longitude": "-122.34491"}, {"latitude": "37.52943", "longitude": "-122.34497"}, {"latitude": "37.52178", "longitude": "-122.34067"}, {"latitude": "37.51974", "longitude": "-122.33817"}, {"latitude": "37.51863", "longitude": "-122.33672"}]
1063237 September 10, 2020 - 18:50:08 UTC 37.52246 -122.30519 29 []
1194669 December 19, 2020 - 17:52:00 UTC 37.52299 -122.33572 29 []
1203730 January 04, 2021 - 20:02:50 UTC 37.52299 -122.33572 29 []
703028 November 09, 2019 - 00:24:40 UTC 37.523 -122.30293 29 []
720860 November 27, 2019 - 17:24:55 UTC 37.523 -122.30293 29 []
1061476 September 09, 2020 - 01:12:00 UTC 37.52336 -122.32692 29 []
1116719 October 13, 2020 - 21:06:21 UTC 37.52373 -122.3252 29 []
1200925 December 29, 2020 - 23:45:04 UTC 37.52399 -122.31199 29 []
1208338 January 11, 2021 - 19:16:44 UTC 37.52402 -122.30309 29 []
1061477 September 09, 2020 - 01:16:37 UTC 37.52413 -122.32958 29 []
739412 December 14, 2019 - 17:38:00 UTC 37.52457 -122.30367 29 [{"latitude": "37.52243", "longitude": "-122.30638"}, {"latitude": "37.52246", "longitude": "-122.30519"}, {"latitude": "37.52452", "longitude": "-122.30382"}, {"latitude": "37.52506", "longitude": "-122.30548"}, {"latitude": "37.5235", "longitude": "-122.30872"}]
779403 February 06, 2020 - 20:24:00 UTC 37.52465 -122.30108 29 []
782803 February 09, 2020 - 19:14:52 UTC 37.52478 -122.32561 29 []
647444 October 08, 2019 - 18:39:17 UTC 37.52571 -122.30535 29 []
1148295 November 18, 2020 - 16:22:08 UTC 37.52571 -122.30012 29 []
1168669 December 07, 2020 - 20:05:20 UTC 37.52616 -122.30761 29 []
658315 October 14, 2019 - 21:33:47 UTC 37.52638 -122.30393 29 []
691451 October 28, 2019 - 16:09:43 UTC 37.52654 -122.30865 29 []
699204 November 04, 2019 - 18:25:15 UTC 37.52659 -122.33268 29 []
1146465 November 16, 2020 - 22:54:55 UTC 37.52704 -122.2931 29 []
689234 October 27, 2019 - 21:01:20 UTC 37.52711 -122.29829 29 []
701834 November 07, 2019 - 18:06:46 UTC 37.52731 -122.30693 29 []
1058184 September 07, 2020 - 13:58:00 UTC 37.52737 -122.32601 29 []
1061449 September 09, 2020 - 00:15:00 UTC 37.52737 -122.32601 29 [{"latitude": "37.52168", "longitude": "-122.32896"}, {"latitude": "37.52178", "longitude": "-122.32698"}, {"latitude": "37.52228", "longitude": "-122.32618"}, {"latitude": "37.523", "longitude": "-122.32558"}, {"latitude": "37.52481", "longitude": "-122.32419"}, {"latitude": "37.52627", "longitude": "-122.32502"}, {"latitude": "37.52486", "longitude": "-122.33002"}, {"latitude": "37.524", "longitude": "-122.33079"}, {"latitude": "37.52245", "longitude": "-122.32973"}, {"latitude": "37.52184", "longitude": "-122.3293"}]
1137483 November 06, 2020 - 18:32:54 UTC 37.52761 -122.29172 29 []
717588 November 27, 2019 - 02:53:29 UTC 37.52763 -122.30981 29 []
709721 November 19, 2019 - 05:15:09 UTC 37.52765 -122.30385 29 []
735916 December 11, 2019 - 00:58:49 UTC 37.52768 -122.30893 29 []
1135840 November 04, 2020 - 19:52:33 UTC 37.5279 -122.29854 29 []
737072 December 12, 2019 - 12:34:04 UTC 37.52796 -122.29313 29 []
709708 November 19, 2019 - 04:09:48 UTC 37.52802 -122.303 29 []
717593 November 27, 2019 - 02:54:10 UTC 37.52826 -122.30998 29 []
1068989 September 14, 2020 - 18:07:25 UTC 37.52828 -122.29377 29 []
675923 October 21, 2019 - 16:08:16 UTC 37.52843 -122.32135 29 []
1072075 September 15, 2020 - 18:40:43 UTC 37.52862 -122.29152 29 []
1122517 October 21, 2020 - 22:12:05 UTC 37.52862 -122.29152 29 []
719735 November 27, 2019 - 10:44:56 UTC 37.52863 -122.31889 29 []
714469 November 25, 2019 - 20:45:09 UTC 37.52864 -122.30933 29 []
1174674 December 10, 2020 - 00:25:59 UTC 37.52905 -122.30561 29 []
678231 October 23, 2019 - 21:58:24 UTC 37.52919 -122.31528 29 []
1080980 September 18, 2020 - 19:22:20 UTC 37.52935 -122.3142 29 []
1192525 December 17, 2020 - 19:05:26 UTC 37.52984 -122.3268 29 []
1062037 September 09, 2020 - 17:53:56 UTC 37.52985 -122.27763 29 []
1209545 January 13, 2021 - 16:04:29 UTC 37.52989 -122.32295 29 []
1201041 December 30, 2020 - 05:02:37 UTC 37.5303 -122.31802 29 []
1201083 December 30, 2020 - 09:06:09 UTC 37.5303 -122.31802 29 []
1201328 December 30, 2020 - 20:27:28 UTC 37.5303 -122.31802 29 []
1201437 December 30, 2020 - 22:49:00 UTC 37.5303 -122.31802 29 []
708100 November 16, 2019 - 15:04:09 UTC 37.5304 -122.28433 29 []
1149587 November 19, 2020 - 21:49:47 UTC 37.53089 -122.30562 29 []
1180327 December 12, 2020 - 05:08:09 UTC 37.53089 -122.30562 29 []
654834 October 12, 2019 - 01:15:00 UTC 37.53096 -122.31593 29 []
1132096 October 30, 2020 - 16:04:45 UTC 37.53108 -122.32893 29 []
1132460 October 31, 2020 - 00:07:46 UTC 37.53108 -122.32893 29 []
737309 December 12, 2019 - 17:10:32 UTC 37.53112 -122.29685 29 [{"latitude": "37.53038", "longitude": "-122.29739"}, {"latitude": "37.53051", "longitude": "-122.29662"}, {"latitude": "37.5316", "longitude": "-122.29736"}, {"latitude": "37.5315", "longitude": "-122.29811"}]
727807 December 02, 2019 - 23:09:28 UTC 37.53123 -122.31742 29 []
719214 November 27, 2019 - 06:28:24 UTC 37.5313 -122.27828 29 []
721294 November 27, 2019 - 19:09:00 UTC 37.5313 -122.27828 29 []
1189840 December 16, 2020 - 08:10:44 UTC 37.5313 -122.27828 29 []
1112674 October 07, 2020 - 16:32:00 UTC 37.53132 -122.28767 29 [{"latitude": "37.53074", "longitude": "-122.27647"}, {"latitude": "37.53133", "longitude": "-122.27695"}, {"latitude": "37.5324", "longitude": "-122.27808"}, {"latitude": "37.53293", "longitude": "-122.27864"}, {"latitude": "37.53326", "longitude": "-122.27954"}, {"latitude": "37.53303", "longitude": "-122.28247"}, {"latitude": "37.5324", "longitude": "-122.2848"}, {"latitude": "37.53141", "longitude": "-122.28771"}]
1113121 October 08, 2020 - 00:40:00 UTC 37.53133 -122.27695 29 []
1119410 October 16, 2020 - 20:29:14 UTC 37.53134 -122.30659 29 []
733254 December 08, 2019 - 02:13:37 UTC 37.53141 -122.32093 29 []
1156266 November 30, 2020 - 17:36:54 UTC 37.5315 -122.29811 29 []
1205130 January 06, 2021 - 16:35:23 UTC 37.5315 -122.29811 29 []
658520 October 14, 2019 - 22:12:01 UTC 37.53157 -122.3161 29 []
1158231 December 02, 2020 - 19:02:24 UTC 37.53157 -122.3161 29 []
1062132 September 09, 2020 - 19:50:47 UTC 37.53166 -122.2815 29 [{"latitude": "37.52793", "longitude": "-122.27312"}, {"latitude": "37.52996", "longitude": "-122.27522"}, {"latitude": "37.53293", "longitude": "-122.27864"}, {"latitude": "37.53326", "longitude": "-122.27954"}, {"latitude": "37.53315", "longitude": "-122.28055"}, {"latitude": "37.53127", "longitude": "-122.28123"}, {"latitude": "37.52852", "longitude": "-122.27656"}, {"latitude": "37.52823", "longitude": "-122.27508"}]
1112729 October 07, 2020 - 16:32:00 UTC 37.53174 -122.28129 29 [{"latitude": "37.53074", "longitude": "-122.27647"}, {"latitude": "37.53133", "longitude": "-122.27695"}, {"latitude": "37.5324", "longitude": "-122.27808"}, {"latitude": "37.53293", "longitude": "-122.27864"}, {"latitude": "37.53326", "longitude": "-122.27954"}, {"latitude": "37.53315", "longitude": "-122.28055"}, {"latitude": "37.53171", "longitude": "-122.27998"}, {"latitude": "37.53093", "longitude": "-122.27895"}]
712386 November 21, 2019 - 21:41:24 UTC 37.53194 -122.30971 29 []
1140770 November 10, 2020 - 08:44:08 UTC 37.53226 -122.30085 29 []
1083301 September 20, 2020 - 20:39:00 UTC 37.53227 -122.32721 29 [{"latitude": "37.53198", "longitude": "-122.32708"}, {"latitude": "37.53238", "longitude": "-122.32735"}, {"latitude": "37.53234", "longitude": "-122.32735"}]
1134957 November 03, 2020 - 16:29:37 UTC 37.5323 -122.29701 29 []
1106659 October 02, 2020 - 16:35:00 UTC 37.53233 -122.2848 29 [{"latitude": "37.53199", "longitude": "-122.28399"}, {"latitude": "37.53237", "longitude": "-122.28306"}, {"latitude": "37.53303", "longitude": "-122.28247"}]
1106142 October 02, 2020 - 14:54:34 UTC 37.53266 -122.30759 29 []
658254 October 14, 2019 - 21:18:25 UTC 37.53267 -122.29308 29 []
1140662 November 10, 2020 - 01:49:31 UTC 37.53274 -122.30159 29 []
1140689 November 10, 2020 - 03:42:09 UTC 37.53274 -122.30159 29 []
1088651 September 23, 2020 - 01:48:54 UTC 37.53276 -122.28986 29 []
1122560 October 21, 2020 - 22:59:56 UTC 37.53298 -122.29067 29 []
1140352 November 09, 2020 - 19:41:20 UTC 37.53298 -122.29067 29 []
1202465 January 02, 2021 - 19:19:39 UTC 37.53302 -122.32121 29 []
1140762 November 10, 2020 - 08:08:55 UTC 37.53303 -122.30094 29 []
1140686 November 10, 2020 - 03:33:25 UTC 37.53324 -122.29985 29 []
1140726 November 10, 2020 - 05:08:58 UTC 37.53324 -122.29985 29 []
1066983 September 13, 2020 - 00:00:00 UTC 37.53344 -122.29363 29 []
1141095 November 10, 2020 - 18:19:10 UTC 37.53348 -122.29006 29 []
1106857 October 02, 2020 - 17:13:00 UTC 37.53359 -122.28339 29 []
1106858 October 02, 2020 - 17:14:51 UTC 37.5336 -122.28465 29 []
1140836 November 10, 2020 - 15:17:28 UTC 37.53362 -122.29502 29 []
657016 October 14, 2019 - 18:05:52 UTC 37.53368 -122.3173 29 []
1204470 January 05, 2021 - 17:18:53 UTC 37.53368 -122.3173 29 []
1120516 October 19, 2020 - 04:20:56 UTC 37.5339 -122.30551 29 []
1210459 January 14, 2021 - 20:52:00 UTC 37.53392 -122.31123 29 []
636675 October 02, 2019 - 17:53:00 UTC 37.53397 -122.29652 29 [{"latitude": "37.53405", "longitude": "-122.29639"}, {"latitude": "37.53435", "longitude": "-122.29565"}, {"latitude": "37.53443", "longitude": "-122.29547"}, {"latitude": "37.53487", "longitude": "-122.29551"}]
713155 November 23, 2019 - 00:15:14 UTC 37.53413 -122.31937 29 []
734872 December 09, 2019 - 23:53:41 UTC 37.5344 -122.30603 29 []
1120517 October 19, 2020 - 04:28:32 UTC 37.5344 -122.30603 29 []