outage_snapshots

34 rows where outage = 19151497

View and edit SQL

id ▼ outage snapshot cluster currentEtor estCustAffected latitude longitude comments cause crewCurrentStatus source
1575838844:19151497 19151497 19151497 2019-12-08 16:00:44-05:00 83 0   4 38.38191 -84.30808 We are aware of outages in this area and will provide an estimated time of restoration as soon as possible. 4 Working to determine cause 2   https://kubra.io/data/580415ff-739a-4300-b551-51cd951dea14/public/cluster-3/0320012002201.json
1575839731:19151497 19151497 19151497 2019-12-08 16:15:31-05:00 84 0   4 38.38191 -84.30808 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 Damaged equipment 3   https://kubra.io/data/18cdc5c0-b506-44cc-b9aa-32a52d527bab/public/cluster-3/032001.json
1575840630:19151497 19151497 19151497 2019-12-08 16:30:30-05:00 85 0   4 38.38191 -84.30808 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 Damaged equipment 3   https://kubra.io/data/562bd76b-5be5-444f-b7da-345105d756f5/public/cluster-3/032001.json
1575841533:19151497 19151497 19151497 2019-12-08 16:45:33-05:00 86 0   4 38.38191 -84.30808 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 Damaged equipment 3   https://kubra.io/data/ab64cd58-db75-4ab6-80cf-24cb517f4f2c/public/cluster-3/032001.json
1575842431:19151497 19151497 19151497 2019-12-08 17:00:31-05:00 87 0   4 38.38191 -84.30808 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 Damaged equipment 3   https://kubra.io/data/e133c628-0696-402d-8d1e-2db60a1fd1d9/public/cluster-3/032001.json
1575843326:19151497 19151497 19151497 2019-12-08 17:15:26-05:00 88 0   4 38.38191 -84.30808 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 Damaged equipment 3   https://kubra.io/data/4a228fc7-da4d-4f35-82fe-f86c3831d45f/public/cluster-3/032001.json
1575844227:19151497 19151497 19151497 2019-12-08 17:30:27-05:00 89 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/7069bbc3-cf9b-4d6a-83fa-5dcda8d246cd/public/cluster-3/032001.json
1575845131:19151497 19151497 19151497 2019-12-08 17:45:31-05:00 90 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/5d6c9e00-6508-439d-aca1-5be7502bcb76/public/cluster-3/032001.json
1575846041:19151497 19151497 19151497 2019-12-08 18:00:41-05:00 91 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/bd4834f3-71b5-4e5c-b013-0160a66e7dc7/public/cluster-3/032001.json
1575846927:19151497 19151497 19151497 2019-12-08 18:15:27-05:00 92 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/384fe41a-e086-4408-8d5a-6a944f45fb48/public/cluster-3/032001.json
1575847833:19151497 19151497 19151497 2019-12-08 18:30:33-05:00 93 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/0e9aa1d4-59a9-4110-a015-a6fe1878a7af/public/cluster-3/032001.json
1575848736:19151497 19151497 19151497 2019-12-08 18:45:36-05:00 94 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/3c416911-0c08-493b-825a-421c5174390a/public/cluster-3/032001.json
1575849734:19151497 19151497 19151497 2019-12-08 19:02:14-05:00 95 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/67b05aaf-d15d-4f5a-bdf1-703f16902766/public/cluster-3/032001.json
1575850531:19151497 19151497 19151497 2019-12-08 19:15:31-05:00 96 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/b7328836-8666-49b6-b4ab-491297971dec/public/cluster-3/032001.json
1575851443:19151497 19151497 19151497 2019-12-08 19:30:43-05:00 97 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/7989180c-1789-4011-bec2-16a0de2a33dd/public/cluster-3/032001.json
1575852331:19151497 19151497 19151497 2019-12-08 19:45:31-05:00 98 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/ef9910d2-4af9-496f-9ab3-13bee933e1c0/public/cluster-3/032001.json
1575853243:19151497 19151497 19151497 2019-12-08 20:00:43-05:00 99 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/22f61724-f5f8-46ad-9dbf-18ea7a99fe9e/public/cluster-3/032001.json
1575854153:19151497 19151497 19151497 2019-12-08 20:15:53-05:00 100 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/2d83ce41-4839-46f9-a54a-328d16e27cd6/public/cluster-3/032001.json
1575855040:19151497 19151497 19151497 2019-12-08 20:30:40-05:00 101 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/d8036e09-eeda-417c-843f-35c61c717d27/public/cluster-3/032001.json
1575855939:19151497 19151497 19151497 2019-12-08 20:45:39-05:00 102 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/7e5cbb8e-9e98-4a86-a048-beaf487fbc41/public/cluster-3/032001.json
1575856846:19151497 19151497 19151497 2019-12-08 21:00:46-05:00 103 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/e8396731-80c5-4814-a22f-3ac141cc68b6/public/cluster-3/032001.json
1575857748:19151497 19151497 19151497 2019-12-08 21:15:48-05:00 104 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/6be8bfc2-d573-463d-bd12-d892fc826216/public/cluster-3/032001.json
1575858634:19151497 19151497 19151497 2019-12-08 21:30:34-05:00 105 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/f167bdac-8f4d-43bf-be42-46b7e76a962f/public/cluster-3/032001.json
1575859539:19151497 19151497 19151497 2019-12-08 21:45:39-05:00 106 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/84108b2f-b783-4037-ad82-7a9afd6da7f3/public/cluster-3/032001.json
1575860461:19151497 19151497 19151497 2019-12-08 22:01:01-05:00 107 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/ff6a62de-9ca3-41e5-87b4-1d4700608097/public/cluster-3/032001.json
1575861343:19151497 19151497 19151497 2019-12-08 22:15:43-05:00 108 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/b1de0aa5-17b4-457a-b766-ed3cdebeecca/public/cluster-3/032001.json
1575862241:19151497 19151497 19151497 2019-12-08 22:30:41-05:00 109 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/bf49ce07-9722-40ef-a86c-d8799a537dc3/public/cluster-3/032001.json
1575863145:19151497 19151497 19151497 2019-12-08 22:45:45-05:00 110 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/aa904d3a-b03c-49f4-924a-f3718c7e9923/public/cluster-3/032001.json
1575864039:19151497 19151497 19151497 2019-12-08 23:00:39-05:00 111 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/12f3c7bf-db63-44a7-a685-1bd3061c1a03/public/cluster-3/032001.json
1575864951:19151497 19151497 19151497 2019-12-08 23:15:51-05:00 112 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/0de728d7-e980-4307-aba8-ea65c821bf21/public/cluster-3/032001.json
1575865844:19151497 19151497 19151497 2019-12-08 23:30:44-05:00 113 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/0adda273-fa72-4c1a-8746-520bfc1547fc/public/cluster-3/032001.json
1575866738:19151497 19151497 19151497 2019-12-08 23:45:38-05:00 114 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/9cd6f255-f357-4e7b-a2d6-aba13528e362/public/cluster-3/032001.json
1575867646:19151497 19151497 19151497 2019-12-09 00:00:46-05:00 115 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/64b801d8-c0fe-4d1a-b2ac-46c6bf695ecc/public/cluster-3/032001.json
1575868537:19151497 19151497 19151497 2019-12-09 00:15:37-05:00 116 0   4 38.38191 -84.30808 The above estimated time of restoration is based on an evaluation of the situation by our technicians. 3 Damaged equipment 3   https://kubra.io/data/85f40f13-d687-4dc3-976e-5dc236b6460b/public/cluster-3/032001.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 1934.333ms