outage_snapshots

where regionName = 43 sorted by currentEtor

View and edit SQL

id outage snapshot lastUpdateTime currentEtor ▼ autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1570813819:654293 654293 654293 2019-10-11 10:10:19-07:00 1371 October 11, 2019 - 17:03:01 UTC     1 1 37.27653 -121.94241 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570814423:654293 654293 654293 2019-10-11 10:20:23-07:00 1372 October 11, 2019 - 17:09:33 UTC     1 1 37.27653 -121.94241 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570815023:654293 654293 654293 2019-10-11 10:30:23-07:00 1373 October 11, 2019 - 17:21:23 UTC     1 1 37.27653 -121.94241 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570815624:654293 654293 654293 2019-10-11 10:40:24-07:00 1374 October 11, 2019 - 17:21:23 UTC     1 1 37.27653 -121.94241 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570816215:654293 654293 654293 2019-10-11 10:50:15-07:00 1375 October 11, 2019 - 17:21:23 UTC     1 1 37.27653 -121.94241 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570816834:654293 654293 654293 2019-10-11 11:00:34-07:00 1376 October 11, 2019 - 17:42:34 UTC     1 1 37.27653 -121.94241 Campbell 43 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570840820:654795 654795 654795 2019-10-11 17:40:20-07:00 1414 October 12, 2019 - 00:31:07 UTC     1 0 37.28584 -121.9473 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570841415:654795 654795 654795 2019-10-11 17:50:15-07:00 1415 October 12, 2019 - 00:31:07 UTC     1 0 37.28584 -121.9473 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570842021:654795 654795 654795 2019-10-11 18:00:21-07:00 1416 October 12, 2019 - 00:31:07 UTC     1 0 37.28584 -121.9473 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570842614:654795 654795 654795 2019-10-11 18:10:14-07:00 1417 October 12, 2019 - 00:31:07 UTC     1 0 37.28584 -121.9473 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570843268:654795 654795 654795 2019-10-11 18:21:08-07:00 1418 October 12, 2019 - 00:31:07 UTC     1 0 37.28584 -121.9473 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570843826:654795 654795 654795 2019-10-11 18:30:26-07:00 1419 October 12, 2019 - 00:31:07 UTC     1 0 37.28584 -121.9473 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570844413:654795 654795 654795 2019-10-11 18:40:13-07:00 1420 October 12, 2019 - 00:31:07 UTC     1 0 37.28584 -121.9473 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570845016:654795 654795 654795 2019-10-11 18:50:16-07:00 1421 October 12, 2019 - 00:31:07 UTC     1 0 37.28584 -121.9473 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570845619:654795 654795 654795 2019-10-11 19:00:19-07:00 1422 October 12, 2019 - 00:31:07 UTC     1 0 37.28584 -121.9473 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570846222:654795 654795 654795 2019-10-11 19:10:22-07:00 1423 October 12, 2019 - 00:31:07 UTC     1 0 37.28584 -121.9473 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570846820:654795 654795 654795 2019-10-11 19:20:20-07:00 1424 October 12, 2019 - 00:31:07 UTC     1 0 37.28584 -121.9473 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570847425:654795 654795 654795 2019-10-11 19:30:25-07:00 1425 October 12, 2019 - 02:15:32 UTC     1 0 37.28584 -121.9473 Campbell 43 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570848022:654795 654795 654795 2019-10-11 19:40:22-07:00 1426 October 12, 2019 - 02:15:32 UTC     1 0 37.28584 -121.9473 Campbell 43 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572220252:690253 690253 690253 2019-10-27 16:50:52-07:00 3626 October 27, 2019 - 23:36:46 UTC     1 1 37.2697 -121.96689 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572220830:690253 690253 690253 2019-10-27 17:00:30-07:00 3627 October 27, 2019 - 23:36:46 UTC     1 1 37.2697 -121.96689 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572221431:690253 690253 690253 2019-10-27 17:10:31-07:00 3628 October 27, 2019 - 23:54:31 UTC     1 1 37.2697 -121.96689 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572222042:690253 690253 690253 2019-10-27 17:20:42-07:00 3629 October 27, 2019 - 23:54:31 UTC     1 1 37.2697 -121.96689 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572222914:690253 690253 690253 2019-10-27 17:35:14-07:00 3630 October 27, 2019 - 23:54:31 UTC     1 1 37.2697 -121.96689 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572223843:690253 690253 690253 2019-10-27 17:50:43-07:00 3631 October 27, 2019 - 23:54:31 UTC     1 1 37.2697 -121.96689 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572224421:690253 690253 690253 2019-10-27 18:00:21-07:00 3632 October 27, 2019 - 23:54:31 UTC     1 1 37.2697 -121.96689 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572225030:690253 690253 690253 2019-10-27 18:10:30-07:00 3633 October 27, 2019 - 23:54:31 UTC     1 1 37.2697 -121.96689 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572225638:690253 690253 690253 2019-10-27 18:20:38-07:00 3634 October 27, 2019 - 23:54:31 UTC     1 1 37.2697 -121.96689 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572226224:690253 690253 690253 2019-10-27 18:30:24-07:00 3635 October 27, 2019 - 23:54:31 UTC     1 1 37.2697 -121.96689 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572226819:690253 690253 690253 2019-10-27 18:40:19-07:00 3636 October 27, 2019 - 23:54:31 UTC     1 1 37.2697 -121.96689 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572228641:690253 690253 690253 2019-10-27 19:10:41-07:00 3637 October 27, 2019 - 23:54:31 UTC     1 1 37.2697 -121.96689 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572229275:690253 690253 690253 2019-10-27 19:21:15-07:00 3638 October 27, 2019 - 23:54:31 UTC     1 1 37.2697 -121.96689 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572229829:690253 690253 690253 2019-10-27 19:30:29-07:00 3639 October 28, 2019 - 02:24:45 UTC     1 1 37.2697 -121.96689 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572230426:690253 690253 690253 2019-10-27 19:40:26-07:00 3640 October 28, 2019 - 02:24:45 UTC     1 1 37.2697 -121.96689 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572231032:690253 690253 690253 2019-10-27 19:50:32-07:00 3641 October 28, 2019 - 02:36:21 UTC     1 1 37.2697 -121.96689 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572231631:690253 690253 690253 2019-10-27 20:00:31-07:00 3642 October 28, 2019 - 02:36:21 UTC     1 1 37.2697 -121.96689 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572232242:690253 690253 690253 2019-10-27 20:10:42-07:00 3643 October 28, 2019 - 03:05:32 UTC     17 1 37.2697 -121.96689 Campbell 43 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572232822:690253 690253 690253 2019-10-27 20:20:22-07:00 3644 October 28, 2019 - 03:05:32 UTC     17 1 37.2697 -121.96689 Campbell 43 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572240629:690995 690995 690995 2019-10-27 22:30:29-07:00 3655 October 28, 2019 - 05:19:02 UTC     1 0 37.292 -121.94815 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572241241:690995 690995 690995 2019-10-27 22:40:41-07:00 3656 October 28, 2019 - 05:19:02 UTC     1 0 37.292 -121.94815 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572241826:690995 690995 690995 2019-10-27 22:50:26-07:00 3657 October 28, 2019 - 05:19:02 UTC     1 0 37.292 -121.94815 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572242435:690995 690995 690995 2019-10-27 23:00:35-07:00 3658 October 28, 2019 - 05:19:02 UTC     1 0 37.292 -121.94815 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572243019:690995 690995 690995 2019-10-27 23:10:19-07:00 3659 October 28, 2019 - 05:19:02 UTC     1 0 37.292 -121.94815 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572243641:690995 690995 690995 2019-10-27 23:20:41-07:00 3660 October 28, 2019 - 05:19:02 UTC     1 0 37.292 -121.94815 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572244829:690995 690995 690995 2019-10-27 23:40:29-07:00 3661 October 28, 2019 - 06:24:48 UTC     1 0 37.292 -121.94815 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572245427:690995 690995 690995 2019-10-27 23:50:27-07:00 3662 October 28, 2019 - 06:38:16 UTC     1 0 37.292 -121.94815 Campbell 43 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572246053:690995 690995 690995 2019-10-28 00:00:53-07:00 3663 October 28, 2019 - 06:38:16 UTC     1 0 37.292 -121.94815 Campbell 43 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572246621:690995 690995 690995 2019-10-28 00:10:21-07:00 3664 October 28, 2019 - 06:38:16 UTC     1 0 37.292 -121.94815 Campbell 43 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572247844:690995 690995 690995 2019-10-28 00:30:44-07:00 3665 October 28, 2019 - 06:38:16 UTC     1 0 37.292 -121.94815 Campbell 43 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572306030:692253 692253 692253 2019-10-28 16:40:30-07:00 3734 October 28, 2019 - 23:24:36 UTC     1 0 37.27518 -121.96121 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572306622:692253 692253 692253 2019-10-28 16:50:22-07:00 3735 October 28, 2019 - 23:39:07 UTC     1 0 37.27518 -121.96121 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572307313:692253 692253 692253 2019-10-28 17:01:53-07:00 3736 October 28, 2019 - 23:39:07 UTC     1 0 37.27518 -121.96121 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572307834:692253 692253 692253 2019-10-28 17:10:34-07:00 3737 October 28, 2019 - 23:39:07 UTC     1 0 37.27518 -121.96121 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572308452:692253 692253 692253 2019-10-28 17:20:52-07:00 3738 October 28, 2019 - 23:39:07 UTC     1 0 37.27518 -121.96121 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572309042:692253 692253 692253 2019-10-28 17:30:42-07:00 3739 October 28, 2019 - 23:39:07 UTC     1 0 37.27518 -121.96121 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572309628:692253 692253 692253 2019-10-28 17:40:28-07:00 3740 October 28, 2019 - 23:39:07 UTC     1 0 37.27518 -121.96121 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572310233:692253 692253 692253 2019-10-28 17:50:33-07:00 3741 October 28, 2019 - 23:39:07 UTC     1 0 37.27518 -121.96121 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572310826:692253 692253 692253 2019-10-28 18:00:26-07:00 3742 October 28, 2019 - 23:39:07 UTC     1 0 37.27518 -121.96121 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572311437:692253 692253 692253 2019-10-28 18:10:37-07:00 3743 October 28, 2019 - 23:39:07 UTC     1 0 37.27518 -121.96121 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572312016:692253 692253 692253 2019-10-28 18:20:16-07:00 3744 October 28, 2019 - 23:39:07 UTC     1 0 37.27518 -121.96121 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572342632:692870 692870 692870 2019-10-29 02:50:32-07:00 3787 October 29, 2019 - 09:45:24 UTC     94 0 37.29081 -121.95834 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572343243:692870 692870 692870 2019-10-29 03:00:43-07:00 3788 October 29, 2019 - 09:47:15 UTC     94 0 37.29081 -121.95834 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572343829:692870 692870 692870 2019-10-29 03:10:29-07:00 3789 October 29, 2019 - 09:47:15 UTC     94 0 37.29081 -121.95834 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572344419:692870 692870 692870 2019-10-29 03:20:19-07:00 3790 October 29, 2019 - 09:47:15 UTC     94 0 37.29081 -121.95834 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572345028:692870 692870 692870 2019-10-29 03:30:28-07:00 3791 October 29, 2019 - 09:47:15 UTC     94 0 37.29081 -121.95834 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572345629:692870 692870 692870 2019-10-29 03:40:29-07:00 3792 October 29, 2019 - 09:47:15 UTC     94 0 37.29081 -121.95834 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572346219:692870 692870 692870 2019-10-29 03:50:19-07:00 3793 October 29, 2019 - 09:47:15 UTC     94 0 37.29081 -121.95834 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572346837:692870 692870 692870 2019-10-29 04:00:37-07:00 3794 October 29, 2019 - 10:49:01 UTC     94 0 37.29081 -121.95834 Campbell 43 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572347418:692870 692870 692870 2019-10-29 04:10:18-07:00 3795 October 29, 2019 - 11:00:47 UTC     94 0 37.29081 -121.95834 Campbell 43 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572364242:693231 693231 693231 2019-10-29 08:50:42-07:00 3821 October 29, 2019 - 15:31:15 UTC     1 0 37.28573 -121.94161 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572364907:693231 693231 693231 2019-10-29 09:01:47-07:00 3822 October 29, 2019 - 15:31:15 UTC     1 0 37.28573 -121.94161 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572365422:693231 693231 693231 2019-10-29 09:10:22-07:00 3823 October 29, 2019 - 15:31:15 UTC     1 0 37.28573 -121.94161 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572366032:693231 693231 693231 2019-10-29 09:20:32-07:00 3824 October 29, 2019 - 15:31:15 UTC     1 0 37.28573 -121.94161 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572366032:693402 693402 693402 2019-10-29 09:20:32-07:00 3824 October 29, 2019 - 16:16:14 UTC     1 1 37.27318 -121.98188 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572366631:693231 693231 693231 2019-10-29 09:30:31-07:00 3825 October 29, 2019 - 15:31:15 UTC     1 0 37.28573 -121.94161 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572366631:693402 693402 693402 2019-10-29 09:30:31-07:00 3825 October 29, 2019 - 16:21:16 UTC     1 1 37.27318 -121.98188 Campbell 43 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572367239:693231 693231 693231 2019-10-29 09:40:39-07:00 3826 October 29, 2019 - 15:31:15 UTC     1 0 37.28573 -121.94161 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572367824:693231 693231 693231 2019-10-29 09:50:24-07:00 3827 October 29, 2019 - 15:31:15 UTC     1 0 37.28573 -121.94161 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572367824:693466 693466 693466 2019-10-29 09:50:24-07:00 3827 October 29, 2019 - 16:46:14 UTC     1 0 37.28677 -121.93981 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572368443:693231 693231 693231 2019-10-29 10:00:43-07:00 3828 October 29, 2019 - 15:31:15 UTC     1 0 37.28573 -121.94161 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572368443:693466 693466 693466 2019-10-29 10:00:43-07:00 3828 October 29, 2019 - 16:46:14 UTC     1 0 37.28677 -121.93981 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572369028:693231 693231 693231 2019-10-29 10:10:28-07:00 3829 October 29, 2019 - 15:31:15 UTC     1 0 37.28573 -121.94161 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572369028:693466 693466 693466 2019-10-29 10:10:28-07:00 3829 October 29, 2019 - 16:46:14 UTC     1 0 37.28677 -121.93981 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572369624:693231 693231 693231 2019-10-29 10:20:24-07:00 3830 October 29, 2019 - 15:31:15 UTC     1 0 37.28573 -121.94161 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572369624:693466 693466 693466 2019-10-29 10:20:24-07:00 3830 October 29, 2019 - 16:46:14 UTC     1 0 37.28677 -121.93981 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572370240:693231 693231 693231 2019-10-29 10:30:40-07:00 3831 October 29, 2019 - 15:31:15 UTC     1 0 37.28573 -121.94161 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572370240:693466 693466 693466 2019-10-29 10:30:40-07:00 3831 October 29, 2019 - 17:20:20 UTC     1 0 37.28677 -121.93981 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572370835:693231 693231 693231 2019-10-29 10:40:35-07:00 3832 October 29, 2019 - 15:31:15 UTC     1 0 37.28573 -121.94161 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572370835:693466 693466 693466 2019-10-29 10:40:35-07:00 3832 October 29, 2019 - 17:20:20 UTC     1 0 37.28677 -121.93981 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572372116:693231 693231 693231 2019-10-29 11:01:56-07:00 3833 October 29, 2019 - 17:51:43 UTC     1 0 37.28573 -121.94161 Campbell 43 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572379829:694034 694034 694034 2019-10-29 13:10:29-07:00 3844 October 29, 2019 - 19:58:09 UTC     1 0 37.28636 -121.94214 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572381049:694034 694034 694034 2019-10-29 13:30:49-07:00 3845 October 29, 2019 - 19:58:09 UTC     1 0 37.28636 -121.94214 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572381625:694034 694034 694034 2019-10-29 13:40:25-07:00 3846 October 29, 2019 - 19:58:09 UTC     1 0 37.28636 -121.94214 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572382242:694034 694034 694034 2019-10-29 13:50:42-07:00 3847 October 29, 2019 - 19:58:09 UTC     1 0 37.28636 -121.94214 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572382854:694034 694034 694034 2019-10-29 14:00:54-07:00 3848 October 29, 2019 - 19:58:09 UTC     1 0 37.28636 -121.94214 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572384031:694034 694034 694034 2019-10-29 14:20:31-07:00 3849 October 29, 2019 - 19:58:09 UTC     1 0 37.28636 -121.94214 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572384623:694034 694034 694034 2019-10-29 14:30:23-07:00 3850 October 29, 2019 - 19:58:09 UTC     1 0 37.28636 -121.94214 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572385261:694034 694034 694034 2019-10-29 14:41:01-07:00 3851 October 29, 2019 - 21:23:27 UTC     1 0 37.28636 -121.94214 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572386436:694034 694034 694034 2019-10-29 15:00:36-07:00 3852 October 29, 2019 - 21:23:27 UTC     1 0 37.28636 -121.94214 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572387020:694034 694034 694034 2019-10-29 15:10:20-07:00 3853 October 29, 2019 - 21:58:00 UTC     1 0 37.28636 -121.94214 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [outage_snapshots] (
   [id] TEXT PRIMARY KEY,
   [outage] INTEGER REFERENCES [outages]([id]),
   [snapshot] INTEGER REFERENCES [snapshots]([id]),
   [lastUpdateTime] INTEGER,
   [currentEtor] INTEGER,
   [autoEtor] INTEGER,
   [estCustAffected] INTEGER,
   [hazardFlag] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [regionName] INTEGER REFERENCES [regionName]([id]),
   [cause] INTEGER REFERENCES [cause]([id]),
   [crewCurrentStatus] INTEGER REFERENCES [crewCurrentStatus]([id])
)
Powered by Datasette · Query took 9358.477ms · About: About this site