outage_snapshots

32 rows where outage = 653963

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1570768819:653963 653963 653963 2019-10-10 21:40:19-07:00 1299 October 11, 2019 - 04:26:24 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570769436:653963 653963 653963 2019-10-10 21:50:36-07:00 1300 October 11, 2019 - 04:26:24 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570770023:653963 653963 653963 2019-10-10 22:00:23-07:00 1301 October 11, 2019 - 04:26:24 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570770622:653963 653963 653963 2019-10-10 22:10:22-07:00 1302 October 11, 2019 - 04:26:24 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570771226:653963 653963 653963 2019-10-10 22:20:26-07:00 1303 October 11, 2019 - 04:26:24 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570771822:653963 653963 653963 2019-10-10 22:30:22-07:00 1304 October 11, 2019 - 04:26:24 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570773019:653963 653963 653963 2019-10-10 22:50:19-07:00 1305 October 11, 2019 - 04:26:24 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570773635:653963 653963 653963 2019-10-10 23:00:35-07:00 1306 October 11, 2019 - 05:46:59 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570774236:653963 653963 653963 2019-10-10 23:10:36-07:00 1307 October 11, 2019 - 05:46:59 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570774822:653963 653963 653963 2019-10-10 23:20:22-07:00 1308 October 11, 2019 - 05:46:59 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570775416:653963 653963 653963 2019-10-10 23:30:16-07:00 1309 October 11, 2019 - 05:46:59 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570776030:653963 653963 653963 2019-10-10 23:40:30-07:00 1310 October 11, 2019 - 05:46:59 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570776618:653963 653963 653963 2019-10-10 23:50:18-07:00 1311 October 11, 2019 - 05:46:59 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570777232:653963 653963 653963 2019-10-11 00:00:32-07:00 1312 October 11, 2019 - 05:46:59 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570777828:653963 653963 653963 2019-10-11 00:10:28-07:00 1313 October 11, 2019 - 05:46:59 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570778420:653963 653963 653963 2019-10-11 00:20:20-07:00 1314 October 11, 2019 - 05:46:59 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570779036:653963 653963 653963 2019-10-11 00:30:36-07:00 1315 October 11, 2019 - 05:46:59 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570779633:653963 653963 653963 2019-10-11 00:40:33-07:00 1316 October 11, 2019 - 05:46:59 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570780219:653963 653963 653963 2019-10-11 00:50:19-07:00 1317 October 11, 2019 - 05:46:59 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570780830:653963 653963 653963 2019-10-11 01:00:30-07:00 1318 October 11, 2019 - 05:46:59 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570781440:653963 653963 653963 2019-10-11 01:10:40-07:00 1319 October 11, 2019 - 05:46:59 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570782048:653963 653963 653963 2019-10-11 01:20:48-07:00 1320 October 11, 2019 - 05:46:59 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570782622:653963 653963 653963 2019-10-11 01:30:22-07:00 1321 October 11, 2019 - 05:46:59 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570783219:653963 653963 653963 2019-10-11 01:40:19-07:00 1322 October 11, 2019 - 08:25:55 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570783833:653963 653963 653963 2019-10-11 01:50:33-07:00 1323 October 11, 2019 - 08:25:55 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570784421:653963 653963 653963 2019-10-11 02:00:21-07:00 1324 October 11, 2019 - 08:25:55 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570785019:653963 653963 653963 2019-10-11 02:10:19-07:00 1325 October 11, 2019 - 08:25:55 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570785619:653963 653963 653963 2019-10-11 02:20:19-07:00 1326 October 11, 2019 - 08:25:55 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570786820:653963 653963 653963 2019-10-11 02:40:20-07:00 1327 October 11, 2019 - 08:25:55 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570787419:653963 653963 653963 2019-10-11 02:50:19-07:00 1328 October 11, 2019 - 08:25:55 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570788033:653963 653963 653963 2019-10-11 03:00:33-07:00 1329 October 11, 2019 - 08:25:55 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570788617:653963 653963 653963 2019-10-11 03:10:17-07:00 1330 October 11, 2019 - 08:25:55 UTC     1 0 37.9269 -122.06331 Walnut Creek 33 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4

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 5658.351ms · About: About this site