15 rows where outage = 671059

View and edit SQL

Suggested facets: lastUpdateTime

id ▼ outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1571474412:671059 671059 671059 2019-10-19 01:40:12-07:00 2447 October 19, 2019 - 08:35:04 UTC October 19, 2019 - 11:00:00 UTC   16 0 37.53587 -122.2989 San Mateo 29 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
1571475013:671059 671059 671059 2019-10-19 01:50:13-07:00 2448 October 19, 2019 - 08:35:04 UTC October 19, 2019 - 11:00:00 UTC   16 0 37.53587 -122.2989 San Mateo 29 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
1571475618:671059 671059 671059 2019-10-19 02:00:18-07:00 2449 October 19, 2019 - 08:35:04 UTC October 19, 2019 - 11:00:00 UTC   16 0 37.53587 -122.2989 San Mateo 29 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
1571476222:671059 671059 671059 2019-10-19 02:10:22-07:00 2450 October 19, 2019 - 08:35:04 UTC October 19, 2019 - 11:00:00 UTC   16 0 37.53587 -122.2989 San Mateo 29 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
1571476810:671059 671059 671059 2019-10-19 02:20:10-07:00 2451 October 19, 2019 - 08:35:04 UTC October 19, 2019 - 11:00:00 UTC   16 0 37.53587 -122.2989 San Mateo 29 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
1571477428:671059 671059 671059 2019-10-19 02:30:28-07:00 2452 October 19, 2019 - 08:35:04 UTC October 19, 2019 - 11:00:00 UTC   16 0 37.53587 -122.2989 San Mateo 29 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
1571478013:671059 671059 671059 2019-10-19 02:40:13-07:00 2453 October 19, 2019 - 08:35:04 UTC October 19, 2019 - 11:00:00 UTC   16 0 37.53587 -122.2989 San Mateo 29 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
1571478625:671059 671059 671059 2019-10-19 02:50:25-07:00 2454 October 19, 2019 - 08:35:04 UTC October 19, 2019 - 11:00:00 UTC   16 0 37.53587 -122.2989 San Mateo 29 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
1571479217:671059 671059 671059 2019-10-19 03:00:17-07:00 2455 October 19, 2019 - 08:35:04 UTC October 19, 2019 - 11:00:00 UTC   16 0 37.53587 -122.2989 San Mateo 29 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
1571479816:671059 671059 671059 2019-10-19 03:10:16-07:00 2456 October 19, 2019 - 08:35:04 UTC October 19, 2019 - 11:00:00 UTC   16 0 37.53587 -122.2989 San Mateo 29 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
1571480413:671059 671059 671059 2019-10-19 03:20:13-07:00 2457 October 19, 2019 - 08:35:04 UTC October 19, 2019 - 11:00:00 UTC   16 0 37.53587 -122.2989 San Mateo 29 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
1571481024:671059 671059 671059 2019-10-19 03:30:24-07:00 2458 October 19, 2019 - 10:18:27 UTC October 19, 2019 - 11:00:00 UTC   16 0 37.53587 -122.2989 San Mateo 29 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
1571481617:671059 671059 671059 2019-10-19 03:40:17-07:00 2459 October 19, 2019 - 10:18:27 UTC October 19, 2019 - 11:00:00 UTC   16 0 37.53587 -122.2989 San Mateo 29 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
1571482216:671059 671059 671059 2019-10-19 03:50:16-07:00 2460 October 19, 2019 - 10:18:27 UTC October 19, 2019 - 11:00:00 UTC   16 0 37.53587 -122.2989 San Mateo 29 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
1571483418:671059 671059 671059 2019-10-19 04:10:18-07:00 2461 October 19, 2019 - 10:18:27 UTC October 19, 2019 - 11:00:00 UTC   16 0 37.53587 -122.2989 San Mateo 29 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

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]);