outage_snapshots

11 rows where outage = 19151542

View and edit SQL

id ▼ outage snapshot cluster currentEtor estCustAffected latitude longitude comments cause crewCurrentStatus source
1575893761:19151542 19151542 19151542 2019-12-09 07:16:01-05:00 126 0   4 38.10356 -85.66749 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/c039885f-3295-419c-96e0-117834f42d04/public/cluster-3/032000312.json
1575894655:19151542 19151542 19151542 2019-12-09 07:30:55-05:00 127 0   4 38.10356 -85.66749 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/c2cde0e6-30f1-4f28-9b0c-de22ed048f8c/public/cluster-3/032000312.json
1575895541:19151542 19151542 19151542 2019-12-09 07:45:41-05:00 128 0   4 38.10356 -85.66749 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/42746a22-63da-472f-8409-3abf8ec95333/public/cluster-3/032000312.json
1575896465:19151542 19151542 19151542 2019-12-09 08:01:05-05:00 129 0   4 38.10356 -85.66749 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/ff04cea7-89f0-4070-b0d2-9e00231e4fb6/public/cluster-3/032000312.json
1575897343:19151542 19151542 19151542 2019-12-09 08:15:43-05:00 130 0   4 38.10356 -85.66749 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/f7f17c92-09dc-4a60-8eb3-6c0a53ac36c8/public/cluster-3/032000312.json
1575898254:19151542 19151542 19151542 2019-12-09 08:30:54-05:00 131 0   4 38.10356 -85.66749 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/356214a1-1ac4-4e82-a292-095406419ee6/public/cluster-3/032000312.json
1575899142:19151542 19151542 19151542 2019-12-09 08:45:42-05:00 132 0   4 38.10356 -85.66749 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/6c514579-d0c9-44a3-b0f2-d20c2bb74fa8/public/cluster-3/032000.json
1575900042:19151542 19151542 19151542 2019-12-09 09:00:42-05:00 133 0   4 38.10356 -85.66749 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/76a22270-55a1-45c7-867d-3658675b3748/public/cluster-3/032000.json
1575900940:19151542 19151542 19151542 2019-12-09 09:15:40-05:00 134 0   4 38.10356 -85.66749 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/a2721703-4411-49a8-83cc-7d452fb6bc99/public/cluster-3/032000.json
1575901844:19151542 19151542 19151542 2019-12-09 09:30:44-05:00 135 0   4 38.10356 -85.66749 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/599ea552-71c0-4cf9-96d8-1837909ae6b3/public/cluster-3/032000.json
1575902750:19151542 19151542 19151542 2019-12-09 09:45:50-05:00 136 0   4 38.10356 -85.66749 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/87488329-fe02-48f2-9052-39594d4e361b/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 2584.254ms