outage_snapshots

15 rows where outage = 697256

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1572619819:697256 697256 697256 2019-11-01 07:50:19-07:00 4208 November 01, 2019 - 14:43:35 UTC November 01, 2019 - 18:45:00 UTC November 01, 2019 - 18:45:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572620447:697256 697256 697256 2019-11-01 08:00:47-07:00 4209 November 01, 2019 - 14:50:44 UTC November 01, 2019 - 18:45:00 UTC November 01, 2019 - 18:45:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572621029:697256 697256 697256 2019-11-01 08:10:29-07:00 4210 November 01, 2019 - 15:01:09 UTC November 01, 2019 - 18:45:00 UTC November 01, 2019 - 18:45:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572621623:697256 697256 697256 2019-11-01 08:20:23-07:00 4211 November 01, 2019 - 15:12:48 UTC November 01, 2019 - 18:45:00 UTC November 01, 2019 - 18:45:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572622225:697256 697256 697256 2019-11-01 08:30:25-07:00 4212 November 01, 2019 - 15:12:48 UTC November 01, 2019 - 18:45:00 UTC November 01, 2019 - 18:45:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572622829:697256 697256 697256 2019-11-01 08:40:29-07:00 4213 November 01, 2019 - 15:12:48 UTC November 01, 2019 - 18:45:00 UTC November 01, 2019 - 18:45:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572623435:697256 697256 697256 2019-11-01 08:50:35-07:00 4214 November 01, 2019 - 15:12:48 UTC November 01, 2019 - 18:45:00 UTC November 01, 2019 - 18:45:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572624039:697256 697256 697256 2019-11-01 09:00:39-07:00 4215 November 01, 2019 - 15:45:59 UTC November 01, 2019 - 18:45:00 UTC November 01, 2019 - 18:45:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572624631:697256 697256 697256 2019-11-01 09:10:31-07:00 4216 November 01, 2019 - 16:02:06 UTC November 01, 2019 - 18:45:00 UTC November 01, 2019 - 18:45:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572625217:697256 697256 697256 2019-11-01 09:20:17-07:00 4217 November 01, 2019 - 16:11:04 UTC November 01, 2019 - 18:45:00 UTC November 01, 2019 - 18:45:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572625832:697256 697256 697256 2019-11-01 09:30:32-07:00 4218 November 01, 2019 - 16:11:04 UTC November 01, 2019 - 18:45:00 UTC November 01, 2019 - 18:45:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572626416:697256 697256 697256 2019-11-01 09:40:16-07:00 4219 November 01, 2019 - 16:11:04 UTC November 01, 2019 - 18:45:00 UTC November 01, 2019 - 18:45:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572627034:697256 697256 697256 2019-11-01 09:50:34-07:00 4220 November 01, 2019 - 16:11:04 UTC November 01, 2019 - 18:45:00 UTC November 01, 2019 - 18:45:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572627647:697256 697256 697256 2019-11-01 10:00:47-07:00 4221 November 01, 2019 - 16:11:04 UTC November 01, 2019 - 18:45:00 UTC November 01, 2019 - 18:45:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572628219:697256 697256 697256 2019-11-01 10:10:19-07:00 4222 November 01, 2019 - 16:57:44 UTC November 01, 2019 - 18:45:00 UTC November 01, 2019 - 18:45:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 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 4247.785ms · About: About this site