outage_snapshots

30 rows where outage = 689245

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1572210621:689245 689245 689245 2019-10-27 14:10:21-07:00 3611 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572211217:689245 689245 689245 2019-10-27 14:20:17-07:00 3612 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572211828:689245 689245 689245 2019-10-27 14:30:28-07:00 3613 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572212416:689245 689245 689245 2019-10-27 14:40:16-07:00 3614 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572213020:689245 689245 689245 2019-10-27 14:50:20-07:00 3615 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572213622:689245 689245 689245 2019-10-27 15:00:22-07:00 3616 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572214818:689245 689245 689245 2019-10-27 15:20:18-07:00 3617 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572215421:689245 689245 689245 2019-10-27 15:30:21-07:00 3618 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572216018:689245 689245 689245 2019-10-27 15:40:18-07:00 3619 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572216627:689245 689245 689245 2019-10-27 15:50:27-07:00 3620 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572217226:689245 689245 689245 2019-10-27 16:00:26-07:00 3621 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572217823:689245 689245 689245 2019-10-27 16:10:23-07:00 3622 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572218422:689245 689245 689245 2019-10-27 16:20:22-07:00 3623 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572219023:689245 689245 689245 2019-10-27 16:30:23-07:00 3624 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572219634:689245 689245 689245 2019-10-27 16:40:34-07:00 3625 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572220252:689245 689245 689245 2019-10-27 16:50:52-07:00 3626 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572220830:689245 689245 689245 2019-10-27 17:00:30-07:00 3627 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572221431:689245 689245 689245 2019-10-27 17:10:31-07:00 3628 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572222042:689245 689245 689245 2019-10-27 17:20:42-07:00 3629 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572222914:689245 689245 689245 2019-10-27 17:35:14-07:00 3630 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572223843:689245 689245 689245 2019-10-27 17:50:43-07:00 3631 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572224421:689245 689245 689245 2019-10-27 18:00:21-07:00 3632 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572225030:689245 689245 689245 2019-10-27 18:10:30-07:00 3633 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572225638:689245 689245 689245 2019-10-27 18:20:38-07:00 3634 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572226224:689245 689245 689245 2019-10-27 18:30:24-07:00 3635 October 27, 2019 - 21:02:38 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572226819:689245 689245 689245 2019-10-27 18:40:19-07:00 3636 October 28, 2019 - 01:29:25 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572228641:689245 689245 689245 2019-10-27 19:10:41-07:00 3637 October 28, 2019 - 01:29:25 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572229275:689245 689245 689245 2019-10-27 19:21:15-07:00 3638 October 28, 2019 - 01:29:25 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572229829:689245 689245 689245 2019-10-27 19:30:29-07:00 3639 October 28, 2019 - 01:29:25 UTC     1 1 37.69389 -122.09929 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572230426:689245 689245 689245 2019-10-27 19:40:26-07:00 3640 October 28, 2019 - 01:29:25 UTC     1 1 37.69389 -122.09929 Castro Valley 4 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 5122.859ms · About: About this site