outage_snapshots

14 rows where outage = 724171 sorted by autoEtor

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor ▼ estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1575141612:724171 724171 724171 2019-11-30 11:20:12-08:00 8320 November 30, 2019 - 19:08:42 UTC November 30, 2019 - 22:00:00 UTC November 30, 2019 - 22:00:00 UTC 1 1 39.03356 -121.56267 Olivehurst 17 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575142212:724171 724171 724171 2019-11-30 11:30:12-08:00 8321 November 30, 2019 - 19:08:42 UTC November 30, 2019 - 22:00:00 UTC November 30, 2019 - 22:00:00 UTC 1 1 39.03356 -121.56267 Olivehurst 17 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575142816:724171 724171 724171 2019-11-30 11:40:16-08:00 8322 November 30, 2019 - 19:08:42 UTC November 30, 2019 - 22:00:00 UTC November 30, 2019 - 22:00:00 UTC 1 1 39.03356 -121.56267 Olivehurst 17 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575143417:724171 724171 724171 2019-11-30 11:50:17-08:00 8323 November 30, 2019 - 19:08:42 UTC November 30, 2019 - 22:00:00 UTC November 30, 2019 - 22:00:00 UTC 1 1 39.03356 -121.56267 Olivehurst 17 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1575144015:724171 724171 724171 2019-11-30 12:00:15-08:00 8324 November 30, 2019 - 19:55:12 UTC November 30, 2019 - 22:00:00 UTC November 30, 2019 - 22:00:00 UTC 1 1 39.03356 -121.56267 Olivehurst 17 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575144612:724171 724171 724171 2019-11-30 12:10:12-08:00 8325 November 30, 2019 - 19:55:12 UTC November 30, 2019 - 22:00:00 UTC November 30, 2019 - 22:00:00 UTC 1 1 39.03356 -121.56267 Olivehurst 17 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575145212:724171 724171 724171 2019-11-30 12:20:12-08:00 8326 November 30, 2019 - 19:55:12 UTC November 30, 2019 - 22:00:00 UTC November 30, 2019 - 22:00:00 UTC 1 1 39.03356 -121.56267 Olivehurst 17 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575145815:724171 724171 724171 2019-11-30 12:30:15-08:00 8327 November 30, 2019 - 19:55:12 UTC November 30, 2019 - 22:00:00 UTC November 30, 2019 - 22:00:00 UTC 1 1 39.03356 -121.56267 Olivehurst 17 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575146414:724171 724171 724171 2019-11-30 12:40:14-08:00 8328 November 30, 2019 - 19:55:12 UTC November 30, 2019 - 22:00:00 UTC November 30, 2019 - 22:00:00 UTC 1 1 39.03356 -121.56267 Olivehurst 17 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575147017:724171 724171 724171 2019-11-30 12:50:17-08:00 8329 November 30, 2019 - 19:55:12 UTC November 30, 2019 - 22:00:00 UTC November 30, 2019 - 22:00:00 UTC 1 1 39.03356 -121.56267 Olivehurst 17 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575147611:724171 724171 724171 2019-11-30 13:00:11-08:00 8330 November 30, 2019 - 19:55:12 UTC November 30, 2019 - 22:00:00 UTC November 30, 2019 - 22:00:00 UTC 1 1 39.03356 -121.56267 Olivehurst 17 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575148224:724171 724171 724171 2019-11-30 13:10:24-08:00 8331 November 30, 2019 - 19:55:12 UTC November 30, 2019 - 22:00:00 UTC November 30, 2019 - 22:00:00 UTC 1 1 39.03356 -121.56267 Olivehurst 17 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575148812:724171 724171 724171 2019-11-30 13:20:12-08:00 8332 November 30, 2019 - 19:55:12 UTC November 30, 2019 - 22:00:00 UTC November 30, 2019 - 22:00:00 UTC 1 1 39.03356 -121.56267 Olivehurst 17 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575149421:724171 724171 724171 2019-11-30 13:30:21-08:00 8333 November 30, 2019 - 19:55:12 UTC November 30, 2019 - 22:00:00 UTC November 30, 2019 - 22:00:00 UTC 1 1 39.03356 -121.56267 Olivehurst 17 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 4871.546ms · About: About this site