41 rows where outage = 689302

View and edit SQL

Suggested facets: lastUpdateTime, hazardFlag, cause, crewCurrentStatus

id ▼ outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1572211217:689302 689302 689302 2019-10-27 14:20:17-07:00 3612 October 27, 2019 - 21:12:41 UTC     18 2 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572211828:689302 689302 689302 2019-10-27 14:30:28-07:00 3613 October 27, 2019 - 21:12:41 UTC     18 2 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572212416:689302 689302 689302 2019-10-27 14:40:16-07:00 3614 October 27, 2019 - 21:12:41 UTC     18 2 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572213020:689302 689302 689302 2019-10-27 14:50:20-07:00 3615 October 27, 2019 - 21:12:41 UTC     18 2 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572213622:689302 689302 689302 2019-10-27 15:00:22-07:00 3616 October 27, 2019 - 21:46:05 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572214818:689302 689302 689302 2019-10-27 15:20:18-07:00 3617 October 27, 2019 - 21:46:05 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572215421:689302 689302 689302 2019-10-27 15:30:21-07:00 3618 October 27, 2019 - 21:46:05 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572216018:689302 689302 689302 2019-10-27 15:40:18-07:00 3619 October 27, 2019 - 21:46:05 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572216627:689302 689302 689302 2019-10-27 15:50:27-07:00 3620 October 27, 2019 - 21:46:05 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572217226:689302 689302 689302 2019-10-27 16:00:26-07:00 3621 October 27, 2019 - 21:46:05 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572217823:689302 689302 689302 2019-10-27 16:10:23-07:00 3622 October 27, 2019 - 21:46:05 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572218422:689302 689302 689302 2019-10-27 16:20:22-07:00 3623 October 27, 2019 - 23:00:58 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572219023:689302 689302 689302 2019-10-27 16:30:23-07:00 3624 October 27, 2019 - 23:00:58 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572219634:689302 689302 689302 2019-10-27 16:40:34-07:00 3625 October 27, 2019 - 23:00:58 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572220252:689302 689302 689302 2019-10-27 16:50:52-07:00 3626 October 27, 2019 - 23:00:58 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572220830:689302 689302 689302 2019-10-27 17:00:30-07:00 3627 October 27, 2019 - 23:00:58 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572221431:689302 689302 689302 2019-10-27 17:10:31-07:00 3628 October 27, 2019 - 23:00:58 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572222042:689302 689302 689302 2019-10-27 17:20:42-07:00 3629 October 27, 2019 - 23:00:58 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572222914:689302 689302 689302 2019-10-27 17:35:14-07:00 3630 October 27, 2019 - 23:00:58 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572223843:689302 689302 689302 2019-10-27 17:50:43-07:00 3631 October 27, 2019 - 23:00:58 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572224421:689302 689302 689302 2019-10-27 18:00:21-07:00 3632 October 27, 2019 - 23:00:58 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572225030:689302 689302 689302 2019-10-27 18:10:30-07:00 3633 October 27, 2019 - 23:00:58 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572225638:689302 689302 689302 2019-10-27 18:20:38-07:00 3634 October 27, 2019 - 23:00:58 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572226224:689302 689302 689302 2019-10-27 18:30:24-07:00 3635 October 27, 2019 - 23:00:58 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572226819:689302 689302 689302 2019-10-27 18:40:19-07:00 3636 October 28, 2019 - 01:31:23 UTC     18 3 37.74778 -121.42898 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572228641:689302 689302 689302 2019-10-27 19:10:41-07:00 3637 October 28, 2019 - 01:50:33 UTC     18 3 37.74778 -121.42898 Tracy 38 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572229275:689302 689302 689302 2019-10-27 19:21:15-07:00 3638 October 28, 2019 - 02:11:04 UTC     18 3 37.74778 -121.42898 Tracy 38 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572229829:689302 689302 689302 2019-10-27 19:30:29-07:00 3639 October 28, 2019 - 02:18:43 UTC     18 3 37.74778 -121.42898 Tracy 38 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572230426:689302 689302 689302 2019-10-27 19:40:26-07:00 3640 October 28, 2019 - 02:18:43 UTC     18 3 37.74778 -121.42898 Tracy 38 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572231032:689302 689302 689302 2019-10-27 19:50:32-07:00 3641 October 28, 2019 - 02:18:43 UTC     18 3 37.74778 -121.42898 Tracy 38 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572231631:689302 689302 689302 2019-10-27 20:00:31-07:00 3642 October 28, 2019 - 02:18:43 UTC     18 3 37.74778 -121.42898 Tracy 38 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572232242:689302 689302 689302 2019-10-27 20:10:42-07:00 3643 October 28, 2019 - 02:18:43 UTC     18 3 37.74778 -121.42898 Tracy 38 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572232822:689302 689302 689302 2019-10-27 20:20:22-07:00 3644 October 28, 2019 - 02:18:43 UTC     18 3 37.74778 -121.42898 Tracy 38 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572233437:689302 689302 689302 2019-10-27 20:30:37-07:00 3645 October 28, 2019 - 03:14:11 UTC     18 3 37.74778 -121.42898 Tracy 38 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572234022:689302 689302 689302 2019-10-27 20:40:22-07:00 3646 October 28, 2019 - 03:14:11 UTC     18 3 37.74778 -121.42898 Tracy 38 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572234634:689302 689302 689302 2019-10-27 20:50:34-07:00 3647 October 28, 2019 - 03:14:11 UTC     18 3 37.74778 -121.42898 Tracy 38 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572236428:689302 689302 689302 2019-10-27 21:20:28-07:00 3648 October 28, 2019 - 04:15:47 UTC     18 3 37.74778 -121.42898 Tracy 38 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is assessing the cause at the outage location. 4
1572237027:689302 689302 689302 2019-10-27 21:30:27-07:00 3649 October 28, 2019 - 04:15:47 UTC     18 3 37.74778 -121.42898 Tracy 38 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is assessing the cause at the outage location. 4
1572237622:689302 689302 689302 2019-10-27 21:40:22-07:00 3650 October 28, 2019 - 04:15:47 UTC     18 3 37.74778 -121.42898 Tracy 38 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is assessing the cause at the outage location. 4
1572238226:689302 689302 689302 2019-10-27 21:50:26-07:00 3651 October 28, 2019 - 04:15:47 UTC     18 3 37.74778 -121.42898 Tracy 38 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is assessing the cause at the outage location. 4
1572238840:689302 689302 689302 2019-10-27 22:00:40-07:00 3652 October 28, 2019 - 04:15:47 UTC     18 3 37.74778 -121.42898 Tracy 38 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is assessing the cause at the outage location. 4

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])
);
CREATE INDEX [idx_outage_snapshots_outage]
    ON [outage_snapshots] ([outage]);