outage_snapshots

28 rows where outage = 667311

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1571376030:667311 667311 667311 2019-10-17 22:20:30-07:00 2289 October 18, 2019 - 05:14:31 UTC October 18, 2019 - 12:00:00 UTC   8 0 37.89399 -122.06147 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
1571376629:667311 667311 667311 2019-10-17 22:30:29-07:00 2290 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571377223:667311 667311 667311 2019-10-17 22:40:23-07:00 2291 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571377814:667311 667311 667311 2019-10-17 22:50:14-07:00 2292 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571378441:667311 667311 667311 2019-10-17 23:00:41-07:00 2293 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571379020:667311 667311 667311 2019-10-17 23:10:20-07:00 2294 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571379618:667311 667311 667311 2019-10-17 23:20:18-07:00 2295 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571380230:667311 667311 667311 2019-10-17 23:30:30-07:00 2296 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571380819:667311 667311 667311 2019-10-17 23:40:19-07:00 2297 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571381417:667311 667311 667311 2019-10-17 23:50:17-07:00 2298 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571382040:667311 667311 667311 2019-10-18 00:00:40-07:00 2299 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571382622:667311 667311 667311 2019-10-18 00:10:22-07:00 2300 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571383244:667311 667311 667311 2019-10-18 00:20:44-07:00 2301 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571383815:667311 667311 667311 2019-10-18 00:30:15-07:00 2302 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571384417:667311 667311 667311 2019-10-18 00:40:17-07:00 2303 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571385020:667311 667311 667311 2019-10-18 00:50:20-07:00 2304 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571385647:667311 667311 667311 2019-10-18 01:00:47-07:00 2305 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571386377:667311 667311 667311 2019-10-18 01:12:57-07:00 2306 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571386815:667311 667311 667311 2019-10-18 01:20:15-07:00 2307 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571387424:667311 667311 667311 2019-10-18 01:30:24-07:00 2308 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571388020:667311 667311 667311 2019-10-18 01:40:20-07:00 2309 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571388614:667311 667311 667311 2019-10-18 01:50:14-07:00 2310 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571389233:667311 667311 667311 2019-10-18 02:00:33-07:00 2311 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571389843:667311 667311 667311 2019-10-18 02:10:43-07:00 2312 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571390450:667311 667311 667311 2019-10-18 02:20:50-07:00 2313 October 18, 2019 - 05:18:58 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571391023:667311 667311 667311 2019-10-18 02:30:23-07:00 2314 October 18, 2019 - 09:24:51 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571391617:667311 667311 667311 2019-10-18 02:40:17-07:00 2315 October 18, 2019 - 09:24:51 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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
1571392215:667311 667311 667311 2019-10-18 02:50:15-07:00 2316 October 18, 2019 - 09:38:36 UTC October 18, 2019 - 12:00:00 UTC   7 0 37.89399 -122.06147 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 4870.854ms · About: About this site