29 rows where outage = 687910

View and edit SQL

Suggested facets: lastUpdateTime, estCustAffected, hazardFlag, latitude, longitude, cause, crewCurrentStatus

id ▼ outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1572199838:687910 687910 687910 2019-10-27 11:10:38-07:00 3596 October 27, 2019 - 18:01:48 UTC     1 1 38.01016 -121.80179 Antioch 42 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572200419:687910 687910 687910 2019-10-27 11:20:19-07:00 3597 October 27, 2019 - 18:14:50 UTC     85 2 38.01188 -121.80505 Antioch 42 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572201028:687910 687910 687910 2019-10-27 11:30:28-07:00 3598 October 27, 2019 - 18:14:50 UTC     85 2 38.01188 -121.80505 Antioch 42 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572201620:687910 687910 687910 2019-10-27 11:40:20-07:00 3599 October 27, 2019 - 18:30:03 UTC     85 2 38.01188 -121.80505 Antioch 42 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1572204020:687910 687910 687910 2019-10-27 12:20:20-07:00 3600 October 27, 2019 - 19:15:38 UTC     85 2 38.01188 -121.80505 Antioch 42 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572204618:687910 687910 687910 2019-10-27 12:30:18-07:00 3601 October 27, 2019 - 19:15:38 UTC     85 2 38.01188 -121.80505 Antioch 42 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572205225:687910 687910 687910 2019-10-27 12:40:25-07:00 3602 October 27, 2019 - 19:15:38 UTC     85 2 38.01188 -121.80505 Antioch 42 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1572205846:687910 687910 687910 2019-10-27 12:50:46-07:00 3603 October 27, 2019 - 19:37:14 UTC     85 2 38.01188 -121.80505 Antioch 42 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572206438:687910 687910 687910 2019-10-27 13:00:38-07:00 3604 October 27, 2019 - 19:37:14 UTC     85 2 38.01188 -121.80505 Antioch 42 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572207026:687910 687910 687910 2019-10-27 13:10:26-07:00 3605 October 27, 2019 - 19:37:14 UTC     85 2 38.01188 -121.80505 Antioch 42 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572207619:687910 687910 687910 2019-10-27 13:20:19-07:00 3606 October 27, 2019 - 20:15:25 UTC     85 2 38.01188 -121.80505 Antioch 42 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572208219:687910 687910 687910 2019-10-27 13:30:19-07:00 3607 October 27, 2019 - 20:17:08 UTC     85 2 38.01188 -121.80505 Antioch 42 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1572208825:687910 687910 687910 2019-10-27 13:40:25-07:00 3608 October 27, 2019 - 20:29:45 UTC     85 2 38.01188 -121.80505 Antioch 42 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1572209423:687910 687910 687910 2019-10-27 13:50:23-07:00 3609 October 27, 2019 - 20:40:01 UTC October 28, 2019 - 01:39:00 UTC   85 2 38.01188 -121.80505 Antioch 42 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7
1572210024:687910 687910 687910 2019-10-27 14:00:24-07:00 3610 October 27, 2019 - 20:40:01 UTC October 28, 2019 - 01:39:00 UTC   85 2 38.01188 -121.80505 Antioch 42 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7
1572210621:687910 687910 687910 2019-10-27 14:10:21-07:00 3611 October 27, 2019 - 20:40:01 UTC October 28, 2019 - 01:39:00 UTC   85 2 38.01188 -121.80505 Antioch 42 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7
1572211217:687910 687910 687910 2019-10-27 14:20:17-07:00 3612 October 27, 2019 - 20:40:01 UTC October 28, 2019 - 01:39:00 UTC   85 2 38.01188 -121.80505 Antioch 42 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7
1572211828:687910 687910 687910 2019-10-27 14:30:28-07:00 3613 October 27, 2019 - 21:21:38 UTC October 28, 2019 - 01:39:00 UTC   85 2 38.01188 -121.80505 Antioch 42 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1572212416:687910 687910 687910 2019-10-27 14:40:16-07:00 3614 October 27, 2019 - 21:21:38 UTC October 28, 2019 - 01:39:00 UTC   85 2 38.01188 -121.80505 Antioch 42 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1572213020:687910 687910 687910 2019-10-27 14:50:20-07:00 3615 October 27, 2019 - 21:21:38 UTC October 28, 2019 - 01:39:00 UTC   85 2 38.01188 -121.80505 Antioch 42 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1572213622:687910 687910 687910 2019-10-27 15:00:22-07:00 3616 October 27, 2019 - 21:21:38 UTC October 28, 2019 - 01:39:00 UTC   85 2 38.01188 -121.80505 Antioch 42 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1572214818:687910 687910 687910 2019-10-27 15:20:18-07:00 3617 October 27, 2019 - 21:53:05 UTC October 28, 2019 - 01:39:00 UTC   85 2 38.01188 -121.80505 Antioch 42 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1572215421:687910 687910 687910 2019-10-27 15:30:21-07:00 3618 October 27, 2019 - 21:53:05 UTC October 28, 2019 - 01:39:00 UTC   85 2 38.01188 -121.80505 Antioch 42 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1572216018:687910 687910 687910 2019-10-27 15:40:18-07:00 3619 October 27, 2019 - 21:53:05 UTC October 28, 2019 - 01:39:00 UTC   85 2 38.01188 -121.80505 Antioch 42 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1572216627:687910 687910 687910 2019-10-27 15:50:27-07:00 3620 October 27, 2019 - 21:53:05 UTC October 28, 2019 - 01:39:00 UTC   85 2 38.01188 -121.80505 Antioch 42 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1572217226:687910 687910 687910 2019-10-27 16:00:26-07:00 3621 October 27, 2019 - 21:53:05 UTC October 28, 2019 - 01:39:00 UTC   85 2 38.01188 -121.80505 Antioch 42 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1572217823:687910 687910 687910 2019-10-27 16:10:23-07:00 3622 October 27, 2019 - 21:53:05 UTC October 28, 2019 - 01:39:00 UTC   85 2 38.01188 -121.80505 Antioch 42 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1572218422:687910 687910 687910 2019-10-27 16:20:22-07:00 3623 October 27, 2019 - 21:53:05 UTC October 28, 2019 - 01:39:00 UTC   85 2 38.01188 -121.80505 Antioch 42 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1572219023:687910 687910 687910 2019-10-27 16:30:23-07:00 3624 October 27, 2019 - 23:19:55 UTC October 28, 2019 - 01:39:00 UTC   85 2 38.01188 -121.80505 Antioch 42 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])
);
CREATE INDEX [idx_outage_snapshots_outage]
    ON [outage_snapshots] ([outage]);