15 rows where outage = 1130852

View and edit SQL

Suggested facets: lastUpdateTime, currentEtor

id ▼ outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1603916813:1130852 1130852 1130852 2020-10-28 13:26:53-07:00 17327 October 28, 2020 - 20:13:17 UTC October 29, 2020 - 01:00:00 UTC   5 0 37.49422 -122.27065 San Carlos 24 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1603917746:1130852 1130852 1130852 2020-10-28 13:42:26-07:00 17328 October 28, 2020 - 20:13:17 UTC October 29, 2020 - 01:00:00 UTC   5 0 37.49422 -122.27065 San Carlos 24 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1603918195:1130852 1130852 1130852 2020-10-28 13:49:55-07:00 17329 October 28, 2020 - 20:13:17 UTC October 29, 2020 - 01:00:00 UTC   5 0 37.49422 -122.27065 San Carlos 24 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1603918615:1130852 1130852 1130852 2020-10-28 13:56:55-07:00 17330 October 28, 2020 - 20:13:17 UTC October 29, 2020 - 01:00:00 UTC   5 0 37.49422 -122.27065 San Carlos 24 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1603920253:1130852 1130852 1130852 2020-10-28 14:24:13-07:00 17331 October 28, 2020 - 21:05:27 UTC October 29, 2020 - 01:00:00 UTC   5 0 37.49422 -122.27065 San Carlos 24 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1603920955:1130852 1130852 1130852 2020-10-28 14:35:55-07:00 17332 October 28, 2020 - 21:05:27 UTC October 29, 2020 - 01:00:00 UTC   5 0 37.49422 -122.27065 San Carlos 24 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1603921805:1130852 1130852 1130852 2020-10-28 14:50:05-07:00 17333 October 28, 2020 - 21:05:27 UTC October 29, 2020 - 01:00:00 UTC   5 0 37.49422 -122.27065 San Carlos 24 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1603922216:1130852 1130852 1130852 2020-10-28 14:56:56-07:00 17334 October 28, 2020 - 21:05:27 UTC October 29, 2020 - 01:00:00 UTC   5 0 37.49422 -122.27065 San Carlos 24 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1603924047:1130852 1130852 1130852 2020-10-28 15:27:27-07:00 17335 October 28, 2020 - 21:05:27 UTC October 29, 2020 - 01:00:00 UTC   5 0 37.49422 -122.27065 San Carlos 24 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1603924952:1130852 1130852 1130852 2020-10-28 15:42:32-07:00 17336 October 28, 2020 - 22:34:54 UTC October 29, 2020 - 03:00:00 UTC   5 0 37.49422 -122.27065 San Carlos 24 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1603925381:1130852 1130852 1130852 2020-10-28 15:49:41-07:00 17337 October 28, 2020 - 22:34:54 UTC October 29, 2020 - 03:00:00 UTC   5 0 37.49422 -122.27065 San Carlos 24 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1603925803:1130852 1130852 1130852 2020-10-28 15:56:43-07:00 17338 October 28, 2020 - 22:34:54 UTC October 29, 2020 - 03:00:00 UTC   5 0 37.49422 -122.27065 San Carlos 24 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1603927490:1130852 1130852 1130852 2020-10-28 16:24:50-07:00 17339 October 28, 2020 - 22:34:54 UTC October 29, 2020 - 03:00:00 UTC   5 0 37.49422 -122.27065 San Carlos 24 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1603928575:1130852 1130852 1130852 2020-10-28 16:42:55-07:00 17340 October 28, 2020 - 22:34:54 UTC October 29, 2020 - 03:00:00 UTC   5 0 37.49422 -122.27065 San Carlos 24 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1603929079:1130852 1130852 1130852 2020-10-28 16:51:19-07:00 17341 October 28, 2020 - 22:34:54 UTC October 29, 2020 - 03:00:00 UTC   5 0 37.49422 -122.27065 San Carlos 24 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1

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