outage_snapshots

38 rows where outage = 680796

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1572107414:680796 680796 680796 2019-10-26 09:30:14-07:00 3461 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572108018:680796 680796 680796 2019-10-26 09:40:18-07:00 3462 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572108620:680796 680796 680796 2019-10-26 09:50:20-07:00 3463 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572109235:680796 680796 680796 2019-10-26 10:00:35-07:00 3464 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572109819:680796 680796 680796 2019-10-26 10:10:19-07:00 3465 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572110415:680796 680796 680796 2019-10-26 10:20:15-07:00 3466 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572111041:680796 680796 680796 2019-10-26 10:30:41-07:00 3467 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572111622:680796 680796 680796 2019-10-26 10:40:22-07:00 3468 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572112221:680796 680796 680796 2019-10-26 10:50:21-07:00 3469 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572112851:680796 680796 680796 2019-10-26 11:00:51-07:00 3470 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572113428:680796 680796 680796 2019-10-26 11:10:28-07:00 3471 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572114021:680796 680796 680796 2019-10-26 11:20:21-07:00 3472 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572114634:680796 680796 680796 2019-10-26 11:30:34-07:00 3473 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572115219:680796 680796 680796 2019-10-26 11:40:19-07:00 3474 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572115818:680796 680796 680796 2019-10-26 11:50:18-07:00 3475 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572116437:680796 680796 680796 2019-10-26 12:00:37-07:00 3476 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572117020:680796 680796 680796 2019-10-26 12:10:20-07:00 3477 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572117624:680796 680796 680796 2019-10-26 12:20:24-07:00 3478 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572118217:680796 680796 680796 2019-10-26 12:30:17-07:00 3479 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572118821:680796 680796 680796 2019-10-26 12:40:21-07:00 3480 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572119416:680796 680796 680796 2019-10-26 12:50:16-07:00 3481 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572120034:680796 680796 680796 2019-10-26 13:00:34-07:00 3482 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572120626:680796 680796 680796 2019-10-26 13:10:26-07:00 3483 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572121214:680796 680796 680796 2019-10-26 13:20:14-07:00 3484 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572121818:680796 680796 680796 2019-10-26 13:30:18-07:00 3485 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572122411:680796 680796 680796 2019-10-26 13:40:11-07:00 3486 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572123014:680796 680796 680796 2019-10-26 13:50:14-07:00 3487 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572123627:680796 680796 680796 2019-10-26 14:00:27-07:00 3488 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572124227:680796 680796 680796 2019-10-26 14:10:27-07:00 3489 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572124824:680796 680796 680796 2019-10-26 14:20:24-07:00 3490 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572125417:680796 680796 680796 2019-10-26 14:30:17-07:00 3491 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572126013:680796 680796 680796 2019-10-26 14:40:13-07:00 3492 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572126613:680796 680796 680796 2019-10-26 14:50:13-07:00 3493 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572127220:680796 680796 680796 2019-10-26 15:00:20-07:00 3494 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572127814:680796 680796 680796 2019-10-26 15:10:14-07:00 3495 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572128412:680796 680796 680796 2019-10-26 15:20:12-07:00 3496 October 26, 2019 - 16:16:39 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572129022:680796 680796 680796 2019-10-26 15:30:22-07:00 3497 October 26, 2019 - 22:16:34 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572129646:680796 680796 680796 2019-10-26 15:40:46-07:00 3498 October 26, 2019 - 22:33:47 UTC     3 0 38.68472 -121.76349 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1

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