outage_snapshots

22 rows where outage = 671193 sorted by lastUpdateTime

View and edit SQL

id outage snapshot lastUpdateTime ▼ currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1571499026:671193 671193 671193 2019-10-19 08:30:26-07:00 2484 October 19, 2019 - 15:19:37 UTC October 19, 2019 - 17:45:00 UTC October 19, 2019 - 17:45:00 UTC 5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571499614:671193 671193 671193 2019-10-19 08:40:14-07:00 2485 October 19, 2019 - 15:19:37 UTC October 19, 2019 - 17:45:00 UTC October 19, 2019 - 17:45:00 UTC 5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571500233:671193 671193 671193 2019-10-19 08:50:33-07:00 2486 October 19, 2019 - 15:19:37 UTC October 19, 2019 - 17:45:00 UTC October 19, 2019 - 17:45:00 UTC 5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571500835:671193 671193 671193 2019-10-19 09:00:35-07:00 2487 October 19, 2019 - 15:19:37 UTC October 19, 2019 - 17:45:00 UTC October 19, 2019 - 17:45:00 UTC 5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571501412:671193 671193 671193 2019-10-19 09:10:12-07:00 2488 October 19, 2019 - 15:19:37 UTC October 19, 2019 - 17:45:00 UTC October 19, 2019 - 17:45:00 UTC 5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571502026:671193 671193 671193 2019-10-19 09:20:26-07:00 2489 October 19, 2019 - 15:19:37 UTC October 19, 2019 - 17:45:00 UTC October 19, 2019 - 17:45:00 UTC 5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571502623:671193 671193 671193 2019-10-19 09:30:23-07:00 2490 October 19, 2019 - 15:19:37 UTC October 19, 2019 - 17:45:00 UTC October 19, 2019 - 17:45:00 UTC 5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571503225:671193 671193 671193 2019-10-19 09:40:25-07:00 2491 October 19, 2019 - 15:19:37 UTC October 19, 2019 - 17:45:00 UTC October 19, 2019 - 17:45:00 UTC 5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571503811:671193 671193 671193 2019-10-19 09:50:11-07:00 2492 October 19, 2019 - 15:19:37 UTC October 19, 2019 - 17:45:00 UTC October 19, 2019 - 17:45:00 UTC 5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571504433:671193 671193 671193 2019-10-19 10:00:33-07:00 2493 October 19, 2019 - 15:19:37 UTC October 19, 2019 - 17:45:00 UTC October 19, 2019 - 17:45:00 UTC 5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571505021:671193 671193 671193 2019-10-19 10:10:21-07:00 2494 October 19, 2019 - 15:19:37 UTC October 19, 2019 - 17:45:00 UTC October 19, 2019 - 17:45:00 UTC 5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571505622:671193 671193 671193 2019-10-19 10:20:22-07:00 2495 October 19, 2019 - 15:19:37 UTC October 19, 2019 - 17:45:00 UTC October 19, 2019 - 17:45:00 UTC 5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571506226:671193 671193 671193 2019-10-19 10:30:26-07:00 2496 October 19, 2019 - 17:22:06 UTC October 19, 2019 - 23:00:00 UTC   5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571506817:671193 671193 671193 2019-10-19 10:40:17-07:00 2497 October 19, 2019 - 17:22:06 UTC October 19, 2019 - 23:00:00 UTC   5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571507414:671193 671193 671193 2019-10-19 10:50:14-07:00 2498 October 19, 2019 - 17:22:06 UTC October 19, 2019 - 23:00:00 UTC   5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571508013:671193 671193 671193 2019-10-19 11:00:13-07:00 2499 October 19, 2019 - 17:22:06 UTC October 19, 2019 - 23:00:00 UTC   5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571508627:671193 671193 671193 2019-10-19 11:10:27-07:00 2500 October 19, 2019 - 17:22:06 UTC October 19, 2019 - 23:00:00 UTC   5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571509220:671193 671193 671193 2019-10-19 11:20:20-07:00 2501 October 19, 2019 - 17:22:06 UTC October 19, 2019 - 23:00:00 UTC   5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571509829:671193 671193 671193 2019-10-19 11:30:29-07:00 2502 October 19, 2019 - 17:22:06 UTC October 19, 2019 - 23:00:00 UTC   5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571510410:671193 671193 671193 2019-10-19 11:40:10-07:00 2503 October 19, 2019 - 17:22:06 UTC October 19, 2019 - 23:00:00 UTC   5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571511012:671193 671193 671193 2019-10-19 11:50:12-07:00 2504 October 19, 2019 - 17:22:06 UTC October 19, 2019 - 23:00:00 UTC   5 0 37.71258 -122.12155 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1571511626:671193 671193 671193 2019-10-19 12:00:26-07:00 2505 October 19, 2019 - 18:44:19 UTC October 19, 2019 - 23:00:00 UTC   5 0 37.71258 -122.12155 Castro Valley 4 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 3814.085ms · About: About this site