16 rows

View and edit SQL

id latitude longitude outage estCustAffected cluster cause crewCurrentStatus comments outage_url currentEtor
1637690762:cgkeFpmqaO-2021-11-23T15:04:47Z 37.74594 -84.30825 cgkeFpmqaO-2021-11-23T15:04:47Z 4 1       https://lgeku-outages.herokuapp.com/outages/outages/cgkeFpmqaO-2021-11-23T15:04:47Z  
1637690762:21122844 37.6155 -87.52753 21122844 4 0 Working to determine cause   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. https://lgeku-outages.herokuapp.com/outages/outages/21122844  
1637690762:21122834 38.10863 -85.82045 21122834 4 0 Scheduled maintenance   The above estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/21122834  
1637690762:21122836 38.14011 -85.62265 21122836 4 0 Working to determine cause   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. https://lgeku-outages.herokuapp.com/outages/outages/21122836  
1637690762:21122842 37.85748 -84.66659 21122842 4 0 Scheduled maintenance   The above estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/21122842  
1637690762:21122821 38.10104 -84.78073 21122821 4 0 Working to determine cause   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. https://lgeku-outages.herokuapp.com/outages/outages/21122821  
1637690762:21122761 38.07412 -84.52471 21122761 10 0 Scheduled maintenance   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. https://lgeku-outages.herokuapp.com/outages/outages/21122761  
1637690762:21122759 38.0305 -84.44978 21122759 4 0 Scheduled maintenance   The above estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/21122759  
1637690762:21122843 38.32663 -85.4251 21122843 4 0 Scheduled maintenance   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. https://lgeku-outages.herokuapp.com/outages/outages/21122843  
1637690762:21122856 38.34698 -85.36806 21122856 4 0 Working to determine cause   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. https://lgeku-outages.herokuapp.com/outages/outages/21122856  
1637690762:21122811 38.27397 -85.61402 21122811 4 0 Working to determine cause   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. https://lgeku-outages.herokuapp.com/outages/outages/21122811  
1637690762:21122791 38.24034 -85.7667 21122791 4 0 Motor vehicle accident   The above estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/21122791  
1637690762:21122820 38.1985 -85.71075 21122820 18 0 Damaged equipment   The above estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/21122820  
1637690762:21122776 38.19505 -85.83198 21122776 4 0 Damaged equipment   The above estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/21122776  
1637690762:21122829 38.18342 -85.80323 21122829 4 0 Working to determine cause   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. https://lgeku-outages.herokuapp.com/outages/outages/21122829  
1637690762:21122857 36.89936 -82.30101 21122857 4 0 Working to determine cause   We are aware of outages in this area and will provide an estimated time of restoration as soon as possible. https://lgeku-outages.herokuapp.com/outages/outages/21122857  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW most_recent_snapshot as
select
    outage_snapshots.id, latitude, longitude, outage, estCustAffected, cluster,
    cause.name as cause, crewCurrentStatus.name as crewCurrentStatus, comments.name as comments,
    'https://lgeku-outages.herokuapp.com/outages/outages/' || outage as outage_url, currentEtor
from outage_snapshots
    left join cause on outage_snapshots.cause = cause.id
    left join comments on outage_snapshots.comments = comments.id
    left join crewCurrentStatus on outage_snapshots.crewCurrentStatus = crewCurrentStatus.id
where
    snapshot in (select id from snapshots order by id desc limit 1);