most_recent_snapshot (view)

11 rows

View and edit SQL

Suggested facets: cause, comments

id latitude longitude outage estCustAffected cluster cause crewCurrentStatus comments outage_url currentEtor
1579284061:20006454 37.32557 -84.9298 20006454 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/20006454  
1579284061:20006412 36.60457 -83.73152 20006412 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/20006412  
1579284061:20003574 37.15642 -83.75399 20003574 4 0 Trees or limbs in lines   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/20003574  
1579284061:20005149 36.96877 -84.07556 20005149 4 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/20005149  
1579284061:20006453 37.96191 -83.79772 20006453 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/20006453  
1579284061:20006414 37.93093 -86.055 20006414 4 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/20006414  
1579284061:20006452 38.19259 -85.78195 20006452 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/20006452  
1579284061:20006456 38.13671 -85.86945 20006456 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/20006456  
1579284061:20006455 38.19157 -85.64988 20006455 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/20006455  
1579284061:20006427 38.24824 -85.7751 20006427 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/20006427  
1579284061:20006382 38.25652 -85.62873 20006382 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/20006382  

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);
Powered by Datasette · Query took 346.442ms