5 rows
where outage = 634858
✎ View and edit SQL
This data as json, CSV (advanced)
Suggested facets: lastUpdateTime, cause, crewCurrentStatus
|
id ▼
|
outage
|
snapshot
|
lastUpdateTime
|
currentEtor
|
autoEtor
|
estCustAffected
|
hazardFlag
|
latitude
|
longitude
|
regionName
|
cause
|
crewCurrentStatus
|
| 1569967246:634858 |
634858 634858 |
2019-10-01 15:00:46-07:00 91 |
October 01, 2019 - 21:50:12 UTC |
October 02, 2019 - 01:00:00 UTC |
October 02, 2019 - 01:00:00 UTC |
1 |
1 |
37.88844 |
-122.2615 |
Berkeley 47 |
Unknown - PG&E will be assessing the cause. 1 |
PG&E has assigned a crew to assess the outage. 1 |
| 1569967836:634858 |
634858 634858 |
2019-10-01 15:10:36-07:00 92 |
October 01, 2019 - 21:50:12 UTC |
October 02, 2019 - 01:00:00 UTC |
October 02, 2019 - 01:00:00 UTC |
1 |
1 |
37.88844 |
-122.2615 |
Berkeley 47 |
Unknown - PG&E will be assessing the cause. 1 |
PG&E has assigned a crew to assess the outage. 1 |
| 1569968422:634858 |
634858 634858 |
2019-10-01 15:20:22-07:00 93 |
October 01, 2019 - 22:06:22 UTC |
October 02, 2019 - 01:00:00 UTC |
October 02, 2019 - 01:00:00 UTC |
1 |
1 |
37.88844 |
-122.2615 |
Berkeley 47 |
Unknown - PG&E will be assessing the cause. 1 |
PG&E assessment crew is en route to the outage. 5 |
| 1569969014:634858 |
634858 634858 |
2019-10-01 15:30:14-07:00 94 |
October 01, 2019 - 22:22:48 UTC |
October 02, 2019 - 01:00:00 UTC |
October 02, 2019 - 01:00:00 UTC |
1 |
1 |
37.88844 |
-122.2615 |
Berkeley 47 |
PG&E is investigating the cause of your outage. 6 |
PG&E is assessing the cause at the outage location. 4 |
| 1569969624:634858 |
634858 634858 |
2019-10-01 15:40:24-07:00 95 |
October 01, 2019 - 22:22:48 UTC |
October 02, 2019 - 01:00:00 UTC |
October 02, 2019 - 01:00:00 UTC |
1 |
1 |
37.88844 |
-122.2615 |
Berkeley 47 |
PG&E is investigating the cause of your outage. 6 |
PG&E is assessing the cause at the outage location. 4 |
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]);