pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1569914414:632117 632117 3 October 01, 2019 - 05:23:44 UTC October 01, 2019 - 11:00:00 UTC   8 0 35.54847 -121.08542 3 2 2
1569914414:632153 632153 3 October 01, 2019 - 06:31:11 UTC October 01, 2019 - 09:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569914414:632414 632414 3 October 01, 2019 - 05:00:53 UTC October 01, 2019 - 09:00:00 UTC   1 0 38.31483 -122.33439 15 2 3
1569914414:632474 632474 3 October 01, 2019 - 05:22:33 UTC October 01, 2019 - 08:00:00 UTC   1 0 36.29815 -119.76184 11 2 2
1569914414:632633 632633 3 October 01, 2019 - 03:18:39 UTC October 02, 2019 - 01:00:00 UTC   1 1 38.37341 -121.54748 5 2 3
1569914414:632634 632634 3 October 01, 2019 - 03:20:04 UTC October 01, 2019 - 13:00:00 UTC   1 0 40.18335 -122.2206 20 2 2
1569914414:633157 633157 3 October 01, 2019 - 03:40:21 UTC October 01, 2019 - 10:00:00 UTC   3 0 36.61393 -121.56663 23 2 2
1569914414:633233 633233 3 October 01, 2019 - 06:29:34 UTC October 01, 2019 - 11:00:00 UTC   1 0 37.3361 -121.9288 26 1 1
1569914414:633373 633373 3 October 01, 2019 - 05:47:15 UTC October 01, 2019 - 23:46:00 UTC   1 0 38.36723 -121.54198 5 4 3
1569914414:633394 633394 3 October 01, 2019 - 05:59:37 UTC October 01, 2019 - 09:00:00 UTC   1 0 36.45004 -121.35438 31 2 3
1569914414:633433 633433 3 October 01, 2019 - 05:33:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569914414:633435 633435 3 October 01, 2019 - 05:20:48 UTC October 01, 2019 - 10:00:00 UTC   13 0 36.81337 -120.25931 8 2 2
1569914414:633444 633444 3 October 01, 2019 - 05:41:06 UTC October 01, 2019 - 12:00:00 UTC   5 0 37.04293 -122.09002 7 2 2
1569914414:633451 633451 3 October 01, 2019 - 03:16:59 UTC October 01, 2019 - 11:00:00 UTC   33 0 37.66234 -121.69662 12 3 2
1569914414:633458 633458 3 October 01, 2019 - 03:36:05 UTC October 01, 2019 - 10:00:00 UTC   5 0 40.78042 -124.18235 6 2 2
1569914414:633460 633460 3 October 01, 2019 - 07:06:25 UTC October 01, 2019 - 12:00:00 UTC   1 0 38.69685 -120.77764 19 2 2
1569914414:633461 633461 3 October 01, 2019 - 06:50:28 UTC October 01, 2019 - 11:00:00 UTC   1 0 35.15723 -120.672 18 6 4
1569914414:633463 633463 3 October 01, 2019 - 04:36:17 UTC October 01, 2019 - 13:00:00 UTC   296 0 37.75335 -122.42778 25 3 2
1569914414:633467 633467 3 October 01, 2019 - 04:59:01 UTC October 01, 2019 - 12:00:00 UTC   48 0 37.76364 -122.38797 25 3 2
1569914414:633470 633470 3 October 01, 2019 - 04:37:06 UTC     97 0 37.75354 -122.42749 25 3 3
1569914414:633477 633477 3 October 01, 2019 - 05:15:44 UTC     100 0 37.75326 -122.42691 25 1 1
1569914414:633478 633478 3 October 01, 2019 - 06:34:37 UTC October 01, 2019 - 07:45:00 UTC October 01, 2019 - 07:45:00 UTC 1 0 37.25687 -120.43449 13 2 3
1569914414:633479 633479 3 October 01, 2019 - 05:04:31 UTC October 01, 2019 - 13:00:00 UTC   45 0 37.75334 -122.42578 25 3 1
1569914414:633480 633480 3 October 01, 2019 - 06:40:37 UTC October 01, 2019 - 07:45:00 UTC October 01, 2019 - 07:45:00 UTC 1 1 37.70999 -122.17583 27 6 4
1569914414:633481 633481 3 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
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
1569914414:633484 633484 3 October 01, 2019 - 06:04:23 UTC     1 0 37.75475 -122.42896 25 1 1
1569914414:633485 633485 3 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569914414:633488 633488 3 October 01, 2019 - 07:06:10 UTC October 01, 2019 - 10:15:00 UTC October 01, 2019 - 10:15:00 UTC 27 1 35.99202 -119.57146 10 1 5
1569914414:633492 633492 3 October 01, 2019 - 07:04:42 UTC October 01, 2019 - 10:15:00 UTC October 01, 2019 - 10:15:00 UTC 0 0 37.09211 -119.55301 1 1 1
1569914414:633503 633503 3 October 01, 2019 - 07:11:19 UTC October 01, 2019 - 09:45:00 UTC October 01, 2019 - 09:45:00 UTC 1 1 36.76072 -119.7904 35 1 5
1569914414:633504 633504 3 October 01, 2019 - 07:07:05 UTC October 01, 2019 - 10:00:00 UTC October 01, 2019 - 10:00:00 UTC 1 0 37.25754 -120.4345 13 1 1
1569914414:633505 633505 3 October 01, 2019 - 07:15:23 UTC October 01, 2019 - 11:30:00 UTC October 01, 2019 - 11:30:00 UTC 1 0 37.66473 -121.92102 36 1 1
1569915019:629455 629455 4 September 30, 2019 - 19:29:15 UTC October 02, 2019 - 05:00:00 UTC   1 0 40.55785 -124.14553 9 2 2
1569915019:629544 629544 4 October 01, 2019 - 04:30:45 UTC October 01, 2019 - 10:00:00 UTC   31 0 37.25649 -121.94472 26 2 2
1569915019:629993 629993 4 September 30, 2019 - 16:05:44 UTC October 01, 2019 - 00:00:00 UTC   1 0 38.50277 -122.71038 30 3 2
1569915019:630055 630055 4 September 30, 2019 - 15:29:50 UTC October 02, 2019 - 23:00:00 UTC   1 0 38.12243 -121.83043 21 3 2
1569915019:630855 630855 4 October 01, 2019 - 02:50:34 UTC October 01, 2019 - 00:00:00 UTC   4 0 37.73454 -122.13937 16 3 2
1569915019:631014 631014 4 September 30, 2019 - 17:04:42 UTC October 03, 2019 - 21:30:00 UTC   1 0 39.0775 -121.52568 17 3 4
1569915019:631133 631133 4 September 30, 2019 - 23:06:01 UTC September 30, 2019 - 20:45:00 UTC September 30, 2019 - 20:45:00 UTC 1 0 38.17765 -121.71222 21 1 1
1569915019:631354 631354 4 October 01, 2019 - 05:15:09 UTC October 01, 2019 - 11:00:00 UTC   1 0 35.30441 -120.77233 28 1 1
1569915019:631639 631639 4 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569915019:631794 631794 4 October 01, 2019 - 05:48:52 UTC October 01, 2019 - 15:30:00 UTC   1 0 36.37987 -119.92783 22 2 2
1569915019:632115 632115 4 October 01, 2019 - 06:40:57 UTC October 01, 2019 - 12:00:00 UTC   1 1 37.56994 -122.31673 29 5 2
1569915019:632117 632117 4 October 01, 2019 - 05:23:44 UTC October 01, 2019 - 11:00:00 UTC   8 0 35.54847 -121.08542 3 2 2
1569915019:632153 632153 4 October 01, 2019 - 06:31:11 UTC October 01, 2019 - 09:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569915019:632414 632414 4 October 01, 2019 - 05:00:53 UTC October 01, 2019 - 09:00:00 UTC   1 0 38.31483 -122.33439 15 2 3
1569915019:632474 632474 4 October 01, 2019 - 05:22:33 UTC October 01, 2019 - 08:00:00 UTC   1 0 36.29815 -119.76184 11 2 2
1569915019:632633 632633 4 October 01, 2019 - 03:18:39 UTC October 02, 2019 - 01:00:00 UTC   1 1 38.37341 -121.54748 5 2 3
1569915019:632634 632634 4 October 01, 2019 - 03:20:04 UTC October 01, 2019 - 13:00:00 UTC   1 0 40.18335 -122.2206 20 2 2
1569915019:633157 633157 4 October 01, 2019 - 03:40:21 UTC October 01, 2019 - 10:00:00 UTC   3 0 36.61393 -121.56663 23 2 2
1569915019:633233 633233 4 October 01, 2019 - 06:29:34 UTC October 01, 2019 - 11:00:00 UTC   1 0 37.3361 -121.9288 26 1 1
1569915019:633373 633373 4 October 01, 2019 - 05:47:15 UTC October 01, 2019 - 23:46:00 UTC   1 0 38.36723 -121.54198 5 4 3
1569915019:633394 633394 4 October 01, 2019 - 05:59:37 UTC October 01, 2019 - 09:00:00 UTC   1 0 36.45004 -121.35438 31 2 3
1569915019:633433 633433 4 October 01, 2019 - 05:33:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569915019:633435 633435 4 October 01, 2019 - 05:20:48 UTC October 01, 2019 - 10:00:00 UTC   13 0 36.81337 -120.25931 8 2 2
1569915019:633444 633444 4 October 01, 2019 - 05:41:06 UTC October 01, 2019 - 12:00:00 UTC   5 0 37.04293 -122.09002 7 2 2
1569915019:633451 633451 4 October 01, 2019 - 03:16:59 UTC October 01, 2019 - 11:00:00 UTC   33 0 37.66234 -121.69662 12 3 2
1569915019:633458 633458 4 October 01, 2019 - 03:36:05 UTC October 01, 2019 - 10:00:00 UTC   5 0 40.78042 -124.18235 6 2 2
1569915019:633460 633460 4 October 01, 2019 - 07:06:25 UTC October 01, 2019 - 12:00:00 UTC   1 0 38.69685 -120.77764 19 2 2
1569915019:633461 633461 4 October 01, 2019 - 06:50:28 UTC October 01, 2019 - 11:00:00 UTC   1 0 35.15723 -120.672 18 6 4
1569915019:633463 633463 4 October 01, 2019 - 04:36:17 UTC October 01, 2019 - 13:00:00 UTC   296 0 37.75335 -122.42778 25 3 2
1569915019:633467 633467 4 October 01, 2019 - 04:59:01 UTC October 01, 2019 - 12:00:00 UTC   48 0 37.76364 -122.38797 25 3 2
1569915019:633470 633470 4 October 01, 2019 - 04:37:06 UTC     97 0 37.75354 -122.42749 25 3 3
1569915019:633477 633477 4 October 01, 2019 - 05:15:44 UTC     100 0 37.75326 -122.42691 25 1 1
1569915019:633478 633478 4 October 01, 2019 - 07:17:58 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 3
1569915019:633479 633479 4 October 01, 2019 - 05:04:31 UTC October 01, 2019 - 13:00:00 UTC   45 0 37.75334 -122.42578 25 3 1
1569915019:633480 633480 4 October 01, 2019 - 07:16:35 UTC October 01, 2019 - 13:16:00 UTC   1 1 37.70999 -122.17583 27 6 4
1569915019:633481 633481 4 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
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
1569915019:633484 633484 4 October 01, 2019 - 06:04:23 UTC     1 0 37.75475 -122.42896 25 1 1
1569915019:633485 633485 4 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569915019:633488 633488 4 October 01, 2019 - 07:26:06 UTC October 01, 2019 - 10:15:00 UTC October 01, 2019 - 10:15:00 UTC 27 1 35.99202 -119.57146 10 6 4
1569915019:633492 633492 4 October 01, 2019 - 07:04:42 UTC October 01, 2019 - 10:15:00 UTC October 01, 2019 - 10:15:00 UTC 0 0 37.09211 -119.55301 1 1 1
1569915019:633503 633503 4 October 01, 2019 - 07:11:19 UTC October 01, 2019 - 09:45:00 UTC October 01, 2019 - 09:45:00 UTC 1 1 36.76072 -119.7904 35 1 5
1569915019:633504 633504 4 October 01, 2019 - 07:25:02 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25754 -120.4345 13 1 5
1569915019:633505 633505 4 October 01, 2019 - 07:15:23 UTC October 01, 2019 - 11:30:00 UTC October 01, 2019 - 11:30:00 UTC 1 0 37.66473 -121.92102 36 1 1
1569915624:629455 629455 5 September 30, 2019 - 19:29:15 UTC October 02, 2019 - 05:00:00 UTC   1 0 40.55785 -124.14553 9 2 2
1569915624:629544 629544 5 October 01, 2019 - 04:30:45 UTC October 01, 2019 - 10:00:00 UTC   31 0 37.25649 -121.94472 26 2 2
1569915624:629993 629993 5 September 30, 2019 - 16:05:44 UTC October 01, 2019 - 00:00:00 UTC   1 0 38.50277 -122.71038 30 3 2
1569915624:630055 630055 5 September 30, 2019 - 15:29:50 UTC October 02, 2019 - 23:00:00 UTC   1 0 38.12243 -121.83043 21 3 2
1569915624:630855 630855 5 October 01, 2019 - 02:50:34 UTC October 01, 2019 - 00:00:00 UTC   4 0 37.73454 -122.13937 16 3 2
1569915624:631014 631014 5 September 30, 2019 - 17:04:42 UTC October 03, 2019 - 21:30:00 UTC   1 0 39.0775 -121.52568 17 3 4
1569915624:631133 631133 5 September 30, 2019 - 23:06:01 UTC September 30, 2019 - 20:45:00 UTC September 30, 2019 - 20:45:00 UTC 1 0 38.17765 -121.71222 21 1 1
1569915624:631354 631354 5 October 01, 2019 - 05:15:09 UTC October 01, 2019 - 11:00:00 UTC   1 0 35.30441 -120.77233 28 1 1
1569915624:631639 631639 5 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569915624:631794 631794 5 October 01, 2019 - 05:48:52 UTC October 01, 2019 - 15:30:00 UTC   1 0 36.37987 -119.92783 22 2 2
1569915624:632117 632117 5 October 01, 2019 - 05:23:44 UTC October 01, 2019 - 11:00:00 UTC   8 0 35.54847 -121.08542 3 2 2
1569915624:632153 632153 5 October 01, 2019 - 06:31:11 UTC October 01, 2019 - 09:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569915624:632414 632414 5 October 01, 2019 - 05:00:53 UTC October 01, 2019 - 09:00:00 UTC   1 0 38.31483 -122.33439 15 2 3
1569915624:632474 632474 5 October 01, 2019 - 07:35:21 UTC October 01, 2019 - 16:00:00 UTC   1 0 36.29815 -119.76184 11 2 2
1569915624:632633 632633 5 October 01, 2019 - 03:18:39 UTC October 02, 2019 - 01:00:00 UTC   1 1 38.37341 -121.54748 5 2 3
1569915624:632634 632634 5 October 01, 2019 - 03:20:04 UTC October 01, 2019 - 13:00:00 UTC   1 0 40.18335 -122.2206 20 2 2
1569915624:633157 633157 5 October 01, 2019 - 03:40:21 UTC October 01, 2019 - 10:00:00 UTC   3 0 36.61393 -121.56663 23 2 2
1569915624:633233 633233 5 October 01, 2019 - 06:29:34 UTC October 01, 2019 - 11:00:00 UTC   1 0 37.3361 -121.9288 26 1 1
1569915624:633373 633373 5 October 01, 2019 - 05:47:15 UTC October 01, 2019 - 23:46:00 UTC   1 0 38.36723 -121.54198 5 4 3
1569915624:633394 633394 5 October 01, 2019 - 05:59:37 UTC October 01, 2019 - 09:00:00 UTC   1 0 36.45004 -121.35438 31 2 3
1569915624:633433 633433 5 October 01, 2019 - 05:33:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569915624:633435 633435 5 October 01, 2019 - 05:20:48 UTC October 01, 2019 - 10:00:00 UTC   13 0 36.81337 -120.25931 8 2 2
1569915624:633444 633444 5 October 01, 2019 - 05:41:06 UTC October 01, 2019 - 12:00:00 UTC   5 0 37.04293 -122.09002 7 2 2
1569915624:633451 633451 5 October 01, 2019 - 03:16:59 UTC October 01, 2019 - 11:00:00 UTC   33 0 37.66234 -121.69662 12 3 2