outage_snapshots

9 rows where outage = 679506 sorted by crewCurrentStatus

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus ▼
1571935826:679506 679506 679506 2019-10-24 09:50:26-07:00 3190 October 24, 2019 - 16:36:54 UTC October 25, 2019 - 00:00:00 UTC   9 0 37.53671 -122.30652 San Mateo 29 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
1571936453:679506 679506 679506 2019-10-24 10:00:53-07:00 3191 October 24, 2019 - 16:36:54 UTC October 25, 2019 - 00:00:00 UTC   9 0 37.53671 -122.30652 San Mateo 29 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
1571937037:679506 679506 679506 2019-10-24 10:10:37-07:00 3192 October 24, 2019 - 16:36:54 UTC October 25, 2019 - 00:00:00 UTC   9 0 37.53671 -122.30652 San Mateo 29 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
1571937638:679506 679506 679506 2019-10-24 10:20:38-07:00 3193 October 24, 2019 - 16:36:54 UTC October 25, 2019 - 00:00:00 UTC   9 0 37.53671 -122.30652 San Mateo 29 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
1571938819:679506 679506 679506 2019-10-24 10:40:19-07:00 3194 October 24, 2019 - 16:36:54 UTC October 25, 2019 - 00:00:00 UTC   9 0 37.53671 -122.30652 San Mateo 29 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
1571939426:679506 679506 679506 2019-10-24 10:50:26-07:00 3195 October 24, 2019 - 16:36:54 UTC October 25, 2019 - 00:00:00 UTC   9 0 37.53671 -122.30652 San Mateo 29 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
1571940043:679506 679506 679506 2019-10-24 11:00:43-07:00 3196 October 24, 2019 - 16:36:54 UTC October 25, 2019 - 00:00:00 UTC   9 0 37.53671 -122.30652 San Mateo 29 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
1571940625:679506 679506 679506 2019-10-24 11:10:25-07:00 3197 October 24, 2019 - 16:36:54 UTC October 25, 2019 - 00:00:00 UTC   9 0 37.53671 -122.30652 San Mateo 29 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
1571941236:679506 679506 679506 2019-10-24 11:20:36-07:00 3198 October 24, 2019 - 16:36:54 UTC October 25, 2019 - 00:00:00 UTC   9 0 37.53671 -122.30652 San Mateo 29 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])
)
Powered by Datasette · Query took 2920.556ms · About: About this site