outage_snapshots

4 rows where snapshot = 173

View and edit SQL

id ▼ outage snapshot cluster currentEtor estCustAffected latitude longitude comments cause crewCurrentStatus source
1575936063:19151760 19151760 19151760 2019-12-09 19:01:03-05:00 173 0   4 38.25661 -85.73756 This estimated time of restoration is based on historical averages of the time required to make similar repairs in this area. We will update the estimate as more information becomes available. Please check back for updates. 2 Working to determine cause 2   https://kubra.io/data/f38315cf-57fc-489b-957d-1387ba61d643/public/cluster-3/032000.json
1575936063:19151781 19151781 19151781 2019-12-09 19:01:03-05:00 173 0   4 36.73959 -83.4283 This estimated time of restoration is based on historical averages of the time required to make similar repairs in this area. We will update the estimate as more information becomes available. Please check back for updates. 2 Working to determine cause 2   https://kubra.io/data/f38315cf-57fc-489b-957d-1387ba61d643/public/cluster-3/032001223212.json
1575936063:19151782 19151782 19151782 2019-12-09 19:01:03-05:00 173 0   4 36.73239 -83.4228 This estimated time of restoration is based on historical averages of the time required to make similar repairs in this area. We will update the estimate as more information becomes available. Please check back for updates. 2 Working to determine cause 2   https://kubra.io/data/f38315cf-57fc-489b-957d-1387ba61d643/public/cluster-3/032001223230.json
1575936063:19151783 19151783 19151783 2019-12-09 19:01:03-05:00 173 0   6 37.99556 -84.51184 This estimated time of restoration is based on historical averages of the time required to make similar repairs in this area. We will update the estimate as more information becomes available. Please check back for updates. 2 Working to determine cause 2   https://kubra.io/data/f38315cf-57fc-489b-957d-1387ba61d643/public/cluster-3/032000.json

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [outage_snapshots] (
   [id] TEXT PRIMARY KEY,
   [outage] INTEGER REFERENCES [outages]([id]),
   [snapshot] INTEGER REFERENCES [snapshots]([id]),
   [cluster] INTEGER,
   [currentEtor] INTEGER,
   [estCustAffected] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [comments] INTEGER REFERENCES [comments]([id]),
   [cause] INTEGER REFERENCES [cause]([id]),
   [crewCurrentStatus] INTEGER REFERENCES [crewCurrentStatus]([id]),
   [source] TEXT
);
Powered by Datasette · Query took 1975.808ms