outage_snapshots

9 rows where outage = 642634 sorted by hazardFlag

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag ▼ latitude longitude regionName cause crewCurrentStatus
1570204853:642634 642634 642634 2019-10-04 09:00:53-07:00 472 October 04, 2019 - 15:55:59 UTC October 04, 2019 - 19:00:00 UTC October 04, 2019 - 19:00:00 UTC 53 0 35.29824 -119.00741 Bakersfield 2 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E is sending a repair crew to the outage location. 3
1570205420:642634 642634 642634 2019-10-04 09:10:20-07:00 473 October 04, 2019 - 15:56:41 UTC October 04, 2019 - 22:00:00 UTC   53 0 35.29824 -119.00741 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
1570206026:642634 642634 642634 2019-10-04 09:20:26-07:00 474 October 04, 2019 - 15:56:41 UTC October 04, 2019 - 22:00:00 UTC   53 0 35.29824 -119.00741 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
1570206627:642634 642634 642634 2019-10-04 09:30:27-07:00 475 October 04, 2019 - 15:56:41 UTC October 04, 2019 - 22:00:00 UTC   53 0 35.29824 -119.00741 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
1570207232:642634 642634 642634 2019-10-04 09:40:32-07:00 476 October 04, 2019 - 15:56:41 UTC October 04, 2019 - 22:00:00 UTC   53 0 35.29824 -119.00741 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
1570207812:642634 642634 642634 2019-10-04 09:50:12-07:00 477 October 04, 2019 - 15:56:41 UTC October 04, 2019 - 22:00:00 UTC   53 0 35.29824 -119.00741 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
1570208451:642634 642634 642634 2019-10-04 10:00:51-07:00 478 October 04, 2019 - 15:56:41 UTC October 04, 2019 - 22:00:00 UTC   53 0 35.29824 -119.00741 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
1570209023:642634 642634 642634 2019-10-04 10:10:23-07:00 479 October 04, 2019 - 15:56:41 UTC October 04, 2019 - 22:00:00 UTC   53 0 35.29824 -119.00741 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
1570209627:642634 642634 642634 2019-10-04 10:20:27-07:00 480 October 04, 2019 - 17:15:51 UTC October 04, 2019 - 22:00:00 UTC   53 0 35.29824 -119.00741 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 7912.148ms · About: About this site