outage_snapshots

27 rows where outage = 645869

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1570463422:645869 645869 645869 2019-10-07 08:50:22-07:00 900 October 07, 2019 - 15:45:05 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570464044:645869 645869 645869 2019-10-07 09:00:44-07:00 901 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570464632:645869 645869 645869 2019-10-07 09:10:32-07:00 902 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570465214:645869 645869 645869 2019-10-07 09:20:14-07:00 903 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570465831:645869 645869 645869 2019-10-07 09:30:31-07:00 904 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570466425:645869 645869 645869 2019-10-07 09:40:25-07:00 905 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570467027:645869 645869 645869 2019-10-07 09:50:27-07:00 906 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570467625:645869 645869 645869 2019-10-07 10:00:25-07:00 907 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570468243:645869 645869 645869 2019-10-07 10:10:43-07:00 908 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570468827:645869 645869 645869 2019-10-07 10:20:27-07:00 909 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570469421:645869 645869 645869 2019-10-07 10:30:21-07:00 910 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570470025:645869 645869 645869 2019-10-07 10:40:25-07:00 911 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570470636:645869 645869 645869 2019-10-07 10:50:36-07:00 912 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570471230:645869 645869 645869 2019-10-07 11:00:30-07:00 913 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570471828:645869 645869 645869 2019-10-07 11:10:28-07:00 914 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570472424:645869 645869 645869 2019-10-07 11:20:24-07:00 915 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570473017:645869 645869 645869 2019-10-07 11:30:17-07:00 916 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570473628:645869 645869 645869 2019-10-07 11:40:28-07:00 917 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570474238:645869 645869 645869 2019-10-07 11:50:38-07:00 918 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570474877:645869 645869 645869 2019-10-07 12:01:17-07:00 919 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570475431:645869 645869 645869 2019-10-07 12:10:31-07:00 920 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570476016:645869 645869 645869 2019-10-07 12:20:16-07:00 921 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570476619:645869 645869 645869 2019-10-07 12:30:19-07:00 922 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570477220:645869 645869 645869 2019-10-07 12:40:20-07:00 923 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570477816:645869 645869 645869 2019-10-07 12:50:16-07:00 924 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570478423:645869 645869 645869 2019-10-07 13:00:23-07:00 925 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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
1570479028:645869 645869 645869 2019-10-07 13:10:28-07:00 926 October 07, 2019 - 15:49:50 UTC October 07, 2019 - 23:00:00 UTC   30 0 38.00184 -121.83329 Antioch 42 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 4624.481ms · About: About this site