outage_snapshots

6 rows where outage = 19151457

View and edit SQL

id ▼ outage snapshot cluster currentEtor estCustAffected latitude longitude comments cause crewCurrentStatus source
1575826224:19151457 19151457 19151457 2019-12-08 12:30:24-05:00 69 0   4 38.14774 -85.73639 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Scheduled maintenance 1   https://kubra.io/data/1ac9bfdf-6160-475d-957d-a34b301c964c/public/cluster-3/03200031200232.json
1575827155:19151457 19151457 19151457 2019-12-08 12:45:55-05:00 70 0   4 38.14774 -85.73639 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Scheduled maintenance 1   https://kubra.io/data/c924c3da-204e-4c55-bcf4-03b2e6d51289/public/cluster-3/03200031200232.json
1575828063:19151457 19151457 19151457 2019-12-08 13:01:03-05:00 71 0   4 38.14774 -85.73639 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Scheduled maintenance 1   https://kubra.io/data/7b22ac44-ad4d-4070-894f-6b1973c9c51b/public/cluster-3/03200031200232.json
1575828955:19151457 19151457 19151457 2019-12-08 13:15:55-05:00 72 0   4 38.14774 -85.73639 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Scheduled maintenance 1   https://kubra.io/data/cda601ae-c464-4276-a6d3-1b643cbd52a0/public/cluster-3/03200031200232.json
1575829841:19151457 19151457 19151457 2019-12-08 13:30:41-05:00 73 0   4 38.14774 -85.73639 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Scheduled maintenance 1   https://kubra.io/data/a9b5441d-a357-4526-9683-9bdd7605de68/public/cluster-3/03200031200232.json
1575830735:19151457 19151457 19151457 2019-12-08 13:45:35-05:00 74 0   4 38.14774 -85.73639 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Scheduled maintenance 1   https://kubra.io/data/ef53c8e8-dd8b-4f6d-a301-d566b8a29916/public/cluster-3/03200031.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 1994.031ms