28 rows where outage = 675893

View and edit SQL

Suggested facets: lastUpdateTime, crewCurrentStatus

id ▼ outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1571674216:675893 675893 675893 2019-10-21 09:10:16-07:00 2771 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571674832:675893 675893 675893 2019-10-21 09:20:32-07:00 2772 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571675431:675893 675893 675893 2019-10-21 09:30:31-07:00 2773 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571676018:675893 675893 675893 2019-10-21 09:40:18-07:00 2774 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571676618:675893 675893 675893 2019-10-21 09:50:18-07:00 2775 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571677231:675893 675893 675893 2019-10-21 10:00:31-07:00 2776 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571677830:675893 675893 675893 2019-10-21 10:10:30-07:00 2777 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571678453:675893 675893 675893 2019-10-21 10:20:53-07:00 2778 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571679043:675893 675893 675893 2019-10-21 10:30:43-07:00 2779 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571679634:675893 675893 675893 2019-10-21 10:40:34-07:00 2780 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571680228:675893 675893 675893 2019-10-21 10:50:28-07:00 2781 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571680850:675893 675893 675893 2019-10-21 11:00:50-07:00 2782 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571681422:675893 675893 675893 2019-10-21 11:10:22-07:00 2783 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571682026:675893 675893 675893 2019-10-21 11:20:26-07:00 2784 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571682735:675893 675893 675893 2019-10-21 11:32:15-07:00 2785 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571683217:675893 675893 675893 2019-10-21 11:40:17-07:00 2786 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571683844:675893 675893 675893 2019-10-21 11:50:44-07:00 2787 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571684444:675893 675893 675893 2019-10-21 12:00:44-07:00 2788 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571685019:675893 675893 675893 2019-10-21 12:10:19-07:00 2789 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571685625:675893 675893 675893 2019-10-21 12:20:25-07:00 2790 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571686241:675893 675893 675893 2019-10-21 12:30:41-07:00 2791 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571686815:675893 675893 675893 2019-10-21 12:40:15-07:00 2792 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571687413:675893 675893 675893 2019-10-21 12:50:13-07:00 2793 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571688034:675893 675893 675893 2019-10-21 13:00:34-07:00 2794 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571688624:675893 675893 675893 2019-10-21 13:10:24-07:00 2795 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571689222:675893 675893 675893 2019-10-21 13:20:22-07:00 2796 October 21, 2019 - 16:04:30 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571689818:675893 675893 675893 2019-10-21 13:30:18-07:00 2797 October 21, 2019 - 20:20:10 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1571690431:675893 675893 675893 2019-10-21 13:40:31-07:00 2798 October 21, 2019 - 20:29:25 UTC October 21, 2019 - 21:00:00 UTC   16 0 37.66394 -121.26835 Tracy 38 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 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]);