outage_snapshots

31 rows where outage = 731855

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1575681614:731855 731855 731855 2019-12-06 17:20:14-08:00 9209 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575682218:731855 731855 731855 2019-12-06 17:30:18-08:00 9210 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575682834:731855 731855 731855 2019-12-06 17:40:34-08:00 9211 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575683424:731855 731855 731855 2019-12-06 17:50:24-08:00 9212 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575684056:731855 731855 731855 2019-12-06 18:00:56-08:00 9213 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575684617:731855 731855 731855 2019-12-06 18:10:17-08:00 9214 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575685234:731855 731855 731855 2019-12-06 18:20:34-08:00 9215 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575685824:731855 731855 731855 2019-12-06 18:30:24-08:00 9216 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575686427:731855 731855 731855 2019-12-06 18:40:27-08:00 9217 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575687053:731855 731855 731855 2019-12-06 18:50:53-08:00 9218 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575687628:731855 731855 731855 2019-12-06 19:00:28-08:00 9219 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575688225:731855 731855 731855 2019-12-06 19:10:25-08:00 9220 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575688818:731855 731855 731855 2019-12-06 19:20:18-08:00 9221 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575689416:731855 731855 731855 2019-12-06 19:30:16-08:00 9222 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575690039:731855 731855 731855 2019-12-06 19:40:39-08:00 9223 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575690620:731855 731855 731855 2019-12-06 19:50:20-08:00 9224 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575691832:731855 731855 731855 2019-12-06 20:10:32-08:00 9225 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1575692416:731855 731855 731855 2019-12-06 20:20:16-08:00 9226 December 07, 2019 - 01:14:07 UTC December 07, 2019 - 04:30:00 UTC December 07, 2019 - 04:30:00 UTC 1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1575693020:731855 731855 731855 2019-12-06 20:30:20-08:00 9227 December 07, 2019 - 04:23:29 UTC December 07, 2019 - 06:23:00 UTC   1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1575693632:731855 731855 731855 2019-12-06 20:40:32-08:00 9228 December 07, 2019 - 04:23:29 UTC December 07, 2019 - 06:23:00 UTC   1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1575694214:731855 731855 731855 2019-12-06 20:50:14-08:00 9229 December 07, 2019 - 04:23:29 UTC December 07, 2019 - 06:23:00 UTC   1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1575694818:731855 731855 731855 2019-12-06 21:00:18-08:00 9230 December 07, 2019 - 04:23:29 UTC December 07, 2019 - 06:23:00 UTC   1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1575695434:731855 731855 731855 2019-12-06 21:10:34-08:00 9231 December 07, 2019 - 04:23:29 UTC December 07, 2019 - 06:23:00 UTC   1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1575696015:731855 731855 731855 2019-12-06 21:20:15-08:00 9232 December 07, 2019 - 04:23:29 UTC December 07, 2019 - 06:23:00 UTC   1 0 38.1945 -120.83093 Valley Springs 32 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1575696614:731855 731855 731855 2019-12-06 21:30:14-08:00 9233 December 07, 2019 - 05:25:24 UTC December 07, 2019 - 06:23:00 UTC   1 0 38.1945 -120.83093 Valley Springs 32 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575697223:731855 731855 731855 2019-12-06 21:40:23-08:00 9234 December 07, 2019 - 05:25:24 UTC December 07, 2019 - 06:23:00 UTC   1 0 38.1945 -120.83093 Valley Springs 32 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575697819:731855 731855 731855 2019-12-06 21:50:19-08:00 9235 December 07, 2019 - 05:25:24 UTC December 07, 2019 - 06:23:00 UTC   1 0 38.1945 -120.83093 Valley Springs 32 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575698427:731855 731855 731855 2019-12-06 22:00:27-08:00 9236 December 07, 2019 - 05:25:24 UTC December 07, 2019 - 06:23:00 UTC   1 0 38.1945 -120.83093 Valley Springs 32 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575699035:731855 731855 731855 2019-12-06 22:10:35-08:00 9237 December 07, 2019 - 05:25:24 UTC December 07, 2019 - 06:23:00 UTC   1 0 38.1945 -120.83093 Valley Springs 32 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575699618:731855 731855 731855 2019-12-06 22:20:18-08:00 9238 December 07, 2019 - 05:25:24 UTC December 07, 2019 - 06:23:00 UTC   1 0 38.1945 -120.83093 Valley Springs 32 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575700212:731855 731855 731855 2019-12-06 22:30:12-08:00 9239 December 07, 2019 - 05:25:24 UTC December 07, 2019 - 06:23:00 UTC   1 0 38.1945 -120.83093 Valley Springs 32 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 4713.403ms · About: About this site