pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1570384218:641453 641453 771 October 03, 2019 - 22:20:08 UTC October 03, 2019 - 21:00:00 UTC   31 0 38.75839 -120.76453 19 3 2
1570384218:644053 644053 771 October 05, 2019 - 17:35:39 UTC October 05, 2019 - 21:00:00 UTC   3 0 38.7198 -120.80203 19 3 2
1570384218:644678 644678 771 October 05, 2019 - 17:53:28 UTC October 05, 2019 - 21:00:00 UTC   2 0 38.69371 -120.78094 72 3 2
1570384218:645104 645104 771 October 06, 2019 - 16:52:19 UTC October 06, 2019 - 21:00:00 UTC   491 3 38.34541 -122.29922 15 2 2
1570384218:645142 645142 771 October 06, 2019 - 17:11:08 UTC October 06, 2019 - 22:00:00 UTC   1 1 36.90469 -121.70383 49 5 2
1570384218:645144 645144 771 October 06, 2019 - 16:13:47 UTC October 06, 2019 - 19:00:00 UTC   10 1 37.23598 -121.9098 26 2 3
1570384218:645153 645153 771 October 06, 2019 - 13:52:47 UTC October 07, 2019 - 01:00:00 UTC   1 0 37.59527 -122.36756 203 2 3
1570384218:645182 645182 771 October 06, 2019 - 17:22:12 UTC October 07, 2019 - 04:00:00 UTC   180 0 39.57306 -121.31759 166 9 4
1570384218:645211 645211 771 October 06, 2019 - 15:55:39 UTC October 07, 2019 - 04:00:00 UTC   103 0 39.76026 -121.61876 167 9 1
1570384218:645214 645214 771 October 06, 2019 - 17:22:35 UTC October 07, 2019 - 04:00:00 UTC   50 0 39.57633 -121.30241 166 9 4
1570384218:645233 645233 771 October 06, 2019 - 15:55:39 UTC October 07, 2019 - 04:00:00 UTC   26 0 39.57489 -121.30564 166 9 1
1570384218:645239 645239 771 October 06, 2019 - 13:20:31 UTC October 06, 2019 - 23:00:00 UTC   8 1 39.53941 -122.26307 86 5 2
1570384218:645269 645269 771 October 06, 2019 - 17:19:24 UTC October 07, 2019 - 04:00:00 UTC   8 0 39.52908 -121.28383 504 9 4
1570384218:645291 645291 771 October 06, 2019 - 17:21:46 UTC October 07, 2019 - 04:00:00 UTC   377 0 39.5148 -121.26438 504 9 4
1570384218:645318 645318 771 October 06, 2019 - 15:55:40 UTC October 07, 2019 - 04:00:00 UTC   0 0 39.87177 -121.61131 481 9 1
1570384218:645325 645325 771 October 06, 2019 - 17:20:40 UTC October 07, 2019 - 04:00:00 UTC   182 0 39.50458 -121.4527 321 9 4
1570384218:645341 645341 771 October 06, 2019 - 15:55:40 UTC October 07, 2019 - 04:00:00 UTC   4 0 39.91174 -121.32669 292 9 1
1570384218:645391 645391 771 October 06, 2019 - 16:32:37 UTC October 07, 2019 - 04:00:00 UTC   315 0 39.77166 -121.59667 167 9 1
1570384218:645395 645395 771 October 06, 2019 - 17:08:50 UTC October 07, 2019 - 04:00:00 UTC   300 0 39.90316 -121.74208 494 9 1
1570384218:645400 645400 771 October 06, 2019 - 16:25:04 UTC October 06, 2019 - 23:00:00 UTC   41 0 35.39883 -118.96497 2 2 3
1570384218:645442 645442 771 October 06, 2019 - 17:22:53 UTC October 07, 2019 - 04:00:00 UTC   119 0 39.67695 -121.49157 166 9 4
1570384218:645443 645443 771 October 06, 2019 - 15:55:41 UTC October 07, 2019 - 04:00:00 UTC   37 0 39.76097 -121.60593 167 9 1
1570384218:645445 645445 771 October 06, 2019 - 15:55:41 UTC October 07, 2019 - 04:00:00 UTC   190 0 39.75844 -121.60693 167 9 1
1570384218:645447 645447 771 October 06, 2019 - 15:55:41 UTC October 07, 2019 - 04:00:00 UTC   98 0 39.75945 -121.60316 167 9 1
1570384218:645448 645448 771 October 06, 2019 - 15:55:41 UTC October 07, 2019 - 04:00:00 UTC   13 0 39.65479 -121.63547 236 9 1
1570384218:645450 645450 771 October 06, 2019 - 15:55:41 UTC October 07, 2019 - 04:00:00 UTC   125 0 39.81458 -121.58458 481 9 1
1570384218:645451 645451 771 October 06, 2019 - 17:18:40 UTC October 07, 2019 - 04:00:00 UTC   291 0 39.82557 -121.59763 481 9 1
1570384218:645453 645453 771 October 06, 2019 - 15:55:41 UTC October 07, 2019 - 04:00:00 UTC   4 0 39.79847 -121.48627 500 9 1
1570384218:645454 645454 771 October 06, 2019 - 17:16:38 UTC October 07, 2019 - 04:00:00 UTC   112 0 39.81196 -121.59143 481 9 1
1570384218:645457 645457 771 October 06, 2019 - 17:23:20 UTC October 07, 2019 - 04:00:00 UTC   266 0 39.64436 -121.43134 425 9 4
1570384218:645458 645458 771 October 06, 2019 - 17:41:06 UTC October 07, 2019 - 04:00:00 UTC   1338 0 39.87162 -121.61128 481 9 1
1570384218:645459 645459 771 October 06, 2019 - 15:55:41 UTC October 07, 2019 - 04:00:00 UTC   22 0 39.87162 -121.61139 481 9 1
1570384218:645461 645461 771 October 06, 2019 - 15:55:42 UTC October 07, 2019 - 04:00:00 UTC   183 0 39.75027 -121.62655 167 9 1
1570384218:645462 645462 771 October 06, 2019 - 15:55:42 UTC October 07, 2019 - 04:00:00 UTC   172 0 39.74112 -121.62776 167 9 1
1570384218:645463 645463 771 October 06, 2019 - 15:55:42 UTC October 07, 2019 - 04:00:00 UTC   92 0 39.74036 -121.49649 500 9 1
1570384218:645465 645465 771 October 06, 2019 - 16:11:39 UTC October 07, 2019 - 04:00:00 UTC   101 0 39.74594 -121.6383 167 9 1
1570384218:645466 645466 771 October 06, 2019 - 17:19:49 UTC October 07, 2019 - 04:00:00 UTC   374 0 39.63945 -121.42969 425 9 4
1570384218:645470 645470 771 October 06, 2019 - 17:20:12 UTC October 07, 2019 - 04:00:00 UTC   250 0 39.63494 -121.39178 425 9 4
1570384218:645471 645471 771 October 06, 2019 - 15:55:42 UTC October 07, 2019 - 04:00:00 UTC   181 0 39.75613 -121.57213 167 9 1
1570384218:645472 645472 771 October 06, 2019 - 15:55:42 UTC October 07, 2019 - 04:00:00 UTC   105 0 39.77165 -121.57973 167 9 1
1570384218:645473 645473 771 October 06, 2019 - 15:55:42 UTC October 07, 2019 - 04:00:00 UTC   102 0 39.74432 -121.5724 167 9 1
1570384218:645474 645474 771 October 06, 2019 - 15:55:42 UTC October 07, 2019 - 04:00:00 UTC   123 0 39.75155 -121.60792 167 9 1
1570384218:645475 645475 771 October 06, 2019 - 15:55:42 UTC October 07, 2019 - 04:00:00 UTC   76 0 39.74848 -121.60849 167 9 1
1570384218:645477 645477 771 October 06, 2019 - 17:17:22 UTC October 07, 2019 - 04:00:00 UTC   1046 0 39.85417 -121.60588 481 9 1
1570384218:645478 645478 771 October 06, 2019 - 15:55:42 UTC October 07, 2019 - 04:00:00 UTC   4 0 39.87191 -121.61187 481 9 1
1570384218:645479 645479 771 October 06, 2019 - 15:55:42 UTC October 07, 2019 - 04:00:00 UTC   127 0 39.87079 -121.65042 481 9 1
1570384218:645480 645480 771 October 06, 2019 - 15:55:43 UTC October 07, 2019 - 04:00:00 UTC   11 0 39.88717 -121.66541 147 9 1
1570384218:645481 645481 771 October 06, 2019 - 15:55:43 UTC October 07, 2019 - 04:00:00 UTC   377 0 39.88766 -121.66546 147 9 1
1570384218:645482 645482 771 October 06, 2019 - 15:55:43 UTC October 07, 2019 - 04:00:00 UTC   250 0 39.88881 -121.6648 147 9 1
1570384218:645483 645483 771 October 06, 2019 - 15:55:43 UTC October 07, 2019 - 04:00:00 UTC   6 0 39.93504 -121.64677 147 9 1
1570384218:645484 645484 771 October 06, 2019 - 15:55:43 UTC October 07, 2019 - 04:00:00 UTC   311 0 40.03756 -121.61789 147 9 1
1570384218:645485 645485 771 October 06, 2019 - 17:25:15 UTC October 07, 2019 - 04:00:00 UTC   566 0 39.85801 -121.61349 481 9 1
1570384218:645486 645486 771 October 06, 2019 - 16:23:41 UTC October 07, 2019 - 04:00:00 UTC   347 0 39.8789 -121.61165 481 9 1
1570384218:645487 645487 771 October 06, 2019 - 16:52:03 UTC October 06, 2019 - 21:00:00 UTC   1 0 38.31668 -122.28499 15 1 1
1570384218:645490 645490 771 October 06, 2019 - 12:55:44 UTC October 06, 2019 - 19:01:00 UTC   1 1 37.70999 -122.17583 27 6 3
1570384218:645491 645491 771 October 06, 2019 - 15:55:43 UTC October 07, 2019 - 04:00:00 UTC   124 0 39.64781 -121.62981 236 9 1
1570384218:645492 645492 771 October 06, 2019 - 17:08:23 UTC October 07, 2019 - 04:00:00 UTC   0 0 39.65686 -121.57597 166 9 1
1570384218:645493 645493 771 October 06, 2019 - 15:55:43 UTC October 07, 2019 - 04:00:00 UTC   128 0 39.69452 -121.52522 501 9 1
1570384218:645494 645494 771 October 06, 2019 - 15:55:43 UTC October 07, 2019 - 04:00:00 UTC   115 0 39.6987 -121.57416 167 9 1
1570384218:645495 645495 771 October 06, 2019 - 15:55:43 UTC October 07, 2019 - 04:00:00 UTC   134 0 39.65654 -121.57623 166 9 1
1570384218:645496 645496 771 October 06, 2019 - 17:29:15 UTC October 07, 2019 - 04:00:00 UTC   260 0 39.65646 -121.5745 166 9 1
1570384218:645497 645497 771 October 06, 2019 - 15:55:43 UTC October 07, 2019 - 04:00:00 UTC   70 0 39.6514 -121.58876 166 9 1
1570384218:645498 645498 771 October 06, 2019 - 15:55:43 UTC October 07, 2019 - 04:00:00 UTC   64 0 39.64701 -121.63448 236 9 1
1570384218:645499 645499 771 October 06, 2019 - 15:55:43 UTC October 07, 2019 - 04:00:00 UTC   189 0 39.65697 -121.63122 236 9 1
1570384218:645503 645503 771 October 06, 2019 - 17:15:51 UTC October 06, 2019 - 19:30:00 UTC   16 0 37.29033 -121.98511 26 2 2
1570384218:645505 645505 771 October 06, 2019 - 15:55:44 UTC October 07, 2019 - 04:00:00 UTC   1 0 39.4936 -121.54384 320 9 1
1570384218:645514 645514 771 October 06, 2019 - 16:53:42 UTC October 06, 2019 - 23:00:00 UTC   19 1 36.15036 -119.50808 466 2 2
1570384218:645515 645515 771 October 06, 2019 - 16:31:30 UTC October 06, 2019 - 19:00:00 UTC   77 1 37.80023 -121.90802 509 2 7
1570384218:645522 645522 771 October 06, 2019 - 16:19:04 UTC October 06, 2019 - 18:30:00 UTC   95 1 40.0425 -122.10039 506 6 4
1570384218:645523 645523 771 October 06, 2019 - 12:05:51 UTC October 06, 2019 - 20:00:00 UTC   1 0 37.67289 -121.83101 36 3 2
1570384218:645526 645526 771 October 06, 2019 - 17:22:00 UTC October 06, 2019 - 19:15:00 UTC   1 0 36.61614 -121.91931 247 6 4
1570384218:645527 645527 771 October 06, 2019 - 17:17:45 UTC October 06, 2019 - 19:00:00 UTC   1 0 36.78282 -121.65103 190 2 2
1570384218:645532 645532 771 October 06, 2019 - 16:18:22 UTC October 06, 2019 - 17:45:00 UTC October 06, 2019 - 17:45:00 UTC 28 1 37.84274 -122.21218 16 2 3
1570384218:645536 645536 771 October 06, 2019 - 16:01:49 UTC October 06, 2019 - 23:00:00 UTC   19 0 39.20096 -121.05856 113 3 2
1570384218:645548 645548 771 October 06, 2019 - 17:41:53 UTC October 06, 2019 - 23:00:00 UTC   346 0 36.85237 -119.66619 57 3 2
1570384218:645558 645558 771 October 06, 2019 - 17:30:33 UTC October 06, 2019 - 19:15:00 UTC October 06, 2019 - 19:15:00 UTC 112 1 36.98742 -121.95241 254 6 4
1570384218:645560 645560 771 October 06, 2019 - 17:16:23 UTC October 06, 2019 - 21:30:00 UTC   1 0 35.76246 -120.95274 510 1 5
1570384218:645562 645562 771 October 06, 2019 - 16:06:10 UTC October 06, 2019 - 22:00:00 UTC   2 0 37.6921 -121.80381 12 3 1
1570384218:645564 645564 771 October 06, 2019 - 17:22:40 UTC October 06, 2019 - 19:00:00 UTC October 06, 2019 - 19:00:00 UTC 1 0 37.30429 -121.86805 26 6 4
1570384218:645567 645567 771 October 06, 2019 - 17:16:43 UTC October 06, 2019 - 21:30:00 UTC   1 0 35.7561 -120.95107 510 1 1
1570384218:645569 645569 771 October 06, 2019 - 16:23:08 UTC October 06, 2019 - 18:45:00 UTC October 06, 2019 - 18:45:00 UTC 1 0 37.7775 -122.46932 25 1 1
1570384218:645571 645571 771 October 06, 2019 - 16:33:45 UTC October 06, 2019 - 20:00:00 UTC October 06, 2019 - 20:00:00 UTC 1 0 36.91331 -121.75187 49 1 1
1570384218:645573 645573 771 October 06, 2019 - 16:36:38 UTC October 06, 2019 - 19:15:00 UTC October 06, 2019 - 19:15:00 UTC 1 1 37.97231 -122.61137 226 1 5
1570384218:645574 645574 771 October 06, 2019 - 16:25:47 UTC October 07, 2019 - 00:00:00 UTC   83 0 37.81468 -122.27871 16 3 2
1570384218:645575 645575 771 October 06, 2019 - 16:50:58 UTC October 06, 2019 - 19:45:00 UTC October 06, 2019 - 19:45:00 UTC 1 0 38.05944 -120.18606 304 6 4
1570384218:645577 645577 771 October 06, 2019 - 17:03:01 UTC October 06, 2019 - 18:15:00 UTC October 06, 2019 - 18:15:00 UTC 10 0 37.30705 -121.98236 26 1 1
1570384218:645578 645578 771 October 06, 2019 - 17:37:17 UTC October 06, 2019 - 19:15:00 UTC October 06, 2019 - 19:15:00 UTC 1 0 37.32732 -121.87118 26 1 1
1570384218:645579 645579 771 October 06, 2019 - 16:45:39 UTC October 06, 2019 - 19:30:00 UTC October 06, 2019 - 19:30:00 UTC 1 1 37.96857 -121.96056 46 1 1
1570384218:645581 645581 771 October 06, 2019 - 16:43:12 UTC October 06, 2019 - 20:15:00 UTC October 06, 2019 - 20:15:00 UTC 1 0 36.86016 -121.76241 49 1 1
1570384218:645582 645582 771 October 06, 2019 - 17:37:26 UTC October 06, 2019 - 20:15:00 UTC October 06, 2019 - 20:15:00 UTC 31 5 36.95978 -122.03015 104 1 5
1570384218:645584 645584 771 October 06, 2019 - 17:01:41 UTC October 06, 2019 - 20:30:00 UTC October 06, 2019 - 20:30:00 UTC 1 0 36.91149 -121.75353 49 1 1
1570384218:645585 645585 771 October 06, 2019 - 17:18:57 UTC October 06, 2019 - 20:30:00 UTC October 06, 2019 - 20:30:00 UTC 7 0 36.91336 -121.7527 49 1 1
1570384218:645586 645586 771 October 06, 2019 - 17:45:02 UTC October 06, 2019 - 19:45:00 UTC October 06, 2019 - 19:45:00 UTC 1 0 38.07676 -122.22981 154 6 4
1570384218:645588 645588 771 October 06, 2019 - 17:05:13 UTC October 06, 2019 - 20:30:00 UTC October 06, 2019 - 20:30:00 UTC 1 0 36.91121 -121.75391 49 1 1
1570384218:645589 645589 771 October 06, 2019 - 17:19:40 UTC October 06, 2019 - 19:45:00 UTC October 06, 2019 - 19:45:00 UTC 1 0 37.72631 -122.38386 25 1 1
1570384218:645590 645590 771 October 06, 2019 - 17:08:23 UTC October 07, 2019 - 04:00:00 UTC   65 0 39.69829 -121.57104 167 9 1
1570384218:645591 645591 771 October 06, 2019 - 17:16:32 UTC October 06, 2019 - 20:00:00 UTC October 06, 2019 - 20:00:00 UTC 1 1 36.72762 -119.72739 35 1 5
1570384218:645592 645592 771 October 06, 2019 - 17:26:31 UTC October 06, 2019 - 20:00:00 UTC October 06, 2019 - 20:00:00 UTC 1 1 38.44867 -122.70957 30 1 5
1570384218:645593 645593 771 October 06, 2019 - 17:16:24 UTC October 07, 2019 - 00:00:00 UTC   20 0 36.97741 -121.95328 253 3 2
1570384218:645594 645594 771 October 06, 2019 - 17:45:05 UTC October 06, 2019 - 20:45:00 UTC October 06, 2019 - 20:45:00 UTC 1 0 39.50925 -121.65262 166 1 5
1570384218:645595 645595 771 October 06, 2019 - 17:40:34 UTC October 06, 2019 - 20:45:00 UTC October 06, 2019 - 20:45:00 UTC 1 1 37.91709 -122.06095 33 1 1