outage_snapshots

15 rows where outage = 687622 sorted by regionName

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName ▼ cause crewCurrentStatus
1572196826:687622 687622 687622 2019-10-27 10:20:26-07:00 3591 October 27, 2019 - 17:07:51 UTC     1 1 37.90122 -122.06624 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572197442:687622 687622 687622 2019-10-27 10:30:42-07:00 3592 October 27, 2019 - 17:07:51 UTC     1 1 37.90122 -122.06624 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572198015:687622 687622 687622 2019-10-27 10:40:15-07:00 3593 October 27, 2019 - 17:07:51 UTC     1 1 37.90122 -122.06624 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572198619:687622 687622 687622 2019-10-27 10:50:19-07:00 3594 October 27, 2019 - 17:07:51 UTC     1 1 37.90122 -122.06624 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572199230:687622 687622 687622 2019-10-27 11:00:30-07:00 3595 October 27, 2019 - 17:07:51 UTC     1 1 37.90122 -122.06624 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572199838:687622 687622 687622 2019-10-27 11:10:38-07:00 3596 October 27, 2019 - 17:07:51 UTC     1 1 37.90122 -122.06624 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572200419:687622 687622 687622 2019-10-27 11:20:19-07:00 3597 October 27, 2019 - 17:07:51 UTC     1 1 37.90122 -122.06624 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572201028:687622 687622 687622 2019-10-27 11:30:28-07:00 3598 October 27, 2019 - 17:07:51 UTC     1 1 37.90122 -122.06624 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572201620:687622 687622 687622 2019-10-27 11:40:20-07:00 3599 October 27, 2019 - 17:07:51 UTC     1 1 37.90122 -122.06624 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572204020:687622 687622 687622 2019-10-27 12:20:20-07:00 3600 October 27, 2019 - 17:07:51 UTC     1 1 37.90122 -122.06624 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572204618:687622 687622 687622 2019-10-27 12:30:18-07:00 3601 October 27, 2019 - 17:07:51 UTC     1 1 37.90122 -122.06624 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572205225:687622 687622 687622 2019-10-27 12:40:25-07:00 3602 October 27, 2019 - 17:07:51 UTC     1 1 37.90122 -122.06624 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572205846:687622 687622 687622 2019-10-27 12:50:46-07:00 3603 October 27, 2019 - 17:07:51 UTC     1 1 37.90122 -122.06624 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572206438:687622 687622 687622 2019-10-27 13:00:38-07:00 3604 October 27, 2019 - 17:07:51 UTC     1 1 37.90122 -122.06624 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572207026:687622 687622 687622 2019-10-27 13:10:26-07:00 3605 October 27, 2019 - 17:07:51 UTC     1 1 37.90122 -122.06624 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1

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