pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1569968422:630055 630055 93 September 30, 2019 - 15:29:50 UTC October 02, 2019 - 23:00:00 UTC   1 0 38.12243 -121.83043 21 3 2
1569968422:631014 631014 93 September 30, 2019 - 17:04:42 UTC October 03, 2019 - 21:30:00 UTC   1 0 39.0775 -121.52568 17 3 4
1569968422:633552 633552 93 October 01, 2019 - 14:22:00 UTC October 02, 2019 - 00:00:00 UTC   1 0 36.13868 -120.12345 51 3 2
1569968422:633550 633550 93 October 01, 2019 - 14:22:00 UTC October 02, 2019 - 00:00:00 UTC   1 0 36.13872 -120.12345 51 3 2
1569968422:633551 633551 93 October 01, 2019 - 14:22:00 UTC October 02, 2019 - 00:00:00 UTC   1 0 36.13871 -120.12345 51 3 2
1569968422:633624 633624 93 October 01, 2019 - 15:26:57 UTC October 01, 2019 - 23:00:00 UTC   9 0 34.95908 -120.51911 52 3 2
1569968422:633573 633573 93 October 01, 2019 - 15:45:57 UTC October 01, 2019 - 23:00:00 UTC   28 0 38.84408 -122.20342 59 3 2
1569968422:633797 633797 93 October 01, 2019 - 16:05:51 UTC October 02, 2019 - 00:00:00 UTC   11 0 40.50248 -124.28154 112 3 2
1569968422:633801 633801 93 October 01, 2019 - 16:10:48 UTC October 02, 2019 - 00:00:00 UTC   43 0 37.95149 -122.32156 111 3 2
1569968422:633488 633488 93 October 01, 2019 - 16:14:10 UTC October 02, 2019 - 01:00:00 UTC   27 1 35.99202 -119.57146 10 2 2
1569968422:633825 633825 93 October 01, 2019 - 16:21:41 UTC October 02, 2019 - 00:00:00 UTC   23 0 37.70608 -122.47673 124 3 2
1569968422:633839 633839 93 October 01, 2019 - 16:32:29 UTC October 01, 2019 - 23:00:00 UTC   25 0 36.61702 -119.27635 136 3 2
1569968422:633822 633822 93 October 01, 2019 - 16:32:36 UTC October 01, 2019 - 23:00:00 UTC   38 0 37.32107 -122.05454 123 3 2
1569968422:633854 633854 93 October 01, 2019 - 16:40:32 UTC October 01, 2019 - 23:00:00 UTC   3 0 37.3744 -121.80994 133 3 1
1569968422:633886 633886 93 October 01, 2019 - 16:58:34 UTC October 01, 2019 - 23:00:00 UTC   4 0 38.38715 -122.97488 148 3 2
1569968422:633891 633891 93 October 01, 2019 - 17:21:18 UTC October 01, 2019 - 20:00:00 UTC October 01, 2019 - 20:00:00 UTC 1 0 39.21249 -121.14529 97 1 1
1569968422:633903 633903 93 October 01, 2019 - 17:24:30 UTC October 02, 2019 - 00:00:00 UTC   28 0 37.84959 -122.21253 16 3 2
1569968422:633867 633867 93 October 01, 2019 - 18:00:05 UTC October 01, 2019 - 23:00:00 UTC   3 0 36.61702 -119.27686 136 3 3
1569968422:633888 633888 93 October 01, 2019 - 18:16:14 UTC October 02, 2019 - 00:00:00 UTC   1 0 37.83546 -122.22186 16 1 1
1569968422:633590 633590 93 October 01, 2019 - 18:48:21 UTC October 02, 2019 - 00:00:00 UTC   89 0 34.61365 -120.07835 68 3 3
1569968422:633940 633940 93 October 01, 2019 - 18:59:43 UTC October 01, 2019 - 23:00:00 UTC   1 0 38.10863 -122.23096 154 6 3
1569968422:633804 633804 93 October 01, 2019 - 19:13:13 UTC October 02, 2019 - 03:00:00 UTC   5 0 40.38922 -122.26397 56 2 2
1569968422:633837 633837 93 October 01, 2019 - 19:22:04 UTC October 01, 2019 - 22:00:00 UTC   79 0 37.37026 -121.80912 26 3 1
1569968422:633599 633599 93 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569968422:633805 633805 93 October 01, 2019 - 19:31:17 UTC October 02, 2019 - 03:00:00 UTC   1 0 40.38934 -122.264 56 1 1
1569968422:633542 633542 93 October 01, 2019 - 19:34:33 UTC October 02, 2019 - 03:00:00 UTC   14 0 36.99019 -121.73674 49 2 2
1569968422:633950 633950 93 October 01, 2019 - 20:02:44 UTC October 02, 2019 - 05:30:00 UTC   1 0 37.65995 -122.38797 156 1 1
1569968422:633602 633602 93 October 01, 2019 - 20:08:52 UTC October 02, 2019 - 03:00:00 UTC   116 0 35.15721 -120.66906 18 3 2
1569968422:634513 634513 93 October 01, 2019 - 20:11:28 UTC October 01, 2019 - 22:45:00 UTC October 01, 2019 - 22:45:00 UTC 1 1 36.79197 -121.65849 190 6 4
1569968422:634434 634434 93 October 01, 2019 - 20:13:50 UTC October 01, 2019 - 22:45:00 UTC October 01, 2019 - 22:45:00 UTC 1 0 36.52389 -119.61108 100 2 3
1569968422:634713 634713 93 October 01, 2019 - 20:18:07 UTC     1 0 37.717 -122.44714 25 1 1
1569968422:634007 634007 93 October 01, 2019 - 20:18:55 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 1 37.34889 -122.04992 129 1 5
1569968422:633774 633774 93 October 01, 2019 - 20:26:41 UTC October 01, 2019 - 21:00:00 UTC   1 0 38.64604 -120.97578 101 3 3
1569968422:634815 634815 93 October 01, 2019 - 20:33:08 UTC October 01, 2019 - 23:30:00 UTC October 01, 2019 - 23:30:00 UTC 1 0 36.82298 -119.7708 35 1 1
1569968422:634613 634613 93 October 01, 2019 - 20:34:49 UTC October 01, 2019 - 23:15:00 UTC October 01, 2019 - 23:15:00 UTC 1 0 36.38594 -119.65496 73 1 1
1569968422:633547 633547 93 October 01, 2019 - 20:40:03 UTC October 01, 2019 - 23:00:00 UTC   4 0 41.17032 -121.68866 50 3 2
1569968422:633753 633753 93 October 01, 2019 - 20:42:43 UTC October 01, 2019 - 23:00:00 UTC   43 0 38.21709 -122.63594 96 3 2
1569968422:633866 633866 93 October 01, 2019 - 20:47:25 UTC October 02, 2019 - 03:21:00 UTC   7 0 38.01599 -120.225 145 2 2
1569968422:634818 634818 93 October 01, 2019 - 20:48:17 UTC October 01, 2019 - 23:15:00 UTC October 01, 2019 - 23:15:00 UTC 1 0 37.50102 -122.25797 24 1 1
1569968422:633816 633816 93 October 01, 2019 - 20:49:11 UTC October 01, 2019 - 23:00:00 UTC   12 0 39.00698 -123.41581 122 3 2
1569968422:633971 633971 93 October 01, 2019 - 20:50:03 UTC October 02, 2019 - 03:00:00 UTC   5 2 39.66681 -121.73549 167 2 2
1569968422:634514 634514 93 October 01, 2019 - 21:02:26 UTC October 02, 2019 - 00:30:00 UTC October 02, 2019 - 00:30:00 UTC 1 0 35.59666 -119.76676 126 1 1
1569968422:634834 634834 93 October 01, 2019 - 21:02:48 UTC October 02, 2019 - 00:30:00 UTC October 02, 2019 - 00:30:00 UTC 1 0 38.74886 -122.62171 200 1 1
1569968422:634827 634827 93 October 01, 2019 - 21:09:28 UTC October 02, 2019 - 00:00:00 UTC   28 0 38.68994 -120.78757 72 3 2
1569968422:634093 634093 93 October 01, 2019 - 21:09:34 UTC October 01, 2019 - 23:00:00 UTC   2 1 40.61849 -122.47477 180 2 2
1569968422:634839 634839 93 October 01, 2019 - 21:09:57 UTC     25 0 37.73528 -122.4484 25 1 1
1569968422:633849 633849 93 October 01, 2019 - 21:10:56 UTC October 02, 2019 - 06:59:00 UTC   19 0 36.82228 -119.80053 35 2 3
1569968422:633546 633546 93 October 01, 2019 - 21:11:46 UTC October 02, 2019 - 03:00:00 UTC   9 0 37.87055 -122.03021 33 2 2
1569968422:633965 633965 93 October 01, 2019 - 21:13:44 UTC October 01, 2019 - 22:45:00 UTC October 01, 2019 - 22:45:00 UTC 1 0 35.32583 -119.35054 162 2 3
1569968422:634842 634842 93 October 01, 2019 - 21:15:47 UTC October 02, 2019 - 00:30:00 UTC October 02, 2019 - 00:30:00 UTC 1 0 37.96776 -121.6848 95 1 1
1569968422:634841 634841 93 October 01, 2019 - 21:15:47 UTC October 01, 2019 - 23:30:00 UTC   2 0 39.06359 -121.01819 113 2 2
1569968422:634832 634832 93 October 01, 2019 - 21:15:47 UTC October 01, 2019 - 22:00:00 UTC   10 0 38.64148 -120.51459 150 3 2
1569968422:634133 634133 93 October 01, 2019 - 21:21:05 UTC October 02, 2019 - 00:00:00 UTC   1 0 37.62163 -122.40958 55 6 4
1569968422:634843 634843 93 October 01, 2019 - 21:23:02 UTC October 02, 2019 - 00:30:00 UTC October 02, 2019 - 00:30:00 UTC 1 2 39.31515 -122.01282 132 2 4
1569968422:634183 634183 93 October 01, 2019 - 21:24:09 UTC October 01, 2019 - 21:00:00 UTC   67 0 37.97339 -122.57139 183 3 2
1569968422:634814 634814 93 October 01, 2019 - 21:24:16 UTC October 02, 2019 - 00:15:00 UTC October 02, 2019 - 00:15:00 UTC 1 1 38.69436 -121.93466 34 6 4
1569968422:633524 633524 93 October 01, 2019 - 21:26:24 UTC October 01, 2019 - 23:30:00 UTC   94 0 37.29072 -121.95844 43 2 2
1569968422:634185 634185 93 October 01, 2019 - 21:28:22 UTC October 01, 2019 - 22:45:00 UTC   1 1 39.37272 -121.29 182 6 4
1569968422:634847 634847 93 October 01, 2019 - 21:35:24 UTC October 02, 2019 - 00:30:00 UTC October 02, 2019 - 00:30:00 UTC 1 1 36.71806 -119.55262 189 1 5
1569968422:634849 634849 93 October 01, 2019 - 21:35:26 UTC October 02, 2019 - 01:00:00 UTC October 02, 2019 - 01:00:00 UTC 1 1 40.01626 -122.40273 202 1 1
1569968422:634837 634837 93 October 01, 2019 - 21:37:27 UTC October 02, 2019 - 01:04:00 UTC   20 0 37.53355 -121.97215 140 2 2
1569968422:633862 633862 93 October 01, 2019 - 21:39:42 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569968422:634835 634835 93 October 01, 2019 - 21:41:40 UTC October 02, 2019 - 00:30:00 UTC October 02, 2019 - 00:30:00 UTC 1 0 37.81369 -121.28245 199 6 4
1569968422:633989 633989 93 October 01, 2019 - 21:41:50 UTC October 02, 2019 - 05:30:00 UTC   1 0 37.59193 -122.41318 173 1 1
1569968422:633635 633635 93 October 01, 2019 - 21:42:34 UTC October 02, 2019 - 01:00:00 UTC   42 0 37.74341 -122.46635 25 3 2
1569968422:634855 634855 93 October 01, 2019 - 21:42:39 UTC October 02, 2019 - 03:00:00 UTC October 02, 2019 - 03:00:00 UTC 1 1 40.20866 -123.49266 205 1 1
1569968422:634013 634013 93 October 01, 2019 - 21:43:39 UTC October 01, 2019 - 23:45:00 UTC   1 0 36.42984 -119.99478 22 1 5
1569968422:634830 634830 93 October 01, 2019 - 21:45:06 UTC October 02, 2019 - 03:00:00 UTC   73 0 37.97436 -121.75807 42 2 2
1569968422:634433 634433 93 October 01, 2019 - 21:47:04 UTC October 01, 2019 - 22:00:00 UTC   8 0 38.65722 -122.61247 108 4 2
1569968422:633964 633964 93 October 01, 2019 - 21:48:26 UTC October 01, 2019 - 22:58:00 UTC   2 0 37.57104 -121.99067 140 2 3
1569968422:634856 634856 93 October 01, 2019 - 21:48:26 UTC October 02, 2019 - 00:45:00 UTC October 02, 2019 - 00:45:00 UTC 1 0 38.00219 -121.89409 204 1 1
1569968422:634854 634854 93 October 01, 2019 - 21:48:28 UTC October 02, 2019 - 00:00:00 UTC October 02, 2019 - 00:00:00 UTC 1 0 37.58335 -122.34946 203 1 5
1569968422:634861 634861 93 October 01, 2019 - 21:51:41 UTC October 01, 2019 - 23:00:00 UTC   2 0 36.96874 -119.39027 79 3 2
1569968422:634694 634694 93 October 01, 2019 - 21:52:17 UTC October 01, 2019 - 22:45:00 UTC October 01, 2019 - 22:45:00 UTC 1 0 36.9708 -120.05688 76 6 4
1569968422:634859 634859 93 October 01, 2019 - 21:52:22 UTC October 02, 2019 - 01:00:00 UTC October 02, 2019 - 01:00:00 UTC 1 1 38.88155 -120.88162 207 1 1
1569968422:633649 633649 93 October 01, 2019 - 21:52:55 UTC October 02, 2019 - 01:00:00 UTC   4 1 38.40058 -122.51294 90 2 2
1569968422:633962 633962 93 October 01, 2019 - 21:53:42 UTC October 02, 2019 - 04:00:00 UTC   15 1 37.54962 -122.33508 29 2 3
1569968422:634863 634863 93 October 01, 2019 - 21:56:08 UTC October 02, 2019 - 01:15:00 UTC October 02, 2019 - 01:15:00 UTC 1 1 38.00148 -120.33263 209 1 1
1569968422:634833 634833 93 October 01, 2019 - 21:58:07 UTC October 02, 2019 - 03:30:00 UTC October 02, 2019 - 03:30:00 UTC 1 0 35.28337 -119.63854 195 6 4
1569968422:634753 634753 93 October 01, 2019 - 22:00:11 UTC October 01, 2019 - 23:45:00 UTC October 01, 2019 - 23:45:00 UTC 1 0 36.61242 -119.89452 35 6 4
1569968422:634864 634864 93 October 01, 2019 - 22:00:20 UTC October 02, 2019 - 00:30:00 UTC October 02, 2019 - 00:30:00 UTC 1 1 38.93724 -121.04828 181 1 5
1569968422:633549 633549 93 October 01, 2019 - 22:00:38 UTC October 01, 2019 - 23:31:00 UTC   3 0 37.29066 -121.95854 43 2 2
1569968422:634865 634865 93 October 01, 2019 - 22:00:55 UTC October 02, 2019 - 01:15:00 UTC October 02, 2019 - 01:15:00 UTC 1 0 38.78533 -120.75834 19 1 5
1569968422:634867 634867 93 October 01, 2019 - 22:00:59 UTC October 01, 2019 - 18:30:00 UTC   21 0 37.64395 -122.48781 174 3 2
1569968422:633572 633572 93 October 01, 2019 - 22:01:08 UTC October 02, 2019 - 04:01:00 UTC   1 0 37.72031 -122.38494 25 2 2
1569968422:634862 634862 93 October 01, 2019 - 22:01:19 UTC October 01, 2019 - 23:30:00 UTC October 01, 2019 - 23:30:00 UTC 1 0 37.97076 -121.34596 206 1 5
1569968422:634553 634553 93 October 01, 2019 - 22:01:32 UTC October 02, 2019 - 01:01:00 UTC   1 0 37.56459 -122.29399 29 6 4
1569968422:633869 633869 93 October 01, 2019 - 22:02:27 UTC October 01, 2019 - 22:00:00 UTC   1 0 40.51095 -124.01787 139 3 3
1569968422:634866 634866 93 October 01, 2019 - 22:04:26 UTC October 02, 2019 - 01:00:00 UTC October 02, 2019 - 01:00:00 UTC 1 1 38.44864 -121.83079 45 1 5
1569968422:634852 634852 93 October 01, 2019 - 22:05:02 UTC October 02, 2019 - 00:30:00 UTC October 02, 2019 - 00:30:00 UTC 1 0 37.97909 -122.49745 144 2 7
1569968422:633972 633972 93 October 01, 2019 - 22:06:00 UTC October 01, 2019 - 23:30:00 UTC   1 1 39.53287 -121.56963 166 6 4
1569968422:634858 634858 93 October 01, 2019 - 22:06:22 UTC October 02, 2019 - 01:00:00 UTC October 02, 2019 - 01:00:00 UTC 1 1 37.88844 -122.2615 47 1 5
1569968422:633844 633844 93 October 01, 2019 - 22:06:38 UTC October 01, 2019 - 23:00:00 UTC   12 0 37.37402 -121.8091 133 3 1
1569968422:633516 633516 93 October 01, 2019 - 22:06:42 UTC October 01, 2019 - 23:00:00 UTC   41 1 35.52131 -120.71256 40 2 2
1569968422:633785 633785 93 October 01, 2019 - 22:07:16 UTC October 01, 2019 - 21:30:00 UTC   34 0 39.21671 -120.79452 105 3 2
1569968422:633827 633827 93 October 01, 2019 - 22:07:43 UTC October 02, 2019 - 00:00:00 UTC   4 0 37.38808 -122.26323 130 3 2
1569968422:633994 633994 93 October 01, 2019 - 22:08:17 UTC October 02, 2019 - 00:00:00 UTC   1 0 37.3018 -120.46319 13 6 4
1569968422:633656 633656 93 October 01, 2019 - 22:09:52 UTC October 01, 2019 - 23:30:00 UTC   1 0 37.97116 -122.34512 98 6 4
1569968422:634848 634848 93 October 01, 2019 - 22:10:15 UTC October 01, 2019 - 23:45:00 UTC October 01, 2019 - 23:45:00 UTC 1 0 39.14739 -121.57565 198 6 4
1569968422:633853 633853 93 October 01, 2019 - 22:10:56 UTC October 02, 2019 - 00:00:00 UTC   58 0 37.83484 -122.22104 16 3 2
1569968422:634870 634870 93 October 01, 2019 - 22:11:19 UTC October 02, 2019 - 01:15:00 UTC October 02, 2019 - 01:15:00 UTC 1 0 38.00994 -121.872 204 1 1
Powered by Datasette · Query took 1296.856ms · About: About this site