outage_snapshots

31 rows where outage = 653247

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1570738822:653247 653247 653247 2019-10-10 13:20:22-07:00 1254 October 10, 2019 - 20:02:35 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570739420:653247 653247 653247 2019-10-10 13:30:20-07:00 1255 October 10, 2019 - 20:02:35 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570740023:653247 653247 653247 2019-10-10 13:40:23-07:00 1256 October 10, 2019 - 20:02:35 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570740636:653247 653247 653247 2019-10-10 13:50:36-07:00 1257 October 10, 2019 - 20:02:35 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570741827:653247 653247 653247 2019-10-10 14:10:27-07:00 1258 October 10, 2019 - 20:02:35 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570742417:653247 653247 653247 2019-10-10 14:20:17-07:00 1259 October 10, 2019 - 20:02:35 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570743698:653247 653247 653247 2019-10-10 14:41:38-07:00 1260 October 10, 2019 - 20:02:35 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570744221:653247 653247 653247 2019-10-10 14:50:21-07:00 1261 October 10, 2019 - 20:02:35 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570744818:653247 653247 653247 2019-10-10 15:00:18-07:00 1262 October 10, 2019 - 20:02:35 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570745417:653247 653247 653247 2019-10-10 15:10:17-07:00 1263 October 10, 2019 - 20:02:35 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570746036:653247 653247 653247 2019-10-10 15:20:36-07:00 1264 October 10, 2019 - 22:05:16 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570746632:653247 653247 653247 2019-10-10 15:30:32-07:00 1265 October 10, 2019 - 22:05:16 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570747239:653247 653247 653247 2019-10-10 15:40:39-07:00 1266 October 10, 2019 - 22:05:16 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570747826:653247 653247 653247 2019-10-10 15:50:26-07:00 1267 October 10, 2019 - 22:05:16 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570748443:653247 653247 653247 2019-10-10 16:00:43-07:00 1268 October 10, 2019 - 22:05:16 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570749020:653247 653247 653247 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:05:16 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570750237:653247 653247 653247 2019-10-10 16:30:37-07:00 1271 October 10, 2019 - 22:05:16 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570750819:653247 653247 653247 2019-10-10 16:40:19-07:00 1272 October 10, 2019 - 23:29:24 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570751419:653247 653247 653247 2019-10-10 16:50:19-07:00 1273 October 10, 2019 - 23:29:24 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570752016:653247 653247 653247 2019-10-10 17:00:16-07:00 1274 October 10, 2019 - 23:43:45 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570752628:653247 653247 653247 2019-10-10 17:10:28-07:00 1275 October 10, 2019 - 23:43:45 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570753215:653247 653247 653247 2019-10-10 17:20:15-07:00 1276 October 10, 2019 - 23:43:45 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570753827:653247 653247 653247 2019-10-10 17:30:27-07:00 1277 October 10, 2019 - 23:43:45 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570754416:653247 653247 653247 2019-10-10 17:40:16-07:00 1278 October 10, 2019 - 23:43:45 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570755024:653247 653247 653247 2019-10-10 17:50:24-07:00 1279 October 10, 2019 - 23:43:45 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570755639:653247 653247 653247 2019-10-10 18:00:39-07:00 1280 October 10, 2019 - 23:43:45 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570756220:653247 653247 653247 2019-10-10 18:10:20-07:00 1281 October 10, 2019 - 23:43:45 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570756815:653247 653247 653247 2019-10-10 18:20:15-07:00 1282 October 10, 2019 - 23:43:45 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570757419:653247 653247 653247 2019-10-10 18:30:19-07:00 1283 October 10, 2019 - 23:43:45 UTC     1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570758024:653247 653247 653247 2019-10-10 18:40:24-07:00 1284 October 11, 2019 - 01:36:19 UTC October 11, 2019 - 06:00:00 UTC   1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1
1570758619:653247 653247 653247 2019-10-10 18:50:19-07:00 1285 October 11, 2019 - 01:36:19 UTC October 11, 2019 - 06:00:00 UTC   1 0 37.76819 -122.00754 Castro Valley 4 To protect public safety, power in your area has been turned off due to extreme weather conditions with high fire danger. Power will be restored as soon as it is safe to do so. 9 PG&E has assigned a crew to assess the outage. 1

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