outage_snapshots

11 rows where outage = 646003

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1570468827:646003 646003 646003 2019-10-07 10:20:27-07:00 909 October 07, 2019 - 17:11:09 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 Riverdale 22 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570469421:646003 646003 646003 2019-10-07 10:30:21-07:00 910 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 Riverdale 22 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570470025:646003 646003 646003 2019-10-07 10:40:25-07:00 911 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 Riverdale 22 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570470636:646003 646003 646003 2019-10-07 10:50:36-07:00 912 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 Riverdale 22 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570471230:646003 646003 646003 2019-10-07 11:00:30-07:00 913 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 Riverdale 22 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570471828:646003 646003 646003 2019-10-07 11:10:28-07:00 914 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 Riverdale 22 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570472424:646003 646003 646003 2019-10-07 11:20:24-07:00 915 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 Riverdale 22 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570473017:646003 646003 646003 2019-10-07 11:30:17-07:00 916 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 Riverdale 22 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570473628:646003 646003 646003 2019-10-07 11:40:28-07:00 917 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 Riverdale 22 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570474238:646003 646003 646003 2019-10-07 11:50:38-07:00 918 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 Riverdale 22 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570474877:646003 646003 646003 2019-10-07 12:01:17-07:00 919 October 07, 2019 - 18:51:43 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 Riverdale 22 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4

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