outage_snapshots

5 rows where outage = 19151611

View and edit SQL

id ▼ outage snapshot cluster currentEtor estCustAffected latitude longitude comments cause crewCurrentStatus source
1575916261:19151611 19151611 19151611 2019-12-09 13:31:01-05:00 151 0   11 38.16406 -85.76873 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/8b4e5569-c14b-46ce-b12d-1caccf5c687f/public/cluster-3/0320003120.json
1575917165:19151611 19151611 19151611 2019-12-09 13:46:05-05:00 152 0   11 38.16406 -85.76873 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/c4f31fe9-13f3-495d-9d05-f0308839c5a2/public/cluster-3/0320003120.json
1575918059:19151611 19151611 19151611 2019-12-09 14:00:59-05:00 153 0   11 38.16406 -85.76873 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/acc8d0b1-9e05-4700-9713-ff947f53e308/public/cluster-3/0320003120.json
1575918960:19151611 19151611 19151611 2019-12-09 14:16:00-05:00 154 0   11 38.16406 -85.76873 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/9cb28571-cacb-46e5-acc7-3ae2f987cf36/public/cluster-3/0320003120.json
1575919871:19151611 19151611 19151611 2019-12-09 14:31:11-05:00 155 0   11 38.16406 -85.76873 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/68c16ea1-cb4d-401d-b57c-d064891565b3/public/cluster-3/0320003120.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 1573.579ms