pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
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: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: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: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:730204 730204 9055 December 05, 2019 - 23:15:43 UTC December 06, 2019 - 02:00:00 UTC   129 0 37.84714 -122.27711 16 2 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: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:730267 730267 9055 December 05, 2019 - 23:20:31 UTC December 06, 2019 - 10:00:00 UTC   55 6 35.38864 -119.00425 2 2 7
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: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:730282 730282 9055 December 05, 2019 - 16:15:56 UTC December 06, 2019 - 01:00:00 UTC   28 0 40.46928 -123.70108 620 3 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:730296 730296 9055 December 05, 2019 - 23:20:58 UTC December 06, 2019 - 01:00:00 UTC   195 0 37.7431 -122.46167 25 3 2
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: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: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: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:730310 730310 9055 December 05, 2019 - 22:34:08 UTC December 05, 2019 - 18:15:00 UTC December 05, 2019 - 18:15:00 UTC 48 0 37.72025 -122.43422 25 1 1
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: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:730332 730332 9055 December 05, 2019 - 23:24:21 UTC December 06, 2019 - 00:00:00 UTC   317 0 38.84946 -121.15955 352 3 2
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: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:730356 730356 9055 December 05, 2019 - 17:14:07 UTC December 06, 2019 - 01:30:00 UTC   102 0 37.95955 -122.10526 37 3 2
1575588620:730366 730366 9055 December 05, 2019 - 17:07:44 UTC December 06, 2019 - 01:00:00 UTC   42 0 37.72951 -122.3732 25 3 1
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:730387 730387 9055 December 05, 2019 - 23:01:27 UTC December 06, 2019 - 01:00:00 UTC   143 0 37.5652 -122.29286 29 3 2
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:730397 730397 9055 December 05, 2019 - 19:51:54 UTC December 06, 2019 - 03:00:00 UTC   23 0 37.47131 -122.16683 141 3 4
1575588620:730409 730409 9055 December 05, 2019 - 18:02:56 UTC December 06, 2019 - 01:00:00 UTC   80 0 40.66832 -124.19738 440 3 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:730432 730432 9055 December 05, 2019 - 17:49:44 UTC December 06, 2019 - 01:00:00 UTC   48 0 37.01404 -121.59986 223 3 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: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:730436 730436 9055 December 05, 2019 - 17:45:25 UTC December 06, 2019 - 00:30:00 UTC   26 0 38.44686 -122.72323 30 3 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: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: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:730479 730479 9055 December 05, 2019 - 18:47:52 UTC December 05, 2019 - 23:00:00 UTC   81 0 39.46722 -120.84607 633 3 2
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:730486 730486 9055 December 05, 2019 - 21:06:22 UTC December 05, 2019 - 21:15:00 UTC December 05, 2019 - 21:15:00 UTC 220 0 37.74062 -121.44116 38 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: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: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: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: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: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: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:730547 730547 9055 December 05, 2019 - 20:13:38 UTC     1 0 36.53228 -121.48877 406 1 6
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: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: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: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: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:730577 730577 9055 December 05, 2019 - 23:21:00 UTC December 05, 2019 - 18:00:00 UTC   41 0 37.12285 -121.6593 319 3 3
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: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: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: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: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: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: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: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:730644 730644 9055 December 05, 2019 - 20:43:27 UTC     1 1 36.86012 -121.75165 49 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: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: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: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: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: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: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: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: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: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: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: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: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: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: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: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: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:730713 730713 9055 December 05, 2019 - 22:43:12 UTC December 06, 2019 - 00:45:00 UTC December 06, 2019 - 00:45:00 UTC 54 0 39.18402 -120.99946 113 6 4
1575588620:730716 730716 9055 December 05, 2019 - 22:18:52 UTC     16 0 39.00805 -123.36628 771 6 1
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: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: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: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:730725 730725 9055 December 05, 2019 - 23:25:26 UTC December 06, 2019 - 00:45:00 UTC December 06, 2019 - 00:45:00 UTC 1371 1 37.33594 -120.5054 13 4 3
1575588620:730726 730726 9055 December 05, 2019 - 23:25:10 UTC December 06, 2019 - 00:45:00 UTC December 06, 2019 - 00:45:00 UTC 3300 0 37.33594 -120.50542 13 2 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: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: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: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: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: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: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:730761 730761 9055 December 05, 2019 - 23:09:47 UTC December 06, 2019 - 01:15:00 UTC December 06, 2019 - 01:15:00 UTC 24 0 37.32187 -120.49011 13 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: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: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: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