outage_snapshots

57 rows where outage = 703260

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1573319431:703260 703260 703260 2019-11-09 09:10:31-08:00 5351 November 09, 2019 - 17:02:20 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 1 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573320013:703260 703260 703260 2019-11-09 09:20:13-08:00 5352 November 09, 2019 - 17:02:20 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 1 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573320619:703260 703260 703260 2019-11-09 09:30:19-08:00 5353 November 09, 2019 - 17:02:20 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 1 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573321218:703260 703260 703260 2019-11-09 09:40:18-08:00 5354 November 09, 2019 - 17:02:20 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 1 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573321812:703260 703260 703260 2019-11-09 09:50:12-08:00 5355 November 09, 2019 - 17:42:53 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 1 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573322503:703260 703260 703260 2019-11-09 10:01:43-08:00 5356 November 09, 2019 - 17:42:53 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 1 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573323017:703260 703260 703260 2019-11-09 10:10:17-08:00 5357 November 09, 2019 - 17:42:53 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 1 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573323618:703260 703260 703260 2019-11-09 10:20:18-08:00 5358 November 09, 2019 - 17:42:53 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 1 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573324255:703260 703260 703260 2019-11-09 10:30:55-08:00 5359 November 09, 2019 - 18:20:25 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 1 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573324814:703260 703260 703260 2019-11-09 10:40:14-08:00 5360 November 09, 2019 - 18:31:09 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573325426:703260 703260 703260 2019-11-09 10:50:26-08:00 5361 November 09, 2019 - 18:41:56 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573326022:703260 703260 703260 2019-11-09 11:00:22-08:00 5362 November 09, 2019 - 18:41:56 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573326614:703260 703260 703260 2019-11-09 11:10:14-08:00 5363 November 09, 2019 - 18:41:56 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573327213:703260 703260 703260 2019-11-09 11:20:13-08:00 5364 November 09, 2019 - 18:41:56 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573327815:703260 703260 703260 2019-11-09 11:30:15-08:00 5365 November 09, 2019 - 18:41:56 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573328428:703260 703260 703260 2019-11-09 11:40:28-08:00 5366 November 09, 2019 - 18:41:56 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573329016:703260 703260 703260 2019-11-09 11:50:16-08:00 5367 November 09, 2019 - 18:41:56 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573329625:703260 703260 703260 2019-11-09 12:00:25-08:00 5368 November 09, 2019 - 18:41:56 UTC November 09, 2019 - 20:00:00 UTC November 09, 2019 - 20:00:00 UTC 22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573330213:703260 703260 703260 2019-11-09 12:10:13-08:00 5369 November 09, 2019 - 20:00:34 UTC November 09, 2019 - 22:30:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573330813:703260 703260 703260 2019-11-09 12:20:13-08:00 5370 November 09, 2019 - 20:00:34 UTC November 09, 2019 - 22:30:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573331416:703260 703260 703260 2019-11-09 12:30:16-08:00 5371 November 09, 2019 - 20:00:34 UTC November 09, 2019 - 22:30:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573332015:703260 703260 703260 2019-11-09 12:40:15-08:00 5372 November 09, 2019 - 20:00:34 UTC November 09, 2019 - 22:30:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573332617:703260 703260 703260 2019-11-09 12:50:17-08:00 5373 November 09, 2019 - 20:00:34 UTC November 09, 2019 - 22:30:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573333216:703260 703260 703260 2019-11-09 13:00:16-08:00 5374 November 09, 2019 - 20:00:34 UTC November 09, 2019 - 22:30:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573333812:703260 703260 703260 2019-11-09 13:10:12-08:00 5375 November 09, 2019 - 20:00:34 UTC November 09, 2019 - 22:30:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573334416:703260 703260 703260 2019-11-09 13:20:16-08:00 5376 November 09, 2019 - 20:00:34 UTC November 09, 2019 - 22:30:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573335018:703260 703260 703260 2019-11-09 13:30:18-08:00 5377 November 09, 2019 - 20:00:34 UTC November 09, 2019 - 22:30:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573335612:703260 703260 703260 2019-11-09 13:40:12-08:00 5378 November 09, 2019 - 20:00:34 UTC November 09, 2019 - 22:30:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573336214:703260 703260 703260 2019-11-09 13:50:14-08:00 5379 November 09, 2019 - 20:00:34 UTC November 09, 2019 - 22:30:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573336834:703260 703260 703260 2019-11-09 14:00:34-08:00 5380 November 09, 2019 - 20:00:34 UTC November 09, 2019 - 22:30:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573337411:703260 703260 703260 2019-11-09 14:10:11-08:00 5381 November 09, 2019 - 22:03:29 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1573338018:703260 703260 703260 2019-11-09 14:20:18-08:00 5382 November 09, 2019 - 22:03:29 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1573338615:703260 703260 703260 2019-11-09 14:30:15-08:00 5383 November 09, 2019 - 22:03:29 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1573339215:703260 703260 703260 2019-11-09 14:40:15-08:00 5384 November 09, 2019 - 22:03:29 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1573339819:703260 703260 703260 2019-11-09 14:50:19-08:00 5385 November 09, 2019 - 22:03:29 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1573340430:703260 703260 703260 2019-11-09 15:00:30-08:00 5386 November 09, 2019 - 22:03:29 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1573341017:703260 703260 703260 2019-11-09 15:10:17-08:00 5387 November 09, 2019 - 23:04:41 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1573341618:703260 703260 703260 2019-11-09 15:20:18-08:00 5388 November 09, 2019 - 23:04:41 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1573342214:703260 703260 703260 2019-11-09 15:30:14-08:00 5389 November 09, 2019 - 23:04:41 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1573342822:703260 703260 703260 2019-11-09 15:40:22-08:00 5390 November 09, 2019 - 23:04:41 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1573343421:703260 703260 703260 2019-11-09 15:50:21-08:00 5391 November 09, 2019 - 23:41:53 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1573344085:703260 703260 703260 2019-11-09 16:01:25-08:00 5392 November 09, 2019 - 23:41:53 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1573344635:703260 703260 703260 2019-11-09 16:10:35-08:00 5393 November 09, 2019 - 23:41:53 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1573345223:703260 703260 703260 2019-11-09 16:20:23-08:00 5394 November 09, 2019 - 23:41:53 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1573345818:703260 703260 703260 2019-11-09 16:30:18-08:00 5395 November 10, 2019 - 00:20:24 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 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
1573346431:703260 703260 703260 2019-11-09 16:40:31-08:00 5396 November 10, 2019 - 00:35:23 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 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
1573347025:703260 703260 703260 2019-11-09 16:50:25-08:00 5397 November 10, 2019 - 00:41:00 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 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
1573347622:703260 703260 703260 2019-11-09 17:00:22-08:00 5398 November 10, 2019 - 00:41:00 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 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
1573348219:703260 703260 703260 2019-11-09 17:10:19-08:00 5399 November 10, 2019 - 00:41:00 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 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
1573348817:703260 703260 703260 2019-11-09 17:20:17-08:00 5400 November 10, 2019 - 00:41:00 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 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
1573349412:703260 703260 703260 2019-11-09 17:30:12-08:00 5401 November 10, 2019 - 00:41:00 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 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
1573350019:703260 703260 703260 2019-11-09 17:40:19-08:00 5402 November 10, 2019 - 00:41:00 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 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
1573350621:703260 703260 703260 2019-11-09 17:50:21-08:00 5403 November 10, 2019 - 01:38:49 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 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
1573351223:703260 703260 703260 2019-11-09 18:00:23-08:00 5404 November 10, 2019 - 01:38:49 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 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
1573351812:703260 703260 703260 2019-11-09 18:10:12-08:00 5405 November 10, 2019 - 01:38:49 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 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
1573352413:703260 703260 703260 2019-11-09 18:20:13-08:00 5406 November 10, 2019 - 01:38:49 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 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
1573353015:703260 703260 703260 2019-11-09 18:30:15-08:00 5407 November 10, 2019 - 01:38:49 UTC November 10, 2019 - 07:59:00 UTC   22 0 35.13787 -120.61 Pismo Beach 18 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 4238.248ms · About: About this site