outage_snapshots

8 rows where outage = 642134 sorted by currentEtor

View and edit SQL

id outage snapshot lastUpdateTime currentEtor ▼ autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1570152018:642134 642134 642134 2019-10-03 18:20:18-07:00 389 October 04, 2019 - 01:07:32 UTC October 04, 2019 - 03:30:00 UTC October 04, 2019 - 03:30:00 UTC 1 1 37.55448 -122.32151 San Mateo 29 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570152613:642134 642134 642134 2019-10-03 18:30:13-07:00 390 October 04, 2019 - 01:07:32 UTC October 04, 2019 - 03:30:00 UTC October 04, 2019 - 03:30:00 UTC 1 1 37.55448 -122.32151 San Mateo 29 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570153220:642134 642134 642134 2019-10-03 18:40:20-07:00 391 October 04, 2019 - 01:30:36 UTC October 04, 2019 - 03:30:00 UTC October 04, 2019 - 03:30:00 UTC 1 1 37.55448 -122.32151 San Mateo 29 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570153814:642134 642134 642134 2019-10-03 18:50:14-07:00 392 October 04, 2019 - 01:30:36 UTC October 04, 2019 - 03:30:00 UTC October 04, 2019 - 03:30:00 UTC 1 1 37.55448 -122.32151 San Mateo 29 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570154423:642134 642134 642134 2019-10-03 19:00:23-07:00 393 October 04, 2019 - 01:52:40 UTC October 04, 2019 - 03:30:00 UTC October 04, 2019 - 03:30:00 UTC 1 1 37.55448 -122.32151 San Mateo 29 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570155023:642134 642134 642134 2019-10-03 19:10:23-07:00 394 October 04, 2019 - 01:52:40 UTC October 04, 2019 - 03:30:00 UTC October 04, 2019 - 03:30:00 UTC 1 1 37.55448 -122.32151 San Mateo 29 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570155620:642134 642134 642134 2019-10-03 19:20:20-07:00 395 October 04, 2019 - 01:52:40 UTC October 04, 2019 - 03:30:00 UTC October 04, 2019 - 03:30:00 UTC 1 1 37.55448 -122.32151 San Mateo 29 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570156220:642134 642134 642134 2019-10-03 19:30:20-07:00 396 October 04, 2019 - 01:52:40 UTC October 04, 2019 - 03:30:00 UTC October 04, 2019 - 03:30:00 UTC 1 1 37.55448 -122.32151 San Mateo 29 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 6977.784ms · About: About this site