pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1570749020:645732 645732 1269 October 10, 2019 - 14:02:20 UTC     6 1 37.57056 -119.94187 211 6 6
1570749020:645873 645873 1269 October 07, 2019 - 15:46:59 UTC October 17, 2019 - 20:00:00 UTC   2 0 38.44571 -121.7909 45 3 2
1570749020:646975 646975 1269 October 09, 2019 - 00:54:10 UTC     56 0 37.57056 -119.94187 211 1 6
1570749020:647518 647518 1269 October 10, 2019 - 00:13:33 UTC October 10, 2019 - 22:30:00 UTC   0 1 39.22256 -121.05152 113 5 2
1570749020:647581 647581 1269 October 10, 2019 - 02:03:46 UTC October 11, 2019 - 02:03:00 UTC   25 0 36.9083 -119.08629 564 2 3
1570749020:647731 647731 1269 October 10, 2019 - 22:02:11 UTC     1 0 38.2916 -122.60869 96 9 3
1570749020:647737 647737 1269 October 09, 2019 - 22:34:37 UTC     7 0 38.31326 -122.3487 15 9 1
1570749020:647781 647781 1269 October 09, 2019 - 16:12:03 UTC     2 0 40.84884 -121.99079 149 9 1
1570749020:647805 647805 1269 October 10, 2019 - 22:31:10 UTC     605 0 39.04439 -121.09116 113 9 1
1570749020:647811 647811 1269 October 09, 2019 - 07:47:53 UTC     13 0 39.92046 -122.38385 289 9 1
1570749020:647812 647812 1269 October 10, 2019 - 20:43:23 UTC     227 0 38.84479 -121.16635 352 9 1
1570749020:647815 647815 1269 October 10, 2019 - 15:08:30 UTC     237 0 39.04439 -121.09111 113 9 1
1570749020:647816 647816 1269 October 10, 2019 - 21:10:06 UTC     89 0 39.95799 -122.29083 289 9 1
1570749020:647826 647826 1269 October 10, 2019 - 20:59:05 UTC     1468 0 39.04439 -121.09104 113 9 1
1570749020:647842 647842 1269 October 10, 2019 - 22:54:56 UTC     96 0 39.20866 -121.30258 429 9 1
1570749020:647843 647843 1269 October 10, 2019 - 16:24:46 UTC     131 0 38.43298 -122.40211 586 9 1
1570749020:647850 647850 1269 October 10, 2019 - 21:19:31 UTC     831 1 37.8966 -122.53936 322 9 1
1570749020:647853 647853 1269 October 10, 2019 - 22:28:56 UTC     3421 1 38.27652 -122.46214 324 9 1
1570749020:647855 647855 1269 October 10, 2019 - 22:52:56 UTC     1306 0 38.90162 -121.08804 181 9 1
1570749020:647856 647856 1269 October 10, 2019 - 22:42:03 UTC     469 0 38.42084 -120.549 460 9 1
1570749020:647863 647863 1269 October 10, 2019 - 00:53:04 UTC     6 0 38.42084 -120.54897 460 9 1
1570749020:647865 647865 1269 October 10, 2019 - 22:57:22 UTC     2185 0 38.29524 -122.27857 15 9 1
1570749020:647871 647871 1269 October 10, 2019 - 21:03:16 UTC     2030 0 38.31552 -122.6815 451 9 1
1570749020:647873 647873 1269 October 10, 2019 - 20:36:45 UTC     130 0 40.42657 -122.22485 106 9 1
1570749020:647876 647876 1269 October 10, 2019 - 22:59:00 UTC     2615 0 38.65549 -121.06028 298 9 1
1570749020:647887 647887 1269 October 09, 2019 - 09:52:25 UTC     0 0 39.2093 -121.06158 113 9 1
1570749020:647892 647892 1269 October 09, 2019 - 07:54:57 UTC     38 0 38.90159 -121.08803 181 9 1
1570749020:647897 647897 1269 October 10, 2019 - 22:46:51 UTC     2002 0 38.27652 -122.46211 324 9 1
1570749020:647899 647899 1269 October 09, 2019 - 16:16:39 UTC     0 0 40.67758 -122.34994 631 9 1
1570749020:647903 647903 1269 October 10, 2019 - 22:48:07 UTC     3257 1 38.26301 -122.26914 15 9 1
1570749020:647904 647904 1269 October 10, 2019 - 21:21:09 UTC     256 0 39.99671 -122.4058 202 9 1
1570749020:647908 647908 1269 October 10, 2019 - 18:18:40 UTC     122 0 38.33108 -120.67252 360 9 1
1570749020:647912 647912 1269 October 10, 2019 - 21:09:13 UTC     73 0 38.41274 -120.66079 433 9 1
1570749020:647916 647916 1269 October 10, 2019 - 20:54:34 UTC     31 0 39.49192 -121.54049 320 9 1
1570749020:647917 647917 1269 October 10, 2019 - 21:38:43 UTC     422 0 40.37892 -122.28111 56 9 1
1570749020:647919 647919 1269 October 10, 2019 - 03:03:14 UTC     16 0 38.70935 -121.07937 298 9 1
1570749020:647920 647920 1269 October 10, 2019 - 17:21:27 UTC     132 0 40.01494 -122.39762 202 9 1
1570749020:647932 647932 1269 October 10, 2019 - 21:43:44 UTC     338 0 38.92761 -121.24689 245 9 1
1570749020:647935 647935 1269 October 09, 2019 - 15:54:54 UTC     0 0 40.12826 -122.09798 20 9 1
1570749020:647939 647939 1269 October 09, 2019 - 08:00:36 UTC     17 0 37.94071 -122.70707 541 9 1
1570749020:647940 647940 1269 October 10, 2019 - 00:07:36 UTC     79 0 39.91489 -122.42872 289 9 1
1570749020:647946 647946 1269 October 10, 2019 - 22:27:23 UTC     130 1 39.91318 -122.42953 289 9 1
1570749020:647949 647949 1269 October 10, 2019 - 19:26:54 UTC     196 0 38.98477 -121.29166 245 9 1
1570749020:647959 647959 1269 October 10, 2019 - 16:03:12 UTC     84 0 40.41716 -122.19647 106 9 1
1570749020:647963 647963 1269 October 10, 2019 - 23:00:26 UTC     576 1 38.70059 -120.81208 72 9 1
1570749020:647964 647964 1269 October 09, 2019 - 07:51:02 UTC     17 0 37.93647 -122.70348 541 9 1
1570749020:647966 647966 1269 October 09, 2019 - 07:49:48 UTC     88 0 39.89041 -122.53694 20 9 1
1570749020:647971 647971 1269 October 10, 2019 - 18:22:08 UTC     107 0 39.02271 -121.29376 245 9 1
1570749020:647974 647974 1269 October 10, 2019 - 20:11:51 UTC     402 0 37.91799 -122.71163 541 9 1
1570749020:647978 647978 1269 October 10, 2019 - 16:25:12 UTC     274 1 40.38947 -122.30686 56 9 1
1570749020:647980 647980 1269 October 10, 2019 - 22:26:04 UTC     69 0 38.34541 -122.29915 15 9 1
1570749020:647983 647983 1269 October 09, 2019 - 08:02:47 UTC     10 0 40.40446 -122.12166 70 9 1
1570749020:647986 647986 1269 October 09, 2019 - 12:45:14 UTC     20 0 37.93162 -122.69788 541 9 1
1570749020:647987 647987 1269 October 10, 2019 - 22:03:53 UTC     272 0 38.89016 -121.09881 181 9 1
1570749020:647988 647988 1269 October 10, 2019 - 20:22:13 UTC     344 0 38.41502 -120.68521 433 9 1
1570749020:647996 647996 1269 October 10, 2019 - 15:41:45 UTC     286 0 37.92527 -122.69817 541 9 1
1570749020:647997 647997 1269 October 09, 2019 - 08:03:42 UTC     0 0 38.59253 -122.57857 108 9 1
1570749020:648003 648003 1269 October 10, 2019 - 22:19:57 UTC     310 0 38.89016 -121.09884 181 9 1
1570749020:648004 648004 1269 October 10, 2019 - 22:55:45 UTC     723 0 38.49991 -122.45899 296 9 1
1570749020:648006 648006 1269 October 10, 2019 - 22:14:55 UTC     668 0 40.37322 -122.28259 56 9 1
1570749020:648009 648009 1269 October 09, 2019 - 12:50:12 UTC     5 0 37.94418 -122.70347 541 9 1
1570749020:648016 648016 1269 October 10, 2019 - 20:28:58 UTC     551 0 40.35609 -122.32636 56 9 1
1570749020:648020 648020 1269 October 09, 2019 - 08:07:25 UTC     11 0 38.79465 -122.06209 442 9 1
1570749020:648023 648023 1269 October 10, 2019 - 22:12:26 UTC     2972 5 38.27652 -122.46209 324 9 1
1570749020:648025 648025 1269 October 10, 2019 - 17:47:39 UTC     343 0 38.88903 -121.27596 245 9 1
1570749020:648026 648026 1269 October 10, 2019 - 23:02:44 UTC     617 0 40.35917 -122.33775 56 9 1
1570749020:648028 648028 1269 October 09, 2019 - 07:58:43 UTC     6 0 37.95588 -122.61762 226 9 1
1570749020:648029 648029 1269 October 10, 2019 - 22:46:28 UTC     289 0 40.3378 -122.37169 56 9 1
1570749020:648030 648030 1269 October 10, 2019 - 20:28:58 UTC     327 0 39.36757 -122.54849 591 9 1
1570749020:648036 648036 1269 October 09, 2019 - 14:23:01 UTC     28 0 38.34541 -122.29912 15 9 1
1570749020:648038 648038 1269 October 10, 2019 - 22:44:20 UTC     265 0 38.88697 -121.23809 245 9 1
1570749020:648043 648043 1269 October 10, 2019 - 03:27:20 UTC     72 0 37.93426 -122.69676 541 9 1
1570749020:648045 648045 1269 October 10, 2019 - 22:11:58 UTC     632 0 38.65973 -120.94699 270 9 1
1570749020:648048 648048 1269 October 10, 2019 - 21:38:48 UTC     771 0 38.49991 -122.45897 296 9 1
1570749020:648049 648049 1269 October 10, 2019 - 15:35:01 UTC     243 0 37.89933 -122.63475 239 9 1
1570749020:648050 648050 1269 October 10, 2019 - 22:36:33 UTC     57 1 40.38941 -122.29185 56 9 1
1570749020:648052 648052 1269 October 10, 2019 - 22:39:28 UTC     440 1 40.38947 -122.34307 56 9 1
1570749020:648055 648055 1269 October 10, 2019 - 22:47:02 UTC     199 0 38.85467 -121.15054 117 9 1
1570749020:648057 648057 1269 October 10, 2019 - 21:36:23 UTC     262 0 40.38851 -122.40788 56 9 1
1570749020:648060 648060 1269 October 10, 2019 - 18:14:09 UTC     595 0 38.49991 -122.45903 296 9 1
1570749020:648069 648069 1269 October 10, 2019 - 22:26:08 UTC     240 0 40.38571 -122.31152 56 9 1
1570749020:648072 648072 1269 October 09, 2019 - 08:15:07 UTC     0 0 39.94154 -122.04134 289 9 1
1570749020:648073 648073 1269 October 09, 2019 - 08:07:42 UTC     50 0 38.76701 -121.16172 531 9 1
1570749020:648075 648075 1269 October 10, 2019 - 22:03:01 UTC     120 0 40.38925 -122.34133 56 9 1
1570749020:648077 648077 1269 October 10, 2019 - 23:05:05 UTC     1400 0 38.84946 -121.15955 352 9 1
1570749020:648079 648079 1269 October 09, 2019 - 16:27:07 UTC     6 0 39.94147 -122.04141 289 9 1
1570749020:648081 648081 1269 October 10, 2019 - 20:34:07 UTC     111 0 40.36972 -122.34424 56 9 1
1570749020:648082 648082 1269 October 10, 2019 - 20:13:35 UTC     483 0 38.76725 -121.15711 531 9 1
1570749020:648084 648084 1269 October 10, 2019 - 01:12:58 UTC     47 0 39.78092 -122.29706 64 9 1
1570749020:648086 648086 1269 October 10, 2019 - 17:43:26 UTC     66 0 39.8559 -121.91926 41 9 1
1570749020:648090 648090 1269 October 09, 2019 - 09:48:56 UTC     0 0 38.75311 -122.60799 200 9 1
1570749020:648094 648094 1269 October 09, 2019 - 14:08:06 UTC     1 0 38.67412 -122.57224 602 9 1
1570749020:648099 648099 1269 October 09, 2019 - 10:33:43 UTC     43 0 38.42355 -122.39127 15 9 1
1570749020:648121 648121 1269 October 09, 2019 - 16:25:47 UTC     0 0 40.14518 -122.21231 20 9 1
1570749020:648133 648133 1269 October 09, 2019 - 15:02:35 UTC     1 0 39.49193 -121.5406 320 9 1
1570749020:648171 648171 1269 October 09, 2019 - 10:11:43 UTC     0 0 38.93275 -122.74089 282 9 1
1570749020:648200 648200 1269 October 09, 2019 - 16:25:37 UTC     0 0 40.06437 -122.15631 326 9 1
1570749020:648204 648204 1269 October 10, 2019 - 01:04:23 UTC     314 0 39.89208 -121.20431 292 9 1
1570749020:648208 648208 1269 October 10, 2019 - 23:04:11 UTC     2978 0 38.27652 -122.46202 324 9 1
1570749020:648212 648212 1269 October 10, 2019 - 19:23:24 UTC     172 0 39.61047 -122.53187 608 9 1
1570749020:648237 648237 1269 October 10, 2019 - 23:04:25 UTC     250 0 40.36491 -122.40625 56 9 1
Powered by Datasette · Query took 498.463ms · About: About this site