outage_snapshots

6 rows where outage = 19151545

View and edit SQL

id ▼ outage snapshot cluster currentEtor estCustAffected latitude longitude comments cause crewCurrentStatus source
1575896465:19151545 19151545 19151545 2019-12-09 08:01:05-05:00 129 0   4 36.6749 -88.99636 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Working to determine cause 2   https://kubra.io/data/ff04cea7-89f0-4070-b0d2-9e00231e4fb6/public/cluster-3/032000.json
1575897343:19151545 19151545 19151545 2019-12-09 08:15:43-05:00 130 0   4 36.6749 -88.99636 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Working to determine cause 2   https://kubra.io/data/f7f17c92-09dc-4a60-8eb3-6c0a53ac36c8/public/cluster-3/0320002.json
1575898254:19151545 19151545 19151545 2019-12-09 08:30:54-05:00 131 0   4 36.6749 -88.99636 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Working to determine cause 2   https://kubra.io/data/356214a1-1ac4-4e82-a292-095406419ee6/public/cluster-3/0320002.json
1575899142:19151545 19151545 19151545 2019-12-09 08:45:42-05:00 132 0   4 36.6749 -88.99636 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Working to determine cause 2   https://kubra.io/data/6c514579-d0c9-44a3-b0f2-d20c2bb74fa8/public/cluster-3/032000.json
1575900042:19151545 19151545 19151545 2019-12-09 09:00:42-05:00 133 0   4 36.6749 -88.99636 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Working to determine cause 2   https://kubra.io/data/76a22270-55a1-45c7-867d-3658675b3748/public/cluster-3/032000.json
1575900940:19151545 19151545 19151545 2019-12-09 09:15:40-05:00 134 0   4 36.6749 -88.99636 The previous estimated time of restoration has expired and we are re-evaluating the situation. A revised estimate will be provided as soon as possible. 1 Working to determine cause 2   https://kubra.io/data/a2721703-4411-49a8-83cc-7d452fb6bc99/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 2687.757ms