outage_snapshots

2,098 rows where regionName = 80 sorted by longitude

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude ▼ regionName cause crewCurrentStatus
1572396015:694249 694249 694249 2019-10-29 17:40:15-07:00 3865 October 29, 2019 - 23:24:22 UTC October 30, 2019 - 01:00:00 UTC   1 1 37.59447 -122.00766 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1581355231:787159 787159 787159 2020-02-10 09:20:31-08:00 11621 February 10, 2020 - 17:15:03 UTC     1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581355838:787159 787159 787159 2020-02-10 09:30:38-08:00 11622 February 10, 2020 - 17:15:03 UTC     1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581356439:787159 787159 787159 2020-02-10 09:40:39-08:00 11623 February 10, 2020 - 17:15:03 UTC     1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581357055:787159 787159 787159 2020-02-10 09:50:55-08:00 11624 February 10, 2020 - 17:15:03 UTC     1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581357656:787159 787159 787159 2020-02-10 10:00:56-08:00 11625 February 10, 2020 - 17:15:03 UTC     1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581358263:787159 787159 787159 2020-02-10 10:11:03-08:00 11626 February 10, 2020 - 17:15:03 UTC     1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581358841:787159 787159 787159 2020-02-10 10:20:41-08:00 11627 February 10, 2020 - 17:15:03 UTC     1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581359431:787159 787159 787159 2020-02-10 10:30:31-08:00 11628 February 10, 2020 - 17:15:03 UTC     1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581360025:787159 787159 787159 2020-02-10 10:40:25-08:00 11629 February 10, 2020 - 17:15:03 UTC     1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581360618:787159 787159 787159 2020-02-10 10:50:18-08:00 11630 February 10, 2020 - 17:15:03 UTC     1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581361278:787159 787159 787159 2020-02-10 11:01:18-08:00 11631 February 10, 2020 - 17:15:03 UTC     1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581361824:787159 787159 787159 2020-02-10 11:10:24-08:00 11632 February 10, 2020 - 17:15:03 UTC     1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581362421:787159 787159 787159 2020-02-10 11:20:21-08:00 11633 February 10, 2020 - 17:15:03 UTC     1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581363044:787159 787159 787159 2020-02-10 11:30:44-08:00 11634 February 10, 2020 - 19:22:49 UTC     1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581363641:787159 787159 787159 2020-02-10 11:40:41-08:00 11635 February 10, 2020 - 19:22:49 UTC     1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581364234:787159 787159 787159 2020-02-10 11:50:34-08:00 11636 February 10, 2020 - 19:22:49 UTC     1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581364927:787159 787159 787159 2020-02-10 12:02:07-08:00 11637 February 10, 2020 - 19:50:02 UTC February 11, 2020 - 00:00:00 UTC   1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581365487:787159 787159 787159 2020-02-10 12:11:27-08:00 11638 February 10, 2020 - 19:50:02 UTC February 11, 2020 - 00:00:00 UTC   1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581366032:787159 787159 787159 2020-02-10 12:20:32-08:00 11639 February 10, 2020 - 19:50:02 UTC February 11, 2020 - 00:00:00 UTC   1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581366642:787159 787159 787159 2020-02-10 12:30:42-08:00 11640 February 10, 2020 - 19:50:02 UTC February 11, 2020 - 00:00:00 UTC   1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1581367237:787159 787159 787159 2020-02-10 12:40:37-08:00 11641 February 10, 2020 - 19:50:02 UTC February 11, 2020 - 00:00:00 UTC   1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1581367855:787159 787159 787159 2020-02-10 12:50:55-08:00 11642 February 10, 2020 - 19:50:02 UTC February 11, 2020 - 00:00:00 UTC   1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1581368442:787159 787159 787159 2020-02-10 13:00:42-08:00 11643 February 10, 2020 - 19:50:02 UTC February 11, 2020 - 00:00:00 UTC   1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1581369042:787159 787159 787159 2020-02-10 13:10:42-08:00 11644 February 10, 2020 - 19:50:02 UTC February 11, 2020 - 00:00:00 UTC   1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1581369629:787159 787159 787159 2020-02-10 13:20:29-08:00 11645 February 10, 2020 - 19:50:02 UTC February 11, 2020 - 00:00:00 UTC   1 0 37.58362 -122.00846 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1581370262:787159 787159 787159 2020-02-10 13:31:02-08:00 11646 February 10, 2020 - 21:24:15 UTC February 11, 2020 - 00:00:00 UTC   1 0 37.58362 -122.00846 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575062417:723670 723670 723670 2019-11-29 13:20:17-08:00 8188 November 29, 2019 - 21:13:09 UTC     1 0 37.59705 -122.01235 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1575063035:723670 723670 723670 2019-11-29 13:30:35-08:00 8189 November 29, 2019 - 21:13:09 UTC     1 0 37.59705 -122.01235 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1575063626:723670 723670 723670 2019-11-29 13:40:26-08:00 8190 November 29, 2019 - 21:13:09 UTC     1 0 37.59705 -122.01235 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1575064229:723670 723670 723670 2019-11-29 13:50:29-08:00 8191 November 29, 2019 - 21:13:09 UTC     1 0 37.59705 -122.01235 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1575064836:723670 723670 723670 2019-11-29 14:00:36-08:00 8192 November 29, 2019 - 21:51:14 UTC     1 0 37.59705 -122.01235 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575065419:723670 723670 723670 2019-11-29 14:10:19-08:00 8193 November 29, 2019 - 21:51:14 UTC     1 0 37.59705 -122.01235 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575066020:723670 723670 723670 2019-11-29 14:20:20-08:00 8194 November 29, 2019 - 21:51:14 UTC     1 0 37.59705 -122.01235 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570909812:655238 655238 655238 2019-10-12 12:50:12-07:00 1528 October 12, 2019 - 19:46:08 UTC     1 0 37.59115 -122.01489 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570910431:655238 655238 655238 2019-10-12 13:00:31-07:00 1529 October 12, 2019 - 19:47:51 UTC     1 0 37.59115 -122.01489 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570911024:655238 655238 655238 2019-10-12 13:10:24-07:00 1530 October 12, 2019 - 19:47:51 UTC     1 0 37.59115 -122.01489 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570911627:655238 655238 655238 2019-10-12 13:20:27-07:00 1531 October 12, 2019 - 19:47:51 UTC     1 0 37.59115 -122.01489 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570912215:655238 655238 655238 2019-10-12 13:30:15-07:00 1532 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570912817:655238 655238 655238 2019-10-12 13:40:17-07:00 1533 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570913412:655238 655238 655238 2019-10-12 13:50:12-07:00 1534 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570914021:655238 655238 655238 2019-10-12 14:00:21-07:00 1535 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570914614:655238 655238 655238 2019-10-12 14:10:14-07:00 1536 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570915215:655238 655238 655238 2019-10-12 14:20:15-07:00 1537 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570915819:655238 655238 655238 2019-10-12 14:30:19-07:00 1538 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570916411:655238 655238 655238 2019-10-12 14:40:11-07:00 1539 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570917024:655238 655238 655238 2019-10-12 14:50:24-07:00 1540 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570917615:655238 655238 655238 2019-10-12 15:00:15-07:00 1541 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570918221:655238 655238 655238 2019-10-12 15:10:21-07:00 1542 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570918813:655238 655238 655238 2019-10-12 15:20:13-07:00 1543 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570919415:655238 655238 655238 2019-10-12 15:30:15-07:00 1544 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570920013:655238 655238 655238 2019-10-12 15:40:13-07:00 1545 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570920614:655238 655238 655238 2019-10-12 15:50:14-07:00 1546 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570921238:655238 655238 655238 2019-10-12 16:00:38-07:00 1547 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570921818:655238 655238 655238 2019-10-12 16:10:18-07:00 1548 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570922414:655238 655238 655238 2019-10-12 16:20:14-07:00 1549 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570923024:655238 655238 655238 2019-10-12 16:30:24-07:00 1550 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570923625:655238 655238 655238 2019-10-12 16:40:25-07:00 1551 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570924226:655238 655238 655238 2019-10-12 16:50:26-07:00 1552 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570924862:655238 655238 655238 2019-10-12 17:01:02-07:00 1553 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570925421:655238 655238 655238 2019-10-12 17:10:21-07:00 1554 October 12, 2019 - 23:56:29 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1570926022:655238 655238 655238 2019-10-12 17:20:22-07:00 1555 October 12, 2019 - 23:56:29 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1570926625:655238 655238 655238 2019-10-12 17:30:25-07:00 1556 October 12, 2019 - 23:56:29 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1570927231:655238 655238 655238 2019-10-12 17:40:31-07:00 1557 October 12, 2019 - 23:56:29 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1570927812:655238 655238 655238 2019-10-12 17:50:12-07:00 1558 October 12, 2019 - 23:56:29 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1570928438:655238 655238 655238 2019-10-12 18:00:38-07:00 1559 October 12, 2019 - 23:56:29 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1570929033:655238 655238 655238 2019-10-12 18:10:33-07:00 1560 October 12, 2019 - 23:56:29 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1570929618:655238 655238 655238 2019-10-12 18:20:18-07:00 1561 October 12, 2019 - 23:56:29 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E assessment crew is en route to the outage. 5
1570930225:655238 655238 655238 2019-10-12 18:30:25-07:00 1562 October 12, 2019 - 23:56:29 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E assessment crew is en route to the outage. 5
1570930812:655238 655238 655238 2019-10-12 18:40:12-07:00 1563 October 12, 2019 - 23:56:29 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E assessment crew is en route to the outage. 5
1570931415:655238 655238 655238 2019-10-12 18:50:15-07:00 1564 October 13, 2019 - 01:44:04 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E assessment crew is en route to the outage. 5
1570932031:655238 655238 655238 2019-10-12 19:00:31-07:00 1565 October 13, 2019 - 01:47:07 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570932618:655238 655238 655238 2019-10-12 19:10:18-07:00 1566 October 13, 2019 - 01:47:07 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1581280239:783651 783651 783651 2020-02-09 12:30:39-08:00 11506 February 09, 2020 - 20:09:27 UTC     1 0 37.58974 -122.01649 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581282021:783651 783651 783651 2020-02-09 13:00:21-08:00 11507 February 09, 2020 - 20:09:27 UTC     1 0 37.58974 -122.01649 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581283215:783651 783651 783651 2020-02-09 13:20:15-08:00 11508 February 09, 2020 - 20:09:27 UTC     1 0 37.58974 -122.01649 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581284422:783651 783651 783651 2020-02-09 13:40:22-08:00 11509 February 09, 2020 - 20:09:27 UTC     1 0 37.58974 -122.01649 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581285019:783651 783651 783651 2020-02-09 13:50:19-08:00 11510 February 09, 2020 - 20:09:27 UTC     1 0 37.58974 -122.01649 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581285634:783651 783651 783651 2020-02-09 14:00:34-08:00 11511 February 09, 2020 - 20:09:27 UTC     1 0 37.58974 -122.01649 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581286245:783651 783651 783651 2020-02-09 14:10:45-08:00 11512 February 09, 2020 - 20:09:27 UTC     1 0 37.58974 -122.01649 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581286833:783651 783651 783651 2020-02-09 14:20:33-08:00 11513 February 09, 2020 - 20:09:27 UTC     1 0 37.58974 -122.01649 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581287419:783651 783651 783651 2020-02-09 14:30:19-08:00 11514 February 09, 2020 - 20:09:27 UTC     1 0 37.58974 -122.01649 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581288016:783651 783651 783651 2020-02-09 14:40:16-08:00 11515 February 09, 2020 - 20:09:27 UTC     1 0 37.58974 -122.01649 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1581289245:783651 783651 783651 2020-02-09 15:00:45-08:00 11516 February 09, 2020 - 20:09:27 UTC     1 0 37.58974 -122.01649 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572201620:688070 688070 688070 2019-10-27 11:40:20-07:00 3599 October 27, 2019 - 18:31:22 UTC     2830 0 37.59527 -122.01746 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572204020:688070 688070 688070 2019-10-27 12:20:20-07:00 3600 October 27, 2019 - 19:08:03 UTC     2830 2 37.59527 -122.01746 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572204618:688070 688070 688070 2019-10-27 12:30:18-07:00 3601 October 27, 2019 - 19:08:03 UTC     2830 2 37.59527 -122.01746 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572205225:688070 688070 688070 2019-10-27 12:40:25-07:00 3602 October 27, 2019 - 19:08:03 UTC     2830 2 37.59527 -122.01746 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572205846:688070 688070 688070 2019-10-27 12:50:46-07:00 3603 October 27, 2019 - 19:33:19 UTC     2830 2 37.59527 -122.01746 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572206438:688070 688070 688070 2019-10-27 13:00:38-07:00 3604 October 27, 2019 - 19:33:19 UTC     2830 2 37.59527 -122.01746 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572298052:692021 692021 692021 2019-10-28 14:27:32-07:00 3724 October 28, 2019 - 21:20:17 UTC     1 1 37.60372 -122.01763 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572299595:692021 692021 692021 2019-10-28 14:53:15-07:00 3725 October 28, 2019 - 21:20:17 UTC     1 1 37.60372 -122.01763 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572301123:692021 692021 692021 2019-10-28 15:18:43-07:00 3726 October 28, 2019 - 21:20:17 UTC     1 1 37.60372 -122.01763 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572301600:692021 692021 692021 2019-10-28 15:26:40-07:00 3727 October 28, 2019 - 21:20:17 UTC     1 1 37.60372 -122.01763 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572302743:692021 692021 692021 2019-10-28 15:45:43-07:00 3728 October 28, 2019 - 21:20:17 UTC     1 1 37.60372 -122.01763 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572303277:692021 692021 692021 2019-10-28 15:54:37-07:00 3729 October 28, 2019 - 22:45:30 UTC     1 1 37.60372 -122.01763 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572303743:692021 692021 692021 2019-10-28 16:02:23-07:00 3730 October 28, 2019 - 22:45:30 UTC     1 1 37.60372 -122.01763 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572304221:692021 692021 692021 2019-10-28 16:10:21-07:00 3731 October 28, 2019 - 22:45:30 UTC     1 1 37.60372 -122.01763 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572304819:692021 692021 692021 2019-10-28 16:20:19-07:00 3732 October 28, 2019 - 22:45:30 UTC     1 1 37.60372 -122.01763 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572305449:692021 692021 692021 2019-10-28 16:30:49-07:00 3733 October 28, 2019 - 22:45:30 UTC     1 1 37.60372 -122.01763 Union City 80 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 1005.416ms · About: About this site