outage_snapshots

38 rows where outage = 635774

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1570030223:635774 635774 635774 2019-10-02 08:30:23-07:00 187 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570030821:635774 635774 635774 2019-10-02 08:40:21-07:00 188 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570031422:635774 635774 635774 2019-10-02 08:50:22-07:00 189 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570032029:635774 635774 635774 2019-10-02 09:00:29-07:00 190 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570032635:635774 635774 635774 2019-10-02 09:10:35-07:00 191 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570033232:635774 635774 635774 2019-10-02 09:20:32-07:00 192 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570033830:635774 635774 635774 2019-10-02 09:30:30-07:00 193 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570034425:635774 635774 635774 2019-10-02 09:40:25-07:00 194 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570035025:635774 635774 635774 2019-10-02 09:50:25-07:00 195 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570035638:635774 635774 635774 2019-10-02 10:00:38-07:00 196 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570036222:635774 635774 635774 2019-10-02 10:10:22-07:00 197 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570036832:635774 635774 635774 2019-10-02 10:20:32-07:00 198 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570037426:635774 635774 635774 2019-10-02 10:30:26-07:00 199 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570038018:635774 635774 635774 2019-10-02 10:40:18-07:00 200 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570038618:635774 635774 635774 2019-10-02 10:50:18-07:00 201 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570039244:635774 635774 635774 2019-10-02 11:00:44-07:00 202 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570039827:635774 635774 635774 2019-10-02 11:10:27-07:00 203 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570040448:635774 635774 635774 2019-10-02 11:20:48-07:00 204 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570041037:635774 635774 635774 2019-10-02 11:30:37-07:00 205 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570041620:635774 635774 635774 2019-10-02 11:40:20-07:00 206 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570042231:635774 635774 635774 2019-10-02 11:50:31-07:00 207 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570042828:635774 635774 635774 2019-10-02 12:00:28-07:00 208 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570043415:635774 635774 635774 2019-10-02 12:10:15-07:00 209 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570044019:635774 635774 635774 2019-10-02 12:20:19-07:00 210 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570044619:635774 635774 635774 2019-10-02 12:30:19-07:00 211 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570045222:635774 635774 635774 2019-10-02 12:40:22-07:00 212 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570045818:635774 635774 635774 2019-10-02 12:50:18-07:00 213 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570046432:635774 635774 635774 2019-10-02 13:00:32-07:00 214 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570047036:635774 635774 635774 2019-10-02 13:10:36-07:00 215 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570047622:635774 635774 635774 2019-10-02 13:20:22-07:00 216 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570048216:635774 635774 635774 2019-10-02 13:30:16-07:00 217 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570048826:635774 635774 635774 2019-10-02 13:40:26-07:00 218 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570049420:635774 635774 635774 2019-10-02 13:50:20-07:00 219 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570050027:635774 635774 635774 2019-10-02 14:00:27-07:00 220 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570050628:635774 635774 635774 2019-10-02 14:10:28-07:00 221 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570051221:635774 635774 635774 2019-10-02 14:20:21-07:00 222 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570051813:635774 635774 635774 2019-10-02 14:30:13-07:00 223 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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
1570052422:635774 635774 635774 2019-10-02 14:40:22-07:00 224 October 02, 2019 - 15:22:42 UTC October 02, 2019 - 23:00:00 UTC   26 0 38.00077 -121.83397 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 3980.773ms · About: About this site