outage_snapshots

23 rows where outage = 647016 sorted by longitude

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude ▼ regionName cause crewCurrentStatus
1570509015:647016 647016 647016 2019-10-07 21:30:15-07:00 976 October 08, 2019 - 04:13:19 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570509615:647016 647016 647016 2019-10-07 21:40:15-07:00 977 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570510211:647016 647016 647016 2019-10-07 21:50:11-07:00 978 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570510820:647016 647016 647016 2019-10-07 22:00:20-07:00 979 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570511439:647016 647016 647016 2019-10-07 22:10:39-07:00 980 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570512035:647016 647016 647016 2019-10-07 22:20:35-07:00 981 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570512620:647016 647016 647016 2019-10-07 22:30:20-07:00 982 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570513237:647016 647016 647016 2019-10-07 22:40:37-07:00 983 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570513814:647016 647016 647016 2019-10-07 22:50:14-07:00 984 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570514412:647016 647016 647016 2019-10-07 23:00:12-07:00 985 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570515035:647016 647016 647016 2019-10-07 23:10:35-07:00 986 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570515610:647016 647016 647016 2019-10-07 23:20:10-07:00 987 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570516226:647016 647016 647016 2019-10-07 23:30:26-07:00 988 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570516821:647016 647016 647016 2019-10-07 23:40:21-07:00 989 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570517426:647016 647016 647016 2019-10-07 23:50:26-07:00 990 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570518027:647016 647016 647016 2019-10-08 00:00:27-07:00 991 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570518626:647016 647016 647016 2019-10-08 00:10:26-07:00 992 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570519221:647016 647016 647016 2019-10-08 00:20:21-07:00 993 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570519821:647016 647016 647016 2019-10-08 00:30:21-07:00 994 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570520425:647016 647016 647016 2019-10-08 00:40:25-07:00 995 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570521024:647016 647016 647016 2019-10-08 00:50:24-07:00 996 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570521647:647016 647016 647016 2019-10-08 01:00:47-07:00 997 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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
1570522824:647016 647016 647016 2019-10-08 01:20:24-07:00 998 October 08, 2019 - 04:23:55 UTC October 08, 2019 - 12:00:00 UTC   6 0 37.89259 -122.0616 Walnut Creek 33 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])
)
Powered by Datasette · Query took 6980.407ms · About: About this site