outage_snapshots

11 rows where outage = 690995 sorted by regionName

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName ▼ cause crewCurrentStatus
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

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