outage_snapshots

36 rows where outage = 647271

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1570551020:647271 647271 647271 2019-10-08 09:10:20-07:00 1040 October 08, 2019 - 16:05:21 UTC October 08, 2019 - 22:00:00 UTC   74 0 35.39788 -118.9277 Bakersfield 2 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
1570551625:647271 647271 647271 2019-10-08 09:20:25-07:00 1041 October 08, 2019 - 16:13:35 UTC October 08, 2019 - 22:00:00 UTC   74 0 35.39788 -118.9277 Bakersfield 2 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
1570552216:647271 647271 647271 2019-10-08 09:30:16-07:00 1042 October 08, 2019 - 16:25:44 UTC October 08, 2019 - 22:00:00 UTC   47 0 35.39788 -118.9277 Bakersfield 2 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
1570552819:647271 647271 647271 2019-10-08 09:40:19-07:00 1043 October 08, 2019 - 16:27:27 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570553431:647271 647271 647271 2019-10-08 09:50:31-07:00 1044 October 08, 2019 - 16:27:27 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570554040:647271 647271 647271 2019-10-08 10:00:40-07:00 1045 October 08, 2019 - 16:27:27 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570554619:647271 647271 647271 2019-10-08 10:10:19-07:00 1046 October 08, 2019 - 16:27:27 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570555224:647271 647271 647271 2019-10-08 10:20:24-07:00 1047 October 08, 2019 - 16:27:27 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570555829:647271 647271 647271 2019-10-08 10:30:29-07:00 1048 October 08, 2019 - 16:27:27 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570556461:647271 647271 647271 2019-10-08 10:41:01-07:00 1049 October 08, 2019 - 16:27:27 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570557027:647271 647271 647271 2019-10-08 10:50:27-07:00 1050 October 08, 2019 - 16:27:27 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570557622:647271 647271 647271 2019-10-08 11:00:22-07:00 1051 October 08, 2019 - 16:27:27 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570558228:647271 647271 647271 2019-10-08 11:10:28-07:00 1052 October 08, 2019 - 16:27:27 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570558831:647271 647271 647271 2019-10-08 11:20:31-07:00 1053 October 08, 2019 - 16:27:27 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570559421:647271 647271 647271 2019-10-08 11:30:21-07:00 1054 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570560032:647271 647271 647271 2019-10-08 11:40:32-07:00 1055 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570560622:647271 647271 647271 2019-10-08 11:50:22-07:00 1056 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570561220:647271 647271 647271 2019-10-08 12:00:20-07:00 1057 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570561817:647271 647271 647271 2019-10-08 12:10:17-07:00 1058 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570562420:647271 647271 647271 2019-10-08 12:20:20-07:00 1059 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570563028:647271 647271 647271 2019-10-08 12:30:28-07:00 1060 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570563616:647271 647271 647271 2019-10-08 12:40:16-07:00 1061 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570564234:647271 647271 647271 2019-10-08 12:50:34-07:00 1062 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570564829:647271 647271 647271 2019-10-08 13:00:29-07:00 1063 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570565418:647271 647271 647271 2019-10-08 13:10:18-07:00 1064 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570566016:647271 647271 647271 2019-10-08 13:20:16-07:00 1065 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570566659:647271 647271 647271 2019-10-08 13:30:59-07:00 1066 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570567215:647271 647271 647271 2019-10-08 13:40:15-07:00 1067 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570567816:647271 647271 647271 2019-10-08 13:50:16-07:00 1068 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570568423:647271 647271 647271 2019-10-08 14:00:23-07:00 1069 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570569022:647271 647271 647271 2019-10-08 14:10:22-07:00 1070 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570569628:647271 647271 647271 2019-10-08 14:20:28-07:00 1071 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570570222:647271 647271 647271 2019-10-08 14:30:22-07:00 1072 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570570826:647271 647271 647271 2019-10-08 14:40:26-07:00 1073 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570571412:647271 647271 647271 2019-10-08 14:50:12-07:00 1074 October 08, 2019 - 18:18:01 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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
1570572039:647271 647271 647271 2019-10-08 15:00:39-07:00 1075 October 08, 2019 - 21:47:45 UTC October 08, 2019 - 22:00:00 UTC   29 0 35.39788 -118.9277 Bakersfield 2 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 4332.64ms · About: About this site