outage_snapshots

48 rows where outage = 697500

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1572635423:697500 697500 697500 2019-11-01 12:10:23-07:00 4234 November 01, 2019 - 19:04:56 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30:00 UTC 1 0 38.17357 -121.74605 Rio Vista 21 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572636026:697500 697500 697500 2019-11-01 12:20:26-07:00 4235 November 01, 2019 - 19:04:56 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30:00 UTC 1 0 38.17357 -121.74605 Rio Vista 21 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572636625:697500 697500 697500 2019-11-01 12:30:25-07:00 4236 November 01, 2019 - 19:17:39 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1572637220:697500 697500 697500 2019-11-01 12:40:20-07:00 4237 November 01, 2019 - 19:17:39 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1572637825:697500 697500 697500 2019-11-01 12:50:25-07:00 4238 November 01, 2019 - 19:43:29 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E assessment crew is en route to the outage. 5
1572638438:697500 697500 697500 2019-11-01 13:00:38-07:00 4239 November 01, 2019 - 19:46:12 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E assessment crew is en route to the outage. 5
1572639021:697500 697500 697500 2019-11-01 13:10:21-07:00 4240 November 01, 2019 - 19:46:12 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30:00 UTC 24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E assessment crew is en route to the outage. 5
1572639615:697500 697500 697500 2019-11-01 13:20:15-07:00 4241 November 01, 2019 - 20:07:54 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30: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
1572640225:697500 697500 697500 2019-11-01 13:30:25-07:00 4242 November 01, 2019 - 20:07:54 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30: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
1572640813:697500 697500 697500 2019-11-01 13:40:13-07:00 4243 November 01, 2019 - 20:07:54 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30: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
1572641418:697500 697500 697500 2019-11-01 13:50:18-07:00 4244 November 01, 2019 - 20:07:54 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30: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
1572642031:697500 697500 697500 2019-11-01 14:00:31-07:00 4245 November 01, 2019 - 20:07:54 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30: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
1572642623:697500 697500 697500 2019-11-01 14:10:23-07:00 4246 November 01, 2019 - 20:07:54 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30: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
1572643220:697500 697500 697500 2019-11-01 14:20:20-07:00 4247 November 01, 2019 - 20:07:54 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30: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
1572643847:697500 697500 697500 2019-11-01 14:30:47-07:00 4248 November 01, 2019 - 20:07:54 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30: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
1572644420:697500 697500 697500 2019-11-01 14:40:20-07:00 4249 November 01, 2019 - 20:07:54 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30: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
1572645015:697500 697500 697500 2019-11-01 14:50:15-07:00 4250 November 01, 2019 - 20:07:54 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30: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
1572645643:697500 697500 697500 2019-11-01 15:00:43-07:00 4251 November 01, 2019 - 20:07:54 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30: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
1572646222:697500 697500 697500 2019-11-01 15:10:22-07:00 4252 November 01, 2019 - 20:07:54 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30: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
1572646829:697500 697500 697500 2019-11-01 15:20:29-07:00 4253 November 01, 2019 - 20:07:54 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30: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
1572647436:697500 697500 697500 2019-11-01 15:30:36-07:00 4254 November 01, 2019 - 20:07:54 UTC November 01, 2019 - 22:30:00 UTC November 01, 2019 - 22:30: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
1572648017:697500 697500 697500 2019-11-01 15:40:17-07:00 4255 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572648621:697500 697500 697500 2019-11-01 15:50:21-07:00 4256 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572649230:697500 697500 697500 2019-11-01 16:00:30-07:00 4257 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572649839:697500 697500 697500 2019-11-01 16:10:39-07:00 4258 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572650425:697500 697500 697500 2019-11-01 16:20:25-07:00 4259 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572651014:697500 697500 697500 2019-11-01 16:30:14-07:00 4260 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572651618:697500 697500 697500 2019-11-01 16:40:18-07:00 4261 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572652214:697500 697500 697500 2019-11-01 16:50:14-07:00 4262 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572652831:697500 697500 697500 2019-11-01 17:00:31-07:00 4263 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572653434:697500 697500 697500 2019-11-01 17:10:34-07:00 4264 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572654019:697500 697500 697500 2019-11-01 17:20:19-07:00 4265 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572654616:697500 697500 697500 2019-11-01 17:30:16-07:00 4266 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572655226:697500 697500 697500 2019-11-01 17:40:26-07:00 4267 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572655814:697500 697500 697500 2019-11-01 17:50:14-07:00 4268 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572656418:697500 697500 697500 2019-11-01 18:00:18-07:00 4269 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572657023:697500 697500 697500 2019-11-01 18:10:23-07:00 4270 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572657620:697500 697500 697500 2019-11-01 18:20:20-07:00 4271 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572658216:697500 697500 697500 2019-11-01 18:30:16-07:00 4272 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572658853:697500 697500 697500 2019-11-01 18:40:53-07:00 4273 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572659422:697500 697500 697500 2019-11-01 18:50:22-07:00 4274 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572660027:697500 697500 697500 2019-11-01 19:00:27-07:00 4275 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572660613:697500 697500 697500 2019-11-01 19:10:13-07:00 4276 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572661216:697500 697500 697500 2019-11-01 19:20:16-07:00 4277 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572661844:697500 697500 697500 2019-11-01 19:30:44-07:00 4278 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572662415:697500 697500 697500 2019-11-01 19:40:15-07:00 4279 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572663049:697500 697500 697500 2019-11-01 19:50:49-07:00 4280 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572663632:697500 697500 697500 2019-11-01 20:00:32-07:00 4281 November 01, 2019 - 22:28:06 UTC November 02, 2019 - 00:25:00 UTC   24 0 38.18257 -121.74157 Rio Vista 21 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3

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