pge-outages

Custom SQL query returning 101 rows (hide)

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