outage_snapshots
1 row where outage = 633509
This data as json, CSV (advanced)
id ▼ | outage | snapshot | lastUpdateTime | currentEtor | autoEtor | estCustAffected | hazardFlag | latitude | longitude | regionName | cause | crewCurrentStatus |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1569917417:633509 | 633509 633509 | 2019-10-01 01:10:17-07:00 8 | October 01, 2019 - 07:59:38 UTC | October 01, 2019 - 11:15:00 UTC | October 01, 2019 - 11:15:00 UTC | 11 | 0 | 37.95498 | -122.11657 | Martinez 37 | 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]);