outage_snapshots

15 rows where outage = 643935

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1570285220:643935 643935 643935 2019-10-05 07:20:20-07:00 606 October 05, 2019 - 14:12:46 UTC October 05, 2019 - 17:15:00 UTC October 05, 2019 - 17:15:00 UTC 1 0 35.36497 -119.00419 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570285816:643935 643935 643935 2019-10-05 07:30:16-07:00 607 October 05, 2019 - 14:12:46 UTC October 05, 2019 - 17:15:00 UTC October 05, 2019 - 17:15:00 UTC 1 0 35.36497 -119.00419 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570286417:643935 643935 643935 2019-10-05 07:40:17-07:00 608 October 05, 2019 - 14:12:46 UTC October 05, 2019 - 17:15:00 UTC October 05, 2019 - 17:15:00 UTC 1 0 35.36497 -119.00419 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570287016:643935 643935 643935 2019-10-05 07:50:16-07:00 609 October 05, 2019 - 14:12:46 UTC October 05, 2019 - 17:15:00 UTC October 05, 2019 - 17:15:00 UTC 1 0 35.36497 -119.00419 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570287622:643935 643935 643935 2019-10-05 08:00:22-07:00 610 October 05, 2019 - 14:12:46 UTC October 05, 2019 - 17:15:00 UTC October 05, 2019 - 17:15:00 UTC 1 0 35.36497 -119.00419 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570288228:643935 643935 643935 2019-10-05 08:10:28-07:00 611 October 05, 2019 - 14:12:46 UTC October 05, 2019 - 17:15:00 UTC October 05, 2019 - 17:15:00 UTC 1 0 35.36497 -119.00419 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570288816:643935 643935 643935 2019-10-05 08:20:16-07:00 612 October 05, 2019 - 14:12:46 UTC October 05, 2019 - 17:15:00 UTC October 05, 2019 - 17:15:00 UTC 1 0 35.36497 -119.00419 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570289416:643935 643935 643935 2019-10-05 08:30:16-07:00 613 October 05, 2019 - 14:12:46 UTC October 05, 2019 - 17:15:00 UTC October 05, 2019 - 17:15:00 UTC 1 0 35.36497 -119.00419 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570290020:643935 643935 643935 2019-10-05 08:40:20-07:00 614 October 05, 2019 - 14:12:46 UTC October 05, 2019 - 17:15:00 UTC October 05, 2019 - 17:15:00 UTC 1 0 35.36497 -119.00419 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570290627:643935 643935 643935 2019-10-05 08:50:27-07:00 615 October 05, 2019 - 14:12:46 UTC October 05, 2019 - 17:15:00 UTC October 05, 2019 - 17:15:00 UTC 1 0 35.36497 -119.00419 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570291231:643935 643935 643935 2019-10-05 09:00:31-07:00 616 October 05, 2019 - 14:12:46 UTC October 05, 2019 - 17:15:00 UTC October 05, 2019 - 17:15:00 UTC 1 0 35.36497 -119.00419 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570291811:643935 643935 643935 2019-10-05 09:10:11-07:00 617 October 05, 2019 - 14:12:46 UTC October 05, 2019 - 17:15:00 UTC October 05, 2019 - 17:15:00 UTC 1 0 35.36497 -119.00419 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570292418:643935 643935 643935 2019-10-05 09:20:18-07:00 618 October 05, 2019 - 14:12:46 UTC October 05, 2019 - 17:15:00 UTC October 05, 2019 - 17:15:00 UTC 1 0 35.36497 -119.00419 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570293014:643935 643935 643935 2019-10-05 09:30:14-07:00 619 October 05, 2019 - 14:12:46 UTC October 05, 2019 - 17:15:00 UTC October 05, 2019 - 17:15:00 UTC 1 0 35.36497 -119.00419 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570293612:643935 643935 643935 2019-10-05 09:40:12-07:00 620 October 05, 2019 - 14:12:46 UTC October 05, 2019 - 17:15:00 UTC October 05, 2019 - 17:15:00 UTC 1 0 35.36497 -119.00419 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 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 5376.39ms · About: About this site