pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1575588620:730572 730572 9055 December 05, 2019 - 21:03:16 UTC December 05, 2019 - 23:00:00 UTC December 05, 2019 - 23:00:00 UTC 1 1 40.86681 -124.04719 230 6 3
1575588620:730507 730507 9055 December 05, 2019 - 18:41:16 UTC December 05, 2019 - 22:45:00 UTC December 05, 2019 - 22:45:00 UTC 1 0 35.09398 -120.36633 368 1 5
1575588620:730783 730783 9055 December 05, 2019 - 23:04:24 UTC December 06, 2019 - 02:00:00 UTC December 06, 2019 - 02:00:00 UTC 1 0 37.33795 -120.58037 87 1 1
1575588620:730788 730788 9055 December 05, 2019 - 22:57:01 UTC     1 0 40.76787 -124.18802 612 1 1
1575588620:730730 730730 9055 December 05, 2019 - 23:12:31 UTC December 06, 2019 - 01:30:00 UTC December 06, 2019 - 01:30:00 UTC 1 0 39.49365 -121.92388 386 6 4
1575588620:730299 730299 9055 December 05, 2019 - 16:25:58 UTC December 06, 2019 - 01:00:00 UTC   1 0 39.74199 -121.67622 479 3 2
1575588620:730700 730700 9055 December 05, 2019 - 23:06:09 UTC December 06, 2019 - 00:45:00 UTC December 06, 2019 - 00:45:00 UTC 1 0 37.27178 -121.94457 43 6 4
1575588620:730753 730753 9055 December 05, 2019 - 22:41:58 UTC December 06, 2019 - 01:30:00 UTC December 06, 2019 - 01:30:00 UTC 1 1 37.28024 -121.95922 43 1 1
1575588620:730339 730339 9055 December 05, 2019 - 18:33:47 UTC December 06, 2019 - 01:00:00 UTC   1 0 38.32665 -122.72335 272 2 2
1575588620:730178 730178 9055 December 05, 2019 - 21:36:52 UTC December 06, 2019 - 01:35:00 UTC   1 0 38.54681 -121.71085 120 2 2
1575588620:730624 730624 9055 December 05, 2019 - 22:12:34 UTC December 06, 2019 - 00:15:00 UTC December 06, 2019 - 00:15:00 UTC 1 0 37.95769 -122.61044 226 6 3
1575588620:730662 730662 9055 December 05, 2019 - 23:23:35 UTC December 06, 2019 - 02:00:00 UTC   1 0 38.25907 -122.03762 169 6 4
1575588620:730526 730526 9055 December 05, 2019 - 18:45:42 UTC December 05, 2019 - 22:00:00 UTC December 05, 2019 - 22:00:00 UTC 1 0 37.67209 -122.06441 562 1 1
1575588620:730568 730568 9055 December 05, 2019 - 22:40:20 UTC December 06, 2019 - 00:00:00 UTC   1 0 36.93278 -120.40071 8 3 2
1575588620:730678 730678 9055 December 05, 2019 - 22:19:18 UTC December 06, 2019 - 00:30:00 UTC December 06, 2019 - 00:30:00 UTC 1 0 39.01815 -120.82624 375 6 4
1575588620:730720 730720 9055 December 05, 2019 - 23:02:41 UTC December 06, 2019 - 01:00:00 UTC   1 0 37.51887 -121.9781 140 6 4
1575588620:730807 730807 9055 December 05, 2019 - 23:17:16 UTC December 06, 2019 - 01:00:00 UTC December 06, 2019 - 01:00:00 UTC 1 0 37.53799 -121.99506 140 1 1
1575588620:730623 730623 9055 December 05, 2019 - 22:58:05 UTC December 06, 2019 - 00:30:00 UTC   1 0 37.55185 -122.05814 140 1 1
1575588620:730646 730646 9055 December 05, 2019 - 23:02:50 UTC December 06, 2019 - 01:00:00 UTC   1 0 37.54608 -122.06248 140 1 1
1575588620:730784 730784 9055 December 05, 2019 - 23:03:59 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 1 1 37.54141 -121.99799 140 1 5
1575588620:730771 730771 9055 December 05, 2019 - 22:56:32 UTC December 06, 2019 - 01:15:00 UTC December 06, 2019 - 01:15:00 UTC 1 0 36.72781 -119.80023 35 1 1
1575588620:730767 730767 9055 December 05, 2019 - 23:17:40 UTC December 06, 2019 - 02:00:00 UTC December 06, 2019 - 02:00:00 UTC 1 0 36.84225 -119.79278 35 6 4
1575588620:730757 730757 9055 December 05, 2019 - 22:37:20 UTC December 06, 2019 - 00:00:00 UTC December 06, 2019 - 00:00:00 UTC 1 0 36.78478 -119.85902 35 1 5
1575588620:730619 730619 9055 December 05, 2019 - 21:30:48 UTC December 06, 2019 - 00:00:00 UTC   1 1 36.7697 -119.8307 35 1 1
1575588620:730547 730547 9055 December 05, 2019 - 20:13:38 UTC     1 0 36.53228 -121.48877 406 1 6
1575588620:730770 730770 9055 December 05, 2019 - 22:54:09 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 1 0 36.50302 -121.44636 406 1 1
1575588620:730732 730732 9055 December 05, 2019 - 22:57:30 UTC December 06, 2019 - 04:00:00 UTC   1 0 37.57922 -122.37503 313 2 7
1575588620:730699 730699 9055 December 05, 2019 - 22:07:26 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 1 1 37.99779 -123.0137 402 1 5
1575588620:730766 730766 9055 December 05, 2019 - 22:46:53 UTC December 06, 2019 - 02:00:00 UTC December 06, 2019 - 02:00:00 UTC 1 0 37.88385 -120.39567 193 1 1
1575588620:730739 730739 9055 December 05, 2019 - 23:25:44 UTC December 06, 2019 - 00:00:00 UTC December 06, 2019 - 00:00:00 UTC 1 1 37.93053 -121.2455 664 6 4
1575588620:730772 730772 9055 December 05, 2019 - 23:22:18 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 1 0 36.49484 -119.58403 390 1 5
1575588620:730707 730707 9055 December 05, 2019 - 23:23:41 UTC December 06, 2019 - 01:30:00 UTC   1 1 38.00569 -121.3301 91 1 1
1575588620:730660 730660 9055 December 05, 2019 - 22:05:19 UTC December 06, 2019 - 00:30:00 UTC   1 0 37.36157 -120.72486 308 1 1
1575588620:730295 730295 9055 December 05, 2019 - 23:07:15 UTC December 06, 2019 - 05:00:00 UTC   1 0 37.39456 -122.1163 151 2 2
1575588620:730803 730803 9055 December 05, 2019 - 23:13:55 UTC December 06, 2019 - 02:45:00 UTC December 06, 2019 - 02:45:00 UTC 1 1 37.37982 -122.13633 125 1 1
1575588620:730681 730681 9055 December 05, 2019 - 21:19:44 UTC December 05, 2019 - 23:00:00 UTC December 05, 2019 - 23:00:00 UTC 1 0 37.23414 -121.9231 121 1 1
1575588620:730438 730438 9055 December 05, 2019 - 21:48:41 UTC December 06, 2019 - 01:00:00 UTC   1 0 35.75485 -119.65518 126 1 6
1575588620:730483 730483 9055 December 05, 2019 - 21:49:28 UTC December 06, 2019 - 01:00:00 UTC   1 0 40.93969 -124.08788 333 1 1
1575588620:730566 730566 9055 December 05, 2019 - 20:09:05 UTC December 05, 2019 - 22:45:00 UTC December 05, 2019 - 22:45:00 UTC 1 1 40.93394 -124.12537 333 1 1
1575588620:730762 730762 9055 December 05, 2019 - 23:03:28 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 1 0 36.60126 -121.90221 163 6 4
1575588620:730796 730796 9055 December 05, 2019 - 23:04:30 UTC December 06, 2019 - 02:45:00 UTC December 06, 2019 - 02:45:00 UTC 1 1 40.72948 -122.31812 587 1 1
1575588620:730792 730792 9055 December 05, 2019 - 22:54:32 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 1 0 37.38621 -122.08299 242 1 1
1575588620:730490 730490 9055 December 05, 2019 - 18:18:41 UTC December 05, 2019 - 23:00:00 UTC   1 0 40.23435 -123.80354 257 3 1
1575588620:730550 730550 9055 December 05, 2019 - 23:09:30 UTC December 06, 2019 - 01:00:00 UTC   1 0 39.34901 -121.1207 69 2 2
1575588620:730755 730755 9055 December 05, 2019 - 22:16:08 UTC December 06, 2019 - 01:15:00 UTC December 06, 2019 - 01:15:00 UTC 1 0 39.28709 -121.05074 69 1 1
1575588620:730722 730722 9055 December 05, 2019 - 22:02:21 UTC December 06, 2019 - 00:45:00 UTC December 06, 2019 - 00:45:00 UTC 1 0 37.54277 -122.0623 225 1 1
1575588620:730595 730595 9055 December 05, 2019 - 22:19:16 UTC December 06, 2019 - 00:15:00 UTC   1 0 37.54022 -122.06446 225 1 1
1575588620:730810 730810 9055 December 05, 2019 - 23:22:48 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 1 0 37.29092 -119.53027 128 1 1
1575588620:730754 730754 9055 December 05, 2019 - 22:46:30 UTC December 06, 2019 - 04:30:00 UTC December 06, 2019 - 04:30:00 UTC 1 1 37.37894 -119.60949 312 1 1
1575588620:730434 730434 9055 December 05, 2019 - 22:57:32 UTC December 06, 2019 - 00:30:00 UTC   1 0 37.76553 -122.20758 16 2 2
1575588620:730631 730631 9055 December 05, 2019 - 22:54:02 UTC December 06, 2019 - 01:00:00 UTC   1 0 37.80383 -122.27033 16 6 4
1575588620:730325 730325 9055 December 05, 2019 - 22:47:26 UTC December 06, 2019 - 00:00:00 UTC   1 0 35.41004 -119.01855 246 2 1
1575588620:730781 730781 9055 December 05, 2019 - 23:07:11 UTC December 06, 2019 - 00:30:00 UTC December 06, 2019 - 00:30:00 UTC 1 0 34.86789 -120.42429 249 1 5
1575588620:730717 730717 9055 December 05, 2019 - 23:01:23 UTC December 06, 2019 - 01:00:00 UTC December 06, 2019 - 01:00:00 UTC 1 1 38.83668 -121.05012 573 1 5
1575588620:730689 730689 9055 December 05, 2019 - 21:27:56 UTC December 06, 2019 - 00:45:00 UTC December 06, 2019 - 00:45:00 UTC 1 0 38.7578 -120.59344 278 1 1
1575588620:730298 730298 9055 December 05, 2019 - 20:25:13 UTC December 06, 2019 - 00:00:00 UTC   1 0 40.10501 -122.18712 20 2 2
1575588620:730656 730656 9055 December 05, 2019 - 23:14:36 UTC December 06, 2019 - 00:30:00 UTC December 06, 2019 - 00:30:00 UTC 1 0 40.7078 -122.23954 85 6 4
1575588620:730802 730802 9055 December 05, 2019 - 23:23:49 UTC December 06, 2019 - 02:00:00 UTC December 06, 2019 - 02:00:00 UTC 1 1 37.99517 -122.57766 183 6 4
1575588620:730813 730813 9055 December 05, 2019 - 23:26:00 UTC December 06, 2019 - 02:00:00 UTC December 06, 2019 - 02:00:00 UTC 1 0 37.80178 -122.41439 25 1 1
1575588620:730801 730801 9055 December 05, 2019 - 23:19:09 UTC December 06, 2019 - 00:45:00 UTC December 06, 2019 - 00:45:00 UTC 1 1 37.29765 -121.97512 26 1 5
1575588620:730528 730528 9055 December 05, 2019 - 21:44:09 UTC December 06, 2019 - 00:30:00 UTC   1 0 35.26003 -120.6497 28 1 1
1575588620:730606 730606 9055 December 05, 2019 - 23:10:12 UTC December 06, 2019 - 04:00:00 UTC   1 0 37.08065 -121.57816 305 2 7
1575588620:730776 730776 9055 December 05, 2019 - 23:00:53 UTC December 06, 2019 - 02:15:00 UTC December 06, 2019 - 02:15:00 UTC 1 0 36.95574 -122.035 104 6 4
1575588620:730805 730805 9055 December 05, 2019 - 23:25:43 UTC December 06, 2019 - 02:15:00 UTC December 06, 2019 - 02:15:00 UTC 1 0 38.42048 -122.76112 30 1 1
1575588620:730763 730763 9055 December 05, 2019 - 23:25:38 UTC December 06, 2019 - 02:00:00 UTC December 06, 2019 - 02:00:00 UTC 1 0 34.61643 -120.09366 68 6 4
1575588620:730440 730440 9055 December 05, 2019 - 23:10:28 UTC December 06, 2019 - 06:30:00 UTC   1 0 37.26046 -121.99748 152 2 3
1575588620:730724 730724 9055 December 05, 2019 - 21:58:55 UTC December 05, 2019 - 23:30:00 UTC   1 0 40.60956 -122.49411 588 3 2
1575588620:730603 730603 9055 December 05, 2019 - 22:22:13 UTC December 06, 2019 - 02:00:00 UTC   1 0 37.65133 -122.4348 156 6 4
1575588620:730703 730703 9055 December 05, 2019 - 22:14:07 UTC December 06, 2019 - 03:00:00 UTC December 06, 2019 - 03:00:00 UTC 1 0 38.02378 -121.5328 78 1 1
1575588620:730573 730573 9055 December 05, 2019 - 23:01:07 UTC December 06, 2019 - 00:30:00 UTC   1 0 38.02133 -121.30471 78 6 4
1575588620:730765 730765 9055 December 05, 2019 - 22:51:34 UTC December 06, 2019 - 01:15:00 UTC December 06, 2019 - 01:15:00 UTC 1 1 37.96296 -121.30274 78 1 1
1575588620:730087 730087 9055 December 05, 2019 - 23:24:02 UTC December 06, 2019 - 04:30:00 UTC   1 1 39.3062 -120.382 653 2 2
1575588620:730644 730644 9055 December 05, 2019 - 20:43:27 UTC     1 1 36.86012 -121.75165 49 1 1
1575588620:730280 730280 9055 December 05, 2019 - 23:10:24 UTC December 06, 2019 - 00:00:00 UTC   1 0 39.72528 -123.80779 543 3 2
1575588620:730685 730685 9055 December 05, 2019 - 21:21:08 UTC December 06, 2019 - 00:20:00 UTC   2 0 36.95647 -121.81679 475 2 2
1575588620:730701 730701 9055 December 05, 2019 - 23:18:31 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 2 0 35.0058 -118.94967 2 6 4
1575588620:730808 730808 9055 December 05, 2019 - 23:16:32 UTC December 06, 2019 - 03:30:00 UTC December 06, 2019 - 03:30:00 UTC 2 0 38.10071 -122.87328 402 1 1
1575588620:730304 730304 9055 December 05, 2019 - 17:00:46 UTC December 06, 2019 - 02:00:00 UTC   2 0 38.53649 -122.33731 296 3 2
1575588620:730587 730587 9055 December 05, 2019 - 19:47:35 UTC December 06, 2019 - 00:00:00 UTC   3 0 39.24336 -121.29383 293 3 2
1575588620:730374 730374 9055 December 05, 2019 - 17:18:50 UTC December 06, 2019 - 01:00:00 UTC   3 0 38.54953 -122.47208 275 3 2
1575588620:730651 730651 9055 December 05, 2019 - 20:40:42 UTC December 05, 2019 - 22:30:00 UTC   3 0 39.25708 -121.01235 69 3 2
1575588620:730516 730516 9055 December 05, 2019 - 18:39:11 UTC December 05, 2019 - 22:00:00 UTC   3 0 39.22051 -121.28465 429 3 2
1575588620:730250 730250 9055 December 05, 2019 - 15:34:31 UTC December 05, 2019 - 20:00:00 UTC   3 0 37.01648 -121.79066 49 3 2
1575588620:730647 730647 9055 December 05, 2019 - 22:50:24 UTC December 06, 2019 - 01:00:00 UTC   4 1 38.11664 -122.92621 402 2 2
1575588620:730135 730135 9055 December 05, 2019 - 20:56:45 UTC December 06, 2019 - 06:34:00 UTC   5 0 36.86715 -121.62129 486 2 2
1575588620:730433 730433 9055 December 05, 2019 - 23:26:00 UTC December 06, 2019 - 02:46:00 UTC   5 0 37.11157 -122.04778 474 4 2
1575588620:730349 730349 9055 December 05, 2019 - 17:01:46 UTC December 06, 2019 - 00:00:00 UTC   6 0 35.50166 -120.67342 40 3 2
1575588620:730529 730529 9055 December 05, 2019 - 22:41:01 UTC December 06, 2019 - 05:00:00 UTC   6 0 36.7621 -121.754 227 2 2
1575588620:730475 730475 9055 December 05, 2019 - 23:22:19 UTC December 06, 2019 - 00:00:00 UTC   6 0 39.00351 -121.05324 135 3 2
1575588620:730302 730302 9055 December 05, 2019 - 21:29:05 UTC December 05, 2019 - 23:00:00 UTC   7 0 41.10197 -121.53516 404 3 2
1575588620:730513 730513 9055 December 05, 2019 - 18:35:18 UTC December 06, 2019 - 00:00:00 UTC   7 0 37.93276 -122.53387 382 3 1
1575588620:730659 730659 9055 December 05, 2019 - 21:54:45 UTC December 06, 2019 - 00:30:00 UTC   7 0 39.52373 -122.19747 86 2 2
1575588620:730420 730420 9055 December 05, 2019 - 17:34:15 UTC December 05, 2019 - 22:00:00 UTC   8 0 37.7244 -121.92822 290 3 2
1575588620:730226 730226 9055 December 05, 2019 - 14:53:27 UTC December 06, 2019 - 01:00:00 UTC   8 0 40.44834 -124.26697 112 3 2
1575588620:730275 730275 9055 December 05, 2019 - 20:23:23 UTC December 06, 2019 - 00:00:00 UTC   8 0 38.38129 -122.9027 99 3 2
1575588620:730811 730811 9055 December 05, 2019 - 23:26:03 UTC December 06, 2019 - 02:15:00 UTC December 06, 2019 - 02:15:00 UTC 9 1 36.62093 -119.71371 89 1 1
1575588620:730326 730326 9055 December 05, 2019 - 22:44:05 UTC December 06, 2019 - 00:00:00 UTC   9 0 37.85429 -122.48901 561 1 1
1575588620:730394 730394 9055 December 05, 2019 - 17:18:48 UTC December 05, 2019 - 23:30:00 UTC   10 0 38.93443 -120.75144 161 3 2
1575588620:730192 730192 9055 December 05, 2019 - 18:50:01 UTC December 06, 2019 - 00:35:00 UTC   10 1 37.01634 -121.7201 223 2 2
1575588620:730686 730686 9055 December 05, 2019 - 23:13:25 UTC December 06, 2019 - 00:15:00 UTC December 06, 2019 - 00:15:00 UTC 13 0 37.97091 -122.02877 46 2 3
1575588620:730716 730716 9055 December 05, 2019 - 22:18:52 UTC     16 0 39.00805 -123.36628 771 6 1