outage_snapshots
2 rows where outage = 785601
This data as json, CSV (advanced)
id ▼ | outage | snapshot | lastUpdateTime | currentEtor | autoEtor | estCustAffected | hazardFlag | latitude | longitude | regionName | cause | crewCurrentStatus |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1581295224:785601 | 785601 785601 | 2020-02-09 16:40:24-08:00 11523 | February 10, 2020 - 00:33:28 UTC | 1 | 1 | 37.67943 | -121.2745 | Tracy 38 | Unknown - PG&E will be assessing the cause. 1 | PG&E has assigned a crew to assess the outage. 1 | ||
1581295818:785601 | 785601 785601 | 2020-02-09 16:50:18-08:00 11524 | February 10, 2020 - 00:33:28 UTC | 1 | 1 | 37.67943 | -121.2745 | Tracy 38 | Unknown - PG&E will be assessing the cause. 1 | PG&E has assigned a crew to assess the outage. 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);