outage_snapshots

34 rows where outage = 737091

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1576161019:737091 737091 737091 2019-12-12 06:30:19-08:00 10005 December 12, 2019 - 14:23:04 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 133 0 36.0036 -119.94969 Kettleman City 10 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1576161622:737091 737091 737091 2019-12-12 06:40:22-08:00 10006 December 12, 2019 - 14:33:30 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 133 0 36.0036 -119.94969 Kettleman City 10 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1576162217:737091 737091 737091 2019-12-12 06:50:17-08:00 10007 December 12, 2019 - 14:38:58 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 133 0 36.0036 -119.94969 Kettleman City 10 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1576162822:737091 737091 737091 2019-12-12 07:00:22-08:00 10008 December 12, 2019 - 14:38:58 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 133 0 36.0036 -119.94969 Kettleman City 10 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1576163419:737091 737091 737091 2019-12-12 07:10:19-08:00 10009 December 12, 2019 - 14:38:58 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 133 0 36.0036 -119.94969 Kettleman City 10 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1576164025:737091 737091 737091 2019-12-12 07:20:25-08:00 10010 December 12, 2019 - 15:13:10 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 133 0 36.0036 -119.94969 Kettleman City 10 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1576164621:737091 737091 737091 2019-12-12 07:30:21-08:00 10011 December 12, 2019 - 15:13:10 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 133 0 36.0036 -119.94969 Kettleman City 10 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1576165225:737091 737091 737091 2019-12-12 07:40:25-08:00 10012 December 12, 2019 - 15:34:11 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 133 0 36.0036 -119.94969 Kettleman City 10 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1576165835:737091 737091 737091 2019-12-12 07:50:35-08:00 10013 December 12, 2019 - 15:42:52 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 114 0 36.0036 -119.94969 Kettleman City 10 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is assessing the cause at the outage location. 4
1576166431:737091 737091 737091 2019-12-12 08:00:31-08:00 10014 December 12, 2019 - 15:42:52 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 114 0 36.0036 -119.94969 Kettleman City 10 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is assessing the cause at the outage location. 4
1576167030:737091 737091 737091 2019-12-12 08:10:30-08:00 10015 December 12, 2019 - 16:04:08 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 114 0 36.0036 -119.94969 Kettleman City 10 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is assessing the cause at the outage location. 4
1576167633:737091 737091 737091 2019-12-12 08:20:33-08:00 10016 December 12, 2019 - 16:06:42 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 114 0 36.0036 -119.94969 Kettleman City 10 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is assessing the cause at the outage location. 4
1576168231:737091 737091 737091 2019-12-12 08:30:31-08:00 10017 December 12, 2019 - 16:06:42 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 114 0 36.0036 -119.94969 Kettleman City 10 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is assessing the cause at the outage location. 4
1576168813:737091 737091 737091 2019-12-12 08:40:13-08:00 10018 December 12, 2019 - 16:06:42 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 114 0 36.0036 -119.94969 Kettleman City 10 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is assessing the cause at the outage location. 4
1576169414:737091 737091 737091 2019-12-12 08:50:14-08:00 10019 December 12, 2019 - 16:41:08 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 114 0 36.0036 -119.94969 Kettleman City 10 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is assessing the cause at the outage location. 4
1576170033:737091 737091 737091 2019-12-12 09:00:33-08:00 10020 December 12, 2019 - 16:41:08 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 114 0 36.0036 -119.94969 Kettleman City 10 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is assessing the cause at the outage location. 4
1576170640:737091 737091 737091 2019-12-12 09:10:40-08:00 10021 December 12, 2019 - 17:02:35 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 114 0 36.0036 -119.94969 Kettleman City 10 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
1576171222:737091 737091 737091 2019-12-12 09:20:22-08:00 10022 December 12, 2019 - 17:13:33 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 87 0 36.0036 -119.94969 Kettleman City 10 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
1576171828:737091 737091 737091 2019-12-12 09:30:28-08:00 10023 December 12, 2019 - 17:18:05 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 87 0 36.0036 -119.94969 Kettleman City 10 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
1576172442:737091 737091 737091 2019-12-12 09:40:42-08:00 10024 December 12, 2019 - 17:33:05 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 87 0 36.0036 -119.94969 Kettleman City 10 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
1576173042:737091 737091 737091 2019-12-12 09:50:42-08:00 10025 December 12, 2019 - 17:36:37 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 2 0 36.0036 -119.94969 Kettleman City 10 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
1576173619:737091 737091 737091 2019-12-12 10:00:19-08:00 10026 December 12, 2019 - 17:36:37 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 2 0 36.0036 -119.94969 Kettleman City 10 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
1576174233:737091 737091 737091 2019-12-12 10:10:33-08:00 10027 December 12, 2019 - 17:36:37 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 2 0 36.0036 -119.94969 Kettleman City 10 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
1576174815:737091 737091 737091 2019-12-12 10:20:15-08:00 10028 December 12, 2019 - 17:36:37 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 2 0 36.0036 -119.94969 Kettleman City 10 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
1576175429:737091 737091 737091 2019-12-12 10:30:29-08:00 10029 December 12, 2019 - 18:12:14 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 2 0 36.0036 -119.94969 Kettleman City 10 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
1576176037:737091 737091 737091 2019-12-12 10:40:37-08:00 10030 December 12, 2019 - 18:12:14 UTC December 12, 2019 - 19:15:00 UTC December 12, 2019 - 19:15:00 UTC 2 0 36.0036 -119.94969 Kettleman City 10 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
1576176647:737091 737091 737091 2019-12-12 10:50:47-08:00 10031 December 12, 2019 - 18:41:44 UTC December 12, 2019 - 21:30:00 UTC   2 0 36.0036 -119.94969 Kettleman City 10 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1576177219:737091 737091 737091 2019-12-12 11:00:19-08:00 10032 December 12, 2019 - 18:41:44 UTC December 12, 2019 - 21:30:00 UTC   2 0 36.0036 -119.94969 Kettleman City 10 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1576177825:737091 737091 737091 2019-12-12 11:10:25-08:00 10033 December 12, 2019 - 18:41:44 UTC December 12, 2019 - 21:30:00 UTC   2 0 36.0036 -119.94969 Kettleman City 10 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1576178443:737091 737091 737091 2019-12-12 11:20:43-08:00 10034 December 12, 2019 - 18:41:44 UTC December 12, 2019 - 21:30:00 UTC   2 0 36.0036 -119.94969 Kettleman City 10 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1576179052:737091 737091 737091 2019-12-12 11:30:52-08:00 10035 December 12, 2019 - 18:41:44 UTC December 12, 2019 - 21:30:00 UTC   2 0 36.0036 -119.94969 Kettleman City 10 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1576179632:737091 737091 737091 2019-12-12 11:40:32-08:00 10036 December 12, 2019 - 18:41:44 UTC December 12, 2019 - 21:30:00 UTC   2 0 36.0036 -119.94969 Kettleman City 10 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1576180222:737091 737091 737091 2019-12-12 11:50:22-08:00 10037 December 12, 2019 - 18:41:44 UTC December 12, 2019 - 21:30:00 UTC   2 0 36.0036 -119.94969 Kettleman City 10 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1576180837:737091 737091 737091 2019-12-12 12:00:37-08:00 10038 December 12, 2019 - 18:41:44 UTC December 12, 2019 - 21:30:00 UTC   2 0 36.0036 -119.94969 Kettleman City 10 Our preliminary determination is that your outage was caused by an equipment issue. 2 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 4248.486ms · About: About this site