outage_snapshots

20,050 rows where regionName = 35 sorted by currentEtor

View and edit SQL

id outage snapshot lastUpdateTime currentEtor ▼ autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1572183633:686800 686800 686800 2019-10-27 06:40:33-07:00 3572 October 27, 2019 - 13:27:34 UTC     1 0 36.76385 -119.96317 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572183633:686801 686801 686801 2019-10-27 06:40:33-07:00 3572 October 27, 2019 - 13:29:17 UTC     45 0 36.76393 -119.96092 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572183633:686799 686799 686799 2019-10-27 06:40:33-07:00 3572 October 27, 2019 - 13:27:34 UTC     1 0 36.76405 -119.97057 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572192644:687296 687296 687296 2019-10-27 09:10:44-07:00 3585 October 27, 2019 - 15:57:34 UTC     1 0 36.71758 -119.70193 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572193821:687447 687447 687447 2019-10-27 09:30:21-07:00 3586 October 27, 2019 - 16:23:25 UTC     1 0 36.84355 -119.8061 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572193821:687296 687296 687296 2019-10-27 09:30:21-07:00 3586 October 27, 2019 - 15:57:34 UTC     1 0 36.71758 -119.70193 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572194421:687469 687469 687469 2019-10-27 09:40:21-07:00 3587 October 27, 2019 - 16:31:52 UTC     1 0 36.87052 -119.77195 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572194421:687478 687478 687478 2019-10-27 09:40:21-07:00 3587 October 27, 2019 - 16:35:21 UTC     15 0 36.70799 -119.76376 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572194421:687296 687296 687296 2019-10-27 09:40:21-07:00 3587 October 27, 2019 - 15:57:34 UTC     1 0 36.71758 -119.70193 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572195024:687469 687469 687469 2019-10-27 09:50:24-07:00 3588 October 27, 2019 - 16:36:48 UTC     1 0 36.87052 -119.77195 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572195024:687296 687296 687296 2019-10-27 09:50:24-07:00 3588 October 27, 2019 - 15:57:34 UTC     1 0 36.71758 -119.70193 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572195622:687469 687469 687469 2019-10-27 10:00:22-07:00 3589 October 27, 2019 - 16:42:50 UTC     1 0 36.87052 -119.77195 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572195622:687296 687296 687296 2019-10-27 10:00:22-07:00 3589 October 27, 2019 - 15:57:34 UTC     1 0 36.71758 -119.70193 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572196223:687549 687549 687549 2019-10-27 10:10:23-07:00 3590 October 27, 2019 - 17:01:04 UTC     1 1 36.71955 -120.01954 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572196223:687469 687469 687469 2019-10-27 10:10:23-07:00 3590 October 27, 2019 - 16:42:50 UTC     1 0 36.87052 -119.77195 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572196223:687296 687296 687296 2019-10-27 10:10:23-07:00 3590 October 27, 2019 - 15:57:34 UTC     1 0 36.71758 -119.70193 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572196826:687549 687549 687549 2019-10-27 10:20:26-07:00 3591 October 27, 2019 - 17:01:04 UTC     1 1 36.71955 -120.01954 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572196826:687469 687469 687469 2019-10-27 10:20:26-07:00 3591 October 27, 2019 - 16:42:50 UTC     1 0 36.87052 -119.77195 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572196826:687296 687296 687296 2019-10-27 10:20:26-07:00 3591 October 27, 2019 - 17:04:01 UTC     1 0 36.71758 -119.70193 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572197442:687549 687549 687549 2019-10-27 10:30:42-07:00 3592 October 27, 2019 - 17:01:04 UTC     1 1 36.71955 -120.01954 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572197442:687469 687469 687469 2019-10-27 10:30:42-07:00 3592 October 27, 2019 - 16:42:50 UTC     1 0 36.87052 -119.77195 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572198015:687549 687549 687549 2019-10-27 10:40:15-07:00 3593 October 27, 2019 - 17:23:26 UTC     1 1 36.71955 -120.01954 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572198015:687469 687469 687469 2019-10-27 10:40:15-07:00 3593 October 27, 2019 - 16:42:50 UTC     1 0 36.87052 -119.77195 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572198619:687549 687549 687549 2019-10-27 10:50:19-07:00 3594 October 27, 2019 - 17:31:31 UTC     1 1 36.71955 -120.01954 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572198619:687469 687469 687469 2019-10-27 10:50:19-07:00 3594 October 27, 2019 - 17:39:41 UTC     1 0 36.87052 -119.77195 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572199230:687549 687549 687549 2019-10-27 11:00:30-07:00 3595 October 27, 2019 - 17:31:31 UTC     1 1 36.71955 -120.01954 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572199230:687469 687469 687469 2019-10-27 11:00:30-07:00 3595 October 27, 2019 - 17:39:41 UTC     1 0 36.87052 -119.77195 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572199838:687549 687549 687549 2019-10-27 11:10:38-07:00 3596 October 27, 2019 - 17:51:47 UTC     1 1 36.71955 -120.01954 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572199838:687469 687469 687469 2019-10-27 11:10:38-07:00 3596 October 27, 2019 - 17:39:41 UTC     1 0 36.87052 -119.77195 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572200419:687549 687549 687549 2019-10-27 11:20:19-07:00 3597 October 27, 2019 - 17:51:47 UTC     1 1 36.71955 -120.01954 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572200419:687469 687469 687469 2019-10-27 11:20:19-07:00 3597 October 27, 2019 - 17:39:41 UTC     1 0 36.87052 -119.77195 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572201028:687549 687549 687549 2019-10-27 11:30:28-07:00 3598 October 27, 2019 - 17:51:47 UTC     1 1 36.71955 -120.01954 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572201028:687469 687469 687469 2019-10-27 11:30:28-07:00 3598 October 27, 2019 - 17:39:41 UTC     1 0 36.87052 -119.77195 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572201620:687549 687549 687549 2019-10-27 11:40:20-07:00 3599 October 27, 2019 - 17:51:47 UTC     1 1 36.71955 -120.01954 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572201620:687469 687469 687469 2019-10-27 11:40:20-07:00 3599 October 27, 2019 - 18:25:38 UTC     1 0 36.87052 -119.77195 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572204020:687549 687549 687549 2019-10-27 12:20:20-07:00 3600 October 27, 2019 - 18:32:45 UTC     1 1 36.71955 -120.01954 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572204020:687469 687469 687469 2019-10-27 12:20:20-07:00 3600 October 27, 2019 - 18:25:38 UTC     1 0 36.87052 -119.77195 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572204618:687549 687549 687549 2019-10-27 12:30:18-07:00 3601 October 27, 2019 - 18:32:45 UTC     1 1 36.71955 -120.01954 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572204618:687469 687469 687469 2019-10-27 12:30:18-07:00 3601 October 27, 2019 - 18:25:38 UTC     1 0 36.87052 -119.77195 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572205225:687549 687549 687549 2019-10-27 12:40:25-07:00 3602 October 27, 2019 - 18:32:45 UTC     1 1 36.71955 -120.01954 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572205225:687469 687469 687469 2019-10-27 12:40:25-07:00 3602 October 27, 2019 - 18:25:38 UTC     1 0 36.87052 -119.77195 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572205846:687549 687549 687549 2019-10-27 12:50:46-07:00 3603 October 27, 2019 - 18:32:45 UTC     1 1 36.71955 -120.01954 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572205846:687469 687469 687469 2019-10-27 12:50:46-07:00 3603 October 27, 2019 - 19:32:11 UTC     1 0 36.87052 -119.77195 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7
1572206438:687549 687549 687549 2019-10-27 13:00:38-07:00 3604 October 27, 2019 - 18:32:45 UTC     1 1 36.71955 -120.01954 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572206438:687469 687469 687469 2019-10-27 13:00:38-07:00 3604 October 27, 2019 - 19:32:11 UTC     1 0 36.87052 -119.77195 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7
1572207026:687549 687549 687549 2019-10-27 13:10:26-07:00 3605 October 27, 2019 - 19:50:58 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572207026:687469 687469 687469 2019-10-27 13:10:26-07:00 3605 October 27, 2019 - 19:32:11 UTC     1 0 36.87052 -119.77195 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7
1572207619:687549 687549 687549 2019-10-27 13:20:19-07:00 3606 October 27, 2019 - 19:50:58 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572207619:687469 687469 687469 2019-10-27 13:20:19-07:00 3606 October 27, 2019 - 19:32:11 UTC     1 0 36.87052 -119.77195 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7
1572208219:687549 687549 687549 2019-10-27 13:30:19-07:00 3607 October 27, 2019 - 19:50:58 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572208219:687469 687469 687469 2019-10-27 13:30:19-07:00 3607 October 27, 2019 - 19:32:11 UTC     1 0 36.87052 -119.77195 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7
1572208825:687549 687549 687549 2019-10-27 13:40:25-07:00 3608 October 27, 2019 - 19:50:58 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572208825:687469 687469 687469 2019-10-27 13:40:25-07:00 3608 October 27, 2019 - 19:32:11 UTC     1 0 36.87052 -119.77195 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7
1572209423:687549 687549 687549 2019-10-27 13:50:23-07:00 3609 October 27, 2019 - 19:50:58 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572209423:687469 687469 687469 2019-10-27 13:50:23-07:00 3609 October 27, 2019 - 19:32:11 UTC     1 0 36.87052 -119.77195 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7
1572209423:688936 688936 688936 2019-10-27 13:50:23-07:00 3609 October 27, 2019 - 20:41:25 UTC     1368 0 36.7661 -119.78144 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572209423:688906 688906 688906 2019-10-27 13:50:23-07:00 3609 October 27, 2019 - 20:34:23 UTC     1 0 36.7863 -119.79814 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572209423:688905 688905 688905 2019-10-27 13:50:23-07:00 3609 October 27, 2019 - 20:34:23 UTC     1 0 36.77814 -119.79737 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572210024:687549 687549 687549 2019-10-27 14:00:24-07:00 3610 October 27, 2019 - 20:44:45 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572210024:687469 687469 687469 2019-10-27 14:00:24-07:00 3610 October 27, 2019 - 19:32:11 UTC     1 0 36.87052 -119.77195 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7
1572210024:688936 688936 688936 2019-10-27 14:00:24-07:00 3610 October 27, 2019 - 20:45:54 UTC     1368 0 36.7661 -119.78144 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572210024:688906 688906 688906 2019-10-27 14:00:24-07:00 3610 October 27, 2019 - 20:34:23 UTC     1 0 36.7863 -119.79814 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572210024:688905 688905 688905 2019-10-27 14:00:24-07:00 3610 October 27, 2019 - 20:34:23 UTC     1 0 36.77814 -119.79737 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572210621:689013 689013 689013 2019-10-27 14:10:21-07:00 3611 October 27, 2019 - 20:46:37 UTC     1 0 36.75761 -119.78385 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572210621:689022 689022 689022 2019-10-27 14:10:21-07:00 3611 October 27, 2019 - 20:52:43 UTC     3 0 36.84355 -119.8061 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572210621:687549 687549 687549 2019-10-27 14:10:21-07:00 3611 October 27, 2019 - 20:44:45 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572210621:688936 688936 688936 2019-10-27 14:10:21-07:00 3611 October 27, 2019 - 21:05:51 UTC     1368 1 36.7661 -119.78144 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572211217:689013 689013 689013 2019-10-27 14:20:17-07:00 3612 October 27, 2019 - 20:46:37 UTC     1 0 36.75761 -119.78385 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572211217:689022 689022 689022 2019-10-27 14:20:17-07:00 3612 October 27, 2019 - 20:52:43 UTC     3 0 36.84355 -119.8061 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572211217:687549 687549 687549 2019-10-27 14:20:17-07:00 3612 October 27, 2019 - 20:44:45 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572211217:688936 688936 688936 2019-10-27 14:20:17-07:00 3612 October 27, 2019 - 21:12:41 UTC     1368 1 36.7661 -119.78144 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572211828:689022 689022 689022 2019-10-27 14:30:28-07:00 3613 October 27, 2019 - 20:52:43 UTC     3 0 36.84355 -119.8061 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572211828:687549 687549 687549 2019-10-27 14:30:28-07:00 3613 October 27, 2019 - 20:44:45 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572211828:689393 689393 689393 2019-10-27 14:30:28-07:00 3613 October 27, 2019 - 21:21:14 UTC     1 0 36.75499 -119.786 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572211828:689392 689392 689392 2019-10-27 14:30:28-07:00 3613 October 27, 2019 - 21:21:14 UTC     1 0 36.76638 -119.77465 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572212416:689022 689022 689022 2019-10-27 14:40:16-07:00 3614 October 27, 2019 - 20:52:43 UTC     3 0 36.84355 -119.8061 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572212416:687549 687549 687549 2019-10-27 14:40:16-07:00 3614 October 27, 2019 - 20:44:45 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572213020:689022 689022 689022 2019-10-27 14:50:20-07:00 3615 October 27, 2019 - 20:52:43 UTC     3 0 36.84355 -119.8061 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572213020:687549 687549 687549 2019-10-27 14:50:20-07:00 3615 October 27, 2019 - 20:44:45 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572213622:689022 689022 689022 2019-10-27 15:00:22-07:00 3616 October 27, 2019 - 20:52:43 UTC     3 0 36.84355 -119.8061 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572213622:687549 687549 687549 2019-10-27 15:00:22-07:00 3616 October 27, 2019 - 20:44:45 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572214818:689022 689022 689022 2019-10-27 15:20:18-07:00 3617 October 27, 2019 - 20:52:43 UTC     3 0 36.84355 -119.8061 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572214818:687549 687549 687549 2019-10-27 15:20:18-07:00 3617 October 27, 2019 - 20:44:45 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572215421:689022 689022 689022 2019-10-27 15:30:21-07:00 3618 October 27, 2019 - 20:52:43 UTC     3 0 36.84355 -119.8061 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572215421:687549 687549 687549 2019-10-27 15:30:21-07:00 3618 October 27, 2019 - 20:44:45 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572216018:689022 689022 689022 2019-10-27 15:40:18-07:00 3619 October 27, 2019 - 20:52:43 UTC     3 0 36.84355 -119.8061 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572216018:687549 687549 687549 2019-10-27 15:40:18-07:00 3619 October 27, 2019 - 20:44:45 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572216627:689022 689022 689022 2019-10-27 15:50:27-07:00 3620 October 27, 2019 - 20:52:43 UTC     3 0 36.84355 -119.8061 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572216627:687549 687549 687549 2019-10-27 15:50:27-07:00 3620 October 27, 2019 - 20:44:45 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572217226:689022 689022 689022 2019-10-27 16:00:26-07:00 3621 October 27, 2019 - 20:52:43 UTC     3 0 36.84355 -119.8061 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572217226:687549 687549 687549 2019-10-27 16:00:26-07:00 3621 October 27, 2019 - 20:44:45 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572217823:689022 689022 689022 2019-10-27 16:10:23-07:00 3622 October 27, 2019 - 20:52:43 UTC     3 0 36.84355 -119.8061 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572217823:687549 687549 687549 2019-10-27 16:10:23-07:00 3622 October 27, 2019 - 22:52:34 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572218422:689022 689022 689022 2019-10-27 16:20:22-07:00 3623 October 27, 2019 - 20:52:43 UTC     3 0 36.84355 -119.8061 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572218422:687549 687549 687549 2019-10-27 16:20:22-07:00 3623 October 27, 2019 - 22:52:34 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572219023:689022 689022 689022 2019-10-27 16:30:23-07:00 3624 October 27, 2019 - 20:52:43 UTC     3 0 36.84355 -119.8061 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572219023:687549 687549 687549 2019-10-27 16:30:23-07:00 3624 October 27, 2019 - 22:52:34 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572219023:690198 690198 690198 2019-10-27 16:30:23-07:00 3624 October 27, 2019 - 23:21:33 UTC     1 1 36.80683 -119.75026 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572219634:689022 689022 689022 2019-10-27 16:40:34-07:00 3625 October 27, 2019 - 20:52:43 UTC     3 0 36.84355 -119.8061 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572219634:687549 687549 687549 2019-10-27 16:40:34-07:00 3625 October 27, 2019 - 22:52:34 UTC     1 1 36.71955 -120.01954 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3

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 3226.739ms · About: About this site