outage_snapshots

27 rows where outage = 644038

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1570291231:644038 644038 644038 2019-10-05 09:00:31-07:00 616 October 05, 2019 - 15:54:23 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570291811:644038 644038 644038 2019-10-05 09:10:11-07:00 617 October 05, 2019 - 15:58:42 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570292418:644038 644038 644038 2019-10-05 09:20:18-07:00 618 October 05, 2019 - 15:58:42 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570293014:644038 644038 644038 2019-10-05 09:30:14-07:00 619 October 05, 2019 - 15:58:42 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570293612:644038 644038 644038 2019-10-05 09:40:12-07:00 620 October 05, 2019 - 15:58:42 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570294214:644038 644038 644038 2019-10-05 09:50:14-07:00 621 October 05, 2019 - 15:58:42 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570294818:644038 644038 644038 2019-10-05 10:00:18-07:00 622 October 05, 2019 - 15:58:42 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570295418:644038 644038 644038 2019-10-05 10:10:18-07:00 623 October 05, 2019 - 15:58:42 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570296016:644038 644038 644038 2019-10-05 10:20:16-07:00 624 October 05, 2019 - 15:58:42 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570296630:644038 644038 644038 2019-10-05 10:30:30-07:00 625 October 05, 2019 - 15:58:42 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570297216:644038 644038 644038 2019-10-05 10:40:16-07:00 626 October 05, 2019 - 15:58:42 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570297829:644038 644038 644038 2019-10-05 10:50:29-07:00 627 October 05, 2019 - 15:58:42 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570298455:644038 644038 644038 2019-10-05 11:00:55-07:00 628 October 05, 2019 - 17:55:48 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570299024:644038 644038 644038 2019-10-05 11:10:24-07:00 629 October 05, 2019 - 17:55:48 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570299611:644038 644038 644038 2019-10-05 11:20:11-07:00 630 October 05, 2019 - 17:55:48 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570300216:644038 644038 644038 2019-10-05 11:30:16-07:00 631 October 05, 2019 - 17:55:48 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570300831:644038 644038 644038 2019-10-05 11:40:31-07:00 632 October 05, 2019 - 17:55:48 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570301426:644038 644038 644038 2019-10-05 11:50:26-07:00 633 October 05, 2019 - 17:55:48 UTC October 05, 2019 - 18:00:00 UTC October 05, 2019 - 18:00:00 UTC 4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570302019:644038 644038 644038 2019-10-05 12:00:19-07:00 634 October 05, 2019 - 18:47:52 UTC October 05, 2019 - 22:00:00 UTC   4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570302616:644038 644038 644038 2019-10-05 12:10:16-07:00 635 October 05, 2019 - 18:47:52 UTC October 05, 2019 - 22:00:00 UTC   4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570303211:644038 644038 644038 2019-10-05 12:20:11-07:00 636 October 05, 2019 - 18:47:52 UTC October 05, 2019 - 22:00:00 UTC   4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570303816:644038 644038 644038 2019-10-05 12:30:16-07:00 637 October 05, 2019 - 18:47:52 UTC October 05, 2019 - 22:00:00 UTC   4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570304416:644038 644038 644038 2019-10-05 12:40:16-07:00 638 October 05, 2019 - 18:47:52 UTC October 05, 2019 - 22:00:00 UTC   4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570305028:644038 644038 644038 2019-10-05 12:50:28-07:00 639 October 05, 2019 - 18:47:52 UTC October 05, 2019 - 22:00:00 UTC   4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570305623:644038 644038 644038 2019-10-05 13:00:23-07:00 640 October 05, 2019 - 18:47:52 UTC October 05, 2019 - 22:00:00 UTC   4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570306224:644038 644038 644038 2019-10-05 13:10:24-07:00 641 October 05, 2019 - 18:47:52 UTC October 05, 2019 - 22:00:00 UTC   4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570306827:644038 644038 644038 2019-10-05 13:20:27-07:00 642 October 05, 2019 - 20:06:55 UTC October 05, 2019 - 22:00:00 UTC   4 0 36.78549 -119.77539 Fresno 35 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3

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