outage_snapshots

51 rows where outage = 680298

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1572021050:680298 680298 680298 2019-10-25 09:30:50-07:00 3324 October 25, 2019 - 16:21:33 UTC     1 0 38.67937 -121.79118 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572021621:680298 680298 680298 2019-10-25 09:40:21-07:00 3325 October 25, 2019 - 16:34:49 UTC     74 0 38.67938 -121.79275 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572022222:680298 680298 680298 2019-10-25 09:50:22-07:00 3326 October 25, 2019 - 16:34:49 UTC     74 0 38.67938 -121.79275 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572022829:680298 680298 680298 2019-10-25 10:00:29-07:00 3327 October 25, 2019 - 16:34:49 UTC     74 0 38.67938 -121.79275 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572023576:680298 680298 680298 2019-10-25 10:12:56-07:00 3328 October 25, 2019 - 16:34:49 UTC     74 0 38.67938 -121.79275 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572024018:680298 680298 680298 2019-10-25 10:20:18-07:00 3329 October 25, 2019 - 16:34:49 UTC     74 0 38.67938 -121.79275 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572024632:680298 680298 680298 2019-10-25 10:30:32-07:00 3330 October 25, 2019 - 17:16:18 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572025218:680298 680298 680298 2019-10-25 10:40:18-07:00 3331 October 25, 2019 - 17:16:18 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572025832:680298 680298 680298 2019-10-25 10:50:32-07:00 3332 October 25, 2019 - 17:40:25 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1572026436:680298 680298 680298 2019-10-25 11:00:36-07:00 3333 October 25, 2019 - 17:40:25 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1572027020:680298 680298 680298 2019-10-25 11:10:20-07:00 3334 October 25, 2019 - 17:40:25 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1572027627:680298 680298 680298 2019-10-25 11:20:27-07:00 3335 October 25, 2019 - 17:40:25 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1572028219:680298 680298 680298 2019-10-25 11:30:19-07:00 3336 October 25, 2019 - 17:40:25 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1572028827:680298 680298 680298 2019-10-25 11:40:27-07:00 3337 October 25, 2019 - 17:40:25 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1572029456:680298 680298 680298 2019-10-25 11:50:56-07:00 3338 October 25, 2019 - 17:40:25 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1572030049:680298 680298 680298 2019-10-25 12:00:49-07:00 3339 October 25, 2019 - 18:49:38 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1572030633:680298 680298 680298 2019-10-25 12:10:33-07:00 3340 October 25, 2019 - 19:05:02 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572031294:680298 680298 680298 2019-10-25 12:21:34-07:00 3341 October 25, 2019 - 19:16:04 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572031826:680298 680298 680298 2019-10-25 12:30:26-07:00 3342 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572032417:680298 680298 680298 2019-10-25 12:40:17-07:00 3343 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572033032:680298 680298 680298 2019-10-25 12:50:32-07:00 3344 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572033657:680298 680298 680298 2019-10-25 13:00:57-07:00 3345 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572034230:680298 680298 680298 2019-10-25 13:10:30-07:00 3346 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572034821:680298 680298 680298 2019-10-25 13:20:21-07:00 3347 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572035433:680298 680298 680298 2019-10-25 13:30:33-07:00 3348 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572036021:680298 680298 680298 2019-10-25 13:40:21-07:00 3349 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572036630:680298 680298 680298 2019-10-25 13:50:30-07:00 3350 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572037262:680298 680298 680298 2019-10-25 14:01:02-07:00 3351 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572037822:680298 680298 680298 2019-10-25 14:10:22-07:00 3352 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572038429:680298 680298 680298 2019-10-25 14:20:29-07:00 3353 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572039021:680298 680298 680298 2019-10-25 14:30:21-07:00 3354 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572039626:680298 680298 680298 2019-10-25 14:40:26-07:00 3355 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572040245:680298 680298 680298 2019-10-25 14:50:45-07:00 3356 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572040841:680298 680298 680298 2019-10-25 15:00:41-07:00 3357 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572041424:680298 680298 680298 2019-10-25 15:10:24-07:00 3358 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572042032:680298 680298 680298 2019-10-25 15:20:32-07:00 3359 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572042615:680298 680298 680298 2019-10-25 15:30:15-07:00 3360 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572043237:680298 680298 680298 2019-10-25 15:40:37-07:00 3361 October 25, 2019 - 19:24:33 UTC     74 0 38.67938 -121.79275 Woodland 34 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572043822:680298 680298 680298 2019-10-25 15:50:22-07:00 3362 October 25, 2019 - 22:40:05 UTC October 26, 2019 - 00:30:00 UTC   74 0 38.67938 -121.79275 Woodland 34 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1572044415:680298 680298 680298 2019-10-25 16:00:15-07:00 3363 October 25, 2019 - 22:40:05 UTC October 26, 2019 - 00:30:00 UTC   74 0 38.67938 -121.79275 Woodland 34 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1572045014:680298 680298 680298 2019-10-25 16:10:14-07:00 3364 October 25, 2019 - 22:40:05 UTC October 26, 2019 - 00:30:00 UTC   74 0 38.67938 -121.79275 Woodland 34 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1572045632:680298 680298 680298 2019-10-25 16:20:32-07:00 3365 October 25, 2019 - 22:40:05 UTC October 26, 2019 - 00:30:00 UTC   74 0 38.67938 -121.79275 Woodland 34 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1572046222:680298 680298 680298 2019-10-25 16:30:22-07:00 3366 October 25, 2019 - 22:40:05 UTC October 26, 2019 - 00:30:00 UTC   74 0 38.67938 -121.79275 Woodland 34 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1572046813:680298 680298 680298 2019-10-25 16:40:13-07:00 3367 October 25, 2019 - 22:40:05 UTC October 26, 2019 - 00:30:00 UTC   74 0 38.67938 -121.79275 Woodland 34 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1572047421:680298 680298 680298 2019-10-25 16:50:21-07:00 3368 October 25, 2019 - 23:40:51 UTC October 26, 2019 - 00:30:00 UTC   74 0 38.67938 -121.79275 Woodland 34 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1572048025:680298 680298 680298 2019-10-25 17:00:25-07:00 3369 October 25, 2019 - 23:40:51 UTC October 26, 2019 - 00:30:00 UTC   74 0 38.67938 -121.79275 Woodland 34 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1572048628:680298 680298 680298 2019-10-25 17:10:28-07:00 3370 October 25, 2019 - 23:40:51 UTC October 26, 2019 - 00:30:00 UTC   74 0 38.67938 -121.79275 Woodland 34 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1572049212:680298 680298 680298 2019-10-25 17:20:12-07:00 3371 October 25, 2019 - 23:40:51 UTC October 26, 2019 - 00:30:00 UTC   74 0 38.67938 -121.79275 Woodland 34 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1572049821:680298 680298 680298 2019-10-25 17:30:21-07:00 3372 October 25, 2019 - 23:40:51 UTC October 26, 2019 - 00:30:00 UTC   74 0 38.67938 -121.79275 Woodland 34 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1572050413:680298 680298 680298 2019-10-25 17:40:13-07:00 3373 October 25, 2019 - 23:40:51 UTC October 26, 2019 - 00:30:00 UTC   74 0 38.67938 -121.79275 Woodland 34 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1572051023:680298 680298 680298 2019-10-25 17:50:23-07:00 3374 October 25, 2019 - 23:40:51 UTC October 26, 2019 - 00:30:00 UTC   74 0 38.67938 -121.79275 Woodland 34 Our preliminary determination is that your outage was caused by an equipment issue. 2 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 4763.882ms · About: About this site