pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1569913215:633483 633483 1 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569913838:633483 633483 2 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569914414:633483 633483 3 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569915019:633483 633483 4 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569915624:633483 633483 5 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569916231:633483 633483 6 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569916815:633483 633483 7 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569917417:633483 633483 8 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569918012:633483 633483 9 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569918645:633483 633483 10 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569919223:633483 633483 11 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569919823:633483 633483 12 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569920421:633483 633483 13 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569921023:633483 633483 14 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569921618:633483 633483 15 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569922217:633483 633483 16 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569922813:633483 633483 17 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569923412:633483 633483 18 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569924030:633483 633483 19 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569924614:633483 633483 20 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569925218:633483 633483 21 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569925819:633483 633483 22 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569926413:633483 633483 23 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569927022:633483 633483 24 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569927620:633483 633483 25 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569928219:633483 633483 26 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569928810:633483 633483 27 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569929414:633483 633483 28 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569930017:633483 633483 29 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569930614:633483 633483 30 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569931217:633483 633483 31 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569931817:633483 633483 32 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569932416:633483 633483 33 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569933016:633483 633483 34 October 01, 2019 - 06:30:51 UTC October 01, 2019 - 13:00:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569933610:633483 633483 35 October 01, 2019 - 12:32:33 UTC October 01, 2019 - 14:30:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569934216:633483 633483 36 October 01, 2019 - 12:32:33 UTC October 01, 2019 - 14:30:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569934854:633483 633483 37 October 01, 2019 - 12:32:33 UTC October 01, 2019 - 14:30:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569935427:633483 633483 38 October 01, 2019 - 12:32:33 UTC October 01, 2019 - 14:30:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569936025:633483 633483 39 October 01, 2019 - 13:07:05 UTC October 01, 2019 - 14:30:00 UTC   17 0 37.50476 -122.25824 24 4 4
1569952839:633957 633957 67 October 01, 2019 - 17:52:33 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 37.50945 -122.26374 24 1 1
1569953462:633957 633957 68 October 01, 2019 - 17:52:33 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 37.50945 -122.26374 24 1 1
1569954055:633957 633957 69 October 01, 2019 - 17:52:33 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 37.50945 -122.26374 24 1 1
1569954621:633957 633957 70 October 01, 2019 - 17:52:33 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 37.50945 -122.26374 24 1 5
1569955253:633957 633957 71 October 01, 2019 - 17:52:33 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 37.50945 -122.26374 24 1 5
1569955842:633957 633957 72 October 01, 2019 - 17:52:33 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 37.50945 -122.26374 24 1 5
1569956437:633957 633957 73 October 01, 2019 - 18:50:12 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 37.50945 -122.26374 24 6 4
1569957023:633957 633957 74 October 01, 2019 - 18:50:12 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 37.50945 -122.26374 24 6 4
1569963019:634818 634818 84 October 01, 2019 - 20:39:21 UTC October 01, 2019 - 23:15:00 UTC October 01, 2019 - 23:15:00 UTC 1 0 37.50102 -122.25797 24 1 1
1569963629:634818 634818 85 October 01, 2019 - 20:48:17 UTC October 01, 2019 - 23:15:00 UTC October 01, 2019 - 23:15:00 UTC 1 0 37.50102 -122.25797 24 1 1
1569964228:634818 634818 86 October 01, 2019 - 20:48:17 UTC October 01, 2019 - 23:15:00 UTC October 01, 2019 - 23:15:00 UTC 1 0 37.50102 -122.25797 24 1 1
1569964818:634818 634818 87 October 01, 2019 - 20:48:17 UTC October 01, 2019 - 23:15:00 UTC October 01, 2019 - 23:15:00 UTC 1 0 37.50102 -122.25797 24 1 1
1569965440:634818 634818 88 October 01, 2019 - 20:48:17 UTC October 01, 2019 - 23:15:00 UTC October 01, 2019 - 23:15:00 UTC 1 0 37.50102 -122.25797 24 1 1
1569966020:634818 634818 89 October 01, 2019 - 20:48:17 UTC October 01, 2019 - 23:15:00 UTC October 01, 2019 - 23:15:00 UTC 1 0 37.50102 -122.25797 24 1 1
1569966613:634818 634818 90 October 01, 2019 - 20:48:17 UTC October 01, 2019 - 23:15:00 UTC October 01, 2019 - 23:15:00 UTC 1 0 37.50102 -122.25797 24 1 1
1569967246:634818 634818 91 October 01, 2019 - 20:48:17 UTC October 01, 2019 - 23:15:00 UTC October 01, 2019 - 23:15:00 UTC 1 0 37.50102 -122.25797 24 1 1
1569967836:634818 634818 92 October 01, 2019 - 20:48:17 UTC October 01, 2019 - 23:15:00 UTC October 01, 2019 - 23:15:00 UTC 1 0 37.50102 -122.25797 24 1 1
1569968422:634818 634818 93 October 01, 2019 - 20:48:17 UTC October 01, 2019 - 23:15:00 UTC October 01, 2019 - 23:15:00 UTC 1 0 37.50102 -122.25797 24 1 1
1569969014:634818 634818 94 October 01, 2019 - 20:48:17 UTC October 01, 2019 - 23:15:00 UTC October 01, 2019 - 23:15:00 UTC 1 0 37.50102 -122.25797 24 1 1
1569969624:634818 634818 95 October 01, 2019 - 20:48:17 UTC October 01, 2019 - 23:15:00 UTC October 01, 2019 - 23:15:00 UTC 1 0 37.50102 -122.25797 24 1 1
1569970224:634818 634818 96 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569970823:634818 634818 97 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569971424:634818 634818 98 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569972029:634818 634818 99 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569972627:634818 634818 100 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569973221:634818 634818 101 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569973815:634818 634818 102 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569973815:635364 635364 102 October 01, 2019 - 23:39:58 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 0 37.51697 -122.26347 24 1 1
1569974427:634818 634818 103 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569974427:635364 635364 103 October 01, 2019 - 23:39:58 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 0 37.51697 -122.26347 24 1 1
1569975023:634818 634818 104 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569975023:635364 635364 104 October 02, 2019 - 00:03:15 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 0 37.51697 -122.26347 24 6 4
1569975632:634818 634818 105 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569975632:635364 635364 105 October 02, 2019 - 00:03:15 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 0 37.51697 -122.26347 24 6 4
1569976224:634818 634818 106 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569976224:635364 635364 106 October 02, 2019 - 00:03:15 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 0 37.51697 -122.26347 24 6 4
1569976824:634818 634818 107 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569976824:635364 635364 107 October 02, 2019 - 00:03:15 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 0 37.51697 -122.26347 24 6 4
1569977421:634818 634818 108 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569978019:634818 634818 109 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569978625:634818 634818 110 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569979222:634818 634818 111 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569979818:634818 634818 112 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569980417:634818 634818 113 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569981024:634818 634818 114 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569981616:634818 634818 115 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569982221:634818 634818 116 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569982816:634818 634818 117 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569983422:634818 634818 118 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569984016:634818 634818 119 October 01, 2019 - 22:45:28 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569984611:634818 634818 120 October 02, 2019 - 02:39:25 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569985221:634818 634818 121 October 02, 2019 - 02:39:25 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569985819:634818 634818 122 October 02, 2019 - 02:39:25 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569986427:634818 634818 123 October 02, 2019 - 02:39:25 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569987020:634818 634818 124 October 02, 2019 - 02:39:25 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569987614:634818 634818 125 October 02, 2019 - 02:39:25 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569988216:634818 634818 126 October 02, 2019 - 02:39:25 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569988829:634818 634818 127 October 02, 2019 - 02:39:25 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569989417:634818 634818 128 October 02, 2019 - 02:39:25 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 24 1 1
1569990017:634818 634818 129 October 02, 2019 - 04:16:09 UTC October 02, 2019 - 08:15:00 UTC   1 0 37.50102 -122.25797 24 1 1
1570045222:637253 637253 212 October 02, 2019 - 19:33:58 UTC October 02, 2019 - 22:00:00 UTC October 02, 2019 - 22:00:00 UTC 1 0 37.49384 -122.2617 24 1 1
1570045818:637253 637253 213 October 02, 2019 - 19:33:58 UTC October 02, 2019 - 22:00:00 UTC October 02, 2019 - 22:00:00 UTC 1 0 37.49384 -122.2617 24 1 1