outage_snapshots

43 rows where outage = 691573

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1572282659:691573 691573 691573 2019-10-28 10:10:59-07:00 3709 October 28, 2019 - 16:58:51 UTC     9 0 37.70274 -122.01184 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
1572283222:691573 691573 691573 2019-10-28 10:20:22-07:00 3710 October 28, 2019 - 16:58:51 UTC     9 0 37.70274 -122.01184 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
1572283828:691573 691573 691573 2019-10-28 10:30:28-07:00 3711 October 28, 2019 - 16:58:51 UTC     9 0 37.70274 -122.01184 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
1572285220:691573 691573 691573 2019-10-28 10:53:40-07:00 3712 October 28, 2019 - 16:58:51 UTC     9 0 37.70274 -122.01184 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
1572286448:691573 691573 691573 2019-10-28 11:14:08-07:00 3713 October 28, 2019 - 16:58:51 UTC     9 0 37.70274 -122.01184 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
1572287203:691573 691573 691573 2019-10-28 11:26:43-07:00 3714 October 28, 2019 - 16:58:51 UTC     9 0 37.70274 -122.01184 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
1572287969:691573 691573 691573 2019-10-28 11:39:29-07:00 3715 October 28, 2019 - 18:31:20 UTC     9 0 37.70274 -122.01184 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
1572288755:691573 691573 691573 2019-10-28 11:52:35-07:00 3716 October 28, 2019 - 18:31:20 UTC     9 0 37.70274 -122.01184 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
1572289521:691573 691573 691573 2019-10-28 12:05:21-07:00 3717 October 28, 2019 - 18:31:20 UTC     9 0 37.70274 -122.01184 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
1572290441:691573 691573 691573 2019-10-28 12:20:41-07:00 3718 October 28, 2019 - 18:31:20 UTC     9 0 37.70274 -122.01184 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
1572292044:691573 691573 691573 2019-10-28 12:47:24-07:00 3719 October 28, 2019 - 18:31:20 UTC     9 0 37.70274 -122.01184 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
1572293454:691573 691573 691573 2019-10-28 13:10:54-07:00 3720 October 28, 2019 - 18:31:20 UTC     9 0 37.70274 -122.01184 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
1572295150:691573 691573 691573 2019-10-28 13:39:10-07:00 3721 October 28, 2019 - 18:31:20 UTC     9 0 37.70274 -122.01184 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
1572297013:691573 691573 691573 2019-10-28 14:10:13-07:00 3722 October 28, 2019 - 18:31:20 UTC     9 0 37.70274 -122.01184 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
1572297657:691573 691573 691573 2019-10-28 14:20:57-07:00 3723 October 28, 2019 - 18:31:20 UTC     9 0 37.70274 -122.01184 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
1572298052:691573 691573 691573 2019-10-28 14:27:32-07:00 3724 October 28, 2019 - 18:31:20 UTC     9 0 37.70274 -122.01184 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
1572299595:691573 691573 691573 2019-10-28 14:53:15-07:00 3725 October 28, 2019 - 18:31:20 UTC     9 0 37.70274 -122.01184 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
1572301123:691573 691573 691573 2019-10-28 15:18:43-07:00 3726 October 28, 2019 - 18:31:20 UTC     9 0 37.70274 -122.01184 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
1572301600:691573 691573 691573 2019-10-28 15:26:40-07:00 3727 October 28, 2019 - 18:31:20 UTC     9 0 37.70274 -122.01184 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
1572302743:691573 691573 691573 2019-10-28 15:45:43-07:00 3728 October 28, 2019 - 18:31:20 UTC     9 0 37.70274 -122.01184 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
1572303277:691573 691573 691573 2019-10-28 15:54:37-07:00 3729 October 28, 2019 - 18:31:20 UTC     9 0 37.70274 -122.01184 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
1572303743:691573 691573 691573 2019-10-28 16:02:23-07:00 3730 October 28, 2019 - 18:31:20 UTC     9 0 37.70274 -122.01184 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
1572304221:691573 691573 691573 2019-10-28 16:10:21-07:00 3731 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572304819:691573 691573 691573 2019-10-28 16:20:19-07:00 3732 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572305449:691573 691573 691573 2019-10-28 16:30:49-07:00 3733 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572306030:691573 691573 691573 2019-10-28 16:40:30-07:00 3734 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572306622:691573 691573 691573 2019-10-28 16:50:22-07:00 3735 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572307313:691573 691573 691573 2019-10-28 17:01:53-07:00 3736 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572307834:691573 691573 691573 2019-10-28 17:10:34-07:00 3737 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572308452:691573 691573 691573 2019-10-28 17:20:52-07:00 3738 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572309042:691573 691573 691573 2019-10-28 17:30:42-07:00 3739 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572309628:691573 691573 691573 2019-10-28 17:40:28-07:00 3740 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572310233:691573 691573 691573 2019-10-28 17:50:33-07:00 3741 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572310826:691573 691573 691573 2019-10-28 18:00:26-07:00 3742 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572311437:691573 691573 691573 2019-10-28 18:10:37-07:00 3743 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572312016:691573 691573 691573 2019-10-28 18:20:16-07:00 3744 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572312628:691573 691573 691573 2019-10-28 18:30:28-07:00 3745 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572313215:691573 691573 691573 2019-10-28 18:40:15-07:00 3746 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572313819:691573 691573 691573 2019-10-28 18:50:19-07:00 3747 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572314433:691573 691573 691573 2019-10-28 19:00:33-07:00 3748 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572315018:691573 691573 691573 2019-10-28 19:10:18-07:00 3749 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572315620:691573 691573 691573 2019-10-28 19:20:20-07:00 3750 October 28, 2019 - 23:03:42 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7
1572316818:691573 691573 691573 2019-10-28 19:40:18-07:00 3751 October 29, 2019 - 02:34:58 UTC     9 0 37.70274 -122.01184 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 repair crew is en route to the outage location. 7

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