outage_snapshots

26 rows where outage = 656177

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1571071828:656177 656177 656177 2019-10-14 09:50:28-07:00 1792 October 14, 2019 - 16:42:44 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571072438:656177 656177 656177 2019-10-14 10:00:38-07:00 1793 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571073025:656177 656177 656177 2019-10-14 10:10:25-07:00 1794 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571073623:656177 656177 656177 2019-10-14 10:20:23-07:00 1795 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571074246:656177 656177 656177 2019-10-14 10:30:46-07:00 1796 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571074823:656177 656177 656177 2019-10-14 10:40:23-07:00 1797 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571075428:656177 656177 656177 2019-10-14 10:50:28-07:00 1798 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571076075:656177 656177 656177 2019-10-14 11:01:15-07:00 1799 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571076621:656177 656177 656177 2019-10-14 11:10:21-07:00 1800 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571077246:656177 656177 656177 2019-10-14 11:20:46-07:00 1801 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571077828:656177 656177 656177 2019-10-14 11:30:28-07:00 1802 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571078429:656177 656177 656177 2019-10-14 11:40:29-07:00 1803 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571079017:656177 656177 656177 2019-10-14 11:50:17-07:00 1804 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571079658:656177 656177 656177 2019-10-14 12:00:58-07:00 1805 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571080236:656177 656177 656177 2019-10-14 12:10:36-07:00 1806 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571080830:656177 656177 656177 2019-10-14 12:20:30-07:00 1807 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571081432:656177 656177 656177 2019-10-14 12:30:32-07:00 1808 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571082027:656177 656177 656177 2019-10-14 12:40:27-07:00 1809 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571082622:656177 656177 656177 2019-10-14 12:50:22-07:00 1810 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571083233:656177 656177 656177 2019-10-14 13:00:33-07:00 1811 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571083825:656177 656177 656177 2019-10-14 13:10:25-07:00 1812 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571084426:656177 656177 656177 2019-10-14 13:20:26-07:00 1813 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571085030:656177 656177 656177 2019-10-14 13:30:30-07:00 1814 October 14, 2019 - 16:47:14 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571085621:656177 656177 656177 2019-10-14 13:40:21-07:00 1815 October 14, 2019 - 20:29:27 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571086219:656177 656177 656177 2019-10-14 13:50:19-07:00 1816 October 14, 2019 - 20:29:27 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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
1571086851:656177 656177 656177 2019-10-14 14:00:51-07:00 1817 October 14, 2019 - 20:29:27 UTC October 14, 2019 - 21:00:00 UTC   25 0 35.15922 -120.67685 Pismo Beach 18 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 5157.561ms · About: About this site