4 rows
where outage = 658394
✎ View and edit SQL
This data as json, CSV (advanced)
Suggested facets: lastUpdateTime, crewCurrentStatus
id ▼
|
outage
|
snapshot
|
lastUpdateTime
|
currentEtor
|
autoEtor
|
estCustAffected
|
hazardFlag
|
latitude
|
longitude
|
regionName
|
cause
|
crewCurrentStatus
|
1571089817:658394 |
658394 658394 |
2019-10-14 14:50:17-07:00 1822 |
October 14, 2019 - 21:45:57 UTC |
October 14, 2019 - 23:30:00 UTC |
October 14, 2019 - 23:30:00 UTC |
1 |
0 |
37.97298 |
-121.7636 |
Antioch 42 |
Unknown - PG&E will be assessing the cause. 1 |
PG&E has assigned a crew to assess the outage. 1 |
1571090429:658394 |
658394 658394 |
2019-10-14 15:00:29-07:00 1823 |
October 14, 2019 - 21:45:57 UTC |
October 14, 2019 - 23:30:00 UTC |
October 14, 2019 - 23:30:00 UTC |
1 |
0 |
37.97298 |
-121.7636 |
Antioch 42 |
Unknown - PG&E will be assessing the cause. 1 |
PG&E has assigned a crew to assess the outage. 1 |
1571091037:658394 |
658394 658394 |
2019-10-14 15:10:37-07:00 1824 |
October 14, 2019 - 22:02:10 UTC |
October 14, 2019 - 23:30:00 UTC |
October 14, 2019 - 23:30:00 UTC |
1 |
0 |
37.97298 |
-121.7636 |
Antioch 42 |
Unknown - PG&E will be assessing the cause. 1 |
PG&E assessment crew is en route to the outage. 5 |
1571091616:658394 |
658394 658394 |
2019-10-14 15:20:16-07:00 1825 |
October 14, 2019 - 22:02:10 UTC |
October 14, 2019 - 23:30:00 UTC |
October 14, 2019 - 23:30:00 UTC |
1 |
0 |
37.97298 |
-121.7636 |
Antioch 42 |
Unknown - PG&E will be assessing the cause. 1 |
PG&E assessment crew is en route to the outage. 5 |
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])
);
CREATE INDEX [idx_outage_snapshots_outage]
ON [outage_snapshots] ([outage]);