11 rows

View and edit SQL

id latitude longitude outage estCustAffected cluster cause crewCurrentStatus comments outage_url currentEtor
1616451074:21029421 36.85972 -82.7065 21029421 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/21029421  
1616451074:21029660 36.85992 -82.7068 21029660 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/21029660  
1616451074:21029662 36.86093 -83.20661 21029662 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/21029662  
1616451074:21029617 36.59968 -83.62284 21029617 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/21029617  
1616451074:21029627 36.7125 -84.48254 21029627 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/21029627  
1616451074:21029397 37.95037 -86.12923 21029397 5 0 Working to determine cause   The above estimated time of restoration is based on an evaluation of the situation by our technicians. https://lgeku-outages.herokuapp.com/outages/outages/21029397  
1616451074:21029424 38.23874 -85.75877 21029424 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/21029424  
1616451074:21029652 38.26863 -85.6746 21029652 12 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/21029652  
1616451074:21029658 38.28151 -84.55087 21029658 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/21029658  
1616451074:21025444 38.29758 -85.54696 21025444 4 0 Working to determine cause   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/21025444  
1616451074:21025443 38.2976 -85.54686 21025443 4 0 Working to determine cause   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/21025443  

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);