pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1575591039:730087 730087 9059 December 05, 2019 - 23:24:02 UTC December 06, 2019 - 04:30:00 UTC   1 1 39.3062 -120.382 653 2 2
1575591039:730135 730135 9059 December 05, 2019 - 20:56:45 UTC December 06, 2019 - 06:34:00 UTC   5 0 36.86715 -121.62129 486 2 2
1575591039:730192 730192 9059 December 05, 2019 - 18:50:01 UTC December 06, 2019 - 00:35:00 UTC   10 1 37.01634 -121.7201 223 2 2
1575591039:730204 730204 9059 December 06, 2019 - 00:00:45 UTC December 06, 2019 - 02:00:00 UTC   129 0 37.84714 -122.27711 16 2 2
1575591039:730226 730226 9059 December 05, 2019 - 14:53:27 UTC December 06, 2019 - 01:00:00 UTC   8 0 40.44834 -124.26697 112 3 2
1575591039:730250 730250 9059 December 05, 2019 - 15:34:31 UTC December 05, 2019 - 20:00:00 UTC   3 0 37.01648 -121.79066 49 3 2
1575591039:730267 730267 9059 December 05, 2019 - 23:20:31 UTC December 06, 2019 - 10:00:00 UTC   55 6 35.38864 -119.00425 2 2 7
1575591039:730275 730275 9059 December 05, 2019 - 20:23:23 UTC December 06, 2019 - 00:00:00 UTC   8 0 38.38129 -122.9027 99 3 2
1575591039:730280 730280 9059 December 05, 2019 - 23:10:24 UTC December 06, 2019 - 00:00:00 UTC   1 0 39.72528 -123.80779 543 3 2
1575591039:730282 730282 9059 December 05, 2019 - 16:15:56 UTC December 06, 2019 - 01:00:00 UTC   28 0 40.46928 -123.70108 620 3 1
1575591039:730295 730295 9059 December 05, 2019 - 23:07:15 UTC December 06, 2019 - 05:00:00 UTC   1 0 37.39456 -122.1163 151 2 2
1575591039:730296 730296 9059 December 05, 2019 - 23:20:58 UTC December 06, 2019 - 01:00:00 UTC   195 0 37.7431 -122.46167 25 3 2
1575591039:730298 730298 9059 December 05, 2019 - 23:52:03 UTC December 06, 2019 - 04:00:00 UTC   1 0 40.10501 -122.18712 20 2 2
1575591039:730299 730299 9059 December 05, 2019 - 16:25:58 UTC December 06, 2019 - 01:00:00 UTC   1 0 39.74199 -121.67622 479 3 2
1575591039:730310 730310 9059 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
1575591039:730325 730325 9059 December 05, 2019 - 22:47:26 UTC December 06, 2019 - 00:00:00 UTC   1 0 35.41004 -119.01855 246 2 1
1575591039:730332 730332 9059 December 05, 2019 - 23:36:36 UTC December 06, 2019 - 00:00:00 UTC   317 0 38.84946 -121.15955 352 3 2
1575591039:730349 730349 9059 December 05, 2019 - 23:32:12 UTC December 06, 2019 - 02:30:00 UTC   6 0 35.50166 -120.67342 40 3 2
1575591039:730356 730356 9059 December 05, 2019 - 17:14:07 UTC December 06, 2019 - 01:30:00 UTC   102 0 37.95955 -122.10526 37 3 2
1575591039:730366 730366 9059 December 05, 2019 - 17:07:44 UTC December 06, 2019 - 01:00:00 UTC   42 0 37.72951 -122.3732 25 3 1
1575591039:730374 730374 9059 December 05, 2019 - 17:18:50 UTC December 06, 2019 - 01:00:00 UTC   3 0 38.54953 -122.47208 275 3 2
1575591039:730394 730394 9059 December 05, 2019 - 17:18:48 UTC December 05, 2019 - 23:30:00 UTC   10 0 38.93443 -120.75144 161 3 2
1575591039:730409 730409 9059 December 05, 2019 - 18:02:56 UTC December 06, 2019 - 01:00:00 UTC   80 0 40.66832 -124.19738 440 3 2
1575591039:730432 730432 9059 December 06, 2019 - 00:04:53 UTC December 06, 2019 - 01:00:00 UTC   48 0 37.01404 -121.59986 223 3 2
1575591039:730433 730433 9059 December 05, 2019 - 23:27:43 UTC December 06, 2019 - 02:46:00 UTC   5 0 37.11157 -122.04778 474 4 2
1575591039:730434 730434 9059 December 05, 2019 - 22:57:32 UTC December 06, 2019 - 00:30:00 UTC   1 0 37.76553 -122.20758 16 2 2
1575591039:730438 730438 9059 December 05, 2019 - 23:53:11 UTC December 06, 2019 - 01:00:00 UTC   1 0 35.75485 -119.65518 126 1 6
1575591039:730440 730440 9059 December 05, 2019 - 23:10:28 UTC December 06, 2019 - 06:30:00 UTC   1 0 37.26046 -121.99748 152 2 3
1575591039:730479 730479 9059 December 05, 2019 - 18:47:52 UTC December 05, 2019 - 23:00:00 UTC   81 0 39.46722 -120.84607 633 3 2
1575591039:730486 730486 9059 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
1575591039:730490 730490 9059 December 05, 2019 - 18:18:41 UTC December 05, 2019 - 23:00:00 UTC   1 0 40.23435 -123.80354 257 3 1
1575591039:730507 730507 9059 December 05, 2019 - 23:31:38 UTC December 06, 2019 - 01:31:00 UTC   1 0 35.09398 -120.36633 368 1 5
1575591039:730513 730513 9059 December 05, 2019 - 18:35:18 UTC December 06, 2019 - 00:00:00 UTC   7 0 37.93276 -122.53387 382 3 1
1575591039:730516 730516 9059 December 05, 2019 - 18:39:11 UTC December 05, 2019 - 22:00:00 UTC   3 0 39.22051 -121.28465 429 3 2
1575591039:730526 730526 9059 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
1575591039:730529 730529 9059 December 05, 2019 - 22:41:01 UTC December 06, 2019 - 05:00:00 UTC   6 0 36.7621 -121.754 227 2 2
1575591039:730547 730547 9059 December 05, 2019 - 20:13:38 UTC     1 0 36.53228 -121.48877 406 1 6
1575591039:730550 730550 9059 December 05, 2019 - 23:09:30 UTC December 06, 2019 - 01:00:00 UTC   1 0 39.34901 -121.1207 69 2 2
1575591039:730568 730568 9059 December 05, 2019 - 23:37:14 UTC December 06, 2019 - 00:00:00 UTC   1 0 36.93278 -120.40071 8 3 3
1575591039:730572 730572 9059 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
1575591039:730577 730577 9059 December 05, 2019 - 23:21:00 UTC December 05, 2019 - 18:00:00 UTC   41 0 37.12285 -121.6593 319 3 3
1575591039:730587 730587 9059 December 05, 2019 - 19:47:35 UTC December 06, 2019 - 00:00:00 UTC   3 0 39.24336 -121.29383 293 3 2
1575591039:730595 730595 9059 December 06, 2019 - 00:04:52 UTC December 06, 2019 - 02:00:00 UTC   1 0 37.54022 -122.06446 225 6 1
1575591039:730603 730603 9059 December 05, 2019 - 23:45:10 UTC December 06, 2019 - 02:00:00 UTC   1 0 37.65133 -122.4348 156 6 4
1575591039:730606 730606 9059 December 05, 2019 - 23:10:12 UTC December 06, 2019 - 04:00:00 UTC   1 0 37.08065 -121.57816 305 2 7
1575591039:730619 730619 9059 December 06, 2019 - 00:00:45 UTC December 06, 2019 - 02:00:00 UTC   1 1 36.7697 -119.8307 35 1 1
1575591039:730623 730623 9059 December 06, 2019 - 00:05:06 UTC December 06, 2019 - 02:00:00 UTC   1 0 37.55185 -122.05814 140 6 1
1575591039:730624 730624 9059 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
1575591039:730631 730631 9059 December 05, 2019 - 23:30:18 UTC December 06, 2019 - 18:00:00 UTC   1 0 37.80383 -122.27033 16 2 3
1575591039:730644 730644 9059 December 05, 2019 - 23:50:56 UTC     1 1 36.86012 -121.75165 49 6 4
1575591039:730646 730646 9059 December 06, 2019 - 00:03:15 UTC December 06, 2019 - 01:00:00 UTC   1 0 37.54608 -122.06248 140 6 4
1575591039:730647 730647 9059 December 05, 2019 - 22:50:24 UTC December 06, 2019 - 01:00:00 UTC   4 1 38.11664 -122.92621 402 2 2
1575591039:730651 730651 9059 December 05, 2019 - 23:39:24 UTC December 06, 2019 - 01:30:00 UTC   3 0 39.25708 -121.01235 69 3 2
1575591039:730660 730660 9059 December 05, 2019 - 22:05:19 UTC December 06, 2019 - 00:30:00 UTC   1 0 37.36157 -120.72486 308 1 1
1575591039:730681 730681 9059 December 05, 2019 - 23:44:43 UTC December 06, 2019 - 02:00:00 UTC   1 0 37.23414 -121.9231 121 6 4
1575591039:730686 730686 9059 December 06, 2019 - 00:05:39 UTC December 06, 2019 - 06:00:00 UTC   13 0 37.97091 -122.02877 46 2 2
1575591039:730689 730689 9059 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
1575591039:730699 730699 9059 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
1575591039:730701 730701 9059 December 06, 2019 - 00:00:10 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 2 0 35.0058 -118.94967 2 2 7
1575591039:730703 730703 9059 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
1575591039:730707 730707 9059 December 05, 2019 - 23:51:12 UTC December 06, 2019 - 01:30:00 UTC   1 1 38.00569 -121.3301 91 6 4
1575591039:730716 730716 9059 December 05, 2019 - 23:50:28 UTC     16 0 39.00805 -123.36628 771 6 4
1575591039:730717 730717 9059 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
1575591039:730722 730722 9059 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
1575591039:730724 730724 9059 December 05, 2019 - 21:58:55 UTC December 05, 2019 - 23:30:00 UTC   1 0 40.60956 -122.49411 588 3 2
1575591039:730725 730725 9059 December 06, 2019 - 00:03:22 UTC December 06, 2019 - 00:45:00 UTC December 06, 2019 - 00:45:00 UTC 1371 1 37.33594 -120.5054 13 4 3
1575591039:730726 730726 9059 December 06, 2019 - 00:04:03 UTC December 06, 2019 - 00:45:00 UTC December 06, 2019 - 00:45:00 UTC 20 0 37.33594 -120.50542 13 2 1
1575591039:730732 730732 9059 December 05, 2019 - 23:59:02 UTC December 06, 2019 - 04:00:00 UTC   1 0 37.57922 -122.37503 313 2 2
1575591039:730753 730753 9059 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
1575591039:730754 730754 9059 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 5
1575591039:730755 730755 9059 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
1575591039:730757 730757 9059 December 05, 2019 - 23:57:26 UTC December 06, 2019 - 00:00:00 UTC December 06, 2019 - 00:00:00 UTC 1 0 36.78478 -119.85902 35 2 3
1575591039:730761 730761 9059 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
1575591039:730762 730762 9059 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
1575591039:730765 730765 9059 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
1575591039:730766 730766 9059 December 05, 2019 - 23:28:01 UTC December 06, 2019 - 02:00:00 UTC December 06, 2019 - 02:00:00 UTC 1 0 37.88385 -120.39567 193 1 5
1575591039:730770 730770 9059 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
1575591039:730771 730771 9059 December 05, 2019 - 23:57:02 UTC December 06, 2019 - 01:15:00 UTC December 06, 2019 - 01:15:00 UTC 1 0 36.72781 -119.80023 35 1 5
1575591039:730781 730781 9059 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
1575591039:730782 730782 9059 December 06, 2019 - 00:03:12 UTC     111 0 38.97812 -122.87044 282 6 5
1575591039:730784 730784 9059 December 05, 2019 - 23:49:33 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 1 1 37.54141 -121.99799 140 6 4
1575591039:730788 730788 9059 December 05, 2019 - 22:57:01 UTC     1 0 40.76787 -124.18802 612 1 1
1575591039:730792 730792 9059 December 05, 2019 - 23:27:02 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 1 0 37.38621 -122.08299 242 1 5
1575591039:730796 730796 9059 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
1575591039:730801 730801 9059 December 05, 2019 - 23:41:17 UTC December 06, 2019 - 00:45:00 UTC December 06, 2019 - 00:45:00 UTC 1 1 37.29765 -121.97512 26 6 4
1575591039:730802 730802 9059 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
1575591039:730803 730803 9059 December 05, 2019 - 23:59:40 UTC December 06, 2019 - 02:45:00 UTC December 06, 2019 - 02:45:00 UTC 1 1 37.37982 -122.13633 125 1 1
1575591039:730805 730805 9059 December 05, 2019 - 23:29:16 UTC December 06, 2019 - 02:15:00 UTC December 06, 2019 - 02:15:00 UTC 1 0 38.42048 -122.76112 30 1 5
1575591039:730807 730807 9059 December 05, 2019 - 23:30:34 UTC December 06, 2019 - 01:00:00 UTC December 06, 2019 - 01:00:00 UTC 1 0 37.53799 -121.99506 140 1 1
1575591039:730808 730808 9059 December 05, 2019 - 23:44:53 UTC December 06, 2019 - 03:30:00 UTC December 06, 2019 - 03:30:00 UTC 2 0 38.10071 -122.87328 402 1 1
1575591039:730810 730810 9059 December 05, 2019 - 23:38:06 UTC December 06, 2019 - 04:00:00 UTC   1 0 37.29092 -119.53027 128 2 2
1575591039:730811 730811 9059 December 05, 2019 - 23:42:24 UTC December 06, 2019 - 02:15:00 UTC December 06, 2019 - 02:15:00 UTC 9 1 36.62093 -119.71371 89 6 4
1575591039:730813 730813 9059 December 05, 2019 - 23:34:19 UTC December 06, 2019 - 02:00:00 UTC December 06, 2019 - 02:00:00 UTC 1 0 37.80178 -122.41439 25 1 1
1575591039:730814 730814 9059 December 05, 2019 - 23:28:28 UTC December 06, 2019 - 02:45:00 UTC December 06, 2019 - 02:45:00 UTC 1 0 38.58534 -121.77344 120 1 1
1575591039:730815 730815 9059 December 06, 2019 - 00:02:03 UTC December 06, 2019 - 02:15:00 UTC December 06, 2019 - 02:15:00 UTC 1 1 37.46235 -122.25169 256 6 4
1575591039:730816 730816 9059 December 05, 2019 - 23:34:56 UTC December 06, 2019 - 02:45:00 UTC December 06, 2019 - 02:45:00 UTC 1 1 38.02051 -122.14502 37 1 5
1575591039:730817 730817 9059 December 05, 2019 - 23:54:02 UTC December 06, 2019 - 02:30:00 UTC December 06, 2019 - 02:30:00 UTC 3 0 37.4388 -122.24005 130 1 1
1575591039:730818 730818 9059 December 05, 2019 - 23:51:33 UTC December 06, 2019 - 02:30:00 UTC December 06, 2019 - 02:30:00 UTC 1 1 40.4875 -122.3668 106 1 1
1575591039:730819 730819 9059 December 05, 2019 - 23:42:42 UTC December 06, 2019 - 01:15:00 UTC December 06, 2019 - 01:15:00 UTC 1 1 37.31204 -121.95417 26 1 1
1575591039:730820 730820 9059 December 05, 2019 - 23:46:48 UTC December 06, 2019 - 02:45:00 UTC December 06, 2019 - 02:45:00 UTC 1 1 37.88958 -122.1233 155 1 1
1575591039:730821 730821 9059 December 05, 2019 - 23:55:35 UTC December 06, 2019 - 01:30:00 UTC December 06, 2019 - 01:30:00 UTC 1 0 37.93048 -121.25876 78 1 1