outage_snapshots
1 row where outage = 707305
This data as json, CSV (advanced)
id ▼ | outage | snapshot | lastUpdateTime | currentEtor | autoEtor | estCustAffected | hazardFlag | latitude | longitude | regionName | cause | crewCurrentStatus |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1573833630:707305 | 707305 707305 | 2019-11-15 08:00:30-08:00 6188 | November 15, 2019 - 15:56:06 UTC | November 15, 2019 - 19:00:00 UTC | November 15, 2019 - 19:00:00 UTC | 1 | 0 | 37.53958 | -122.2802 | San Mateo 29 | 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]);