6 rows where outage = 1216254

View and edit SQL

Suggested facets: lastUpdateTime

id ▼ outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1611081250:1216254 1216254 1216254 2021-01-19 10:34:10-08:00 22150 January 19, 2021 - 17:56:36 UTC     1 1 37.50387 -122.27 San Carlos 24 Our preliminary determination is that your outage was caused by the weather. 8 PG&E has assigned a crew to assess the outage. 1
1611087536:1216254 1216254 1216254 2021-01-19 12:18:56-08:00 22152 January 19, 2021 - 19:29:53 UTC     1 1 37.50387 -122.27 San Carlos 24 Our preliminary determination is that your outage was caused by the weather. 8 PG&E has assigned a crew to assess the outage. 1
1611090314:1216254 1216254 1216254 2021-01-19 13:05:14-08:00 22153 January 19, 2021 - 19:29:53 UTC     1 1 37.50387 -122.27 San Carlos 24 Our preliminary determination is that your outage was caused by the weather. 8 PG&E has assigned a crew to assess the outage. 1
1611093013:1216254 1216254 1216254 2021-01-19 13:50:13-08:00 22154 January 19, 2021 - 19:29:53 UTC     1 1 37.50387 -122.27 San Carlos 24 Our preliminary determination is that your outage was caused by the weather. 8 PG&E has assigned a crew to assess the outage. 1
1611097883:1216254 1216254 1216254 2021-01-19 15:11:23-08:00 22155 January 19, 2021 - 19:29:53 UTC     1 1 37.50387 -122.27 San Carlos 24 Our preliminary determination is that your outage was caused by the weather. 8 PG&E has assigned a crew to assess the outage. 1
1611101339:1216254 1216254 1216254 2021-01-19 16:08:59-08:00 22156 January 19, 2021 - 23:53:17 UTC     1 1 37.50387 -122.27 San Carlos 24 Our preliminary determination is that your outage was caused by the weather. 8 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]);