16 rows where outage = 744938

View and edit SQL

Suggested facets: lastUpdateTime, currentEtor, cause, crewCurrentStatus

id ▼ outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1576632027:744938 744938 744938 2019-12-17 17:20:27-08:00 10788 December 18, 2019 - 01:15:11 UTC December 18, 2019 - 03:30:00 UTC December 18, 2019 - 03:30:00 UTC 1 0 37.51055 -122.27847 San Carlos 24 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1576632632:744938 744938 744938 2019-12-17 17:30:32-08:00 10789 December 18, 2019 - 01:15:11 UTC December 18, 2019 - 03:30:00 UTC December 18, 2019 - 03:30:00 UTC 1 0 37.51055 -122.27847 San Carlos 24 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1576633223:744938 744938 744938 2019-12-17 17:40:23-08:00 10790 December 18, 2019 - 01:15:11 UTC December 18, 2019 - 03:30:00 UTC December 18, 2019 - 03:30:00 UTC 1 0 37.51055 -122.27847 San Carlos 24 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1576633836:744938 744938 744938 2019-12-17 17:50:36-08:00 10791 December 18, 2019 - 01:15:11 UTC December 18, 2019 - 03:30:00 UTC December 18, 2019 - 03:30:00 UTC 1 0 37.51055 -122.27847 San Carlos 24 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1576634421:744938 744938 744938 2019-12-17 18:00:21-08:00 10792 December 18, 2019 - 01:15:11 UTC December 18, 2019 - 03:30:00 UTC December 18, 2019 - 03:30:00 UTC 1 0 37.51055 -122.27847 San Carlos 24 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1576635017:744938 744938 744938 2019-12-17 18:10:17-08:00 10793 December 18, 2019 - 01:15:11 UTC December 18, 2019 - 03:30:00 UTC December 18, 2019 - 03:30:00 UTC 1 0 37.51055 -122.27847 San Carlos 24 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1576635647:744938 744938 744938 2019-12-17 18:20:47-08:00 10794 December 18, 2019 - 01:15:11 UTC December 18, 2019 - 03:30:00 UTC December 18, 2019 - 03:30:00 UTC 1 0 37.51055 -122.27847 San Carlos 24 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1576636219:744938 744938 744938 2019-12-17 18:30:19-08:00 10795 December 18, 2019 - 01:15:11 UTC December 18, 2019 - 03:30:00 UTC December 18, 2019 - 03:30:00 UTC 1 0 37.51055 -122.27847 San Carlos 24 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1576636816:744938 744938 744938 2019-12-17 18:40:16-08:00 10796 December 18, 2019 - 01:15:11 UTC December 18, 2019 - 03:30:00 UTC December 18, 2019 - 03:30:00 UTC 1 0 37.51055 -122.27847 San Carlos 24 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1576637434:744938 744938 744938 2019-12-17 18:50:34-08:00 10797 December 18, 2019 - 01:15:11 UTC December 18, 2019 - 03:30:00 UTC December 18, 2019 - 03:30:00 UTC 1 0 37.51055 -122.27847 San Carlos 24 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1576638024:744938 744938 744938 2019-12-17 19:00:24-08:00 10798 December 18, 2019 - 01:15:11 UTC December 18, 2019 - 03:30:00 UTC December 18, 2019 - 03:30:00 UTC 1 0 37.51055 -122.27847 San Carlos 24 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1576638627:744938 744938 744938 2019-12-17 19:10:27-08:00 10799 December 18, 2019 - 03:01:45 UTC December 18, 2019 - 03:30:00 UTC December 18, 2019 - 03:30:00 UTC 1 0 37.51055 -122.27847 San Carlos 24 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1576639230:744938 744938 744938 2019-12-17 19:20:30-08:00 10800 December 18, 2019 - 03:15:26 UTC December 18, 2019 - 05:15:00 UTC   1 0 37.51055 -122.27847 San Carlos 24 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1576639831:744938 744938 744938 2019-12-17 19:30:31-08:00 10801 December 18, 2019 - 03:25:23 UTC December 18, 2019 - 05:15:00 UTC   1 0 37.51055 -122.27847 San Carlos 24 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1576640431:744938 744938 744938 2019-12-17 19:40:31-08:00 10802 December 18, 2019 - 03:25:23 UTC December 18, 2019 - 05:15:00 UTC   1 0 37.51055 -122.27847 San Carlos 24 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1576641015:744938 744938 744938 2019-12-17 19:50:15-08:00 10803 December 18, 2019 - 03:25:23 UTC December 18, 2019 - 05:15:00 UTC   1 0 37.51055 -122.27847 San Carlos 24 PG&E is investigating the cause of your outage. 6 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]);