outage_snapshots

2,004 rows where regionName = 80

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1570765221:653724 653724 653724 2019-10-10 20:40:21-07:00 1293 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570765818:653724 653724 653724 2019-10-10 20:50:18-07:00 1294 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570766426:653724 653724 653724 2019-10-10 21:00:26-07:00 1295 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570767054:653724 653724 653724 2019-10-10 21:10:54-07:00 1296 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570767633:653724 653724 653724 2019-10-10 21:20:33-07:00 1297 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570768223:653724 653724 653724 2019-10-10 21:30:23-07:00 1298 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570768819:653724 653724 653724 2019-10-10 21:40:19-07:00 1299 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570769436:653724 653724 653724 2019-10-10 21:50:36-07:00 1300 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570770023:653724 653724 653724 2019-10-10 22:00:23-07:00 1301 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570770622:653724 653724 653724 2019-10-10 22:10:22-07:00 1302 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570771226:653724 653724 653724 2019-10-10 22:20:26-07:00 1303 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570771822:653724 653724 653724 2019-10-10 22:30:22-07:00 1304 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570773019:653724 653724 653724 2019-10-10 22:50:19-07:00 1305 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570773635:653724 653724 653724 2019-10-10 23:00:35-07:00 1306 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570774236:653724 653724 653724 2019-10-10 23:10:36-07:00 1307 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570774822:653724 653724 653724 2019-10-10 23:20:22-07:00 1308 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570775416:653724 653724 653724 2019-10-10 23:30:16-07:00 1309 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570776030:653724 653724 653724 2019-10-10 23:40:30-07:00 1310 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570776618:653724 653724 653724 2019-10-10 23:50:18-07:00 1311 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570777232:653724 653724 653724 2019-10-11 00:00:32-07:00 1312 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570777828:653724 653724 653724 2019-10-11 00:10:28-07:00 1313 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570778420:653724 653724 653724 2019-10-11 00:20:20-07:00 1314 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570779036:653724 653724 653724 2019-10-11 00:30:36-07:00 1315 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570779633:653724 653724 653724 2019-10-11 00:40:33-07:00 1316 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570780219:653724 653724 653724 2019-10-11 00:50:19-07:00 1317 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570780830:653724 653724 653724 2019-10-11 01:00:30-07:00 1318 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570781440:653724 653724 653724 2019-10-11 01:10:40-07:00 1319 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570782048:653724 653724 653724 2019-10-11 01:20:48-07:00 1320 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570782622:653724 653724 653724 2019-10-11 01:30:22-07:00 1321 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570783219:653724 653724 653724 2019-10-11 01:40:19-07:00 1322 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570783833:653724 653724 653724 2019-10-11 01:50:33-07:00 1323 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570784421:653724 653724 653724 2019-10-11 02:00:21-07:00 1324 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570785019:653724 653724 653724 2019-10-11 02:10:19-07:00 1325 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570785619:653724 653724 653724 2019-10-11 02:20:19-07:00 1326 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570786820:653724 653724 653724 2019-10-11 02:40:20-07:00 1327 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570787419:653724 653724 653724 2019-10-11 02:50:19-07:00 1328 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570788033:653724 653724 653724 2019-10-11 03:00:33-07:00 1329 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570788617:653724 653724 653724 2019-10-11 03:10:17-07:00 1330 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570789224:653724 653724 653724 2019-10-11 03:20:24-07:00 1331 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570789825:653724 653724 653724 2019-10-11 03:30:25-07:00 1332 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570790428:653724 653724 653724 2019-10-11 03:40:28-07:00 1333 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570791023:653724 653724 653724 2019-10-11 03:50:23-07:00 1334 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570791623:653724 653724 653724 2019-10-11 04:00:23-07:00 1335 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570792224:653724 653724 653724 2019-10-11 04:10:24-07:00 1336 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570792822:653724 653724 653724 2019-10-11 04:20:22-07:00 1337 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570793427:653724 653724 653724 2019-10-11 04:30:27-07:00 1338 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570794020:653724 653724 653724 2019-10-11 04:40:20-07:00 1339 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570794621:653724 653724 653724 2019-10-11 04:50:21-07:00 1340 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570795243:653724 653724 653724 2019-10-11 05:00:43-07:00 1341 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570795828:653724 653724 653724 2019-10-11 05:10:28-07:00 1342 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570796419:653724 653724 653724 2019-10-11 05:20:19-07:00 1343 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570797024:653724 653724 653724 2019-10-11 05:30:24-07:00 1344 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570797622:653724 653724 653724 2019-10-11 05:40:22-07:00 1345 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570798234:653724 653724 653724 2019-10-11 05:50:34-07:00 1346 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570798830:653724 653724 653724 2019-10-11 06:00:30-07:00 1347 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570799420:653724 653724 653724 2019-10-11 06:10:20-07:00 1348 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570800016:653724 653724 653724 2019-10-11 06:20:16-07:00 1349 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570800634:653724 653724 653724 2019-10-11 06:30:34-07:00 1350 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570801229:653724 653724 653724 2019-10-11 06:40:29-07:00 1351 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570801827:653724 653724 653724 2019-10-11 06:50:27-07:00 1352 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570802438:653724 653724 653724 2019-10-11 07:00:38-07:00 1353 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570803029:653724 653724 653724 2019-10-11 07:10:29-07:00 1354 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570803642:653724 653724 653724 2019-10-11 07:20:42-07:00 1355 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570804233:653724 653724 653724 2019-10-11 07:30:33-07:00 1356 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570804831:653724 653724 653724 2019-10-11 07:40:31-07:00 1357 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570805426:653724 653724 653724 2019-10-11 07:50:26-07:00 1358 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570806040:653724 653724 653724 2019-10-11 08:00:40-07:00 1359 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570806622:653724 653724 653724 2019-10-11 08:10:22-07:00 1360 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570807224:653724 653724 653724 2019-10-11 08:20:24-07:00 1361 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570807830:653724 653724 653724 2019-10-11 08:30:30-07:00 1362 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570808422:653724 653724 653724 2019-10-11 08:40:22-07:00 1363 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570809616:653724 653724 653724 2019-10-11 09:00:16-07:00 1364 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570810228:653724 653724 653724 2019-10-11 09:10:28-07:00 1365 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570810820:653724 653724 653724 2019-10-11 09:20:20-07:00 1366 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570811457:653724 653724 653724 2019-10-11 09:30:57-07:00 1367 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570812029:653724 653724 653724 2019-10-11 09:40:29-07:00 1368 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570812624:653724 653724 653724 2019-10-11 09:50:24-07:00 1369 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570813239:653724 653724 653724 2019-10-11 10:00:39-07:00 1370 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570813819:653724 653724 653724 2019-10-11 10:10:19-07:00 1371 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570814423:653724 653724 653724 2019-10-11 10:20:23-07:00 1372 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570815023:653724 653724 653724 2019-10-11 10:30:23-07:00 1373 October 11, 2019 - 08:32:56 UTC     1 0 37.59266 -122.02591 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570844413:654848 654848 654848 2019-10-11 18:40:13-07:00 1420 October 12, 2019 - 01:34:15 UTC     1 0 37.56856 -122.06721 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570845016:654848 654848 654848 2019-10-11 18:50:16-07:00 1421 October 12, 2019 - 01:38:55 UTC     1 0 37.56856 -122.06721 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570845619:654848 654848 654848 2019-10-11 19:00:19-07:00 1422 October 12, 2019 - 01:38:55 UTC     1 0 37.56856 -122.06721 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570846222:654848 654848 654848 2019-10-11 19:10:22-07:00 1423 October 12, 2019 - 01:38:55 UTC     1 0 37.56856 -122.06721 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570909812:655238 655238 655238 2019-10-12 12:50:12-07:00 1528 October 12, 2019 - 19:46:08 UTC     1 0 37.59115 -122.01489 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570910431:655238 655238 655238 2019-10-12 13:00:31-07:00 1529 October 12, 2019 - 19:47:51 UTC     1 0 37.59115 -122.01489 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570911024:655238 655238 655238 2019-10-12 13:10:24-07:00 1530 October 12, 2019 - 19:47:51 UTC     1 0 37.59115 -122.01489 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570911627:655238 655238 655238 2019-10-12 13:20:27-07:00 1531 October 12, 2019 - 19:47:51 UTC     1 0 37.59115 -122.01489 Union City 80 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570912215:655238 655238 655238 2019-10-12 13:30:15-07:00 1532 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570912817:655238 655238 655238 2019-10-12 13:40:17-07:00 1533 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570913412:655238 655238 655238 2019-10-12 13:50:12-07:00 1534 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570914021:655238 655238 655238 2019-10-12 14:00:21-07:00 1535 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570914614:655238 655238 655238 2019-10-12 14:10:14-07:00 1536 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570915215:655238 655238 655238 2019-10-12 14:20:15-07:00 1537 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570915819:655238 655238 655238 2019-10-12 14:30:19-07:00 1538 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570916411:655238 655238 655238 2019-10-12 14:40:11-07:00 1539 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570917024:655238 655238 655238 2019-10-12 14:50:24-07:00 1540 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570917615:655238 655238 655238 2019-10-12 15:00:15-07:00 1541 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570918221:655238 655238 655238 2019-10-12 15:10:21-07:00 1542 October 12, 2019 - 20:21:26 UTC     1 0 37.59115 -122.01489 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4

Next page

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